Date() Right() Missing !?

[ddelport]

One of the PC's in our LAN using my database wouldn't run the VB code that contains the above functions. We run Office 97 in a Win 98 environment... Which libraries contain these functions and where should I be looking for the problem. I compared the library references on my own pc with those on the the dysfunctional one but all appeared the same? Aren't these rather common/standard functions that should work as a rule?

 

[PHV]

No MISSING reference ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tcace]

Open the references on the lame PC and make sure they are all there. If they are, uncheck one, close, reopen the references and recheck it. This is called "resetting the references" and fixes an undocumented microsoft problem.

 

[Hap007]

Dear ddelport,

I have seen that same problem before and could never solve it completely. I had an access application that used the treeview, list view and image controls in access. I would copy the mdb to 50 PC's and 48 would have it work ok, but those last 2 pc's would always hickup. Eventually, I would need to go to the 2 offending PC's and create a new blank db and import everything or just replace the controls in question. In my problem, the Mid, Left and Date functions would fail because the reference to the other controls was causing the problem. I tried TCase's trick, but that did not seem to work for me if my memory serves me correctly. Ultimately, I thought it was because the version of Access was installed in a different directory on the 2 problem pc's inquestion. The only way I could solve my problem was to re-format the PC,s reinstall the operating system and then Access. Yet, on other PC's where access was installed to a directory other than the default, those PC's worked. Go figure..

So, I hope that Tcace's suggestion works, and I would love to hear your followup, but, with Windows 98 and Access 97, you just may have a problem with directories, dll versions and the system registery that will not go away.

Good Luck,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[Hap007]

Dear ddelport,

Here is another thought, and perhaps this sample would work for you.
This is very similar to another reference problem here at tek tips today.

You can set your references using VBA Code

That way, the runtime version will work.

Here is a sample from mvps.org that shows how to do this:

http://www.mvps.org/access/modules/mdl0022.htm

Good Luck,
Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[ddelport]

Thanks Ya ALL! I haven't tried out all the suggested option yet, but I couldn't find anything saying "missing" and checking/unchecking didn't work in my case. I then did as Hap007 suggested, I imported the frontend to the sick PC and that immediatly remedied the problem. Although I cannot find it completely acceptable in my heart because I know that this is only symptomatic relieve it gives good enough to keep me satisfied for now. Once I have tried the other options I'll keep you posted.

Regards,

Deon

 

[LittleSmudge]

I have experience similar problems and the FIX is to adjust the ORDER of the items in the Reference Library list.


There are some things that MUST come before other or the problems that you mention occur.



Make sure that you have your list order in this rogue machine in the same order as the other machines.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.