Split Database Distribution Errors

[Konchetta via AccessMonster.com]

I have split my A2007 database with the BE on the server for which each user
has access but have run into some errors when distributing the FE to each
employee's workstation. The FE works well on my workstation. After I loaded
it to the first workstation, I went thru each command button, forms, reports
to make sure everything works but for some reason, I have the following
errors:

1. When opening a report that requires a date range to be entered: Enter
Parameter Value (Format) message pops up for this
=Format([Date 8823 Issued],"mmmm yyyy")...it works on my computer

2. It also says the following file is missing for my references: outlclx.dll
This file is on my computer in the Office folder but I notice they only have
a Office12 folder and the file is not located there. Is there another
reference for Office 12?

3. I have a Form to create labels and now on their workstations, I have the
error: Enter Parameter Value (Trim).

Could something in their Access 2007 be missing or wasn't loaded by the IT
department? Please HELP!!

Thanks

 

[Konchetta via AccessMonster.com]

I fixed the problem...copied that dll file to link in my references and
everything worked fine. Truly don't understand the dll file but would like to
know more of its function. Thanks Access Monster!!

I have split my A2007 database with the BE on the server for which each user
has access but have run into some errors when distributing the FE to each
employee's workstation. The FE works well on my workstation. After I loaded
it to the first workstation, I went thru each command button, forms, reports
to make sure everything works but for some reason, I have the following
errors:

1. When opening a report that requires a date range to be entered: Enter
Parameter Value (Format) message pops up for this
=Format([Date 8823 Issued],"mmmm yyyy")...it works on my computer

2. It also says the following file is missing for my references: outlclx.dll
This file is on my computer in the Office folder but I notice they only have
a Office12 folder and the file is not located there. Is there another
reference for Office 12?

3. I have a Form to create labels and now on their workstations, I have the
error: Enter Parameter Value (Trim).

Could something in their Access 2007 be missing or wasn't loaded by the IT
department? Please HELP!!

Thanks

 

[John W. Vinson]

2. It also says the following file is missing for my references: outlclx.dll
This file is on my computer in the Office folder but I notice they only have
a Office12 folder and the file is not located there. Is there another
reference for Office 12?

Try removing it from the References altogether - uncheck its checkbox. It may
be something that was added in development and may not be needed. If any
reference is MISSING, you'll have this kind of bug, even if outlclx.dll isn't
used at all.

My guess is that it's there for some sort of early-binding link between Access
and Outlook, and that if the user doesn't have the right version of Outlook
installed they'll get the error.