Search results

Ok I have this resolved and here is the code that works wclause = "[date] = #" & Me![Combo2] & "# " If Len(Me.Combo0) > " " Then: wclause = wclause & " And " & "[press_number] = '" & Me.Combo0 & "'" Thanks for the information.

I know this post is a few days old but this is still not working for me. I'm not getting any errors it just doesn't do anything when I click the command button on the form with this code in the on click event: wclause = "[date] = #" & Me![Combo2] & "# " If Len(Me.Combo0) > 0 Then: wclause...

Thank you for your reply and sorry for taking so long to respond. I'm getting an "expected: end of statement" error with your code at the [field3] point. I copied your code then edited it to reflect the correct field names and combo box names and pasted it right below my wclause. wclause =...

Hello All! I want to open a form that is filtered by the selections made from another form with three combo boxes. I have this so far to filter from one of the combo boxes how do I filter using all three combo boxes. wclause = "[date] = #" & Me![Combo2] & "#" DoCmd.OpenForm...

Excellent! Your first example worked for me and I will change the name of that field from Date to something else. Thank you very much!

Hello all! Can someone tell me why I would get "data type mismatch" error for this string and what I need to do to correct it. Trying to use it as a row source for a combo box in Access 2010 strRowSource = "SELECT time FROM [silo changes] WHERE [date]= """ & Me!Combo2 & """" Thanks!

We are migrating from Office 2003 to 2010. I opened one of my 2003 files in 2010 and noticed that when I have a report Maximized in preview mode the close button in the upper right hand corner disappears. The properties for the report are set to display this button and the min/max buttons. But...

Thanks for the reply! I will be contacting our IT dept about getting a copy deployed early for me so I can test my files out before the upgrade. Thanks for the tip!

My company is upgrading from Office 2003 to 2010 in a couple weeks. I have several Access databases in use being shared on our network. I have forms, reports, querys, macros, VBA code and a lot of time spent making them user friendly. Are we going to have any problems running the 2003 files in 2010?

I think this will do what I need. Can't thank you enough. Thanks for taking the time to reply and have a good weekend!

Thank you for responding! How do you create subtotals in a query?

Comparing two tables in a Query Good Evening All! I have 2 tables structurally exactly the same. Named "First Check" and "Second Check" used to take inventory. I have them joined in a query by an "item number" field. Each table has a "quantity" field. I need to compare the 2 tables and find...