DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Some help with a VBA solution

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Dec 2007

Posts: 1

Reputation: vbdave is an unknown quantity at this point

Solved Threads: 0

vbdave

Offline

Newbie Poster

Some help with a VBA solution

Oct 14th, 2008

Hi,

I made a small Access DB that has a Date field in it (DUEDATE). The DB is used for demonstration purposes to show current orders.

I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date and a range (30,60, Etc.) in a text box and have the function randomly create dates based on the start date and within the range input. If the DUEDATE column is empty or has another date should not matter.

Thanks in advance

•

Join Date: Jul 2008

Posts: 472

Reputation: abu taher is an unknown quantity at this point

Solved Threads: 24

abu taher

Offline

Posting Pro in Training

Re: Some help with a VBA solution

Oct 15th, 2008

Please tell your problem details. I don't understand what you said. please details.

•

Join Date: Oct 2008

Posts: 20

Reputation: rstkw is an unknown quantity at this point

Solved Threads: 2

rstkw

Offline

Newbie Poster

Re: Some help with a VBA solution

Oct 26th, 2008

•

Originally Posted by vbdave

Hi,

I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date and a range (30,60, Etc.) in a text box and have the function randomly create dates based on the start date and within the range input. If the DUEDATE column is empty or has another date should not matter.

Do you want the code for the random date generator, or changing the DueDate Column, or both?

The random date generator could get messy, but I'll see what I can do.

Last edited by rstkw; Oct 26th, 2008 at 1:08 pm. Reason: Added last line.