adding a checkbox to a split database form

[William Kossack]

I have a split database.

The forms are in one database and the data is in another with the forms
database containing tables and queries linked to the other database.

A previous developer added a check box to a form but did it is not bound
to the database. As a result people have been clicking the checkbox for
months but nothing has been entered into the database.

There is a field for the checkbox that seems to be defined correctly.
However, when editing the form when I try to list the fields for the
form it does not show the field so it can be bound.

What is the process for adding a control to a form in a split database
so that it works? The developer used minimal code in developing his
application so I'm not sure at this point if I want to use VB code to
get his application working.

 

[Chris]

If the form is based on the table itself (Form ->
Properties -> RecordSource), I think that setting the
ControlSource Property of the checkbox to that field
should do it.

If not, see if the RecordSource of the form is based on a
query and then add that checkbox field to that query.

Hope that helps. Cheers

Chris

 

[William Kossack]

when I try to add the new checkbox to the query ie tablename.fieldname
and run the query it pops up a window 'Enter Parameter value'

 

[tina]

hi william. if you're still having problems and nobody
else has helped you, i'll take a look at your db and try
to fix it if you want to send it to me. if so, do the
following:
1. make a copy of the frontend and the backend.
2. remove proprietary data from the backend, but put in a
couple "fake" records so i'll have something to work with.
3. compact each copy.
4. zip each copy separately, if necessary, to under 2 MB
each.
5. if both files add up to more than 2 MB, email each
separately.
i'll take a look and get back to you today or monday.

 

[William Kossack]

got it figured out

I had copied the database into a directory about 5 levels down from
root. I'm
wondering if access has a problem with long directory strings because
things
just did not work correctly.

However, I looked at the original copy of the database and say that it
was in
c:\database so I created a c:\database and copied the database and the
forms
database into that folder.

Then I went through the long process of re-linking all the tables
queries and
forms to the new location.

This time it worked and I was able to enter things into the form and
have them
appear in the database.

The real problem I think is this database consists of some 30 tables
with a real
rats nest of relationships.