rhenerlau

This code is to split a Microsoft Access database and re-connect it on launch so that you can use Access on a multi user network...After Splitting the database manually, place the following code in the form that launches when the database is launched...

This code uses field level validation to check for data in fields in an Access form, and instead of using message boxes (as the "Validation Rule" and "Validation Text" properties of a field (in the table design window) do, it turns the associated label and control (textbox/listbox/combobox) background color to …

Place the file with part one of the code on the server. This part of the code gets placed in a batch file (text file with the extension *.BAT) and placed on each client's machine. Again, you will need to change the paths used to the real paths on your …

The Len() function is all you really need

There is no built-in control to display access reports in Visual BASIC. However, there are several third-party components (some of which cost $$$) that can be used for this purpose. Hope this helps! Richard Henerlau

Access is not the best choice for this kind of application. Unless you are required to use access (part of a class assignment or something) you would be better off looking into either Oracle or Microsoft Structured Query Language (SQL) Server. Those applications are built for large scale databases, Access …

Check out the InStr() function for your "Find" request - do a search in the Help file to get the exact syntax. THere is also a built-in Replace() Function. Hope this helps! Richard

There is a way to create a thirty-day free trial (if that interests you). This hard codes the license key code into each copy of the application (you have to compile multiple times in order to give it to multiple users if you do not want them to share codes). …

Data-driven means that there is a database as a part of the program, often called the "back end", and residing on a server...the VB part of the program, which resides on the user's machine, along with the report [I]templates[/I], is often called the [I]front end[/I] or [I]Graphical User Interface (GUI)[/I]. …