DB27378554.mdb

<div>
I used LSMConsulting's second answer, because it was extremely clear, could be lifted straight into my database (with the necessary alterations to names) and did exactly what I wanted - almost. &nbsp;One problem I had was that the date format was unreliable - it would add the ten entries, but two out of three would be formatted for US, and I live in Australia; however, I solved that problem by using
<blockquote>
 format(datInsert, &quot;mm/dd/yyyy&quot;)
</blockquote>
 from kmslogic's answer, and fixing that for Australia as dd/mm/yyyy.<br />
The other good point about LMSConsulting was that s/he asked the question at the end &quot;Do you know how to add code to a Button's click event?&quot; which was enough of a prompt for me to ba able to work it out. &nbsp;Thank you.<br />
<br />
Als315 and fyed gave solutions that I could see where they were heading, but couldn't quite work out how to use them.
</div>


<div>
<div class="content wysiwyg-content">
I have a table/query/form with the following record:-<br />
customerID<br />
Jobid<br />
Date<br />
&nbsp;I provide service to the customer at regular intervals - weekly, fortnightly, monthly - over the course of a year<br />
I want to be able to generate a series of new RECORDS by adding to the date<br />
<br />
I want to be able to fill in the initial details then tell it to add a specific number of days (maybe 7, 14, or 28, or something else altogether) to the date, and to do this a specified number of times.<br />
I thought I might have found an answer, but I seem to have lost it.<br />
I would expect to need two additional fields, Frequency and No of Times, and perhaps an append query, but I just cannot get my head around it.<br />
<br />
Most answers are about two date fields (startdate/Enddate) and adding to the first to generate the latter. &nbsp;Also, they assume that the interval will be constant (always add 7 dayes).This doesn't do what I want.<br />
<br />
Can It be done? &nbsp;I am an amateur when it comes to VBA.
</div>
</div>


I have a table/query/form with the following record:-
customerID
Jobid
Date
 I provide service to the customer at regular intervals - weekly, fortnightly, monthly - over the course of a year
I want to be able to generate a series of new RECORDS by adding to the date

I want to be able to fill in the initial details then tell it to add a specific number of days (maybe 7, 14, or 28, or something else altogether) to the date, and to do this a specified number of times.
I thought I might have found an answer, but I seem to have lost it.
I would expect to need two additional fields, Frequency and No of Times, and perhaps an append query, but I just cannot get my head around it.

Most answers are about two date fields (startdate/Enddate) and adding to the first to generate the latter.  Also, they assume that the interval will be constant (always add 7 dayes).This doesn't do what I want.

Can It be done?  I am an amateur when it comes to VBA.

adding new records with dates

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.