Search results for query: *

Hi thanks for the links and response. Another explination of what i am trying to do is as follows i have c:\data\spreadsheet1.xls & c:\files\spreadsheet2.xls which i want to display Cells A1 - A3 which has cost values, i want these to be shown on a form within access. I also have...

Hi could somebody please advise if the below is possible. I have several excel spreadsheets with accounting information in and i would like to read part of this information into Access so that the user has a single source to read this information rather than having to open excel and access for...

I am trying to build a query in Access 2003 based upon a form that the users select's several checkbox's then displays the results in the query. For example if i have a table like Apples Pears Oranges Grapes N Y N Y Y N N N Y Y Y N When say...

Top Top Man..... i have now changed it to use a query as the record source rather than the table and it is all working spot on. Thanks so much for your help ********* Man

thanks again, if i add it as a subform on the form can i link the two so if i go from record to record they change e.g if form one has name Peter and form two has apples. then when i go to next record they both change like form one Bob and form two pears ? Thanks

Hi thanks again for your help, i have now got it returning the the results correctly for the different columns by using the the sql statment in my query but i have one last question. How do i add the query to the form so i can get the information to my text box ?

What i have in my table is like below. So what i want to do is for example run a query that checks HVAC, Haulage, Hydraulics and if any of the entries in the table have a value of YES then i want to display that this is "Valid" in a text box even though the other two have this as No. Or check...

Hi thanks for the response do i add this as an event for the texbox or do i add it as part of the control source. Thanks in advance

Hi wonder if somebody could help out on this problem i am having. I have several different columns that have yes/no values assigned to them. What i am wanting to do is if any records in one of the columns returns the value as yes then i want to change a text box to display "Data Found" or if...

Hi thanks for the response but this is not supported by IE 7

When i run updates some machines to IE 7 they encounter a problem that clicking on the link that opens a new window will only open a blank page and not the link. The only solution i appear to have to fix this is reinstalling of IE7. I have checked out the below link from microsoft with regards...

I am currently having a problem when trying to open PDF files through internet explorer. If for example i click the link of the pdf file it then starts downloading within internet explorer but then stops downloading half way through. Example file is 6.51 meg downloads 3.6 meg then stops, this...

What i am trying to do is select a number of projects from a table (hence the mutli select list box) and assign to a suppliers contact details. So when i open up my form with the contact details i can see what projects they have worked on. I can get the information pushed to the screen so i can...

Hi thanks for the response, i am quite happy to do what i need to so that i can get this to work. I am quite new to this so if you could give me a example of what i need to do i would be very thankful. Just have have not used these options yet in my limited time with Access. Thanks again

Hi i have been going round in circles and unable to find out how to assign a string which i have by clicking a command button to assign as a multi table in access 2003. I know if i had this in 2007 it would not be a problem, unfortunatly i don't have this. My main problem is assigning th string...