Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

The nation that controls magnetism controls the universe. -- Chester Gould/Dick Tracy


devel / comp.databases.ms-access / Re: Combo Box

SubjectAuthor
* Combo BoxMike P
`* Re: Combo BoxRon Weiner
 `- Re: Combo BoxMike P

1
Combo Box

<fb93e671-599c-41b0-b4e1-f9926cb05e90n@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=556&group=comp.databases.ms-access#556

 copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a05:6214:2482:: with SMTP id gi2mr4975021qvb.126.1644058537092;
Sat, 05 Feb 2022 02:55:37 -0800 (PST)
X-Received: by 2002:a05:6870:9201:: with SMTP id e1mr760263oaf.65.1644058536902;
Sat, 05 Feb 2022 02:55:36 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Sat, 5 Feb 2022 02:55:36 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2a00:23c5:f183:fd01:c51b:e011:12ae:4be6;
posting-account=kPm-FwoAAAD0MX_g8dnNmexZ6gEyJcrj
NNTP-Posting-Host: 2a00:23c5:f183:fd01:c51b:e011:12ae:4be6
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <fb93e671-599c-41b0-b4e1-f9926cb05e90n@googlegroups.com>
Subject: Combo Box
From: mikewpa...@tiscali.co.uk (Mike P)
Injection-Date: Sat, 05 Feb 2022 10:55:37 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 6
 by: Mike P - Sat, 5 Feb 2022 10:55 UTC

ComboBox Row Source
I have a combo box with a row source based on a query that has a WHERE clause, "WHERE ACTIVE = True". The bound column is the ID field for the underlying table and is not visible in the drop down list for the combo box.
This works except that, over time, some records are no longer in the combo box row source because the ACTIVE field has been set to False and the combo box is blank.
How can I make the combo box work for records that have ACTIVE = False without taking out the WHERE clause from the row source query?

Mike P.
5/2/22

Re: Combo Box

<stn434$r6b$1@dont-email.me>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=557&group=comp.databases.ms-access#557

 copy link   Newsgroups: comp.databases.ms-access
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rw...@domain.com (Ron Weiner)
Newsgroups: comp.databases.ms-access
Subject: Re: Combo Box
Date: Sat, 05 Feb 2022 19:17:38 -0500
Organization: WorksRite
Lines: 19
Message-ID: <stn434$r6b$1@dont-email.me>
References: <fb93e671-599c-41b0-b4e1-f9926cb05e90n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 6 Feb 2022 00:17:40 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="4e9c63d016add15471aab6cf2ed98e95";
logging-data="27851"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Y+5v7kYeXtoysJ3xP83si"
Cancel-Lock: sha1:KabmW42dpRrP/H5lJNF2v0Qa338=
X-Antivirus-Status: Clean
X-Newsreader: MesNews/1.08.06.00-gb
X-Antivirus: AVG (VPS 220205-6, 2/5/2022), Outbound message
X-ICQ: 1701145376
 by: Ron Weiner - Sun, 6 Feb 2022 00:17 UTC

Mike P was thinking very hard :
> ComboBox Row Source
> I have a combo box with a row source based on a query that has a WHERE
> clause, "WHERE ACTIVE = True". The bound column is the ID field for the
> underlying table and is not visible in the drop down list for the combo box.
> This works except that, over time, some records are no longer in the combo
> box row source because the ACTIVE field has been set to False and the combo
> box is blank. How can I make the combo box work for records that have ACTIVE
> = False without taking out the WHERE clause from the row source query?
>
> Mike P.
> 5/2/22

If you want to allow the user to decide which subset of records (Active
or Inactive) to display, add a CheckBox to the form. Then in the Click
event of the CheckBox Update the sql in the Combo's Row Source to
appropriate sql based on if the checkBox was checked or not.

Rdub

Re: Combo Box

<18be8c4b-52bc-4ccd-9f6d-19b016bb5dean@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=558&group=comp.databases.ms-access#558

 copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a05:6214:400f:: with SMTP id kd15mr7548556qvb.69.1644146800699;
Sun, 06 Feb 2022 03:26:40 -0800 (PST)
X-Received: by 2002:a05:6830:1be7:: with SMTP id k7mr2570700otb.209.1644146800420;
Sun, 06 Feb 2022 03:26:40 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!feeder.erje.net!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Sun, 6 Feb 2022 03:26:40 -0800 (PST)
In-Reply-To: <stn434$r6b$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=2a00:23c5:f183:fd01:68dc:a29f:45c4:6799;
posting-account=kPm-FwoAAAD0MX_g8dnNmexZ6gEyJcrj
NNTP-Posting-Host: 2a00:23c5:f183:fd01:68dc:a29f:45c4:6799
References: <fb93e671-599c-41b0-b4e1-f9926cb05e90n@googlegroups.com> <stn434$r6b$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <18be8c4b-52bc-4ccd-9f6d-19b016bb5dean@googlegroups.com>
Subject: Re: Combo Box
From: mikewpa...@tiscali.co.uk (Mike P)
Injection-Date: Sun, 06 Feb 2022 11:26:40 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 0
 by: Mike P - Sun, 6 Feb 2022 11:26 UTC

OK. Thank you Ron.

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor