Search results

Pr2 - Sounds good in theory but I can't say I know how to do that. I put a subform in with all the bound text boxes and left the unbound combo boxes on the main form. Not sure what to set the record source to so that it does what you're saying. Mile - I open by double clicking. I don't want to...

Thanks, I was afraid of that. I'm learning on the go here and keep discovering things that I should of done earlier. I'm a little confused though. If I make a subform with all the bound text boxes and check boxes, it will be clear on load until I make a selection on the main form combo box?

Hi, I have a form that I populate after making selections in two combo boxes but when I load the form the text boxes are already filled in with the first record. The combo boxes load blank, which is what I want. How do I get the rest of the form to be blank on load? It is made up of text...

Got it to work with: DoCmd.OpenReport "Copy of PSReport", acViewPreview, , "[PS_Agent]='" & Me.cboName & "' And [PS_dDate]=#" & Me.cboDate.Column(1) & "# And [ID]=" & Me.[ID].Value

Seemed to have go it to work with: DoCmd.OpenReport "Copy of PSReport", acViewPreview, , "[PS_Agent]='" & Me.cboName & "' And [PS_dDate]=#" & Me.cboDate.Column(1) & "# And [ID]=" & Me.[ID].Value So I'll go with that for now!

Hello again, Quick follow-up for you, How can I inlcude the ID in the openreport command? Some dates are the same but the record is different so I I'd like the report to be populated by the ID as well. That way I can split up records with the same date and not have them appear on the same...

That number changes though depending on which date is selected. I know I need to set ID= to something that captures that change, and not just a set number.

Hi, I want to tweak an existing form that currently allows me to generate a report based on a name and date selected. The issue now is that there are some records that have the same date and I want to be able to generate a report on them seperately. i.e. Jane has 2 records for December 5...

Scratch my last post, I didn't see the last 2 posts. It works perfectly now by referencing the column! Many thanks to the both of you.

That did the trick for the report but now the form itself does not populate. It stays blank after I make my selections in the combo boxes. Now I do have have a SearchForRecord Macro in the date combo box which now might be off. Object Type - (blank) Object Name - (blank) Record - First...

Yes, the date is shown and it is date type in the table. But still get Syntax error in date query expression '([PS_Agent]='John Smith' And [PS_dDate]=#75#' Does it have something to do with the date como box being a box that finds a record on my form based on the value selected? It also has 3...

I get a syntax error when I run it with that line

Hi, I can open a report right with a wherecondition that opens a report based on an agent name.. DoCmd.OpenReport "SelectPSReport", acViewPreview, , "[PS_Agent]='" & Me.CboAgt & "'" But it returns every record for that agent and I want to be able to specify the date that goes with the...

Unfortunately I can't, do to regulations in my office.

Hi, I'm trying to create a report in Access 2010 but I've reached the maxium 22"" length on my sheet. It's a training feedback form that gets filled out on InfoPath then dumped into Access. It has the Agents name, date, and projects followed by 10 different evaluation sections. Each...

Actually I got it to work with the wherecondition. I wasn't filling it out properly. Thanks!

I put Forms!Formname!.Textboxname as the WhereCondition of the macro and it just opens the report based on every name and not the one in the textbox.

I want to open a report that shows only the information displayed on the form. My form allows me to cycle through 20 different names and their scores and I want to be able to stop on any name and open a report with just that information.

Hello, I've set up a form with a button to open a report based on the current name on the form. The idea is that as you look through the different pages on the form you can open a report for whatever one you're on and print it. In my query I have a name field where I put the criteria...

An Access newcomer here from Canada. I've been learning with videos and forums over the last month and have reached a few stumbling blocks, so here I am!