Why don't data show up?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a vendor software that captures the signature when one signs in on the
signature pad. In the events OnLoad and the OnCurrent, I have the code as
following:
SigXXX.SigString = InstructorSignature.Value

to show the signature everytime the user opens the form. SigXXX is the
vendor software's control that handles the signature and displays it on the
control. The textbox InstructorSignature bounds to a field in the table
already stores the value. However, when I open the form, the signature does
NOT show up even though it is bounded to a field that has value. It's driving
me nuts because this program is very simple and suppose to work! My question
is why the signature's value seems isn't bounded to the InstructorSignatrue
textbox control even it is there in the table. I use MS Access 2003 open the
database in Access 2000 file format.

I don't think the database is corrupted because I create a new one. So far,
the vendor can not help me to solve the problem.

Thank you in advance for your help.
tim
 
I'm not sure from your description which bit is failing; the Signature
display, the InstructorSignature textbox content, or both.

However, one technique might be to split the problem in the middle and see
which bit works. Find a known value for InstructorSignature (from the
underlying table) and temporarily change the OnLoad or OnCurrent procedure:

SigXXX.SigString = (your known value)

If the form then displays the signature for your inserted value, look at the
InstructorSignature text box and its binding to the table. If the form
still doesn't display a signature, talk to your vendor.

Robin
 
Hi Robin,
Thank you for your advice. That's the smart way to do. Yes, I know that the
value is there and it does show up and is stored in the table, so I suspect
the vendor's fault. However, maybe there are other reasons have caused the
problem as following:
1. I use too many forms just open and re-use that record that has the
signature over and over again so maybe this is the problem?
2. I have a query that if I use a table as a record source, then it won't
show up the signature. However, if I create a query that has multiple tables
as a record source. I just put these tables in the query with no
relationships at all (cross query) then it does show up the signature. I have
no clue why it behave like that.

Do you have any idea?
Thanks a lot for your help.
tim
 
Back
Top