Search results

Yes, thank you very very much. I've also edited the form1 so it is a combo box and it works fine also. Did you have to write any code in the backstage for this or was it just getting criteria right? Thanks, J

It was still looking for "ClientID_Label" in "Merged41" report.

I did do, just not the record source part of "Final 41". however, this still works with the old code in either way. I have changed the record source to match what you did in qry_COMPLETEDDATES now. It works now by selecting the client and then pressing run report. Can I ask, how did you...

The one you sent me has that in also.

Final report including all sub reports = "Merged1" The subreports and queries used in each are: "Final 1" report from "qry_COMPLETEDDATES" from table "ETC_1stAug2014_CompletedDates" "Final 2" report from "qry_COMPLETEDDATES" from table "ETC_1stAug2014_CompletedDates" "Final 3" report...

Here's the one I've been editing. Thank you again. This is the Youtube video I used: https://www.youtube.com/watch?v=_cefYH6VNb0 also. J

I couldn't see anything different with the qry_COMPLETEDDATES other than the criteria had changed? I copied that into all the relevant queries but it just returned a blank report. Jim

Hi, I added the open queries part because when I ran the report from the button, it just opened a blank report with no data entered. When I told it to open just 1 query, it only filled in the data on the report relevant to that query and left the remainder blank. I tried many variations...

Morning VBAInet, thank you for your work on this. I've added the following to VBA and it seems to stitch together okay now: Private Sub btnClient_Click() DoCmd.SetWarnings False CBOclient.SetFocus DoCmd.OpenQuery ("qry_COMPLETEDDATES") DoCmd.OpenQuery ("qry_Cancellations") DoCmd.OpenQuery...

Morning VBAINet, Please see the attached for a very stripped out version. The procedure: Main Form - Frm_Training Main Screen The command button on there then opens Form1 Here is a list of made up Clients that I'd like to use as parameters for the report ( report name is Merged1) and the...

I'll do it first thing in the morn. I'll change names in the sample tables and remove and logos etc from the report. Thank you.

Thank you, I genuinely appreciate your time. I'll strip it down to the basic tomorrow and post it up. Can I email it or must it be posted? Thanks again, J

I don't know how to, I think that's the issue. I looked at what happens with the other reports my colleague set up. When I click one of her reports, it first opens a form with drop down boxes which I can choose certain parameters. But, there are other buttons on that form such as "print" and...

Sorry, I think I've not made it clear/I'm getting very confused. Our current report system, once split, offers the user a list of buttons linked to various reports. When they click the button, a second form opens with options (such as date, venue, ClientId) that the user selects from...

This is what I get (embedded macro)

I have done that now (created a button that just opens the report). When I click it, I have to enter ClientID 6 or 7 times. Why can't I have it open the form I have created (Form1...with ClientID, CLientName) that is linked to the criteria in each of the queries like I have on other reports?

I have fixed the attached error, but now my code just opens the form I want to use to filter the final report, it doesn't do anything beyond that. :( any ideas please? J

When I click the command button, it should open the FORM1 form, based on some VBA like: Private Sub Command9_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form1" DoCmd.OpenForm stDocName, , , stLinkCriteria ReportName = "MERGED1"...

I haven't set the form up to the report yet. When I run the report by double clicking, it asks for the ClientID several times, but does display the report correctly after that.

Ah okay. What should I do now?