John W. Colby
jwcolby at gmail.com
Sat Feb 28 12:59:41 CST 2015
No. Me.simperasma_1.RowSourceType = "Table/Query" The LITERAL string "Table/Query" John W. Colby On 2/28/2015 1:55 PM, Kostas Konstantinidis wrote: > 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 >> >