Posted by Racer on July 1, 2004, at 20:09:47
In reply to have you got your towel with you? » Racer, posted by NikkiT2 on July 1, 2004, at 13:41:06
LOL! And my husband came up with a good one today, too:
"You know, it might be better to go out and buy MS Visual Basic and learn to use it so that you can build this thing..."
Thanks, Honey...
OK, first, the problem with the tab is fixed -- but now that's I've entered a few days worth of this stuff, another problem has come up! For some reason, it isn't updating certain linked fields. I'm thinking that I've either got to add the primary keys from those tables into the linking table, or add the fields from those tables into the query that one of my subforms is based on? Can you help with that?
The relationships from the linking table are all set at one-to-many, based on a compound primary key in the linking table, since it's really many-to-many-to-many > TOO MANY! Sorry, got a little hot there... It's three tables set to the linking table, at any rate. They're all set to "cascade update" and everything worked EXCEPT that the date and time were only created in the linking table, not any of the child tables?
I know what the real problem is, by the way, so don't tell me to learn to do it properly or I'll have to stick my tongue out at you. I know how to use the program a little, and I know a little about relational databases, but I don't know how to *program* a relational database in Access, 'K? I already *know* that. {sulk}
OK, back now! {bright smile} If you can offer any better advice than my husband did -- other than crayons -- I'd love to hear it.
And your job sounds pretty awesome, although not the taking minutes part. (Then again, I can't write very well by hand, and do it very slowly. It's much worse now than when I was in school, but even then my notes were the last you'd want to borrow. I'd go home each night and transcribe them while I could still remember the class well enough that I could decipher them...) And Prince Charles? Eldest son of one of the sexiest men I ever saw? Too COOL! You gonna tell us what he was there for, or is it a secret? Congrats!
poster:Racer
thread:362006
URL: http://www.dr-bob.org/babble/2000/20040626/msgs/362400.html