Search results

Thank you Cronk and jdraw for the reply. You are right Cronk I have now put the formula in the field and the result is exactly what I wanted. Thank you.

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

Hi Sean Thanks for all the help. What you demonstrated does work but as you said on enter it first appears you have entered the action column. This could be misleading for an operator who is not aware of this situation. I have decided to display the action column 2nd so that the Item value is...

Hi Sean. I have attached two very basic dbase's that explain my problem. In each one click on the combo box "Item".The one called forum 1 lets me put in the correct value which is "item" in the form. But the columns in the drop down box are not in the order I want people to view. I want the...

Thanks for the advice Sean. However it does not seem to work. Try doing it on the link database from John. First you have open the width of his first two columns which are set to (0). If you make them wider so you can read them (and the total width wider) you can read the first two columns of...

Hi John thanks for the reply. I have looked at your example and it is doing the same as my database. You have 0 in the width of your first two columns. If you make them wider so you can read them (and the total width wider) you can read the first two columns of your combo box when you click it...

Hi Sean thanks for the prompt reply. The form I am using is called "Accessories Required" which enters information in the Accessories Required table. I have a text box in the form which is a combo box looking up columns in a table called accessories. I then select from the combo box the item...

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

Thank You Redneckgeek I have only used Queries using the criteria box. Where do I put your code. Regards Keith

Thank you Khawar. I copied your Form and Query in to my Database and then altered my table name to Table1. I also added the Number column as you had in your table, and made my date column XDate. I get a result of 28 dates, some in FEB,March and April. The table runs from the 1-Feb-2008 to...

Thank you Mailman. Yes I do want to see 19 if 17 is missing. Regards Keith

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

Helo Bob thank you for your suggestion. I had thought of the firewall and every thing seems to be correct. The relevant boxes are ticked including File and printer sharing. Is there other areas of the firewall I should be checking.

Hi Dave Found security setting on IE7 but still do not understand quite what to alter as when we are networking we are not going through the internet. Keith

Hello Dave I will check tomorrow to see if we have IE7. Can internet settings effect access software or a network. If we do use IE7 can you suggest where and how I should alter the settings. Keith

HI Ken thanks for the response. Can you suggest where I might check the security. Keith

Hi Shadow thanks for the respose. Not sure what IE7 is. All the computors are using AVG anti virus. Keith

HI Dave thanks for the respose. All the computors are using AVG anti virus. 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...

Hi wazz thank you for your response. What you said does work but as we will be entering quite a bit of data quickly I wanted the subform to appear without having to press the + button every time. Also you then have to click the - button to close it . Is it possible to automate this feature.