Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to set field from VBA on Form Save

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  Double wide Task Bar  
Author Message
frank

External


Since: Oct 21, 2009
Posts: 1



(Msg. 1) Posted: Wed Oct 21, 2009 4:24 am
Post subject: How to set field from VBA on Form Save
Archived from groups: microsoft>public>access (more info?)
Hello
I have a data entry form with a label that displays a running timer
hh:mm:ss.
The value displayed on the timer label must be saved to the TimeSpent
field of the table when the form is saved.
How can I set the TimeSpent field in the current unsaved record when
the save button is clicked?

???.TimeSpent = TimerLabel.caption


Thanks

 >> Stay informed about: How to set field from VBA on Form Save 
Back to top
Login to vote
Mark Andrews

External


Since: Nov 30, 2008
Posts: 16



(Msg. 2) Posted: Wed Oct 21, 2009 8:34 am
Post subject: Re: How to set field from VBA on Form Save
Archived from groups: per prev. post (more info?)
Me.TimeSpent = Me.TimerLabel.Caption should work

"frank" wrote in message

> Hello
> I have a data entry form with a label that displays a running timer
> hh:mm:ss.
> The value displayed on the timer label must be saved to the TimeSpent
> field of the table when the form is saved.
> How can I set the TimeSpent field in the current unsaved record when
> the save button is clicked?
>
> ???.TimeSpent = TimerLabel.caption
>
>
> Thanks

 >> Stay informed about: How to set field from VBA on Form Save 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
create a button to save form in pdf - Hello everyone I need to create a button on a form that would save the form in pdf format. I don’t know how to do that? any help will be greatly appreciated. thank you very much

Implementing Save and Cancel command buttons on a form - I am having issues enabling and disabling Save and Cancel buttons on a form in continuous form view. I'm using the Dirty and Current events to enable and disable as the user tabs or clicks through records. (Works fine.) For cancel, I move the focus to..

A Form that leads to a second Form - I have a button on my first form that opens up a second form which has a button on it leading to a third form. I would like the 3rd form to gather the client Name, Phone, ID from the first form. But when I do this I get the 1st record in the database....

save u tube videos - tall women videos filme von leonardo di caprio msn filme schauen videos auf iphone importieren videos schnell uploaden 'bret pitt..

Locking a few field - On a form if i have a tick box 'OrderComplet" I would like some code that will lock the following text boxes if "ORderComplete" is ticked txtOrderNumber txtORderDate txtTotal txtDespatchDAte Thanks
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]