There are plenty of places on the web you can get beginner HowTo's on Access.
These tips are subtle ones that even experienced Access developers often don't know about.
For the best Access sites on the web, check out 'Microsoft Access Links' on the
Right click on the function or sub call in the code. Choose 'go to definition' from the menu !
If you select a set of controls on a form, and then cut and paste them to a different area on the form, for example
when moving them out of or into a parent control, all the event procedures associated with the controls are cleared.
You can go and reconnect the events one at a time, or
- switch to the form code window (ctrl-g)
- select everything (ctrl-a)
- cut (ctrl-x) and then paste (ctrl-v) all the form code
That's it ! All the events are now reconnected.
(from Stack Overflow
This is highly annoying problem with Jet/ACE. But try either:
- go to the query properties (click the background of the pane where the tables are displayed) and set 'Unique Records' to 'Yes'
- Option 1 is the equivalent of adding the somewhat strange looking DISTINCTROW keyword to the SELECT clause, eg:
UPDATE DISTINCTROW tblClient
INNER JOIN qryICMSClientCMFinite
ON tblClient.ClientID = qryICMSClientCMFinite.ClientID
SET tblClient.ClientCMType = "F";
This solves so many problems involving this error message that it is almost ridiculous.