I am trying to create some sort of warning to show that a date in one of my forms will expire in say 30 days. I need the warning to be a pop up (or similar) rather than be sent via email (only because I don't have Outlook set up and probably will not be able to). Effectively, I have a list of names and a column in my table to show an expiry date. To avoid missing the expiry date, I would like to be advised of this at least 30 days before hand.
I have a "date" field and a "Expire dare" field, what I need is automatically obtain a expire date wich will be the last day on the month of the date field plus 1 year. example date = 15/02/2006 expire data 28/02/2007
I have developed a form and used code to disable the append messages Access displays the user such as: 'You are about to append data, do you want to continue'.
The form works great on my machine and I don't see the messages. When i use it on another machine the messages appear?? Please help.
I have a query and I need the records to display 3 working days before the 15 working day deadline.
I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead.
I have a query and I need the records to display 3 working days before the 15 working day deadline.
I used the following in the criteria box below the received date field and it doesn't pull the correct number of workdays, it's pulling calendar days instead.
I am using workdays to calculate time passed between two dates. I also have a table for Holidays that I don't want counted as work days. This is working well, but I would like my queries to show a null value instead of showing #Error when a date field is empty. Here is my coding in my Module.
Option Compare Database Option Explicit Public Function Workdays(ByRef startDate As Date, _ ByRef endDate As Date, _ Optional ByVal strHolidays As String = "Holidays" _ ) As Integer
I have a data entry form linked to a table that records daily catch details (date, invoice number, buyer, kilos, price, etc). For the last 2 years I've been using the no duplicate index on the date field of the table to prevent duplicates, until he (my husband) decided that he wanted to sell his catch to different buyers on the same date.
I've changed the index to allow duplicates but now I need to create a message box which warns that he is entering a duplicate date as he has a history of trying to enter the same info twice. I've found examples of code that warns on duplicate text entries but nothing for duplicate dates?
What's the formula we can use to calculate days between no of days between date job is open and today's date in a query. I am using formulat below formula but the DATE_OPEN and Today (todays date) pops us as enter parameter value. I dont want those enter parameter windows pops us. The date job is open is in a linked table and linked table is getting the information from BPCS software. The date in Liinked is in format YYYYMMDD.
Total Days: DateDiff("d",[Date_Open],[Today])
The SQL Details are below. AUNPRDF_AAA802 is a linked table and information gets updated on 12 am everyday
SELECT DateDiff("d",[Date_Open],[Today]) AS [Total Days], AUNPRDF_AAA802.AAAGE AS Age, AUNPRDF_AAA802.AAORD AS [Job Number], AUNPRDF_AAA802.AAWKSP AS Workshop, AUNPRDF_AAA802.AASWKT AS WorkType, AUNPRDF_AAA802.AANAME AS [Customer Name], AUNPRDF_AAA802.AANME AS [Service Admin], AUNPRDF_AAA802.AASDE1 AS Complaint,
I have a form where the user enters a date into a field (box 1). Next they select a time frame in days from a drop down (box 2). What I want is for Access to take the date entered from box 1 add the number of days selected from box 2 and place the new (later) date into box 3. From there I can run simple queries. It's for a small data base to track the recall of pacemaker patients.
I enter their appointmet (today) date 1st box and then select whether they should return in 30, 90, or 180 days for a follow up 2nd box. When I choose the interval I want a 3rd box to automatically show their next appointment due date.
I am obviously not an Access expert and I think this should be simple. But 3 cups of coffee and 2 handfuls of my own hair have taken me further from a solution. THANK YOU for looking!!
Is there a way that a DB expire after 30 days? :confused:
I have found some sample DB (see attachment) but it is limited only in a single machine, cause I'm going to distribute my DB on a Network. Can anyone help me how to incorporate this to my DB. Just re-post the the updated DB thanks.
I have a report that displays simple date fields. One of the fields is "lease execution". On the report, I want "lease execution" to display differently depending on the date the report was run.
So:
- If the "lease execution" date is more than 120 days away from today, I want it to display as Q YYYY. - If the "lease execution" date is between 120 and 90 days away from today, I want it to display as MM/YYYY - If the "lease execution" date is 90 days or less away, I want it to display the normal date MM/DD/YYYY
I was thinking I would need to do DateDiff() to figure out an amount of days that's between Now() and [Lease_Execution]. Then based on that amount make the report show it differently. Pseudocode would be: if DateDiff() = 40, then display [lease_execution] as MM/DD/YYYY
I am creating a repayment schedule (as a report) and I want to display a series of fields as a column which return (show) a date one month after the date in the field above.
The first repayment date field (Line 1) will show a date one month after the loan was paid out. the Next field below will show the date one month later.
I can't simply insert the "Date + 30" because that would get out of since over the year. If the loan was issued on say the 15th of January, I need the first field to display 15th February and the next would be .... 15th March.... Yes - You've got it!
Now I could do that in Excel, but I don't know how to get Access to do it.
I would like to create an Expire Indicator field. This field would automatically check against today's date and if the Expiration_Date equals to TODAY, the indicator would automatically be set to YES.
Does anyone know how to create this field in the table?
Hi one and allI am basically trying to do what another member has detailed in this threadhttp://www.access-programmers.co.uk/forums/showthread.php?t=77802&highlight=add+dayswhere someone has suggested another link http://www.access-programmers.co.uk/forums/showthread.php?t=62570which the person states has solved the problem - however it seems this link is dead, perhaps as a result of the site hack.I am sure you can see my question coming like a rabbit in headlights - does anyone know how to do this?!?Basically, I want to add a certain number of days (as specified in a text box-(txtDaysToAdd)) to a date, where weekends and self defined holidays are excluded (I have already set up my tbleHolidays to enter such dates).Any ideas?Thanks in advance
Any way to make the query expired after a defined period but it must remain with that query only not for other queries. Also the query expires should have an option to be alive again or redated for next period after updation means expiry means stop working but not corruption or anything else.
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 need to find the LATEST date in field Recdate that is 45 days or older in a query. I have tried <Date()-45, etc. but it returns all dates not just the last one. Does this require a range of dates to do this ? If not, how would I id the last date input ? Thanks
Hi I have 3 date fields. I am trying to work out number of days when
=[FIELD1 - FIELD2 OR FIELD3]
should do the calculation in field 4 NUMBER OF DAYS. but it comes up with date only. FIELD1 will always be filled, if field 2 is field then the number of days must be based on that. but if field2 is blank then it should be field1 - field 3. I may need a help on the formula does it need any if, else statement or not. If so can someone please help