problems with split database

[jrlh]

I split my database and realized that I needed a new field
on my table/form. I am able to enter a new field into the
back end table, but it does not show up on my front end
table or in my front end form Field List. How do I add
this field to my form so that the data entered into the
form ends up in my back end table? Is it to late to add a
new field? Please help!

Thanks,

Jennifer

 

[Rick B]

If your front-end tables are linked to your backend, then any changes made
to the backend will be reflected on the front-end tables.

Your front-end linked tables are jsut a link to the backend. They just
point to an image of the tables on the backend.

Rick B


I split my database and realized that I needed a new field
on my table/form. I am able to enter a new field into the
back end table, but it does not show up on my front end
table or in my front end form Field List. How do I add
this field to my form so that the data entered into the
form ends up in my back end table? Is it to late to add a
new field? Please help!

Thanks,

Jennifer

 

[Tim Ferguson]

How do I add
this field to my form so that the data entered into the
form ends up in my back end table? Is it to late to add a
new field?

No, it's not too late: but you'll have to do it the normal manual way. In
Form Design, click the text box tool and then click-and-drag on an empty
bit of form; then set the properties, probably starting with the
ControlSource (this is the one that names the new field) and the Name
(could be the same, or ideally txtNewFieldName). I would guess that most
experienced Access developers build most of their forms by hand without
going near the Wizards. I only just discovered that none of my wizards are
functional anyway!

Access may be clever, but it's not telepathic; and it cannot guess which
forms will need new fields added automatically and which are fine left as
they are.

Hope that helps


Tim F

 

[jrhl]

Thanks, guys. I realized that I was modifying a copy of
the back end tables, not the actual tables! Doh! Now
that my head is unstuck, things are working much better!