
December 29th, 2003, 11:09 AM
|
|
Contributing User
|
|
Join Date: Dec 2003
Posts: 34
Time spent in forums: 1 h 20 m 25 sec
Reputation Power: 7
|
|
|
Query-by-Form (w/date & memo fields)
I have a database where I have attempted to create a "query-by-form". I downloaded Qbf2k.exe (by ken Getz) that simplifies/automates the routine to create the query parameters. It worked quite well except for a couple fields - DATE and REMARKS (DATE is a date field and REMARKS is a memo field).
1. DATE - Works if I enter a specific date. However, I would like to query by all records between two dates (i.e., enter a start date and end date). I have a query that does this, but, when I run it, I lose all the other query parameters. It only sorts by my date parameters.
2. REMARKS - Works if I want to query on the first word in the memo field. However, I would like to be able to add key word(s) to the REMARKS query field and have it filter on those key words plus items entered in other query fields.
3. Is it possible to setup a Query-by-Form based on the record source being a query? In other words, the QBF would only return results from the previous record source query (i.e., a start/end date query or Remarks query)?
I see where the Tag property is set for each unbound text control. Is this where the modification takes place or is it on one of the other items (i.e., Before Update, On Enter, etc.)?
Thanks,
SKK
|