INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Drop down not populated all names

Drop down not populated all names

(OP)
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,

OCM

RE: Drop down not populated all names

  1. Most likely, the problem lies in the query you're pulling into the combo box or else a filter you have on the control.
  2. This is definitely a separate issue. Would be best to post in its own question. You'll need to look at action behind the button: is it a Macro or VBA code? Either way, there should be some conditional statements, something like (VBA):

CODE --> VBA

Private Sub Login_Click()
     
     If UserName = vbNullString Then
          MsgBox "Missing UserName"
     ElseIf Password = vbNullString then
          MsgBox "Missing Password"
     Else
          'Check the username and password against accepted login credentials
          'Go to next form IF credentials are correct
     End If

End Sub 

In the above setup, if either the UserName or Password field is left blank, then you never get to the step of checking the code, and you never get to whatever the next step in the process is.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

RE: Drop down not populated all names

(OP)
kjv1611

Thanks for the reply post.

As per your suggestion (regard to login form issue) I’ll initiate a separate question.

As for dropdown. I learned that Access has a limit to the number of entries (65k records).
We have over 72k records. What would be a better way to redesign this whereby a user enters part of the Provider ID, or to paste the Provider ID etc. the form then populates Provider name and other needed info.?

By the way, I checked 'Notify Me' to get e-mail message whenever this forum is updated. For some reasons, I didn't get e-mail.

TIA

Regards,

OCM

RE: Drop down not populated all names

65k records - that's a lot of records for the user to see. "over 72k records" is an insane number for a user to sift / scroll thru.

Can you group those Providers and Clients in some logical way?

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Drop down not populated all names

(OP)
Andy,

Thanks for the reply post. That is my goal somehow to enhance the design and I found the following resource that was provided by Allen Browne Link

Couple of questions:

1. I was going to download & try sample mentioned in the resource postcodes for Australia. But for some reasons, I didn’t see the link for download.

2. Allan’s method seems to be the solution for my issue. But, I wasn’t sure what code I need to modify to get this method work in my environment.

TIA,

OCM

RE: Drop down not populated all names

Let's say you have a long list of names and you want a user to first select a letter from one combo box, and based on this selection, you want to display all names that start with the selected letter from first combo in the second combo box.

CODE

With cboLetter
    .AddItem "A"
    .AddItem "B"
    ....
    .AddItem "Z"
End With

Private Sub cboLetter_Click()

strSQL = "Select FullName from MyTable Where FullName Like '" & cboLetter.Text & "*'"
'Based on this SQL populate a combo with names

End Sub 

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Drop down not populated all names

(OP)
Thanks Andy,

How do I go about finding/modifying, or commenting the existing code so I can apply implement the method you suggested? Below is some info looking at the properties:

Name: cboCaseType
Control Source: blank
Row Source: "P";"Providers";"C";"Clients"
Row Source Type: Value List

Please let me know if you need additional info.

TIA

OCM

RE: Drop down not populated all names

I do all of my coding using recordsets (no bound controls). More about recordsets in Access here
After you read this, maybe my example above will make more sense.

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Drop down not populated all names

(OP)
Andy,

Thanks for the link. I’ll try to adopt your example along w/ the link you provided.

Regards,

OCM

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close