Search results

Figures just after I 'clean' my old files. I had a sample MDB that had a table and a module that you can add to an exist mdb/accbd. Once added to your front-end. run the module to add all the linked tables to the LinkedTableList table (for lack of its real name). The table list held...

I need a way to determine if the SQL native client is installed on a workstation and what version so that the ODBC connect string can be adjusted to meet the workstations config. Does PC have SQL Server client? Yes -----> What Version -- | --- Connect using to Installed SQL Client No ------>...

This took a few days of playing but I finally got it working. You will need to use this code in a Print Button on your form. Change the strReportName to your report. Change the constant for the printer to your desired printer. ' Set Default Printer to the Windows Default Printer Set...

Anyone know of a way to validate an email address against the Exchange GAL? I have a need where only requests from "valid" emails can be processed. In this case a 'valid' email is one that is listed in the Exchange Server GAL. And yes this is VERY big. Requests for information come in from...

I have just inherited an Access application that no less than 3 other people have made major changes to and I am trying to clean it up and move the data over to a MS SQL backend. So far I have modified the column names to conform to standards (no column names like [Delete]) (Not joking)...

I have a "New Call" form that works just fine in the original Access Application but now that it has been converted to an ADP (Access Project) I cannot find a way to get the form to start on a new record. I have tried Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec 'Startnewcall_Click...