Search results

The demo works great. For some reason though when I use the same code on another form my sig.gif is unreadable. I found a way around it by saving a screengrab of the signed form instead of saving the signature itself. Thanks for the help. That demo is pretty cool btw.

Ok. I solved the path problem, cause i'm an idiot and left this in the code CurrentProject.Path & before my path. Solved that problem but when I open the saved gif I get a message saying "we can't show you this file right now. Try again"

Thank you for all the advice on this previously but now I need some more. I have been working with theDBguyCollectSignatureDemoV1.0 form theDBGUY, obviously, and I want to save the sig.gif as a file in another folder and keep them that way rather than have them in a table. I can't seem to figure...

Good point. Why bother. Seems simpler to just use an access form and a cheap tablet. Thanks guys

Has anyone had any luck connecting a signature pad to access without having to buy 3rd party software? Is it possible? I was helping to clean out an unused office here at work and found a Wacom STU-430V still in the box but with no software. Wondering if I could put it to use and get...

Thats the direction I'm heading. Thanks for the help all.

That's pretty much what I'm doing. The difference is when I was using a single search field I could change the listbox rowsource so that it, neatly IMHO, updated the list as they typed. if they typed Rikk it showed any records that had Rikk in any field and it updated as they typed the letters...

I really liked my dynamic lookup. Wish I could keep it but... Everytime I try to prevent someone from doing something wrong they find a better way. lol

I have it working somewhat. Unfortunately I could still get duplicates with different spellings but at least I think this will limit the number of duplicates I get.

I would like to use whatever info is entered. The requirements ar first and last name, gender, nationality, vehicle ID and a company name. It is possible to have the same name from different companies but unlikely to have all the same info. I want the person entering the data to at least have...

I need some advice. I have a database that tracks visitors to our company. I started with a search box that will look up any info entered from the records of previous visitors and show any record that has that info. You can also just enter a NEW visitor. The problem is the search field is...

Morning all, I've been asked to import some excel graphs to display on an access form. I haven't found a way to link to the actual graphs in the spreadsheet so I linked to it as a table. I am trying to recreate the graphs in access but what I want to know is if there is any way to...

A loop. I knew there was an easy solution I just wasn't thinking of. Thanks.

So I'm stuck with something that should probably be easy but I can't figure it out. I want to open a random picture named 1 to 50 once an hour. Easy enough, but I need to not use the same picture more than once in 24 hours. When I open the picture I update a record in the table of the last...

It's there. The fields was what I needed. Thanks gents.

INSERT INTO tempschedule SELECT TOP 9 FROM tbl_adjustedschedule WHERE ID>lngID ORDER BY ID I though if the fields where the same in the tables you didn't need to list fields?

It's almost there but I think I have something wrong. It fails. Heres what I've got. Variable = 90 - DCount("*", "tempschedule") Dim lngID As Long lngID = DMax("ID", "tempschedule") If Variable > 0 Then strSQL = "INSERT INTO tempschedule SELECT TOP " & Variable & " FROM...

Hello all, I'm curious about keeping a set number of records in a table. I have two tables. One with 40000 records and one with 90. The 90 are also in the 40000. I have a button on a form to delete records, selected in a listbox form the 90 record table. I'm curious if there is a way to...

That did it. Thanks.

So I have a list box and 6 buttons next to it. I'm trying to make the buttons visible or not based on whether there is something in the list in that row. My buttons are named REC1 thru REC6 and are tagged logistics but I can't get this code to work. Any ideas where I'm going wrong? x =...