Functions and import spec problems

  • Thread starter Thread starter JA
  • Start date Start date
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
 
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
Click to expand...
Click to expand...
 
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top