[AccessD] limit drop down from another field...

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
>>
>



More information about the AccessD mailing list