G
Guest
Hi,
I'm building my 1st access app.
It's going ok, but having a few stubborn problems I need your help with.
It's a c/s app (.adp) file with the data in sql server. I'm using
switchboard manager and it's failing with "..Object .. not set". Can someone
explain this and advise on what to do about it.
background.
-------------
I started with the sample contact manager which uses the switchboard manager.
I nearly completed tailoring the app to suit my needs, but had problems with
setting properties at too detailed and decided to start over.
For the 2nd build, I used "Access 2002 Enterprise Develop Handbook" as a
guide.
I used an Access Project (adp) instead of an MDB as the book recommended.
I was able to salvaged most of everything I wanted from the 1st version, but
in testing I found that the Switchboard didn't work. I moved the switchboard
items table into SQL server and everything works except for the "change
switchboard items".
When change switchboard items" is executed, I get an error dialog
Switchboard Manager
"Object variable or With Block not set"
In addition, it appears that the Switchboard manager is not available in
..adp projects. Under Tools|Database Utilities| switchboard manager is
grayed out, even in freshly generated sample apps.
attempted resolution
-----------------------
In researching this error I found suggestions to:
"WZMAIN80.sbm_Entry"
1. change WZMAIN80 to ACWZMAIN - already was
2. Ensure ACWZtool, and ACWZmain are in the reference list for the module
3. Ensure DAO 3.6 library is ahead of the ADO libraries.
I've checked all of these and I still have this problem.
There was also a discussion about SBM being written for DAO and not ADO. I
believe that in 2002 is was redone, since all the code it generated for me
was ADO.
In tracing the problem, the dialog comes up after calling
Application.Run "ACWZMAIN.sbm_Entry"
This is the pfrag.
' Customize the Switchboard.
Case conCmdCustomizeSwitchboard
' Handle the case where the Switchboard Manager
' is not installed (e.g. Minimal Install).
On Error Resume Next
Application.Run "ACWZMAIN.sbm_Entry"
If (Err <> 0) Then MsgBox "Command not available."
On Error GoTo 0
' Update the form.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.Caption = Nz(Me![ItemText], "")
FillOptions
Using the object browser I can't find a SBM_Entry in the ACWZMAIN library.
I'm not sure where to go next.
Any ideas?
Thanks in advance.
I'm building my 1st access app.
It's going ok, but having a few stubborn problems I need your help with.
It's a c/s app (.adp) file with the data in sql server. I'm using
switchboard manager and it's failing with "..Object .. not set". Can someone
explain this and advise on what to do about it.
background.
-------------
I started with the sample contact manager which uses the switchboard manager.
I nearly completed tailoring the app to suit my needs, but had problems with
setting properties at too detailed and decided to start over.
For the 2nd build, I used "Access 2002 Enterprise Develop Handbook" as a
guide.
I used an Access Project (adp) instead of an MDB as the book recommended.
I was able to salvaged most of everything I wanted from the 1st version, but
in testing I found that the Switchboard didn't work. I moved the switchboard
items table into SQL server and everything works except for the "change
switchboard items".
When change switchboard items" is executed, I get an error dialog
Switchboard Manager
"Object variable or With Block not set"
In addition, it appears that the Switchboard manager is not available in
..adp projects. Under Tools|Database Utilities| switchboard manager is
grayed out, even in freshly generated sample apps.
attempted resolution
-----------------------
In researching this error I found suggestions to:
"WZMAIN80.sbm_Entry"
1. change WZMAIN80 to ACWZMAIN - already was
2. Ensure ACWZtool, and ACWZmain are in the reference list for the module
3. Ensure DAO 3.6 library is ahead of the ADO libraries.
I've checked all of these and I still have this problem.
There was also a discussion about SBM being written for DAO and not ADO. I
believe that in 2002 is was redone, since all the code it generated for me
was ADO.
In tracing the problem, the dialog comes up after calling
Application.Run "ACWZMAIN.sbm_Entry"
This is the pfrag.
' Customize the Switchboard.
Case conCmdCustomizeSwitchboard
' Handle the case where the Switchboard Manager
' is not installed (e.g. Minimal Install).
On Error Resume Next
Application.Run "ACWZMAIN.sbm_Entry"
If (Err <> 0) Then MsgBox "Command not available."
On Error GoTo 0
' Update the form.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.Caption = Nz(Me![ItemText], "")
FillOptions
Using the object browser I can't find a SBM_Entry in the ACWZMAIN library.
I'm not sure where to go next.
Any ideas?
Thanks in advance.