Tom Wickerath...or anyone... Still need help please error

http://www.microsoft.com/office/comm...=en-us&m=1&p=1

If you are still using DoMenuItem, you haven't really learned VBA yet.
What is it you are trying to do?
Trying to read code with DoMenuItem commands is almost impossible to follow.
Who remembers all the various menus?

"justme" wrote:

http://www.microsoft.com/office/comm...=en-us&m=1&p=1

You are correct, Klatuu, I am no good at vba.

My error right now does not have to do with doMenuItem. Tom Wickerath
suggested

Private Sub btnCommentSubmit_Click()
On Error GoTo Err_btnCommentSubmit_Click

Me.CommentDate = Now
Me.Dirty = False

Exit_btnCommentSubmit_Click:
Exit Sub

Err_btnCommentSubmit_Click:
MsgBox Err.Description
Resume Exit_btnCommentSubmit_Click

End Sub

Which is what I am using now, but still having problems. I have a small
pop-up subform. It has only 3 fields:

Style ( text field), Comment Date (General Date Field) and Comment (Memo
field). The style auto populates via open argument function I got from one
of your posts.

The user simply puts in the comment and presses submit button. The submit
button puts in the date, saves the record and closes the popup form. That is
all. The error I am receiving is that

When I click submit, the date goes in the box and the error message comes
up. I
click OK to the message, and then have to cancel out of my form. but when I
go into my table, the comment and date are there just fine.

What error number are you getting?
I notice that there is nothing in your code that closes the pop-up form.
Where do you actually do that?

Sorry, did not intend to demean you. We all start at 0 and work our way up
from there. Sometimes my delivery is more abrupt than it should be. What I
really mean is take the time to learn how to use VBA commands and functions.
They are more powerful and easier to read.

I have my "Function of the Day" routine. It is not really limited to
functions, but I pick out an object, a function, or a command of some kind
and read up on it and then try it out to see how it works.
(You too can learn VBA in Seven Easy Lessons!)


"justme" wrote:

You are correct, Klatuu, I am no good at vba.

My error right now does not have to do with doMenuItem. Tom Wickerath
suggested

Private Sub btnCommentSubmit_Click()
On Error GoTo Err_btnCommentSubmit_Click

Me.CommentDate = Now
Me.Dirty = False

Exit_btnCommentSubmit_Click:
Exit Sub

Err_btnCommentSubmit_Click:
MsgBox Err.Description
Resume Exit_btnCommentSubmit_Click

End Sub

Which is what I am using now, but still having problems. I have a small
pop-up subform. It has only 3 fields:

Style ( text field), Comment Date (General Date Field) and Comment (Memo
field). The style auto populates via open argument function I got from one
of your posts.

The user simply puts in the comment and presses submit button. The submit
button puts in the date, saves the record and closes the popup form. That is
all. The error I am receiving is that

When I click submit, the date goes in the box and the error message comes
up. I
click OK to the message, and then have to cancel out of my form. but when I
go into my table, the comment and date are there just fine.

Sorry to hear that you are still having problems with this. Right now, I'm
not able to provide much help. I've been without power at my home since early
Friday morning last week. I live in the Seattle area; you may have heard on
the news about severe windstorm damage in the Pacific Northwest. I had come
into the office on Saturday evening, to get out of the cold and cook some
dinner in the microwave, which is when I attempted to answer your question
the first time.

You can go ahead and send me a zipped copy of your database, and I will take
a look at it when I get power back. My e-mail address is shown on the bottom
of the contributor's page indicated in my sig. line below. (I'm replying to
this message from my office, where we do have power, but I really cannot
spend normal work hours helping on a newsgroup issue).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"justme" wrote:

http://www.microsoft.com/office/comm...=en-us&m=1&p=1

Klatuu,

No offense was taken. That was not a "pouty" "I am no good at vba" that was
just me stating the truth, so don't worry. I have not had time yet to learn,
as I have been thrown into this project and my boss wants it yesterday. But I
will be taking a class soon. I will also follow your advice.

Anyway, I do need help. This is the last problem to overcome before I
present the database to my boss. Any advice you can offer would be great.
That was my whole sub I posted.

Thanks!

Hey Tom,

So sorry that you are in the middle of all that! I hope you are out of
harm's way and have some heat now.

I appreciate your offer to look at my database, and I will see if I can
strip it down small enough to send. But I understand if you have other
things more important..

Thanks!


"Tom Wickerath" wrote:

Sorry to hear that you are still having problems with this. Right now, I'm
not able to provide much help. I've been without power at my home since early
Friday morning last week. I live in the Seattle area; you may have heard on
the news about severe windstorm damage in the Pacific Northwest. I had come
into the office on Saturday evening, to get out of the cold and cook some
dinner in the microwave, which is when I attempted to answer your question
the first time.

You can go ahead and send me a zipped copy of your database, and I will take
a look at it when I get power back. My e-mail address is shown on the bottom
of the contributor's page indicated in my sig. line below. (I'm replying to
this message from my office, where we do have power, but I really cannot
spend normal work hours helping on a newsgroup issue).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"justme" wrote:

http://www.microsoft.com/office/comm...=en-us&m=1&p=1