Search results

Good Afternoon. I need to produce a report that will detail the number of records that are found in each query in my DB. For instance... Query Live Projects...........24 records found Query Dave Quotes...........16 records found Query Expired Quotes........21 records found etc etc I will...

Spend about 10 minutes thinking about this problem carefully and then realise that computers, and especially databases are a stressful waste of time. Then go out and get blind druck on Jack D's and screw a prostitute, (if you're a male that is).

Thanks The form is built around the main table and is used to add projects to the database. I just want to display the total value of live projects (from the query I mentioned) on the form. Hope you can help, I've been told I need to use the expression builder in the text box properties in...

Can anyone help please. I have a report based on a standard query. The query extracts all live projects from the database table and displays them along with the total value of the projects. I also need this total to appear in a standard text box on a form that I have set up. Can anyone advise...

I have a report in an Access database which is based on a standard query. On the report I have a total which I get using the formula....... =SUM([Project Value]) This works fine and I get the correct value. Question is I want the same value to appear on a form in my database in a standard...

I have a report in an Access database which is based on a standard query. On the report I have a total which I get using the formula....... =SUM([Project Value]) This works fine and I get the correct value. Question is I want the same value to appear on a form in my...

Good Morning I have a number of reports set up on my database. When the corresponding queries do not find any records for the reports I would like Access to display a message dialog stating that no records were found. I do not want a blank report displayed/printed. Could you advise an easy way...

Thank you I'm not sure which control/object on the form this event should be on. Can you advise please.

This may seem a simple problem but if anyone can help with some VBA code it would be a great help. I have a label on a form in an access database. The form is a data entry form for the main table in the database. One of the fields is a yes/no and appears on the form as a standard check box...