I have a database that I converted to an .mde and I then distributed it using the 2003 Developers Extension Tools Packaging Wizard. So it is being accessed using a runtime version of Access 2003. On one of the reports, I am concatenating two fields, [LastName] and [FirstName], from the underlying query. When the end user tries to preview the report, #error# shows up where the concatenated field is. When I view it using a full version of Access, the field shows as it should. Can anyone give me some direction as to how to fix this problem? Thanks.
Field Errors in Report using a .mde file
- Thread starter spowers21
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 23:12
- Joined
- Jan 12, 2001
- Messages
- 32,040
The are probably missing a reference and for text like that it is likely the MSCOMCTL.ocx file causing the problem. I think for MDE files you have to refresh the references programmatically. There are some posts here on how to do it (look for "refresh references" in the search).
You might want to check to see which directory you have MSCOMCTL.ocx in on your computer and then search the other computer to see if it exists on that machine. If not, you could copy it over and use register it manually by the process described here:
http://word.mvps.org/FAQs/Customization/RegisterDLL.htm
You might want to check to see which directory you have MSCOMCTL.ocx in on your computer and then search the other computer to see if it exists on that machine. If not, you could copy it over and use register it manually by the process described here:
http://word.mvps.org/FAQs/Customization/RegisterDLL.htm
Thanks for your reply. One thing that I failed to mention, is that I am using the same concatentation on other reports in the .mde and they are working OK. I even think the end user told me the report was working fine and now all of sudden the error message appears. ???
Similar threads
