Solutions for reaching data limits?

[drr1970]

Hello
I have a data entry form that pulls information from a Table called "Clients" so that we can enter the client data in another table. This is done through a lookup in a form. We just noticed that we can't pull in clients with a last name beginning with a "Y". in fact the last client that shows up in the lookup field, is client number 65535, when the names are sorted alphabetically. In looking through various data limits that Access has, 65535 seems to be an important limit on characters, but i am not understanding how it is limiting records. If we have reached a limit, is there any override for this?


Thanks in advance.

[June7]

Access has a 2GB file size limit.

You are hitting a limit for combobox and listbox lists. Review http://allenbrowne.com/ser-32.html

I hope you are not duplicating client data in two tables.

[drr1970]

Thank you.
My database is 0.16 GB in size right now, and no! I'm definitely not duplicating data. This database has actually been working really well for about 7 years.
In the link you posted there is a suggestion as follows, which is:
"

1. Create a function that assigns the RowSource after a minimum number of characters has been typed. Only entries matching these initial characters are loaded, so the combo's RowSource never contains more than a few hundred records."

I do not know how to code, is "create a function" is the same as "create a macro"? Am i correct in assuming that this will require me to find someone who can write code for that, or is there a built-in Access function (like "assignRowSource).

Thanks again.

[June7]

The article means create VBA procedures and example included. Modify as required for your situation. You will have to learn VBA or find someone. https://support.office.com/en-us/art...0-DAB7C75CBE0C

Macros in Access are very different.