Recent content by Funkbuqet

That did the trick. Thanks for all your help answering my very convoluted question!

Plog, thanks a lot for your help. That almost gets me there. As I mentioned but did not include in my sample data, I have 4 states with different sets of values. The expression you gave me works well except it returns the closest value without going over from the table as a whole and does not...

I need some help figuring out how to make this query work. Essentially I have a table [Activity] with the feild "RecordedConcentration" with a numeric value. I have a second table [Assumptions] that defines the "Catagory" (for a given area) based on "Concentration". What I want to do is for...

yes I had a similar issue with the table I was talking about above. It references 4 subreports in thiamin report footer, but it didn't want to see any of them. However if you hide group header they are in they won't populate the main report. But you can set the all individually to visible=no and...

Megan, the only "solution" that I found was that there had to be data present. For me it shows the #error when the record set does not have record that fits the criteria I set in the subreport. I worked around it by entering zeros in the table when nobody worked in the represented county instead...

Minidumps, yes I did. I was unable to use DoCmd.SendReport however. I ended up using DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, "PathAndFileName", [AutoStart] And then had to include the PathAndFileName as an attachment in the e-mail compsition code.

I got it to do what I wanted!! Thank you very much for all of your help. Instead of using a parameter query I just added a where clause making ComplaintReportID = [Forms]![ComplaintReportForm]![ComplaintReportID]. The query only works when the form is open, but that suits my needs just fine...

Is there a way to specify what the name of the outputted PDF file will be?

What do you have to do to get the parameter query with the parameters specified to open a report based on that query? I am using the below code and when the report opens it still prompts me to enter the ID parameter instead of accepting the one I have in the code. When I bug check it and hover...

I will try something like that, but I do not really want to preview the report. In the end I want to click the button and it e-mails the report out. I was just using OpenReport in the code above as a proof of concept that the report would be produced properly. Do you know why the code I...

Ok i am getting closer. Thank you for all of your help so far. The link you posted lead me to realize that i needed to use a parameter query (had no idea that's what I was looking for was called). I wrote some test code into my form tied to a button click just to see if i could get it to produce...

Excellent thank you. This has a lot of the coding in it I can use to adapt to my situation. Is there a way via VBA to influence an existing report based on an existing query? In other words, if I have a query that feeds a report can I in VBA code generate said report for a particular record. So...

I have a form that I am using to collect information about complaints we receive from the public. Once we receive the complaints it is my job to dispatch one of our feild teams to respond to the complaint. What i would like to do is have a button at the bottom of the entry form that will send...

Excellent. Thank you very much gentlemen, the code is working just like I want it to! I appreciate all your help. I have posted the working code below in case someone in the future comes accross a similar issue. Private Sub RPphone_AfterUpdate() Dim strSQL1 As String Dim db As Database...

When I enter "If Is Null (Me.RPphone.Value) Then" it hilights Is and tells me and expression is required. If I reverse it the "If Me.RPphone.Value Is Null Then" it hilights the whole line and tells me it is missing an object. What am i doing wrong?