Search results

Thank you again for this information and your sample DB on how to use. As my report actually has 4 different listboxes, I will need to figure out how to apply your solution to that multiple list box structure.

I would like the user to be able to select a town and then be able to print out the result using the command button. Currently all the items from the listboxes print out (checked and unchecked). I would like to only print out checked items. Thank you.

Thank You

Thank you!

Hi, I have received some good help in the past from various people on a project I am working on. Unfortunately I am stuck again with the following: I have several combo boxes embedded in subforms within a navigation form. I know the syntax changes between a standalone form and one embedded as...

YES THANK YOU!. Would you mind helping me understand what you did so I can learn? I'm not sure I see anything different.

Hi, I did look at trying to fix the WhereCondition but I can't seem to get it. I know the value from the TempVars is correct but it does not seem to pass it to the report. If I put the [TempVars]![tmpFilterID] in manually as a criteria it works just fine. Your continued help would be much...

Thank you for your edits. It works just fine. My issue now however is that I get Parameter errors because I use gryContactsExtended at various other times in the database. I guess I can create a separate query just to run against this report?

Thank you very much. I'm looking at the WhereCondition now. Of course I don't know why it does not seem to work but I will certainly give it a try before asking. Thank you

I deleted as much from the DB as possible in hopes it was small enough to attach. Thank you again for taking a look at it.

Hi, I am looking to use the "DoCmd BrowseTo" along with a "Where Condition" to filter a report in place. I can not for the life of me get the Path to Subform Control argument right. I did try and look at other threads and still can't seem to get it right. Here is my current setup: Form: Main...

Hi, I have made some changes and removed 90% of the database so I can attach. As suggested, I have placed my second subform into the footer of the first and have linked the master/child fields. So it seems the only thing that is missing is to automatically apply a filter to only show...

As you can tell I am very new to the whole Access thing and don't have any experience coding. I attempted to zip the db but even after being ziped it is too large. Private Sub Dashboard_Open_Project_Items_CountOfFinished_Click() Dim strSQL As String strSQL = "ProjectID = " & Chr(34) & Me.ID &...

Hi, Thanks for taking a look. What I am attempting to say is that when the user clicks on the count of the open items {highlilted in red box} (which is part of the first subform) the second subform will reflect only open items for that record.

Hi, I have a navigation control with various tabs on it. On my tab called "Task Center" I have a blank form called "Task Center". On this form I have two subforms which are both unbound. The first subform is called "Task Center subform". This form contains various fields. [ID],[Project...