Need help to find a function

[lil]

Dear Forum,



I took an Access class last year but haven't used it much since and I am starting on memory loss at a young age...

I am working on a booking system (I don't want any of the softwares I have seen online).

Ideally, people will select a date(1) in the first textbox, and a date(2) in the second textbox. I would then like to see a grid numbered 1 to 31 with the backcolor of the dates selected in another color.

I can do the second part with a function in vb, but I can't find the function that would display all the numbers between the two dates chosen:

For example:

If person choses "5" and "10", I need to see "5" "6" "7" "8" "9" "10" (I would also be happy with "5" "6" "7" "8" "9", whitout the last number)

Any idea?

Many thanks in advance for your time

[RuralGuy]

Are you really using Access 97 with Vista?

[lil]

Thanks for pointing this out!! I use Access 2007.

I just found a thread on http://www.access-programmers.co.uk/...d.php?t=146597 if this can be of any help to people wanting to set up a booking system.

[RuralGuy]

Were you going to change your profile to reflect ac2007 instead of ac97?

[lil]

I have in my profile, but for some reason it doesn't seem to display here... I hope you've not lost sleep over it.

Update: Apparently it was just waiting for a new post..

[RuralGuy]

Great! Will that link you provided solve your issue or would you still like to pursue this thread?

[lil]

I intended to post detailed results once I would have looked at the given example more closely, but this thread could be marked as answered now. If I find how to do that....

[RuralGuy]

There's no hurry. Post back if you've solved your issue. I have a link in my signature.