Hello, I am struggling to find a way to do reoccurring orders. Hoping for some help.. It has been over 10 years since I've messed with ms access, so I remember a bit, but still getting back into the swing of things.
I am trying to make a database for ordering products. When a new customer signs up, they can do a single order, or reoccurring subscription. Subscriptions can be every 1, 2, 3, or 4 weeks. On my order form, it has the normal stuff. customer name, delivery date, and product info. I also have delivery frequency, ie, subscription or single order. I have it so it runs a SQL append query and enters the data fine for a single record. What I need is how can I make it so when I submit the order it duplicates that order every 1,2,3,or 4 weeks (depending of frequency) up to the delivery end date.
my file is too large to upload here.
Delivery days are typically every Tuesday for home delivery, and Wednesdays for businesses. Though those days may vary in the future.
TIA,
Mike
I am trying to make a database for ordering products. When a new customer signs up, they can do a single order, or reoccurring subscription. Subscriptions can be every 1, 2, 3, or 4 weeks. On my order form, it has the normal stuff. customer name, delivery date, and product info. I also have delivery frequency, ie, subscription or single order. I have it so it runs a SQL append query and enters the data fine for a single record. What I need is how can I make it so when I submit the order it duplicates that order every 1,2,3,or 4 weeks (depending of frequency) up to the delivery end date.
my file is too large to upload here.
Delivery days are typically every Tuesday for home delivery, and Wednesdays for businesses. Though those days may vary in the future.
TIA,
Mike