Search results

Have you manually or programmatically suppressed error messages or data warnings? I turn them off and on in code to avoid confusion for the users. Normally, an adp will let you know if it doesn't add data to the table. I have discovered that an adp can be very hard to work with and it can be...

Save Record I need a little more information before I can attempt to answer your question. Are you using an Access .adp or .mdb file? What type of recordsource do you have for this form (table, SQL statement, etc)? The SQL table itself WILL NOT allow duplicate key entries if there is indeed a...

Save record I have had this same problem numerous times. I am using several Access front ends for SQL Server database files. The last time I received the message was yesterday in response to programmatically assigning values to text boxes and row sources to combo boxes based upon opening a...

Tips Delays occur occasionally if the machine is slow to process the request. Some PCs are just faster than others, anyway. The most delay I have seen is about 5 seconds before Access opens and displays the file. Keep in mind I am only copying down the front end and not any of the tables...

Tips I have 4 multiuser databases which have anywhere from 2 to 10 users. Each is a front end for a SQL database. I use batch files to copy the original front end (stored on a network drive) down to the user's hard drive. I can make whatever changes I want to the front end and the next time the...

Thanks. That is what I realized when I posted the code. I had it right in another event but that event was not being called.

Found my problem when I posted the thread. Thanks, anyway.

Help! I have an unbound listbox on a form that has its rowsource set by code on form load, current, and activate events. It is populated with the contents of a directory on a network drive. The exact location is determined by the code below which determines the folder name by concatenating two...