If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date fields - Combo Box and Text box
I am using Windows XP and Access 2000.
I have a form with two date fields. A Combo box and a Text box. How can I make a command button check that these two dates are exactly the same before Saving and closing the form? Thanks in advance for any help. Richard |
#2
|
|||
|
|||
Date fields - Combo Box and Text box
The question that has to be asked here is ***why*** would you want to store
the exact same data in two fields? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Date fields - Combo Box and Text box
Please see my post 3 rows down.
Can anyone answer this question? "Linq Adams via AccessMonster.com" wrote: The question that has to be asked here is ***why*** would you want to store the exact same data in two fields? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com . |
#4
|
|||
|
|||
Date fields - Combo Box and Text box
I've solved the problem myself.
"Richard" wrote: I am using Windows XP and Access 2000. I have a form with two date fields. A Combo box and a Text box. How can I make a command button check that these two dates are exactly the same before Saving and closing the form? Thanks in advance for any help. Richard |
#5
|
|||
|
|||
Date fields - Combo Box and Text box
Be aware that references like "3 rows down" are generally meaningless to
those of us who don't use Microsoft abyssmal web interface to these newsgroups. I, for one, use a NNTP news reader, and Linq posts through AccessMonster. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Richard" wrote in message ... Please see my post 3 rows down. Can anyone answer this question? "Linq Adams via AccessMonster.com" wrote: The question that has to be asked here is ***why*** would you want to store the exact same data in two fields? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com . |
#6
|
|||
|
|||
Date fields - Combo Box and Text box
From what I can glean from your brief postings it seems the text box and the
combo box are bound to fields in different tables, one of which has a date field and the other does not. You want to sort the table without the date field by a date field in the related table. I don't know which record you would use if there are several related records, but in any case it seems having a date field in the main record makes sense. If you don't want to do that, you may be able to sue a DMax expression in a query based on the main table to find the earliest date value in a related record: =DMax("[DateField]","[ChildTable]","[ID] = " & [ID]) This assumes ID is the linking field, and that it is a number field. Richard wrote: I've solved the problem myself. I am using Windows XP and Access 2000. [quoted text clipped - 6 lines] Richard -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
Thread Tools | |
Display Modes | |
|
|