+ Reply to Thread
Results 1 to 4 of 4

? about a userform

  1. #1
    Forum Contributor
    Join Date
    06-13-2004
    Posts
    120

    ? about a userform

    Quick question for you guys...I have a userform, that has 2 textboxes on it...the user is going to enter a date into both boxes. I need help creating a macro that will connect to a database, and query the db for anything btwn those dates in the specified table. I don't need to copy this info, I just need to temporarily isolate it from the rest. What i'm needing from that data, is to then have a label on the userform that is going to average the scores from those dates.

    IE.
    textbox1.value = 10/01/2001
    textbox2.value = 10/30/2001

    Using these dates, query the table 'Results' for any rows that are within this date range. Then on the userform, I need label1.caption = 'the average of all entries in "Q1" of Table "Results"...'

    anyone have any idea's of how to do this? I really appreciate the help

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Dok112,

    It would help to know what type of database you are working with.

    Sincerely,
    Leith Ross

  3. #3
    Forum Contributor
    Join Date
    06-13-2004
    Posts
    120
    Sorry...it's a Microsoft Access DB.

  4. #4
    Forum Contributor
    Join Date
    06-13-2004
    Posts
    120
    does anyone have any ideas of how to do this? Any help is GREATLY appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1