473,326 Members | 2,173 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,326 software developers and data experts.

Reoccurring log D/W/M

I have created a database that needs to track certain logs on a daily, weekly
or monthly basis.

my question, how can i have a record automatically created every monday for
example.

fields are simple- Week of, reviewed (yes/no) and notes

so i would like the above fields to be created for my clients log and the
only field that should be populated is the week of.

thank for any help.

--
brandon

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200710/1

Oct 31 '07 #1
1 1201
On Oct 31, 12:49 pm, "bml337 via AccessMonster.com" <u30333@uwe>
wrote:
I have created a database that needs to track certain logs on a daily, weekly
or monthly basis.

my question, how can i have a record automatically created every monday for
example.

fields are simple- Week of, reviewed (yes/no) and notes

so i would like the above fields to be created for my clients log and the
only field that should be populated is the week of.

thank for any help.

--
brandon

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...
I would attack this in a different manner. I would only create a
review record when the user conducts a review and date/time stamp the
review. Then you can query/report/filter on the review records to see
when reviews were performed. If you try to create records say every
monday, you have to control what happens if no one runs the database
on a monday on a given week or even worse for several consecutive
mondays. It is unsound to assume that 'the database is always run on
mondays'.

Oct 31 '07 #2

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

Similar topics

11
by: Tom | last post by:
I have had a reoccurring issue with movement to C# and I was wondering if any C# gurus can give me any suggestions to this problem. Lately I have be running into companies with large c++ code...
27
by: poiuz24 | last post by:
aeh, this may be stupid, but could s.b. please explain to me why the following won't link (gcc 3.3)? foo.cpp = """ namespace foo { int main () { return 0; }
10
by: JS | last post by:
I have a rather long JavaScript in my <HEAD> </HEAD> part. I would like to put this javaScript in another file and then just include it instead. Is that possible and what should files containing...
1
by: David | last post by:
I know that this is an reoccurring issue, but I need to get PHP 5 running under IIS 5.x. This machine hosts a asp.net project, but it also has a few php pages under a sub-domain. The PHP works...
1
by: Alex | last post by:
Acc97.. I have a database which records down-time on 8 machines, the selection of reasons comes from a combo box. I have tried to be clever! and limit the options relative to each machine within...
4
by: KnightKnives | last post by:
Is there anyone out there who could help me find the resources I need in order to make this application. I have done a lot of work with 2.0 engine then upgraded to 97; now have 2003. I have...
0
by: Joachim | last post by:
I have, in order, installed MS Visual Studio 6, MS Visual Studio .NET and MS Visual Studio 6 SP 6. After installing MSVS SP6 I frequently get the following errors when compiling my projects ...
3
by: winterjunkie | last post by:
Does anyone know where I can buy a Cold Fusion calendar that has all the bells and whistles? I have a client that needs a calendar they will be using very frequently, and will have a lot of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.