Search results

I need to add a DLookup to my Subreport. For my text box, Text255, on the Subreport I have tried: Private Sub Report_Load() Me.Text255 = DLookup("[Along_line_spacing_%pass]", "Performance_Requirements_Defaults_Table") The table Performance_Requirements_Defaults_Table has just one record...

Now to see if I can make Subreport2 a chart with the same, correct data on it ;)

It worked! Thank you so much - and it was super easy as I already had the needed hidden field on the main report ;)

I have a report with a nested Subreport. Main Report>Subreport1>Subreport2, for simplicity. I have master/child set up for both Subreports, but I would also like to filter the Subreport2 records with a date range parameter. Is there a way to get the Subreport2 where clause to recognize the...

Thanks David, This ended up getting me the result I was after - close to your suggestion. strSQLStaticExpr1 = (1 - CDbl(Forms![Print_Processing_Report]! [SRespTol])) & " * [Response_Value_CH2], " I have a long way to go, but this gets me moving again in the right direction. I'd...

I am trying to build a function that will create a dynamic query for a chart on a Subreport. I am not exactly sure I am going about this the right way, but I need the user to be able to change selected fields for use in the query. I have a form with 3 combobox controls for selecting options to...

Project_Defaults and Performance_Requirements_Defaults_Table are two separate tables. My database is split, with most of the tables in a linked BE. There are a few that reside in the interface, including Project_Defaults. I just created a new test form and added lookups one each from a...

Yeah I double and triple checked them. I also played around with the code a little. If Both tables are linked it works, if none are linked it works, but if one is linked and the other is not, they do not work. Is there a way to refer more specifically to the tables being used in this instance?

So maybe it is normal to get the compile error? I get the same thing when running on the code that works, but still can't figure out why the other does not work.

Can anyone help me understand why I am getting "Compile Error: Expected: =" here: Private Sub Form_Load() Me.Text9 = DLookup("[Along_line_spacing]", "Performance_Requirements_Defaults_Table") when this: Private Sub Form_Load() Me.charttypestatic = DLookup("[Static_Chart_Type]"...

That's OK - you were right! I got my query filtered correctly so the chart shows up just once, and I found my mistake with the other two Subreport errors. I copied my main report to a temp one to make changes and forgot to update the parameters on my Subreports! Oops. All is well now, thank you!

Making the Subreport query exactly the same as the chart query has made my chart show up 4 times on the report (once for each record being plotted on the chart - which I only want it to show once - all 4 records plotted on the same chart). The other two Subreports are still prompting me for...

GinaWhipp, I used the same query as on the chart for the RecordSource of the Subreport, but I didn't include all of the same fields. I was having some trouble with the chart either not showing or showing multiple times when I messed around with this.

So I am adding a chart (on a subreport) to a report that has multiple subreports already. I have gotten the chart to show up correctly on the report, but now 2 of my other subreports are not working. I am being prompted to input parameters for these subreports that used to pull their parameters...

MySub() = ExportByItem_Click() I have the form open. I set a break at Set qdf = CurrentDb.CreateQueryDef("Static_Response_Export_" & Forms!Export_for_Excel_Chart_Static!SelectByItem, strExport) When I put ExportByItem_Click in the immediate window and push return I get Compile...

Thanks for the tip Rx - feeling really inexperienced here - can I set a start point for my code test? I have a bunch of other things that are not compiling in other modules. I would prefer to not have to delete all of that from my project. Setting my cursor in the correct code window does not...

The code I posted is pretty much what I have, I just didn't include the "on click" and "end sub" parts. I don't have any error handling built in yet. I do not believe it is creating the query when I run it, though it did before I made changes. Copying the query into Access to check it seemed to...

So I had this code working and then I cleaned it up a little and it no longer works. It should export data from a created query using criteria selected by the user on a form and put it into an excel file that exists. I get no errors but it does not export anymore. After pouring over it for a...

I am trying to use the string value from a form control as the criteria for a query. I first need to replace the "," in the string with "AND". So far I have a module using the Replace function, but it doesn't seem to be working. I am not sure I can reference the string inside the form control...

@spikepl - thanks for your comment. It made me take a step back and think about some things I hadn't been focusing on. As far as business needs - most of our database functionality requirements have not changed in the past few years. The biggest change is updating hardware. We do need to...