Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Allen Browne's Audit Trail

Discussion in 'Information Technology' started by Gabby Girl, Jul 28, 2006.

  1. Gabby Girl

    Gabby Girl
    Expand Collapse
    Guest

    Hello,

    I've previously used Allen Browne's "Creating and Audit Log" with no
    problems. I've now just gone through the same procedures for my
    tblEquipmentMaster but now it won't work. Could it be because the Primary
    key is a text data type as opposed to a number? If so, can I work around
    this?

    Any help would be greatly appreciated.

    Thanks Kindly
     
  2. Loading...


  3. Gabby Girl

    Gabby Girl
    Expand Collapse
    Guest

    Sorry, I just reread Allen's notes and found that the table to be audited
    must have an Autonumber primary key. Oh well, back to the drawing board.

    Thanks anyway.

    "Gabby Girl" wrote:

    > Hello,
    >
    > I've previously used Allen Browne's "Creating and Audit Log" with no
    > problems. I've now just gone through the same procedures for my
    > tblEquipmentMaster but now it won't work. Could it be because the Primary
    > key is a text data type as opposed to a number? If so, can I work around
    > this?
    >
    > Any help would be greatly appreciated.
    >
    > Thanks Kindly
    >
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Gabby Girl, you could re-write the code so that it supported a Text type
    primary key.

    The main issue would be the need to add extra quote delimiters within the
    action query statements.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    news:74F67B41-6124-422F-86E6-C11639B09CF9@microsoft.com...
    > Sorry, I just reread Allen's notes and found that the table to be audited
    > must have an Autonumber primary key. Oh well, back to the drawing board.
    >
    > Thanks anyway.
    >
    > "Gabby Girl" wrote:
    >
    >> Hello,
    >>
    >> I've previously used Allen Browne's "Creating and Audit Log" with no
    >> problems. I've now just gone through the same procedures for my
    >> tblEquipmentMaster but now it won't work. Could it be because the
    >> Primary
    >> key is a text data type as opposed to a number? If so, can I work around
    >> this?
    >>
    >> Any help would be greatly appreciated.
     
  5. Gabby Girl

    Gabby Girl
    Expand Collapse
    Guest

    Hi Allen,

    Thank you so much for your response. I would love to be able to do that,
    but unfortunately my VB is limited. What about my other audit trails that do
    work on autonumber primary keys? Would this not mess them up? Or would I have
    to have 2 different calling functions? I thought I might be able to add an
    autonumber primary key field as well as my EquipmentId (I don't want to have
    to change all my relationships, etc hence why I would leave EquipmentId as a
    "sub" primary key). Would this work? Or is it a totally dumb idea? I would
    appreciate any assistance that you could give me.

    Thanks Kindly

    "Allen Browne" wrote:

    > Gabby Girl, you could re-write the code so that it supported a Text type
    > primary key.
    >
    > The main issue would be the need to add extra quote delimiters within the
    > action query statements.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    > news:74F67B41-6124-422F-86E6-C11639B09CF9@microsoft.com...
    > > Sorry, I just reread Allen's notes and found that the table to be audited
    > > must have an Autonumber primary key. Oh well, back to the drawing board.
    > >
    > > Thanks anyway.
    > >
    > > "Gabby Girl" wrote:
    > >
    > >> Hello,
    > >>
    > >> I've previously used Allen Browne's "Creating and Audit Log" with no
    > >> problems. I've now just gone through the same procedures for my
    > >> tblEquipmentMaster but now it won't work. Could it be because the
    > >> Primary
    > >> key is a text data type as opposed to a number? If so, can I work around
    > >> this?
    > >>
    > >> Any help would be greatly appreciated.

    >
    >
    >
     
  6. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Yes, another unique number field would be fine, so adding an AutoNumber
    would solve the problem.

    Re-writing the code would be a bigger issue.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    news:B2ED00B9-049A-4290-B27E-0A1C68B524BF@microsoft.com...
    > Hi Allen,
    >
    > Thank you so much for your response. I would love to be able to do that,
    > but unfortunately my VB is limited. What about my other audit trails that
    > do
    > work on autonumber primary keys? Would this not mess them up? Or would I
    > have
    > to have 2 different calling functions? I thought I might be able to add
    > an
    > autonumber primary key field as well as my EquipmentId (I don't want to
    > have
    > to change all my relationships, etc hence why I would leave EquipmentId as
    > a
    > "sub" primary key). Would this work? Or is it a totally dumb idea? I
    > would
    > appreciate any assistance that you could give me.
    >
    > Thanks Kindly
    >
    > "Allen Browne" wrote:
    >
    >> Gabby Girl, you could re-write the code so that it supported a Text type
    >> primary key.
    >>
    >> The main issue would be the need to add extra quote delimiters within the
    >> action query statements.
    >>

    , rather than allenbrowne at mvps dot org.
    >>
    >> "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    >> news:74F67B41-6124-422F-86E6-C11639B09CF9@microsoft.com...
    >> > Sorry, I just reread Allen's notes and found that the table to be
    >> > audited
    >> > must have an Autonumber primary key. Oh well, back to the drawing
    >> > board.
    >> >
    >> > Thanks anyway.
    >> >
    >> > "Gabby Girl" wrote:
    >> >
    >> >> Hello,
    >> >>
    >> >> I've previously used Allen Browne's "Creating and Audit Log" with no
    >> >> problems. I've now just gone through the same procedures for my
    >> >> tblEquipmentMaster but now it won't work. Could it be because the
    >> >> Primary
    >> >> key is a text data type as opposed to a number? If so, can I work
    >> >> around
    >> >> this?
    >> >>
    >> >> Any help would be greatly appreciated.
     
  7. Gabby Girl

    Gabby Girl
    Expand Collapse
    Guest

    Again Thank you so very much Allen. Just to confirm before I continue (and
    please forgive my ignorance), I can add the autonumber but leave all my
    relationships the same and all my other code will still work the same?

    I know you've been told this before but I'm going to reiterate, All of you
    MVP's are fabulous and Thank You so much for taking the time to help.

    Regards

    "Allen Browne" wrote:

    > Yes, another unique number field would be fine, so adding an AutoNumber
    > would solve the problem.
    >
    > Re-writing the code would be a bigger issue.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    > news:B2ED00B9-049A-4290-B27E-0A1C68B524BF@microsoft.com...
    > > Hi Allen,
    > >
    > > Thank you so much for your response. I would love to be able to do that,
    > > but unfortunately my VB is limited. What about my other audit trails that
    > > do
    > > work on autonumber primary keys? Would this not mess them up? Or would I
    > > have
    > > to have 2 different calling functions? I thought I might be able to add
    > > an
    > > autonumber primary key field as well as my EquipmentId (I don't want to
    > > have
    > > to change all my relationships, etc hence why I would leave EquipmentId as
    > > a
    > > "sub" primary key). Would this work? Or is it a totally dumb idea? I
    > > would
    > > appreciate any assistance that you could give me.
    > >
    > > Thanks Kindly
    > >
    > > "Allen Browne" wrote:
    > >
    > >> Gabby Girl, you could re-write the code so that it supported a Text type
    > >> primary key.
    > >>
    > >> The main issue would be the need to add extra quote delimiters within the
    > >> action query statements.
    > >>

    > , rather than allenbrowne at mvps dot org.
    > >>
    > >> "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    > >> news:74F67B41-6124-422F-86E6-C11639B09CF9@microsoft.com...
    > >> > Sorry, I just reread Allen's notes and found that the table to be
    > >> > audited
    > >> > must have an Autonumber primary key. Oh well, back to the drawing
    > >> > board.
    > >> >
    > >> > Thanks anyway.
    > >> >
    > >> > "Gabby Girl" wrote:
    > >> >
    > >> >> Hello,
    > >> >>
    > >> >> I've previously used Allen Browne's "Creating and Audit Log" with no
    > >> >> problems. I've now just gone through the same procedures for my
    > >> >> tblEquipmentMaster but now it won't work. Could it be because the
    > >> >> Primary
    > >> >> key is a text data type as opposed to a number? If so, can I work
    > >> >> around
    > >> >> this?
    > >> >>
    > >> >> Any help would be greatly appreciated.

    >
    >
    >
     
  8. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Yes. You can leave the other fields intact.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    news:ED899581-51E0-4EFA-B65D-7EE355784D0B@microsoft.com...
    > Again Thank you so very much Allen. Just to confirm before I continue
    > (and
    > please forgive my ignorance), I can add the autonumber but leave all my
    > relationships the same and all my other code will still work the same?
    >
    > I know you've been told this before but I'm going to reiterate, All of you
    > MVP's are fabulous and Thank You so much for taking the time to help.
    >
    > Regards
    >
    > "Allen Browne" wrote:
    >
    >> Yes, another unique number field would be fine, so adding an AutoNumber
    >> would solve the problem.
    >>
    >> Re-writing the code would be a bigger issue
     
  9. Gabby Girl

    Gabby Girl
    Expand Collapse
    Guest

    Great. Thanks Allen.
    Have a great day.


    "Allen Browne" wrote:

    > Yes. You can leave the other fields intact.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Gabby Girl" <GabbyGirl@discussions.microsoft.com> wrote in message
    > news:ED899581-51E0-4EFA-B65D-7EE355784D0B@microsoft.com...
    > > Again Thank you so very much Allen. Just to confirm before I continue
    > > (and
    > > please forgive my ignorance), I can add the autonumber but leave all my
    > > relationships the same and all my other code will still work the same?
    > >
    > > I know you've been told this before but I'm going to reiterate, All of you
    > > MVP's are fabulous and Thank You so much for taking the time to help.
    > >
    > > Regards
    > >
    > > "Allen Browne" wrote:
    > >
    > >> Yes, another unique number field would be fine, so adding an AutoNumber
    > >> would solve the problem.
    > >>
    > >> Re-writing the code would be a bigger issue

    >
    >
    >
     

Share This Page