Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    12

    Unanswered: Is this Possible? Updateable Query/Form. Mine Wont Work! HELP!

    Ok. I logged on here almost a year ago, trying to learn how to set up a basic Database. Since then, I've been hooked. I use this database for soooooo many things at work. No one can figure out how I always have so much info/data at my fingertips. So THANKS SO MUCH!!!!

    Now.... I need some help...

    Heres what I have....

    • I have Tables that are linked to Excel Files I Download each night.
    • I also have 1 Table that is a Standard Table I can Add Records to.
    • I have all of the Excel File Tables, and the 1 Table I made Joined together in a Query with 1 Common field (I call it Stock # (They are cars for a dealership)).
    • The 1 Table (not the excel Table) is a table that I edit Notes of the cars, and what the Status..


    What I want to do, is Creat a Form, That Looks at this Query, and lets Lets me modify the field where my Notes are.

    I'm sure this is possible right?!?!

    I Tried it, and I created the form, but I could not edit the notes Field. I had to pull up the table and do it manually.... What a Pain.

    Thanks again so much!!!!


    **UPDATE** After more reading.... What I need is to make the Query Updateable, then the Form Should be able to also. My Query will not Update. And I think it may have something to do with the join properties.


    -Dave Kost
    Park Cities Ford Lincoln Mercury
    Dallas, TX
    Last edited by koster88; 10-26-09 at 19:40.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It will definitely be something to do with the join properties.

    Get a new query and add only the table you want to modify the data of.
    Test that the query allows updates.
    Now add one more table, link it.
    Test that the query allows updates.
    Add another table...
    Test that the query allows updates.

    Eventually, you will find the link which is causing the updates to be locked out. This will give you at least a hint as to what is going on.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2008
    Posts
    12
    Quote Originally Posted by StarTrekker
    It will definitely be something to do with the join properties.

    Get a new query and add only the table you want to modify the data of.
    Test that the query allows updates.
    Now add one more table, link it.
    Test that the query allows updates.
    Add another table...
    Test that the query allows updates.

    Eventually, you will find the link which is causing the updates to be locked out. This will give you at least a hint as to what is going on.
    Ok I Tried this. If I do a Query of only the table That will get modified it works. Then, as soon as I add any of the other Tables (They are linked Excel Tables), it will Not let me modify the Query. What can I do to the Join Properties to allow it to be modified?

    -Dave

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Mnnn... linked XL tables. Can't say I have much experience with that :/

    You could try using outer joins... double click on the relationship line and set it to all records from (the table you want to modify) and only those matching records from (the XL table).

    See how that goes.

    Beyond that, you might have to consider copying the XL data to Access tables (temporarily) and use them instead.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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