Search results

Hi lagbolt, Thanks for the reply. Sorry, I should have mentioned that they are already split and on a server, my apologies. My initial thought is that they would be easier to maintain if they were relatively small and I could just link to them as and when required. But, the more I think...

Hi, I started to build a database for my wife's company with the intention of 'One database to do everything!' I quickly realised what a mammoth task this involved and started losing myself in queries & code. I have now split it into smaller chunks; Employees db - Employee info and...

Hi, Thanks all for the replies. Dale, I tried your suggestion, with no joy. Simon, Brian, I guess my solution is along the lines of what you have suggested. I pursued the article by Allen Browne and finally got it to work (Or at least it seems like it's working with the small amount of...

Hi Everyone, I have just joined this forum after a few years of lurking and getting some great info from it. I am relatively new to Access (Tried many times over the past 5 or so years, but got frustrated and always went back to Excel). I have just built my first db (Employees Info and...

Hi Alan, Thanks for the input, I thought that would be the outcome. Unfortunately the name criteria is not always required, the user has to filter on FundingAreas, ChargeTo and BookingType as well as names. I will pursue the VBA route from Allen Browne's article and keep this post updated...

Hi Simon, Thanks for the reply. I have taken out the leading "*" and still got similar (if not the same results). I am not to sure by what you mean by; 'and then test is the relevant combi is null and ignore the search criteria in other words search on values that have been requested'...

Hi, I have created a simple Unbound search form based on a 'Bookings' table. There are 4 comboboxes that the user can choose to search on, 'Client_ID', 'BookingType', 'FundingArea' and 'ChargeTo'. I have created a query that uses the following criteria; Like "*" &...