Functions and import spec problems

J

JA

I just transferred my stock updating database to a different computer, and
nothing works!

Both are using Access 2000. The db was originally on Win2000, and now it is
on WinME.

First, I can't use import specs through a macro. I have to go to File/Import
and use the specs from there. If I try it using the macro, everything goes
into the first field. Either way, the same spec is used.

Next, I have a query that updates 2 fields with today's date, using Date().
I'm now getting the error message that Date is an undefined function.

I also add the number value of several text fields, using Val([field1]) +
Val([field2])+etc. I'm getting the same error message that Val is an
undefined function.

All these things work on the Win2000 machine, but not on the WinME machine,
which doesn't make sense to me.

Thanks for any insights,

Jill
 
J

JA

Allen,

I have 4 libraries - VBA, Access, OLE Automation, and ADO 2.1. I have the
exact same libraries registered on both computers. Nothing seems to be
marked as missing, and I browsed to the files to make sure they were
actually there - they are.

I also compacted and repaired the database. It didn't help. What can I try
next?

Thanks, Jill


Allen Browne said:
First issue to sort out is your References.

Press Ctrl+G to open the immediate window.
Choose References from the Tools menu.
Sort out what is "MISSING".

More info on the references you need:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

JA said:
I just transferred my stock updating database to a different computer, and
nothing works!

Both are using Access 2000. The db was originally on Win2000, and now it is
on WinME.

First, I can't use import specs through a macro. I have to go to File/Import
and use the specs from there. If I try it using the macro, everything goes
into the first field. Either way, the same spec is used.

Next, I have a query that updates 2 fields with today's date, using Date().
I'm now getting the error message that Date is an undefined function.

I also add the number value of several text fields, using Val([field1]) +
Val([field2])+etc. I'm getting the same error message that Val is an
undefined function.

All these things work on the Win2000 machine, but not on the WinME machine,
which doesn't make sense to me.

Thanks for any insights,

Jill
 
A

Allen Browne

If it thinks that Date is an undefined function, you do have a references
problem.

You could deselect all libraries (except VBA and Access which can't be
deselected). Then close Access, and use regsvr32 to re-register them, and
then select them again in your VBA.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

JA said:
Allen,

I have 4 libraries - VBA, Access, OLE Automation, and ADO 2.1. I have the
exact same libraries registered on both computers. Nothing seems to be
marked as missing, and I browsed to the files to make sure they were
actually there - they are.

I also compacted and repaired the database. It didn't help. What can I try
next?

Thanks, Jill


Allen Browne said:
First issue to sort out is your References.

Press Ctrl+G to open the immediate window.
Choose References from the Tools menu.
Sort out what is "MISSING".

More info on the references you need:
http://allenbrowne.com/ser-38.html


it
is
Val([field1])
+
Val([field2])+etc. I'm getting the same error message that Val is an
undefined function.

All these things work on the Win2000 machine, but not on the WinME machine,
which doesn't make sense to me.

Thanks for any insights,

Jill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top