Recent content by krishill

Relationships ????? Ok, please let me know if you cannot see this correctly for whatever reason (I just saved it as a Winzip file?). You'll see that I have no idea how to link my MATERIALS table to anything else. The MATERIALNUMBER field will be the same as the P???? fields in the three other...

How can you help? Hey guys, Ok....how can I lay everything out so you can help me normalize and link all my tables? Just give you the table names & fields for each in the format Fizzio gave me above? Would you be able to help just with that info or do I need to give you anything else...

relationships Hey guys, working hard on this. My last question I still need answered, but have another one...this should be easy. Do ALL tables in a database have to be either one-to-many or many-to-many (or one-to-one) or can I have two tables with a one-to-many relationship but another...

unique keys? Hi Pat! Thanks for the reply. What about the fact though that NOTHING on here is a unique value except the Course#...and get this! I just found that we're doing away with all the #s because our new system can't do them so they'll just be the course titles! So the course title...

# of Materials fields Hey guys, me again. I just wanted to update this again, with new info (sorta). I need to be able to have up to 10 spots each for all the different MATERIALS (Required Student, Optional Course, and Required Instrctor). 10 EACH. So it can be anywhere from ZERO to TEN for...

P# answer Hi. I said in my last post that "I've got an email into my boss now asking if the P#s are going to be completely unique, that should help answer one question about them. I *THINK* they will be, but not sure. " Well, got the answer. The P # CAN be on more than one course. Just...

Report won't open Hi There! I didn't get an email telling me there were replies to this post!! I'm glad I came to check on it. Anyway, I've opened the .zip file you sent me and the database opened, but when I tried to open the report it tells me that it cant' do it, so to "Debug" or "End"...

Pat - Please see my other thread posting! Hi Pat!!! Please see my thread posting at: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=50197 I started to do it as a reply to this but it really isn't a REPORT question so I didn't want to post it in the wrong place! Let me...

Ok, with all of the problems I've been having with my database, I think I've finally gotten to the nitty gritty of it - that I need to normalize it and have more tables! This was the only thing I was NOT looking at in trying to find the answer! I've been reading all day about Normalization and...

relationships? I have a question for you Pat (or anyone else who can answer). I guess I don't really understand why I need separate tables for each section of my report. Every field on it has to do with the course. It's not like I have info on there about students, or schools, or some...

Thank you Pat! Thank you so much Pat. That's like the one thing I was NOT looking at, thinking that it was ok. lol I have now printed out a ton of info on Normalization and will work some more on my table(s). Again, thanks a bunch! Keep your fingers crossed I understand all this stuff I...

Please see report Thanks Pat for your reply! Please take a look at my database attached. You can see the form and the report from it that I use. I think I have page 1 ok, don't I? But I really don't understand what you're saying about page 2 and on. Could you please elaborate a little on...

Ok, this is my BIGGEST problem of all trying to figure this all out (if you've seen my other questions). Please see the attached Word document. Please look at page 2 of that document. Now...is there ANY way possible to have this REPORT be put into Access and look at least almost like it...

Hey guys! I hope you can help me with this! I have a feeling, from all the hundreds of forums I've read, that the answer is NO, not possible, but hey, I'll ask anyway! Is it possible to have page 2 of a report (and page 3 and on if longer) be 2 or 3 columns when page 1 is NOT!?!?!?! Kris

This is another one that I have spent days trying to find info on! I have some fields that are hyperlinked. I figured out how to do that and it's working, I can open documents. However, IS THERE A WAY to have it automatically attach to a document (in a certain spot, with same name as value...