Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I recognise that code....!



    You have a missing reference.
    That is part of the standard VBA DAO library reference: Microsoft Office 16.0 Access database engine object library
    Add the reference & you should be good to go

    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	42.8 KB 
ID:	50153
    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

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by isladogs View Post
    I recognise that code....!

    You have a missing reference.
    That is part of the standard VBA DAO library reference: Microsoft Office 16.0 Access database engine object library
    Add the reference & you should be good to go

    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	42.8 KB 
ID:	50153
    Very underhand.
    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

  3. #18
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Thanks. I reinstalled Office. I wouldn't have known that, even though I know of that.

  4. #19
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You didn't need to reinstall Office to fix this.
    How are you getting on with my automatic form resizing code?
    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

  5. #20
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    I have 3 computers with different screen sizes at home on a little network. I have never tested it, but what I really want is for my app to fit well balanced on any screen size. If ever I get to a point that the app is web based, then again it should fit well on a tablet, laptop or cell phone. Can you tell me if your form resizing will do that? Is my thinking close if I think that any medium (cell phone, tablet, laptop) should have as part of the back end, the settings in table tblMonitors that will make the difference?

    Somehow whenever I opened Access not even with my app, Access froze. I did not reinstall for any issue on my app. My two clever sons or I do not know what caused it, so I reinstalled Office.

  6. #21
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    My AFR code is designed to handle different screen sizes and resolutions. It will work on any Windows device running Access including tablets like the one I'm using now.

    It will not work on a phone or in a browser as Access is a desktop app. If you want a web app, Access is the wrong program.
    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 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Run Time Error 3061
    By DMT Dave in forum Access
    Replies: 6
    Last Post: 10-22-2019, 08:45 AM
  2. Run Time error 3061
    By sdel_nevo in forum Programming
    Replies: 6
    Last Post: 06-08-2015, 10:09 AM
  3. Run-time error '3061'
    By TheLazyEngineer in forum Programming
    Replies: 1
    Last Post: 03-04-2015, 11:17 AM
  4. Run-Time Error 3061
    By GraeagleBill in forum Programming
    Replies: 2
    Last Post: 09-23-2013, 06:46 AM
  5. Run-time error 3061
    By boywonder in forum Programming
    Replies: 1
    Last Post: 07-20-2011, 06:14 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