Search results

I tried that and it says there are no records there but when I place the code in a query under the sql view it works fine, it shows there are records in there. Here is my code Criteria_Str = [Forms]![EnterPayDate]![txtPayDate] sql_str = "Select * FROM [Orders Report] WHERE [Orders Report].[Pay...

Is there a way to place query results in the body of an e-mail? Thanks in advance.

The form is open. I have it open at all times because of there are different things that use it at different times. So it's alwasy there.

You suggested using the input box but I have the text box on a seperate form cause I use the criteria in multiple places. I don' t want to have to ask for the date more then once. Is there a way at all I can specify the text box as criteria for the query I am opening via DAO?

I have a form which has a text box prompting for a date. I use that date as criteria in a query. That works fine. But when I try and reference the query using DAO - Set rsReportq1 = CurrentDb.OpenRecordset("Orders Reportq1") it gives me the too few parameters error. Does anyone have any idea...

I implemented it and it works perfectly thank you so much.

Thank You That is exactly what I was looking for. Thanks. One question though will it run them all at once or will it wait for one to finish before it begins the next?

Does anyone know if it's possible to run multiple command buttons under one command button without pasting the code for each under one. For example I have 4 different command buttons to run payroll for our 4 different clients in case we have to run just one. Is there a way for me to put a...

after you change the date maybe in a lost focus event try using YourSubReport.Requery

I took over a project that someone else was working on and for a report that we have it uses VBA to pull information into the report. And that query has criteria. It was giving an error when I did it that way. So I just referenced the table and used an IF statement for the criteria. But the...

I am trying to sort a recordset in VBA. I know you can use RS.Sort but I do not know the full snytax. Could someone please explain to me how this works and what the exact syntax is. Thanks,

Thank you soooo much Rich that worked perfectly. I tried something like that among the many other things I tried but couldn't get it to work. Thanks again.

No problem, I was just browsing the other day and saw that thread and then saw your problem today.

This link may help http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=21154&highlight=close+all+forms

Ok I have done some research on the hasdata method but when I try to use it I get an error stating "Object does not support this property or method" I tried setting the page breaks to invisible and then said if the subreport.hasdata = -1 then set the page break to visible. Anyone know what I...

Rich, I'm not too familiar with the HasData Method. What would I put in there?

It doesn't work because I have page breaks before each subreport. So it still forces a new page.

Does anyone know how to stop the subreport from showing if there is no data? Right now I have a main report and two subreports linked to it. I also have a page break before each subreport. If there is no data in the subreport it just prints a blank page. I don't want the blank page if there...

Thanks Shane

You're right I'm sorry I wrote something wrong. I know how to get the total using a query but how do I place that value on the report if I have a text box called ReserveTtl. I don't know the code to use.