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.

>>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);

--
KARL DEWEY
Build a little - Test a little

ed the beginner wrote:
> 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

"Philip Herlihy" wrote:

> ed the beginner wrote:
> > 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
>
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!

ed the beginner wrote:
>
> "Philip Herlihy" wrote:
>
>> ed the beginner wrote:
>>> 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
>>
> 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

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.


"Philip Herlihy" wrote:

> ed the beginner wrote:
> >
> > "Philip Herlihy" wrote:
> >
> >> ed the beginner wrote:
> >>> 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
> >>
> > 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
>