Solved

Debug appears when Access Switchboard tries to open

Posted on 2007-03-26
10
391 Views
Last Modified: 2013-11-29
I am receivng debug error when my Switchboard attempts to open.  The system highlights this code when I open Debug...Me("Option" & intOption).Visible = False.  Can anyone tell me why this is happening and how to fix it?  I tried creating a new switchboard and it does the same thing obiviosly I have screwed something up :).
0
Comment
Question by:CudaGal
  • 5
  • 3
  • 2
10 Comments
 
LVL 9

Expert Comment

by:TheSloath
ID: 18796055
Should work fine, unless there isn't a control on the Form called Option1, Option2, ... depending on what the value of intOption is.

Email me an MDB with the form in it and I'll have a look:


email address deleted.
Please do not do that again.
Vee_Mod
Experts Exchange Moderator
0
 

Author Comment

by:CudaGal
ID: 18796106
I sent it to you.  The last time I tried to open it, it gave me a Runtime 2465.  Something about Control 4 missing.
0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18796285
Looks like the switchboard used to have 8 buttons on it, and now there are only 7: Number 4 has been removed.

This stops function FillOptions() working.

Has Command Button 4 been deleted accidentally, or does the code need to be changed to compensate for the removal?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:CudaGal
ID: 18796307
I deleted the button because I could not figure out how to fix the command.  My ignorance.
0
 
LVL 84
ID: 18796478
TheSloath: The use of private email exchanges to solve problems if prohibited as an abuse of the points system:  http://www.experts-exchange.com/help.jsp#hi99. You would also be strongly advised NOT to post your email address here at EE, it's constantly being crawled by harvestbots and your email address is probably already in several thousand spamlists ;). I've posted a question in Community Support to have them remove it for you.

CudaGal: Many EE users make use of www.EE-Stuff.com to upload small database files. Any EE user can use it (with their username and password), and you can always delete the file when the question is answered. Also, if you make the file publicly available all Experts have an equal chance at helping.
0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18796513
Oops - Sorry, and cheers for that LSM.
That's about the 3rd time I've done it as well. I'll try and find the community board to see if I can get the others removed.
0
 

Author Comment

by:CudaGal
ID: 18796629
Thanks for the information.  This is just the second time I used this service.  So is there anything that I need to do to remove anything else?  Interetingly enough, I opened The Sloath's email and it took my whole system down.  I wondered if I had really screwed then.

Now can someone tell me how to get the Control button issue fixed on my switchboard?
0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18796681
Either replace the command button you removed (and call it Option4), or slip an IF statement into the loop causing the problem, to stop it trying to use Option4:

For intOption = 2 To conNumButtons
    If intOption <> 4 Then    'Start of IF statement
        Me("Option" & intOption).Visible = False
        Me("Option" & intOption).Visible = False
        Me("OptionLabel" & intOption).Visible = False
    End IF    'End of IF statement
Next intOption
0
 
LVL 9

Accepted Solution

by:
TheSloath earned 500 total points
ID: 18796711
I'd just open the switchboard in design view, select one of the command buttons and it's label already there, copy and paste, then place the new button and label in the correct position, then name correctly: 'Option4' for the button and 'OptionLabel4' for the label.

There doesn't seem to be any reason to not have the 4th button there...
0
 
LVL 84
ID: 18798798
A link to support is at the very top of this webpage on the right side.

Good luck to both, and glad you got your troubles fixed CudaGal.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Documents and settings folder 30 79
Why can't I get rid of record selectors on my form? 9 30
Experience with VBA code that changes unexplicably? 8 25
Help in SQL 13 20
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

825 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