ACCESS FEED: Agustus 2016

Rabu, 31 Agustus 2016

Re: [MS_AccessPros] RE: subform in datasheet not triggering GotFocus

you're welcome, Liz ~

respectfully,
crystal

~ have an awesome day ~

On 8/31/2016 9:31 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Thanks Crystal.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 30, 2016 9:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: subform in datasheet not triggering GotFocus

Hi Liz,

you might also consider the ON ENTER event of the subform control. The active form is still the main form ... but getting ready to change

respectfully,
crystal

~ have an awesome day ~

On 8/30/2016 12:19 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Ah – nevermind. I decided to use the current event of the form. It's working better.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 30, 2016 9:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] subform in datasheet not triggering GotFocus

Pros, I have 2010, and am trying to run a simple procedure and need it to run when the subform gets the focus. However, It doesn't seem to be triggering this event. Has anyone seen this happen? My google searches are yielding nothing.

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] RE: subform in datasheet not triggering GotFocus

Thanks Crystal.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 30, 2016 9:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: subform in datasheet not triggering GotFocus

Hi Liz,

you might also consider the ON ENTER event of the subform control. The active form is still the main form ... but getting ready to change

respectfully,
crystal

~ have an awesome day ~

On 8/30/2016 12:19 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Ah – nevermind. I decided to use the current event of the form. It’s working better.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 30, 2016 9:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] subform in datasheet not triggering GotFocus

Pros, I have 2010, and am trying to run a simple procedure and need it to run when the subform gets the focus. However, It doesn’t seem to be triggering this event. Has anyone seen this happen? My google searches are yielding nothing.

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Have you tried the highest rated email app?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Birthdays Report

Robin,
Just December and January definitely helps with troubleshooting.

I don't believe you answer the question/email about if you have another function named Month(). He also asked you to open the debug window (press Ctrl+G) and enter
? Month(Date)

I believe someone asked if the date field is actually a date. Since you have only December and January, I expect you aren't storing an actual date value like Mar-21-1980 or Aug-2-2001.

If you don't want to store the actual year of birth, at least store them all as the year 1900 or similar since the birthday report discards the year.

Regards,
Duane

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 31 Aug 2016 07:22:18 +1000
Subject: RE: [MS_AccessPros] Birthdays Report

Duane,

I am still perplexed. The grouping shows January Birthdays first with a December header and all remaining in a group with a January header.Most odd.

Cheers,

Robin

At 31/08/2016 06:42 AM, you wrote:

Robin,

Has this been resolved? If so, I think I missed the email.

Regards,
Duane

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 30 Aug 2016 09:29:17 +0200
Subject: Re: [MS_AccessPros] Birthdays Report

OK, that makes more sense! If the day sort is below the group on month, then the records should be sorted correctly.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
http://www.viescas.com/
(Paris, France)

On Aug 30, 2016, at 8:37 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

OOOPS! Sorry that Was a typo !!!! It should be 10. All of the other entries return 10. Yes ten.

Red faced!

Robin

At 30/08/2016 01:48 PM, you wrote:

Robin-

The Month function should return values 1 to 12. It should never return 19! Is birthdate a Date / Time field?

John Viescas, author

Effective SQL

SQL Queries for Mere Mortals

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 20 07 Inside Out

Building Access Applications

http://www.viescas.com/

On Aug 29, 2016, at 23:48, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:

Robin,

Add a text box to the month gro up header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com

From: MS_Access_Professionals@yahoogroups.com

Date: Mon, 29 Aug 2016 08:24:37 +1000

Subject: RE: [MS_AccessPros] Birthdays Report

Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin

At 26/08/2016 08:17 PM, you wrote:

Robin,

Display the report sorting and group. Then select to group by the expression:
Month([birthdate])
Then add another sorting expression of:
Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.

Regards,
Duane

> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month an d then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple

__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (20)

Have you tried the highest rated email app?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

Selasa, 30 Agustus 2016

Re: [MS_AccessPros] RE: subform in datasheet not triggering GotFocus

Hi Liz,

you might also consider the ON ENTER event of the subform control. The active form is still the main form ... but getting ready to change

respectfully,
crystal

~ have an awesome day ~

On 8/30/2016 12:19 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:

Ah – nevermind. I decided to use the current event of the form. It's working better.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 30, 2016 9:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] subform in datasheet not triggering GotFocus

Pros, I have 2010, and am trying to run a simple procedure and need it to run when the subform gets the focus. However, It doesn't seem to be triggering this event. Has anyone seen this happen? My google searches are yielding nothing.

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Have you tried the highest rated email app?

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Birthdays Report

Duane,

I am still perplexed. The grouping shows January Birthdays first with a December header and all remaining in a group with a January header.Most odd.

Cheers,

Robin

At 31/08/2016 06:42 AM, you wrote:

Robin,

Has this been resolved? If so, I think I missed the email.

Regards,
Duane

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 30 Aug 2016 09:29:17 +0200
Subject: Re: [MS_AccessPros] Birthdays Report

OK, that makes more sense! If the day sort is below the group on month, then the records should be sorted correctly.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
http://www.viescas.com/
(Paris, France)

On Aug 30, 2016, at 8:37 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

OOOPS! Sorry that Was a typo !!!! It should be 10. All of the other entries return 10. Yes ten.

Red faced!

Robin

At 30/08/2016 01:48 PM, you wrote:

Robin-

The Month function should return values 1 to 12. It should never return 19! Is birthdate a Date / Time field?

John Viescas, author

Effective SQL

SQL Queries for Mere Mortals

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 20 07 Inside Out

Building Access Applications

http://www.viescas.com/

On Aug 29, 2016, at 23:48, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:

Robin,

Add a text box to the month gro up header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com

From: MS_Access_Professionals@yahoogroups.com

Date: Mon, 29 Aug 2016 08:24:37 +1000

Subject: RE: [MS_AccessPros] Birthdays Report

Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin

At 26/08/2016 08:17 PM, you wrote:

Robin,

Display the report sorting and group. Then select to group by the expression:
Month([birthdate])
Then add another sorting expression of:
Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.

Regards,
Duane

> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month an d then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple

__._,_.___

Posted by: Robin Chapple <robinski@westnet.com.au>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (19)

Have you tried the highest rated email app?

Visit Your Group

New Members 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

RE: [MS_AccessPros] Birthdays Report

Robin,

Has this been resolved? If so, I think I missed the email.

Regards,

Duane

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 30 Aug 2016 09:29:17 +0200
Subject: Re: [MS_AccessPros] Birthdays Report

OK, that makes more sense! If the day sort is below the group on month, then the records should be sorted correctly.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

http://www.viescas.com/

(Paris, France)

On Aug 30, 2016, at 8:37 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

OOOPS! Sorry that Was a typo !!!! It should be 10. All of the other entries return 10. Yes ten.

Red faced!

Robin

At 30/08/2016 01:48 PM, you wrote:

Robin-

The Month function should return values 1 to 12. It should never return 19! Is birthdate a Date / Time field?

John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
http://www.viescas.com/

On Aug 29, 2016, at 23:48, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

Duane,

The month provides numeral 1 for the first group and numeral 19 for the second group. There are no other groups.

The day gives the day date for each entry.

I hope that means something to you!

Thanks,

Robin

At 29/08/2016 03:42 PM, you wrote:


Robin,

Add a text box to the month group header with a control source of:

=Month([birthdate])

Add a control to the detail section with a control source of:

=Day([birthdate])

What do you see when you run the report?

Duane Hookom

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 29 Aug 2016 08:24:37 +1000
Subject: RE: [MS_AccessPros] Birthdays Report

Thanks Duane,

I have now done that and the first group shows January as the first month and lists birthdays in ascending order.

The next group header is May with all the remaining birthdays in random order. There is not another month group header

What have I missed?

Regards,

Robin

At 26/08/2016 08:17 PM, you wrote:

Robin,

Display the report sorting and group. Then select to group by the expression:
Month([birthdate])
Then add another sorting expression of:
Day([birthdate])
You can format the [birthdate] text boxes in your report sections to display whatever you want.

Regards,
Duane

> From: MS_Access_Professionals@yahoogroups.com
> Date: Fri, 26 Aug 2016 14:02:03 +1000
>
> I have a members database which includes their birthdays. I plan to
> make a report that groups birthdays on the month and then sorts them
> by the day.
>
> How do I do that?
>
> Many thanks,
>
> Robin Chapple

__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (18)

Have you tried the highest rated email app?

Visit Your Group

New Members 1

• Privacy • Unsubscribe • Terms of Use

__,_._,___

[MS_AccessPros] RE: subform in datasheet not triggering GotFocus

Ah – nevermind. I decided to use the current event of the form. It’s working better.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, August 30, 2016 9:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] subform in datasheet not triggering GotFocus

Pros, I have 2010, and am trying to run a simple procedure and need it to run when the subform gets the focus. However, It doesn’t seem to be triggering this event. Has anyone seen this happen? My google searches are yielding nothing.

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver