Copy a web form to normal form?

[Tooom]

Hi, If their is a pre-existing topic on this please point me to it as I could not find anything. I have built a database using Access 2010 using the 'web' format for the forms, reports and tables.

This has been fine so far as I have been using macros for my clickonevents.

However I now need some functionality not available in the web forms macro expression builder. Namely Openquery, (it is not on the available list). I therefore want to copy my forms formatting and properties to a normal non-web form allowing me to enter vba code.

Is there no way of doing this though - will I have to redesign the form again from scratch?

I have attached a screenshot of the form in question if it helps. Thanks

 

[Tooom]

Anybody? =(

 

[Tooom]

I found a way, here it is for anyone that might end up in my position and get stuck on this for 24hours.....

You can individually change a web object and save out a copy of the object as a client object.
- To do this, highlight a web query for example in the Navigation Pane. Click File tab, then Save & Publish area on the left, then Save Object As in the middle of this pane, and finally click the Save As Client Object button on the right side. You'll be prompted to give a name for the client object. Since it can't be the same name as the original at the moment, just use the same name and append the word Client at the end.
- You'll see a client copy of that web query in the Navigation Pane. To make sure the application still works, you'll need to delete that web query, and rename the client version to match the original name (remove the appended Client word from the name you gave it earlier.)