Search results

Had a quick check but couldn't find any relevant help. Anyone have a clever way of stopping a report footer from appearing on the last page by itself? Even if I just knew it was going to happen I could write code to push some data onto the last page. Sam.

Glad it worked and thanks for the reply. Getting bored of writing up solutions here and never hearing whether it was useful. Or even read for that matter.

Is there a question there somewhere? Looks OK to me, except you will want to change your condition to: If [txtReportDate] >= [txtStart] AND [txtReportDate] <= [txtEnd] THEN

Do you really then need a UNION query? Do you want different types of information of different rows? What will you be doing with the information? You are free to add WHERE clauses to your individual queries and if you need to JOIN in you main table you can do in each case. Then add a parameter...

You can base the report on a new query which joins the table and saved query on the Last Name field. You don't even have to create a saved query to do it. The report can hold its own derived query as a recordsource. Just go to the table name in the report properties and click on the little...

Let's just work with one subreport and one user. Ideally your subreport will contain data in a User field which has the name of the person able to see that line of data. So when you run it before managing to achieve your goal it will simply show all the data for Tom, Dick, and Harry. I usually...

Me.pbSick.Visible is not a statement and will cause an error. You need to use Me.pbSick.Visible= True. Or instead of the whole If...Then...Else construct use: Me.pbSick.Visible=Me![rptReview].Report.HasData That's a start. Whether it will help your report is another matter. Are these...

I'm not following all of this but if you don't get an answer to what is a fairly simple question, try just posing it without some of the irrelavant extras such as the API calls. If your recordset has a field called "datew" then all of rs!datew, rs("datew") and rs.fields("datew") will reference...

Why is one of those not OK, but the other is? Do you want the data to be rejected from the table when the addition attempt is made? Where did you use DISTINCT? There isn't mention of a query here.

Have a one record table with the date in it, and link that date to the fields in the queries which need to be restricted to that date. Then set up a form to edit the date if you want.

You need to build up your criteria based only on the fields where there is a value. Taking just a couple as an example I'd do this: Dim strWhere As String if len([d1])>0 And len([d2])>0 then strWhere = strWhere & " AND [Ad_Date] BETWEEN #" & Format$(Me![d1], "yyyy-mm-dd") & "# AND #" &...

You'll have to be more specific at a guess. Have you tried debugging to see which part is failing? If so, let us know.

You are really going to have to explain that a lot more clearly and while you're at it give it a relevant subject heading.

Hey, I'm from Perth. Forget the Excel and go to the beach.

I'm a little worried though about your use of WorkBooks like that. Shouldn't you be using the Excel application object you created to reference the worksheets? So xlApp.WorkSheets... Otherwise you are referring to Access' Application object's WorkSheets property, and not the one you think you...

I can understand what you are describing, but it makes no sense to do it this way.

How good is your coding? I'd say it is about the only way to do this. Create a recordset and run through it. Easy if you do it that way. Otherwise I could suggest a clunky method using a Make Table querie to record twenty names without a group yet assigned, and another query to return the...

You can execute a CREATE TABLE statement easily enough. Not sure about through the query builder, but in code it is simple enough. Load your statement into a string variable, create a database variable, and execute it. strSQL = "CREATE ..." set db = CurrentDB db.Execute strSQL Go crazy. (You...

There are two good ways to do this, and a few others I can think of as well. 1) Have your report refer to the form controls in its record source. Get to the query builder behind the report by clicking on the builder box next to the report's Record Source. Add in any criteria you want by...

I should probably add that there is a DateDiff function which you can use if you're more comfortable with that. Look it up in the help.