Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Enter Parameter Prompt


Message #1 by "Adeyemi Ajao" <adeyemiajao@h...> on Wed, 23 Jan 2002 22:22:09 +0000
Dear sirs,



I get prompted for a parameter when i do not expect it in running reports.



I used the function =Format(Date(),"mmm")to get the month part of system 

date in text format.



The application work fine on the system I used originally, but when copied 

to other systems the prompt to enter parameter for Format and Date is always 

displayed.



I need assistance please !!!.



Sincerely,

Yemi Ajao





_________________________________________________________________

Join the world?s largest e-mail service with MSN Hotmail. 

http://www.hotmail.com



Message #2 by "A. van Huizen" <ajvhzn@p...> on Wed, 23 Jan 2002 23:37:13 +0100
I've had this too.

Check your references in the VB editor (Tools -> References) and check

for Missing one's.



MSCAL.OCX is a famous one! 





Regards,

Arjan





-----Original Message-----

From: Adeyemi Ajao [mailto:adeyemiajao@h...] 

Sent: woensdag 23 januari 2002 23:22

To: Access

Subject: [access] Enter Parameter Prompt





Dear sirs,



I get prompted for a parameter when i do not expect it in running

reports.



I used the function =Format(Date(),"mmm")to get the month part of system



date in text format.



The application work fine on the system I used originally, but when

copied 

to other systems the prompt to enter parameter for Format and Date is

always 

displayed.



I need assistance please !!!.



Sincerely,

Yemi Ajao





_________________________________________________________________

Join the world's largest e-mail service with MSN Hotmail. 

http://www.hotmail.com













  Return to Index