Please excuse my ignorance in this area, being an amateur Access user.
I have an Access 2000 application which runs fine, however when I
convert it to Access 2002 and run it, it comes up with repeated error
messages, as for example in the code below when it reaches the line
rst.Edit
The message is:
Microsoft Visual Basic
Compile Error: Method or data member not found.
What is missing from my conversion?
The code is as follows:
Dim intdummy As Integer
intdummy = tblcheck()
Dim MyDb As Database
Dim rst As Recordset
Set MyDb = CurrentDb
Set rst = MyDb.OpenRecordset("USysSecurity")
'Check if there are any records in the table
If (rst.EOF And rst.BOF) Then
' There are no records in the file
' Create a record for next time
With rst
..AddNew
..Update
End With
Else
' there are records in the file
rst.Edit
etc... 5 3032
Don't know anything about Access2002, but I suspect you are missing a
reference to the Microsoft Office Library (In the VB window see
Tools->References)
HTH
Phil
"John Furphy" <jo********@a1.com.au> wrote in message
news:4c**************************@posting.google.c om... Please excuse my ignorance in this area, being an amateur Access user.
I have an Access 2000 application which runs fine, however when I convert it to Access 2002 and run it, it comes up with repeated error messages, as for example in the code below when it reaches the line
rst.Edit
The message is:
Microsoft Visual Basic Compile Error: Method or data member not found.
What is missing from my conversion?
The code is as follows:
Dim intdummy As Integer intdummy = tblcheck() Dim MyDb As Database Dim rst As Recordset Set MyDb = CurrentDb Set rst = MyDb.OpenRecordset("USysSecurity") 'Check if there are any records in the table If (rst.EOF And rst.BOF) Then ' There are no records in the file ' Create a record for next time With rst .AddNew .Update End With Else ' there are records in the file rst.Edit etc... jo********@a1.com.au (John Furphy) wrote: Please excuse my ignorance in this area, being an amateur Access user.
I have an Access 2000 application which runs fine, however when I convert it to Access 2002 and run it, it comes up with repeated error messages, as for example in the code below when it reaches the line
rst.Edit
The message is:
Microsoft Visual Basic Compile Error: Method or data member not found.
You are very likely missing the DAO reference from the A2002 version. Or it's lower
in the references priority than the ADO reference. Locate the Microsoft DAO 3.6
Object Library reference and place it above the Microsoft ActiveX Data Objects 2.5
Library.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
I guessing, but I believe that a missing reference or the order of the
References may be the problem. Try changing:
Dim rst As Recordset
to
Dim rst as DAO.Recordset
That should explicitly grab the appropriate references. If this does
not work, go to the "Tools - References" menu item in the VBA Window
and see if there are any missing references.
Let us know if anything works!
Jim
Phil,
I already had Visual Basic for Applications and the Microsoft Access
11.0 Object Library selected in the References.
I added in the Microsoft Office 11.0 Object Library, but the problem
still occurs.
I'm sure you are correct that I'm missing a reference, but which one?
John Furphy
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:<41*********************@mercury.nildram.net> ... Don't know anything about Access2002, but I suspect you are missing a reference to the Microsoft Office Library (In the VB window see Tools->References)
HTH
Phil "John Furphy" <jo********@a1.com.au> wrote in message news:4c**************************@posting.google.c om... Please excuse my ignorance in this area, being an amateur Access user.
I have an Access 2000 application which runs fine, however when I convert it to Access 2002 and run it, it comes up with repeated error messages, as for example in the code below when it reaches the line
rst.Edit
The message is:
Microsoft Visual Basic Compile Error: Method or data member not found.
What is missing from my conversion?
The code is as follows:
Dim intdummy As Integer intdummy = tblcheck() Dim MyDb As Database Dim rst As Recordset Set MyDb = CurrentDb Set rst = MyDb.OpenRecordset("USysSecurity") 'Check if there are any records in the table If (rst.EOF And rst.BOF) Then ' There are no records in the file ' Create a record for next time With rst .AddNew .Update End With Else ' there are records in the file rst.Edit etc...
Thanks, the problem is now fixed, and it was either missing
references, or references in the wrong order. For anyone with a smilar
problem, the following references work for me in the order listed:
Visual Basic for Applications
Microsoft Office 11.00 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.7 Library
Thanks.
John Furphy This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jason |
last post by:
Could someone highlight any known problems in converting an access 2000 to
access 2002 database....should I expect a painful transition or can I expect
a quick turnaround time to get my existing...
|
by: David |
last post by:
Hi,
I want to work with Access 2002.
I will need to be able to distribute my application to users that may
still have access 2000 on their computers. I know access 2002 has a
function that...
|
by: David W. Fenton |
last post by:
A client is panicking about their large Access application, which
has been running smoothly with 100s of thousands of records for
quite some time. They have a big project in the next year that will...
|
by: Ishbel Kargar |
last post by:
Since upgrading from old laptop (Windows 98) to new laptop (Windows XP), my
mail-merge letters are doing strange things with date formats. For
instance, my reminder letter for lapsed subs carries...
|
by: Scott |
last post by:
Hi,
If we want to compile an Access 2002 database and distribute it to
others, will the compiled software run on any PC, like Windows 98,
Windows 2000, etc.
Also, you don't have to have...
|
by: Maurice |
last post by:
Folks
once again I look forward to your invaluable assistance.
When converting an Access 2002 mdb back to Access 1997 using the Access 2002
inbuilt tools I receive the following error message...
|
by: Stickleback |
last post by:
Morning All
I have been developing and deploying with Office 2000 for about 3 years, mainly Access based
programs and although I have gotten used to it's quirks, I am starting to feel that I...
|
by: Badboy36 |
last post by:
Hello user from googlegroups,
i made a microsoft access database with front and backend. i created
the backend in microsoft access97. for the frontend i made two
versions (one for microsoft...
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |