Search results

Helo..how do i open that database so i can view all the tables/queries and stuff? Thanks Jon

OMG..I think u have just saved my life. Thank you..that has also helped alot

Another quick question..i am going to purchase microsoft office 2007 this afternoon and i was wondering whether it would effect the DB at all?

OK. fixed all them problems. so thank you. What i am looking for now it to create a switch board but i dont want any old switchboard i want one from an example access database i found on the microsoft site. i like the layout and the way it works. The only thing now is that i have no idea how to...

Thanks for your reply. I have now added the query to the "view/edit Customer Details" but i cant get it to display the relavant feilds. i want it to only show the data from the Customer who's data is being displayed. Do u know how.. i have added the file incase u want to take alook

do u think it would be easier to create a new form and embed the new form in the customer form? How is this done?

Thank you rainman. ive sorted that all out now. Now formy next step. One the Customers details page i want to create a tab which when clicked will display all the customers past and present rentals to date. I know that i need to create a query but am 100% on what to do. could you explain...

Ive got a few more minor problems which i cant seem to sort out wordered if u can take another look: 1. On the "Add New Supplier" Form. When i first open it there is data/information already on the input boxes..I am trying to get it so when i open the form "add new Supplier" the input boxes...

ok heres a screeny of what i am getting here

Yes that is the box which is appearing when i click on the combo box wizard but i only get two options. the third option isnt there when i try...Wierd

Yes that is the box which is appearing when i click on the combo box wizard but i only get two options. the third option isnt there when i try...Wierd

ok here it is..Its the View/edit Supplier detials in the forms section..I am also having another problem here..when i open the "add new supplier" form i want the input boxes to be blank ready for new data..but they are not blank they have records from the tables in there..do u know what i am...

Hell again, I have ran into the same problem again with the suppliers form..I am trying to put a combo box at the top..but again it just keeps saying "no valid fields were found" i have tried doing what you said you did but i cant find that option. when the combo bozx wizard appears it only...

Hello, Thank you very much for that much apprieated. ill let u know if i run into any more problems. lol Thanks again Jon

ok i have now attached the file to this message. thanks Jon

Thank you Rich, i tried it but still no luck i just keep getting the error message "No valid fields were found "customerDetails". Please select another source" it wont let me upload it for some reason. Its just not working for me..stops uploading alf way through. Thanks Jon

yess that is correct i am using the wizard to make the combo boxes. and i tried to select info from the query option and no luck. i have also tried the table option to see if that works but no. Thanks Jon. i can send u the file if u like..just email me @ whittlephones1@aol.com

yes just treid this and when i go to select from the new drop down list box..it i blank..for some reason it is not picking up any of my fields. Thanks Jon

Thanks rainman. i tried this just a minute ago but wheni go to select the table/query i want to use for the data it tells me that there is no valid fields in the table/query. but there is.. i dont understand..i tried doing it with all the tables and queriies i have but i keep getting the same...

Thanks for your reply. Ive done what u asked and it seems to be working now. i have created a good input form for adding new customers. What i need now is to creat a form were i can search for a customers records based on there customer ID so i need an input box were the customer ID is...