Search results

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?

you usualy put spaces between the initial speach marks and the SQL command(from, where etc) EXCEPT for the initial "SELECT Now that I think about it I did add a space at the end of the Select and From lines, initially it didn't seem to do anything but it must have made the difference.

Nevermind it seems to be working fine now. I din't change anything though. Now I just need to work on getting it to do exactly what I want in each case of the If Then. Is ther a was to exit the sub if the RPphone feild is cleared. Right now if I enter a number in and then delete it returns...

Ok, I entered the code you provided in and it is getting stuck when it tries to run the SQL statement. It give me an error stating "Syntax error with FROM clause" and when I go to debug the line "Set LRS = db.OpenRecordset(strSQL1)" hilighted. So I cut and copied the SQL statement into a blank...

Thank you. I will try and giv this a shot later today. For auto fill I think I can use DLookup() to fill in the correct data corresponding to the ComplainerID#.

I am trying to create a form to log complaints from the public. We frequently receive complaints from the same people over and over. Instead of duplicating data about the complainer I have decided to make a table for just complainer contact info and a table for complaint details tied to each...