good idea
I'll do that at the week end
thanks
good idea
I'll do that at the week end
thanks
I tried opening my mdb with one other computer
it works perfectly the bar of the panel can be moved with a two sided arrow
so where does that come from ?
thank you
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
tried already
doesn't work
and office does not like to be desinstalled and reinstalled what I also tried
where do I look for missing Dll and how do I do install them ?
I found a pc repair program which should do it, but I don't have any trust.
it wants to suppress a lot of things
I would not mess with a pc repair program for this. I wonder if it's a mouse issue if you got the same db to work on another pc. Try swapping?
Or does that other pc have a different version of Access? If so, COPY your db, put on other pc, re-save the db in that Access version, import back to the usual pc and see what you get.
Could also try right click on nav header, uncheck search bar option and see if that frees it up. This was a known issue in some earlier versions 2007 - 2010?) but you seem to be using 2016.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I would not mess with a pc repair program for this. I wonder if it's a mouse issue if you got the same db to work on another pc. Try swapping?
Or does that other pc have a different version of Access? If so, COPY your db, put on other pc, re-save the db in that Access version, import back to the usual pc and see what you get.
Could also try right click on nav header, uncheck search bar option and see if that frees it up. This was a known issue in some earlier versions 2007 - 2010?) but you seem to be using 2016.
Well I tried every suggestion
my version of Access are different : ON this ocomputer, thr troublesome one I have office 16, on the other one office 14.
I uninstalled on this one(Office 2016 plus, got a new office key)
installed
nothing has changed
on an other mdb it tell me that OFFOWC.dll is missing, and I can not find it anywhere
I tried tools, visual basic, references looks at though the .dll are not in this part
anything else possible ?
thank you for your patience
That dll is for Access Web databases, which can no longer be designed in later versions of Access IIRC. If you must continue web based db, you're going to have to leave it on the pc with the older version that has that dll. I expect that if you're in a business environment, eventually you'll lose that Office version.
You didn't say what you saw in References. I imagine that one is flagged as missing or broken. Uncheck it and any other marked as missing in the newer Access version and see what happens. Any functionality that depends on OFFOWC will no longer work, AFAIK.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
yes. I unchecked it and my database doesn't make any more comment great. I don't need a web based mdb.
remain my panel .........it is really difficult
I don't know what causes it
thank you for your help
What about the suggestions in posts 14 and 21?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I tried 21
as soon as my mdb is on my actual comptuter let's call it A, the navigation panel is dead
on my computer B it worked
I tried uncheck search bar options nothing happens, just the field is not visible any more
as for nr 14..............
I am afraid I don't know how to make an empty copy of my database in Access 2016 yet
I will try to make it in Access 2010 and copy it here.
By the way I did try to send my mdb from my window7 old computer ( access 2010 )
through icloud to computer A , all the visual basic has gone wrong, could not open this, could not open that
when I copied the mdb 2010 to an external hard disk and copied to my A computer , the visual basic is ok
and the mdb works except the navigation panel. Weird
Just make a copy of the problem db in the version it was created in, remove most of the tables/forms/reports but leave something to aid in examining the behavior, zip that and post it here. If need be, perhaps remove any private data from the remaining table(s). There seems to be several versions in use by responders from here, so perhaps someone will be able to replicate your issue in the same version you have.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I tried 21
as soon as my mdb is on my actual comptuter let's call it A, the navigation panel is dead
on my computer B it worked
I tried uncheck search bar options nothing happens, just the field is not visible any more
as for nr 14..............
I am afraid I don't know how to make an empty copy of my database in Access 2016 yet
I will try to make it in Access 2010 and copy it here.
By the way I did try to send my mdb from my window7 old computer ( access 2010 )
through icloud to computer A , all the visual basic has gone wrong, could not open this, could not open that
when I copied the mdb 2010 to an external hard disk and copied to my A computer , the visual basic is ok
and the mdb works except the navigation panel. Weird
I think I made it but I can not attach it because is is too big (more than 500.....
Well I would say, if it works fine on another computer, then the DB is not at fault?
Try perhaps System File Checker in Command window in Administrator mode.
Type in sfc /scannow into the command window opened in Admin mode.
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