Page 2 of 2 FirstFirst 12
Results 16 to 25 of 25
  1. #16
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,708

    I too had never heard of application parts, or if I had they didn't turn on the the Idea lightbulb.
    Funnily enough we have just been creating/cleaning up a library of common functions and basic menu forms between us at work.

    It's hard work rationalising things when you have 4 similar, but different, versions of FileExists() type functions gathering dust in the corner of different apps.

    Add a mint to the rogues gallery...
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  2. #17
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,693
    Actually I did already know about application parts and had made use of the feature as well as creating template files.

    Initial discussion with a few developers had indicated this was a relatively unknown feature
    It was for that reason that I had already planned to create a video on the topic in the near future.

    This thread, inadvertently hijacked by the OP, had confirmed it would be useful
    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

  3. #18
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,574
    Colin,

    I now you are very busy, but was wondering if a video on Application Parts is still in the works.
    I'm sure it would be useful. You're getting a good following because of your good work!!
    jack

  4. #19
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,693
    Hi @orange
    I had completely forgotten about this thread and my offer to create a video on application parts.
    I've now bookmarked it and added it to my list of things to do.

    It won't be for some time though as I have a long backlog of things to do including preparing for my own Access Europe session on 7 Sept
    Access Europe Colin Riddington (Optimising Queries and the JET ShowPlan) Europe AccessUserGroups.org
    Hopefully I'll see you & some other forum members at that session
    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
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,574
    Thanks Colin.
    It's on the to do list

    Good luck with your UserGroup presentation. I hope to be watching/attending virtually.

  6. #21
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,693
    Just rediscovered this thread by accident.
    I did write a web article on this topic a few months ago which may be useful for reference: Application Parts and Templates (isladogs.co.uk)
    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. #22
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Posts
    1,389
    Better late than never Col.
    I've been adding to my templates since this thread was started. They are incredibly useful.
    Great idea to have one that sets all your usual form options, etc. That's on todays to-do list.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  8. #23
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,693
    Its a pity the supplied application parts are so naff as it puts people off using what is a very useful (but massively underused) feature
    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

  9. #24
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,574
    I have not yet created any templates. If some templates are considered useful, and are shareable, could we add such to code or database samples in the forum(s)?
    Moke123 seems to have quite an evolving collection that may be suited to others.
    Davegri's template(s) in post #1 is now a "tool" I use.

  10. #25
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Posts
    1,389
    I'm sure we could. I move them between work and home on a flash drive. They are stored in C:\Users\<Your user name >\AppData\Roaming\Microsoft\Templates\Access. Its just a matter of dropping them in the folder and re-starting access.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Cant open VB editor window for a form
    By JmMrhw in forum Programming
    Replies: 5
    Last Post: 10-18-2017, 12:34 PM
  2. Replies: 4
    Last Post: 12-05-2014, 11:15 AM
  3. Form size affected by tabs in editor!?
    By BayerMeister in forum Forms
    Replies: 6
    Last Post: 04-15-2014, 10:10 AM
  4. Added Form Not Visible in VBA Editor
    By dccjr in forum Forms
    Replies: 3
    Last Post: 01-14-2013, 07:05 PM
  5. Replies: 8
    Last Post: 08-02-2012, 08:48 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