Is it possible to organize a 'quick search functionality' in the table by
meanse of the Filter prop. I wouldn't like to requery. Filter works
faster. Can someone give me examples for numeric and date fields?
Looks pretty simple to use LIKE. However, LIKE is only for strings (which is
also true of the T-SQL LIKE in SQL Server). What exactly are you trying to
do?
RE: VBA record filtering and filterOn property ... I would store the current record position before the requery,...sort order is the same and no new records were added in the meantime. ... Because I display the Access navigation buttons on my form, I had to filter... (microsoft.public.access.formscoding)
RE: VBA record filtering and filterOn property ... I would store the current record position before the requery,... Because I display the Access navigation buttons on my form, I had to filter... (microsoft.public.access.formscoding)
Re: Resetting subform filters ... I was wondering if you could force a requery... Not requerying - it isn't necessary when I change the filter,... The recordsource on both subforms is set to a table - not a query or ... (microsoft.public.access.forms)
Re: Removing filter loses bookmark ...filter, change the sorting, change the RecordSource, or requery the form. ... the first record becomes the default? ... before I reset the form's recordsource, and then in the ontimer event, I ... (microsoft.public.access.formscoding)
Re: Value with Record change ... trigger that requery.... > cbo_2 is fed off of a query that has cbo_1 set as the filter criteria.... > the options in cbo_2 will change depending on the value selected in cbo_1. ... > It only filters if I make a current selection.... (microsoft.public.access.formscoding)