By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,244 Members | 1,972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,244 IT Pros & Developers. It's quick & easy.

Problem with Allen Browne's Function TableInfo()

P: n/a
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.

Apr 5 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Photobug" <ne*****@knology.netwrote in message
<11**********************@e65g2000hsc.googlegroups .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
Apr 5 '07 #2

P: n/a
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("Table1")

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*****@knology.netwrote in message
<11**********************@e65g2000hsc.googlegroups .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
Apr 5 '07 #3

P: n/a
On Apr 5, 12:32 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
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("Table1")

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...@knology.netwrote in message
<1175785436.594046.192...@e65g2000hsc.googlegroups .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.

Apr 5 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.