Search results

I would like to see this example Dan. I need to do a simmilar thing except I have a number of word documents, photos and pdf documents associated with each record. I am looking for ideas on how to limit the listbox you are talking about to only those that would match the record. For example...

Gotcha. I hadent planned on hard-coding in the search terms, it was more for the example, but I appreciate the help on the syntax, etc.... That should clean up my code a little too. Every little tip helps. Thanks, Leo

Great, Thank you very much. I forgot that from my database class. Hmmm... Leo

tfoulkes, Thanks for your reply, That is what I want to do. I used something very similar to your code to modify the recordsource of my continous form. It works great (eg it performs the search and displays only the matching records) when I include only one column in the WHERE clause of the...

Oh, I see now... That is the column name in the WHERE clause. Do you know how to search multiple columns using a simillar query? TIA Leo

Re: What I've done.... tfoulkes, I am trying to implement your code but I am not sure what you mean by [Page Path]. I understand the rest (I think). Leo

Thanks Rich, That worked great! Leo

I have a form with a button that when pressed assigns a value to a variable (and it does other other things on the form). I would like to use that variable in a subform. Right now when I try to call it on the subform it is null. I am assuming that I have to make the variable public somehow...

Could you please post this on the board? Leo

I am interested in making a sub-form that looks like a multi-select list box maybe even with check boxes (so it looks like the "Categories" selection in Microsoft Outlook). I have my many-to-many tables set up correctly. Currently my subform just looks like a table with a combo box for each...

I am simply tyring to make a summary table to export into some statistical software. The more I can get Access to do before I export, the less work there is to do in the statistical software (cuutting, pasting, pivot-tables etc...) So far I have found subforms (for this purpose) are a little...

Sure did Mile-O-Phile :-). I have a bad habit of being too technical. It drives my wife nuts! LOL BTW, I like your sig.

Is it possible to count two groups at once in the same query? For example I would like to know the number of species and a count of species from the following simplified version of my database: sample (sampleID, lots_of_sample_information) fish (fishID, sampleID, species...

Tech note Sorry to be technical but a spreadsheet is a database, it is just not a relational database (by itself).

Is it possible to put an Autonumber field into a make table query? I am using an external application (ArcGIG 8.1) to access an Access database. I have put together a query that returns the table I need for ArcGIS but ArcGIS insists on creating a unique identifier in the table before it will...