i need to run a specific qry that runs from 5th to 5th of every month to show payments made between the dates. i dont want to fill anything in as these dates are set. can a qry be made to run and retrive the info between 5th of last month & 5th of current month automatically ( by the press of a button ) every month?
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)?
This is going to be a dumb question for all you Access experts, but how do I insert a field that will automatically display the date that the record was created (not updated, but created)?
I am trying to create a function whereby when I update a memo field or a field where I put in notes, after I am done, it will automatically put in the current date.
I am putting this form together that involves the user to enter in the current date 2/20/2007 in that format. Is there a script or something i can do in access that will autmatically put the current date in the date field and just update the date as each day changes everyday?
OK, next question. I have a query for my database that asks for all records reviewed on a particular date. I've got it set up so that when I run the query, it will ask me for a date range and then run the query only bringing up the records that meet the date range criteria. I then developed a report from this query and it too asks for a date range when I run the report. My question is this: I hit the button to run my report, the box asks me for a beginning date and then a ending date. I enter the date range and the report runs great. Is there a way that after I put in the date range, that date range will show on my report? Thanks once again for your help.
Example:
NAME OF REPORT 1/12/07 - 1/20/07 (this is the date range I entered)
I've got a form that writes to a database for news articles.
Is it possible to set up Access so it automatilcally inserts the date of when the article was added to the database??? Ideally in the dd/mm/yyyy format.
This might be basic stuff to the more advanced user but its all new to me :)
Hi, Probably this question has been asked before, but I'm new here. Don't know if the question should be asked here and hope that my English is good enough.
I have a database in which I change the content of the records on a regular base. There are two dates in it. One is the day I made/added a new record, one should be the date I made the last change, but I can't get it to work. I have been searching the Help-option in Access as well as Google to find an answer, but so far no results. I don't know anything about Visual Basic, so if you answer please keep it simple.:o
I have a query that allows the user to see how many hours we've flown, sorted by month for the current year.
Problem is that in the query I have to manually put in the criteria "january 2007" or "february 2007" or etc....
What I would like it to be able to do is based on the current year (2007 for instance) set the criteria by itself. Someday I might not be around to reset the year in the criteria so therefore it should be automated.
Anybody have an idea what I'm talking about and a simple solution a hack of a programmer could figure out?
Is there any way I can add the date to come up automatically (i.e. today's date) on a field called 'order date' on my orders form. I currently have an input mask on this table field (i.e. dd/mm/yyyy) if this is any help/hiderance?
I have a date field (WhitesDue) that I want automatically filled in when information in another field (Conditions) in another table is entered. The field Conditions is a number field and depending on the number of conditions determines when the whites are due.
I saw the other thread, Automatic Date Function, and was wondering if it was possible to put an if then code in to have the date updated with different dates depending on the number of conditions and the date that the information is put in. For example if someone is putting information in today and they have 4 conditions then I want the date to be automatically filled in with 8/17/04 (is it possible to factor weekends in too?).
Does that make sense? Can anyone help me out here?
Okay I stepped through some code that I have in the Conditions after update event. It works, it puts the date in the code like it is supposed to. Now, how do I get it to put the date into a field on another form?
If [Conditions] > 3 And [Conditions] < 5 Then [Whites] = Now + 2 ElseIf [Conditions] > 5 Then [Whites] = Now + 4 Else [Whites] = Now + 1 End If
I have a quick question on how to enter the current date in a record automatically when the record is created.
Here is the situation. Say I have a Products table that lists the products that have come into the inventory. There is a field that denotes the day the product was introduced into the inventory. So ideally when the user creates a new record for the product, I would like this field to be populated automatically with the actual date that this filed was created by the user. Note that in future the user may edit the product (i.e other fields in this record), but the entry_date field should not be altered from what it was the first time is was created.
Is there a way I can do this? Any help much appreciated. thanks.
I have a memo field on a form. I am trying to autopopulate it when entered into. For example: I enter in clients info and then tab to the memo field and it automatically enters date and time. Then later when I go back to that same record to append to the memo field it adds the current date. This way I can go back and see all the dates and times when that person called. Any idea how to do this? Thank you
I would like to create a memo field which automatically enters the date prior to any text input from the user. Also allow dated updates in the same field
I have a database that contains 13,772 records and each record contains 34 fields. The database is used for historical research purposes. As I am constantly changing the content in one or more fields I would like to be able to have a field that would show the date of any changes that are made to any of the fields in any given record. Additionally I would like to be able to run a query, lets say every six months and extract all the updated records.
The project I'm working on is an action list with the following tables;
itemnumber - autonumber PK originator - text dateentered - date/time actiondescription - text assignedto - text targetdate - date/time forecastdate - date/time actual date - date/time remarks - text due - text (not sure if this will be correct)
Basically, when a new task is entered, all info will be manually filled in except last 3 fields. targetdate needs to be locked after entry, and forecastdate initially set to targetdate.
"due" should show how many days between dateentered and forecast date, and preferably update everytime the DB is opened. IF the current date is beyond the forecast date, "due" should read "OVERDUE".
Changing forecastdate would obviously reset the "due" field to show how many days left to complete. If a date is entered into actualdate, then "due" should show COMPLETE.
Reports will be generated based on what is coming due, what is over due, and not show what is already complete.
I am in the process of development of a database and one of the functionality that I would like to achieve is a custom ID to become automatic on my 'ADD-CUSTOMER' form (e.g. CID0001 - CID0002) so on an so forth. From my research all I can see in access 2010 is a autonumber which cannot be altered (or at least i don't know how).
I am tying to create a setup application in access. The setup forms are incorporated in the database application.It has to split my database into a FE and BE so that the corresponding files can be placed in thier corresponding files folders automatically. Iam doing this because the database has to be exported to a number of remote locations every after two weeks.
Apart from using the Database Splitter, Could there be any Ideas on how i can split and link my database through code.
I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when entering the sub form, the main record gets saved automatically. First I added the following procedure
Private Sub Form_AfterInsert() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If
Private Sub cmdSave_Click() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If
However, I then realized the after insert function will add the new autonumber to the form. However, it will not saved it to the table until the main record is saved again (which may not happen)
“DoCmd.RunCommand acCmdSaveRecord” doesn’t seems to be working after the “Form_AfterInsert”
Now I moved the code to the “Form_BeforeUpdate” (still testing)
Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy