I have downloaded Allen Browne's function TableInfo() and am getting a
ByRef Type Mismatch error when I try to execute it.
I don't know if it is a reference problem or not, but my references
for Access 2000 are set at:
VB for Applications
MS Access 9.0 Object Library
OLE Automation
MS ActiveX DataObjects 2.5 Library
MS VB for Apps Extensibility 5.3
MS DAO 3.6 Object Library
I tried moving the MS DAO 3.6 Object Library above the Active X
Library, but that didn't make any difference.
Any ideas would be greatly appreciated! Thanks. 3 2300
"Photobug" <ne*****@knolog y.netwrote in message
<11************ **********@e65g 2000hsc.googleg roups.com>:
I have downloaded Allen Browne's function TableInfo() and am getting
a ByRef Type Mismatch error when I try to execute it.
I don't know if it is a reference problem or not, but my references
for Access 2000 are set at:
VB for Applications
MS Access 9.0 Object Library
OLE Automation
MS ActiveX DataObjects 2.5 Library
MS VB for Apps Extensibility 5.3
MS DAO 3.6 Object Library
I tried moving the MS DAO 3.6 Object Library above the Active X
Library, but that didn't make any difference.
Any ideas would be greatly appreciated! Thanks.
Perhaps if you cared to give a link to where you found the function,
and paste the code where you're using it, and state which line the
error occurs on.
--
Roy-Vidar
Presumably the link is: http://allenbrowne.com/func-06.html
Did it compile okay?
(Compile on Debug menu, in the code window.)
How did you call it?
In the Immediate Window (Ctrl+G), you use something like this:
? TableInfo("Tabl e1")
If a particular line is highlighted when you get the error, it would be
useful to know which line, and what the error number is and the error
message.
--
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.
"RoyVidar" <ro************ *@yahoo.nowrote in message
news:mn******** *************** @yahoo.no...
"Photobug" <ne*****@knolog y.netwrote in message
<11************ **********@e65g 2000hsc.googleg roups.com>:
>I have downloaded Allen Browne's function TableInfo() and am getting a ByRef Type Mismatch error when I try to execute it.
I don't know if it is a reference problem or not, but my references for Access 2000 are set at: VB for Applications MS Access 9.0 Object Library OLE Automation MS ActiveX DataObjects 2.5 Library MS VB for Apps Extensibility 5.3 MS DAO 3.6 Object Library
I tried moving the MS DAO 3.6 Object Library above the Active X Library, but that didn't make any difference.
Any ideas would be greatly appreciated! Thanks.
Perhaps if you cared to give a link to where you found the function,
and paste the code where you're using it, and state which line the
error occurs on.
--
Roy-Vidar
On Apr 5, 12:32 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
Presumably the link is: http://allenbrowne.com/func-06.html
Did it compile okay?
(Compile on Debug menu, in the code window.)
How did you call it?
In the Immediate Window (Ctrl+G), you use something like this:
? TableInfo("Tabl e1")
If a particular line is highlighted when you get the error, it would be
useful to know which line, and what the error number is and the error
message.
--
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.
"RoyVidar" <roy_vidarNOS.. .@yahoo.nowrote in message
news:mn******** *************** @yahoo.no...
"Photobug" <nej1...@knolog y.netwrote in message
<1175785436.594 046.192...@e65g 2000hsc.googleg roups.com>:
I have downloaded Allen Browne's function TableInfo() and am getting
a ByRef Type Mismatch error when I try to execute it.
I don't know if it is a reference problem or not, but my references
for Access 2000 are set at:
VB for Applications
MS Access 9.0 Object Library
OLE Automation
MS ActiveX DataObjects 2.5 Library
MS VB for Apps Extensibility 5.3
MS DAO 3.6 Object Library
I tried moving the MS DAO 3.6 Object Library above the Active X
Library, but that didn't make any difference.
Any ideas would be greatly appreciated! Thanks.
Perhaps if you cared to give a link to where you found the function,
and paste the code where you're using it, and state which line the
error occurs on.
--
Roy-Vidar- Hide quoted text -
- Show quoted text -
I'm sorry I didn't provide enough information in my initial request -
this is the first time that I have posted a request to a user group.
Normally I just search the groups to find an answer.
You were right about the link and the program did compile correctly.
The error message didn't give a number and no line was highlighted
when I received the error message - so that's why I couldn't find the
problem.
However - you answered my question inadvertantly anyway - and I feel
like a dope! As soon as I saw your answer I realized what I had done
- I simply forgot to put the table name in quotes when I was running
it in the Immediate window. I know better than that! It's the simple
things that trip me up sometimes! Sorry to bother you - but thanks so
much for the quick reply. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Chris Kennedy |
last post by:
I am having big problem manipulating XML in a dataset. I am reading in a
schema based on the following XML document. The minute I try to e.g. create
a new row I get 'Object reference not set to an instance of an object' error
<?xml version="1.0" encoding="utf-8"?>
<DocumentElement xmlns="http://tempuri.org/dseditted2.xsd">
<TableInfo>
<FieldName>column value</FieldName>
<ControlType>column value</ControlType>
<IsNull>column...
|
by: Steve |
last post by:
Hi
I have a site using an access 97 application deployed with the runtime
version of access 97 i.e no development environment
on their PC's.
A few days ago their hardware people were on site and "something" was
changed on the PC. The result of the change
is as follows :
|
by: Gox |
last post by:
Hi,
I got a problem with VBE6.DLL (VBA reference)
On my machine everything work well.(access 2k, vesion dll 6.0.84.35)
First machine NO PROBLEM (access 2003, vesion dll 6.4.99.72)
Second machine problem (access xp, vesion dll 6.4.99.69)
I used pivot query and function Format(, "mmm") for Column
Heading
This is error:
|
by: cmd |
last post by:
I have code in the OnExit event of a control on a subform. The code
works properly in this instance. If, however, I put the same code in
the OnExit event of a control on a Tab Control of a main form, the code
errors out at the 2nd line. The error number is 13 and the description
is "Type mismatch". Both controls are memo fields. I suspect that
"Screen.ActiveControl.Parent" is not referencing the form as intended.
Thanks for any help,...
|
by: Ecohouse |
last post by:
I have a main form with two subforms. The first subform has the child
link to the main form identity key.
subform1 - Master Field: SK
Child Field: TrainingMasterSK
The second subform has a master-child link to the first subform.
subform2 - Master Field: subTrainingModule.Form!TrainingModuleTopicSK
Child Field: TrainingModuleTopicSK
| |
by: Mary |
last post by:
I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:( & ", " &
), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
( & " " & ), only the first name
appears.
I sure would appreciate any help!
Mary
|
by: Richard Sherratt |
last post by:
I'm trying to stop users deleting an existing value in a field. If
they go to an existing record and hit delete, I want to give an error
message and reverse the change. The BeforeUpdate event is firing and
they get the error message. But when they click "OK", the change is
not undone. They can hit enter and go on to the next field with the
null not being undone. However, if they change to an illegal (not
null) value, the change is undone....
|
by: Gilberto |
last post by:
Hello,
I have a couple of forms using the code to FIND AS YOU TYPE from Allen Browne (http://allenbrowne.com/AppFindAsUType.html). It worked PERFECTLY until yesterday when i splitted the db into FE/BE. The tables link ok and everything works ok EXCEPT this function. When i open the form it gives me a underlining line (iReturn = ctl.Parent.PageIndex IN THE PARENTNUMBER function in BOLD) and indicating that iReturn=0. I am new with access and...
|
by: babamc4 |
last post by:
I have a main form (mainformlung) with 5 subforms (followupacute, followuplate, biochemresults, haemresults and pftresults). I have copied Allen Browne's Audit Trail code (thanks to Allen Browne) and this is working great, edit, insert etc is working bar when I try to delete a record in one of my subforms (I'm in test stage at the mo) I get a run time error 3022 'The changes you requested to the table where not successful because they would...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |