Search results for query: *

Hello I am using MS Access 2003 I have used a Pivot Table 11.0 Active X object within eight subreports that are linked to a Main Report using the same Master/Child Link Field: SellerNumber I am trying to find a way to use VBA to refresh several subreports within a Main report which each...

HELP! Using CR v10 I have tried to sum a formula that calculate the percentage of dollars in each Group - this formula is located GF 2. I need to accumulate (sum) these percentages calculated by the formula ({@O/S % of Total} to display in GF 1 as the Grand Total of the accumulated...

HELP! Using CR v10 I have tried to sum a formula that calculate the percentage of dollars in each Group - this formula is located GF 2. I need to accumulate (sum) these percentages calculated by the formula ({@O/S % of Total} to display in GF 1 as the Grand Total of the accumulated...

For whatever reason I am still not able to get this to work. I am using Windows 2000 and I am logged on as as user with Administrator rights. Using task scheduler I am trying to launch a macro called "mcrTestMacro" located in MS Access mdb file "C:Test\Test.mdb". I am able...

Does anyone have any documentation about using Windows Task Scheduler to launch a MS Access macro? What is the syntax / or pathing needed to accomplish this. I cannot find ANY documentation on this matter. I have done this before and I seem to remember the path was somthing like...

Is there a simple way to determine the name of the currently open Query (select query) and then close it on the on_click event of a command button?

Does anyone have any guidance about how to hook up a command button to send the Open query's result set to a printer?

Does anyone know a simple way to convert seconds to hh:mm:ss format. Access doesn't have a native Mod() function so I am finding this seemingly simple task to be very challenging. Any ideas would be appreciated. Thank you.

Does anyone know if there is a simple way to test to see if a query object exists before running a Docmd.DeleteObject piece of code to delete the query?

This is a real newbie question I have a form with 2 textboxes 1)start date 2) end Date for a report date range. A valid start and end date needs to be entered before the underlying report generation macro can function properly. I am trying to test for a valid date in each text box and throw up...

Ido, I did try what you suggested the "whileprinting..." formula and I didn't have any luck. I placed the date field in the detail section and the formula in the group header and then in the detail section. Nothing (no date) appears when I print out the report. Anything else I should...

Still unable to get this Max Date issue resolved. It is the last issue I have with this particular report. I reread prior posts and tried putting the Date field in the Detail section then creating a running total on this date field for every change in userid. No Luck with that either...

Thanks that did the trick! You're the greatest!

Does anyone know how to dynamically update a Report Title with the Date Range used for the Report Parameters? I am creating a report with a date range parameter (report date is a date range, not a discrete value) which I would like to display in the Report's Title.

No such luck getting this Maximum({Closed.date}) to work and also a Maximum({Closed.Date},{Userid}) with no luck. This is proving to be my biggest challenge!

I am trying to retrieve the latest/last date from a table which could have multiple records for a given user in it. I just want to display only one date on the report, the last date of contact by the user. I tried doing a Summary using a Max filter on the date field to no avail. Any ideas...

I was able to get a Count of Total Help Desk tickets by userid using this formula: DistinctCount({Change_Order.chg_ref_num},{Change_Order.requestor}) where requestor = userid and chg_ref_num = TicketNo But I have not been able to get the count of the Closed tickets to work. I am checking to...

I am trying to create a report that lists the Top 20 Users with the most Help Desk Tickets, then break that number into # of Open and # of Closed Tickets. I am unable to get distinctcount or count to give me a simple aggregate number (i.e. Count of Help desk Tickets by Userid, count of Help...

Does this help? One way I have been able to troubleshoot dynamically modifiying excel charts in code is to create an excel macro as I perform the chart modification. I then open up the macro and copy excel vba into Access with usually only slight modifications needed to get it to work in Access...

I am trying to set the backcolor/forecolor property for four textboxes on a form based upon the whether different combinations of the textboxes currently contain data (is not null) I hooked this event to the Form's OnCurrent event. Stepping through my code the conditional statements correctly...