Search results

I have a Form ‘frmMsg’. (This is the Main Form) I have a Pivot Table Form called ‘pvtMsgLayer’ with a built in Record Source Query. (This is the Sub Form) I am using VBA to open the Main Form. The part I am having trouble with is Filtering the Sub Form with a Comma Separated Values...

Any assistance would really be greatly appreciated. I’m a Newbie and have been trying to figure this out all week!! I have a form called [frmCreateTask] that I am using to add tasks to my table [tblTask]. On this form I have a combo-box [cboEmployee]. I would like my row source to...

I am still unable to figure this out. If anyone has any suggestions I would really appreciate the help :)

Yesterday as discussed I broke the different leads out into a separate table called "tblTaskAssign". For the life of me I can not get this application to work properly now. I have attached the db Now from "frmCreateTask" Towards the bottom of the form there is a sub-form where i would like to...

Funny you should mention that because I was unsure how to deal with all those Task & Checker Subs. Basically, I have a task that comes up, I will open the Form called: "frmCreateTask". Each task is assigned an Auto ID. I will give the task a Task Name, Description, Due Date etc. As part of...

Ok here is my most current db. I have incorporated your added features into this one and broke the report query out of the report. As you will see when you attemp run a report from the following Form: "frmCreateTaskReport", Access asks for any criteria not filled out on the form. The previous...

yes the query is built into the reports "Record Source". If you click on the reports record source property, that is my old sql statement.

First off please excuse my ignorance :confused: Previously I had the optional criteria working in my db when I had the query built into my report. I have attached my old report with the built in query if you would like to view the sql statement. I then cut the query sql statement out of the...

There is a few Text-Boxes and Combo-Boxes that I have on this same filter form. I would like those controls to be optional so for instance if I do not put a value in the control it will simply return record sets based on the other criteria. I hope I have explained this proper. Any suggestions...

Opps my mistake. I had re-copied your db and forgot to save it so it was in "read only".. Ok I am back in action. Thanks again =)

For some reason the code is stopping on the following line: loqd.SQL = stSQL

wow took me awhile but I finally found the "Thanks" button.

Got it working. Thanks for the help :)

Hi I am new to VBA so please bare with me.. I have a Form I am using for Filtering Records on a Report. I am trying to figure out the code to make my Listbox a Multi-Select Listbox and have the code in the on click event of a command button to output to a report. My Single-Column/String...