Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mattymatt79

    Many to Many relationship with tables

    Thanks guys for all the very very valuable info on this little project of mine, I think I got most of it figured out and you guys definetly helped.
  2. mattymatt79

    Many to Many relationship with tables

    Well if visit doesn't need an ID, then how would you create the relationship? I figured it would need to have a serialized document on each entry so it knows its place, making it the PK
  3. mattymatt79

    Many to Many relationship with tables

    I clicked all three fields in the tblVisit and made them primary keys, so now I just need to make the relationship to work, I never knew I could do that in access with the multifield PK. Thanks for that.
  4. mattymatt79

    Many to Many relationship with tables

    I'm having a hard time understanding what you mean? Access only allows me to label one primary key. I made the primary key of tblVisit ID
  5. mattymatt79

    Many to Many relationship with tables

    I'm guessing thats SQL coding? or some kind of variant of that? ok, I get that I'm creating 3 tables, PK In Customers is ID (Autonumber in Access) PK In Dealers is ID Visits would be the intermediary table using the ID from Customers and Dealers as foriegn keys? As of now I currently have...
  6. mattymatt79

    Many to Many relationship with tables

    Well I'm pretty rusty on the concepts of many to many relationships, but I'm assuming thats what I want to create for this situation. What I'm creating is a database to track customers that enter my place of buisness. So far so good, but what I'm having issues with is 2 of the major things...
  7. mattymatt79

    certain page not displaying

    ok, well looking at it, it shows correctly inside of firefox but in internet explorer it doesn't show at all. Could there be something in IE that doesn't allow it to show correctly?
  8. mattymatt79

    certain page not displaying

    I have a windows 2000 machine in my domain and I've checked the firewall settings and it is not displaying a certain page. It works for me from my machine but I know my machine has unaltered access to the internet. Ive checked through the banned destinations and the page is not in that, and...
  9. mattymatt79

    Outlook Custom Form VBA Question

    Ok, Ive figured out its something inside the strMyField Any clue?
  10. mattymatt79

    Outlook Custom Form VBA Question

    Ok, I read through the office kb article about adding in ' If the form contains user-defined fields, you can use ' the following syntax to transfer the contents of a ' user-defined field (FieldName) to Word: ' strMyField = Item.UserProperties.Find("FieldName") ' oDoc.FormFields("Text3").Result...

Part and Inventory Search

Back
Top