ACCESS FEED: Januari 2021

Kamis, 28 Januari 2021

Re: [MSAccessProfessionals] 2013 Hide Database window

Hi Bill,

I apologize but I was pulled away and I'm just getting back to this project.

Thank you,

Patty

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Patricia Mapes via groups.io
Sent: Thursday, January 21, 2021 7:39 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] 2013 Hide Database window

Thanks Bill,

I'll give this a try!

Regards,

Patty

On Jan 21, 2021, at 7:31 PM, Bill Mosca <wrmosca@myself.com> wrote:

On Thu, Jan 21, 2021 at 07:57 AM, Patricia Mapes wrote:
Hi,
Does anyone have a good solution for hiding the database windows for access apps.
I would prefer a startup solution but in desperate times I could go firm to form.
Thank you,
Patty
Hi Patty

Here's another way. Call this public function using True argument to show and False argument to hide.
Public Function ShowHideNavPane(bolShow As Boolean)
'Purpose : Show or hide Nav Pane.
'DateTime : 11/23/2020 11:34
'Author : Bill Mosca
'Params : bolShow True=show; False=hide

'Need to select any table in Nav Pane before you can hide it.
If bolShow = False Then
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
Else
DoCmd.SelectObject acTable, , True
End If

End Function

--
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP 2010-2016
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

Minggu, 24 Januari 2021

Re: [MSAccessProfessionals] Unbound Object Frame

hi Youssef,

in whatever application you (or your users) use for the default PDF reader, allow the application to be embedded. For instance, with the free version of Foxit, choose File > Preferences > Documents and enable "In web browser, display PDF in Read Mode by default"

This will enable a file to open inside Access using the web browser control. If you're using a bound control, you might be tied to the application used when the data was created. For an unbound control, I imagine you need to set defaults for the PDF reader, which is done in each user environment, so on each machine.

> "Also, Why I can't see the control source (file path) of this frame in properties window?"

if you're using an UNbound anything, it isn't bound ... code is setting it instead?

kind regards,
crystal

Tips and Shortcuts for the Beginning Access Developer, Part 1, by Maria Barnes and Crystal Long
https://youtu.be/5hf6qX0kBgA

On 1/23/2021 11:48 AM, Youssef wrote:

[Edited Message Follows]
Dear All,

I have a report that contains Unbound object frame this frame view a fixed PDF document

I need to make this frame read a PDF document that it's name will be according to a text box on the same report

Also, Why I can't see the control source (file path) of this frame in properties window?

Thanks in advance

Sabtu, 23 Januari 2021

[MSAccessProfessionals] Unbound Object Frame

[Edited Message Follows]

Dear All,

I have a report that contains Unbound object frame this frame view a fixed PDF document

I need to make this frame read a PDF document that it's name will be according to a text box on the same report

Also, Why I can't see the control source (file path) of this frame in properties window?

Thanks in advance

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] Unbound Object Frame

Dear All,

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Jumat, 22 Januari 2021

Re: [MSAccessProfessionals] View PDF file on a report

If your mso is x32, install acrobat pro (not the reader).

Create a report and insert a webbrowser control (or the acrobat activex).

Resize the control to occupy the entire page.

Set the control source of the control to the path of the pdf file.

On Sat, Jan 23, 2021, 12:43 AM Youssef <youssef2309@gmail.com> wrote:

Dear All,

thanks to support as I need to know how to view a PDF document on an access 2013 report

Thanks in advance

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] View PDF file on a report

Dear All,

thanks to support as I need to know how to view a PDF document on an access 2013 report

Thanks in advance

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Kamis, 21 Januari 2021

Re: [MSAccessProfessionals] 2013 Hide Database window

Thanks Bill,

I'll give this a try!

Regards,

Patty

On Jan 21, 2021, at 7:31 PM, Bill Mosca <wrmosca@myself.com> wrote:

On Thu, Jan 21, 2021 at 07:57 AM, Patricia Mapes wrote:

Hi,
Does anyone have a good solution for hiding the database windows for access apps.
I would prefer a startup solution but in desperate times I could go firm to form.
Thank you,
Patty
Hi Patty

Here's another way. Call this public function using True argument to show and False argument to hide.

Public Function ShowHideNavPane(bolShow As Boolean)

'Purpose : Show or hide Nav Pane.

'DateTime : 11/23/2020 11:34

'Author : Bill Mosca

'Params : bolShow True=show; False=hide

'Need to select any table in Nav Pane before you can hide it.

If bolShow = False Then

DoCmd.SelectObject acTable, , True

DoCmd.RunCommand acCmdWindowHide

Else

DoCmd.SelectObject acTable, , True

End If

End Function

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Re: [MSAccessProfessionals] 2013 Hide Database window

On Thu, Jan 21, 2021 at 07:57 AM, Patricia Mapes wrote:

Hi,
Does anyone have a good solution for hiding the database windows for access apps.
I would prefer a startup solution but in desperate times I could go firm to form.
Thank you,
Patty

Hi Patty

Here's another way. Call this public function using True argument to show and False argument to hide.

Public Function ShowHideNavPane(bolShow As Boolean)

'Purpose : Show or hide Nav Pane.

'DateTime : 11/23/2020 11:34

'Author : Bill Mosca

'Params : bolShow True=show; False=hide

'Need to select any table in Nav Pane before you can hide it.

If bolShow = False Then

DoCmd.SelectObject acTable, , True

DoCmd.RunCommand acCmdWindowHide

Else

DoCmd.SelectObject acTable, , True

End If

End Function

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] 2013 Hide Database window

Thx. Runtime didn't do it in this case.

I just tried : CurrentDb.Properties("StartUpShowDBWindow") = False

I put it on the opening form load event.

This looks like it may do the trick.

Patty

On Jan 21, 2021, at 1:02 PM, Neil Woodnick <neil2336@gmail.com> wrote:

Use runtime ?

On Thu, 21 Jan 2021 at 15:58, Patricia Mapes <patty.mapes@gmail.com> wrote:
Hi,
Does anyone have a good solution for hiding the database windows for access apps.
I would prefer a startup solution but in desperate times I could go firm to form.
Thank you,
Patty

Re: [MSAccessProfessionals] 2013 Hide Database window

Use runtime ?

On Thu, 21 Jan 2021 at 15:58, Patricia Mapes <patty.mapes@gmail.com> wrote:

Hi,
Does anyone have a good solution for hiding the database windows for access apps.
I would prefer a startup solution but in desperate times I could go firm to form.
Thank you,
Patty

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] 2013 Hide Database window

Hi,
Does anyone have a good solution for hiding the database windows for access apps.
I would prefer a startup solution but in desperate times I could go firm to form.
Thank you,
Patty

-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#115842): https://groups.io/g/MSAccessProfessionals/message/115842
Mute This Topic: https://groups.io/mt/80006949/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-

Sabtu, 16 Januari 2021

Re: [MSAccessProfessionals] Rumors about membership fees

Thank you! This group is really very good!

Inviato da iPhone

Il giorno 13 gen 2021, alle ore 20:36, Bill Mosca <wrmosca@myself.com> ha scritto:

Dear members

Rest assured there is no membership fee for our group. Groups.io has announced they will be charging group owners on a per member basis for all NEW groups created AFTER January 18th. We formed our group a long time ago. There will be NO FEES charged us other than the basic fee I pay for making sure we have adequate storage space. I take that on as my own responsibility.

Enjoy the free perks of belonging to an excellent resource for Access development. The moderators and I put a lot of effort in to make sure advice is accurate and our files folder is filled with useful material.

Stay safe and get your vaccines as soon as they are available.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Jumat, 15 Januari 2021

Re: [MSAccessProfessionals] Rumors about membership fees

Thank you very much Bill!

Ozair Khalid

Kamis, 14 Januari 2021

Re: [MSAccessProfessionals] Rumors about membership fees

Thanks Bill!

Em qua., 13 de jan. de 2021 às 18:57, Dean Waring <deanjw2006@msn.com> escreveu:

Thank you for all you do….

Sent from Mail for Windows 10

From: Adeboyejo Oyenuga via groups.io
Sent: Wednesday, January 13, 2021 3:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Rumors about membership fees

Thanks Bill.

Ade

On Wednesday, 13 January 2021, 19:48:56 GMT, Jim Wagner <josephwagner2@outlook.com> wrote:

Bill

Thank You Very Much

Jim Wagner

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Mosca <wrmosca@myself.com>
Sent: Wednesday, January 13, 2021 12:36 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [Special] [MSAccessProfessionals] Rumors about membership fees

Dear members

Rest assured there is no membership fee for our group. Groups.io has announced they will be charging group owners on a per member basis for all NEW groups created AFTER January 18th. We formed our group a long time ago. There will be NO FEES charged us other than the basic fee I pay for making sure we have adequate storage space. I take that on as my own responsibility.

Enjoy the free perks of belonging to an excellent resource for Access development. The moderators and I put a lot of effort in to make sure advice is accurate and our files folder is filled with useful material.

Stay safe and get your vaccines as soon as they are available.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Jaime Agut R.

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Rabu, 13 Januari 2021

Re: [MSAccessProfessionals] Rumors about membership fees

Thank you for all you do….

Sent from Mail for Windows 10

From: Adeboyejo Oyenuga via groups.io
Sent: Wednesday, January 13, 2021 3:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Rumors about membership fees

Thanks Bill.

Ade

On Wednesday, 13 January 2021, 19:48:56 GMT, Jim Wagner <josephwagner2@outlook.com> wrote:

Bill

Thank You Very Much

Jim Wagner

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Mosca <wrmosca@myself.com>
Sent: Wednesday, January 13, 2021 12:36 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [Special] [MSAccessProfessionals] Rumors about membership fees

Dear members

Rest assured there is no membership fee for our group. Groups.io has announced they will be charging group owners on a per member basis for all NEW groups created AFTER January 18th. We formed our group a long time ago. There will be NO FEES charged us other than the basic fee I pay for making sure we have adequate storage space. I take that on as my own responsibility.

Enjoy the free perks of belonging to an excellent resource for Access development. The moderators and I put a lot of effort in to make sure advice is accurate and our files folder is filled with useful material.

Stay safe and get your vaccines as soon as they are available.

--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Re: [MSAccessProfessionals] Rumors about membership fees

Thanks Bill.

Ade

On Wednesday, 13 January 2021, 19:48:56 GMT, Jim Wagner <josephwagner2@outlook.com> wrote:

Bill

Thank You Very Much

Jim Wagner

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Re: [MSAccessProfessionals] Rumors about membership fees

Bill

Thank You Very Much

Jim Wagner

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

[Special] [MSAccessProfessionals] Rumors about membership fees

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Sabtu, 02 Januari 2021

Re: [MSAccessProfessionals] ExportAll Add-In updated for Windows 10

I'm going to crawl out on a limb and assume Richard meant Office 365, the subscription version.

Richard, While I haven't developed a stock data sheet, it seems to me I've seen some out there.

On Sat, Jan 2, 2021 at 01:26 PM, Duane Hookom wrote:

Richard,

I'm not sure what you mean by Office 3. The MS Access version history is documented at https://www.fmsinc.com/microsoftaccess/history/features.htm

Microsoft Access Version Features and Differences Comparison Matrix - FMS, Inc

Microsoft Access Version Differences with database formats, field types, security, containers, form and report features, discontinued features, etc.

www.fmsinc.com

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Richard Power <db_design@hotmail.com>
Sent: Saturday, January 2, 2021 8:51 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] ExportAll Add-In updated for Windows 10

Bill .... I told you wrong I have Office 3

Richard

On Jan 1, 2021, at 8:30 PM, Richard @ <db_design@hotmail.com> wrote:

Bill

I have Microsoft office 10

I am looking for an Excel live download of stock data

Did you develop such a download

If so where can I find it

Richard

On Dec 14, 2020, at 5:06 PM, Bill Mosca <wrmosca@myself.com> wrote:

Hi all

I am in the process of converting one of my more complex MDEs to an ACCDE and found I needed my ExportAll add-in. So I downloaded the 2010 version and installed it. Result was painful. The USYS table entry to create a reg key blew up due to changes in MS Windows 10.

I've since fixed the problem with the key. If anyone wants to try out the add-in please let me know if you find any problems with it. Create a folder on your C drive and name it ThatllDoIT. Unzip the files to that folder. Be sure to read the ReadMe file before installing the Add-in. The About form is out of date as my site is not up right now. I'm retiring at the end of January and just might get my site back up again. And curse Microsoft for breaking my site and then abandoning hosting it and all the other OfficeOnline sites they were hosting.

As always with my utilities and add-ins in the Files section, they are opensource and you can do with them as you wish. You might even learn a few tricks by playing with the code.
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] ExportAll Add-In updated for Windows 10

Richard,

I'm not sure what you mean by Office 3. The MS Access version history is documented at https://www.fmsinc.com/microsoftaccess/history/features.htm

Microsoft Access Version Features and Differences Comparison Matrix - FMS, Inc

Microsoft Access Version Differences with database formats, field types, security, containers, form and report features, discontinued features, etc.

www.fmsinc.com

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Richard Power <db_design@hotmail.com>
Sent: Saturday, January 2, 2021 8:51 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] ExportAll Add-In updated for Windows 10

Bill .... I told you wrong I have Office 3

Richard

On Jan 1, 2021, at 8:30 PM, Richard @ <db_design@hotmail.com> wrote:

Bill

I have Microsoft office 10

I am looking for an Excel live download of stock data

Did you develop such a download

If so where can I find it

Richard

On Dec 14, 2020, at 5:06 PM, Bill Mosca <wrmosca@myself.com> wrote:

Hi all

I am in the process of converting one of my more complex MDEs to an ACCDE and found I needed my ExportAll add-in. So I downloaded the 2010 version and installed it. Result was painful. The USYS table entry to create a reg key blew up due to changes in MS Windows 10.

I've since fixed the problem with the key. If anyone wants to try out the add-in please let me know if you find any problems with it. Create a folder on your C drive and name it ThatllDoIT. Unzip the files to that folder. Be sure to read the ReadMe file before installing the Add-in. The About form is out of date as my site is not up right now. I'm retiring at the end of January and just might get my site back up again. And curse Microsoft for breaking my site and then abandoning hosting it and all the other OfficeOnline sites they were hosting.

As always with my utilities and add-ins in the Files section, they are opensource and you can do with them as you wish. You might even learn a few tricks by playing with the code.
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Re: [MSAccessProfessionals] ExportAll Add-In updated for Windows 10

Bill .... I told you wrong I have Office 3

Richard

On Jan 1, 2021, at 8:30 PM, Richard @ <db_design@hotmail.com> wrote:

Bill

I have Microsoft office 10

I am looking for an Excel live download of stock data

Did you develop such a download

If so where can I find it

Richard

On Dec 14, 2020, at 5:06 PM, Bill Mosca <wrmosca@myself.com> wrote:

Hi all

I am in the process of converting one of my more complex MDEs to an ACCDE and found I needed my ExportAll add-in. So I downloaded the 2010 version and installed it. Result was painful. The USYS table entry to create a reg key blew up due to changes in MS Windows 10.

I've since fixed the problem with the key. If anyone wants to try out the add-in please let me know if you find any problems with it. Create a folder on your C drive and name it ThatllDoIT. Unzip the files to that folder. Be sure to read the ReadMe file before installing the Add-in. The About form is out of date as my site is not up right now. I'm retiring at the end of January and just might get my site back up again. And curse Microsoft for breaking my site and then abandoning hosting it and all the other OfficeOnline sites they were hosting.

As always with my utilities and add-ins in the Files section, they are opensource and you can do with them as you wish. You might even learn a few tricks by playing with the code.
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

Jumat, 01 Januari 2021

Re: [MSAccessProfessionals] ExportAll Add-In updated for Windows 10

Bill

I have Microsoft office 10

I am looking for an Excel live download of stock data

Did you develop such a download

If so where can I find it

Richard

On Dec 14, 2020, at 5:06 PM, Bill Mosca <wrmosca@myself.com> wrote:

Hi all

I am in the process of converting one of my more complex MDEs to an ACCDE and found I needed my ExportAll add-in. So I downloaded the 2010 version and installed it. Result was painful. The USYS table entry to create a reg key blew up due to changes in MS Windows 10.

I've since fixed the problem with the key. If anyone wants to try out the add-in please let me know if you find any problems with it. Create a folder on your C drive and name it ThatllDoIT. Unzip the files to that folder. Be sure to read the ReadMe file before installing the Add-in. The About form is out of date as my site is not up right now. I'm retiring at the end of January and just might get my site back up again. And curse Microsoft for breaking my site and then abandoning hosting it and all the other OfficeOnline sites they were hosting.

As always with my utilities and add-ins in the Files section, they are opensource and you can do with them as you wish. You might even learn a few tricks by playing with the code.
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com