The most bizarre error with graph generation on a form.

[TrulyVisceral]

Ok, quick context here:
I made a simple database for the gerneration of graphs to help my coordinator with his report making. Something with incidents about ATMs and POSs and stuff.

The graphs worked fine, in my office PC, in my house, and my coordinator's...

and then, 2 days ago, he calls me saying they aren't being genereated anymore. I was dead confused for a second. He sends me the DB, I run it and... I can see the graphs. Confused once more. I go to the office, run it there, the graphs work fine.

So then I see my coord. running it himself. He runs it directly from the mail, no download or anything, I was like "Was that it?". Nope, he runs it from the desktop and the same thing, no graphs. So he gives me his laptop for a bit to see what the error is. And I finally realized: The graphs are being generated, they just aren't being shown.

I could copy paste them to powerpoint and excel and they show just fine, they just weren't displaying in Access for some reason, just blank spaces, and only on his laptop as well. They display on design view, but not Layout or Form view.

I made a refresh option, nothing. Modified the graph's layout, nothing. Any idea what's causing it?

He uses a Dell laptop running Windows 7 with Office 2013. Dunno if that makes a difference?


EDIT: WIndows 8, not 7. Sorry.

[Minty]

Are they "off screen" ? . Did you design / save them on a dual monitor set up, and have them float off to another screen. That can cause this.
View them on your PC, on the main monitor, and make sure you re-save them within the normal single monitor viewing area, then try again on the troublesome PC.

[isladogs]

And if Minty's suggestion isn't the answer, is the issue a smaller screen size and/or lower resolution and therefore the charts are too far to the right or too far down?
I use form resizing code to handle these issues.

[TrulyVisceral]

To Minty:
Ok, I suck at explaining. I kept saying PC, but no. All laptops. My house, office, my coord. Only 1 monitor, always.

To ridders52:
Perhaps it is the screen size/resolution, I noticed that a lot of the text was missaligned or a little bit offscreen on my coordinator's laptop, and also my house. Though in my house, even if the text was a bit off, the graphs were fine. So I don't know why my Coord. would be that much different.
I'll go check with him for a sec.

[TrulyVisceral]

And if Minty's suggestion isn't the answer, is the issue a smaller screen size and/or lower resolution and therefore the charts are too far to the right or too far down?
I use form resizing code to handle these issues.

Alright, his resolution is actually HIGHER than either of my laptops. So what would be the problem in that case? We tried changing the resolution to no avail.
For the record, when he first ran it mid May, the graphs showed just fine, so again I don't know.

Now I'm confused even more so. Perhaps I should try to make the forms resize and test that?

EDIT: Ok, tried a couple other things. Maybe the app got damaged or something? So I gave him a new one from my laptop. Same thing.
Changed the text size in the display settings for the laptop. Again nothing.

HOWEVER, there's one thing I did notice. When I open the form with the charts and stuff, the app starts to load them one by one and the cursor goes to the loading symbol. My coord doesn't do that. It just doesn't even try to load. What's up with that?

[TrulyVisceral]

To Ridders52:
Alright. I modified the forms and added some code to resize.

Private Sub Form_Load()
With DoCmd
.Restore
.RunCommand acCmdSizeToFitForm
End With
End Sub

I also added a refresh button because of the thing I said in my last post. And just in case I told him to just hit shift-F9, see if that does anything. He left for something, but I don't know when he'll be back, so I can't say if this works just yet.

[isladogs]

I've never used that shortcut and had to look up what it does
Not sure how requerying the underlying tables helps .. or have I got it wrong?

What code did you use to resize the form?
If you want the free form resizing code by Jamie czernak that I use, let me know and I'll find a download link

[TrulyVisceral]

I've never used that shortcut and had to look up what it does
Not sure how requerying the underlying tables helps .. or have I got it wrong?

What code did you use to resize the form?
If you want the free form resizing code by Jamie czernak that I use, let me know and I'll find a download link

Mate, I don't know, never had to resize anything before, no idea how it works. If you want to give me a link go ahead, thanks in advance.

As for requerying, perhaps I explained wrong once again. I noticed that his version of Access, or maybe his laptopt, or something, just straight up don't try to load, unlike all other's I've tried, which spend a couple seconds loading everything. Maybe requerying helps? I don't know, He hasn't come back yet.

[isladogs]

I can't find a link to his code now (its about 15 years old) but its open source.
So I've attached the version I use which is slightly extended from the original.
Its an entire module with a .bas extension renamed so I can post it here
Remove the .txt from the attached file and you can then import it to the VBE as a standard module e.g. modResizeForm

To use it, design your form to be smaller than usual e.g. so it would fit full screen in a resolution of 800*600.
You will also need to make all objects & font sizes smaller e.g. Calibri 7 pt (for a final size of 11 pt after resizing)
In the form load event , add one line of code:

ResizeForm Me

The form will then expand proportionately to fit the screen size & resolution.
You may need to do a bit of tweaking at first but you'll soon get the hang of it

The only controls that can occasionally be problematic are:
a) tab controls - sometimes don't quite go in the exact position you want
b) option group controls - can cause resizing issues occasionally

I've posted many sample databases that use this code as its in almost everything I do.
For example, see: https://access-programmers.co.uk/for....php?p=1554422

HTH