i have a tbl that stores items that have an expiry. in a child table i want to store the expiry. but as it is different for each item i need a way of doing this.
i thought that by having
DateAdd('m',3,Date()) in one of the fields this would work.
on click event i would like the date add to come into play but the way i am doing it comes up with an error. too few arguments.
this is what i have so far
Code:
Dim rs As DAO.Recordset
Dim db As DAO.Database
Set db = CurrentDb
I am trying to add a certain number of days onto a date field to create a due date within a Table but can't work out how to do it. I know that to add days on I can use the function DateAdd but the only way I can see how to do this is to create and update query to run and add the date on. Is there anyway that I can set the field to automatically update the due date dependent on the priority of the record e.g. immediate (1 day) standard (3 days) and request (28 Days)?
I'm exporting a query from Access to an ASCII text file. It is automatically adding a time stamp (0:00:00) to the end of ALL of my date fields. I would like it if it didn't do this...:D
I have a date picker field in my form that is used as part of a criteria in a query. I also add it as a result field in the query being that it is appending data to a table. But when the query runs it puts weird characters into the query field with expression.
The Expression is as follows:
BillWk: [Forms]![Invoice Form]![WkEnd]
My Criteria is: Between [Forms]![Invoice Form]![WkEnd] And [Forms]![Invoice Form]![WkEnd]-6
I am writing a sports database and have a query that displays a seasons fixture list in a form. One of the fields shows the points from each game played. (either 3 for a win, 1 for a draw etc). I can not get these points to be added up and displayed in a form along side the fixture list.
I have a field named Supplies Expense. As an analyst inputs a business's expenses, it may require multiple entries into this one field. What is the best way to accomplish this?
For example:
Supplies Expense (Field Name) [$0.00]
The analyst has the following data:
2009 Financial Statement Paper $50 Depreciation Expense N/A Ink $100
So, going down the list, the analyst goes into access and enters $50 for paper then later needs to enter $100 for ink.
What is the best way to combine these multiple entries into a single Supplies Expense field and allow for a quality check of the individual numbers at the end of the project?
My database is almost complete. I am just having trouble with adding a a Required Field to the General Section (down below) in my tables. Two of my tables already have the Required Field there with the drop down Yes/No. My other 2 tables to not have one at all? How to sort/group things in Reports?
I have got a a form storing all employee's information and on that form I have a lookup field which looks up all the records in the "Qualification table" and the user can select multple qualifications. What I want to add to the lookup field is a data box so you can select a qualification and then enter the date that it expires (different for expiry date for each employee) How do I do this?
I have added the date field to the qualification table but when I create the lookup field on the form it shows the qualifications and a blank column next to it which data can't be enteed into.
I am looking to add a field to my table with a timestamp for each new entry.
I am working with a split database. All of the records are inputted by forms (in the back end by other users). I want to be able to see the exact time that a record was added, but without having to add this field to the actual form. I just want to be able to have a field in the table that shows me when the user submitted an entry. Is there a way to add an automatic timestamp field to the table?
I have a date and time stamp in a Date/Time field of General Date format (3/1/2006 7:52:25 AM).
I wish to select query on the table's Date/Time field by date portion only (3/1/2006) and not include the time portion (7:52:25 AM) of the field.
Using this expression in the query's criteria - "Between [Enter Start Date: (MM/DD/YY Format)] And [End Date: (MM/DD/YY]" will not return the date ranges as desired without also typing in the full time string.
How can the date integer be parsed out and the query properly expression ed on the criteria field without using VB?
In VBA, how to compare date variable with date/time field from table, as when defined the data type in table, date/time option is the only choice for date data type even though I don't want the time portion.
I am wanting to populate a field by entering a date in another field. I am trying to determine age(years, months, and weeks) of something by entering a date in another field. Is that possible in Access?
I want a field in my table (called 'ContactTotal') that tracks the total number of times the date was changed in the field 'LastContacted' - through either table or a form, but it should exclude any changes made on the same day.
I'd also like a second field (called 'Popularity') that does the same thing, but multiplies any changes made in the last 3 months by 3, the last 3-6 months by 2, the last 12 months by 1 and anything before that by 0.
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.
I have an update query that adds a date to a field which works perfectly but I am wondering if I can get it to check if there is a date there already, if so add another field and put the date in that? Here is my code currently:
Private Sub Command33_Click() Dim t1 As Date t1 = Date CurrentDb.Execute "update tblTest set tblTest.Date2 = #" & t1 & "# WHERE ID = " & Forms!frmSwitchBoard.txtID End Sub
On my form have a status field with about 7 options to choose from a combo box, i have these values set in another table. What i would like is for my other field, which is a date, to automatically change whenever the status field is changed. So i know how long ago the status field was set. So basically if i change the status to complete i want the date to then set the date and time now.
