[AccessD] Combos with Tens of Thousands of Records

[Kostas Konstantinidis]

Thanks, I’ll try it while
 back home the next hours

> 23 Ιουν 2021, 13:04, ο χρήστης «Stuart McLachlan <stuart at lexacorp.com.pg>» έγραψε:
> 
> 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