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

Rocky Smolin rockysmolin at bchacc.com
Sat Feb 28 13:55:45 CST 2015


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




More information about the AccessD mailing list