Search results

I see! but thanks this has done the trick i think, time to go home now so if i have any further problems ill be back on here tomorrow!! thanks for all your help regards Paul

Im afraid not, all the data came from excel sheets and we need this interactive database as it is being used throughout the office as a quick and easy way to find gasket information, its working fine, just how we want, its only this problem of when entering new records they are not being...

I would post it, however it is far too large, even when fully compressed! Basically there is a single table that holds all data regarding car head gasket sets, i then have a query that displays all the information onto a subform with cbo boxes to carry out a refined search of the records, the...

could you explain where the requery is supposed to be located please?

doesn't seem to be working, already have the requery in place, the data is entered into the table fine but still not showing up with the query?

Hello, I have created a form to enable data to be easily added to the database table, however does anybody know why the query that looks up the records from the table does not return the new entered records, only what was originally in the table? Thanks

Not to worry everyone found an easy way, simply set 'unique records' in the query properties to 'yes'!

Thanks for that, unfortunately it has gone right over my head!! can i simply add this code to my database in the vb code for the form produced from the query? Or is there another way of doing this? Sorry im not very clued up with applying the vb code solution.

Dear Experts, I have created a database with queries that is working fine, however there are many records that have the same information that can not be removed easily, is there a method anyone knows of that can filter the records produced from a query to remove duplicates? i.e. 'select...

Thanks guys i have actually managed to sort it now, it was an adressing issue, i have forgotten to put txt or cbo before the textbox names in their properties!! Another question though, quite funny one, i finished off the database by removing some of the Access menus at the startup, but now i...

Hi there people, i have created a query that searches through different fields within the database, and on its own works fine, enter some or no data and it will return what you have entered. The problem is i have created a form with text and combi boxes on that i can enter the query parameters...

thank you Brian, seems to have done the trick. superb!!

Sorry could you put that in a little more laymans terms please, im a bit new to this whole access thing!

Hello, i have a database that simply holds all the information on one table at the moment and what im trying to figure out is how to create a form that i can enter data onto that searches all the different fields at once, instead of one search for one thing and another for another. Some of the...