Prev: Go Through Records by ScrollBar Control
Next: Change color on date field in form for re-certification
From: Richard on 11 Apr 2010 15:12
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
From: Linq Adams via AccessMonster.com on 11 Apr 2010 16:09
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

From: Richard on 11 Apr 2010 17:08
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
>
> .
>
From: Richard on 11 Apr 2010 19:56
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
From: Douglas J. Steele on 12 Apr 2010 09:03
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" <Richard(a)discussions.microsoft.com> wrote in message
news:364B2815-DC21-4911-A496-C024A4753588(a)microsoft.com...
> 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
>>
>> .
>>


 |  Next  |  Last
Pages: 1 2
Prev: Go Through Records by ScrollBar Control
Next: Change color on date field in form for re-certification