Search results for query: *

Akar33, The easiest way to do this is to have the database open in exclusive mode. That way only one user can open the database at a time. To set your database to open in exclusive mode by default go to the Tools pull down and select Options. Pick the Advanced tab from the Options dialog box...

I am trying to export data from one password protected access database to another using an append query. I don't want to link the tables because the export is only for archive purposes. I can get the query to work fine when there is no password on teh external database, but I can't seem to...

I think your problem is with the combobox format. I assume you have your combo box set up to display two columns (SupplierID, Description) and it is bound to column 1. To have it still capture the value of column 1 (SupplierID)in your table but only dispay column 2 (Description) you need to...

You need to define the sort order in the report to get the report to sort the records the way you want.. In design view, click on the Sorting and Grouping button in teh tool bar to bringup the Sorting and Grouping dialog box. Select the Field you want to sort on and the order (acending or...