Rob,
here are my table field names:
[Subpoena Delivery - Federal Express].[FETracking#],
[Subpoena Delivery - Federal Express].[FEShip Date],
[Subpoena Delivery - Federal Express].[FEDeliver By],
[Subpoena Delivery - Federal Express FEShip to Phone],
[Subpoena Delivery - Federal Express].[FEShip to Attention],
[Subpoena Delivery - Federal Express].[FEShip To Company],
[Subpoena Delivery - Federal Express].[FEShip To Street],
[Subpoena Delivery - Federal Express].[FEShip to City],
[Subpoena Delivery - Federal Express].[FEShip to State],
[Subpoena Delivery - Federal Express].[FEShip to Zip],
[Subpoena Delivery - US Mail].[USDate Mailed],
[Subpoena Delivery - US Mail].USLastName,
[Subpoena Delivery - US Mail].USFirstName,
[Subpoena Delivery - US Mail].USMiddle,
[Subpoena Delivery - US Mail].USCompany,
[Subpoena Delivery - US Mail].USStreet,
[Subpoena Delivery - US Mail].USCity,
[Subpoena Delivery - US Mail].USState,
[Subpoena Delivery - US Mail].USZip,
[Subpoena Delivery - US Mail].USPhone,
[Subpoena Delivery - Hand Delivery].[HDDate Delivered],
[Subpoena Delivery - Hand Delivery].HDLastName
[Subpoena Delivery - Hand Delivery].HDFirstName,
[Subpoena Delivery - Hand Delivery].HDMiddle,
[Subpoena Delivery - Hand Delivery].HDCompany,
[Subpoena Delivery - Hand Delivery].HDStreet,
[Subpoena Delivery - Hand Delivery].HDCity,
[Subpoena Delivery - Hand Delivery].HDState,
[Subpoena Delivery - Hand Delivery].HDZip,
[Subpoena Delivery - Hand Delivery].HDPhone,
[Subpoena Delivery - Interoffice].[IOTo Mailcode],
[Subpoena Delivery - Interoffice].[IOTo LastName],
[Subpoena Delivery - Interoffice].[IOTo FirstName],
[Subpoena Delivery - Interoffice].[IOTo Middle],
[Subpoena Delivery - Interoffice].[IOTo Phone],
[Subpoena Delivery - Interoffice].[IOFrom Mailcode],
[Subpoena Delivery - Interoffice].[IOFrom LastName],
[Subpoena Delivery - Interoffice].[IOFrom FirstName],
[Subpoena Delivery - Interoffice].[IOFrom Middle],
[Subpoena Delivery - Interoffice].[IOFrom Phone],
Any suggestions?
Rob Oldfield said:
Yes. You definitely need to record on the main table whether it went FedEx,
Mail, By Hand ..... You can either store those as text, or as code numbers
which relate
The next question is how different are the fields of information that you
need to store for each of these methods. You will, I assume, want to record
both SentDate and ReceivedDate for any of the different methods, but you are
going to have differences where, for example, FedEx will have some kind of
ID number given out by them, while sending it by hand won't have that. If
they're similar enough, then the easiest way round your issue will be just
to add those fields onto that main form - you can then fill them in by
either just displaying the fields that relate the particular ShipType on the
same form, or by popping up a subform based on the same table.
Again, the thing that you need to think about on the "are they similar
enough" question, is down to what you actually want to do with that data
later on.
I am understanding everything you are saying, except for the "ShipType"
field. Am I to add this field to my one big table; and, how do I store
the
data on the 'shiptype' that I pick. I need some type of data form to open
so
that I can enter information on the shipping method. Evidently, I am
missing
something you are saying. I hear one table and the 'Ship Type' field for
the
ListBox. What am I missing?
:
Slightly tricky. It actually comes down to how you organise your table
structure. It sounds like, at the moment, that you have one table for
each
of the shipping methods. I'd say that that is a structure to avoid -
unless
the fields that you need to store for each one are fundamentally
different.
If they're not, then I'd just store that information in fields on the
main
table (although you will end up with fields which *must* be blank - if
you
have a delivery reference that is applicable for FedEx, then you're
never
going to have that data for Interoffice). Having said that,
reorganising
your data in this way might cause problems later on dependent upon what
else
you want to do with the data.
Either way, you're going to need to control which controls/which subform
to
display. I'd definitely suggest losing the command buttons - a simple
drop
down list (bound to a field ShipType) showing each of the methods is
going
to be better.
You're then going to need to run code in both the AfterUpdate event of
that
control (so that the relevant controls are displayed when ShipType is
updated) and also the Current event of the form (so that the same thing
happens when the user moves from record to record). That will be the
same
code in both cases and will need to include...
if isnull(me.shiptype)
'hide all fields/subforms which are dependent upon knowing ShipType
endif
so that nothing is available *until* the ShipType is entered.
So - how different are the fields of data required for each method?
On the main form, I have the basic information on the data I am
tracking.
However, one piece that could vary is how the final response was
shipped:
Federal Express, U.S. Mail, Hand Delivered, or Interoffice. For
these, I
have developed subform.
Unfortunately, when a record on the main form is displayed, and you
don't
know up-front that it was shipped U.S. Mail and click the Federal
Express
Button, the first record for Federal Express is displayed, rather that
US
Mail. This record is displayed regardless as to whether it is the
method
of
shipment for the main form record. How do I tie the correct method of
shipment to the correct main record.
In order to click the right delivery method button (Federal Express,
US
Mail....) for the displayed record, you have to know the method of
shipment
upfront.
I need for the coordination to automatically take place. When the
main
record is displayed, highlight the cmdButton for shipment type and
'gray
out'
the other buttons..
Can you help me with the code?
:
What do you mean by 'synchronise'? The usual relationship that
exists
between records on a main form, and records on a subform is just
that a
one
to many relationship applies between the two (controlled by the
master
and
child fields properties of the subform control). If you data is in
that
form, then it would just be a case of each command button setting
the
source
object for the subform control, and also resetting the master and
child
fields (me.SubformControlName.linkchildfields and
me.subformcontrolname.linkmasterfields). It might be that you don't
always
need to reset both - if the parent field for all six subforms was an
ID
field then you wouldn't need to touch it.
Does that make any sense to you?
Microsoft Access 2003
I have developed a Main Tracking form in Access. I have six
cmdButtons on
the Main form that 'on-click' opens difference subform. How do I
synchronizing the data in the Main form with the data in the
subform.
Or
can
this synchronization of a main form and six subforms be done? As
you
may
have noted, I am extremely new at this.
Any help is greatly appreciated.
patricia
