MS Access and functions

[fredElliotRules]

Hello,

I have developed a MS Access database which uses several functions such as DateDiff and inStr. When I use these function on my machine the database runs fines and the values are calculated.

However the database I have developed is not for my computer and when run on this one computer produce some errors (The date function is mentioned). I believe this is some sort of security issue stopping her running the functions.

Both computers run the same version of Access. Does anyone have any ideas.

 

[ColinEssex]

Check the references in the modules to see if any are missing (on the users PC)

Tools>>>>>>>References

Col

 

[fredElliotRules]

Hi,

You're right it does say Microsoft Office XP web components is missing. Do I need to download it, then it'll show there and I check it?

 

[The_Doc_Man]

1. Please don't post duplicates.

2. At worst, you would have to re-install Office from the original kit. There is an Office option to "adjust" the features installed with Office (as opposed to uninstalling, installing via overwrite, etc.). You should be able to select the component you named and install it without killing the rest of your system. At best, you could look at the name it thinks it wants and search for that name.

Usually, the desired module name is displayed below the list of module descriptions in the References dialog box. Even if the path is wrong, the name would be good.