I have a MS Access database application split into a front-end/back-end database. The functionality all works fine on my
computer but when my client tests it various pieces of functionality don't work. This is VERY frustrating and quite
difficult to troubleshoot as I'm not sure what it is that's different between the client's and my pc that is causing the code
Issue #1) The button on-click event: "DoCmd.OutputTo acOutputQuery, "Talent Data", acFormatXLSX, , True" works great on my
computer my when my client runs this screen from her laptop, all of the memo fields convert to something that looks like
chinese characters when it is exported to Excel.
Issue #2) I have a report that has a text box with a control source set to "IIf([l2p1] Is Null,"",[L2P1] & Chr(13) & Chr(10)
& [l2p1jobtitle])" which in essence lists a persons name, forces a new line and then displays their job title on the next
line of the text box. If that field is null, it won't display anything. This works Great in my version but of course, on my
client's computer, the text box displays as "#Name?".
I'm not positive that this is the same issue - but it sort of seems that there is a missing library or something on my
client's pc. I know that it is missing the DTS.dll (Microsoft DTS runtime 1.0) file... but when I take that reference out of
my copy of access, all of my functionality still works - so I don't think that's it.