Recall customers

[alpapak via AccessMonster.com]

Recall customers
------------------------------------------------------------------------------
--

hi
i want to make a recall form
my tables are Customers and Recall
CustomersID RecallID
Surname DateOfRecall = Date
RecallID RecallOk = True/False

i will fill the field Surname(MainFormCustomers) and insert a DateOfRecall
(SubRecall)

When i click a commandButton to open a form with the recalls that have pass
today.
If the recall is done, i will check RecallOk (CheckBox on the subRecall) and
it will not be visible as a recall

And a second form to show me the next 10 days recall.

thxs

Sorry for my english.

 

[alpapak via AccessMonster.com]

help pls

 

[Duncan Bachen]

Recall customers
------------------------------------------------------------------------------
--

hi
i want to make a recall form
my tables are Customers and Recall
CustomersID RecallID
Surname DateOfRecall = Date
RecallID RecallOk = True/False

i will fill the field Surname(MainFormCustomers) and insert a DateOfRecall
(SubRecall)

When i click a commandButton to open a form with the recalls that have pass
today.
If the recall is done, i will check RecallOk (CheckBox on the subRecall) and
it will not be visible as a recall

And a second form to show me the next 10 days recall.

thxs

Sorry for my english.

This is similar to your last question. You need to base your forms on a
query where you set the criteria.

In this case, your criteria in the RecallDate field would be < Date()

So it would pull all recall dates which are earlier than today's date.

The next portion would be criteria using the dateadd function, just as
before

Between Date() and DateAdd("d", 10, Date()).

This will let you see any dates which are between today and 10 days from
today.