InActive functionality for Access 2007 Linked Records

[Preston]

Hi,
I was wondering if I could get a little help with Access 2007. I am trying
to create a database that will allow us to input service tickets with
technician's time and then generate timesheets for the week based on that
data. Everything is going pretty smooth except for one thing. I have a
service ticket form that has a technician subform. On any one ticket you can
have more than one time entry for technicians. This subform has a lookup
field that looks up technician names from a query. However, i have tried to
work active/inactive technician functionality into all of this. I want
inactive techs to not showup in the lookup field but i also don't want them
to disappear from the service ticket form because their time should still be
on the ticket even if they are made inactive. Quickbooks has this kind of
functionality and (surprise) we are using quickbooks. Is there any way to
mimic or reproduce this active/inactive status? I have tried changing the
relationship type but that didn't fix anything. I unchecked ref integ and
also cascade update. The technician entries would still be pulled from the
service tickets when they were made inactive (they disappear from the query
as they should also.)
sorry for the book and thank you for any help you can give.
Preston

 

[KARL DEWEY]

What I did was to include the Active field in the source for the combo and
sorted first on Active and then Names. Dispay play both name and Active
field when selecting technician.
SELECT [Auditor].[Auditor], [Auditor].[Name],[Auditor].[Active] FROM
[Auditor] ORDER BY Active, LastName

 

[Preston]

That's actually a really good idea. If say i have a tech table with a techID
an active field binary and a name field then i could bind combo box on
techID and choose to have 0,.25,.75 values (something of that nature) for the
display columns.
thank you for your help,
Preston

What I did was to include the Active field in the source for the combo and
sorted first on Active and then Names. Dispay play both name and Active
field when selecting technician.
SELECT [Auditor].[Auditor], [Auditor].[Name],[Auditor].[Active] FROM
[Auditor] ORDER BY Active, LastName
--
KARL DEWEY
Build a little - Test a little

Hi,
I was wondering if I could get a little help with Access 2007. I am trying
to create a database that will allow us to input service tickets with
technician's time and then generate timesheets for the week based on that
data. Everything is going pretty smooth except for one thing. I have a
service ticket form that has a technician subform. On any one ticket you can
have more than one time entry for technicians. This subform has a lookup
field that looks up technician names from a query. However, i have tried to
work active/inactive technician functionality into all of this. I want
inactive techs to not showup in the lookup field but i also don't want them
to disappear from the service ticket form because their time should still be
on the ticket even if they are made inactive. Quickbooks has this kind of
functionality and (surprise) we are using quickbooks. Is there any way to
mimic or reproduce this active/inactive status? I have tried changing the
relationship type but that didn't fix anything. I unchecked ref integ and
also cascade update. The technician entries would still be pulled from the
service tickets when they were made inactive (they disappear from the query
as they should also.)
sorry for the book and thank you for any help you can give.
Preston

 

[david]

If you think about, you can also add the existing tech on a record
to the combo recordsource (but this is advanced stuff). One way
is to use a union query that unions your restricted tech list with a
query that returns the techID from your currenct record, joined
back to the tech list to get the tech name .....

The easier way to do it is to use a seperate form for adding new records.
The new record form can show only the active tech's: the main display
form can show all tech's.

(david)

That's actually a really good idea. If say i have a tech table with a
techID
an active field binary and a name field then i could bind combo box on
techID and choose to have 0,.25,.75 values (something of that nature) for
the
display columns.
thank you for your help,
Preston

What I did was to include the Active field in the source for the combo
and
sorted first on Active and then Names. Dispay play both name and Active
field when selecting technician.
SELECT [Auditor].[Auditor], [Auditor].[Name],[Auditor].[Active] FROM
[Auditor] ORDER BY Active, LastName
--
KARL DEWEY
Build a little - Test a little

Hi,
I was wondering if I could get a little help with Access 2007. I am
trying
to create a database that will allow us to input service tickets with
technician's time and then generate timesheets for the week based on
that
data. Everything is going pretty smooth except for one thing. I have a
service ticket form that has a technician subform. On any one ticket
you can
have more than one time entry for technicians. This subform has a
lookup
field that looks up technician names from a query. However, i have
tried to
work active/inactive technician functionality into all of this. I want
inactive techs to not showup in the lookup field but i also don't want
them
to disappear from the service ticket form because their time should
still be
on the ticket even if they are made inactive. Quickbooks has this kind
of
functionality and (surprise) we are using quickbooks. Is there any way
to
mimic or reproduce this active/inactive status? I have tried changing
the
relationship type but that didn't fix anything. I unchecked ref integ
and
also cascade update. The technician entries would still be pulled from
the
service tickets when they were made inactive (they disappear from the
query
as they should also.)
sorry for the book and thank you for any help you can give.
Preston