Rocky Smolin
rockysmolin at bchacc.com
Sat Feb 28 16:15:28 CST 2015
No opening quotes on the WHERE. Try: "WHERE(([0simperasmata].tip) =""z"""") And quotes around the z. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, February 28, 2015 12:11 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... it breaks on line WHERE.... with a compile error Sub or Function not defined -----Αρχικό μήνυμα----- From: Rocky Smolin Sent: Saturday, February 28, 2015 9:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] limit drop down from another field... What line doesn't compile and what is the compile error? r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, February 28, 2015 11:53 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... No it doesn't and while I stop the code running after the error I see the total of the data, unfiltered of coarse -----Αρχικό μήνυμα----- From: Rocky Smolin Sent: Saturday, February 28, 2015 9:40 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] limit drop down from another field... So does it compile now? And if so, what do you see when you drop down the list in that combo box? r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, February 28, 2015 11:34 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... Rocky it's exactly as you describe -----Αρχικό μήνυμα----- From: Rocky Smolin Sent: Saturday, February 28, 2015 9:30 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] limit drop down from another field... No - just remove lie line of code Me.simperasma_1.RowSourceType = "simperasmata" and in the design view of the form select the combo box and in the combo box property sheet select Table/Query from the RowSourceType dropdown list. r -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, February 28, 2015 10:56 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... Just let you know I just renamed the table from 0simperasmata to simperasmata deleting the first "0" Rocky you mean Me.simperasma_1.RowSourceType = "simperasmata" -----Αρχικό μήνυμα----- From: Rocky Smolin Sent: Saturday, February 28, 2015 8:45 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] limit drop down from another field... Kostas: Did you try to replacing the RowSourceType with 'Table/Query'? R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, February 28, 2015 10:41 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... John I tried that too Suzan the parenthesis closes well because in other case the system would answer as expected end of statement or something any other way to do what I need? after a very hard deep dive in a 2nd War wreck and after five hours tries on that demon piece of code too I can think nothing else :-))) /kostas -----Αρχικό μήνυμα----- From: John W. Colby Sent: Saturday, February 28, 2015 8:08 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... I think one problem is that you do not put the NAME of the table in that property but the STRING value 'Table/Query' John W. Colby On 2/28/2015 1:00 PM, Kostas Konstantinidis wrote: > Hi Dan, > the original table's name begins with 0 (zero) I renamed it but it > also refuses to execute > > thank's > > /kostas > > -----Αρχικό μήνυμα----- From: Dan Waters > Sent: Saturday, February 28, 2015 7:32 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] limit drop down from another field... > > Hi Kostas, > > > Take a look at this in your text: > > '0simperasmata' is typed in your example with a leading zero. > > 'Osimperasmata' is typed with a leading 'O'. > > At least variables cannot be named with a leading number. I checked > and it is possible to name a table in both Access and SQL Server with > a leading number - I was surprised! > > Perhaps changing the leading zero to a leading O might help? > > Good Luck! > Dan > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas > Konstantinidis > Sent: Saturday, February 28, 2015 9:27 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] limit drop down from another field... > > Hi, > There are three fields into the same form > > [result_zscore_ostiki_piknotita]--> decimal > [result_tscore_ostiki_piknotita]--> decimal [simperasma_1] --> combo > box with record source SELECT [0simperasmata].ID_symperasmata, > [0simperasmata].simperasma, [0simperasmata].tip FROM 0simperasmata > ORDER BY [0simperasmata].simperasma; > > into [0simperasmata].tip are saved three different values "z", "t" and > "zt" > > what I need is to limit the drop down list the based on > [result_zscore_ostiki_piknotita] or [result_tscore_ostiki_piknotita] > values > > I tried: > > Private Sub result_zscore_ostiki_piknotita_AfterUpdate() > If Not IsNull(result_zscore_ostiki_piknotita) Then > Me.simperasma_1.RowSourceType = "0simperasmata" > Me.simperasma_1.RowSource = "SELECT ID_symperasmata, simperasma, > tip FROM 0simperasmata " & _ > WHERE(([0simperasmata].tip) = "z") > Else > End If > End Sub > > but it doen't work > > any help please? > thank's > /kostas > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com