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.OpenRecord set("USysSecuri ty")
'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 3055
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.goo gle.com... 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.OpenRecord set("USysSecuri ty") '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.c om.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********@sta ntonfamily.co.u k> 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.goo gle.com... 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.OpenRecord set("USysSecuri ty") '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 2000 apps into 2002 format?
Many thanks
Jason
|
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 enables you to convert a database to a format of an
earlier version of Access. I wanted to check for any unforeseen
problems so here is what I did:
I used Access 2002 to convert my Access 2000 application to the 2002
|
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
lead to a lot of use of the database and the adding of quite a lot
of new data (though I can't conceive of them adding more than than
10s of thousands of records, which won't change the current
performance profile at all).
If there is a SQL...
|
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 the 'expiry' date as a
merge field from the database, and this previously was shown as dd/mm/yy (UK
format). Now it persists in showing as mm/dd/yy. I've gone to the Windows
Control Panel and made sure that my Regional settings show UK format,...
|
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 Access 2002 in order to run it do you?
Thanks!
| |
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 "Some errors happened
during the conversion. No converted database was generated". This message is
not of great assistance to me in sorting out the error!!
I have not been able to find any helpful support on where to start looking
|
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 should be
switching to Office 2002 or maybe 2003
It would mean upgrading a lot of existing work, not to mention 3rd party tools that I have bought
over the years. I'll switch if there are any real benefits but if it is just marginally better I'll...
|
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 access 97 and the other one for microsoft
acess 2000/2002).
my problem is in a field with a hyperlink , which i selected in a
table. this hyperlink refer to microsoft word documents on our
intranet. i enter the hyperlink in a formular (right...
|
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 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |