?
Solved

Access 2000 says 'Setting Up Wizards' constantly after SendKeys action

Posted on 2004-03-25
1
Medium Priority
?
278 Views
Last Modified: 2007-12-19
Im using Access 2000, and something is causing it to say 'Setting Up Wizards' in the status bar. I noticed this was being triggered by a marco off a particular button, and when I went into it, stopping the macro at different points - it was the SendKeys function that was causing this to appear in the status bar.

I was just sending %u - which should cause focus to move to a control that I've set up Alt+U to do this for - and Alt+U works fine, but using the sendkeys function causes 'Setting Up Wizards' to appear in the status bar until I finally close access down. And when I close it down, it crashes and sends an error report. Incidentally, if when using Access I don't trigger this macro, Access closes down fine.

Well, it sounds like a bug in Access to me, just wondering if anyone knows anything about it and how to get rid of it without re-coding. I've got all the latest windows updates etc, and Im using Office Service Release1.

Thanks,
Matt.

0
Comment
Question by:MatthewP
1 Comment
 
LVL 36

Accepted Solution

by:
SidFishes earned 150 total points
ID: 10677551
sendkeys is a nightmare and should be avoided if possible...


have a look here for an alternative


http://www.mvps.org/access/api/api0046.htm
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month16 days, 16 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question