Problem with Reports and Forms

[OBarry]

I am having problems with my reports and forms that I created using Access 97. These reports and forms work fine on my PC at home that I created them on but when I try to use these reports and forms on my PC at work they don't. Wherever I use =Date I get #Name? instead of the date and wherever I use =Trim([First Name] & " " & [Last Name])I get #Error instead of the name. The only difference between the two PCs I'm using is that one has Windows 98 (home) and the other has Windows NT (work) and both have Access 97.

Thanks in advance for any help.

 

[smedvid]

Is Access the same on both PC's? Try a reinstall on the PC at work and choose custom install to make sure you install all the gizmos, like Calendar, etc...

htwh
Steve

 

[DougP]

I get similar problems and I have NT here at work too.
I use this instead of =Date
=format(now,"mm/dd/yy&quot

make sure the textbox where you are concatenating the names together is not the "First Name" field or the "Last Name" field.

Call it something like WholeName
So the "Name" would be Wholename and the "control source" would be =Trim([First Name] & " " & [Last Name])

try creating brand new text boxes for both items too. Sometimes they get corrupted or....


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[PaulF]

on the PC where you are experiencing the problems, open a code module in design view, click on Tools -> References and check for any Library that has Missing beside it. If you find one, then unclick it and reclick the checkbox. Sometimes dlls are not in the same locations, or Access loses the reference to them. Even if you don't find one with Missing beside it, you might click on a new reference, compile and close the module, reopen it, go back to the References, and unclick the same one, compile and close again. Sometimes this will help Access to re-establish any lost links.

PaulF

 

[OBarry]

Thanks for the help!! I will try these out.