Search results

Sorry my terminology is confusing, there are three places where there is a computer to access and update the data hence the need for some sort of multiuser system. The seven instructors all work at the same physical location but take clients out individually, at the momnt we use a paper diary...

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

Nice idea I am trying to put the combo boxes onto a rectangle that comes up when a search key is hit. The whole lot will then disappear after the search, the problem now is that when you use one of the combo boxes and it tries to make itself invisible you get an error saying that you can't make...

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

Some of the data is historical and I have already used both now() and date() to store the date and tried storing as long date and short date etc. The fields look OK in the tables but the query can't see the ones that have been created by duplication. I was wondering if somehow the absolute...

After more research I think it is something to do with the copying of a date field when I duplicate the record. It looks as if the format of the date changes and the query can't then see it.

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

It doesn't matter when I run the query, I have even run it after closing down and restarting the MS Access system so I don't think that it's a case of flushing buffers etc. I can clearly see the records in the underlying table but when I apply my query they are not there. It's as if there is...

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

Thanks it now works fine. Dennis

Text to hyperlink No that didn't work either. I now get run time error 2220. .....can't open file '#http:.........etc......jpg#' It's as if it's trying to open the link rather than just store it.

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

Can someone help please? I am writing a small retail application where I use a barcode scanner. My problem is that most barcodes seem to be 13 digits long and I can't get MS Access 2003 to recognise a code of 11 digits or more in a combo box. I have a table with the codes as a field where I...