Results 1 to 11 of 11
  1. #1
    Join Date
    Feb 2006
    Posts
    12

    Talking Unanswered: repeated field entries

    Hi, i have a databse for booking sessions in a town hall. At the moment i have a pretty standard form/subform layout to enter in bookings according to the customer name etc... However, there are bookings that happen every month or every week, regularly.

    I would like to know how to setup repeated bookings..... Obviously its going to involve the bookings table in some way, say i wanted to enter all of the regular bookings for the next 5 months, is there a simple way to just run a type of query or something.

    Thanks for any help recieved in advance, dragon2309

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    theoretically yes
    you may need to write some vba to hadle the intervals, but in principle its farily straight forward
    the dateadd / datediif fucntion will be worth a look at, the recordset handling too
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2006
    Posts
    12
    do you have any examples of this, or anythign to help, i do not know VB, so i can code without extreme dificulty.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    there was a question very like this recently on this forum
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2006
    Posts
    12
    there was, does anyone have a link to it please.

  6. #6
    Join Date
    Feb 2006
    Posts
    12
    anybody...?

  7. #7
    Join Date
    Feb 2006
    Posts
    12
    i only want the link, can someone please post it up here...?

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try the (advanced) search......
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Feb 2006
    Posts
    12
    i cant find it, i searched a lot aswell.

  10. #10
    Join Date
    Feb 2006
    Posts
    12
    ....hello??

  11. #11
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    i cant find it, i searched a lot aswell.
    well thats odd
    using the advanced search, searching for dateadd, limiting to MS Access forum came up with many hits, 220+, some of which looked appropriate

    the second in the list looked relevant.
    Last edited by healdem; 02-25-06 at 08:12.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •