+ Reply to Thread
Results 1 to 2 of 2

How to open an Access form with a button in Excel?

  1. #1
    Registered User
    Join Date
    01-10-2019
    Location
    London, England
    MS-Off Ver
    365
    Posts
    1

    How to open an Access form with a button in Excel?

    Hi everyone,

    I'm trying to open a MS Access form (NewStudent) using a "button" (image with a macro) in Excel. I've been playing around with some code but haven't gotten it to work.


    Please Login or Register  to view this content.

    I get the error: Microsoft Access can't open the database because it is missing, opened exclusively by another user, or is not an ADP file.

    However, the database is not missing or opened by another user and it is an ADP file.

    Any ideas?

    Thanks!!

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: How to open an Access form with a button in Excel?

    should work if you add the extension of the filename.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create a form with a button to save the form and open Outlook
    By OmegaSea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2015, 05:12 PM
  2. [SOLVED] Open Access Userform from Excel Macro Button
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-09-2015, 09:45 AM
  3. Excel Command button to open a Microsoft Access query
    By Bineyo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2012, 04:31 PM
  4. Cannot add a Macro button to open VBA form on excel
    By leosardinha in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-17-2010, 01:42 PM
  5. [SOLVED] Not able to open MS Access Form
    By jesika in forum Access Tables & Databases
    Replies: 0
    Last Post: 05-30-2009, 05:01 AM
  6. Access control on Button in Excel form
    By psatkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2006, 05:01 AM
  7. [SOLVED] Open Access form from excel hyperlink
    By JCanyoneer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2006, 02:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1