Combo Box will only work if Access is no minimized

[moke123]

As an aside, with a combo you can add text to the format property of a combo so you do not need to have "Pick Desired Report" as a choice.


It eliminates the need for some of your code. When the combo is null it will display "Pick Desired Report"

In the format property of the combo put

@ ;"Pick Desired Report"

You also should be using the afterupdate event, not the click event of the combo.

[moke123]

Oops, deleted double post.

[pledbetter]

500k max file size. Are you kidding me? I stripped out all data tables and queries and left the autoexec and two forms and I'm still over 2000k. This interface is very cryptic. I does not ever throw an error. It just acts like it's loading then if your file does not satisfy any one of it's quasi-unstated parameters, it will just stop and look at you without the decency of an error announcement, let alone telling you what the precise error is. It's only after I decided to click on a very small question mark did the file size limitation pop up. Well, let' see what I can do.

[Welshgasman]

Have you never heard of a zip file?
Right click the file in Explorer and Send To/Compressed (Zipped) Folder.

Also Compact the DB before even trying that.

[pledbetter]

Max allowed is 500k. The smallest I can get it (as a Zip) is 1307k. What are my options? Anyone want to receive an FTP?

[pledbetter]

Cross-Posted https://www.access-programmers.co.uk...imized.333702/

[Welshgasman]

Thank you for the crosspost notification.

[pledbetter]

OK, so here is the solution. My autoexec was opening my main switchboard form as Read-Only. Totally missed it. Appreciate all the help here.

[Micron]

The smallest I can get it (as a Zip) is 1307k.

Sometimes this is because you have embedded images in things like buttons, form backgrounds, report headers and the like. Those are stored in a system table and you'd never get the file size down small enough because of that. If that's your problem, it's usually best to link images and keep them in the same folder as the db, or a sub folder of it.

[Welshgasman]

Max allowed is 500k. The smallest I can get it (as a Zip) is 1307k. What are my options? Anyone want to receive an FTP?

We only need enough to see the issue? So create a new DB and import just what is needed for that.

[pledbetter]

I cut it down to just what was needed. I removed everything except the autoexec macro, two forms, and my VBA modules. Then I compacted, then created a Zip file. Removing anything else would have been fatal to what I was trying to demonstrate. I could have removed more VBA code, but I really don't think that would have accounted for 1200k of file size.

[Micron]

If you want feedback on why that may have been necessary, post a copy to a file share and post a link here.