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!

Register Log in
  • 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. DotComDV

    Staying in the Background

    hi there all, I have a small program that displays in a window a line from a txt file. After 1 min, it skips to the next word in the text file and displays that - but in doing so, it makes the application active again which takes the focus off wateva application i am using at the time. This is...
  2. DotComDV

    Creating a Recordset from a many-to-many access db relationship

    damn it!! all that makes sense, but it still comes up with the error i always get: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. wat this means, i am not sure - wat u have said makes perfect sense and i cannot understand why this comes up!
  3. DotComDV

    Creating a Recordset from a many-to-many access db relationship

    I am confused, how would u so something like that - even using the wizard, it still doesnt make sense! Could u please elaborate? Cheers.
  4. DotComDV

    Creating a Recordset from a many-to-many access db relationship

    thanx, i will try that - sounds good, i will let u know how it goes when i try it tomorrow (im an aussie and it is 10:30pm) and i am sure as hell not at work at that hour! Cheers, Shane.
  5. DotComDV

    Creating a Recordset from a many-to-many access db relationship

    Hi there, i have an access database, with a many-to-many relationship, consisting of 3 tables: tblStock - About 8 columns, eg. CODE, TITLE, AUTHOR (product details) tblCategories - Number Name tblStockCat - StockRef (linked to CODE in tblStock) CatRef (linked to NUMBER in tblCategories)...
  6. DotComDV

    Inputing multiple values into a linked cell (cross referencing?)

    Thankyou so much, you have cleared everything up for me, i wouldnt have been able to figure that solution without ur help - Cheers! Shane.
  7. DotComDV

    Inputing multiple values into a linked cell (cross referencing?)

    Ok so i think i have got it all worked out now, just to check though, the new table should be filling up with Primary Keys in each column right? Eg. tblStockCat StockRef - lots of book codes (PK's from STOCK) doubling up (because they belong to more than one category) CatRef - lots of...
  8. DotComDV

    Inputing multiple values into a linked cell (cross referencing?)

    Thanx for the speedy reply! Everything make sense now, thanx a lot, but i have one question... what is a FK? You used it in this context: "StockRef: Joint PrimeKey and also FK pointing to PK in STOCK" I was a little confused by what was needed to be done here. Other than that minor...
  9. DotComDV

    Inputing multiple values into a linked cell (cross referencing?)

    Help! I have an Access database, getting ready for use with a website. I have 2 tables set out as follows: STOCK (Lots of columns, but the one i have linked is called CAT) Categories CatNo CatName I have created a one-to-many relationship between CAT in STOCK and CatNo in Categories so i can...

Part and Inventory Search

Back
Top