Hi,
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 to break.
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.
Help!!?
-