Topics Search

Automatically general date when another field is written to

Automatically general date when another field is written to
Views: 39
apologies if this is in the wrong section.

I've created a field and set the type to general date.

What I want to do is have access insert the date when a certain other field is written to. The other field is called notice. When I have written my message in this field, I want access to get the date andtime from the clock and insert it in the date field. I want to do this as in the future I wish to write to the notice field from a website (connected to database via odbc), and when that data is added, I want access to add the additional info to the date field.
Sponsored Links:

More topics


Creating a general date from a short date and my own time stamp?

I need to create a general date field that takes my field [LogDate] and adds 9am to it (i.e 9:00:00), so that it basically shows 9am of whatever date it happens to be for that row, such as '12/03/2011 9:00:00'. I've tried but it only outputs as a string. Is there a function that I can use to put these together?

Autoinsert of variable data into update query

I have several update queries that I would like to automate the Date field to today's date and the "UpdatedBy" field to the person who's logged in "GUserName."

When a person logs in, his name is written to a global variable "GUserName" so that the system can update records automatically with that user's name. This works perfectly on all the forms.

I have written a number of update queries where I'd like to update the tables with new values and at the same time update the "UpdatedBy" field and the "ModfiedDate" field with the values from "GUserName" and today's date respectively.

Every time I try something, I only get a pop-up parameter input box instead of the system automatically inserting the value and moving on.

How to use Input mask for general date with milliseconds added

I am having a problem creating this input mask wizard for the following general date format:

1) 12/11/2011 09:33:46.240
the general date I use needs to be changed:

1) 00/00/0000\ 00:00:00\ >\ LL;0;#

Changing date to date with time

I currently have a report generating a date field that lists date only. I changed the format for the data type for the field in the table to General Date and tried changing the input mask for the field in the design view of the report to show the time, but it is still only printing the date.

Date Not Displaying Correctly on Access Form

I have a date field that when I use the date picker, it shows the date correctly but the minute I click out of the field, the date is converted into a different format. For example, 10/11/11 is converted to 40827. In the datasheet the field is set up as a Date/Time data type with a General Date format. Several of my other fields are set up the same way and work correctly but for some reason this field won't behave. It looks correct in the datasheet

Adding multiple data to one field

I would like to be able to have the date written in to a field when another field is updated. Pretty simple, however, there are circumstances that this field could be updated as many as 6 times. I will have to build a query that will search this field for specific dates so I can count them. I need to keep on file each added instance and not just the latest update date. I had thought of using the field being updated and adding Now to it to get a value, and then should there be another update I could simply take the value from the field and the new date (updates will never be done more than once on a given date). Not sure if this is the best idea or if there is a much simpler path

Bound Date/Time field to automatically display the current date

I have a bound form which has a field called WorkDate which I would like to default to todays also still needs to be able to be changed to a different date. I have tried inserting =Date() in the On Load event of the
Bound Worked Date field, but no luck.the picker is still just sitting there with nothing in the field.

automatically having a field filled in based on another field's criteria

Within a table, I have a field named date and a field named qtr. On the form, I want to automatically fill in the qtr field based on the date field. for ex: if date=>01/01/2010 and date=04/01/2010 and date =

How to create a custom autonumber

I have a table where I want to genrate the contactID automatically. The format is HS+mmyy+serialnumber I.e HS is the prefix for all the contactIDs followed the month and year followed by the serial number. so if a contact is introduced today as the 2nd contact for the month, the ContactID would be HS0810002.

2. I also have an age field which I want to be calculated from the date of birth.
3. I have another field in which I want to store the date exactly one year from the date of birth field
4. Also, I want to add a date field which is automatically filled in with today's date.

I hope all these are quite clear and related

changing date automatically in a table field

I have a table of customers and dates when their orders were placed. Is their a way of having a field within said table that shows the order date plus 3 weeks (ie when the order is due for delivery). It would be good if this can be done automatically as soon as the first date is entered in the first field without the operator having to do anything