DaniWeb IT Discussion Community - Some help with a VBA solution

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Visual Basic 4 / 5 / 6 (http://www.daniweb.com/forums/forum4.html)

- - Some help with a VBA solution (http://www.daniweb.com/forums/thread151178.html)

vbdave

Oct 14th, 2008 7:15 pm

Some help with a VBA solution

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

abu taher

Oct 15th, 2008 12:13 am

Re: Some help with a VBA solution

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

rstkw

Oct 26th, 2008 1:06 pm

Re: Some help with a VBA solution

Quote:

Originally Posted by vbdave (Post 712653)

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.

All times are GMT -4. The time now is 3:23 am.