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
|
|||
|
|||
Compiling problem after installing Office 2007 SP2
I have just installed Office 2007 SP2 and I now have problems in Access 2007.
1. My application will not now compile: I get the error message "Invalid procedure call or Argument", and the line of code which is highlighted is "Dim dbs as DAO.Database". This line was at the top of a code module as a global line. 2. I tried to rename a form and got the message: "The OLE server may not be registered. To register the OLE server reinstall it." What is going on? Yesterday this application (before SP2) worked fine. Any suggestions please? Or should I uninstall SP2? -- PeterJC |
#2
|
|||
|
|||
Compiling problem after installing Office 2007 SP2
If this is a global variable change it to this:
public dbs as dao.database Chris PeterJC wrote: 1. My application will not now compile: I get the error message "Invalid procedure call or Argument", and the line of code which is highlighted is "Dim dbs as DAO.Database". This line was at the top of a code module as a global line. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200905/1 |
#3
|
|||
|
|||
Compiling problem after installing Office 2007 SP2
PeterJC wrote:
I have just installed Office 2007 SP2 and I now have problems in Access 2007. 1. My application will not now compile: I get the error message "Invalid procedure call or Argument", and the line of code which is highlighted is "Dim dbs as DAO.Database". This line was at the top of a code module as a global line. See Bob Larson's Quick Tutorial, "How to Check for Missing References": http://www.btabdevelopment.com/main/...1/Default.aspx |
#4
|
|||
|
|||
Compiling problem after installing Office 2007 SP2
Thanks for your res ponse, Chris. I tried what y ou suggested, and it still
won't compile, I got the same message, with the same words highlighted. I tried putting the declaration in a code procedure, but got the same message and nothing was highlighted. -- PeterJC "Chris O'C via AccessMonster.com" wrote: If this is a global variable change it to this: public dbs as dao.database Chris PeterJC wrote: 1. My application will not now compile: I get the error message "Invalid procedure call or Argument", and the line of code which is highlighted is "Dim dbs as DAO.Database". This line was at the top of a code module as a global line. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200905/1 |
Thread Tools | |
Display Modes | |
|
|