Search results

In Access 2010 I have a table called CUSTOMER which contains a field called PCODE. In PCODE are the full UK postcodes for my customers. I have created a Query and inserted the table CUSTOMER and pulled down the PCODE field. In the criteria I have inserted Left([PCODE],InStr([PCODE]," ")-1) which...

I am having a problem entering the 2nd column of a combo box.This is a lookup combo looking at a table called Accessories. The combo is looking up 4 columns in the table, the first column is called "Action" the 2nd column is called "Item". I click on the combo box in the form and decide on the...

I have a query where the first column contains dates. I wish to find consecutive dates stating with a date I choose. IE [date] + the following 5 consecutive dates. If are choose 16/5/08 I would like to see rows for 15,16,17,18,19/05/08 Is this possible if so what formula do I use. Thanks Keith

We have 11 computers on the network. One has an Access back end file. When we try to open this file via the network some of the computers can open it others get the follwing message. "Microsoft Access cannot open this File This file is located outside your intranet or on an untrusted site...

Can I show a Subform in datasheet view when master form is in datasheet view. It works ok whwn master form is in singlesheet. keith hawes

Is it possible to show a subform in datasheet view when the master form is in datasheet view. It works if Master form is in singlesheet view.

Query does not return all stock. In basic form the database has 3 tables. One is “stock” another is “stock in” and the third is “stock out”. I want to run a query using all three tables so that I can take stock out away from stock in. The problem is the column stock in (in the query result)...