Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
? 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 :) -- dok112 ------------------------------------------------------------------------ dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581 View this thread: http://www.excelforum.com/showthread...hreadid=478130 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
? about a userform
Hello Dok112, It would help to know what type of database you are working with. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=478130 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
? about a userform
Sorry...it's a Microsoft Access DB -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=47813 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
? about a userform
does anyone have any ideas of how to do this? Any help is GREATL appreciated -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=47813 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform from a Userform Problem | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |