access database 2007

[ed the beginner]

Hi Guys,

I understand if ask to much but please have mercy, I start using access 2007
only 4 weeks ago and I need some help ( I can't reply to my original question
so I post another one ).

1. I have a table named Products ( aprox 500 ) and it looks like this:

product received expire
a 12/12/2008
12/12/2010
b 01/01/2008
01/01/2009
c 10/02/2009
01/07/2009
I want a code(?) to search in the column expire and to pop up (or message
box ) a list with all products due to expire in 5days.

2. I want to create a treeview (HOW?) and to open a form when I click on a
leaf/children(?).

Is there anybody who can help me with templates or small examples?
I don't know anything about codes and I can learn from templates/examples,
like I learned everything I know about Access.

Thank you Tina and Philip for your help.
Thank you all.

 

[KARL DEWEY]

I want a code(?) to search in the column expire and to pop up (or message
box ) a list with all products due to expire in 5days.
Here is SQL for query --
SELECT [product], [received], [expire]
FROM Products
WHERE ([expire] <= Date()+5);

 

[Philip Herlihy]

Hi Guys,

I understand if ask to much but please have mercy, I start using access 2007
only 4 weeks ago and I need some help ( I can't reply to my original question
so I post another one ).

1. I have a table named Products ( aprox 500 ) and it looks like this:

product received expire
a 12/12/2008
12/12/2010
b 01/01/2008
01/01/2009
c 10/02/2009
01/07/2009
I want a code(?) to search in the column expire and to pop up (or message
box ) a list with all products due to expire in 5days.

2. I want to create a treeview (HOW?) and to open a form when I click on a
leaf/children(?).

Is there anybody who can help me with templates or small examples?
I don't know anything about codes and I can learn from templates/examples,
like I learned everything I know about Access.

Thank you Tina and Philip for your help.
Thank you all.

See my latest reply to your original post: "Access database reminder"
which you posted 08/02/2009 12:31

Don't break threads - bad manners! You may need to fiddle with your
newsreader settings to get back to the original.

Phil

 

[ed the beginner]

See my latest reply to your original post: "Access database reminder"
which you posted 08/02/2009 12:31

Don't break threads - bad manners! You may need to fiddle with your
newsreader settings to get back to the original.

Phil

I apologize, I didn't break threads. After I replied my computer frozen and
after few hours my post wasn't there so I tried again to post a reply and I
had the same problem. After another 2 hours both replies are there and both
are in a wrong format then original.

SORRY!

 

[Philip Herlihy]

I apologize, I didn't break threads. After I replied my computer frozen and
after few hours my post wasn't there so I tried again to post a reply and I
had the same problem. After another 2 hours both replies are there and both
are in a wrong format then original.

SORRY!

No worries, but it's best to keep the thread together if at all
possible. What program are you using to read and write here? Can you
see my reply to the "Access database reminder" thread?

Phil

 

[ed the beginner]

Thank you for advice. Yes. I can see now your reply and I'll try to learn
what you told me.
To read I just click on a screen name under question. To write I click on
option reply, but I think it was something wrong with my internet connection.
Anyway, now it looks OK.
From now on I'll keep my question with the original thread.
Thank you again.