Search results
-
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- mollycase
- Post #3
- Forum: Modules & VBA
-
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...- mollycase
- Thread
- Replies: 8
- Forum: Modules & VBA
-
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... -
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... -
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... -
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...