[AccessD] Combos with Tens of Thousands of Records

Kostas Konstantinidis kost36 at gmail.com
Wed Jun 23 11:56:50 CDT 2021


Stuart,
It works....
I checked line by line.. there is no differences between your version and
mine even at references too...
I copied your table and form into my database and it doesn't work!!!! Didn't
manage to find out what exactly happens.
So I threw out mine and kept yours as an example.
Many thank's


-----Original Message-----
From: AccessD <accessd-bounces+kost36=gmail.com at databaseadvisors.com> On
Behalf Of Stuart McLachlan
Sent: Wednesday, June 23, 2021 1:04 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Combos with Tens of Thousands of Records

Just sent it directly to you.


On 23 Jun 2021 at 12:18, Kostas Konstantinidis wrote:

> Yes I am Stuart
> Could you please send me the example of the database you created and 
> it works? Just to see the differences There may be something wrong 
> with the Greek version of Office 365 I work with
> 
> There are some differences e.g.
> Category: Nz([CategoryName],'Not Found') not works for me... it needs 
> ";" instead of "," Category: Nz([CategoryName]; 'Not Found') that 
> works Thank's
> 
> -----Original Message-----
> From: AccessD <accessd-bounces+kost36=gmail.com at databaseadvisors.com>
> On Behalf Of Stuart McLachlan Sent: Wednesday, June 23, 2021 11:49 AM
> To: Access Developers discussion and problem solving 
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Combos with Tens 
> of Thousands of Records
> 
> Are you sure that it is is  in the Form's module and not a standard 
> module? If it is in a standard module you will get that error (There 
> is no "Me". in a standard module!)
> 
> > > > -----Original Message-----
> > > > From: AccessD
> > > > <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On 
> > > > Behalf Of Kostas Konstantinidis Sent: Wednesday, 23 June 2021
> > > > 5:34 pm To: 'Access Developers discussion and problem solving'
> > > > <accessd at databaseadvisors.com> Subject: [AccessD] Combos with 
> > > > Tens of Thousands of Records
> > > > 
> > > > Hi all,
> > > > I use a combo box with more than 85.000 records (names) and I am 
> > > > trying Allen Browne's solution at 
> > > > http://allenbrowne.com/ser-32.html I followed his instructions 
> > > > step by step but the code stops on the function's point
> > > >             Me.Suburb.RowSource = "SELECT Suburb, State,
> > > >             Postcode FROM
> > > > Postcodes WHERE (False);"
> > > >             sSuburbStub = ""
> > > >  With the error "Invalid use of Me keybord"
> > > > Any idea?
> > > > Thank's all
> > > > /kostas
> > > > 
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > > 
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > > 
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > > 
> > > 
> > > 
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > > 
> > 
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list