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...

Thanks for all your help. I was able to figure out how to associate the names with the sheet they reside on. If you copy the worksheet out of the original file and into a second excel file the named cell ranges only show in the name box when that specific worksheet is activated (in the second...

Thanks for the assistance. The named cells 211 thru 217 are visible to all sheets. The other 216 are only visible on the sheet that they were created on. It would be nice to be able to reproduce this affect for 211 to 217 because the spreadsheet will track all requests for the year 2004 on...

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...

Loomah, Thanks for the post, works great. Much appreciation. And yeah, like you said, what's up with "ply"?

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...

Poweruser99, I agree with Tony that you might be making things more complicated than required. However, if you want to accomplish a connection to your table and recordset through code, here is what you need to do: Dim dbs as dao.database Dim rst as dao.recordset set dbs=currentdb() set...

Dyarwood, Thanks for the info but all the appropriate file type extensions are associated with the proper application. Everything works great within Excel. The problem lies in sending the activeworksheet as the body of an email with a hyperlink in the email to the appropriate NAMED cell...

PHV (MIS), Thanks for the advice, however, I already have a BeforeClose Event setup and it has the Application.Quit command in it. What I am finding is that when the spreadsheet is open in Internet Explorer, once it has been modified and saved and the user is exiting, it does not seem to...

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...

You can use an image control to display the chart. You must first create the chart on a worksheet within the workbook and export the chart as a gif file. You will set the picture property of the image control to the exported gif file. Use the following web address for detailed information...

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...

James, Thanks for the advice. Was hoping to avoid this solution but it appears that I won't be able to. Thanks again...

Ben, Thanks for the help, got me headed in the right direction. I was able to take your advice and us it in a For...Next statement to cycle through my commandbar and submenu commands. Thanks again...

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...

Digsys, Have you thought about placing the following code in your 'On Open' Events procedure for your report... docmd.maximize 'Placed in the On Open Events procedure By doing the above it will fill your screen with the report. Should correct positioning problem. Also, place the following...

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...