Search results

  1. M

    help with " and ' in the values (i've tried everything and i'm still lost!)

    thanks ok - i'll give that a try. sometimes i feel like homer simpson as i bungle thru this coding stuff :p
  2. M

    help with " and ' in the values (i've tried everything and i'm still lost!)

    hi everyone - i am making a db that has the names of paintings. some paintings would come out Hunting Scene (generic) or specific - "The Hunter's Scene". So while I have been able to find solutions for dealing with EITHER apostrophes OR double quotes, i can't find one that will work with...
  3. M

    Multiple tables, query to make form

    no doubt! would you mind taking a look if i uploaded what i have now? i'm trying to hammer this out tonight. you're the first person who's responded in over 12 hours to my posts on either forum. i think the tblBookAuthors had something to do with relating things back to the tblBookInfo. but...
  4. M

    Multiple tables, query to make form

    hmm... someone on the utteraccess forum advised me to use the tblBookAuthors as a way to link the authors with the books. i don't think it should be on the tblBookInfo because there's a whole list of authors. it should be on it's own table. but beyond that, i don't know about the...
  5. M

    Import Data into Related Tables?

    not sure if this only applies to Access 2007 but... i am new to access and i read Pat's answer and it seemed to make sense. however, when i got to the part about creating an update query to update the PK field on the table, i was all confused. i kept hitting "view" in access 2007 to see how it...
  6. M

    Multiple tables, query to make form

    Hi all, I'm a newbie so bear with me. I have attached my db in both 2007 and 2000 formats. I would like a table to be able to enter: BookTitle BookAuthor Category Subcategory Format However, I'm having trouble. If I do a select query, no results are returned. And I tried messing with the...
Back
Top Bottom