Results 1 to 7 of 7
  1. #1
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36

    Look like software Application


    What are steps to take my MS Access Application like a Custom Software Application


  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,400
    A very broad question - depends how far you want to go. Some of the things to consider

    don't use newly available functionality not available to users with earlier versions of access
    hide the access window
    split your db
    ensure you have full error handling
    make your front end .accde
    protect the backend with password

    make sure it will run and has the functionality available if user only has runtime access. Runtime does not have certain functionality such as right click menus - so you need to write your own
    you may need 2 versions for 32 and 64 bit access

    late bind everything you can (such as references to excel/word/outlook etc)

    use a suitable installer package to distribute your app

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    This is a question and shouldn't be in the code repository. Mods may wish to move it to a better location

    I agree with everything Ajax has written.
    You should also consider security such as hiding the navigation pane and ribbon.
    It is also possible to hide the entire Access application interface so your app is 'floating' on the desktop.

    However it is worth stressing that an Access database can never be a standalone application.
    Users will always need either a full version of Access or a runtime version in order to run your app.

    EDIT: The post has now been moved
    Last edited by isladogs; 08-02-2020 at 10:12 AM.
    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

  4. #4
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36
    How can i hide the ribbon

  5. #5
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36
    Please forward the tips to hide the ribbon,
    when cancel button in parameter query dialog box pressed, there is blank screen appeared, how can i solve this

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Have a look at my example database which includes code to hide the ribbon and much more http://www.mendipdatasystems.co.uk/c...ace/4594365418.

    I rarely use parameter queries, partly for that reason. Your end users should NEVER open tables or queries directly.
    Instead get users to select from the available choices using one or more combo boxes or listboxes.
    The selected choices act as your parameter(s) and are used to display filtered results on the form or a subform
    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

  7. #7
    rohinikrishna1987 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    36
    Thank u very much

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-27-2016, 10:59 AM
  2. Replies: 1
    Last Post: 08-27-2015, 06:05 AM
  3. Replies: 4
    Last Post: 01-05-2014, 02:09 PM
  4. Replies: 0
    Last Post: 08-26-2008, 09:22 AM
  5. Access application to Web based application
    By admaldo in forum Access
    Replies: 0
    Last Post: 06-12-2008, 06:22 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