Recreate Issues DB - Report Centre (with Form and not report)

[joycekuo]

Hi Guys

I would like to build a Carpool database from utilising Access’s own web enable Issues database
as a template, but has ran into some problems..

What I am trying to do is to recreate a Report Centre - instead mine will be called Process Centre
to run queried forms within the selected date range criteria.

Following its structure, I have a “Process Centre” form within Main.NavigationSubform, a “Process
Running Hourly” form sits within the Process Centre.sfrReport Page, and a “Process Running Hourly
Main” (sorry not on screenshot. This runs the RunningHourlyCharges query) within the Process
Running Hourly.sfrReport subform.

Currently if I run the date range selection from Main form it returns nothing/blank, and if I am
running the “Process Running Hourly” form in insolation – it gives me the “Macro action BrowseTo
requires a valid Path argument error.

I have double checked the path loaded for macro, but still am not sure where I am going wrong..
Help!!!

Keeping with the Issues DB Structure:




Running form in insolation:


Macro for From and To/Start and End date:


*tmpForm has been preset as "ProcessRunningHourly" at ProcessCentre level as a OnClick
on Running Hourly Charges link.

My final goal is to bring up a selection of records from selected dates, and then build a export
button to 1. export data to Excel and 2. update a status field on original table to Processed.

[ItsMe]

Navigation Controls and Web Forms are above my pay grade. The best advice I can offer is to study how the methods behave that you are employing.

Quote from the following link.

The PathToSubFormControl argument must be specified using the syntax in the following example:

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

Also, my understanding is that the BrowseTo method needs to see the DB or SharePoint server. In other words, it will take a trip to the data. Unlike the Where Clause that will use the existing recordset and NOT take a trip to the data.