B
BillH
I have a big problem
Every time I open a DB with a switchboard I get ERROR 3001 Invalid argument
Even if I create a new empty DB, then a Switchboard with no assigned
buttons, I get "Run-Time ERROR 3001 Invalid argument" when I open the
Switchboard form.
Ever since I put SP3 on my office 2000
I gotta use Office 2000 to be compatible with the people I work for
All my old projects crash. Every one! I cant do anything.
I uninstalled and reinstalled O2K, but it did nothing.
I checked all my references and they are all valid.
I must have a bad DLL or something i figure, but I have a short time frame
and MS Office is letting me down.
I'm gonna loose my job over this.
So I try to work on my litlle laptop.
I got Win2K Professional and Access 9.0.2720
Plenty of ram (512 MB), Gigabytes of free space, P3 850 MHz
I talked them into using MS Office, now I am regretting it.
I pasted in the lines of code where Access crashes. The -> is the
highlighted line.
If anyone can help, PLEASE do.
I am clueless.
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set con = Application.CurrentProject.Connection
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
-> rs.Open stSql, con, 1 ' 1 = adOpenKeyset
Every time I open a DB with a switchboard I get ERROR 3001 Invalid argument
Even if I create a new empty DB, then a Switchboard with no assigned
buttons, I get "Run-Time ERROR 3001 Invalid argument" when I open the
Switchboard form.
Ever since I put SP3 on my office 2000
I gotta use Office 2000 to be compatible with the people I work for
All my old projects crash. Every one! I cant do anything.
I uninstalled and reinstalled O2K, but it did nothing.
I checked all my references and they are all valid.
I must have a bad DLL or something i figure, but I have a short time frame
and MS Office is letting me down.
I'm gonna loose my job over this.
So I try to work on my litlle laptop.
I got Win2K Professional and Access 9.0.2720
Plenty of ram (512 MB), Gigabytes of free space, P3 850 MHz
I talked them into using MS Office, now I am regretting it.
I pasted in the lines of code where Access crashes. The -> is the
highlighted line.
If anyone can help, PLEASE do.
I am clueless.
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set con = Application.CurrentProject.Connection
stSql = "SELECT * FROM [Switchboard Items]"
stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" &
Me![SwitchboardID]
stSql = stSql & " ORDER BY [ItemNumber];"
Set rs = CreateObject("ADODB.Recordset")
-> rs.Open stSql, con, 1 ' 1 = adOpenKeyset