<b>making program stop for you to enter date</b>

[bwedmund]

How can I make a program stop and ask me to change the date that is needed?

 

[rhicks]

To make your program pause for user input, you need to build a small form to accept the user input. This form must be opened using the acDialog arugument of the DoCmd.OpenForm method.

DoCmd.OpenForm "YourFormName", , , , , acDialog

Using the acDialog arugment as shown above, in conjunction with your code will cause your code to pause until the form is closed. The code will then resume from that point.

HTH X-)
RDH

Ricky Hicks
rdhicks@mindspring.com

 

[rhicks]

Barry, I receive an email requestist help on this. I tried repling back but got an error the two times I tried. First you sent the db as an Access 2000 db. I use Access 97, so you need to use the feature in Access 2000 to save the db as an Access 97 db before emailing it to me. Also give me the datails of exactly what you are want to do. Also check the email address you sent. I could not reply to the one attached to your message. I will be glad to give you a hand.

RDH |-0

Ricky Hicks
rdhicks@mindspring.com

 

[Rohdem]

you could also use an input box to prompt the user for text data.....

VB code:

dim inputstring as string

inputstring = inputbox("Enter some data now!!!&quot

Mike Rohde
rohdem@marshallengines.com