Search results

Duh :rolleyes: I didn't have my sql syntax quite right, it is now working. Thanks for your reply quasimodo Think it was getting late in the day for me, brain not in gear... :D

How do i search a subform? I have a form that has a query as the record source. On this form is a subform. I can search the main form without any problems through the forms query. When i add the subform's table to the query row source seems to throw up parameter boxes. The relationship...

Thanks Rich, Works just fine. Matt

Is it possible to stop a query running if no results were found in the search. I have a form with a query behind it which i use to filter data from a search form. If the query returns no data on to the search results form then instead of showing a blank form can it either display a message or...

Ok, This is what you need to do: Open up your query in design view and place the following around your criteria in the selected column: Like '*' & [Your criteria] & '*' This will allow either a null entry where all data is returned or restricted data by entered criteria. Matt

Sorry, I have actually mis read your post. What i was thinking of is adding all to your combo box and not actually the report. Matt

Hi, If you have a look at the Solutions example database there is an example and step by step guide on how to do this. Matt

Just been quietly getting on with my little task here and have managed to sort of do what i am looking for by creating a search results form using the following sql: SELECT tblInventory.[ASSET ID], tblInventory.[SERIAL NO HIDDEN], tblInventory.[QTY SUFFIX], tblInventory.DESCRIPTION...

Yes that would be fine, but would that be similar to the way i do it in the second option that i listed?

Hi Yes i have seen this thread. I did try it out and it works fine but.. instead of loading the listbox up with data can the search results be loaded into the main form, so, say after searching there are 20 records which match the criteraia and the user clicks through the 20 records via the...

From my experience with exporting data out of databases you only ever seem to get the raw table data and not the relationship information. i.e. i have exported an access db into a mySQL db, the relationship information in access is not exported out, basically i had to look at all of the indexes...

Yes i am wanting to return all records that meet a certain criteria. Basically what i want to do is to allow the user to search a complete table via say the main form by entering a search word into a text box on the main form. A little similar to the built in search that access has where the...

What is the best method as regards searching table data through a form? I have been looking at the archives on this subject and there seems to be different ways of doing this. In my db i do it by several different ways: 1.Using the built in search code 2.Create a query and base the form on...

Thanks for the info Doc_man, Will take a look at these. Just been playing around wiht Rich's suggestion using the Iif statement: =IIf(DateDiff("yyyy",[DATE WHEN PURCHASED],Now())>=[DepLife],[DepLife],DateDiff("yyyy",[DATE WHEN PURCHASED],Now())) I removed the static 8,8 and replaced with the...

Hi Doc_man, Thanks for the reply, I have tried the following two functions, DDB Function, SYD Function but they arn't quite what i am after, they only return a single value and not a yearly decllining figure. I presume that these are the functions you were refering to. Okay will have another...

Hi Rich , Sorry mate seemed to be struggling on this. I have attached a screen shot of the form that i am currently re-designing. I shows my depreciation workings out. I need to be able to get the Years elapsed and the Cur Dep Val to halt when they both reach zero.

Thanks Rich, will give that a try. Matt :)

Is it possible to stop a value when using the datediff function? I am using several functions to calculate depreciation on an asset item. The one which i need to try and stop is the datediff function which is currently in a forms text box. When it reaches the depreciation life of an item it...

Wey hey :D It works now. Did a couple of things including removing the subform from the main form and re-linking again. The "+" in the expression builder does not exist, must be a non Access97 thing as these were not present but managed to get the syntax right anyway: SELECT DISTINCT...

Hi Guys, Okay this may be getting somewhere. I used the expression builder and have come up with the following sql: SELECT DISTINCT tblTrainingRecordSubForm.Category, tblTrainingRecordSubForm.Item FROM tblTrainingRecordSubForm WHERE...