Re: Table/Form/Query Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Erin

Depends on what you define as possible ...

If you require that the approach you've been using is the only way that it
can be done, it may be possible but require more work that you care to
spend...

If, by "possible", you mean a way to keep track of who has received a
warning already, and who is eligible to receive one, then that's much more
likely/possible.

Again, it all starts with the data... and I don't have a very clear picture
what your data structure looks like. Please post back a description of your
table structure. Here's an example (simplified) of a data structure for an
enrollment database:

tblStudent
StudentID
FName
LName
DOB

tblClass
ClassID
ClassTitle
ClassDescription

trelEnrollment
EnrollmentID
StudentID
ClassID
EnrollmentDate

Please provide your table(s) in a similar format.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Erin" <Erin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17C532DA-C395-4B16-AFB7-82AE3A1B1C71@xxxxxxxxxxxxxxxx
Yes, I am using the query to determine which employees need a warning and
for
what.

How would you structure the form and table using this "two check box"
method? I am really struggling because the user needs to know who already
got
a warning. However, the info will be updated via both the query and now
these
check boxes, so I am stuck.

Maybe it is not possible???

"Jeff Boyce" wrote:

Erin

It all starts with the data...

Are you keeping track of the warnings already delivered? It sounds like
you're using a query to find situations that could lead to a warning, but
how do you "know" that the warning was actually delivered?

If you use a form that lists 'warnings delivered' and lists 'impending
warnings', you might be able to get away with using paired listboxes to
"move" an impending warning over into "delivered" status.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Erin" <Erin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EAA76DE5-9021-4ADF-9C6C-7784707AF189@xxxxxxxxxxxxxxxx
I have a query that uses employee records to determine if an employee
needs
to receive a warning or not.

I want the user to be able to see the results of the query, and check a
box
once the warning has been issued.

Finally, I would like for these checks that the user enters to somehow
filter back to the query, so that the next time the query is run they
would
see any new warnings that need to be issued PLUS warnings that have
already
been issued.

What is the proper flow in order to get that done? I am really
struggling
with whether or not I need a table feeding my form, and how to get the
information back to the query (I was initially thinking joining the
table
created for the form to the query) without making any duplicate records
or
circular references.

I hope that made sense... thanks for the help!!!!!





.

Relevant Pages

  • Re: Table/Form/Query Question
    ... I am using the query to determine which employees need a warning and for ... the info will be updated via both the query and now these ... "Jeff Boyce" wrote: ... If you use a form that lists 'warnings delivered' and lists 'impending ...
    (microsoft.public.access.queries)
  • Re: How do I suppress warnings when using an Access MDB as a runtime?
    ... The destination computer can have the macro security settings set to Low to ... avoid the three warning messages. ... > warnings you get when you run an update or delete query. ...
    (microsoft.public.access.security)
  • Re: Only if 1 of 3 checked
    ... While I still don't have a very clear picture of your data structure, ... then the report is created via that query. ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.reports)
  • Re: Reminder Query
    ... Describe your data structure and folks here may be able to offer more ... specific suggestions about "how" to construct a query. ... Microsoft Office/Access MVP ... Jeff Boyce wrote: ...
    (microsoft.public.access.queries)
  • Re: Import data
    ... To turn off the warning message: how do you do the import? ... > I am transfering Txt file into an Access table. ... >>If the filename on the disk is always the same and the ... >>import), then use a DFirst on it for the Delete query, ...
    (microsoft.public.access.macros)