[AccessD] Combos with Tens of Thousands of Records

[Stuart McLachlan]

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
>