Search results

Advice To All Access Users As a related piece of advice to all Access users. Change the default number type from INTEGER to either SINGLE or DOUBLE. This will prevent data loss on make table queries. It will also cure the above problem with imports. An INTEGER will alway chop off everything...

You can tell if records have been modified or added by using the "Dirty" property in the code. You can use the condition: if me.dirty then............

When you use the command button wizard, select "misc" and then "run query". If your query is not in the list, then it is not saved as a query. Maybe it was saved as an SQL? If all else fails, re-created the query. If it is a multiuser db with security, you might want to set the "run...