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

Sorry It's a form with the combo boxes on.

I get the following message; Run-time error '3075': Syntax error (missing operator) in query expression ' AND (Performance.Gender=[Forms]![Performance Dynamic Report Builder]![gender])'.

Hi I originally posted the following thread 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...

Hi RainLover Thanks for the reply. I'm new to this. Private Sub Command93_Click() Dim StrRptWhere As String If Nz([Specialties]) <> 0 Then StrRptWhere = "(Performance.Specialty =[Forms]![Performance Dynamic Report Builder]![specialties])" End If If Nz([Gender]) <> 0 Then If Nz(StrRptWhere) =...

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...

thanks it work great. But only if the first combo box is used and the second is empty and not if its the other way round. Also if I wanted to add more combo boxes ie [grade] how would I go about adding that as I see the code is 'If', 'then' and the 'and' functions. Really appreciate your help.

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 "...

thank you, it worked!!! :)

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

Thank you so much guys. John Big Booty I used your link/code. I cant thank you enough for this. Really big 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...