Append a database in a form. (New to Access 2007)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan55 - 22 Jul 2007 03:51 GMT

I have created a database and a form in Access 2007. I can view data in the
form, but I can't append. I have been manually entering info in the database.
Would like to use the form to enter info. Not exactly new to databases, I
used dBase in DOS for 10 years. Any assistance would be appreciated.

Reply to this Message

Allen Browne - 22 Jul 2007 08:20 GMT

In form design view, open the Properties sheet.

Looking at the properties of the Form (not of a text box), what is the
RecordSource property (on the Data tab of Properties sheet)?

You will be able to add records if the RecordSource is just one table, or a
query that uses just one table. If the query contains 2 tables, you may find
you can't append or can't edit, or that you can append to one of the tables
only (depending on indexes/relations between the tables.)

So, simplify the query. Perhaps use a subform to show the related data.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have created a database and a form in Access 2007. I can view data in the
> form, but I can't append. I have been manually entering info in the
> database.
> Would like to use the form to enter info. Not exactly new to databases, I
> used dBase in DOS for 10 years. Any assistance would be appreciated.

Reply to this Message