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

    Look like software Application

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



  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,382
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,193
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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

  5. #5
    rohinikrishna1987 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    23
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,193
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  7. #7
    rohinikrishna1987 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2020
    Posts
    23
    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 - Senior Forums