Recent content by zorplex

Some users have reported that when they close down a particular Access application the Access database closes but the Access application stays open but minimises to the system tray. The only way to stop the Access application is to kill the application from Task manager. After a bit of testing...

Solution: Access 97 and XP file permissions Found a solution to the problem myself which I thought I'd post for the sake of completness. To enable charting, form and report wizards give the user's account write prmissions to the Microsoft Office folder (it seems to create temporary files here...

The problem occurs on a WinXP machine with Access 97. When Access is run as a Power User everything works fine but when it runs under a user account that is a standard "User" non of the wizards function properly. By changing some file permissions I can get the control, form and report wizards...

How to attach code Thanks. How do I attach code to a button?

I want to create a custom menu or toolbar which opens the print dialogue box when pressed. i.e it opens the dialogue that allows the user to select a particular printer, specify number of copies etc. All I have been able to do using the customise toolbar function (View > Toolbars > Customise)...

I have a form which needs to test whether another form is open and if not open it, otherwise sets its visibility to true and give it focus. I can open the form using the DoCmd.OpenForm command but how do I test whether it is open in the first place?

When I run a pass-through query in Access, if an ODBC error occurs after the full ODBC error message is displayed in a second message box that appears after the initial "ODBC Call failed". Is it possible to obtain this ODBC error message in VBA. The Err object only gives me "ODBC Call failed"...