Search results

Occasionally when I am using access I get a message telling me that there is insufficient memory to open a report. Usually this is when I am opening a report from a form and have opened the same report a short time before eg. doing a search for individual names or data then a full new search...

can the text in a message box be set to a colour? I refer to the text which is shown when the box is activated by the end user.

Try this, it works for me; Between DateSerial(Year(Date()), Month(Date()), 1) And Date()

I need to be pointed in the right direction. I have a sub form with two fields; 1. Chemical (combo) gets data from a Chemical Qry 2. WHP (withholding period) data entered manually I want the WHP to be filled in & recorded in the underlying tbl when I select a Chemical.

Wayne I only record precipitation on dates when it falls, thus for the months nothing falls I have nothing recorded at all. In my reports I group on months but if any month has zero precipitation nothing will show because I haven't entered any data. If I were to separate the months from...

I have a Db used to record local rainfall which so far is working great. One report I like to use is that of monthly rain and occasionally we have a month with zero precipitation. When I report on the various months the odd one with zero is just not in the report as zero only those that had...

Is this too simple? Hide the Detail section of the report (Visible set to No) and you will then only see the Totals in the Report footer(s).

PH what you suggest looks good so I will use that in future. A simpler way of doing things. Thank you all for your replies.

Just a thought, your field might contain nulls, killing your formula. You can easily replace the nulls with zero using Pat H's suggestion Sum(Nz([Field]),0). I haven't tried that one yet but it looks nice & simple. In one step before summing I have been using iif([field] is null,0,[field]) to...

I noticed that Access 2000 has an option to Compact upon closing. Has anyone used this feature & is it reliable? I would assume that it is ok to use all the time but as it has to be set for each db I am a little suspicious.

databasedonr Yes you are correct. I have been engaged on other matters until a few days ago when I revisited my query & report in question. Like you I ensured that every field contained a zero and was not null with this, IIf([field] Is Null,0,[field]) . Now it all works 100%. Funny I knew...

Try this, it is what I use on reports when I use a form + calendar to select dates; ="Dates From" & " " & [Forms]![Name of your Form]![txtFrom] & " " & "To" & " " & [Forms]![Name Of your Form]![txtTo] You will have to edit "name of your form" and "txtFrom" and "txtTo" to reflect your...

This still has me stumped???? After a bit more hair tugging I have noted that when the data from any of the three fields I am trying to sum contains a zero then the sum will always equal zero. eg. if field a = 1 and field b = 2 and field c=0 then in my report a+b+c= 0 not 3 as would be expected...

Does access 2003 have any meaningful advantages over access 2000?

I have three reports in a db, all showing the same data but using three different queries to give Current Year data, a variable date selection (using a form) and the final report shows ALL data. The most unusual thing about these reports & associated queries & tables is that one tbl has lots of...

Rich I have repeated the calculations as you suggested, prior to my original post & after, but with no luck. From what I can see I am only getting data from the first txt box. For some reason the other two are not added? Does it make any difference that the data originated from a calculation...

I am having difficulties with a report used to view fertilizer elements. The report is based on a qry in which I have created several fields where the total amount of fertilizer is divided & multiplied to arrive at a %. This works ok. These Text Box fields (percentages) are placed into the...

ekta I have only just noticed your earlier posting. It looks as if you now have what you want anyway. Good luck.

Ekta I assume you mean that you want data for 2004 then next year you will want data only for 2005 & so on... If that is the case you should do as RichO said & base your report on a query. Then add the following to your date field criteria; Between DateSerial(Year(Date()), 1, 1) And...

I have the following set up; 1. A Form to select one parameter in a query and date fields with beginning & end dated using calendars. 2. A report based on the query which the above form provides dates & parameter to. This report has one sub report. When I select a date range on the form the...