Search results

Hi I'm quite new to access. I have a form [Performance Dynamic Report Builder] with 3 combo boxes on it [specialties], [gender] and [grade]. I'd like it to be able to filter my report [Dynamic Specialty Performance] by selecting data from either 1,2 or 3 of the combo boxes. Any ideas? Thanks

I have a report that gets filtered by a form with 2 combo boxes on. If I select data from both the combo boxes the report works fine. If I select data from th e first combo and not the second it works fine. But if I leave the first combo blank and data in the second it doesn’t work. I'd like to...

Hi I have a report that gets filtered by a form with 2 combo boxes on. If I select data from both the combo boxes the report works fine. I'd like to get it to have the ability to select data from 1 or 2 of the combo boxes. The code is; DoCmd.OpenReport " Dynamic Specialty Performance "...

Im using Access 2007 and I have a on my switchboard a total for any bookings outstanding usuing a subform and the count funtion. It all works fine except when there are no records then its just returns #Error Is there a way to stop this? I've tried is null and nz function but no joy. Thanks

I have built an access db and I have a form with a list box on it that lists all my customers. Cust Id, Last Name, First Name etc I can scroll down the list and when I double click on the particular customer it will open up another form with their details on it which is what I want. As I have...