Results 1 to 5 of 5

Thread: a hand with button codeing anyone?

  1. #1
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116

    a hand with button codeing anyone?

    trying to code a command button to do the following :

    1. add a new record to the table the form is based off of
    2. drop the new project number into the 3 or 4 other tables that use it

    can anyone think of a decent way to accomplish this considering i only have a rudimentary knowledge of VB?

    Brandon

  2. #2
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    For steps 1 & 2: Execute an Append query to add the new record. Or do it with the use of a recordset but more coding knowledge reqd.

    Out of curiosity why can the user not add a new record on the form itself ?

  3. #3
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116
    Basicly there is a frmNew_Project form that lets you put in a number, name, leader, evaluator, and a few other pieces of key info. The other tables wont have info in them right away, and prolly wont for a month or two. So I want a button on the frmNew_Project form that simply puts matching numbers in all of the subsidary tables. That way they dont have to go into multiple forms and what not and search for numbers in other places.
    At least... thats the plan.

    The thing is, I figured it would be append queries, but I have had 0 luck calling a query in VBA. So a brief handout / handup on syntax for such a thing would be greatly appreciated.

    Brandon
    -=sometimes nothing can be a real cool hand=-

  4. #4
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    See if this helps at all....

    http://www.visualbasicforum.com/show...?postid=417475

    Let me know if you're none the wiser after reading this. It is quite similar to what you what to do.

    It's another forum if nothing else.

  5. #5
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116
    Thanks for the help KnooKie, it gave me a starting point for what to look for. I ended up goin to my local Borders and just buying a book. Then I fixed it in like 20 min.

    Anyway, you are still my hero.

    Brandon

Posting Permissions

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