PC Review


Reply
Thread Tools Rate Thread

date fields in excel user form

 
 
sam
Guest
Posts: n/a
 
      9th Jul 2009

Hi All,
I have created an Excel User form wtih Date fields. Is there a way I can
show calendar popup once the user clicks on any of the Date Text Input
fields? If not, Is there a way I can format the text field such that it
displays and accepts data in this format "mm/dd/yyyy"?? The form input is
then exported to access 2007 DB, So i would want the same to be displayed in
access as well.

Thanks in Advance.
 
Reply With Quote
 
 
 
 
ryguy7272
Guest
Posts: n/a
 
      10th Jul 2009

http://www.rondebruin.nl/calendar.htm
http://www.fontstuff.com/access/acctut09.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"sam" wrote:

> Hi All,
> I have created an Excel User form wtih Date fields. Is there a way I can
> show calendar popup once the user clicks on any of the Date Text Input
> fields? If not, Is there a way I can format the text field such that it
> displays and accepts data in this format "mm/dd/yyyy"?? The form input is
> then exported to access 2007 DB, So i would want the same to be displayed in
> access as well.
>
> Thanks in Advance.

 
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
how to map existing bcm fields to user created fields in the form desertfilm Microsoft Outlook BCM 0 25th Jul 2009 12:16 PM
Date field in user form & Loading a user form on opening workbook Balan Microsoft Excel Programming 1 24th May 2008 03:40 PM
How to move fields in custom form to "user-defined fields in folde austex Microsoft Outlook Contacts 0 9th Jan 2008 11:51 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
Need a code to fill 2 fields in a form with the user date and the =?Utf-8?B?amVhbm5ldHRlX3JpdmVyYQ==?= Microsoft Access Form Coding 1 10th Aug 2005 08:56 PM


Features
 

Advertising
 

Newsgroups
 


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