[AccessD] Combos with Tens of Thousands of Records

Kostas Konstantinidis kost36 at gmail.com
Wed Jun 23 04:18:12 CDT 2021


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



More information about the AccessD mailing list