Recent content by rdmartin

You need to convert the application to an executable file type. This is option availible in deveoper's edition of Office, and if I am not mistaken also in the Enterprise version of Office. To do this goto file and select the option from the Menu.

I have a table that holds a matrix of reports depending on certain criteria. Each of these reports is a worksheet created in Excel and need to be printed. I have a routine that reads the table (Matrix) and then opens the correct form in a separate instances and then closes that instance. I...

Capture the CurrentUser in a string variable then update the record with that value. Dim UserName as String UserName = CurrentUser

I am looking for a way to programtically open a specific Excel Spreadsheet to print preview mode. Any Ideas?

Here is another method: SELECT MAX(Table1.intIDNum) + 1 AS NewNum FROM Table1;

I am attempting to open a database exclusively, the databases in question are setup to login into a user group. I have found a way to open the databases using the OpenDatabase Method and the CurrentDB Method. However, I have not been able to incorporate a sign in or login script.

I appreciate the information, but let me clarify some things on this situation. I am aware of Access Error Handeling. I need to open external Access Databases. I then run macros inside these databses to control code modules that delete table contents, and then re-populate the data tables...

I am trying to run various scripts and modules in external Access databases that will update tables with current information. I am running into errors due to the tables being opened by other scripts which have prevented my scripts from opening the tables exclusivly. I am looking for a way to...