Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

Troubleshooting Access Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
capricorny - 19 Mar 2008 16:51 GMT
I'm not sure what I did, but I've lost the ability to add new records to a
form in Access 2003.

I can go into a Table and add the record, but not directly through the form.
The form's source is a Query that is run from the aforementioned  Table.

Any ideas?
Albert D. Kallal - 19 Mar 2008 17:44 GMT
> I'm not sure what I did, but I've lost the ability to add new records to a
> form in Access 2003.
[quoted text clipped - 4 lines]
>
> Any ideas?

Well, can you see/edit existing records in the form, or does is ALWAYS go to
a new record?

If it always goes to a new records, then:
     You accident set the forms data enter property = yes...that what this
feature is supposed to do).

If you can see existing records, and can't add new ones, then:
       you likely set the forms allow additions = no

If you can see existing records, and can't edit them, then:
   Either your query is not a updateable query, or you set allows edits =
no.

What happens if you open up the query (the form is based on) , and try
editing data then? Can you add, can you edit? Does it display records?

     So, check the query the form based on...and see if it is editable, and
how it works....

the above is just a short list of things I would look at, but you not really
told us what you tried so far....

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.