[AccessD] Problem Making Query

Bob Walsh BWalsh at acumentra.org
Mon Dec 14 10:17:26 CST 2015


Does your Projects table have a status or completion date field?

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, December 11, 2015 10:07 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Problem Making Query

David:

That part is not a problem.  I've got the check boxes that are looked at in the open event of the called form and the row source of the combo box set accordingly.  Problem is I've got these two queries

qryMarketingActivitiesProjectNumberActive

And

qryMarketingActivitiesProjectNumberComplete

But they ain't workin'.  The query that shows all the projects regardless of active/complete status is working That was a no-brainer.

Thanks

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Friday, December 11, 2015 9:49 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Problem Making Query

You can a list box with 3 optional boxes in a frame.
Active, Complete and Both are the options (0, -1 & 2 are the values respectively).

If the client doesn't want a framed optional box, you can have a hidden text box with a value.
 In the after_update event of each check box, call a sub: (warning all air
code)

Private Sub CalcStatus
   Dim intStatus as integer

end sub

I have a deleted



On Fri, Dec 11, 2015 at 8:50 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Dear List:
>
> I need some help structuring 2 queries and can't seem to figure how to
> do it.
>
> I have two tables: Projects and Project Activities, where Project
> Activities has the FK of Project ID - PK in the project table.
>
> Activities table has a status field 'ACTIVE' or 'COMPLETE'
>
> The client wants to add checkboxes on the calling form - one labeled
> 'Active', one  labeled 'Complete', so that the combo box of Projects
> on the called form will show only Active projects, only Complete
> projects
or both.
>
> Showing both is easy - I already had that before he thought up this
> dandy enhancement
>
> A project is Active if ANY project activity is status = ACTIVE.
>
> A project is complete if ALL activities are status = COMPLETE.
>
> So I'm trying to create two queries - one which would list active
> projects and one which would list complete project per the definition
> above then I'll change the row source of the combo box based on which
> boxes are checked.
>
> But I've been fooling around with it long enough without success that
> I think I need some help.
>
> (help!)
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>
>
> --
> 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


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
IMPORTANT NOTE: The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately and delete this message from your computer. Acumentra Health.



More information about the AccessD mailing list