Full Version: Access Tables + Relationships
UtterAccess Forums > Microsoft® Access > Access Tables + Relationships
Pages: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69
  1. Leading Zeros in Primary Key Field (8 replies)
  2. Database for daily employee attendence sign-in - basic design ? (18 replies)
  3. count total records in table using VB (4 replies)
  4. Converting 2.0 to 2002: nulltozero function error (9 replies)
  5. Relationship dilemma! (28 replies)
  6. How do you require a field to have some type of data? (17 replies)
  7. database final product (.mdb or .exe?) (16 replies)
  8. CD Collection database - VERY basic design question! (40 replies)
  9. Chaning the path to linked tables with ADO! (10 replies)
  10. This makes no sense (21 replies)
  11. My relationship joins are invisible. (19 replies)
  12. Hardcode connect string to Oracle table through Access (9 replies)
  13. Too many indexes on table = can't make rships (12 replies)
  14. Trouble designing (25 replies)
  15. Controlling Many to Many Relationships (9 replies)
  16. Splitting first and last name from one name field (18 replies)
  17. DCount + SQL (10 replies)
  18. Error in sending email from access 2000 (6 replies)
  19. Returning (and testing) a table's field names (11 replies)
  20. Adding "0" to a 4 digit ZIP Code (6 replies)
  21. Is my database structure ok ? (27 replies)
  22. What would you choose? (12 replies)
  23. setting/resetting default record in many table (18 replies)
  24. time of day incorrect in Access - reverts to AM instead of PM fo (33 replies)
  25. Normalization checkup (12 replies)
  26. Concatenating a Field (19 replies)
  27. Parse Name Field (3 replies)
  28. Why use passwords? (11 replies)
  29. help: Can't save property changes for linked tables (9 replies)
  30. Back color number of standard Command Button (10 replies)
  31. Creating an Editable Timeline with Default Values (14 replies)
  32. Inserting bullets in text/memo field (6 replies)
  33. Deduct item qty from orders table into inventory table for same (9 replies)
  34. One very long table! (11 replies)
  35. Is select case best? (46 replies)
  36. Combo Box Baloon Help popup (12 replies)
  37. Importing Tables AND subdatasheets (12 replies)
  38. "Too Many Fields Defined" (17 replies)
  39. 1500+ tables (15 replies)
  40. Securing Database Design (8 replies)
  41. splitting a text field (35 replies)
  42. Start autonumber at something other than 1 (11 replies)
  43. The Value You Entered isn't Valid for this Field (14 replies)
  44. Turn off dotted lines appearing inside a clicked command button? (10 replies)
  45. Any "OnMouseMove" pointers? (8 replies)
  46. Filtering Field With Multiple Criteria (16 replies)
  47. Production tracking (5 replies)
  48. Using Scroll Wheel in Memo field (4 replies)
  49. Simple Relationship (12 replies)
  50. Unknown function 'Date' validation expression (4 replies)
  51. Data Validation rule to stop dates after a certain date being en (7 replies)
  52. making my first database.. (30 replies)
  53. Would Soundex Help to Avoid Duplicates (8 replies)
  54. Multiple Fields (21 replies)
  55. Please Help. Replacing one character for another in a table. (9 replies)
  56. Exporting 2 table into 1 Text File Access 2002 (8 replies)
  57. Many to One Relationships: I think (25 replies)
  58. Null value in an auto-number field (2 replies)
  59. Send attachment via Lotus Notes to recipients in table. (14 replies)
  60. How to make check boxes hide/show a number inside a field... (15 replies)
  61. Email ID creation - conti.. (13 replies)
  62. Supress Standard Error Message and Replace with Custom (6 replies)
  63. composite keys? (9 replies)
  64. Design Questions from a neophyte! (13 replies)
  65. Populate "bridge" table? (2 replies)
  66. Is it possible to create "Reverse Pivot Table" view on a table? (17 replies)
  67. Adding a field and Counting Help. (24 replies)
  68. Adding zero in front of number in field (2 replies)
  69. Repeating Appointments (9 replies)
  70. Character count in a field (13 replies)
  71. Autonumber Incrementing (16 replies)
  72. Splitting first and last name from one name field (27 replies)
  73. Complicated Relationship/Join (14 replies)
  74. No One Responds and I'm DESPERATE! (31 replies)
  75. How to copy certain fields to another table ? (20 replies)
  76. When should I denormalize? (7 replies)
  77. Database Design (Training Tracking DB) (5 replies)
  78. Dealing with "double-barrelled" family names (9 replies)
  79. Your thoughts on a Data Import Design (13 replies)
  80. Recursive relationship (7 replies)
  81. DB Normalization (17 replies)
  82. Warning about duplicate values in text fields: Efficient? (9 replies)
  83. Acess Tables and listing their fields (10 replies)
  84. Filtered Combo`s (13 replies)
  85. Help please! I'm having trouble with changing pay rates! (17 replies)
  86. Printing a mail merge document with a command button (11 replies)
  87. find name of linked table if different (23 replies)
  88. Bytes, Megabytes, Kilobytes.....confusing!!! (13 replies)
  89. insert a carriage return into a memo field using VB (3 replies)
  90. Unary relationship - parent / child table (5 replies)
  91. Adding Fields with Text (21 replies)
  92. Problem using RST to check two fields in one table (14 replies)
  93. count how many digits a TEXT/MEMO/NUMBER field has (13 replies)
  94. Help with converting Date info (15 replies)
  95. Remove everything after / (9 replies)
  96. Changing field captions using ADO..? (11 replies)
  97. Auto entry of data to another Table...can this be done? (17 replies)
  98. How do I Cascade these Combos? (17 replies)
  99. Output sql to table or text file (8 replies)
  100. Answer for Wolfegirl (13 replies)
  101. Export Access Table to Excel Workbook (4 replies)
  102. textbox references (10 replies)
  103. Code Help...Need to reference Word template NOT text file (12 replies)
  104. DB Design problem (8 replies)
  105. Triple keys, good or bad? (11 replies)
  106. Incrementing customised number in Access prefing with letters!! (24 replies)
  107. AutoNumber Primary Key in MS Access projects (22 replies)
  108. Table Structure (12 replies)
  109. how to prevent user from changing the field size? (12 replies)
  110. need help to strip commas out of a text field to prepare for exp (11 replies)
  111. Cannot add record(s); join key of table ..... (16 replies)
  112. relationships (17 replies)
  113. cut and paste from one table to another (5 replies)
  114. Undefined Function 'left' in expression (3 replies)
  115. subtracting fields (45 replies)
  116. Creating a Table from a search result (15 replies)
  117. Table structure for VB code (15 replies)
  118. Retrieving values from a List Box (19 replies)
  119. Access Runtime Error Messgae '-2147023897 (800703e7)' (7 replies)
  120. Designing a database for work (18 replies)
  121. Problems with RecordsGoToNew (19 replies)
  122. Golf League Database (5 replies)
  123. Reseting the Autonumber back to one (19 replies)
  124. Problem with code (20 replies)
  125. Sort, Subsort then assign value to field in table 001,002,etc (16 replies)
  126. List Box with multiple selected items - send to a data entry for (7 replies)
  127. Asset Tracking (12 replies)
  128. Making Folders based on LastName FirstName (18 replies)
  129. Bypass Prompt on delete table (2 replies)
  130. Open Table w/ Combo Box (21 replies)
  131. Transfertext problem (5 replies)
  132. Hopefully a simple database question (22 replies)
  133. need urgent help to do calculations (16 replies)
  134. Working with FoxPro 2.5 tables (11 replies)
  135. Control cannot be edited; it's bound to unknown field/expression (2 replies)
  136. SQL question (13 replies)
  137. Cutomising Autonumber in Access and incrementing at the same tim (41 replies)
  138. table field caption property (8 replies)
  139. Multiple Databases - your thoughts (11 replies)
  140. "linking" two fields (15 replies)
  141. Auto Number for large tables (7 replies)
  142. Need Data Entry Example (16 replies)
  143. Set Focus when field not completed (20 replies)
  144. Subtracting 2 datetime values (13 replies)
  145. Refresh Auto Number (7 replies)
  146. Question on Setup of tables (13 replies)
  147. Force move to next field (18 replies)
  148. Date Field Calculations (14 replies)
  149. ORA-01013 error when linking tables in Access (1 reply)
  150. Employee ID - Text or Number Field? (10 replies)
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.