PC Review


Reply
Thread Tools Rate Thread

Date fields - Combo Box and Text box

 
 
Richard
Guest
Posts: n/a
 
      11th Apr 2010
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
 
Reply With Quote
 
 
 
 
Richard
Guest
Posts: n/a
 
      11th Apr 2010
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
>
> .
>

 
Reply With Quote
 
Richard
Guest
Posts: n/a
 
      12th Apr 2010
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

 
Reply With Quote
 
Douglas J. Steele
Guest
Posts: n/a
 
      12th Apr 2010
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" <(E-Mail Removed)> wrote in message
news:364B2815-DC21-4911-A496-(E-Mail Removed)...
> 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
>>
>> .
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hello i have two fields, one text and the other combo h3llz Microsoft Access Form Coding 2 4th Dec 2008 09:14 AM
Filter Continuous form with 2 combo boxes and 2 text date fields Sierras Microsoft Access Forms 6 20th Nov 2006 02:50 PM
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! =?Utf-8?B?UFNTU0Q=?= Microsoft Excel Worksheet Functions 2 8th Aug 2006 09:31 PM
syntax for combining text fields and formatted date fields; =?Utf-8?B?ZGlyb3M=?= Microsoft Access Queries 1 5th Oct 2005 01:15 PM
Text fields changed to date fields =?Utf-8?B?Z3Vpbm5lc3M0YnJlYWtmYXN0?= Microsoft Excel Misc 4 17th Nov 2004 02:50 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:19 AM.