Problem running Access Wizards from VB code

I have just finished writing an Access 2000 based database, a portion of this database enables users to seamlessly access the Report and Query wizards (inbuilt) by calling the query using the following line of code -

Application.Run "acwztool.frui_entry", "tablename", acQuery
Application.Run "acwztool.frui_entry", "tablename", acReport

This works fine the database is run using Access 2000, however when the database is run on Access XP the following error occurs:

The form 'frui_frmMain' is misspelled or refers to a form that does'nt exist.

Can someone please let me know what the differences in the procedure call argument, or a suitable workaround so I can resolve this problem without having to resort to writing my own wizards.

Thanks in advance.

Nathan
yeahbaby692001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dottheiCommented:
0
shanesuebsahakarnCommented:
Actually - there's an error on the mvps site(!!!). In Access XP, the form frui_frmMain is in acwzmain, not acwztool. Try:
Application.Run "acwzmain.frui_entry", "tablename", acQuery
Application.Run "acwzmain.frui_entry", "tablename", acReport
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dottheiCommented:
Shane - Thanks for the heads up!
should someone tell "Dev Ashish"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

shanesuebsahakarnCommented:
Dotthei, I've notified them. Dev sometimes posts to the Access newsgroup (he was there a couple of months ago after a long absence) but the people who maintain the site definitely post there so I will post a message if I don't hear back soon.

BTW did you get my e-mail ?
0
dottheiCommented:
I worship the ground from which Dev codes from
0
yeahbaby692001Author Commented:
Thanks for the help.  I actually fixed the problem a few hours after posting this question by manually opening both the 'awzmain' and 'awztool' addin files and found that awzmain was the only one with the frui_frmMain form in it.

So I gave it a shot by changing the names (same as you suggested) and tada...it worked.

Thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.