General :: Automatically Store Expiry Date?
Nov 18, 2013
i need a method to store an expiry date. i have a column prepared in my table but i do not know how to reach the desired result.
the date will always be different depending on certain criteria
the course length. some courses we have are valid for a month. some for 6 months. some for a year and some for only 14 days.
i can use the date add to add the date period to the purchase date but i do not know where or how to store course length to be able to use it.
i have approached this before and i had a column in my courses table as below
("m",3,Date())
i pland on haveing this type for each course and varying it as applicable but this did not work and apparantley i was breaching the fundamental rules of relational data.
View Replies
ADVERTISEMENT
Sep 26, 2006
Hi I am doing a date expiry query which has worked for one of my other queries i have copied the same criteria for another table but for some reason it does not work now
Below is the SQL i am using
SELECT Computers.[Machine ID], Computers.[Machine Type], Computers.User, Computers.Department, Computers.[Installed Applications], Computers.[Serial Tag], Computers.[OS Installed], Computers.[Pc Brought]
FROM Computers
WHERE (((Computers.[Pc Brought]) Between DateAdd("d",30,Date()) And DateAdd("d",-30,Date())));
I have 3 records which are within the criteria but for some reason i do not get these.
Any idea why this does not work but works for my other query
Many thanks
View 2 Replies
View Related
May 25, 2005
I have a issue date and an expiry date feilds,
the below script in my query is to automatically increase the date by one year, this works fine but i would like to be able to back date the script if necassary.
i have checked the properties and the field is not locked. but it wont let me change the date.
any ideas
Expirydate: DateAdd("m",12,[Issueddate])
View 4 Replies
View Related
Jan 23, 2006
Hello, im new to this forum, and i need some help fast.
I have a database which is a list of all of member with some information and an expiry date for there membership. What i would like to be able to do is run a query and for it to search a table and give me the names of the people whos member ship has run out or is going ot run out within a month of the query being run.
I have tried several things already but access isn't realy my thing, i do Visual basic .net .
If any one has any ideas about how i could sort this would you please be able to respond, thanks in advance!
View 5 Replies
View Related
Dec 18, 2012
I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.
View 2 Replies
View Related
Jul 19, 2013
I am creating a database with over 500 entries. One thing that would speed up the process of entering all of this data manually would be if I could type in the birth date and the age would be automatically calculated. Is there any way this can be done? It is all in the same table.
View 1 Replies
View Related
Dec 9, 2013
Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour?
View 7 Replies
View Related
Dec 4, 2014
Is there a way to make access be able to store software versions and product keys automatically? Programs I am most interested in is like Microsoft Office suites and Adobe Acrobat and Photoshop and whatnot like that. I am not sure if this is even possible but I am trying to get my database fully functional with all the data and efficiency I can for at least 5 people so that I can try to sell access as a better tool than the service they are using now.
View 4 Replies
View Related
Nov 20, 2005
Basically, i have a field where the expiry date of a credit card is input, but i want to set an input mask so that it loks something like this:
MM/YY but i cant find a way of doing this!
I then have validation text which makes sure that this value is either equal to or more than todays date! this looks like this:
>=int(now())
So the input mask has to accept this validation...
If you could help, i would be very greatful!
Cheers
View 1 Replies
View Related
Apr 23, 2013
What I am trying to do is create a stock database and iv imported a blank version of the northwind template and filled it in with my own products which is fine up to a point.
What i also have though is i get weekly reports of the stock of each product with their batch numbers, expiry date and quantity remaining for that individual lot sent to me from another company. (So i might have several lines with the same batch number and expiry date but diffeent quantities) So what i want to ask is:
Is there any way for me to combine the data in the weekly reports with the stock level data in the northwind template?
What i want to be able to have is where somehow i can see the total quantity of eac product with the same batch number and expiry date and then it tells me when that batch has expired and it also automatically deducts the stock from my total stock when it gets to within e.g 9 months of the expiry date as we will not likely sell those.
I need to do this as at the moment all i can get from my database is how much stock has been ordered, sold and what we have in total on hand but if the stock is close to expiring then i wouldnt know and i need to be able to see when to order stock in advance as i want a minimum of 6 months cover and ideally 9 months cover as orders for stock dont come in straight away.
Also, how i can import the data from the weekly reports into excel/access easily as they come as word files presented as a table but the data is put in frames i think and iv tried removing them but then it all looks messed up.
View 1 Replies
View Related
Aug 7, 2015
I have a query which shows data about certain checks that are carried out employees. One of the fields is Expiry Date of the check. What I want is for the query to show only records that have a expiry date which has expired or is going to expire within the next three months of today's date. But I cannot work out how to do it!
View 2 Replies
View Related
Jul 12, 2013
I want to have an input mask on an 'Expiry Data' Field so that the input method is 'MON-YY" and I need access to realise it as a data. And then I also need when a user opens a record an anything that is 2 weeks from expiring I need an error message to pop up.
View 1 Replies
View Related
Mar 5, 2014
I have a query call courses and field name expiry date I have add additional field within the query to show how many day left and how many days over the expiry date
Code : DayLeft:[expirydate]-now()
but i just get a error when i run the query
I also would like to ask is this possible to be done within the table e.g adding another field dayleft and some how add formula to calculate number days left or over due .
View 2 Replies
View Related
Aug 7, 2014
I have main form call frmemployee and subform call frmlcourse subform the main form hold's employee information e.g. first name addresss the sub form hold's all the training courses that the employee has been on
I have a text box called txtnextcourse due to display when the next course due date is
Code:
=DMin("Expirydate","tblcourses","[ID]=" & [empID])
this works perfect. I have check box on my subform called ex course if this is true. I don't want the dmin to count that record I have tried
Code:
=DMin("Expirydate","tblcourses","[ID]=" & [empID]) [forms]![frmlcourse subform]![ex course]=false
View 14 Replies
View Related
Aug 18, 2013
I am very new to access and I would like to pull some information from my tables.
I am using this for training records, I can calculate the expiry date of certificates using a query. What I would like is a report (even better an alarm of some sort) to show when things are due to expire. I can't seem to find this option as a report.Also, is it possible to have reports go into excel?
View 3 Replies
View Related
Jul 26, 2015
I have a form (Access 2010) in which i insert contracts; each contract has a start and an expiry date, but instead of dd/mm/yyyy i would like the user to be able to insert just the year, while the day and month are predefined values and they are automatically inserted (i.e. 01/10/yyyy; the year being the only value that changes, and it is manually inserted by the user).
I would like to set a pop up remainder (on form load) x days before the expiry date, but, because too many of them have the same expiry date i am wondering if the reminder can be set on different days, based on another field (i.e. partner location [country]).. i.e. reminder for contracts with Austria to pop up 60 days before expiring, for UK = 67 days and so on.. or even a specific day for each, i.e. for Austria = 01/08/yyyy, for UK 01/09/yyyy).
View 2 Replies
View Related
Nov 17, 2014
I have a task completion database. Each record of model consists of an expiry date. I need to review and update the records before the expiry date. Each model may have more than one record as I have updated the models a couple of times. I would like to select all of records with the expiry date less than 30 days so I can plan to review and update them on time. How to select all these records.
View 2 Replies
View Related
Dec 9, 2014
How can I add 7 days in todays date to store target date in the table?
Code:
ssql = "Insert into tblUpdate([Update_ID],[Date],Username,Status,Target_Date) values('" & j & "',#" & Format(Date, "mm/dd/yyyy") & "#,'" & k & "','Open')"
CurrentDb.Execute ssql, dbFailOnError
View 3 Replies
View Related
Aug 5, 2013
I run a service related company and I am trying to develop a service database that will automatically calculate the next service due based on the previous service date, the catch is that the service need to happen on the same week day. i.e. if the last service was on Friday 02-08-2013 and it is a monthly service, the next service is due on Friday 06-09-2013. Is there any way that this can be done? PS there are various service periods such as bi-weekly, weekly, 2 weekly, monthly, 2 monthly etc.
View 2 Replies
View Related
Mar 3, 2006
Hello, is it possible to temporally store a date from a combo box and display this date in the header of a report? (without having to store in a table)I have a form with 2 combo boxes, one combo where the user selects “from date” and another combo where the user selects an “End date” and a button that loads up a report. I would like to temporally store these 2 dates and display them in the header of the report when the report is loaded by the button.Ideally with either a "to" or a "-" between the dates like this: 25/02/2006 to 03/03/2006Is this possible?, I think I need to a variable to store the date(s) but not sure how to go about this. Anybody kindly point me in the right direction?Thanks
View 2 Replies
View Related
Nov 12, 2013
I have not developed a database application before. At my work I was seconded to fill in as a team lead for a change management team. We are in a production environment and need to track the progress of product improvements. The current system is very complicated using an enormous Excel spreadsheet and a very bid MSProject schedule. It is very handraulic in the way it is maintained.
Before I started I reviewed who inputs data, who uses the data, and what metrics are reported. I can reduce the amount of data that is recorded by only generating many of the existing Excel fields through calculation run when a report is generated or a chart populated.
I need to track the state of several hundred minor changes through the production run. The reference data I need to store is serial number against production batch. This is fixed data that is not changed, only used as to show the entry point of a change into the production line and which serial numbers the change is applied to.
View 3 Replies
View Related
Jul 6, 2013
how could I store files such as PDF inside MS access.
View 1 Replies
View Related
Aug 27, 2013
I have split a few different MS Access databases before with the BE on a shared drive and the FE installed on all users' local machine. In this instance, I have three ODBC connections bringing in data to my tool from an outside database once a day. Is it faster to store the odbc connections on the FE or BE when I split them?
View 2 Replies
View Related
Nov 10, 2013
I am trying to add an attendance records to my database but cannot figure out how best to do it..I already have a 'children' table were all the kids info is stored and have created a 'roll' table.
i want to be able to open a form and search first and/or last name from the 'Children' table, then be able to save both first and last names and the date into the 'Roll' table. (then open reports etc later based on dates)how to pull data from one table and store it in another.
View 3 Replies
View Related
Jul 27, 2013
I have an A2007 database used for time and billing. As time goes on I've had to add more forms and especially more reports. I feel the because of all these "additions" the FE is getting a bit bloated, something like 2.2MB right now.What I want to inquire about is the possibility of moving at least some (if not all) of the forms and reports to another FE and can this be done without having to move tables and/or queries?
The navigation pane is "hidden" from the users so they don't see all the tables, queries, forms and reports but some are smart enough to figure out to "unhide" the navigation pane.Concerning the forms; there are certainly some forms that I do not want other users to open out of curiosity, or for whatever other reasons they might have, so these I would want to move. The same basic reasoning would apply to the reports.
My thinking would be this; move a particular form/report to a separate FE that merely acts as a "bucket" to store the form/report. Clicking on the control in the main FE would open the form/report stored in the other FE using the tables and queries in the main FE.can it be done without having to re-write a bunch of code? I know I can add code so certain controls aren't visible to certain users but I've not found a way to permanently lock and hide the navigation pane.
View 4 Replies
View Related
Apr 30, 2013
I am building a database for a client who manufactures car parts. I have a table to store vehicle model. Each model has a date range of production. I have two build dates from and to. Both of these fields are setup as date fields on the table. I made both fields required with a mask for validation. In the "build date to" field if a car is still in production I need to leave the field blank. Is there any special character that will allow me to store a required field blank.
View 2 Replies
View Related