Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

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

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

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.


Ricky Hicks

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

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.


Ricky Hicks

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

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!!!")

Mike Rohde

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close