S
Scitea
Hi, I've been given the job of creating a database for a colleague using a
current excel speadsheet with 3500 records, so filtering is definately needed!
I have created a form which contains a subreport detailing information such
as Company Name, Country, Trademark, Expiry Year, Agent Name, etc. I have put
textboxes in the form header for Company Name, Country and Trademark which
works well when you know all three pieces of information. However, I have 2
questions;
1. Can I set up the textboxes in the Header so that they will filter if only
1 or 2 of them are filled in (the others being blank)?
2. Can I create a 'wildcard filter' so that when you enter the first few
letters of, say, the trademark, it automatically filters for those characters
as it changes? I have created wildcard filters before, but with set
characters (e.g. Star*) in queries and am unsure if it can be done without
defining characters to filter for, other than what is entered into the text
box each time (I'm ok with VB but I've only dealt with the basics before!).
Any help with this would be great,
Many thanks,
Sci x
current excel speadsheet with 3500 records, so filtering is definately needed!
I have created a form which contains a subreport detailing information such
as Company Name, Country, Trademark, Expiry Year, Agent Name, etc. I have put
textboxes in the form header for Company Name, Country and Trademark which
works well when you know all three pieces of information. However, I have 2
questions;
1. Can I set up the textboxes in the Header so that they will filter if only
1 or 2 of them are filled in (the others being blank)?
2. Can I create a 'wildcard filter' so that when you enter the first few
letters of, say, the trademark, it automatically filters for those characters
as it changes? I have created wildcard filters before, but with set
characters (e.g. Star*) in queries and am unsure if it can be done without
defining characters to filter for, other than what is entered into the text
box each time (I'm ok with VB but I've only dealt with the basics before!).
Any help with this would be great,
Many thanks,
Sci x