Rabu, 03 Februari 2016

RE: [MS_AccessPros] Re: general date format

 

Liz


It could very well be that the controls were corrupt or, as you said, locked on the previous settings.

-Bill


---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Bill, I think you got another MS Access bug you can report.  I used the very same fields, went into form design, select fields, added those fields, went into datasheet view, and the new fields show time and the old fields don't. 

I'll swap them out.  I think it locked on to some short time value as a previous value or something.

 

Problem solved.  Thanks.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 02, 2016 2:13 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: general date format

 




Of course, and that is funny.  I can view it in datasheet view and it is the same – date only – no time.  I was in a meeting so am ready to try my experiment.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 02, 2016 1:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: general date format

 



Liz

Have you tried widening the control to see if the time is just hidden?

-Bill



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Hi Bill,  It just shows the date.  I checked the table and there wasn't a format on it.  I don't like to set things at that level – rather at the form level for flexibility.  I'm going to try a couple of things.  1.  Add the fields to the form again, and 2. If that doesn't work, I'll try new fields.

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 02, 2016 12:24 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: general date format

 



Liz

 

Access doesn't show a time if it's midnight (00:00 the default for any given date). 

  1. Are you saying that times other than midnight are not showing?
  2. Does the field in the table have a format on it?

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Pros, I recently changed a form format from short time to general date and it is not showing me the time.

What am I doing wrong?  What simple thing have I possibly missed?

 

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

 

 



 



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.





This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar