Re: [MSAccessProfessionals] Binary Data in Forms and Reports

hi Norbert,

perhaps compiled code is one of those ... who knows ... undocumented! As you figure things out, share back!

When you reply, please look and "include previous� messages", "Quote Post" or something like that so we can see the whole thread, thanks

Quote Post .. Duane uploaded an image here:

https://groups.io/g/MSAccessProfessionals/photofromactivity?id=2977001

kind regards,
crystal

================

On 10/4/2021 4:00 PM, drnorb wrote:

Dear Crystal,
Sorry, you are correct I meant 1999, the inception of Access version 1.0 was on 11/ 1992.

I am still puzzled about what creates the Binary Data in forms and reports even though they don't have an image included.

Regards,

Norbert

On 10/3/2021 12:30 PM, crystal (strive4peace) via groups.io wrote:

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