Re: Now works, Date doesn't?
- From: AllYourSpam <AllYourSpam@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 May 2009 11:58:09 -0700
Sorry it has taken a few days to get back.
Insinuate away, the truth is the truth. I am a low intermediate level
designer/user in Access but I have a great understanding of the basics and
years of experience in FileMaker, even from when they were Claris (but that’s
probably not saying much). I inherited the database we work in, and it is
definitely NOT properly normalized. I have fixed as much as I can without it
being totally unstable. For as bad as it is, I can’t believe how much we can
actually make it do!
I have been churning on version 2 for a while but database work is only
1/10th of my duties, and I don’t get the focus time required to design and
test a new version.
The only time I have ever made changes to a dll file was when I tried to add
a Redemption file so Access could better utilize Outlook. Honestly, that was
the worst mistake I made, I have had nothing but problems since. As of today
I have a new computer, so maybe that will help.
Regarding minimizing corruption, after reading many different entries on
this and other forums, I have done some things, like turning off Name
AutoCorrect, prevent auto indexes, compact & repair on close, etc, but if you
have a recommended list I am always open; call me student, Mr. Meogy. All
help is appreciated.
I have not thought about a date button, I’ll see about incorporating your
suggestion.
Thanks
CAS
"Jack Leach" wrote:
.I guess what I'd really like is to have Rich Text format and
still use the date shortcut (Ctrl;), but I have not been able to use them
together.
Have you considered a small 'Today' button on the side of your memo control
that will add the date for you? Something like...
Private Sub btnToday_Click()
Me.MemoField.SetFocus
Me.MemoField.Text = Me.MemoField.Text & " " & Date()
End Sub
--
Jack Leach
www.tristatemachine.com
"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
"AllYourSpam" wrote:
Thank you. Thank you to all!
Here is what happened, because I tried each solution -
Adams: Did not work - the field froze and could not be updated.
Vinson: Did not work at all. The code turned red with a syntax error
Steele: Worked but in a Rich Text format it adds a return so comments move
to the next line down.
I am convinced there is something wrong with my computer (see my earlier
comments on this post) because today, the date function works properly!
After all this, I guess what I'd really like is to have Rich Text format and
still use the date shortcut (Ctrl;), but I have not been able to use them
together.
Has anyone else had this situation? Or is it my computer? If it is not my
computer, can it be fixed - can the shortcut be used with Rich Text?
"John W. Vinson" wrote:
On Fri, 01 May 2009 01:18:57 GMT, "Linq Adams via AccessMonster.com"
<u28780@uwe> wrote:
What happens if you try using
Me.Comments = DatePart("m",Now)& "/" & DatePart("d",Now) & "/" & DatePart
("yyyy",Now) & " - " & [Comments]
Or just
Me.Comments = Format(Date("mm/dd/yyyy") & " - " & Me.Comments
--
John W. Vinson [MVP]
- References:
- RE: Now works, Date doesn't?
- From: AllYourSpam
- RE: Now works, Date doesn't?
- From: Linq Adams via AccessMonster.com
- Re: Now works, Date doesn't?
- From: John W . Vinson
- Re: Now works, Date doesn't?
- From: AllYourSpam
- Re: Now works, Date doesn't?
- From: Jack Leach
- RE: Now works, Date doesn't?
- Prev by Date: Re: refresh excell
- Next by Date: Re: Receipt Printer Autocut
- Previous by thread: Re: Now works, Date doesn't?
- Next by thread: Re: Now works, Date doesn't?
- Index(es):
Relevant Pages
|
