? about a userform

  • Thread starter Thread starter dok112
  • Start date Start date
D

dok112

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
:)
 
Hello Dok112,

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

Sincerely,
Leith Ross
 
does anyone have any ideas of how to do this? Any help is GREATL
appreciated
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
Sum numbers in userform 8
Firing Event in another user form 1
userform textbox returns changeable date 4
Initializing Userform not working 4
Date showing as numbers in Textbox on Userform 2
Userform 1
How to transfer the data from userform to spreadsheet for specific dates 0

Back
Top