Problem with Allen Browne's Function TableInfo()

  • Thread starter Thread starter Photobug
  • Start date Start date
P

Photobug

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.
 
Photobug said:
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.
Click to expand...

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.
 
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.
 
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.






- Show quoted text -
Click to expand...

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.
 
Back
Top