Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 698
  • Last Modified:

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
0
yeahbaby692001
Asked:
yeahbaby692001
  • 3
  • 2
1 Solution
 
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
 
dottheiCommented:
Shane - Thanks for the heads up!
should someone tell "Dev Ashish"
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now