report forms all of a sudden minimalising when loading

[ShaunG]

it seems to be after i open a report in design view when open in form view its minimalised, the overlapping windows is checked.



it was working fine when i was working on the usb and then i saved the database over an original to update it and this issue has occurred.... any body else had this happen?

ive tried compacting and repair which help a few times when working off the usb but since i have saved over main db issue does not go away.

[Minty]

Be very wary of opening a Database from a USB Stick, I've seen corruption occur where the PC has "dropped" the USB connection for some reason in the middle of doing something.
Always copy it to your local drive, do the work then copy it back.

[ShaunG]

i have worked out what my problem is but not sure how to fix it......

so my shortcut to database properties are set to minimalize so ms access is not in the back ground. when i change back everything works.

ive tried minimalising with vba when form loads and restoring the reports but comes up with memory space error..

any ideas?

[ShaunG]

Be very wary of opening a Database from a USB Stick, I've seen corruption occur where the PC has "dropped" the USB connection for some reason in the middle of doing something.
Always copy it to your local drive, do the work then copy it back.

im only working on a the db with the usb and didnt think that would be an issue.... no worries will do from now on!!

[ShaunG]

managed to get it the report to fit full screen when shortcut minimalised on open using below code.

DoCmd.OpenReport "rptVariationstoJob", acViewPreview            
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow

would be good for it to not be full screen, this is better then nothing but if there's a better way i'm open for suggestions.

[Minty]

Does restore not bring it back to it's original size ?

[ShaunG]

No It doesn’t Minty I get an access memory not sufficient message come when form loads.
using Docmd.restore in form load events

[Minty]

Hmm interesting.

When I get a moment i'll dig some code out i use to manage form sizes and positions.
In the meantime have a dig around for some samples from Ridders, he has a sample database that hides and removes forms / splash screens etc.

[isladogs]

Hmm interesting.

When I get a moment i'll dig some code out i use to manage form sizes and positions.
In the meantime have a dig around for some samples from Ridders, he has a sample database that hides and removes forms / splash screens etc.

I think Minty is referring to this http://www.mendipdatasystems.co.uk/c...ace/4594365418

HTH

[Missinglinq]

Also note that you should be aware of the dangers of using USB stick to transfer Access files from one box to another! I've seen beaucoup reports of file corruption happening when this is done...apparently caused by the computer reporting 'transfer complete,' when this is not 100% true, and the flash drive being yanked out quickly! Best to count ten, after the 'complete' message appears, before removing the drive, even on Friday afternoon at quitting time!

Linq ;0)>

[ShaunG]

thanks for that Minty, ill do that.

ridders52 thanks ill have a look.

Missinglinq thanks for the advice, fridays are always a quick escape. lol will try my best to stay away from usb work.