Why doesn;t it fill in all the items?

  • Thread starter Thread starter Van T. Dinh
  • Start date Start date
OOPS! Did it again! Very very sorry :-(
Henro

Van T. Dinh said:
We'll wait until the 6 Jan (my date/time) before we answer.

--
Van T. Dinh
MVP (Access)



Henro said:
Can anyone tell me why in the following code only the begindate (dtWhen) is
added?

Private Sub Form_AfterInsert()

With Me.RecordsetClone

For dtwhen = Me.Begindatum + 1 To Me.Einddatum
.AddNew
![Omschrijving] = Me.Omschrijving
![Relatie] = Me.Relatie
![Omschrijving] = Me.Omschrijving
![2e Engineer] = Me.Ctl2e_Engineer
![Engineer] = Me.Engineer
![AgendaItem] = Me.AgendaItem
![Einddatum] = Me.Einddatum
![Begindatum] = dtwhen
.Update
Next
End With
End Sub

TIA Henro
Click to expand...
Click to expand...
 
Can anyone tell me why in the following code only the begindate (dtWhen) is
added?

Private Sub Form_AfterInsert()

With Me.RecordsetClone

For dtwhen = Me.Begindatum + 1 To Me.Einddatum
.AddNew
![Omschrijving] = Me.Omschrijving
![Relatie] = Me.Relatie
![Omschrijving] = Me.Omschrijving
![2e Engineer] = Me.Ctl2e_Engineer
![Engineer] = Me.Engineer
![AgendaItem] = Me.AgendaItem
![Einddatum] = Me.Einddatum
![Begindatum] = dtwhen
.Update
Next
End With
End Sub

TIA Henro
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help of my Windows XP doesn`t work 1
Validation (in DAO) doesn´t work! 6
Series fill only copying and fill series greyed out 1
IE 7 problem with "@" 1
Updateing a record with a Null value field, fails? 5
Me.Undo doesn't work, records are added each time i enter the form and exit 0
keyboard doesn' t run after boot from floppy disk 8
Intel 8th-gen CPU Launch 2

Back
Top