I have found thyat sometimes I have to save and close a form and reopen it
before some of my coding works. Never have figured out what causes it.
As for your locking, the only thing I could suggest is to repost the part of
your question and see if someone else can help.
Sorry
--
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
"Tom" wrote:
> Thanx, just retried the Now() function and it worked fine, somehow when i
> tried it before I wasn't having any success.
>
> By locking the form, I want to have the data in the table secure and only
> able to amend it if I go back into that record with a password or a
> prompt/alert that the record is about to changed.
>
> Tom
>
> "Cyberwolf" wrote:
>
> > You can use the Now() function in the default value of the date/time field.
> > I am not sure what you mean by locking the form. I will assume that you wan
> > to lock that record after all of the fields are filled in. I am not aware of
> > any way of doing this, but you can set the forms dataentry property to true.
> > This will only allow the record currently being worked to show on the form.
> >
> > HTH
> >
> > Cyberwolf
> > --
> > James Gaylord
> > Finder of Paths, Hunter of Prey
> > Ghost of the Night, Shadow of Day
> > The Wolf
> >
> >
> > "Tom" wrote:
> >
> > > I have a simple table and form to record projects where I manually input the
> > > time and date, followed by a title of the project and then a remark/comment.
> > > I use the table/form within a larger work recording system.
> > >
> > > I would like to be able to have the time and date inserted automatically
> > > from the PC clock and the table/form locked from further amendment on
> > > completion. Basically a simple time/date stamp with comments.
> > >
> > > Tom
|
Similar Threads
