[mso] Re: ACCESS - Update Records

Well...then I can only assume you'll have to learn some Access VBA????
Cos' I don't know how it would be done any other way. Sorry!

Dian Chapman
Technical Consultant,
Microsoft MVP & TechTrax Editor

Tutorial web site: http://www.mousetrax.com
TechTrax Ezine: http://www.mousetrax.com/techtrax/
Word MVP support site: http://www.mvps.org/word
Microsoft support groups: http://support.microsoft.com


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Charles Ippolito
Sent: Wednesday, May 22, 2002 11:37 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: ACCESS - Update Records


The whoel thing is I don't want to have to actually enter ANY price...
the price should be set when the ordered is entered, and the item is
looked up for the price... whatever the price is at that given time,
that's what the price should remain.

---Charlie

  ----- Original Message ----- 
  From: Dian Chapman 
  To: mso@xxxxxxxxxxxxx 
  Sent: Tuesday, May 21, 2002 5:43 PM
  Subject: [mso] Re: ACCESS - Update Records



  Create another table with just the prices and link the relationship to
  the field with prices. Then you can change the prices, but the one set
  for any order will remain unchanged. Make it a combo box so you can
  click a drop down to easily find the current price, if there aren't
too
  many or start typing and the current price will usually show up fairly
  quickly. But it'll also give you the advantage of being able to enter
a
  new price if the current one isn't already in the table.

  Dian Chapman
  Technical Consultant,
  Microsoft MVP & TechTrax Editor

  Tutorial web site: http://www.mousetrax.com
  TechTrax Ezine: http://www.mousetrax.com/techtrax/
  Word MVP support site: http://www.mvps.org/word
  Microsoft support groups: http://support.microsoft.com


  -----Original Message-----
  From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
  Behalf Of Charles Ippolito
  Sent: Tuesday, May 21, 2002 2:05 PM
  To: mso@xxxxxxxxxxxxx
  Subject: [mso] Re: ACCESS - Update Records


  Well, yes, that is what I need to do, but it's not with every single
  field. Maybe with an example you can see why I would want to do
that...

  Let's say I have a table with with orders, and I have another table
with
  products for sale. When entering an order, I will enter in the product
  ID and through the relationships it will automatically fill in the
  product description and price. 

  Now, in the future, I may need to change the product ID, for whatever
  reason, and I would need the product ID to change in all the records
its
  been entered in as well. So, there, its ok for everything to change.

  On the other hand, let's say the price changes. Well, in the past
  orders, I need to show what the price was at the time the order was
  entered, NOT what it is currently. So, if I change the price in the
  PRODUCTS table, I cannot have the price change in orders that have
been
  entered.

  So, the question is, how would I allow this in some fields, but not
  others.

  Thanks!

  ---Troth


    ----- Original Message ----- 
    From: James LaBorde 
    To: 'mso@xxxxxxxxxxxxx' 
    Sent: Tuesday, May 21, 2002 2:17 PM
    Subject: [mso] Re: ACCESS - Update Records



    Charlie,

    Are you saying that you want to change data that is linked but not
  have it
    changed everywhere it has already been entered?  It sounds like you
  may be
    trying to violate referential integrity which isn't necessarily a
good
  idea.
    If you do want to do it, you can simply uncheck the box to enforce
    referential integrity on the relationships.  Be very careful with
  doing this
    though.  It will allow you to have "orphaned" records in your
  database.  

    James La Borde
    South Western Federal Credit Union

    -----Original Message-----
    From: Charles Ippolito [mailto:CharlesMTFAccess@xxxxxxxxxxx]
    Sent: Tuesday, May 21, 2002 11:01 AM
    To: MSO
    Subject: [mso] ACCESS - Update Records :VSMail MX2


    I have my tables and forms set up. I have my relationships between
all
  the
    tables set up as well. Now, using a form, when I enter data in one
  field, it
    will automatically add the correct info in related fields. Fine, as
  that's
    what I want.

    However, sometimes I might change data in a field from a table and I
  do NOT
    want it to update in existing records... how would I go about doing
  this?

    If I didn't explain that correctly, let me know and I'll rephrase my
    request.

    Thanks!

    ---Charlie



    *************************************************************
    PLEASE READ!!!!

    You are receiving this mail because you subscribed to
  mso@xxxxxxxxxxxxx or
    MicrosoftOffice@xxxxxxxxxxxxxxxx

    To Unsubscribe from this group, send an email to
  mso-request@xxxxxxxxxxxxx
    with a subject line that says "unsubscribe" (without the quotes).
Do
  not
    put unsubscribe IN CAPS.  Screaming doesn't get you out any faster
and
  the
    caps prevent the function from working.

    To change your email settings to digest or vacation (no mail), visit
  the
    group's homepage for full instructions.

    http://www.freelists.org/webpage/mso

    To be able to use the files section for sharing files with the
group,
  send a
    request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
  invitation
    with instructions.
    *************************************************************
    *************************************************************
    PLEASE READ!!!!

    You are receiving this mail because you subscribed to
  mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx

    To Unsubscribe from this group, send an email to
  mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe"
  (without the quotes).  Do not put unsubscribe IN CAPS.  Screaming
  doesn't get you out any faster and the caps prevent the function from
  working.

    To change your email settings to digest or vacation (no mail), visit
  the group's homepage for full instructions.

    http://www.freelists.org/webpage/mso

    To be able to use the files section for sharing files with the
group,
  send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
  invitation with instructions.
    *************************************************************

  *************************************************************
  PLEASE READ!!!!

  You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx
  or MicrosoftOffice@xxxxxxxxxxxxxxxx

  To Unsubscribe from this group, send an email to
  mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe"
  (without the quotes).  Do not put unsubscribe IN CAPS.  Screaming
  doesn't get you out any faster and the caps prevent the function from
  working.

  To change your email settings to digest or vacation (no mail), visit
the
  group's homepage for full instructions.

  http://www.freelists.org/webpage/mso

  To be able to use the files section for sharing files with the group,
  send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
  invitation with instructions.
  *************************************************************

  *************************************************************
  PLEASE READ!!!!

  You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx

  To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe"
(without the quotes).  Do not put unsubscribe IN CAPS.  Screaming
doesn't get you out any faster and the caps prevent the function from
working.

  To change your email settings to digest or vacation (no mail), visit
the group's homepage for full instructions.

  http://www.freelists.org/webpage/mso

  To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.
  *************************************************************

*************************************************************
PLEASE READ!!!!

You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe"
(without the quotes).  Do not put unsubscribe IN CAPS.  Screaming
doesn't get you out any faster and the caps prevent the function from
working.

To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.

http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.
*************************************************************

*************************************************************
PLEASE READ!!!!

You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.
*************************************************************

Other related posts: