Results 1 to 4 of 4
  1. #1
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79

    Custom ActiveX Controls For a Shared Front-End

    Hello,

    I wish to create a custom ActiveX control or find one that correctly suits my needs and have some concerns before I get started.



    Firstly, I have no idea how to make one or the actual effort that is needed to get one to work. Does anyone has experience in creating custom controls?
    Also, if my front-end is distributed to many users, all with different versions of MS Office and even MS Windows, will I need to install my custom control onto each of their machines.

    Ultimately I want to create a control that is like the ListBox, but also like the TextBox. I wish to form a bulleted list based on the user that is accessing the form at that point. From there I want to enable the user to select a "row" within the List/Text Box and obtain the data associated with that row. I've tried implementing a plain ListBox, but I was not able to set margins for the columns nor get the text to wrap.

    Thank you in advance

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    Does anyone has experience in creating custom controls?
    from the description of what you are trying to do, suggest use a subform rather than a listbox.

    Also be aware that activeX controls that work in 32bit access need to be rewritten to work in 64bit access - many of the 'off the shelf' active x controls will only work in 64bit

  3. #3
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79
    Datasheet view seems to be the closest I could get a subform to resemble what Im after. These controls seem clunky and are often unsightly. It's surprising that there isn't some way to customize the existing controls..

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    use a continuous form and customize to your hearts content. Datasheet is just a basic view with basic formatting capabilities.

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

Similar Threads

  1. Replies: 2
    Last Post: 12-23-2015, 09:32 PM
  2. Custom Controls
    By Perceptus in forum Programming
    Replies: 2
    Last Post: 06-25-2013, 12:24 PM
  3. Front end on shared drive, modified date?!
    By redbull in forum Access
    Replies: 3
    Last Post: 09-13-2012, 10:32 AM
  4. Custom Front End
    By rogueakula in forum Access
    Replies: 1
    Last Post: 05-04-2012, 07:40 AM
  5. "On Current" event and ActiveX controls
    By beru777 in forum Programming
    Replies: 7
    Last Post: 12-20-2011, 10:32 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