=CStr([Recordset].[AbsolutePosition]+1) works, and doesn't work

B

barret bonden

This great little bit of code :
=CStr([Recordset].[AbsolutePosition]+1)

shows the record a form is on (when set as the data control source in a
textbox) . It works fine on my office machine and, of course, blows up
on a client's PC.
Help !
 
M

Marshall Barton

barret said:
This great little bit of code :
=CStr([Recordset].[AbsolutePosition]+1)

shows the record a form is on (when set as the data control source in a
textbox) . It works fine on my office machine and, of course, blows up
on a client's PC.

Try it without the CStr function. If that works, then your
client does not have all of your referenced libraries
installed to the same version and location that you do.
While you're checking the References, make sure you really
need every one that is checked.
 
B

barret bonden

Marshall:

Still not working. I took out the CStr function and also checked for
references. All refs are the same, Still blows up with a "?name" error.



Marshall Barton said:
barret said:
This great little bit of code :
=CStr([Recordset].[AbsolutePosition]+1)

shows the record a form is on (when set as the data control source in a
textbox) . It works fine on my office machine and, of course, blows up
on a client's PC.

Try it without the CStr function. If that works, then your
client does not have all of your referenced libraries
installed to the same version and location that you do.
While you're checking the References, make sure you really
need every one that is checked.
 
M

Marshall Barton

That expression is so simple that the only thing I can
imagine causing an error is if there is some kind of
referencing problem.

Note that just having the same references checked is not
sufficient. The user's system must have the same version of
the referenced library installed and registered. It also
must be in the same location (or a location in the default
search path).
--
Marsh
MVP [MS Access]


barret said:
Still not working. I took out the CStr function and also checked for
references. All refs are the same, Still blows up with a "?name" error.
barret said:
This great little bit of code :
=CStr([Recordset].[AbsolutePosition]+1)

shows the record a form is on (when set as the data control source in a
textbox) . It works fine on my office machine and, of course, blows up
on a client's PC.

Try it without the CStr function. If that works, then your
client does not have all of your referenced libraries
installed to the same version and location that you do.
While you're checking the References, make sure you really
need every one that is checked.
 

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