If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Store info for reports from switchboard
Hello, im running MS 2007 and I need help with my form 'frmSwitchboard'. On
my form I have buttons that open reports and some buttons require a selection from a combo box thats associated with that button. Now on the frmSwitchboard(s) button I am using; Me.Visible = False 'Hides the switchboard So I can use the information when the report opens and when I close the report I use; Forms![frmSwitchboard].Visible = True Which makes the frmSwitchboard visible again. My problem is if I open a report and choose to just close the DB all together I get the error; Run-time error '2450': cant find the form 'frmSwitchboard' refered to in a macro expression or Visual Basic code. But if I close the report then the DB everythings fine. Is there another way besides using the Me.Visible? If so can someone please explain how it could be acomplished or give me a sample or link to a sample. Thanks! -- Thanks, Chad |
#2
|
|||
|
|||
Store info for reports from switchboard
Assuming it's the line in the report's Close event procedure that's raising
the error trap and ignore the error in the code: Const FORMCLOSED = 2450 On Error Resume Next Forms![frmSwitchboard].Visible = True Select Case Err.Number Case 0 ' no error Case FORMCLOSED ' anticipated error, so ignore Case Else 'unknown error, so inform user MsgBox Err.Description, vbExclamation, "Error" End Select Ken Sheridan Stafford, England SoggyCashew wrote: Hello, im running MS 2007 and I need help with my form 'frmSwitchboard'. On my form I have buttons that open reports and some buttons require a selection from a combo box thats associated with that button. Now on the frmSwitchboard(s) button I am using; Me.Visible = False 'Hides the switchboard So I can use the information when the report opens and when I close the report I use; Forms![frmSwitchboard].Visible = True Which makes the frmSwitchboard visible again. My problem is if I open a report and choose to just close the DB all together I get the error; Run-time error '2450': cant find the form 'frmSwitchboard' refered to in a macro expression or Visual Basic code. But if I close the report then the DB everythings fine. Is there another way besides using the Me.Visible? If so can someone please explain how it could be acomplished or give me a sample or link to a sample. Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201006/1 |
#3
|
|||
|
|||
Store info for reports from switchboard
Alan G answered it with code below.... Worked great!
If CurrentProject.AllForms("frmSwitchboard").IsLoaded Then Forms![frmSwitchboard].Visible = True End If -- Thanks, Chad "SoggyCashew" wrote: Hello, im running MS 2007 and I need help with my form 'frmSwitchboard'. On my form I have buttons that open reports and some buttons require a selection from a combo box thats associated with that button. Now on the frmSwitchboard(s) button I am using; Me.Visible = False 'Hides the switchboard So I can use the information when the report opens and when I close the report I use; Forms![frmSwitchboard].Visible = True Which makes the frmSwitchboard visible again. My problem is if I open a report and choose to just close the DB all together I get the error; Run-time error '2450': cant find the form 'frmSwitchboard' refered to in a macro expression or Visual Basic code. But if I close the report then the DB everythings fine. Is there another way besides using the Me.Visible? If so can someone please explain how it could be acomplished or give me a sample or link to a sample. Thanks! -- Thanks, Chad |
Thread Tools | |
Display Modes | |
|
|