been awhile since I've posted but I need some advice on a new problem thats been brought to my attention.
We're running MS Access 2003, and what I'm faced with is the following problem.
We have our service techs always out on the road with laptops, and when they're there they create Service Reports and they have our customers sign off on a signature capture device. Now what this does is it gives us a hard copy of the report on their computer with the signature of our customer to show they've signed off on the work we have done. Thats fine and dandy when they're out on the road cause it stores the signature on their laptop locally(C:\My Documents\Signature.bmp).
This is where our problem comes in.
When they come back to our main office and update the server here locally with the new report for our sales and other departments to review they cannot. The reason being is, because they do not currently have signatures tied into their computers locally.
I'm wondering is there a better way of doing this like maybe moving the pictures from the laptop locally to one of our servers? or am I S.O.L on this issue.
If ya need more info let me know and if ya can help thanks in advance!!
What I am doing at the moment is creating a receipt for the customer to sign off on based on the form built in the database. The field engineer would get the customer to sign the receipt (using a ticket printer), and then send that copy in to the office to add to the file. He also clicks "submit," and the report is emailed to the dispatcher in snp format.
As to how to solve your problem, if you created a record of the source in the database, you could create a routine/query/module approach to:
1. copy the data into your tables
2. query the new data for the file locations on the laptop
3. for each instance found, copy it to the new location
4. update the location in your master database.
Similarly, I have a question about how you are copying the data over. Is it using a synchronization using replicaiton ID's, and if so, how are you dealing with things like work orders? Autonumber is a problem because you have multiple units in the field.
Thats the entire signature from our customer. Now when it's shown in the form it's an ActiveX Control.
And the way we're updating the records is by doing an update query from the local copy on our service tech's laptop to our server version of the same database. No synchronization is being used here..as we can't have that happen incase of changes here in the office before they return.
well I am(in a sense) just don't know perl or macros all that well I more so need it to show the data the signature creates on the form more then anything but I would use the ability to move the pictures over as well