Re: Synchronizing the Main form and six (6) subforms?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" wrote:

> 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.
>
>
>
>
> "phmckeever" <phmckeever@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:86AE9437-B19A-4AEF-B8EA-A6CD1B326EEE@xxxxxxxxxxxxxxxx
> > 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?
> >
> > "Rob Oldfield" wrote:
> >
> > > 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?
> > >
> > >
> > > "phmckeever" <phmckeever@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:D9B673AC-3E39-422F-B7F1-1480A058D05D@xxxxxxxxxxxxxxxx
> > > > 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?
> > > >
> > > > "Rob Oldfield" wrote:
> > > >
> > > > >
> > > > > 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?
> > > > >
> > > > >
> > > > > "phmckeever" <phmckeever@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > > > news:499D9E3F-739B-4721-93AD-B4A463092BCE@xxxxxxxxxxxxxxxx
> > > > > > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>
.

Quantcast