Search results

I have almost the same setup as you. Migrated the Back end to SQL Server, and use a front end with linked tables. 150 users. We use DSN-Less connections, and it is always blazing fast. So, you could always give that a shot. If you do decide to try it, your connection has to be inside an IF...

Hi, you should be able to do this in 2 queries. Query 1: Create a field for each CPT code you want to check for duplicates. Example CPT code 36555 Use this code for the field: (Assuming CPT Code is your field name) 36555: IIf([CPT Code]="36555",1,0) This will generate a 1 for any record...

Can you post your Union Query code?

Create new Database with VBA that is already set to "Tabbed Documents" view. Hi! Does anyone know of a way to create a new Database with VBA that is already set to "Tabbed Documents" view. OR is there a way to use VBA to set the view of another database to "Tabbed Documents" view. Here's...