Timestamping a record - Microsoft Access / VBA

Johan Opperman

Is there a way to find out when a record has been modified last, that is
automatically updated by Access??
Like an automatic timestamp in the record or so??

Kind regards,

Johan

Nov 12 '05 #1

Subscribe Post Reply

2558

Wayne Morgan

1) Create a date/time field in the table to hold this information

2) In the form used for this table(s) place a textbox (hidden if you wish) and bind it to
this field.

3) In the BeforeUpdate event of the Form, set the value of this new textbox to Now

Example:
Me.txtTimeStamp = Now

--
Wayne Morgan
Microsoft Access MVP
"Johan Opperman" <jo***@opperman.nl> wrote in message news:bn*********@reader08.wxs.nl...

Is there a way to find out when a record has been modified last, that is
automatically updated by Access??
Like an automatic timestamp in the record or so??

Nov 12 '05 #2

Pieter Linden

"Johan Opperman" <jo***@opperman.nl> wrote in message news:<bn*********@reader08.wxs.nl>...

Is there a way to find out when a record has been modified last, that is
automatically updated by Access??
Like an automatic timestamp in the record or so??

Kind regards,

Johan

Not that I know of... if you are modifying your record in a form, you
could update a hidden timestamp field. Otherwise, I think you gotta
use SQL Server...

Nov 12 '05 #3

Similar topics

Get the First record

by: Rick | last post by:

Hi all, Is there a MySQL function to get the first record through a query? I would like to open a page of client records with the first one shown. The other records can be accessed from a...

PHP

New record saved when Refresh clicked

by: Mark | last post by:

I have a working PHP/MySQL application used for data entry. The data entry screen includes a "Save" button. The PHP code for this button looks like this: if (isset($_POST)) { if ($_POST ==...

PHP

input record seperator (equivalent of "$|" of perl)

by: les_ander | last post by:

Hi, I know that i can do readline() from a file object. However, how can I read till a specific seperator? for exmple, if my files are name profession id #

Python

Form Doesn't Go To New Record

by: Steve | last post by:

I have a form with about 25 fields. In the BeforeUpdate event of the form, I have code that sets the default value of each field to its current value. For a new record, I can put the focus in any...

Microsoft Access / VBA

How to synchronize current record in the form with value selected in a combobox ?

by: Zlatko Matiæ | last post by:

There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...

Microsoft Access / VBA

Entering the Record Number in a field?

by: Scott269 | last post by:

So I've got an old MS Works database I imported into Access. I needed a primary key so I created a record number field that was just the record number I manually inserted when I entered it in the...

Microsoft Access / VBA

Taking control of a record

by: Mark Reed | last post by:

Hi All, I have created a multi-user application at work which is working perfectly apart from a small problem which I believe to more a of a user issue (maybe some will set me straight on that...

Microsoft Access / VBA

[SOLVED] how to close td tr after every three mysql record ?

by: khalidbaloch | last post by:

hi : all Friend i am a new member of this comunity as well in php myqsl i want learn that how to dispaly three or two record from a mysql table for example .. mysql table category has 21 columns,...

PHP

Having problem moving out of spurious record

by: prn | last post by:

Hi folks, I've got something that's driving me crazy here. If you don't want to read a long explanation, this is not the post for you. My problematic Access app is a DB for keeping track of...

Microsoft Access / VBA

Wordpress or something else?

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...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware