Search results

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...

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...

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...

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...

I am trying to create a system for scheduling instructors during the working day. We currently have a paper based system where we fill in boxes on a grid to represent half hour slots for each of up to about 7 instructors. I am looking for something that can be filled in on a computer screen...

I have a database with lots of names and addresses. For the first time I am trying to set up a mail merge to do a mail shot, my problem is that I can get the mail merge wizard to work fine with the underlying address table but if I create a query to do selective mailings then mail merge comes...

I have a form with lots of information on it and I need to add a couple of combo boxes to search for the next record to display on the form via different criteria (customer surname, or address or order no etc). My problem is that there isn't much room left on the screen to put the combo boxes...

I have built an application which uses a bar code reader to populate various boxes on a form - it's a simple retail app based on the Northwind. This works OK but to create the next record I have to get the user to click on a "next customer" button on the form. What I want to be able to do is...

I have a form with four subforms which display highest scores in four categories during a competition. At the moment I have to manually refresh the form to see the latest scores. How can I get this to happen automatically say every 2 minutes? Thanks Dennis

This should be easy but I can't see how to do it efficiently. I have a small application that books people in for a competition and creates a record for each. At most I get about 500 people registered in a day, I need to be able to highlight when anyone from a specific list of names (no more...

I have a simple database used for competition entries and scoring where I capture the entrants' details (and later their scores) in a single table. If an entrant returns to have another go I can either type in his details again or choose one of his earlier entries and issue a "duplicate"...

I have a table with one field set as a hyperlink. I have to generate the hyperlink according to what else is going on in the record, I do this by assembling a text string which I can write to a text field in the same record. I have no problem doing this but when I try to copy that string into...