Switchboard problem

P

Peterst

I set up a switchboard and when i try to run it i get this message, no matter
what froms I have. Any help please
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True

End Sub
 
G

GBA

well it is unclear what is right or wrong....but do this for now to clear
this debug message: put a ' in front of the two lines of active code

so it looks like this:

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
' Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
' Me.FilterOn = True

End Sub

this will totally deactivate this - - - it may then reveal other behavior
that you don't want...but for now it will allow you to continue....
 
P

Peterst

Thanks for that. It worked. I had tried sucessfully to change True to False
and it worked. My next problem was when following the text book, and
checking all the coding on the Switchboard (Command arguments etc.) Although
3 forms open for editing , the Enter/Edit other Data command to go to
switchboard 2 highlights but does not work. detail below. grateful for help,
as you can see form the headings I am in public healthcare.
--

SwitchboardID ItemNumber ItemText Command Argument
1 0 Haematology Lines Management 0 Default
1 1 Add a patient 3 Patients
1 2 Insert a Line 3 Lines
1 3 Remove a Line 3 Removals
1 4 Enter/Edit Other Data 1 2
1 5 Close the Database 6
2 0 Enter/Edit Other Data 0
2 1 Enter/Edit Antibiotics 3 Antibiotics
2 2 Enter/Edit Organism Names 3 OrganismNames
2 3 Return to Main Switchboard 1 1

PeterinExeter


GBA said:
well it is unclear what is right or wrong....but do this for now to clear
this debug message: put a ' in front of the two lines of active code

so it looks like this:

Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
' Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
' Me.FilterOn = True

End Sub

this will totally deactivate this - - - it may then reveal other behavior
that you don't want...but for now it will allow you to continue....


Peterst said:
I set up a switchboard and when i try to run it i get this message, no matter
what froms I have. Any help please
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top