Link to home
Start Free TrialLog in
Avatar of urjudo
urjudoFlag for United States of America

asked on

Add Signature in a report

Hi Experts,
I'm going to start working on to add a signature in a report, but I don't know where to start it and need some assistance. Here are some questions:
1). Is better to store the signature in the table (create a text field in the table) or store the signature in the same folder as the database?

2). If I store the signature in the table, on the signature field in the table, shall I just enter the path on that field?

3). when I scan the signature or if it comes from as an attachment in an email, shall I save it as bmp, gif or jpg (if I don't have options for png)


Thank you
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of urjudo

ASKER

@PatHartman,
Please be patience with me as I try to understand how is this works.
1). I store the .bmp files in a shared folder on the server  -  I got this.  
2). the actual file name in the employee's record -- No sure what do you mean.
3). The path is stored in a setup table  -- you mean enter the path on the field.  ( I have a tblInformation just for store such as Chief's name, annual fee etc, so that if there are reports that need to show Chief's name or annual fee then it will pull from that table, so if we have new chief to change of annual fee, then I just need to change in one place and will automatically change on all the reports. so I plan to create a field for the Signature).  
4). In the employee table, the Signature = EmpID.bmp  -- a little confuse this
5). the LogoPath -- is this the name of the field (the signature)?

I'm working on it but it seems the signature not showing, maybe something I did it wrong
is possible you have a sample db how it works?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of urjudo

ASKER

@John,
I will try your way later today but just FYI, my bmp size is 24,154kb (it's just a signature), it's kind of large, is going to affect to the program? also, do you know what is the name of the OLE Object in SQL when I add the field.  (for example, Text field in SQL is nvarchar.)
Your BMP must be resized....no matter what...choose IrfanView that has many option for decreasing color and resolution...
For SQL is not that simple...SQL has BLOB...which is a different...from Access -OLE Object.
I have a solution for this but is a bit more complex....i suppose some day to write an article ...but....if you want to give it a shot..this is the code that i posted on a similar question : https://www.experts-exchange.com/questions/28969405/Images-in-Access-2007.html?anchorAnswerId=41795603#a41795603
so I plan to create a field for the Signature
For the SignaturePath.  The file name for each signature is in the record of the person to whom the signature belongs.  I called them employees.  I have no idea what you call them.  

Each signature has a file name.  I have no idea how you would want to name the files.  I suggested using the EmployeeID but since you don't have employees but you have some other type of "people", you found that confusing.

Sam = 1234.Bmp
Mary = 22445.Bmp
etc.
Avatar of urjudo

ASKER

@PatHartman & John,
Thanks for the good suggestion.  I scan the signature as jpg coz the bmp to too large.  so I used PatHartment's method but for some reason the signature showed really tiny, is anyway I can enlarge it with make the image control cover the whole report or did I missing something?  because I only need to show the signature on the bottom of the report and above the Print Name so the space is limited.  below is my code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Dim LogoPath As String
    Dim ImgLogo As String
   
     Me.LogoPath = "H:\WordDocuments\Signature.jpg"
   
     If Me.LogoPath & "" = "" Then
     Else
        Me.ImgLogo.Picture = Me.LogoPath
     End If
End sub
Bmp is usually blue or black ink on white paper....so you can easily scan a signature as bmp and avoid hassle.
If the signature is directly written on an image file (Paint program and a pen) it could be small ...as 250Kb for 800x600 signature
Avatar of urjudo

ASKER

@John,
I tried to follow your suggestion open the bmp image but I can't even open my bmp to copy the signature to paste to the Paint program.  I think it's because when I scan and save, the size just too large to open.
Just download irfanview...Resize it to "human size" and paste it to Paint...i reckon a size of around 400x400 is more than enough
I don't have any trouble with .bmp.  Crop the scan if necessary using Paint.

I know a lot of people use freeware but I don't.  Nothing is actually free and you don't know what the "cost" of using the freeware actually is.  I'm not suggesting that this website is a problem but I just don't do it.
PS, I know you're trying to be nice but you didn't use both solutions.  Please don't feel that you have to award participation points to me if you didn't actually use my answer.  It is much more useful to the people who find this thread later if you accept the answer you actually used and then award bonus points to other answers that worked but that you didn't use.