Using WinXP / Access 2002 -
A client of ours uses a DB designed by another vendor to track patient information, which is gathered remotely on a paperless system and stored on a central server. We in turn use this information for patient billing and insurance filing. We access the DB offsite with MS-Access via ODBC.
One of the fields is a signature field, which stores a BMP of the signature in a directory on the server and path/filename of the BMP is stored in a DB field (which could be turned into a hyperlink). This signature isn't always obtained, but we must accurately know which patients signed and which didn't. The path field is null if nothing was obtained, which is easy enough to discern if something is there or not.
However, at times the employees gathering the information will place an "X" in the signature block, or write something like "Unable". To us it looks like a valid signature based on the path existing (not null), but in reality, it's worthless. To further complicate things, sometimes the BMP gets scrambled in transmission; in which case, again we don't have a valid signature.
As a result, we must manually look at each of these via a utility built to view all patient data, including the signature, but it is cumbersome and *slow*. We have to pull a couple hundred a day, so this gets very time consuming.
What I'm looking to do is generate an Access report, that shows the identifying information (account number/name/etc.) and shows the actual BMP picture based on the path. Then we can easily spot the ones that are invalid and mark them as so on our system. However, all of the information I've read toward doing this relates to the picture being locally stored on your hard drive and not on an external server, specifically:
How to display images from a folder in a form, a report, or a data access page
How to embed a bitmap object in a report at run time in Access 2002
However, these don't work when the files/links are not local.
Any ideas how I can build such a report? Thanks.