• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

Debug appears when Access Switchboard tries to open

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
CudaGal
Asked:
CudaGal
  • 5
  • 3
  • 2
1 Solution
 
TheSloathCommented:
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
 
CudaGalAuthor Commented:
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
 
TheSloathCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
CudaGalAuthor Commented:
I deleted the button because I could not figure out how to fix the command.  My ignorance.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
TheSloathCommented:
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
 
CudaGalAuthor Commented:
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
 
TheSloathCommented:
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
 
TheSloathCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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