Search results

Ok, time for Question 2. Any hints on how I can filter the report to only generate form letters for the record I am viewing on my form? OnClick Do.Cmd RunSQL "blah blah blah" Where does the filter go? Thanks in advance, Ox

Ok, I have a DB containing data (name and address) about a client's parents, psychiatrist, and school. When it comes time for the client to have a review meeting, I want to be able to generate a form letter to all these parties, but I'm not sure how to do that with my current DB configuration...

Oops! Thanks for the tip!

I want a text box on my report to return the sum of persons who are between ages x and y. The code works perfectly if I want to return persons below or above a certain age, but does not want to return persons within an age range. Here is the code that is not working...

Had this problem as well. Took me about 30 min and a lot of hair pulling to figure out. Check and make sure that the fields you are referencing in the table are set to "Date/Time" format in Table Design view. I thought just having the input mask would be enough. Mine were set to "Text" and a...

Just for future readers/searchers, I found this, works like a charm: Linkage

Let me rephrase for better clarity: I have several locations with many clients under each one. Each time one location ends and another begins I would like the report to start on a new page. I cannot seem to determine where I should place the page break or if this requires code. Thanks in...

I believe this is right. If not, one if the gurus here will correct me :D docmd.openreport "MyReport", acnormal PS: I believe you have quadruple posted this, might want to delete those:)

I am currently running a report that outputs a list of clients at various locations. What I would like to do is have the report jumpt to a new page each time a nrew location comes up. Is there any way to do this, where would I place the page break?

Like this? DoCmd.OpenReport "rptClientsOpen", acViewPreview, , "Reports!rptClientsOpen!Date_Opened Between #' & Me!txtFromDate & '# AND #' & Me!txtToDate & '#'"

Hey, no need to apologize, I'd be lost without this forum:) I hate to continue the thread, but I'm still getting zero records back when filtering with this code. I have no idea why this would be, as the code looks fine to me. However, this is my first time filtering by date so maybe I've got...

Yep, I tried that solution but heres what I got: It took the #s off the ends, but Im still getting a similar error. I can't quite figure whats going on here.

You guys are a lifesaver! Thanks for the help, getting an error though: Syntax Error (missing operator) in query expression '([Date_Opened] = #Between #06/25/2006# AND #07/01/2006##) Here is code with additions: Private Sub cmdApply_Filter_Click() Dim strDate As String Dim strFilter As String...

Forgive my noobness, but can you point out where I need the #s? Or any other mistakes. Am trying to do the same thing the OP is doing, searching a report by date range. Private Sub cmdApply_Filter_Click() Dim strDate As String Dim strFilter As String 'Date Boxes If...

Wait a minute..... I should be summing in the query and doing the actual math (subtraction from authorized amount) in the report. Right?

SELECT tblClient.FullName, tblService.Funding_Source, tblService.Service_Name, tblService.Auth_Date, tblService.Auth_Units, Sum(tblServiceLog.Service_Units) AS SumOfService_Units, [Auth_Units]-[SumOfService_Units] AS [Remaining Units] FROM (tblClient INNER JOIN tblService ON tblClient.SSN =...

Hmm, that makes sense, I will make the proper adjustments. Thanks for your help!

Let me try and explain another way: I want to create a 1-to-many relationship between 1 field in one table and 2 fields in another. Access will not let me Enforce Referential Integrity on this relationship. Is there any way around that?

Ok I have a table of clients, and each client will have 2 employees of differing types assigned to them. I had hoped to combine all employees into one table, assign them differnet titles in the employee table by way of combo box and then have the appropriate fields in the client table only show...

the 2nd one works brilliantly, thanks!