PC Review


Reply
Thread Tools Rate Thread

Access 2002 refrence errors

 
 
=?Utf-8?B?Q2hyaXN0aW5l?=
Guest
Posts: n/a
 
      16th Jun 2005
I have converted a 97 access database into a 2002 version. I have the
following references selected: Visual Basic for
Applications, Microsoft Access 10.0 Object library, OLE Automation and
Microsoft DAO 3.6 Object library.
Here are some of my compile issues:
If gintURSure = True Then
DBMainInit
Set qd = dbmain.OpenQueryDef("QUOT_qD_DelQuote")
qd.Parameters("pQuoteID") = Me![txtQuoteID]
qd.Execute
End If
"dnmain. being the referenced error"
And then also auto keys defined:
DoCmd.GoToControl Me![comp_id].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![DATE_SUBMITTED].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![DATE_RECEIVED].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![DATE_ACTION].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![DATE_FFP_RECD].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![DATE_FPP_EFF].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![STATUS].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![date_paid/recd].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![LINE_OF_BUSINESS].name
fn_Autokeys ("^'")
DoCmd.GoToControl Me![COMMENTS].name
fn_Autokeys ("^'")
"fn_Autokeys referenced error"
Any suggestions?

 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      17th Jun 2005
dbmain is not the name of any build in object that I recognise.

Try adding these lines to the top of the procedure:
Dim dbMain as DAO.Database
Set dbMain = CurrentDb()

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Christine" <(E-Mail Removed)> wrote in message
news:5B32A4FC-198D-48C4-8A0D-(E-Mail Removed)...
>I have converted a 97 access database into a 2002 version. I have the
> following references selected: Visual Basic for
> Applications, Microsoft Access 10.0 Object library, OLE Automation and
> Microsoft DAO 3.6 Object library.
> Here are some of my compile issues:
> If gintURSure = True Then
> DBMainInit
> Set qd = dbmain.OpenQueryDef("QUOT_qD_DelQuote")
> qd.Parameters("pQuoteID") = Me![txtQuoteID]
> qd.Execute
> End If
> "dnmain. being the referenced error"
> And then also auto keys defined:
> DoCmd.GoToControl Me![comp_id].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![DATE_SUBMITTED].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![DATE_RECEIVED].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![DATE_ACTION].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![DATE_FFP_RECD].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![DATE_FPP_EFF].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![STATUS].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![date_paid/recd].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![LINE_OF_BUSINESS].name
> fn_Autokeys ("^'")
> DoCmd.GoToControl Me![COMMENTS].name
> fn_Autokeys ("^'")
> "fn_Autokeys referenced error"
> Any suggestions?
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting errors in Access 2002 SP3 and restart program Syphonics via AccessMonster.com Microsoft Access Forms 1 22nd Oct 2007 05:13 AM
Errors on Vista with Access 2002/2007 Installed Vic Spainhower Microsoft Access 3 7th Apr 2007 06:14 PM
Automation Errors in Access 2002 paxdominus Microsoft Access 1 19th Jul 2006 05:33 PM
DAO Errors after converting from Access 97 to 2002 Dave Microsoft Access VBA Modules 2 26th May 2004 05:25 AM
Re: Access 2000 / 2002 errors - urgent Later Microsoft Access Forms 0 11th Jul 2003 11:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:18 PM.