Re: Duplicating

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

From: Kuwait in Army**US (SteveMurphyKuwaitinArmyUS_at_discussions.microsoft.com)
Date: 11/29/04

  • Next message: Kuwait in Army**US: "RE: .jpg pictures are allowed to store as OLE objects?" 
    Date: Mon, 29 Nov 2004 01:25:02 -0800

    The field is a 17 digit text field example "W915BQ43220851XXX" . If you have
    ever been in the military regardless of branch, you will recognize this as a
    TCN # or TMR #. If not, no big deal, this is a transportation code for cargo,
    air cargo in this case. I work for the Army, preparing and transporting air
    cargo on the Air Force cargo jets. What I have developed is a Access program
    to accomplish the paperwork in a more efficient manner. Using the "Duplicate"
    button helps speeds this process. The problem I have is this TMR/TCN cannot
    be a duplicate once used it is never good again. Ideally I would have a
    button to duplicate al of the cargo information except the TCN/TMR or have it
    automatically change the TCN/TMR even if it is the last digit being the "X"
    changing to a numeric value that increased per duplicate. Current I have the
    table properties for this field set to duplicates ok, but I really shouldn't
    have it set that way. Unfortunately being self Access taught I do not posses
    the knowledge, YET, to write a VBA to expound on the current capabilities of
    Access. If you can provide guidance I would greatly appreciate it.
    Steve

    "John Vinson" wrote:

    > On Sun, 28 Nov 2004 04:13:02 -0800, Steve Murphy (Kuwait in Army**US)
    > <Steve Murphy (Kuwait in Army**US)@discussions.microsoft.com> wrote:
    >
    > >Using the duplication button speeds data entry tremendously. Is there any way
    > >to duplicate and auto change a "indexed (no duplicates)" field, (it is text)?
    > >The wholes form revolves around that field, which is comprised of letters and
    > >numbers, and I would rather not have duplicates of it.
    >
    > You'll need to give us some help here. Certainly, it can be changed,
    > probably using a small VBA function; but since you don't say what the
    > field looks like, what values currently exist, and how it should be
    > changed, it's more than a bit difficult to suggest just how!
    >
    > I'd suggest putting the code to calculate the new value in the Form's
    > BeforeInsert event; it would need to use DLookUp() to find the
    > previous entry and then some algorithm (depending on the content of
    > the field) to generate the new value.
    >
    > John W. Vinson[MVP]
    > Join the online Access Chats
    > Tuesday 11am EDT - Thursday 3:30pm EDT
    > http://community.compuserve.com/msdevapps
    >

  • Next message: Kuwait in Army**US: "RE: .jpg pictures are allowed to store as OLE objects?"

    Relevant Pages

    • Re: Duplicating
      ... preparing and transporting air ... >cargo on the Air Force cargo jets. ... >be a duplicate once used it is never good again. ... Dim iSeq As Integer ...
      (microsoft.public.access.forms)
    • Re: generating a random six digit number
      ... I have to come up with a random six digit  SPC code. ... In order to avoid duplicates you need to avoid using random numbers, ... The easiest permutation to use is some ... Do not change the key unless you want to risk duplicate ...
      (sci.crypt)
    • RE: Customized Autonumbering
      ... Is not returning the 3 digit day. ... Dim strReturn As String ... 'Do a DLookup in the table for an existing duplicate value. ... 'Duplicate Number, increment ...
      (microsoft.public.access.modulesdaovba)
    • Re: Duplicating
      ... Guess I need to teach myself VBA, ... it can take me way beyond the capabilities of "just" Access. ... preparing and transporting air ... >>changing to a numeric value that increased per duplicate. ...
      (microsoft.public.access.forms)
    • Re: Lord Valve Conservatism is a metal disorder
      ... "borrows" other people's words without attribution shouldn't be so ... trip....still trying to duplicate that tone... ... Happened to me when I started hearing too many lo0ns blowing hot air. ... water because they *don't* follow scientific processes when they use ...
      (alt.guitar.amps)