Is there anyway to have a digital signature in Access? Like there is when signing PDF Files. I had perfected a way to use password an signing but that wasnt good enough for the higher ups. Before they will even consider my idea they want to have digital signatures?
View RepliesI have an accdb built using Access 2013 that will run with in 2010 Runtime. I am about ready to distribute the application, and am starting to do some research.
When I attempt to package and sign the db using the feature in Access 2013 it asks for me to "Confirm Certificate".
Before I go buy one I want to 1) try to create on myself and 2) learn about some good places to buy them.
1) I created a "Self-Signed" certificate using IIS, but the certificate doesn't show up on the list of certs when I attempt to package and sign the accdb. Is there a way to use a "Self-Signed" certificate to package my accdb?
2) If purchasing a SSL is the only option. Where is the best place to buy a SSL that I can use to package and sign accdbs from Access 2013?
Hello,
I am trying to figure out how the digital signature cert works for an access application. I have completed my program, access db and access front end. This is going to be used on a network drive and multiple people will be using it. Right now I get that "This file may not be safe if it contains code that was intended to harm your computer" on all the computer that open the mde file. From what I am reading I need to get a digital signature for the file. Is this something I purchase and code into the file? Or do I have to get the cert and have the IT department install it on a server? Any explaination of the process would be great. Thanks.
Joe
Hi All, I have just recently purchases a signature pad, I have added it to my working program, via using the demo applicaiton which comes with it. However I am getting a mismatch type. On the form load this code is highlighted in debug mode: SigPlus1.SigString = Signature.Value. I think that the problem is that there is no value in the Signature it is Null. So I was wondering if there was anyone with any ideas that might help me. Thanks
View 3 Replies View Relatedadding digital signatures to a form or table? my dilemma is this:
we issue out badges to people based on their clearance. if someone has a Top Secret Clearance, they get a green badge. If they don't have a TS Clearance, then they get a Red Badge. When we issue out badges, we take their CAC from them to hold in place of the badge in case they never return the badge, and we have them sign out the badge # in a paper log. I wanna get rid of the paper log and replace it with something digital if possible.
What I'm wanting is an Access table that can hold their digital signature from their CAC. They insert their card into the CAC Reader, type in their pin and press enter, done. Access inserts their digital signature into to the table and locks the record so that editing of that particular record cannot be possible.
I have a question about sending secure emails by VBA code in MS-Access. I have a Access application within you also can also send emails by VBA code using outlook. Everything works fine, but now the recipient wants to receive the mails with a digital signature by S/MIME.
I got a digital certificate from the recipient as a pfx-file.
Is this possible in Access using outlook ?
I use MS-Access 2010 en Windows 7
Any way to incorporate an E-Signature box in an access form?
View 3 Replies View RelatedHas anyone had the experience using a digital notepad, such as this one, http://www.newegg.com/Product/Product.asp?Item=N82E16883101001, can this device allow an user to enter free text from handwriting to a field on a form in real time?
View 1 Replies View RelatedHere is a question I have been hammering away at for a while but have not come up with an answer yet.
I am trying to come up with a way to make a digital archive in addition to the access database that i have been working on. Right now I have records for customers and all of their reservations, as this is a travel agency. I would like to be able to save all emails, pdf receipts, and any other applicable files that may pertain to that customer and/or on one level lower, their reservation.
Yes, I have heard of the attachment option in Access 2007, but I am getting mixed feelings about using that to solve this problem. One reason is because I have heard that this can make a database absolutely huge very quickly. (One question I have about that is whether or not that large size ends up slowing down the database or not?) My other concern is that after creating everything I would really like to integrate the database into SQL Server and only use access as the front end for forms and reports. And SQL Server 2005 does not work with access's new handy attachment feature in 2007.
This must be a common need with various businesses, so maybe you all have a few ideas out there. I would love to hear them!!! I am open to anything that solves this problem. Thanks for taking the time to read this and help me out.
Dillon
Hi all,
I have heard alot about digital signature, however it is not quite what I am looking for in reguards to them, I would like to add a digital signature to my form, from a writing tablet. So I can write my signature and have it appear on the form when I would like and save it to the file and clear it out for the next person to write in the same spot on the form. If anyone could help that would be great. Thanks in advance
We have an Access 2003 application that creates a report. This report is currently being printed, signed and then tossed in a file cabinet. We are very interested in purchasing some kind of electronic signature device. I've been searching all the websites that have these devices but I'm not sure I can narrow down the best one. The report is printed when it's time to ship product which means there is a key field on the report. We can save the report as a Word document giving the file name the key field so that it is unique every time the report is previewed. We'd like to be able to either have the electronic signature open this document and add the signature or store the signature somehow with the same file name as the report (Word document). Does anyone know the best device to handle this situation?
Thanks!
Hi All, This isnt really a problem i have, but a general question.
I am developing a Medical Database using Access, one of the requirements that I would like included is the ability to incorporate Electronic Signatures on various Forms/Reports (ie Medical Records etc, this is required by Law for Legal reasons when substantiating a Law Suit against the Practice). Although we could carry on printing the Report for the Doctor to Sign, current legislation/Legal Law now accepts encrypted Electronic Signatures via a tablet or the like.
Has anyone incorporated this into Access, perhaps a lead to a website that has products designed for this would be useful.
To Date, i can only find products that integrate with C++ or Visual basic Applications.
I have an application where I have some users in the field with tablets and they deliver a package and the receiver will sign for it (like UPS or FedEx essentially). They sign my application and then the application saves the signature to a SQL Database in binary data. I'm using the Microsoft InkPicture ActiveX control to achieve this. After they sign, I have a line of code that equals:
Me.RecBySignature = Me.RecBySig.Ink.Save
This works fine and I can also recall the signature to the form when the form is re-opened.how to do is to put the signature on a report. Is there a way to "draw" the signature on the report? Or to print it to the screen?
I have an excel sheet having coloumns as under
Payee_Name Amount CHQ# Date
There are about 100 record in my excel sheet and the i have import report by linking from desktop for updating purpose. when i tried to print report its result came not as i desired.
These words i like to print on last page of report but the words like:
( Cheque writer Accounts officer Zonal accountant) print on each page.
How can i print these signatures at the end of last page.
I have created a form that allows the user to create an Outlook email message using a saved HTML template in VBA but the users default Outlook signature is added every time the message is sent.
how to remove the default signature from the message body?
I'm looking for a way, when entering form, to force a field to accept a value, rhs;jjc;cjs. then every record will automatically contain the accepted value time you go to a new record. That would only be for newly added record. It would stay this way tell exit forum and the next time is open. It starts the same way.
It's my way of finding out who entered each record.
I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.
Is there a way to only bring up the form, unless I obviously need to edit the date base.
I've done some research on Google and it seems I need to use:
SW_SHOWMINNOACTIVE
However I can not seem to find how I would use this or where?
and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?
is there a way to have both Access 2010 and 2003 exist peacefully on the same desktop. My company uses Office 2010, but my department has an Access 2003 application. As a result, I have to have A2003 on my desktop and use it quite frequently for this one application.
I have some small databases that I really want to move onto A2010 so we can take advantage of SharePoint functions, etc. Is there anytning I can do to be sure that the .mdb and .mde open in A2003 and the new .accdb opens in A2010, without getting errors and the Windows installer going through the Office installation process for the respective version? I've gone to the file locations and set the "Open with" setting to the respective version.
Alright I have two tables, one is a user table, the other is one that holds the users roles. A user can have multiple different roles (up to 9). If you do a regular join on the tables you will get one that shows all the user information repeated each time for the number of roles they have. What I would like to do is design a form or something where the user can specify which role (1-9) they are interested in and the system will display all the users with that role. So for example show me the users that only have role 1 and no other role. I did this manually for one role by the following
1) Joining the two tables.
2) Setting a count to see which users have more then 1 role.
3) Eliminate any users the had more then 1 role.
4) Specify which role I want to display.
So is their some type of front end I can create where the user can specify what role they want to filter for with and without the exclusive roles?
how to lock access DB Tables ,Queries, Report so other's can not import them to other access database (without encrypting my database with password ).I've noticed when forms have VBA codes it cant be imported if they locked by password(VBA) !
View 7 Replies View RelatedWhat steps do I need to take in order to convert a 2007 database into a 2010 database
View 4 Replies View RelatedI am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an excel copy of the results of the search, and repeat for each value in the table.
I am not asking for the code for the entire thing, just the code to access SAP similar to the way you open up other applications like internet explorer.
how send SMS to phone by using text from access form.
View 3 Replies View RelatedI have a database that works fine on access 2000. The problem is that when I open it in Access 2007 the switchboard does not display correctly and my command buttons do not work. Also, my field that autofill from a combo box do not fill in. I am assuming that access 2007 does not recognize the code for all of these. If this is the problem does anyone know of a reference that can be used to change the code to work.
Also, thought I would mention that I opened it in Windows Vista. I have read about problems with Vista. I have not tried opening the database on a computer running XP.
Just wanting to get working now in case my company changes over to Office 2007 in the future.
Thanks for any info.
creating a import form into access.File format is txt (tab delimited)
Ideally I need:
- a box to enter the file name
- a box to enter the path
- a import button to push
I have seem some comments saying you have to creat a transfer text.However I have no knowlegde of Coding, opening or closing statments..
Where I can get some better pictures for my access database. The standard ones are really not all that great. I am looking for a stock pile of pics that I can place in my files so that I can draw upon them whenever I am designing my database.
I just havent had much luck designing buttons in GIMP.