|
| 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
October 21st, 2004, 01:35 PM
|
|||
|
|||
i got error 3001 when try to open switchboard
every time i try to open switchboard i got messege error 3001 and can not use
any wizard, is it any way to fixing it? thank you in advance 
|
|
#2
October 22nd, 2004, 03:45 PM
|
|||
|
|||
|
Could you please tell us what the error message is for
error 3001 and at what line in what procedure it occurs? Geof Wyght -----Original Message----- every time i try to open switchboard i got messege error 3001 and can not use any wizard, is it any way to fixing it? thank you in advance .
|
|
#3
October 23rd, 2004, 04:41 AM
|
|||
|
|||
|
Run-time error 3001
Invalid Argument and after debug, this is the result ' 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 the yellow mark is in the last comad.. thnak you "Geof Wyght" wrote: Could you please tell us what the error message is for error 3001 and at what line in what procedure it occurs? Geof Wyght -----Original Message----- every time i try to open switchboard i got messege error 3001 and can not use any wizard, is it any way to fixing it? thank you in advance .
|
|
#4
October 25th, 2004, 01:55 PM
|
|||
|
|||
|
Sorry for the delay. I believe that if you Dim your
recordset as a DAO.Recordset your problem will go away. You may have ADO and DAO objects in your database. If you do, be explicit about what type they a ADODB.Recordset etc... Good luck. Geof Wyght -----Original Message----- Run-time error 3001 Invalid Argument and after debug, this is the result ' 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 the yellow mark is in the last comad.. thnak you "Geof Wyght" wrote: Could you please tell us what the error message is for error 3001 and at what line in what procedure it occurs? Geof Wyght -----Original Message----- every time i try to open switchboard i got messege error 3001 and can not use any wizard, is it any way to fixing it? thank you in advance . .
|
|
#5
October 27th, 2004, 01:31 PM
|
|||
|
|||
|
thank you for helping me,
I chose to uninstall my windows XP sp2 to solve the problem, because before i install it i can use my access properly, when i use windows SP 2 i miss MSADO10.dll fromm my acces, because it change with MSADO18.dll and other MSADO...dll, but i can not find msado10.dll thank you "Geof Wyght" wrote: Sorry for the delay. I believe that if you Dim your recordset as a DAO.Recordset your problem will go away. You may have ADO and DAO objects in your database. If you do, be explicit about what type they a ADODB.Recordset etc... Good luck. Geof Wyght -----Original Message----- Run-time error 3001 Invalid Argument and after debug, this is the result ' 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 the yellow mark is in the last comad.. thnak you "Geof Wyght" wrote: Could you please tell us what the error message is for error 3001 and at what line in what procedure it occurs? Geof Wyght -----Original Message----- every time i try to open switchboard i got messege error 3001 and can not use any wizard, is it any way to fixing it? thank you in advance . .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Switchboards | Jenn Connors | New Users | 1 | October 30th, 2004 09:48 AM |
| Power Point Pack and Go | scott | Powerpoint | 17 | October 4th, 2004 05:57 AM |
| Icon shows open envelope in send folder. | Roger D. Thompson | General Discussion | 5 | August 11th, 2004 06:07 PM |
| Switchboard form views | Garry | New Users | 4 | July 14th, 2004 08:22 PM |
| datasheet forms open in form mode from the Switchboard | Paul James | Using Forms | 5 | July 13th, 2004 06:51 AM |
Linear Mode
