Search results

WOW that works brilliant i dont know how to thank you. your a life saver thank you again. Many regards

Ok thank you

Hi Chris Thanks for your help so far, I have sent the database again this time I an older format so it should open ok. As you will be able to see I have changed the bookSeries in the main table it is now BookSeriesID as you suggested. I have also followed your advice with the query editor but...

Hi thank if you still have problems i will save it a a 2007 or 2003 tomorrow as i have to got to work now. Regards

Hi i have sent it again after a compact and repair, i am using access 2010 do you think that might be the problem if you dont have access 2010 regards

Hi guys I will try and post my database for you to have a look at. It is only a basic setup i have yet to set it up properly. If you look at he report titles by author you will see it is grouped by author then the book title. If you look just before the book title you can see a number this is...

Hi Stophern and vbaInet Thanks for the information i will try and post my database. i just need to tidy it up a little then i will post it and hope you can help or advise me. Thanks for the help

Hi Stopher Sorry i did not explain fully. Its not that i dont want a query i will possible end up with a query its not that i am against them its just i know it can be done without a query and i am pulling my hair out to fine out how to do it. I know it can be done because i am trying to...

Hi Stopher, Thanks for the tip and yes if i make a queary then base the report on the queary that works ok. But there is a way to do it without the queary i just dont knowhow to do it.

Hi Can someone please help me. I have created a database in access 2010 and I have made a data input form on the data input form I have a combo box getting data from another table, and I have set it to store the relevant data in my main table, I have also set the main table not to show the...

Thanks Vapid2323 for the link but i am still unable to work it out Ok I have created a table to store the names of people, who read audio books, then I have created a input form to add new books, on this input form I have created a combo box using the control wizard to select data from the...

Thanks for the infomation but i am still no wiser, is it possible to point me towards a video tutoril please

Hi guys can someone please help. how do i double click on a combo box to add data i have made a combo box to get data from another table and add it to my data input form. but if the data i want is not in the table linked to the combo box, i need to be able to double click the combo box to add...

Access 2010 database password removal Hi can someone please help me to remove a password i have set on my access 2010 database. I know the password but i am unable to find a way to remove it, i have done a search on the microsoft web site and i have got the following info. Remove a...

Ok thanks i will give that a try regards to you all

Hi Guys Can someone please help me with a problem with my reports in access 2007. I have designed a database that stores information on my book collection. There is a table to record the books and separate tables to record the Publisher and The topic of the book. On the main switchboard i have...

Hi Guys I recently asked for help with my access 2007 database and with the help of the advice given i was able to create a combo box that looks at a table i made, i can the select the data from this other table and it automatically enters into the form i am working on. One last question if i...

Hi Guys, Ok i have managed to make a table with the information i want to lookup, and i have made a combo box to look at this table and i can select what ever entry is in this table. This is a great step forward for me. The only problem i have is i have to enter any new data in the table before...

Thank you i will give utube a try Regards to you all

Hi guys thaks for the help. I still carn't get it to work i guess i must be missing something. Does anybody know of a video tutorial i could buy that way i might be able to follow what to do. I just dont seem to get it. Regards Edward