[AccessD] Combos with Tens of Thousands of Records

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jun 23 01:48:08 CDT 2021


In that case, can you post the actual function as you have it entered.


On 23 Jun 2021 at 9:38, Kostas Konstantinidis wrote:

> Hi David
> I have already tried it... doesn't work
> Thank's
> 
> -----Original Message-----
> From: AccessD <accessd-bounces+kost36=gmail.com at databaseadvisors.com>
> On Behalf Of David Emerson Sent: Wednesday, June 23, 2021 9:29 AM To:
> 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Combos with Tens
> of Thousands of Records
> 
> Without looking at the code in detail, try replacing Me. With Me!
> 
> Regards
> 
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
> 
> 
> 
> -----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
> 




More information about the AccessD mailing list