Recent content by eddyfuente

Yes, 2 of the sub reports use parameter queries... Do you think the parameter query cannot prompt? Could it be that even from print preview it is expecting to retrieve parameters?

Thanks for the quick response GinaWhipp, Unfortunately, the fun ended quickly. I got the same results. I get blank excel sheets weather it is on the network or local drives. BTW, I also created a trusted location (locally) and and exported to the folder and although the files is no longer in...

My report (rptBilling_STS_Summary) has three subreports (rptBilling_STS_Summary_Install, rptBilling_STS_Summary_Rental, rptBilling_STS_Summary_LDRate) that return values that are grouped by customer and calculates a total for each customer. I need the report to export to excel for our client...

Thanks for the response... It's not an issue of null values because they are calculated in the queries. The issue is my subforms are based on different queries and when I bring them into the main form I cannot total those values. The values from the subforms are grouped by customer in the main...

This Works: I have a report with subreports that provide totals to the main report. The main report is grouped to provide the totals by customer. Here is the format: Customer Labor Materials LineTotal Cust1 $100 $10 $110 Cust2 $200 $20 $120...

I am creating a database and ran into an issue I do not know how to resolve. I created a datasheet form (frmMSRSubRecords) and based one combo box (cboPartNo) on another(cboCategory). The cboPartNo field is bound to a materials tables (frmMaterialRecords) and automatically updates other fields...

Sorry, forgot to mention the "[Forms]![frmDept]![cboDept]" shows up in the Enter Parameter Value form...

Hey all, Hope you can help. I have a database with one table with 5 fields: Table = TimeOffRequest field 1 = Record No field 2 = Department field 3 = Employee Name field 4 = Date of Request field 5 = Requested Date I'm running a parameter query based on the departments (qryDept) which...

Hi All, Newbie in a little predicament here and could really use some assistance. I created a small database to keep track of everyone’s time off requests and it has slowly grown to include approval time stamps by different levels of management. The time stamp(s) are created via a command...