Hi,
I would like to have current date automatically enter into a form that is
based on a table, so that from report I can tell how many records I have
entered for the day. If I use date() on the data entry form, would I get
the record changing the date whenever I happen to browse the data entry
form? That I don't want to happen.
What is the better way to keep track of the date on each record entering
without manually inputting the date onto the table through form?
Any help is greatly appreciated!
Ste
1  1502 
In your table design on the tab below you can set the default value to
date() for your particular field. Then when you insert a new record the
current date will be entered. This value won't change when you open the
table on another day.
john
"Ste" <sc*****@verizo n.netschreef in bericht
news:e%ici.1416 4$Ar5.9671@trnd ny01...
Hi,
I would like to have current date automatically enter into a form that is
based on a table, so that from report I can tell how many records I have
entered for the day. If I use date() on the data entry form, would I
get the record changing the date whenever I happen to browse the data
entry form? That I don't want to happen.
What is the better way to keep track of the date on each record entering
without manually inputting the date onto the table through form?
Any help is greatly appreciated!
Ste
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jeremy Weiss |
last post by:
I'm trying to build a database that will handle the monthly billing needs of
a small company. I'm charting everything out and here's what I see:
table for customers
sub table to track payments received.
No biggie, right? Well, here's my problem. I don't know how to tell access
to modify everyone's account balance each month. And I can't just always
assume that their monthly bill is $16 just because their balance is $16. If
I do that...
|
by: Dom Boyce |
last post by:
Hi
First up, I am using MS Access 2002.
I have a database which records analyst rating changes for a list of
companies on a daily basis. Unfortunately, the database has been set
up (by my predecessor, I hasten to add) so that each day it creates a
copy of the record for each company, changes the date to today's date,
and prompts the user for any changes of ratings on that day. The
resulting data table grows by approx 600 records per...
|
by: cappelquist |
last post by:
I have a small Task List / Project Management / Time Management app I'm
building for my own use. Any "Getting Things Done" (GTD) users out
there?
I want a main form that has a large List Box on the right side of the
main form that will list Projects by name. In the top right section of
the main form, I want a sub-form that will be a Datasheet format that
will list Tasks for a given Project.
So, I want to be able to Highlight a...
|
by: blyxx86 |
last post by:
I am very new to Access, and have only been using it for a month now. I have learned how to do a lot of things, but have been having problems making a form update a query that then is sent to a report.
Here is what I would like to accomplish...
I have a table that has customers, and another table that has salesperson. I want to link certain salespersons to an individual customer. Also, each salesperson may have more than one customer. ...
|
by: Jo |
last post by:
Hi there,
I'm Jo and it's the first time I've posted here. I'm in process of creating
a database at work and have come a little unstuck.....I'm a bit of a novice
and wondered if anyone could help. I work in a library and send out dual
language books to babies of dual or other nationality.
The db is to be used for logging a range of book titles and numbers ordered
and books sent out to individuals. I am trying to work out a way of...
| | |
by: jverri01 |
last post by:
First, I am relatively new to working with variables. Most of my experience has been with interface design. i am using ACCESS ver. 2003, running in Windows XP.
Second, I spent an hour searching through articles and posts to make sure the information I am seeking is not already posted on the site.
I am beating my head against the wall trying to figure out something that seems like it should be very simple. The trouble is I do not fully...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
