Does Access/VB Code have the ability to regularly check a queue to see if
there is an item in it that needs to be processed, get the item and then
process it?

You can use a form timer event to do that. You set the Timer Interval to a
value to tell it how often to fire the timer event. 1 = 1 millisecond, so
1000 is 1 second.

Then you code the timer event of the form to do whatever needs to be done.
--
Dave Hargis, Microsoft Access MVP


"LKH" wrote:

> Does Access/VB Code have the ability to regularly check a queue to see if
> there is an item in it that needs to be processed, get the item and then
> process it?

I've never done this before so here's another question... How do I tell it
where to look (such as for a msg coming in via Outlook and getting an
attachment from the e-mail)?

"Klatuu" wrote:

> You can use a form timer event to do that. You set the Timer Interval to a
> value to tell it how often to fire the timer event. 1 = 1 millisecond, so
> 1000 is 1 second.
>
> Then you code the timer event of the form to do whatever needs to be done.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "LKH" wrote:
>
> > Does Access/VB Code have the ability to regularly check a queue to see if
> > there is an item in it that needs to be processed, get the item and then
> > process it?

The Outlook object model is not my strong suit, so I can't provide any useful
detail for you. I would suggest you post a new question and be specific
about what you want to do, for example:

"I want to use a form timer event to see if new emails have arrived and when
a new email arrives I want to determine if it has an attachement. If it
does, then I want to......"

You will get much better help when your questions clearly describe "What"
you want to do.
--
Dave Hargis, Microsoft Access MVP


"LKH" wrote:

> I've never done this before so here's another question... How do I tell it
> where to look (such as for a msg coming in via Outlook and getting an
> attachment from the e-mail)?
>
> "Klatuu" wrote:
>
> > You can use a form timer event to do that. You set the Timer Interval to a
> > value to tell it how often to fire the timer event. 1 = 1 millisecond, so
> > 1000 is 1 second.
> >
> > Then you code the timer event of the form to do whatever needs to be done.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "LKH" wrote:
> >
> > > Does Access/VB Code have the ability to regularly check a queue to see if
> > > there is an item in it that needs to be processed, get the item and then
> > > process it?

I will do that - thanks for your help!

"Klatuu" wrote:

> The Outlook object model is not my strong suit, so I can't provide any useful
> detail for you. I would suggest you post a new question and be specific
> about what you want to do, for example:
>
> "I want to use a form timer event to see if new emails have arrived and when
> a new email arrives I want to determine if it has an attachement. If it
> does, then I want to......"
>
> You will get much better help when your questions clearly describe "What"
> you want to do.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "LKH" wrote:
>
> > I've never done this before so here's another question... How do I tell it
> > where to look (such as for a msg coming in via Outlook and getting an
> > attachment from the e-mail)?
> >
> > "Klatuu" wrote:
> >
> > > You can use a form timer event to do that. You set the Timer Interval to a
> > > value to tell it how often to fire the timer event. 1 = 1 millisecond, so
> > > 1000 is 1 second.
> > >
> > > Then you code the timer event of the form to do whatever needs to be done.
> > > --
> > > Dave Hargis, Microsoft Access MVP
> > >
> > >
> > > "LKH" wrote:
> > >
> > > > Does Access/VB Code have the ability to regularly check a queue to see if
> > > > there is an item in it that needs to be processed, get the item and then
> > > > process it?