Search results for query: *

Is there a way, through VBA, to have a macro automatically check to see if the "Trust Access to Visual Basic Project" checkbox on the Security dialog box is checked, and if it is NOT checked, do so? This check box is located as follows...Tools pulldown menu, Macro, Security menu option, select...

I have an Excel spreadsheet with several worksheets (i.e. Startup, Survey Form, Survey Log 04, etc.). The purpose of the spreadsheet is to track survey requests by individuals. When the individual creates a new survey request, the information is automatically stored on the Survey Log 04...

I am looking for a way to disable the right-click popup menu that appears when you right-click over a worksheet tab. Specifically, I want to disable the DELETE command on the popup menu that appears when you right-click over the worksheet tab. I would prefer not to hide the tabs, just disable...

I have an app that I want to use an API call to close. I am looking for an example of the API call SENDMESSAGE using WM_DESTROY to close the app. I do not wish to use WM_CLOSE. I want the app to terminate upon initiation of this command. Any examples would be greatly appreciated. Thanks in...

To All, First, any help or advice would be deeply appreciated. Here is the scenario. I have constructed an Excel spreadsheet consisting of three worksheets. The first is a Startup page with navigation buttons and menu options for the user. The second page is the standard form the user is to...

During the process of adding new forms to my existing Access database, something has happened to the database file. While in VBA adding code for controls, etc., when I select the Debug pulldown menu and select Compile from the menu I receive the following error..."Error Accessing File...

I know that if you define an AUTOEXEC macro that it will automatically run each time the Access database is opened. Is there a way to define a macro or VBA function or subroutine that will automatically be executed if the user selects "X" close button in the upper right-hand corner of...

I have created a custom menu bar named TIMETRACKER that replaces the standard Access MENU BAR when my application is started. The custom menu bar has 10 available pulldown menus on it such as "File", "Edit", "View" and so forth. Under the "File" pulldown...