Search results

give me an email address and I will send you a cut down copy of what I was working on.

It's easy, you save the captured image from Dorgem with a unique name into a local folder, my code below shows how to create a filename prefixed with "abc" plus the date and time (to make it unique). Then you store this filename in your Access record and show it on the form.

Do you have an email address for me to email a database to you? It's a stripped down version of a programme for competition entries. It doesn't work and only has a few records but it should show you the bits that you are interested in. I seem to recall that it was necessary to take a photo...

OK basically what you do is put a button on your form which runs a bit of code like this Private Sub Command323_Click() On Error GoTo Err_Command323_Click Shell ("C:\Program Files\dorgem-nightly[1]\Dorgem.exe /m /capnow") [FilePath] = "c:\capture\abc" & Format(Now(), "hhnnss") &...

I eventually solved the problem using a program called "dorgem" written by a guy from Holland. It's been a couple of years sine I set it up and it's not used any more but I was able to capture images of people and associate them with their data record in Access. Basically look up dorgem on...

I have a query fed by several related queries (each query is linked directly to a corresponding table so that I can delete and download the data in these tables with maketable queries). Nearly everything works. Two of the tables have memo fields. When I run the query one of those memo fields...

I want to update the records in a local Access table every few days by downloading from an ODBC database server connection. How can I write a query which will allow me to "merge" the local and remote tables? (99% of the data is unchanged). I have tried an append query which sort of works but...

Thanks for your response. I have followed the general strategy that you outlined but when I came to run the make_table queries Access objected on the grounds that it couldn't rewrite the tables without destroying the relationship structure. I guess I really need some sort of update query to...

Hello, I am working on an Access project where I have to connect to a MySQL database and download the tables using ODBC my problem is that every time I open a form it seems to kick off the process whereby it downloads the tables afresh (which takes ages) . How can I stop this happening and force...

I have just installed Access 2007 on a Vista PC. I don't seem to be able to get anything to happen when I right click the mouse on say, a query in the navigation panel to try to get it in design mode. Any suggestions? Thinking that this might be a bug I have tried to install the latest...

Is there any way that I can write a command line which will write a value in a text box which is visible on a form which is already open and on the screen? Ideally it should be able to run from the Windows "run" command line. My aim is for a webcam program to be able to send the filename of a...

I have an application which dumps jpg images in a folder on demand, they do not overwrite each other and can be created for example, with date and time stamps in their file names. I want to be able to pick up the name of the latest image and store a link to it in a access form so that it can be...

I have written an MS Access system for entering competitors at a competition and then displaying storing scores . The requirement now is to photograph every entrant with a web cam and store their image with their scores. So basically I want to be able to capture an image from a webcam on a form...

I am looking at developing a stock control program. There will be several items that need updating but how do I store a global total of how many items are in stock at any time? I will have records of what is coming in and out but ideally I would update some sort of global counter for each...

I have a table in which each record includes a field showing the time that an event started and then another field which stores "how long did it take", these two fields are both defined as a short Time. I then have a query that runs through the "how long did it take" fields to produce an...

Thanks for the advice and now I know where those reference errors are coming from. Cheers Dennis

I have been tasked with creating a system for booking instructors with clients. Customers will book in for a lesson which can be anything from 30 mins to three hours long in half hour chunks. There are up to seven instructors available and I need to be able book up to six months in advance and...

Although I have been using access for a year or two (self taught) I have only recently noticed that the form toolbox (the one with combo boxes and buttons etc on it) appears to have a library of procedure calls for calendars and all sorts of things sitting there waiting to be used. Is there a...

Just realised that the combo box behaviour is now quite what I thought. If you pick from the barcode drop down list it works but not if you type in the value - what does this imply?

I have built a retail app for a members' club based on the Northwind system where I use the invoice generator as a retail screen. The problem is that I am using a barcode scanner to scan in membership cards (works OK) and then on a sub form I scan in what they buy. Some of the products are...