Using Form to Select Records in Query to Display in Report

Using Form to Select Records in Query to Display in Report

Post by SkhL » Tue, 21 Dec 2004 04:29:01


I have a table named TimesJB5, which contains a field named Unit#, which is a
text-type field.

I would like to present the user with a Form which lists 10 different check
boxes each with a unit#. Depending on which boxes the user checks, I would
pass this information to a query, which would select the corresponding unit#
records and then display the records in a report.

I plan to use a CommandButton on the form that would run the proper macro to
open the query and then the report.

What would the proper syntax be to have in the query to select the proper
unit# records from the table?
 
 
 

1. Problems with custom forms not displaying, (using outlook form ins

2. Some snap-ins not displaying in "Restricted/Permitted snap-ins"

I need the ability to restrict a Help desk operator from gaining access to
some MMC snap-ins, but allow access to other "allowed" snap-ins.

In the group policy User Configuration\Administrative Components\Microsoft
Management Console I've set the Policy "Restrict users to the explicitly
permitted list of snap-ins" to "enabled". Now the operator can't access the
SMS snap-in.

We are running the current version of SMS and are in a 2003 AD domain (not
mixed mode). I've checked for an SMS entry in the "Restricted/Permitted
snap-ins" and the "Extension snap-ins" - I don't see it. We have considered
the alternative of enabling all snap-ins and only explicitly denying the
snap-ins that the help desk shouldn't have access to. However, we were
unable to find some of the snap-ins that we need to deny access to (DNS is
one of them).

Is there a "registration" step we missed for the "missing" snap-ins, in
order for the group policy to be able to "see" them? Or are we in a "can't
get there from here" problem?

Unfortunately we are still running Windows 2000 on some of our workstations,
otherwise I would have the help desk using the "remote assistance" program
and continue with the GPO that we have in place.

Any thoughts on how to tackle this problem?

3. Can I get native code add-ins when I development the add-ins using C#?

4. Visio Tools? Add-Ins, Plug-Ins, etc.

5. Excel add-ins does not show up in Excel>Tools>Add-ins list.

6. Com add-ins versus normal add-ins?

7. WIN XP SP2 active X controls, plug ins, add ins, downloading s

8. Ins PA w/Life Ins sw such as Cyberlife, Vantage, Life70, etc. Contract to Hire Perm

9. Better Graph Add-ins/Plug-ins

10. Add-ins do not show up in the Add-Ins Ribbon

11. Disabling Add-Ins, plug ins

12. Can only remove add-ins but cannot add add-ins in Outlook 2003 anymore

13. XP SP2 active x control,add-ins,plug-ins nightmare

14. Schedule an email without plug-ins or add-ins?

15. Remap Copy (CTRL+INS) Paste (SHIFT+INS) to other keysyms