I have added two command buttons on my form. The first button searches for a persons last name and the 2nd button searches for the SS# and displays the appropriate record on the form. The problem is that sometimes this works and other times it doesn't. I have checked the underlying table and...
I have added two command buttons on my form. The first button searches for a persons last name and the 2nd button searches for the SS# and displays the appropriate record on the form. The problem is that sometimes this works and other times it doesn't. I have checked the underlying table and...
Okay, here I am again. I have one large table (1900 records). I want to have an input box appear to capture a social security number. Then I want to locate and display the appropriate record on a page (not a form). Finally, I want to copy the displayed record (just a couple of fields) to...
The pictures are being taken with a digital camera and are being saved to the database. Unfortunately the program that I'm using to capture the picture (ID Works) doesn't show an option to change the way the picture is saved (jpg, meta or bitmap). I'll check into this further, though.
Thanks
No, I'm not trying to display the form in datasheet view. However, if I switch to datasheet view, I see long binary in the field.
The pictures were taken with a digital camera and used in another program to generate IDs. It doesn't give me an option to change or set the file format.
Database has a field called photo where student/employee pictures are saved per record. I want to view these pictures on a form. All of the other info from that record appears, but not the picture.
The photo field data type is OLE. Any suggestions?
I'm trying to write an If-Then-Else statement using a DoCmd.Find Record statement.
If the record is found, I want to have it appear on the screen (which it does currently). If the record is not found I want to display a message box.
I can get the message box to display, but it displays all...
Kathryn,
I'm verifying usage of a recreation center by authorized personnel. Their info (full name, ss#, id card #, photo, etc.) is in the main table and when they come to the front desk I want to have their record appear when their ss# is scanned and then if they're in the table, have their...
I have a table with 1800 records. I want to search for a specific record via a form and then have that record copied to another table (table 2).
Every evening I want to run a report that prints out table 2 and then erases all of the data in it.
Any help is greatly appreciated!
New to access...I have a large database containing employee name, ssn, address, phone number and photo. I have created a form which allows you to run a query on the ssn field and search the 1st database for the matching record. I want to then have this record copied to another table. I can get...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.