ACCESS FEED

Minggu, 03 Oktober 2021

Re: [MSAccessProfessionals] Binary Data in Forms and Reports

hi Norbert,

Thanks! AutoCorrect is a big culprit. It would be nice to have a list :)

1989 was before Access -- aï¿½ long time ago though ~ I made that note in 2010.

kind regards,
crystal

ï¿½

~ remote training and programming ~

connect to me, let's do it together

On 10/3/2021 11:47 AM, drnorbert@gmail.com wrote:

Hi Crystal,

Wonderful to hear from you.
You are correct, John suggested to me in 1989.
The issue with the reports and forms is that they tend to bloat.
I want to find out what creates the binary data in a form and report.
I delete all the binary data and the form size reduces to almost half.
Let me know if you are familiar with this issue.

Regards,

Norbert

On 10/3/2021 9:36 AM, crystal (strive4peace) via groups.io wrote:

hi Norbert,

thanks for sharing.

The text files created by SaveAsText are undocumented, and indeed interesting. Several years ago, John Viescas said to "Delete everthing between NameMap = Begin and the matching End statement and save the file." for cleaning up what AutoCorrect does.

kind regards,
crystal

Document Access Tables to Excel
https://www.youtube.com/watch?v=r6LRurruI44

On 10/3/2021 8:20 AM, drnorbert2002 wrote:

How and when the binary data is created in forms and reports?

ï¿½

I use the two undocumented functions. Application.SaveAsText and Application.LoadFromText ï¿½functions to export the form/report definitions, identify the binary data blocks and

I clean up the definition, and then import it again.

The Binary Data Blocks starts in ï¿½Parameter = Beginï¿½ and ends with ï¿½Endï¿½.

Also the I delete the ï¿½Checksum=ï¿½ line. (should be on line 3)

The data blocks are in the following parameters.

NameMap

PrtMip

PrtDevMode

PrtDevNames

PrtDevModeW

PrtDevNamesW

Thanks,

ï¿½

Norbert

ï¿½

Norbert Foigelman, Ph.D.

NSF Services Corp.

Newport Beach, CA

Re: [MSAccessProfessionals] Binary Data in Forms and Reports

Hi Crystal,

Wonderful to hear from you.
You are correct, John suggested to me in 1989.
The issue with the reports and forms is that they tend to bloat.
I want to find out what creates the binary data in a form and report.
I delete all the binary data and the form size reduces to almost half.
Let me know if you are familiar with this issue.

Regards,

Norbert

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Re: [MSAccessProfessionals] Binary Data in Forms and Reports

hi Norbert,

thanks for sharing.

The text files created by SaveAsText are undocumented, and indeed interesting. Several years ago, John Viescas said to "Delete everthing between NameMap = Begin and the matching End statement and save the file." for cleaning up what AutoCorrect does.

kind regards,
crystal

Document Access Tables to Excel
https://www.youtube.com/watch?v=r6LRurruI44

On 10/3/2021 8:20 AM, drnorbert2002 wrote:

How and when the binary data is created in forms and reports?

ï¿½

I use the two undocumented functions. Application.SaveAsText and Application.LoadFromText ï¿½functions to export the form/report definitions, identify the binary data blocks and

I clean up the definition, and then import it again.

The Binary Data Blocks starts in ï¿½Parameter = Beginï¿½ and ends with ï¿½Endï¿½.

Also the I delete the ï¿½Checksum=ï¿½ line. (should be on line 3)

The data blocks are in the following parameters.

NameMap

PrtMip

PrtDevMode

PrtDevNames

PrtDevModeW

PrtDevNamesW

Thanks,

ï¿½

Norbert

ï¿½

Norbert Foigelman, Ph.D.

NSF Services Corp.

Newport Beach, CA

[MSAccessProfessionals] Binary Data in Forms and Reports

How and when the binary data is created in forms and reports?

I use the two undocumented functions. Application.SaveAsText and Application.LoadFromText functions to export the form/report definitions, identify the binary data blocks and

I clean up the definition, and then import it again.

The Binary Data Blocks starts in “Parameter = Begin” and ends with “End”.

Also the I delete the “Checksum=” line. (should be on line 3)

The data blocks are in the following parameters.

NameMap
PrtMip
PrtDevMode
PrtDevNames
PrtDevModeW
PrtDevNamesW

Thanks,

Norbert

Norbert Foigelman, Ph.D.

NSF Services Corp.

Newport Beach, CA

Jumat, 01 Oktober 2021

Re: [MSAccessProfessionals] Lockdown

Thank you….

Sent from Mail for Windows

From: Bill Mosca
Sent: Friday, October 1, 2021 2:28 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

Hi Dean,

You can find several versions here: https://groups.io/g/MSAccessProfessionals/files/0_Utilities%20and%20Add-ins

-Bill Mosca

On Fri, Oct 1, 2021 at 11:25 AM, Dean Waring wrote:

Where can I find PropertiesSetter utility imentioned in this email.

Thank you

Dean Waring

Sent from Mail for Windows

From: Bill Singer
Sent: Thursday, September 23, 2021 2:26 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

I have not had a chance to track this down, however I do not have an Auto Exec.

Thanks for the help.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Thursday, September 23, 2021 1:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

Hi Bill & Duane

I put a call to my lockdown stuff in my startup form's Load event. You might want to use my PropertiesSetter utility in our files/0_Utilities%20and%20Add-ins folder. It will let you bypass startup forms, autoexec macros and set the properties you want on the target database so you can get in to poke around to find your module and where it is being called.

MZTools for VBA has a feature that will track down all places a function or sub is called. That might be helpful as well. It's not free, but it's well worth the price. You can download it at https://www.mztools.com/v8/download_trial.aspx By the way, this add-in has been my go-to for 20 years. Too many features to list here.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 12:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function.

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:

I have a module called Lockdown which locks down a lot of properties from an end user. It appears to run on database startup. I put this in a few years ago and now I want to remove it. How do I keep this from running upon start up? I am guessing if I just delete it there will be issues.

Bill Singer

Microsoft Office 365

Windows 10

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] Lockdown

Hi Dean,

You can find several versions here: https://groups.io/g/MSAccessProfessionals/files/0_Utilities%20and%20Add-ins

-Bill Mosca

On Fri, Oct 1, 2021 at 11:25 AM, Dean Waring wrote:

Where can I find PropertiesSetter utility imentioned in this email.

Thank you

Dean Waring

Sent from Mail for Windows

From: Bill Singer
Sent: Thursday, September 23, 2021 2:26 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

I have not had a chance to track this down, however I do not have an Auto Exec.

Thanks for the help.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Thursday, September 23, 2021 1:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

Hi Bill & Duane

I put a call to my lockdown stuff in my startup form's Load event. You might want to use my PropertiesSetter utility in our files/0_Utilities%20and%20Add-ins folder. It will let you bypass startup forms, autoexec macros and set the properties you want on the target database so you can get in to poke around to find your module and where it is being called.

MZTools for VBA has a feature that will track down all places a function or sub is called. That might be helpful as well. It's not free, but it's well worth the price. You can download it at https://www.mztools.com/v8/download_trial.aspx By the way, this add-in has been my go-to for 20 years. Too many features to list here.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 12:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function.

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:

I have a module called Lockdown which locks down a lot of properties from an end user. It appears to run on database startup. I put this in a few years ago and now I want to remove it. How do I keep this from running upon start up? I am guessing if I just delete it there will be issues.

Bill Singer

Microsoft Office 365

Windows 10

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] Lockdown

Where can I find PropertiesSetter utility imentioned in this email.

Thank you

Dean Waring

Sent from Mail for Windows

From: Bill Singer
Sent: Thursday, September 23, 2021 2:26 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

I have not had a chance to track this down, however I do not have an Auto Exec.

Thanks for the help.

Bill

Bill Singer

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Thursday, September 23, 2021 1:00 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

Hi Bill & Duane

I put a call to my lockdown stuff in my startup form's Load event. You might want to use my PropertiesSetter utility in our files/0_Utilities%20and%20Add-ins folder. It will let you bypass startup forms, autoexec macros and set the properties you want on the target database so you can get in to poke around to find your module and where it is being called.

MZTools for VBA has a feature that will track down all places a function or sub is called. That might be helpful as well. It's not free, but it's well worth the price. You can download it at https://www.mztools.com/v8/download_trial.aspx By the way, this add-in has been my go-to for 20 years. Too many features to list here.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 22, 2021 12:13 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Lockdown

There are several places this could be called from at startup. I would check for the AutoExec macro first. Then check the code in the form that opens when the file is run. There is also a command line parameter that can run any macro. If this doesn't help, search the VBA for the sub or function.

Duane

Sent from my mobile

On Sep 22, 2021, at 2:05 PM, Bill Singer <Bill.Singer@at-group.net> wrote:

I have a module called Lockdown which locks down a lot of properties from an end user. It appears to run on database startup. I put this in a few years ago and now I want to remove it. How do I keep this from running upon start up? I am guessing if I just delete it there will be issues.

Bill Singer

Microsoft Office 365

Windows 10