System update message Board - Microsoft Access / VBA

malvina shagabayeva

I need to set up a system that will keep track of my daily updates in
the DB. I would like the user to see a message after opening the
database, that would display that the last update was done on #date#.
Any suggestions will be greatly appreciated.

Malvina S
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #1

Subscribe Post Reply

1465

PC Datasheet

You need a table to store the last update date. Then when an update occurs, you
either need to add a new record for the new update date or edit the update date
that is there. Presuming that your database opens to a specific form, put this
code in that form's OnOpen event:
MsgBox "The Database Was Last Updated On " _
& DMax("[UpdateDate]","TblUpdateDate")
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"malvina shagabayeva" <ma*****************@hewitt.com> wrote in message
news:40***********************@news.frii.net...

I need to set up a system that will keep track of my daily updates in
the DB. I would like the user to see a message after opening the
database, that would display that the last update was done on #date#.
Any suggestions will be greatly appreciated.

Malvina S
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

Similar topics

A simple message board?

by: delisonews | last post by:

I'm looking for a simple, filesystem-based message board. (No MySQL!) Something that I could include easily in my code: include '../inc/messageboard.php'; .... so that the board shows up at...

PHP

Good Family Portal System?

by: Kirk Larsen | last post by:

Here's what I want: 1. Simplicity. I basically want to be able to post news on the front page, similar to a blog. 2. Good Image Gallery. I would like something that is simple to navigate...

ASP / Active Server Pages

Looking for a php content management system

by: Epetruk | last post by:

Hello all, I'm sorry for the long post, but I think it's better if I'm as detailed as I can be so that I don't make a mistake in my choice and so that there's a clear understanding of to what...

PHP

Displaying System RAM in c#

by: Jonny | last post by:

How do I display the system RAM in C# ?? Do I have to get it from the Registry or is there a function for it? If so how?? Thanks /Jonny

C# / C Sharp

Content Management System question

by: Jon | last post by:

All, I'm currently building sites for a fairly small dev shop, and we've run into a subject that we simply don't know where to take. So, here we go: We have built all of our sites statically...

PHP

Sending E-Mails from ASP.NET 2.0 page using System.Net.Mail

by: Eric Sheu | last post by:

Greetings, I have been searching the web like mad for a solution to my SMTP problem. I am using Windows Server 2003 and ASP.NET 2.0 w/ C# to send out e-mails from a web site I have created to...

ASP.NET

C# bulletin board system

by: Jason Huang | last post by:

Hi, I would like to build up a web bulletin board by using C#. But my schedule is quite busy, and I'm not familiar with the C# web form. So, I'm thinking is there any C# based free ware I can...

C# / C Sharp

Bulletin board system help

by: soramaster | last post by:

I'm coding a BB system and I need help with one thing. How do I make it where my board can use themes? Also if I need to post the code I don't know what to post ...

PHP

Request for the permission of type 'System.Web.AspNetHostingPermission...'failed

by: clintonb | last post by:

I hope this is the appropriate group for my question. We have a Web Application Project that compiles just fine using Visual Studio 2005 on Windows XP but it won't compile on Windows Vista. ...

ASP.NET

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

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

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

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

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing