I'm developing a database application for a company. This company has employees that go to a work site and perform work for clients. They have the work forms on the PC through my access application. They are using tablet pcs with the pen and such. They want to be able to capture a customers signature and save it linked to that particular work order. Now I've come up with a solution in my head, but in not sure how to implement it:
Ms Paint would serve just perfectly as a place to capture the signature. I could save it as an image (jpg, bmp, whatever) and store the image address in the database linked to the related work order. The problem is I dont want them to open MS Paint, sign, save, and place the address. I want there to be a place on one of my forms that they can sign, and just click the 'Accept' button, and its all done. Is there a way to get such a "draw box" on an access form? If not, can anyone think of another way i might accomplish this?
thanks for your help.
-Pete
Ms Paint would serve just perfectly as a place to capture the signature. I could save it as an image (jpg, bmp, whatever) and store the image address in the database linked to the related work order. The problem is I dont want them to open MS Paint, sign, save, and place the address. I want there to be a place on one of my forms that they can sign, and just click the 'Accept' button, and its all done. Is there a way to get such a "draw box" on an access form? If not, can anyone think of another way i might accomplish this?
thanks for your help.
-Pete