Question VBA functions missing

[janz]

I face the following frustrating problem I made a small program using VBA in access to structure some internet information that I want people to look at and distributed it to differnt (80) people to play with. Now there are about 10 people that get constant error messages. stating that the left($,#) does not exsist. I did make a program with only the left function in it and that doesn't work on these pc's. I found out that also the instr function doesn't work and probably some others. Our IT department claims that they always used the same installation CD.
Can anybody point me please in the right direction or even tell me what the problem could be? I'm .

 

[neileg]

Sounds like a missing references problem. Search in here for that subject.

 

[namliam]

Sounds like a missing references problem. Search in here for that subject.

Confirming Neil's suggestion, adding... Are they using different versions of access?? Cause that could be a cause of this problem.

 

[janz]

I face the following frustrating problem I made a small program using VBA in access to structure some internet information that I want people to look at and distributed it to differnt (80) people to play with. Now there are about 10 people that get constant error messages. stating that the left($,#) does not exsist. I did make a program with only the left function in it and that doesn't work on these pc's. I found out that also the instr function doesn't work and probably some others. Our IT department claims that they always used the same installation CD.
Can anybody point me please in the right direction or even tell me what the problem could be? I'm .

Yes it is a missing reference issue. In the mean time I found out that it has to do with Outlook that is not installed on these pc's. As standard Email program we use Lotus Notes (Yes I feel bad about that as well) however in the past Outlook was installed on the pc's as well. Later they stopped putting outlook on the PC's at all and in these PC's is where the problem lays. We did put outlook on one of them and Suprise all works fine. We uninstalled outlook again and the problem came back. So somehow the left($,#) function and some others are not in the MS access instalation but in the Outlook installation???! Does any body has any idea if I can fix this without putting MS outlook on these PC's. Did any body ever make or hear of a patch for that? Would be very helpfull. PS. I can't find any thing on the internet about this issue.

 

[namliam]

No, it has nothing to do with the Left function or with outlook (directly).

The Access application has a "reference" that is supplied by Outlook, as soon as any reference is missing each and every even very basic functions like left, right, date, etc fail.

Try searching this forum for "missing reference" and follow it to remove the Outlook reference that is appearently not needed. That should resolve your issue.

 

[janz]

Thanks all yes it was a refernce question. I made an outlook and Lotus notes option to send the data back. I now found out that on the PC's where it did not work there was no form of outlook installes.
Thinking about it it was rather logical only the error message did put me on the wrong trail.

I solved it by adding an extra database where the lotus outlook refernence set is activated . It is called by the other db if somebody clicks the send by outlook option. In this way I can still use my MDE version. Since in the MDE versions it seems that I can't reset the references what is rather logical.
I left the send with outlook dB a mdb file so if needed that the refernce can be updated automatically.

Again thanks for your inputs.

 

[boblarson]

Actually, one way to fix it would be to use Late Binding instead of Early Binding and then use error handlers to notify users that they can't use this item if Outlook is not installed.

 

[janz]

Actually, one way to fix it would be to use Late Binding instead of Early Binding and then use error handlers to notify users that they can't use this item if Outlook is not installed.

Bob, does this also work in an mde file? and would you maybe have an example on hand. If not I will search the forum. Thanks for your help

 

[boblarson]

Bob, does this also work in an mde file? and would you maybe have an example on hand. If not I will search the forum. Thanks for your help

Yes, it works in an MDE file. I don't have an OUTLOOK example available, but my Excel version is on my website under Code Snippets. Basically you do something like:

Dim objOutlook As Object
Din olMailItem As Object

Set objOutlook = CreateObject("Outlook.Application")

Not sure what you would use for the olMailItem, etc. but there is code around. Plus if you use Late Binding like that you have to provide explicit values for the Outlook Constants. So, if you use any constants you need to declare those as variables(or constants) and set their values to the values they would be returning.

 

[janz]

Thanks Bob for your help. Did some reading up about it and I guess I understood it since the program is working fine now. Thanks again.