Search results

  1. B

    Timed Msgbox Function: TMsgBox

    Below is documentation and code for a timed version of the MsgBox function for Microsoft Access. Copy the code and paste it into a new Module in your MDB project, then save the Module as mdlTMsgBox. TMsgBox Function Executes a timed version of the MsgBox function. It displays a message in a...
  2. B

    Access Tips: Cascading Lists for Access Forms

    Since there have been so many posts regarding cascading ComboBoxes on Forms lately, I thought the following link might prove useful: Access Tips: Cascading Lists for Access Forms
  3. B

    Code to upsize individual tables to SQL Server

    The following code will allow you to upsize a single table from a Microsoft Access Database to SQL Server. To upsize a local table in the current database (Trusted Connection on SQL Server 2000): UpsizeTable "MySql2000Server", "MySQL2000Db", "MyTable" To upsize a local table in the current...
  4. B

    ShellExecuteEx and PDF files

    For my company, I wrote an application that includes a function called FileExecute, which takes file path parameter lpFile, calls the open command with the ShellExecuteEx function and returns the Process handle: Ex: ?FileExecute("C:\MyFolder\MyFile.txt") ...opens up the file with the...
  5. B

    Chart/Graph control not functioning

    On a specific machine, when Microsoft Office Access 2003 attempts to run a report containing a chart/graph object, the following error occurs: Microsoft Office 2003 component ------------------------------- Microsoft Office 2003 component has encountered a problem and needs to close. We are...
Top Bottom