News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Incomplete drop down list

    This topic contains 0 replies, has 0 voices, and was last updated by  WSOCM 2 years, 6 months ago.

    • Author
      Posts
    • #508235 Reply

      WSOCM
      AskWoody Lounger

      Greetings,

      We’re currently running access 2016 split database (with individual front-end and shared back-end)

      Couple of questions:

      1. We have a form with a drop-down whereby users select either P: Providers or C: Clients to populate the name of the provider or the client. However, the list that is populated is not complete (e.g. provider name that starts with the letter (P-Z) did not show in the list. I checked the tables to verify the provider names are up to date.

      a. I checked properties > data tab > Record Source is blank
      B. In design mode I also checked properties of the object’s name it shows cboType

      2. Though we have a login form where users enter their credentials to log in, we noticed just clicking login will let users access to the application (without entering username & password)

      TIA

      Regards,

    • #1591645 Reply

      WBell
      AskWoody_MVP

      1 – It appears the RowSource for your combo box is the issue – it is likely being updated by VBA code that runs on the AfterUpdate event on the dropdown combo box. May be a bit of a challenge to debug.

      2 – Has the application been around a long time and just recently upgraded to 2016? If it has, and you were depending on Access User Security, that feature is no longer supported if you are using the .accdb format for the front-end. Even if the front-end is in .mdb format, the administration of user security is more challenging and more tempremental.

    • #1591705 Reply

      WSMarkLiquorman
      AskWoody Lounger

      Just out of curiousity, how many providers do you have? If there are a lot of rows, Access will delay fully populating a listbox. Just a way of managing resources.

    • #1591797 Reply

      WSHiTechCoach
      AskWoody Lounger

      It is best for all online forums, including this one, to to limit a post to one topic and question. This help others who use the forum as a knowledge base to search for answers. It also make the thread much easier to follow.

      Greetings,

      We’re currently running access 2016 split database (with individual front-end and shared back-end)

      Couple of questions:

      1. We have a form with a drop-down whereby users select either P: Providers or C: Clients to populate the name of the provider or the client. However, the list that is populated is not complete (e.g. provider name that starts with the letter (P-Z) did not show in the list. I checked the tables to verify the provider names are up to date.

      a. I checked properties > data tab > Record Source is blank
      B. In design mode I also checked properties of the object’s name it shows cboType

      First, this is a limit of 64K rows in a combo box’s row source.

      Have you check to see haw many rows are getting loaded?

      Also see Combos with Tens of Thousands of Records here http://allenbrowne.com/ser-32.html

      FWIW: I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode.

      2. Though we have a login form where users enter their credentials to log in, we noticed just clicking login will let users access to the application (without entering username & password)

      Do you think this is related to the combo box issue?

    • #1593521 Reply

      WSOCM
      AskWoody Lounger

      Sorry for the late reply on this. For some reasons, I still do not get a notification e-mail when someone reply to the post. I thought I set up notification already.

      We actually have over 72k providers. Obviously, this is the issue as the limit is 65K. I’m trying to adopt the workaround by Allen browne http://allenbrowne.com/ser-32.html

      HiTechCoach, I’d like to learn how the following is implemented…

      I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode.

      TIA,

      • #1593552 Reply

        WSHiTechCoach
        AskWoody Lounger

        Sorry for the late reply on this. For some reasons, I still do not get a notification e-mail when someone reply to the post. I thought I set up notification already.

        We actually have over 72k providers. Obviously, this is the issue as the limit is 65K. I’m trying to adopt the workaround by Allen browne http://allenbrowne.com/ser-32.html

        HiTechCoach, I’d like to learn how the following is implemented… “I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode. ”

        TIA,

        Sure.

        I use the same technique to show a pop-up calendar and calculator that are both Access forms with only native controls.

        FWIW: I first started doing this many years ago with Access 2.0 (Window 3.1). It is the exact same code with only minor changes to update VBA constant names.

        To learn more check out this example I have:

        Pop ups – Calendar, Calculator, Zoom box

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Incomplete drop down list

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.