Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    Australia
    Posts
    2

    Question Unanswered: Creating fields with a macro...?

    I have a little problem, and one possible solution I see can be done by hand... but I need it to be done by a macro for end-user usfulness.

    So after using a make-table query, is it possible to then:
    * Add a new field to this table,
    * Set data type of this field to autonumber,
    * Create relationship from this new field to an existing table and field?

    If anyone has time to respond, I'd be a happy man even a poke in the right direction/ where I can find information/ if its even possible would be helpful.

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    Hi scrash,

    Manuel Gimenez had the very same questions a few months ago. Check it out!

    Add an Autonumeric Field into a Table

    Create Relations between tables into a module

    Does that make you a happy man?
    JT

  3. #3
    Join Date
    Aug 2003
    Location
    Australia
    Posts
    2

    Thumbs up

    You have no idea how happy a man it makes me.

    Thanks a bajillion!

  4. #4
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    Originally posted by scrash
    You have no idea how happy a man it makes me.
    Really? A few lines of code is all it takes?

    * ditches family, heads to Australia iso "scrash", intends to propose marriage *

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •