Search results

HasData seemed to work for this. Here is what I used, in case someone else has the problem. In the control soure for text box I used this =(IIF([PURCHASES].Report.HasData,[PURCHASES].Report.[Text8],0)+([WorkHours]*[BillingRate])) PURCHASE IS THE subreport Text 8 is the box in the subreport...

Very new to creating databases so VBA is new to me also. Wouldn't have a clue where to start. I will look into find some code for storing the value. Thank you for the assistance.

I have a report with a subreport. The Report is called Invoices and the subReport is called Purchases. In the subreport I have a filed that shows Amount. It can contain several rows if there were more than one purchase. so in the subreport footer I have a text box with control source =Sum...

Thanks, changing the contro source worked great. Took me a second to find it but I did. Appreciate the help.

I have a report that comes from the fields in a form. I created a query which allows me to pull only certain records with in a date range. I then created a form based on the query so I could then create a report for the dates I used. Is there a way to take an existing report and change which...

Got it working. Thanks a lot. Greatly appreciate the help.

Worked like a charm. Thanks. I never noticed that button before. Does that have to be clicked every time or just once. Thanks again

I have a database that works fine on access 2000. The problem is that when I open it in Access 2007 the switchboard does not display correctly and my command buttons do not work. Also, my field that autofill from a combo box do not fill in. I am assuming that access 2007 does not recognize...

this is very close to what I want. I may need to change my tables a little. I really want to set up the report to include the name and address of the property and the name of the employee. I wan the items in my query to be in the report. I may need to change the table to include these. I am...

Here is the database. On the enter workorder I am wanting to add a button to preview a report that draws the current info. I set up a query for this, but when I do a report it places all of the work orders in the body of the report. I erased the report, due to frustration. Thanks for any help

I have a very simple database that allows you to enter a workorder, it auto numers the workorder, select the property (by combobox), select employee (by combo box), date, desription of work, and unit number. I am wanting to add a button to the form that pulls up a report. the problem is not...

I work for a property management compnay and they have put me in charge of coming up with a way to go some what paperless. What they are wanting is a way to enter a work order for a particular client (i.e description of work to be done for maintenance). This would then need to be printed in a...