Page 3 of 3 FirstFirst 123
Results 31 to 45 of 45
  1. #31
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,266
    Quote Originally Posted by tartarine View Post
    I think I made it but I can not attach it because is is too big (more than 500.....
    I would not bother now, as you say it works fine on another computer?
    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

  2. #32
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,372
    zip that and post it here.
    did you follow all of the instructions?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #33
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    Quote Originally Posted by Welshgasman View Post
    I would not bother now, as you say it works fine on another computer?
    I need it to work on my A computer
    thank you

  4. #34
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    I hope it works
    thank you for your help

  5. #35
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    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!
    Attached Files Attached Files
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #36
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    Quote Originally Posted by isladogs View Post
    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!
    thank you
    I'll send an other zip from the other computer tomorrow

  7. #37
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    OK I'm confused.
    I thought you were uploading from the problem PC.
    Also, why did you remove the attachment from your post?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #38
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,266
    Quote Originally Posted by tartarine View Post
    I need it to work on my A computer
    thank you
    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

  9. #39
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    Quote Originally Posted by Welshgasman View 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?
    I am not sure
    everything else works well on my computer. it is a one year old Lenovo thinkpad
    but thank you

  10. #40
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    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

  11. #41
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    It still seems like a flawed Access installation. I would definitely recommend removing & reinstalling Office 2016

    I wondered if I could go through my main form to open a list of all objects of the database ?
    See if you can make use of my example app: View All Database Objects

    Click image for larger version. 

Name:	Capture.PNG 
Views:	16 
Size:	26.1 KB 
ID:	46117
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #42
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    Quote Originally Posted by isladogs View Post
    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 Objects

    Click image for larger version. 

Name:	Capture.PNG 
Views:	16 
Size:	26.1 KB 
ID:	46117
    thank you for your example, I downloaded it .I will try to understand how it works, but need a little bit more time

    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

  13. #43
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    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
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  14. #44
    tartarine is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2021
    Posts
    21
    Quote Originally Posted by isladogs View Post
    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

  15. #45
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    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.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Opening databases and saving object changes
    By Paul G Nottingham in forum Access
    Replies: 6
    Last Post: 04-14-2020, 06:12 AM
  2. Replies: 5
    Last Post: 10-09-2017, 03:09 PM
  3. Replies: 6
    Last Post: 10-11-2015, 03:47 PM
  4. Replies: 6
    Last Post: 04-11-2014, 05:51 AM
  5. Replies: 2
    Last Post: 03-23-2009, 05:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums