Create an Access Table that "auto-Populates" with Dates
$10-30 USD
Completed
Posted about 7 years ago
$10-30 USD
Paid on delivery
I need a table that will “auto-populate” with dates (Months) based on some input by the user. The table will have four fields: AutoNumber, PID Number, Month and Year.
The user will Select a PID. The PID (Proposal Number) will already exist in another Table.
In a Field on a Form, Query… the User will enter a Start Date and Number of months
What I need, in the Month Field, is the aforementioned Date plus 1 (the equivalent of one Month)
Example: If the User entered January 01, 2017 the first Month record would be 2/1/2017
In the Year field, I need the Equivalent Year of the Month in the same record (i.e. 1/1/17 would be 2017)
The User must be able to go back and make changes to the Start date and the number of years. I would assume it would have to back to the table and find and replace the records for the Assigned PID.
PID: Z00026A-APCH-NF-1701
Start: 1/1/2017
Number of Months: 60
Record One would be:
1, Z00026A-APCH-NF-1701, 2/1/2017, 2017
Record Two would be:
2, Z00026A-APCH-NF-1701, 3/1/2017, 2017
And so on until there are Sixty records.
Need someone who can think outside the Box.
Hi,
I'm a professional Microsoft Access and VBA developer with strong background in developing and modeling information systems using Ms Access. I have read your project description and would like to help you fulfilling your needs. I have done similar projects before, check my profile for details.
I'm looking forward to hearing from you.
Regards,
Hello, dear sir!
I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
Hi,
clear requirements. I am starting a sample.
windows application.
simple forms.
access database (2016)
please initiate a chat to discuss further.
Thanks
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, Access. I can create auto scripts to scrape websites, format txt, csv, xls, xlsx, doc, docx, database files as you request. I can start right now
Hi.. I am a C# .net developer.. I have expertise in manipulating tables of Access using C# which is a windows form application. I have read the description and will be able to do the task.. We can discuss more over chat..
Looking forward to work with you..
I will create access based application for you and if you want i convert access db into exe for your database security..
Once you share your exact requirement with me then i will give you some more suggestions to automate your entire process.. And this access application can generate customized reports as per your requirement.