Microsoft Access Expiry Date


I need a script to calculate an expiry date using an integer and an initial date.

I have no experience with coding, but I tried the following code copied from a YouTube video;

"Private Sub date_Post_Change()

Me.date_Exp = Adddate_Exp(Me.date_Post, [login to view URL])

End Sub

Public Function Adddate_Exp(date_Post As Date, txtVal As Integer) As Date

Dim rst As Recordset

Dim db As Database

Dim date_Exp As Date

Dim icount As Integer

End Function"

I attached a screenshot image of the form showing I am getting a result in Time instead of Date.

I need the value in "Validity" to be added to the date in "Post Date" to give the Expiry Date.

Taidot: Microsoft Access

Näytä lisää: how to check microsoft office 2010 expiry date, ms access date functions in query, does microsoft office 2016 expire, microsoft office expired fix, microsoft office expired key, ms access expiry date alert, how to check microsoft office 2016 expiry date, how to check microsoft office expiry date, microsoft access open locked, microsoft access telco database, microsoft access search function code, microsoft access executable, system time microsoft access, microsoft access email harvester, inventory programs using vb6 microsoft access, sending microsoft access reports email, conversion microsoft access sharepoint, microsoft access contact databases, microsoft access image gallery, limiting reportand graph date range microsoft access

Tietoa työnantajasta:
( 0 arvostelua ) St. George's, Grenada

Projektin tunnus: #18872876

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Lisää

$10 USD 0 päivässä
(121 arvostelua)

Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have a very good command over SQL and user interface desgin. Send me more details about the work

$30 USD 1 päivässä
(5 arvostelua)