advancing a text box date by one week

[Ron]

I use Access 95 (I know its time to upgrade)at my local
church. I print out weekly attendance sheets for about 12
classes. I have the date stored in a text box with a
particular date. Each week I advance the date by one
week. Other than using a macro to automatically open the
forms for editing; which I have doing quite regularly, how
can I get the forms to update the week date textbox by one
week when I choose to.

 

[Fredg]

Ron,
How about using a command button click event:
[DateField] = [DateField] + 7

Or place the code in the DateField's double-click event.

 

[Rebecca Riordan]

The expression DateAdd("w", 1, <date>) will add a week to the date you
provide. You could put this in the Click event of a button on the form.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...