If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Parameter Form
I have tried for the last 2 weeks to get a parameter form
to open from a report to enter queries for 'StartDate' and 'EndDate' without success. I have followed and refollowed the article at Office Assistance (HA011170771033.aspx but with each attempt to open the report I am shuttled to VBA and the identifier 'IsLoaded' is highlighted with the msgbox stating the sub or procedure is not identified. When I try checking the identity I am messaged that 'IsLoaded' is not recognized. Now here is the rub, I can make it work in the sample data base by deleting the form and report and then creating the form and copying a fresh report and setting the controls but never never in my very on database. HELP! |
#2
|
|||
|
|||
"Murray" wrote in message
... I have tried for the last 2 weeks to get a parameter form to open from a report to enter queries for 'StartDate' and 'EndDate' without success. I have followed and refollowed the article at Office Assistance (HA011170771033.aspx but with each attempt to open the report I am shuttled to VBA and the identifier 'IsLoaded' is highlighted with the msgbox stating the sub or procedure is not identified. When I try checking the identity I am messaged that 'IsLoaded' is not recognized. Now here is the rub, I can make it work in the sample data base by deleting the form and report and then creating the form and copying a fresh report and setting the controls but never never in my very on database. HELP! From Access 2002 Help: "I get a "Sub or Function not defined" message when I try to use the IsLoaded function. The IsLoaded function is a sample Function procedure included with the Northwind sample database, and not a built-in Microsoft Visual Basic function. To use the IsLoaded function in your database, you must copy it to your database." |
#3
|
|||
|
|||
Thanks Brian, I'll give it a try.
"Brian" wrote: "Murray" wrote in message ... I have tried for the last 2 weeks to get a parameter form to open from a report to enter queries for 'StartDate' and 'EndDate' without success. I have followed and refollowed the article at Office Assistance (HA011170771033.aspx but with each attempt to open the report I am shuttled to VBA and the identifier 'IsLoaded' is highlighted with the msgbox stating the sub or procedure is not identified. When I try checking the identity I am messaged that 'IsLoaded' is not recognized. Now here is the rub, I can make it work in the sample data base by deleting the form and report and then creating the form and copying a fresh report and setting the controls but never never in my very on database. HELP! From Access 2002 Help: "I get a "Sub or Function not defined" message when I try to use the IsLoaded function. The IsLoaded function is a sample Function procedure included with the Northwind sample database, and not a built-in Microsoft Visual Basic function. To use the IsLoaded function in your database, you must copy it to your database." |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
Taking form value and displaying on report | Drew | Setting Up & Running Reports | 4 | August 19th, 2004 06:04 PM |
6 Tables, 1 Report, W/O 6 Qrys | Andy | Setting Up & Running Reports | 9 | June 29th, 2004 09:52 PM |
Creating a report from a form | Kristin | Setting Up & Running Reports | 7 | June 28th, 2004 09:21 PM |