Search results

Hi, I am Creating a Access 2007 Database for my Collection Invertory. I want to keep track of Items and produce Reports. There are many tables of which about five tables are for data entries. others are lookup tables. One table namely tblCountryNTypes (pk CountryTypeID auto,MainIndex...

Hi, Pat Hartman, RainLover thanks.:) Pat I had done as suggestion, Electric Rod Icon I meant Index dialog (Dialogue) box. Pat I appreciate you explanation very much, Now I am clear in my mind. Cheers! Note: Agree RL,Practical gives experience Textbook can give all the theoretical...

hi, I have question here please. In my situation junction table will have relation with other table in Db. Also want that junction table will have one and only one record with fk1+fk2. so creating junction table tblTest (testId pk auto, fk1,fk2) should one other index unique via Electric...

And what you do , Where you go when you get Sarcastic Comments ? Gurus, Gods and Expert we bow down ... but hard to leave with those sarcastic comments and attitudes. "You scratch my back I will scratch yours" jumping in and making fun.No doubt leaving forum is easy way out. Salute, and regard...

Thank you very much RainLover appreciate. I am working on it will post it later Date. Basically 1:M and M:M types of tables are let me go through it. Thanks Zubersurati

ok all thanks ..also thanks for teaching me English... no my mother tongue is not English Sir. But looking at screen shop Redundancy cop came. Lot of redundant data in tables..... let me remove and see...till than great day. Thanks and regards to all of you. Oh I see Australia. Zubersurati

Hi Skechin and Rainlover, Would you see the following to first post other post in the thread...Please. I have narrated Tables and relationship I may be right or wrong in Junction table. Love your Comment RainLover .. Yes I played with computer from the time of CPM+, dBase, Delphi If I get...

Hi spikepl, No sir this is not joke. I had made three tables in real life situation. So was trying to see in the relationship by these five tables. I am really sorry if I offended any pros or Experts. I created Three Tables 1. tblCountries (pk CountryID auto,countryName, ..etc) 2...

Hi, Using Access 2007. Learning through Forum and books. I created five Tables tbl1 to tbl5. Have created relationship as attached screen shot. What are Pros and Cans. Are some relationship in screen shot unnecessary ? Thanks in advance Zubersyrati

Hi I am trying but cmbTypes or lstTypes does not populate . will try and comeback.

Thank you very much Isskint . Appreciate very much will try and come back further when addition of tables. will try both Combo box as well as List bx and see which suits .. forms layouts. again Thanks surati

Hi, I am using Access 2007 . Created two tables Namely. tblCountries (Pk CountryID, CountryNames,etc) tblTypes (Pk TypesID,TypeDescrip) then I created Junction table tblCountryNTypes Pk CountryNTypeID, CountryID numeric,TypesID numeric) also in Index created...

Hi, I am new to MS Access 2007. Just started learning, trying to learn Access and VBA as much I can learn on site. Thanks all