Filter By Date

[Guest]

I have a form that I have added an active control calendar. My calendar is
working great without problems. How can I base my forms information dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form to
refresh to display info relating to May 6, 2005. Do I need to have a subform?
Thank you for your time!
Ryan

 

[Guest]

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need to type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

 

[Guest]

I am sorry for my ignorance...how can I apply your response to my database?
Where would I be entering the code that you wrote and where do I set the
Filter/Filteron controls? Thank you so very much for your time, Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need to type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

I have a form that I have added an active control calendar. My calendar is
working great without problems. How can I base my forms information dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form to
refresh to display info relating to May 6, 2005. Do I need to have a subform?
Thank you for your time!
Ryan

 

[Guest]

Hi, Ryan.

I have not used an ActiveX control in any of my applications, but I'm
presuming it, like any other control, has an AfterUpdate event property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into the
AfterUpdate field, and click on the ellipsis to the right, and select Code
Builder, if necessary (depending on your configuration it may just launch the
Code Builder).

VBA will create the shell of the event procedure for you. Add the code
between the Sub and End Sub lines, change YourDateField to the name of the
field by which you wish to filter, and change YourActiveXControl to the name
of the control. Save it, except the VBA editor, save your form, and you
should be in business.

Hope that helps.
Sprinks

I am sorry for my ignorance...how can I apply your response to my database?
Where would I be entering the code that you wrote and where do I set the
Filter/Filteron controls? Thank you so very much for your time, Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need to type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

I have a form that I have added an active control calendar. My calendar is
working great without problems. How can I base my forms information dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form to
refresh to display info relating to May 6, 2005. Do I need to have a subform?
Thank you for your time!
Ryan

 

['69 Camaro]

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail address for
people to reach you outside of the newsgoups. Have you already contacted
the Microsoft Online Community tech support about the bronze medal icon next
to your name in the newsgroup thread pane? If so, what did they tell you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Hi, Ryan.

I have not used an ActiveX control in any of my applications, but I'm
presuming it, like any other control, has an AfterUpdate event property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into the
AfterUpdate field, and click on the ellipsis to the right, and select Code
Builder, if necessary (depending on your configuration it may just launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the code
between the Sub and End Sub lines, change YourDateField to the name of the
field by which you wish to filter, and change YourActiveXControl to the
name
of the control. Save it, except the VBA editor, save your form, and you
should be in business.

Hope that helps.
Sprinks

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I set the
Filter/Filteron controls? Thank you so very much for your time, Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form to
refresh to display info relating to May 6, 2005. Do I need to have a
subform?
Thank you for your time!
Ryan

 

[Guest]

Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail address for
people to reach you outside of the newsgoups. Have you already contacted
the Microsoft Online Community tech support about the bronze medal icon next
to your name in the newsgroup thread pane? If so, what did they tell you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Hi, Ryan.

I have not used an ActiveX control in any of my applications, but I'm
presuming it, like any other control, has an AfterUpdate event property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into the
AfterUpdate field, and click on the ellipsis to the right, and select Code
Builder, if necessary (depending on your configuration it may just launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the code
between the Sub and End Sub lines, change YourDateField to the name of the
field by which you wish to filter, and change YourActiveXControl to the
name
of the control. Save it, except the VBA editor, save your form, and you
should be in business.

Hope that helps.
Sprinks

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I set the
Filter/Filteron controls? Thank you so very much for your time, Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form to
refresh to display info relating to May 6, 2005. Do I need to have a
subform?
Thank you for your time!
Ryan

 

['69 Camaro]

Hi, Kevin.

Well, this means that you haven't contacted tech support about it, so that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.

The bronze medal icon indicates a contributor's level of expertise in the
Microsoft Online Community, and the icon appears next to the display name of
the contributor for new posts after he has reached each level. The icon can
be seen in the "thread pane" in the middle of the Web page listing the
display names and dates of replies to the question. It can also be seen in
the "reply pane" on the right-hand side of the Web page, next to the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the number 3 in
it? Select Jim's name in the right-hand pane to open his profile. He has
earned the bronze badge by correctly answering at least 51 questions and
waiting till after the requisite four week waiting period has expired. Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your display name
in the right-hand pane to open your profile. You have also earned the
bronze badge by correctly answering at least 51 questions and waiting till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the other
people who regularly post in the Access newsgroups and have had at least 51
replies marked as answers and have been waiting more than a month since they
reached 51 answers? Other newsgroups have a few people with badges
indicating their contribution level in the Microsoft Online Community, but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has reached the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a bunch of
slackers compared to the other newsgroups, and that just ain't true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail address
for
people to reach you outside of the newsgoups. Have you already contacted
the Microsoft Online Community tech support about the bronze medal icon
next
to your name in the newsgroup thread pane? If so, what did they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Hi, Ryan.

I have not used an ActiveX control in any of my applications, but I'm
presuming it, like any other control, has an AfterUpdate event
property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into the
AfterUpdate field, and click on the ellipsis to the right, and select
Code
Builder, if necessary (depending on your configuration it may just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the code
between the Sub and End Sub lines, change YourDateField to the name of
the
field by which you wish to filter, and change YourActiveXControl to the
name
of the control. Save it, except the VBA editor, save your form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I set
the
Filter/Filteron controls? Thank you so very much for your time, Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need
to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form
to
refresh to display info relating to May 6, 2005. Do I need to have
a
subform?
Thank you for your time!
Ryan

 

[Guest]

Gunny,

Thanks for all of that information. I had no idea about this program, and I
suppose, egos being what they are, I'd prefer to have the recognition than
not have it!

I have contacted them, and will follow up with you if and when I hear
anything.

BTW, why do you think my name is Kevin?

Sprinks

Hi, Kevin.

Well, this means that you haven't contacted tech support about it, so that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.

The bronze medal icon indicates a contributor's level of expertise in the
Microsoft Online Community, and the icon appears next to the display name of
the contributor for new posts after he has reached each level. The icon can
be seen in the "thread pane" in the middle of the Web page listing the
display names and dates of replies to the question. It can also be seen in
the "reply pane" on the right-hand side of the Web page, next to the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the number 3 in
it? Select Jim's name in the right-hand pane to open his profile. He has
earned the bronze badge by correctly answering at least 51 questions and
waiting till after the requisite four week waiting period has expired. Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your display name
in the right-hand pane to open your profile. You have also earned the
bronze badge by correctly answering at least 51 questions and waiting till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the other
people who regularly post in the Access newsgroups and have had at least 51
replies marked as answers and have been waiting more than a month since they
reached 51 answers? Other newsgroups have a few people with badges
indicating their contribution level in the Microsoft Online Community, but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has reached the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a bunch of
slackers compared to the other newsgroups, and that just ain't true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail address
for
people to reach you outside of the newsgoups. Have you already contacted
the Microsoft Online Community tech support about the bronze medal icon
next
to your name in the newsgroup thread pane? If so, what did they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, Ryan.

I have not used an ActiveX control in any of my applications, but I'm
presuming it, like any other control, has an AfterUpdate event
property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into the
AfterUpdate field, and click on the ellipsis to the right, and select
Code
Builder, if necessary (depending on your configuration it may just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the code
between the Sub and End Sub lines, change YourDateField to the name of
the
field by which you wish to filter, and change YourActiveXControl to the
name
of the control. Save it, except the VBA editor, save your form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I set
the
Filter/Filteron controls? Thank you so very much for your time, Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need
to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form
to
refresh to display info relating to May 6, 2005. Do I need to have
a
subform?
Thank you for your time!
Ryan

 

['69 Camaro]

Hi, Kevin.

You're welcome. I contacted tech support nearly a month ago, too, and
they've replied a few times. Unfortunately, they are still researching the
problem (or have forgotten about the problem by now), so I wondered if
anyone else is complaining to them.

BTW, why do you think my name is Kevin?

When parents have twins, they are often asked how they tell the two apart.
"You yell out one of the names, and whoever answers is the one you want."
I'm addressing my messages to Kevin. You're the one who is answering me.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Gunny,

Thanks for all of that information. I had no idea about this program, and
I
suppose, egos being what they are, I'd prefer to have the recognition than
not have it!

I have contacted them, and will follow up with you if and when I hear
anything.

BTW, why do you think my name is Kevin?

Sprinks

Hi, Kevin.

Well, this means that you haven't contacted tech support about it, so
that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.

The bronze medal icon indicates a contributor's level of expertise in the
Microsoft Online Community, and the icon appears next to the display name
of
the contributor for new posts after he has reached each level. The icon
can
be seen in the "thread pane" in the middle of the Web page listing the
display names and dates of replies to the question. It can also be seen
in
the "reply pane" on the right-hand side of the Web page, next to the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the number 3
in
it? Select Jim's name in the right-hand pane to open his profile. He
has
earned the bronze badge by correctly answering at least 51 questions and
waiting till after the requisite four week waiting period has expired.
Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your display
name
in the right-hand pane to open your profile. You have also earned the
bronze badge by correctly answering at least 51 questions and waiting
till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the other
people who regularly post in the Access newsgroups and have had at least
51
replies marked as answers and have been waiting more than a month since
they
reached 51 answers? Other newsgroups have a few people with badges
indicating their contribution level in the Microsoft Online Community,
but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has reached
the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a bunch of
slackers compared to the other newsgroups, and that just ain't true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea,
however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

:

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail
address
for
people to reach you outside of the newsgoups. Have you already
contacted
the Microsoft Online Community tech support about the bronze medal
icon
next
to your name in the newsgroup thread pane? If so, what did they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, Ryan.

I have not used an ActiveX control in any of my applications, but
I'm
presuming it, like any other control, has an AfterUpdate event
property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into
the
AfterUpdate field, and click on the ellipsis to the right, and
select
Code
Builder, if necessary (depending on your configuration it may just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the
code
between the Sub and End Sub lines, change YourDateField to the name
of
the
field by which you wish to filter, and change YourActiveXControl to
the
name
of the control. Save it, except the VBA editor, save your form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I
set
the
Filter/Filteron controls? Thank you so very much for your time,
Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also
need
to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl &
"#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my
form
to
refresh to display info relating to May 6, 2005. Do I need to
have
a
subform?
Thank you for your time!
Ryan

 

[Guest]

I've been known to answer to "Hey You" also.

Well, I received an email after my initial contact with Microsoft saying
they were looking into the problem.

Today I see that they've resolved it and are displaying my bronze star.
Thanks for mentioning it.

Sprinks

Hi, Kevin.

You're welcome. I contacted tech support nearly a month ago, too, and
they've replied a few times. Unfortunately, they are still researching the
problem (or have forgotten about the problem by now), so I wondered if
anyone else is complaining to them.

BTW, why do you think my name is Kevin?

When parents have twins, they are often asked how they tell the two apart.
"You yell out one of the names, and whoever answers is the one you want."
I'm addressing my messages to Kevin. You're the one who is answering me.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Gunny,

Thanks for all of that information. I had no idea about this program, and
I
suppose, egos being what they are, I'd prefer to have the recognition than
not have it!

I have contacted them, and will follow up with you if and when I hear
anything.

BTW, why do you think my name is Kevin?

Sprinks

Hi, Kevin.

Well, this means that you haven't contacted tech support about it, so
that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.

The bronze medal icon indicates a contributor's level of expertise in the
Microsoft Online Community, and the icon appears next to the display name
of
the contributor for new posts after he has reached each level. The icon
can
be seen in the "thread pane" in the middle of the Web page listing the
display names and dates of replies to the question. It can also be seen
in
the "reply pane" on the right-hand side of the Web page, next to the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the number 3
in
it? Select Jim's name in the right-hand pane to open his profile. He
has
earned the bronze badge by correctly answering at least 51 questions and
waiting till after the requisite four week waiting period has expired.
Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your display
name
in the right-hand pane to open your profile. You have also earned the
bronze badge by correctly answering at least 51 questions and waiting
till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the other
people who regularly post in the Access newsgroups and have had at least
51
replies marked as answers and have been waiting more than a month since
they
reached 51 answers? Other newsgroups have a few people with badges
indicating their contribution level in the Microsoft Online Community,
but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has reached
the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a bunch of
slackers compared to the other newsgroups, and that just ain't true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea,
however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

:

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail
address
for
people to reach you outside of the newsgoups. Have you already
contacted
the Microsoft Online Community tech support about the bronze medal
icon
next
to your name in the newsgroup thread pane? If so, what did they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, Ryan.

I have not used an ActiveX control in any of my applications, but
I'm
presuming it, like any other control, has an AfterUpdate event
property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into
the
AfterUpdate field, and click on the ellipsis to the right, and
select
Code
Builder, if necessary (depending on your configuration it may just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the
code
between the Sub and End Sub lines, change YourDateField to the name
of
the
field by which you wish to filter, and change YourActiveXControl to
the
name
of the control. Save it, except the VBA editor, save your form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I
set
the
Filter/Filteron controls? Thank you so very much for your time,
Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also
need
to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl &
"#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my
form
to
refresh to display info relating to May 6, 2005. Do I need to
have
a
subform?
Thank you for your time!
Ryan

 

[Guest]

Whoops! Make that seven additional weeks after the requisite four week wait,
not just a seven week wait.

Gunny

Hi, Kevin.

Today I see that they've resolved it and are displaying my bronze star.

Congratulations! You were the first Microsoft Online Community member who
answers questions in the Access newsgroups to have earned the Bronze badge,
so you deserve recognition. According to Microsoft's Online Help FAQ, one
must wait four weeks after having the 51st reply marked as an answer by the
original poster before the badge is awarded, but it appears that you got to
wait seven weeks instead. I guess it's better to wait seven weeks than seven
months, though!

I'm still wondering what caused the bug, because people in other newsgroups
have had badges, but none in the Access newsgroups who had already earned the
badge had it displayed next to their names until you did yesterday.

Thanks for mentioning it.

You're very welcome. Have a great day!

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

I've been known to answer to "Hey You" also.

Well, I received an email after my initial contact with Microsoft saying
they were looking into the problem.

Today I see that they've resolved it and are displaying my bronze star.
Thanks for mentioning it.

Sprinks

Hi, Kevin.

You're welcome. I contacted tech support nearly a month ago, too, and
they've replied a few times. Unfortunately, they are still researching the
problem (or have forgotten about the problem by now), so I wondered if
anyone else is complaining to them.

BTW, why do you think my name is Kevin?

When parents have twins, they are often asked how they tell the two apart.
"You yell out one of the names, and whoever answers is the one you want."
I'm addressing my messages to Kevin. You're the one who is answering me.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Gunny,

Thanks for all of that information. I had no idea about this program, and
I
suppose, egos being what they are, I'd prefer to have the recognition than
not have it!

I have contacted them, and will follow up with you if and when I hear
anything.

BTW, why do you think my name is Kevin?

Sprinks

:

Hi, Kevin.

Well, this means that you haven't contacted tech support about it, so
that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.

The bronze medal icon indicates a contributor's level of expertise in the
Microsoft Online Community, and the icon appears next to the display name
of
the contributor for new posts after he has reached each level. The icon
can
be seen in the "thread pane" in the middle of the Web page listing the
display names and dates of replies to the question. It can also be seen
in
the "reply pane" on the right-hand side of the Web page, next to the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the number 3
in
it? Select Jim's name in the right-hand pane to open his profile. He
has
earned the bronze badge by correctly answering at least 51 questions and
waiting till after the requisite four week waiting period has expired.
Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your display
name
in the right-hand pane to open your profile. You have also earned the
bronze badge by correctly answering at least 51 questions and waiting
till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the other
people who regularly post in the Access newsgroups and have had at least
51
replies marked as answers and have been waiting more than a month since
they
reached 51 answers? Other newsgroups have a few people with badges
indicating their contribution level in the Microsoft Online Community,
but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has reached
the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a bunch of
slackers compared to the other newsgroups, and that just ain't true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea,
however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

:

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail
address
for
people to reach you outside of the newsgoups. Have you already
contacted
the Microsoft Online Community tech support about the bronze medal
icon
next
to your name in the newsgroup thread pane? If so, what did they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, Ryan.

I have not used an ActiveX control in any of my applications, but
I'm
presuming it, like any other control, has an AfterUpdate event
property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into
the
AfterUpdate field, and click on the ellipsis to the right, and
select
Code
Builder, if necessary (depending on your configuration it may just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the
code
between the Sub and End Sub lines, change YourDateField to the name
of
the
field by which you wish to filter, and change YourActiveXControl to
the
name
of the control. Save it, except the VBA editor, save your form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I
set
the
Filter/Filteron controls? Thank you so very much for your time,
Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also
need
to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl &
"#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my
form
to
refresh to display info relating to May 6, 2005. Do I need to
have
a
subform?
Thank you for your time!
Ryan

 

[Guest]

Hi, Kevin.

Today I see that they've resolved it and are displaying my bronze star.

Congratulations! You were the first Microsoft Online Community member who
answers questions in the Access newsgroups to have earned the Bronze badge,
so you deserve recognition. According to Microsoft's Online Help FAQ, one
must wait four weeks after having the 51st reply marked as an answer by the
original poster before the badge is awarded, but it appears that you got to
wait seven weeks instead. I guess it's better to wait seven weeks than seven
months, though!

I'm still wondering what caused the bug, because people in other newsgroups
have had badges, but none in the Access newsgroups who had already earned the
badge had it displayed next to their names until you did yesterday.

Thanks for mentioning it.

You're very welcome. Have a great day!

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

I've been known to answer to "Hey You" also.

Well, I received an email after my initial contact with Microsoft saying
they were looking into the problem.

Today I see that they've resolved it and are displaying my bronze star.
Thanks for mentioning it.

Sprinks

Hi, Kevin.

You're welcome. I contacted tech support nearly a month ago, too, and
they've replied a few times. Unfortunately, they are still researching the
problem (or have forgotten about the problem by now), so I wondered if
anyone else is complaining to them.

BTW, why do you think my name is Kevin?

When parents have twins, they are often asked how they tell the two apart.
"You yell out one of the names, and whoever answers is the one you want."
I'm addressing my messages to Kevin. You're the one who is answering me.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

Gunny,

Thanks for all of that information. I had no idea about this program, and
I
suppose, egos being what they are, I'd prefer to have the recognition than
not have it!

I have contacted them, and will follow up with you if and when I hear
anything.

BTW, why do you think my name is Kevin?

Sprinks

:

Hi, Kevin.

Well, this means that you haven't contacted tech support about it, so
that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.

The bronze medal icon indicates a contributor's level of expertise in the
Microsoft Online Community, and the icon appears next to the display name
of
the contributor for new posts after he has reached each level. The icon
can
be seen in the "thread pane" in the middle of the Web page listing the
display names and dates of replies to the question. It can also be seen
in
the "reply pane" on the right-hand side of the Web page, next to the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the number 3
in
it? Select Jim's name in the right-hand pane to open his profile. He
has
earned the bronze badge by correctly answering at least 51 questions and
waiting till after the requisite four week waiting period has expired.
Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your display
name
in the right-hand pane to open your profile. You have also earned the
bronze badge by correctly answering at least 51 questions and waiting
till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the other
people who regularly post in the Access newsgroups and have had at least
51
replies marked as answers and have been waiting more than a month since
they
reached 51 answers? Other newsgroups have a few people with badges
indicating their contribution level in the Microsoft Online Community,
but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has reached
the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a bunch of
slackers compared to the other newsgroups, and that just ain't true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, 69 Camaro. And BTW; that was one sweet car. I have no idea,
however,
what a "bronze medal icon" is, nor what the "newsgroup thread pane" is.
Please enlighten me.

Sprinks

:

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail
address
for
people to reach you outside of the newsgoups. Have you already
contacted
the Microsoft Online Community tech support about the bronze medal
icon
next
to your name in the newsgroup thread pane? If so, what did they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Hi, Ryan.

I have not used an ActiveX control in any of my applications, but
I'm
presuming it, like any other control, has an AfterUpdate event
property.
Open the form in design view, click on the control, and display the
properties with View, Properties. Click the Event tab, click into
the
AfterUpdate field, and click on the ellipsis to the right, and
select
Code
Builder, if necessary (depending on your configuration it may just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you. Add the
code
between the Sub and End Sub lines, change YourDateField to the name
of
the
field by which you wish to filter, and change YourActiveXControl to
the
name
of the control. Save it, except the VBA editor, save your form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response to my
database?
Where would I be entering the code that you wrote and where do I
set
the
Filter/Filteron controls? Thank you so very much for your time,
Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also
need
to
type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl &
"#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my
form
to
refresh to display info relating to May 6, 2005. Do I need to
have
a
subform?
Thank you for your time!
Ryan

 

[Douglas J. Steele]

Sorry, Gunny, but who cares? This is NNTP: a well established internet
protocol. Just because Microsoft chooses to put some bizarre critieria
around it doesn't really mean anything...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Whoops! Make that seven additional weeks after the requisite four week
wait,
not just a seven week wait.

Gunny

Hi, Kevin.

Today I see that they've resolved it and are displaying my bronze star.

Congratulations! You were the first Microsoft Online Community member
who
answers questions in the Access newsgroups to have earned the Bronze
badge,
so you deserve recognition. According to Microsoft's Online Help FAQ,
one
must wait four weeks after having the 51st reply marked as an answer by
the
original poster before the badge is awarded, but it appears that you got
to
wait seven weeks instead. I guess it's better to wait seven weeks than
seven
months, though!

I'm still wondering what caused the bug, because people in other
newsgroups
have had badges, but none in the Access newsgroups who had already earned
the
badge had it displayed next to their names until you did yesterday.

Thanks for mentioning it.

You're very welcome. Have a great day!

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

I've been known to answer to "Hey You" also.

Well, I received an email after my initial contact with Microsoft
saying
they were looking into the problem.

Today I see that they've resolved it and are displaying my bronze star.
Thanks for mentioning it.

Sprinks

:

Hi, Kevin.

You're welcome. I contacted tech support nearly a month ago, too,
and
they've replied a few times. Unfortunately, they are still
researching the
problem (or have forgotten about the problem by now), so I wondered
if
anyone else is complaining to them.

BTW, why do you think my name is Kevin?

When parents have twins, they are often asked how they tell the two
apart.
"You yell out one of the names, and whoever answers is the one you
want."
I'm addressing my messages to Kevin. You're the one who is answering
me.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and (e-mail address removed)


Gunny,

Thanks for all of that information. I had no idea about this
program, and
I
suppose, egos being what they are, I'd prefer to have the
recognition than
not have it!

I have contacted them, and will follow up with you if and when I
hear
anything.

BTW, why do you think my name is Kevin?

Sprinks

:

Hi, Kevin.

Well, this means that you haven't contacted tech support about it,
so
that
question is answered. Thanks.

I have no idea, however,
what a "bronze medal icon" is, nor what the "newsgroup thread
pane" is.

The bronze medal icon indicates a contributor's level of expertise
in the
Microsoft Online Community, and the icon appears next to the
display name
of
the contributor for new posts after he has reached each level.
The icon
can
be seen in the "thread pane" in the middle of the Web page listing
the
display names and dates of replies to the question. It can also
be seen
in
the "reply pane" on the right-hand side of the Web page, next to
the
contributor's display name.

Look at the following Web page:

http://www.microsoft.com/office/com...cbdb1a-b136-4d4a-8b50-5eb3a7b8f332&sloc=en-us

Do you see a bronze badge next to Jim Tomlinson's name with the
number 3
in
it? Select Jim's name in the right-hand pane to open his profile.
He
has
earned the bronze badge by correctly answering at least 51
questions and
waiting till after the requisite four week waiting period has
expired.
Now
look at the following Web page:

http://www.microsoft.com/office/com...00dd05-838b-42cf-a247-b97f5f09c529&sloc=en-us

There's no bronze badge next to your display name. Select your
display
name
in the right-hand pane to open your profile. You have also earned
the
bronze badge by correctly answering at least 51 questions and
waiting
till
after the requisite four week waiting period has expired.

So where is your badge? Furthermore, where are the badges for the
other
people who regularly post in the Access newsgroups and have had at
least
51
replies marked as answers and have been waiting more than a month
since
they
reached 51 answers? Other newsgroups have a few people with
badges
indicating their contribution level in the Microsoft Online
Community,
but
none of the the Access newsgroups seem to.

Here's another contributor in the SQL Server newsgroups who has
reached
the
second level, the silver badge:

http://www.microsoft.com/communitie...2310d6-082f-484f-a749-f806572ebaa1&sloc=en-us

This makes it look like the Access community contributors are a
bunch of
slackers compared to the other newsgroups, and that just ain't
true.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail
harvesters
for spammers are (e-mail address removed) and
(e-mail address removed)


Hi, 69 Camaro. And BTW; that was one sweet car. I have no
idea,
however,
what a "bronze medal icon" is, nor what the "newsgroup thread
pane" is.
Please enlighten me.

Sprinks

:

Hi, Kevin.

Sorry to barge in on this thread, but you don't offer an E-mail
address
for
people to reach you outside of the newsgoups. Have you already
contacted
the Microsoft Online Community tech support about the bronze
medal
icon
next
to your name in the newsgroup thread pane? If so, what did
they tell
you?

Thanks.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that
a
message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup
E-mail
harvesters
for spammers are (e-mail address removed) and
(e-mail address removed)


Hi, Ryan.

I have not used an ActiveX control in any of my applications,
but
I'm
presuming it, like any other control, has an AfterUpdate
event
property.
Open the form in design view, click on the control, and
display the
properties with View, Properties. Click the Event tab, click
into
the
AfterUpdate field, and click on the ellipsis to the right,
and
select
Code
Builder, if necessary (depending on your configuration it may
just
launch
the
Code Builder).

VBA will create the shell of the event procedure for you.
Add the
code
between the Sub and End Sub lines, change YourDateField to
the name
of
the
field by which you wish to filter, and change
YourActiveXControl to
the
name
of the control. Save it, except the VBA editor, save your
form, and
you
should be in business.

Hope that helps.
Sprinks

:

I am sorry for my ignorance...how can I apply your response
to my
database?
Where would I be entering the code that you wrote and where
do I
set
the
Filter/Filteron controls? Thank you so very much for your
time,
Ryan

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You
also
need
to
type
the data as a date value with leading and trailing #
symbols:

Me.Filter = "[YourDateField]= #" &
Me.YourActiveXControl &
"#"
Me.FilterOn = True

Hope that helps.
Sprinks

:

I have a form that I have added an active control
calendar. My
calendar is
working great without problems. How can I base my forms
information
dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I
want my
form
to
refresh to display info relating to May 6, 2005. Do I
need to
have
a
subform?
Thank you for your time!
Ryan

 

[Guest]

Hi, Doug.

who cares? This is NNTP: a well established internet
protocol. Just because Microsoft chooses to put some bizarre critieria
around it doesn't really mean anything...

Touche. But try to look at it from a slightly different perspective. Isn't
Microsoft the sole selector of some particular criteria used to decide who is
bestowed the Microsoft Access MVP award for outstanding participants who use
NNTP, too? As an Oracle DBA and having come from the Unix and VAX worlds, I
can tell you that Oracle professionals and other non-Microsoft technology
professionals who use NNTP for technical discussions don't care about the
Microsoft Access MVP award, either. Does this mean that people shouldn't be
recognized for outstanding achievement just because the criteria for earning
the award doesn't mean anything to those other folks who use NNTP? Of course
not.

The badges indicating the level of achievement for Microsoft online
community members are additional awards that Microsoft has offered to give to
those who meet the published requirements. Without these awards, the only
award available for participants is the MVP award, which extremely few of the
more than 600 people who correctly answered questions in the Access
newsgroups will ever attain if they aren't already an MVP. And considering
that half of the replies marked as answers were posted by non-MVP's,
recognizing only MVP's doesn't seem fair.

After nearly a year of Microsoft's program, the first person who has earned
the badge by answering a sufficient number of Access questions deserves some
recognition. That person happens to be Kevin Sprinkel.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

 

[Guest]

Sprinks...

Thanks a million! I've been working for 3 days on a similar problem, and
your explanation resolved my problem immediately.

YOU ARE THE "MAN"!

Hi, Ryan.

To do this, set the Filter and FilterOn properties. You also need to type
the data as a date value with leading and trailing # symbols:

Me.Filter = "[YourDateField]= #" & Me.YourActiveXControl & "#"
Me.FilterOn = True

Hope that helps.
Sprinks

I have a form that I have added an active control calendar. My calendar is
working great without problems. How can I base my forms information dependent
on the date I choose in the active x?

For example, if I choose May 6, 2005 on my control, I want my form to
refresh to display info relating to May 6, 2005. Do I need to have a subform?
Thank you for your time!
Ryan