ACCESS FEED: November 2023

Kamis, 30 November 2023

Re: [MSAccessProfessionals] Change background color

No problem!

Paul

Sent via mobile device

-------- Original message --------

From: Bill Singer <Bill.Singer@at-group.net>

Date: 11/30/23 12:13 PM (GMT-08:00)

To: MSAccessProfessionals@groups.io

Subject: Re: [MSAccessProfessionals] Change background color

Bingo, good idea. I forgot that was there.

Thanks,

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Thursday, November 30, 2023 11:58 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change background color

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

Paul

------ Original Message ------

From: "Bill Singer" <Bill.Singer@at-group.net>

To: MSAccessProfessionals@groups.io

Sent: 11/30/2023 9:39:53 AM

Subject: Re: [MSAccessProfessionals] Change background color

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

I have not been able to figure out how to change the background property of a text box.

Any help would be appreciated.

Thanks,

Bill

Bill Singer

Re: [MSAccessProfessionals] Change background color

Bingo, good idea. I forgot that was there.

Thanks,

Bill

Bill Singer

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

Paul

------ Original Message ------

From: "Bill Singer" <Bill.Singer@at-group.net>

To: MSAccessProfessionals@groups.io

Sent: 11/30/2023 9:39:53 AM

Subject: Re: [MSAccessProfessionals] Change background color

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

I have not been able to figure out how to change the background property of a text box.

Any help would be appreciated.

Thanks,

Bill

Bill Singer

Re: [MSAccessProfessionals] Change background color

You can use Conditional Formatting with "Expression Is" testing the combo, or code in the format event of the section containing the textbox.

Paul

------ Original Message ------

From: "Bill Singer" <Bill.Singer@at-group.net>

To: MSAccessProfessionals@groups.io

Sent: 11/30/2023 9:39:53 AM

Subject: Re: [MSAccessProfessionals] Change background color

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

I have not been able to figure out how to change the background property of a text box.

Any help would be appreciated.

Thanks,

Bill

Bill Singer

Re: [MSAccessProfessionals] Change background color

I am using equation this in the source field to change a text box on a Report based on a selection in a previous form

=IIf([Forms]![f_PremCollFormSetup]![cboNewPlan]=1,"X","")

It work fine, but rather than an X in the text box, I would rather turn the background of the box black so it stand out more.

I have not been able to figure out how to change the background property of a text box.

Any help would be appreciated.

Thanks,

Bill

Bill Singer

Senin, 27 November 2023

Re: [MSAccessProfessionals] Change Value based on another value

Happy to help Bill!

Paul

Sent via mobile device

-------- Original message --------

From: Bill Singer <Bill.Singer@at-group.net>

Date: 11/27/23 9:13 AM (GMT-05:00)

To: MSAccessProfessionals@groups.io

Subject: Re: [MSAccessProfessionals] Change Value based on another value

Paul,

This worked perfectly.

Thanks

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Paul Baldy
Sent: Wednesday, November 22, 2023 2:43 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

To MSAccessProfessionals@groups.io

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup
I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer
Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Change Value based on another value

Paul,

This worked perfectly.

Thanks

Bill

Bill Singer

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

To MSAccessProfessionals@groups.io

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup
I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer
Bill.Singer@at-group.net

Kamis, 23 November 2023

Re: [MSAccessProfessionals] Change Value based on another value

Duane,

I will give it a try.

Wow, cardiac arrest, even with all the biking you do. I am very glad the EMT was close.

With your perspective I understand how this year would be special.

Thanks again.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io On Behalf Of Duane Hookom
Sent: Thursday, November 23, 2023 12:46 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

You could use code similar to what Paul suggested in the after update event.

Happy Thanksgiving to you also. This year is special for me since I had a major cardiac arrest in June. I wouldn't be here if not for the ten EMTs within 50' of me when it happened.

Duane

Sent from my mobile

On Nov 23, 2023, at 12:22 PM, Bill Singer <Bill.Singer@at-group.net> wrote:

Duane,
Happy Thanksgiving to you. I have been refreshing my knowledge on DLookup.

Will DLookup just display the information or will it assign the value to the field CTICRUHealth. The example I looked at has the DLookup in the Source property and I am thinking that would disconnect it from the table behind the form.

I am not at work now so I did not actually try this yet.

Thanks,

Bill

Bill Singer

From: MSAccessProfessionals@groups.io On Behalf Of Duane Hookom
Sent: Wednesday, November 22, 2023 3:27 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

I would probably create a small table of ranges that allow you to easily change the upper and lower range values as well as the return value. Your after update code would then use DLookup() with the CTICOBRACount between the low and high values and return the CTICRUHealth value. I always try avoid hard-coding values.

Duane
Sent from my mobile

On Nov 22, 2023, at 2:43 PM, Paul Baldy <Pbaldy@gmail.com> wrote:

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------
From "Bill Singer" <Bill.Singer@at-group.net>
To MSAccessProfessionals@groups.io
Date 11/22/2023 10:22:41 AM
Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup
I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.
Do I use iff or If then…
It has been a while since I had to add programming.
Thanks for your help.

Bill

Bill Singer
Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Change Value based on another value

You could use code similar to what Paul suggested in the after update event.

Happy Thanksgiving to you also. This year is special for me since I had a major cardiac arrest in June. I wouldn't be here if not for the ten EMTs within 50' of me when it happened.

Duane

Sent from my mobile

On Nov 23, 2023, at 12:22 PM, Bill Singer <Bill.Singer@at-group.net> wrote:

Duane,

Happy Thanksgiving to you. I have been refreshing my knowledge on DLookup.

Will DLookup just display the information or will it assign the value to the field CTICRUHealth. The example I looked at has the DLookup in the Source property and I am thinking that would disconnect it from the table behind the form.

I am not at work now so I did not actually try this yet.

Thanks,

Bill

Bill Singer

From: MSAccessProfessionals@groups.io On Behalf Of Duane Hookom
Sent: Wednesday, November 22, 2023 3:27 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

I would probably create a small table of ranges that allow you to easily change the upper and lower range values as well as the return value. Your after update code would then use DLookup() with the CTICOBRACount between the low and high values and return the CTICRUHealth value. I always try avoid hard-coding values.

Duane

Sent from my mobile

On Nov 22, 2023, at 2:43 PM, Paul Baldy <Pbaldy@gmail.com> wrote:

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

To MSAccessProfessionals@groups.io

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup

I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Change Value based on another value

Duane,

Happy Thanksgiving to you. I have been refreshing my knowledge on DLookup.

Will DLookup just display the information or will it assign the value to the field CTICRUHealth. The example I looked at has the DLookup in the Source property and I am thinking that would disconnect it from the table behind the form.

I am not at work now so I did not actually try this yet.

Thanks,

Bill

Bill Singer

From: MSAccessProfessionals@groups.io On Behalf Of Duane Hookom
Sent: Wednesday, November 22, 2023 3:27 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Change Value based on another value

I would probably create a small table of ranges that allow you to easily change the upper and lower range values as well as the return value. Your after update code would then use DLookup() with the CTICOBRACount between the low and high values and return the CTICRUHealth value. I always try avoid hard-coding values.

Duane

Sent from my mobile

On Nov 22, 2023, at 2:43 PM, Paul Baldy <Pbaldy@gmail.com> wrote:

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------
From "Bill Singer" <Bill.Singer@at-group.net>
To MSAccessProfessionals@groups.io
Date 11/22/2023 10:22:41 AM
Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup
I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.
Do I use iff or If then…
It has been a while since I had to add programming.
Thanks for your help.

Bill

Bill Singer
Bill.Singer@at-group.net

Rabu, 22 November 2023

Re: [MSAccessProfessionals] Change Value based on another value

Great point, that's what I would do too. I didn't see the forest for the trees.

Paul

Sent via mobile device

-------- Original message --------

From: Duane Hookom <duanehookom@hotmail.com>

Date: 11/22/23 4:26 PM (GMT-05:00)

To: MSAccessProfessionals@groups.io

Subject: Re: [MSAccessProfessionals] Change Value based on another value

Duane

Sent from my mobile

On Nov 22, 2023, at 2:43 PM, Paul Baldy <Pbaldy@gmail.com> wrote:

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

To MSAccessProfessionals@groups.io

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup

I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Change Value based on another value

Duane

Sent from my mobile

On Nov 22, 2023, at 2:43 PM, Paul Baldy <Pbaldy@gmail.com> wrote:

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

To MSAccessProfessionals@groups.io

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup

I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Change Value based on another value

Something along the lines of:

Me.CTICRUHealth = IIf(Me.CTICOBRACount > 19, 1, 2)

In the after update event of CTICOBRACount. It could also be done with an If/Then block, as you prefer.

Paul

------ Original Message ------

From "Bill Singer" <Bill.Singer@at-group.net>

To MSAccessProfessionals@groups.io

Date 11/22/2023 10:22:41 AM

Subject [MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup
I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer
Bill.Singer@at-group.net

[MSAccessProfessionals] Change Value based on another value

I am having a hard time figuring out best way to change the value of 3 fields on a form, based on the initial input in another field.

I have a form named f_PremCollFormSetup

I have a field in that form called CTICOBRACount

When a person enters a value into CTICOBRACount and if that value is over 19 I want to set/change the value in the fields called CTICRUHealth and CTICRUDental to a value of 1

And if the value of CTICOBRACount is not over 19 I want to set/change the value to 2.

I am having a hard time figuring out where the best place to put this. I am guessing in the AFTER UPDATE property of the CTICOBRACount field.

Do I use iff or If then…

It has been a while since I had to add programming.

Thanks for your help.

Bill

Bill Singer

Bill.Singer@at-group.net

Senin, 20 November 2023

Re: [MSAccessProfessionals] PDF forms

Thanks for the offer. I do not have Adobe Pro. I use Power PDF Standard as my pdf editor. I am not sure if that is an issue.

At this point, I changed my pdf into a png file and added it to a report. I will then add fields on top of the report. Right I am creating the forms and gathering the information to populate the fields.

I appreciate the offer, I may be back.

😊

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Cheeseburger via groups.io
Sent: Monday, November 20, 2023 9:00 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] PDF forms

Bill, is this a fillable PDF? If it is, you can use code to update the controls in the pdf. But you would need Adobe Pro and some time.
I have done this with a few of my clients and they love it.
If your desire is to take a fillable PDF and fill in the text boxes and check boxes, then let me know and I will try and provide help.

Re: [MSAccessProfessionals] PDF forms

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Jumat, 17 November 2023

Re: [MSAccessProfessionals] Strange Combo Box Behavior

Are you sure the bound column is the expected field? Try add a text box with a control source of =[Your Combo Box Name]

Btw: please reply with the previous email content so we have the history.

Duane

On Nov 17, 2023, at 9:31 AM, paco@cellarinfo.com wrote:

The autoexpand only works for the letters "a" and "b." If I select a record from the dropdown list, the find works. For some forms with identical cboFind combo boxes, everything works as expected. I believe you are correct that the issue is related to the known bug. However, I was able to test on a Surface Pro 6 with the same Windows 11 build and it worked fine. Very strange.

Thanks for the info. I'll just wait to see if a future W11 build corrects the issue.

Re: [MSAccessProfessionals] PDF forms

Bill

You will need a PDF editor. Or if you are good at image editing, you can save the PDF as an image and then put the boxes on the image. Once they are in place, you can save the image as a PDF again.

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, November 17, 2023 3:32 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] PDF forms

Hmmm, Where do I learn how to edit the pdf so it has check boxes already in it. Do you know of a video or some directions. I did not know this was an option.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io On Behalf Of Bill Mosca
Sent: Friday, November 17, 2023 5:09 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] PDF forms

Bill

Try loading the PDF in an image control. As to adding checkboxes, you might be able to place those controls on top of the image, but why not just edit the PDF so it has the checkboxes already on it?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Friday, November 17, 2023 10:06 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] PDF forms

I have Access 365 on a Window 11 machine.

I am wondering if there is any way to load a PDF onto a Report and then add check boxes over the PDF to filling a variety of check boxes.

The form is pretty complex so I do not want to recreate it using lines and boxes.

Bill

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] PDF forms

Hmmm, Where do I learn how to edit the pdf so it has check boxes already in it. Do you know of a video or some directions. I did not know this was an option.

Bill

Bill Singer

Bill

Try loading the PDF in an image control. As to adding checkboxes, you might be able to place those controls on top of the image, but why not just edit the PDF so it has the checkboxes already on it?

Regards,

Bill Mosca

I have Access 365 on a Window 11 machine.

I am wondering if there is any way to load a PDF onto a Report and then add check boxes over the PDF to filling a variety of check boxes.

The form is pretty complex so I do not want to recreate it using lines and boxes.

Bill

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Strange Combo Box Behavior

Have you checked the RowSource to see if it is selecting all the records you want?

Regards,

Bill Mosca

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of paco@cellarinfo.com
Sent: Friday, November 17, 2023 7:32 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Strange Combo Box Behavior

The autoexpand only works for the letters "a" and "b." If I select a record from the dropdown list, the find works. For some forms with identical cboFind combo boxes, everything works as expected. I believe you are correct that the issue is related to the known bug. However, I was able to test on a Surface Pro 6 with the same Windows 11 build and it worked fine. Very strange.

Thanks for the info. I'll just wait to see if a future W11 build corrects the issue.

Re: [MSAccessProfessionals] PDF forms

Bill

Try loading the PDF in an image control. As to adding checkboxes, you might be able to place those controls on top of the image, but why not just edit the PDF so it has the checkboxes already on it?

Regards,

Bill Mosca

I have Access 365 on a Window 11 machine.

I am wondering if there is any way to load a PDF onto a Report and then add check boxes over the PDF to filling a variety of check boxes.

The form is pretty complex so I do not want to recreate it using lines and boxes.

Bill

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] PDF forms

I have Access 365 on a Window 11 machine.

I am wondering if there is any way to load a PDF onto a Report and then add check boxes over the PDF to filling a variety of check boxes.

The form is pretty complex so I do not want to recreate it using lines and boxes.

Bill

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

Re: [MSAccessProfessionals] Strange Combo Box Behavior

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Kamis, 16 November 2023

Re: [MSAccessProfessionals] Strange Combo Box Behavior

Are you suggesting the combo box doesn't allow selecting values other than a or b? Or is the correct value selected in the combo box but the find doesn't work?

There is a known bug with combo boxes as noted at https://www.accessforever.org/post/combo-box-auto-expand-may-not-work-correctly-in-windows-11

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of paco@cellarinfo.com <paco@cellarinfo.com>

II have a combo box on a form that is used to find a specific record. The behavior is that when the first letter of the record to find is entered, the combo box record list moves to that record so that hitting enter displays the selected record on the form - fairly standard cboFind. The problem is that it works as expected when an "a" or a "b" is entered. Anything above a or b doesn't produce the expected behavior. Even stranger is that I have an almost identical form where everything works fine (one looks up wine and the other looks of wineries). In fact, there are several other forms where the find works as expected. The recordset for the form that doesn't work is around 750 and is sorted alphabetically.

Any ideas?

If Me.CurrentView = 2 Then

Exit Sub

End If

Me.FilterOn = False

DoCmd.GoToControl "txtWine"

DoCmd.FindRecord "" & Me!cboFind & ""

Me.sfrmWineLocation.SetFocus

Me.cboFind = Null

Version

__._,_

[MSAccessProfessionals] Strange Combo Box Behavior

Any ideas?

If Me.CurrentView = 2 Then

Exit Sub

End If

Me.FilterOn = False

DoCmd.GoToControl "txtWine"

DoCmd.FindRecord "" & Me!cboFind & ""

Me.sfrmWineLocation.SetFocus

Me.cboFind = Null

Version

Selasa, 14 November 2023

Re: [MSAccessProfessionals] Return records less than 2 years from CurrentDate

No problem Jim!

Paul

------ Original Message ------

From "Jim Wagner" <josephwagner2@outlook.com>

To MSAccessProfessionals@groups.io

Date 11/14/2023 11:27:22 AM

Subject Re: [MSAccessProfessionals] Return records less than 2 years from CurrentDate

On Tue, Nov 14, 2023 at 12:02 PM, Paul Baldy wrote:

< DateAdd("yyyy", -2,Date())
Thank You Paul. That was the answer. I appreciate your help.

Jim Wagner