Search results

Guys, thank you for discussion - I found property sheets - the panel was hiding to the left of the form view panel. Thank you!

Exactly my problem. I did it many times trying to find check related to the property sheet ... This code did not help either: Private Sub ShowToolBars() Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i End Sub

Well ... I'm working remotely via Citrix/Remote Desktop and cannot change the resolution. Just one thing: two months ago, the Properties panel was there. It disappeared after Microsoft patches (?) were installed ...

No, just one screen ...

Question: usually if I open form in design mode, right click a control and select Properties, a panel popups with the properties of the control. However lately this property panel is not visible anymore. Any database. Please advice how to bring it back? I'm running Access 365 accdb

86Mb instead of 120 ... will check how does it work ...

Good idea ... will try

That's true

Interesting ... good to know ... thank you ... I'll try to split during the weekend ....

Thank you ... I would expect that other Access databases (even after C&R) would also behave like the one in question, e.g. to show the same size again and again ... but this is not the case, they always shrink after compacting

There was no ldb file ...

I added a "big" table from the external database, C&R - the size increased 20 Mb (140 instead of 120), then deleted this table, C&R - but the size remains the same 140 Mb ...

Yes ... and some remote to office laptop desktop via Citrix, others take laptops home and logged into the corporate network ...

Is it something like SQL Server pages?

Chunk? Interesting ...where can I read about chunks?

Good idea! Thanks ...

This is very true ... but (back to our sheep) why the size is the same?

Spiting is a way to go (I tried it with other databases some time ago, FE linked to BE - it slows down the performance to the degree of users loosing not only patience but sanity).

As you didn't respond to Gasman's earlier reply <== you mean I did not buy a lottery ticket?