UnhideColumns in Access 97
Posted on 2004-04-20
Im developing a fairly simple database for work in access 2000. The main problem I have is that the users only have access 97 on their machines (don’t ask why it’s a complete farce), so I have to convert the database to 97.
My problem is as follows, I have a form which contains a subform displaying data from a query as a datasheet. The user selects search criteria on the main form and the sub form displays the results ect. I also have a few buttons which allows users to Freeze/Unfreeze columns and one button which allows the user to select which columns to display, using the Access 'Unhide Columns' dialog box using the following code:
Note this code works fantastic in Access 2000, but when its executed on a 97 machine after conversion I get the following error:
The command or action ‘UnhideColumns’ isn’t available now.
You may be in a read-only database or an unconverted database from an earlier version of .
The type of object the action applies to isn’t currently selected or isn’t in the active view.
Use only those commands and macro actions that are currently available for this database.
I know that the Unhide Columns dialog is available in 97; however, I’m not sure if I can access it programmatically like in 2000.
Any Ideas or will I have to create my own dialog?