Search results for query: *

Using the MS Graph object that comes with Access 2003, there is a chart object option to display or hide the data table with the graph. Does any one know how to obtain the same functionality from code?

Using the MS Graph object that comes with Access 2003, there is a chart object option to display or hide the data table with the graph. Does any one know how to obtain the same functionality from code?

Hi Geoff, I guess that I will have to use the standard work around. Thanks for the suggestions. Neil

Hi Geoff, This makes alot of sense, but I am not sure how to implement it. I have an Auto_Open procedure in a module which is the procedure that gets cancelled when opening the application with the shift key. I know that each sheet can have an Auto_Activate but I am not sure when it is fired...

Ok folks, we have hit a problem between MS Access and MS Excel. Using Excel 2002, I have not been able to find a property 'AllowByPassKey'. I have looked at the Wookbook, the sheet and of course the Application. If I missed something, please clue me in. Perhaps there is an API or Dll that...

Thanks Folks! I will check it out and let you know the result. Neil

Hi Garry, I turned application updating off on the very first line of my autoexec macro and turn it back on at the end of the autoexec process. But holding a shift key will allow the user to Totally skip the autoexec macro. I think that I need to find the code(s) to disable the shift keys as...

MS gave the knowledgeable a key to stop the autoexec code in both Excel and Access. Does anyone know a way to lock out this feature until the autoexec has finished processing?

Thank you. I don't need it now, but I was curious. When I have some extra time (ha!), I will try to find it. Thanks again for your help.

Well it worked great on 2002. Just for fun, I tried to run the same form on Access 2000. It turns out that it doesn't understand what a printer is. I am sure this is what you were referring to. I would be interested to see how to do this in the older versions. Thanks again.

Wow - I can't belive its that simple. I will give it a try and let you know. Thanks

Thank goodness. We are using Access 2002 and 2003.

I am sure that others have had the need for this functionality. I have an access application that needs to print to two different printers. Currently, the user selects the printer they want to print to via Windows. The user then has to remember to reset the default printer or the next print job...

Awesome! I tried it and it worked perfectly. And the really cool part is that I now have one more tool for the ever growing arsenal. Thank You Steve!

Hi Steve, This function will fit the bill. JFisher of tek-tips wrote a slick piece of code. However, you mentioned that you used command line parameters on a shortcut to load the function. Could you give me a simple example of how that is done? I rarely use command line parameters. Thanks Neil

Here is an interesting problem. I have a situation where I need to allow the user to connect an Access ADP to identical SQL Databases on different servers and I can not hard code the server path. Since any data stored in a table in the ADP is actually stored on the server, it can't be accessed...