A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Parameter Form



 
 
Thread Tools Display Modes
  #1  
Old October 6th, 2004, 01:26 AM
Murray
external usenet poster
 
Posts: n/a
Default 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  
Old October 6th, 2004, 10:05 AM
Brian
external usenet poster
 
Posts: n/a
Default

"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  
Old October 6th, 2004, 11:43 AM
GrouchyMedic
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.