ACCESS FEED

Kamis, 17 Desember 2020

Re: [MSAccessProfessionals] row source and auto numbering

Yes I agree. the point i suppose is that i need to break down the actions of the a lot more, that i can make several templates with and link them to the client, thanks for the suport

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] row source and auto numbering

Thanks it looks like i need revise how i communicate what want to achive.

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Custom Ribbon not showing

On Thu, Dec 17, 2020 at 04:16 PM, Arnelito Puzon wrote:

each Form/Report has "Ribbon Name" property (Property->Other).
you put the name of your custom ribbon there.

On Thu, Dec 17, 2020 at 12:27 PM Bill Mosca <wrmosca@myself.com> wrote:

This is my first time using a custom ribbon and I can't get things to jive. You know, old dogs, new tricks stuff I guess.

The main ribbon is limited to just the Home tab. It uses XML that Daniel Pineault wrote years ago. That part works. Here is the XML:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

<ribbon startFromScratch="true">

<tabs>

<tab id="tabMain" label="Home">

<group id="grpMain" label="Main">

<button id="cmdHome" label="Home" onAction="OnActionButton" size="large" imageMso="OpenStartPage"/>

</group>

</tab>

</tabs>

</ribbon>

</customUI>

In File tab >Options>current database, the ribbon is selected as the Ribbon Name. That ribbon loads as expected.

All my reports have a different custom ribbon chosen as the report's ribbon. It has various buttons for printing, emailing as attachment, saving results to spreadsheet, etc. Each button calls a function. I used Gunter Aveniius's Ribbon Creator (2013-2016). All I really need is to it load onto the main ribbon, or even replace the main ribbon as long as the report is open in preview.

My problem is the report ribbon is not loading onto the main ribbon. The property Start from scratch is set to false. I've tried setting it to tru but that didn't make any difference.
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

--

Arnelito G. Puzon

Arnelito - Thank you for taking the time to respond. I did put the name of the ribbon in the report's property sheet by selecting it from the dropdown. As far as I can see, I am not doing anything in VBA code that would block this custom ribbon.

--

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.

_._,_._,_

[MSAccessProfessionals] Custom Ribbon not showing

This is my first time using a custom ribbon and I can't get things to jive. You know, old dogs, new tricks stuff I guess.

The main ribbon is limited to just the Home tab. It uses XML that Daniel Pineault wrote years ago. That part works. Here is the XML:

<tabs>

</group>

</tab>

</tabs>

</ribbon>

</customUI>

In File tab >Options>current database, the ribbon is selected as the Ribbon Name. That ribbon loads as expected.

All my reports have a different custom ribbon chosen as the report's ribbon. It has various buttons for printing, emailing as attachment, saving results to spreadsheet, etc. Each button calls a function. I used Gunter Aveniius's Ribbon Creator (2013-2016). All I really need is to it load onto the main ribbon, or even replace the main ribbon as long as the report is open in preview.

My problem is the report ribbon is not loading onto the main ribbon. The property Start from scratch is set to false. I've tried setting it to tru but that didn't make any difference.

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

On Mon, Dec 14, 2020 at 09:50 PM, ozairkhalidozair wrote:

Bill,

Not sure if I made a mistake, please see attached screenshot.

This is what I see when I tried the add-in on two different computers.

Windows 10 with Office 2016 64 bit

Windows Server 2012 R2 (via RDP) with Office 2016 64 bit

FYI in the modules, I replaced all "Declare" with "Declare PtrSafe".

Best,

Ozair Khalid

Ozair - Once you install an Add-in, MS will put a copy of it in its own Add-in folder. You have to remove that copy after you uninstall the add-in.
Please make sure you do these steps:

unzip the file to C:\ThatllDoIT\.
open Access and uninstall the add-in if it is installed.
Close Access
Open windows explorer. Under the View tab, check the box to show hidden items.
Go to C:\Users\<your user name>\AppData\Roaming\Microsoft\AddIns and delete the file. This is necessary because MS remembers that location and you want it to look in C:|ThatllDoIT\ instead of its default folder.
Open Access and add the add-in again.

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.

_._,_._,_

Senin, 14 Desember 2020

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

Bill,

Not sure if I made a mistake, please see attached screenshot.

This is what I see when I tried the add-in on two different computers.

Windows 10 with Office 2016 64 bit
Windows Server 2012 R2 (via RDP) with Office 2016 64 bit

FYI in the modules, I replaced all "Declare" with "Declare PtrSafe".

Best,

Ozair Khalid

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

On Mon, Dec 14, 2020 at 02:15 PM, jfejsa wrote:

Hi Bill,

I would love a copy of the new version.

Where do I find it?

Thank you.

John

Sent from my Galaxy

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

From: Bill Mosca <wrmosca@myself.com>

Date: 15/12/20 9:06 am (GMT+10:00)

To: MSAccessProfessionals@groups.io

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

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

Hi John
Just go to our files folder. You can find it in the 0_utilities_add-ins folder.

--

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.

_._,_._,_