473,324 Members | 2,456 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Thanks to Pieter and to Paul

uv
Hi Pieter!
Thanks alot for the help.
Tried to email you directly but wasn't succesful.

I was thinking there should probably be a property of the form that
can
be changed so that it won't update the table automaticaly.

Are you telling me the only way to do that is to unbind the form from
the table and then write the code binding it the way I prefer?

As to my second question, would you happen to know how do I get the
time
from my computer so that I can automaticaly fill the date in my form?

Paul, Thanks, you're tip might come in handy as I don't realy care for
security. My main worry is to fill in as much as I can for the users.

Thank again to both of you,
Yuval
Nov 13 '05 #1
2 1040
> Are you telling me the only way to do that is to unbind the form from
the table and then write the code binding it the way I prefer? Not sure... don't remember the original question...

As to my second question, would you happen to know how do I get the
time
from my computer so that I can automaticaly fill the date in my form?

Now() works real nice <grin> You could set the value of, say, the
record update, in the BeforeUpdate event of the form. Just leave the
datestamp field hidden

Sub Form_BeforeUpdate()
Me.LastUpdated=Now()
End Sub
Nov 13 '05 #2
Yuval

The simplest way to do acieve this is to set the Default Value (for new
records) to Now() in the table design for the appropriate field. Because
access stores the date & time (in the same field) you will effetively have
the date & time 'stamped' against the approrpriate record.

The principle works for Default Values for a text box also. Play around with
the 'Format' property until you have a display you're happy with - you may
also want to consider locking/disabling the text box so users can't
accidently or otherwise alter the data. Again, it's easily beaten but who'd
really bother??
HTH
Paul
"uv" <er******@tau.ac.il> wrote in message
news:23**************************@posting.google.c om...
Hi Pieter!
Thanks alot for the help.
Tried to email you directly but wasn't succesful.

I was thinking there should probably be a property of the form that
can
be changed so that it won't update the table automaticaly.

Are you telling me the only way to do that is to unbind the form from
the table and then write the code binding it the way I prefer?

As to my second question, would you happen to know how do I get the
time
from my computer so that I can automaticaly fill the date in my form?

Paul, Thanks, you're tip might come in handy as I don't realy care for
security. My main worry is to fill in as much as I can for the users.

Thank again to both of you,
Yuval

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: Steve | last post by:
If someone says RTFM, go here... http://www.hudzilla.org/php/index.php <quote> Please read the copyright notice and abide by it. Some day I hope to publish this thing, and that would be...
11
by: Mike Cox | last post by:
After writing an article trashing java, and C++, notable LISP guru Paul Graham is getting roasted on slashdot. Apart from AutoCAD and Emacs, what has LISP done anyway? Most real work is done in...
7
by: beliavsky | last post by:
Paul Graham's recent book "Hackers & Painters" may be interesting readers for Python programmers. He likes flexible languages like Python, although Lisp is his favorite. Here is a quote from his...
235
by: napi | last post by:
I think you would agree with me that a C compiler that directly produces Java Byte Code to be run on any JVM is something that is missing to software programmers so far. With such a tool one could...
6
by: Jim | last post by:
Last year I downloaded a form that can be put in an Acces database that writes SQL text for VB. I have it in an older database but it won't work in my current project. I get an error message...
2
by: PeteZ | last post by:
Can someone help me here. I'm having trouble finding details on how complex objects (eg. an object created in a code behind page that has imbedded object references, collections etc imbedded in...
1
by: Maciek | last post by:
Hi all, I'm desinging a web page and I'm novice in this matters, so I need your help. I need to validate if checkbox is checked and to show an alert if it isn't. So I've added two Paul's...
6
by: Richard Heathfield | last post by:
My recent replies to Paul Hsieh have been unnecessarily inflammatory. His views on C do not even remotely coincide with my own, but nevertheless I should have taken the effort to reply civilly to...
26
by: Ramon F Herrera | last post by:
http://groups.google.com/group/comp.lang.c/browse_frm/thread/86a3ddf0724d9630/4e38340aa824bee0?lnk=gst&q=how+to+best+parse+a+CSV&rnum=1#4e38340aa824bee0 http://tinyurl.com/29q4kf Michael & Paul...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.