Missing reference? 4

[ZOR]

A user gets this error

Function is not available in query expressions 'Val(Right([Barcode],9))'.

Is there a missing reference somewhere. Thanks

 

[MajP]

test the function in the immediate window and see if it works.
?Val(Right("12345",4))

If it does not return 2345 then it could be the reference to vba.

 

[ZOR]

Many thanks. Problem is I don't have the program, its with a user, and its an mde version. The mdb version works at my end no problem. User has just aquired a new pc, xp, access 2003, and programs working before are falling over.

 

[MajP]

Do not know what to say, but I have seen where string functions stop working and I had to remove the vba reference and then readd it back in.

 

[ZOR]

Thanks again. Looks like I will have to go to the user with an mdb version and debug what I can there. Regards

 

[boblarson]

For making sure all references are refreshed, so the MDE will work, you can use this:

http://www.access-programmers.co.uk/forums/showpost.php?p=658969&postcount=4

Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[ZOR]

Thanks Bob, if it says whats on the box then that could really be a winner. Thanks very much, have s good weekend.

 

[ZOR]

Does the code have to be fired from an autoexec macro, as I tried calling the function from a button on a form after removing one of my references. It gave me the message -
"This application has detected newer versions etc " but seemed to finish quickly, but my reference was not put back? Thanks

 

[boblarson]

Yes, it has to fire on the autoexec macro because that is the only thing that fires BEFORE the references are checked by Access.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[ZOR]

Thanks Bob. Regards

 

[ZOR]

I put both the function and the sub into amodule. I created a macro, calling it autoexec. In the macro I used runcode, and in the function put Checkrefs, however it halts saying it cannot find the name? Whats missing in my brian, thanks

 

[boblarson]

Change the first part to this:

Public Function CheckRefs()


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[ZOR]

Hi Bob, no, it still reports it cannot find the name Checkrefs. I double checked all spelling. My macro is within the macros section of the database. Regards

 

[ZOR]

My db works fine, I only tried it in mine to check it out, adding the function and sub seemed relatively simple in a new module, and the macro again seemed straight forward. I have removed it all and guess I will have to visit the user to manually check references/debug. But thanks again for your help.

 

[Ed2020]

Bob,

That looks like a very handy piece of code - have a star!

Just one (possible silly) question: the code references a qryTestRefs - what is this?

Ed Metcalfe.

Please do not feed the trolls.....

 

[boblarson]

Oh yeah - the original code is actually from here:

http://support.microsoft.com/kb/194374

And it was a test query that was built to test if there was a broken reference. I totally forgot all about that part and also had forgotten where that actually had come from. Sorry for the mixup.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[Ed2020]

Thanks Bob, much appreciated.

Ed Metcalfe.

Please do not feed the trolls.....

 

[ZOR]

Thanks Ed/Bob, I'll have another go.

 

[Ed2020]

No need to thank me. I haven't offered any assistance with this one.

Ed Metcalfe.

Please do not feed the trolls.....

 

[ZOR]

Thanks ED, you did do your bit. Thanks Bob, I found where I goofed it, I put Checkrefs in the macro function name instead of Checkrefs(). All works well, thanks again.