Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
did you follow all of the instructions?zip that and post it here.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I hope it works
thank you for your help
I opened it & the navigation pane was both wide enough & adjustable in width.
I made no changes other than rezipping it to upload
EDIT:
Your attachment has disappeared whilst I did that!
OK I'm confused.
I thought you were uploading from the problem PC.
Also, why did you remove the attachment from your post?
That might well be the case, but my suggestion was just to see if it worked on another computer.?
At the time, you never mentioned you had additional computers to test on, and now you have, it appears it is your computer at fault for some reason, and not your DB?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I am not sure
everything else works well on my computer. it is a one year old Lenovo thinkpad
but thank you
I removed it because I thought it would work like if it was on the pc where it worked
I downloaded mdbs from microsoft, Northwind and other ones
they all present the same problem
so it does not come from my db but from access itself
or is there something in the register , any .dll missing , which could explain this behavior ?
how to check if it is from Access or from Windows ?
is it known that office 16 produces this mistake ?
it is a pain in the neck to work like this
I am not good enough with Access 2016 to make a change, but I wondered
if I could go through my main form to open a list of all objects of the database ?
like a event procedure ??????
any way thank you all for your patience
It still seems like a flawed Access installation. I would definitely recommend removing & reinstalling Office 2016
See if you can make use of my example app: View All Database ObjectsI wondered if I could go through my main form to open a list of all objects of the database ?
![]()
thank you for your example, I downloaded it .I will try to understand how it works, but need a little bit more timeIt still seems like a flawed Access installation. I would definitely recommend removing & reinstalling Office 2016
See if you can make use of my example app: View All Database Objects
I repaired Access, I uninstalled it, I installed the same version with the same id still no change
I got a newer version installed it , bought and used a new key still no change
Did a quick repair, did a thorough repair ........still no change
Did you get any error messages as you downloaded my empty one ?
I didn't get any when I opened Northwind
Could it be in Windows and not in Access ?
I uninstalled the mouse and used my pad...nothing
There were no errors when I tried it. I've deleted it since.
My app automatically lists all the database objects by object type.
Select any object and , depending on what type of object it is, you can open in design view or e.g. form view.
If its a query you can run it.
For modules, you can view the code
If you think its helpful, just import these three objects into your own database(s):
Form - frmDatabaseObjects
Report - rptDatabaseObjects
Table - tblSysObjectTypes
There were no errors when I tried it. I've deleted it since.
My app automatically lists all the database objects by object type.
Select any object and , depending on what type of object it is, you can open in design view or e.g. form view.
If its a query you can run it.
For modules, you can view the code
If you think its helpful, just import these three objects into your own database(s):
Form - frmDatabaseObjects
Report - rptDatabaseObjects
Table - tblSysObjectTypes
thank you I'll try at the week end
I am "cleaning" my db to make work better at the moment
actually it would be interesting to know
what difference there is in office 2016 version 14 and office 2016 version 16
the bug is there I think
either mouse, move bar ....I don't know
no problem in any other app office so far
Did you mean Access 2010 (14.0) compared to Access 2016 (16.0)
I have both versions and use both of them on a regular basis. Neither have this as a bug.