mattkbishop
Registered User.
- Local time
- Today, 21:12
- Joined
- Mar 5, 2003
- Messages
- 36
Hi everyone,
Cheers for the help so far. Here's the latest....
(Sadly I can't upload on here as it's about 100kb too big)
I've added in a 5th tab to my database (I'm using tabs to segregate the form up). This is for the user to set the criteria for a search and run the query (SearchFilter - on the button on tab 5)), thus performing the search.
Also, I tried a tickbox in the same way for Permissions as you can see. Ticking it means no records appear at all - do I have to do these in a different way to the text boxes? How? Somone suggested using an MZ function but I don't understand.
And finally, this is the big one. I want a list, of Towns (as you would get in a list box), where the user can hold Ctrl or shift or whatever, and select as many as they want to search on WITH the other criteria upon pressing the button (that at the moment runs the SearchFilter query). I also need this for Category and AgeRanges - which pops up another problem due to them being linked tables by ContactID, and where the data for the field is selected from a table (tblPostalTown) simply consisting of all the Postal Towns, that are added into the main table (tblProfessionalData)
When that's done, presumably I can design a new form with the query as a record source to add controls such as print form. This would just be easier for the user I feel.
So, a selection of problems there, hopefully getting those solved will more or less end my dealings with MS Access forever, and any help will be most appreciated.
Thanks,
Matt
Cheers for the help so far. Here's the latest....
(Sadly I can't upload on here as it's about 100kb too big)
I've added in a 5th tab to my database (I'm using tabs to segregate the form up). This is for the user to set the criteria for a search and run the query (SearchFilter - on the button on tab 5)), thus performing the search.
Also, I tried a tickbox in the same way for Permissions as you can see. Ticking it means no records appear at all - do I have to do these in a different way to the text boxes? How? Somone suggested using an MZ function but I don't understand.
And finally, this is the big one. I want a list, of Towns (as you would get in a list box), where the user can hold Ctrl or shift or whatever, and select as many as they want to search on WITH the other criteria upon pressing the button (that at the moment runs the SearchFilter query). I also need this for Category and AgeRanges - which pops up another problem due to them being linked tables by ContactID, and where the data for the field is selected from a table (tblPostalTown) simply consisting of all the Postal Towns, that are added into the main table (tblProfessionalData)
When that's done, presumably I can design a new form with the query as a record source to add controls such as print form. This would just be easier for the user I feel.
So, a selection of problems there, hopefully getting those solved will more or less end my dealings with MS Access forever, and any help will be most appreciated.
Thanks,
Matt
