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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by montrose

  1. montrose

    System Restore after wipe-out of 2000 for 2003?

    I recently upgraded to Office 2003 pro, and told it to get rid of 2000. Realized too late that some programs (such as FMS Develper Suite) do not yet include the components to work with 2003 version-single compnent ugrades are just too expensive. Speed Ferret has not yet released a new version...
  2. montrose

    PCAnywhere 11 Windows XP Slow!

    Windows 2000, rplaced pcAnywhere 105. qith 11.0. SLOW, fuzzy painting of screens, scrren too big, even with screen scaling. Could not get drop down arrows to work in MS Access program, nothing on Symantec site about this. Gave up and un-installed 11.0, went back to 10.5 and wokrs like a...
  3. montrose

    How to Increase number of menu items in a switchboard?

    janetlyn, Catching up on tek-tips after being away for a while. Presuming you found this thread doing a search-glad it was helpful! montrose Learn what you can and share what you know.
  4. montrose

    Table/PrimaryKey/Relationship Help for Inner City School

    sailorripley, It doesn't appear that you've got your entities and attributes clearly defined. For example, your tblStudentInfo. You stated "Because we have open enrollment new students are enrolled into courses at any given day or time." Yet you have not allowed for the student's...
  5. montrose

    How should I handle a customer name being company or individual

    Dean, Glad you found it helpful. I think it's a good basic design. Best of luck, Montrose Learn what you can and share what you know.
  6. montrose

    How should I handle a customer name being company or individual

    Dean, You're 'sub-classing entities'. Here's an interesting example that may addrress your needs. http://www.mvps.org/access/tables/tbl0013.htm HTH, Montrose Learn what you can and share what you know.
  7. montrose

    How to manage many clients??

    carmo, Go to http://www.granite.ab.ca/access/autofe.htm Learn what you can and share what you know.
  8. montrose

    Appearing Relationship Tables

    Ben Dalziel, They are, indeed there because of your queries-Access will make these 'indirect relationships'. If you don't want to see them just click on the button "Show Direct Relationships". Montrose Learn what you can and share what you know.
  9. montrose

    MSysCompactError

    SG, I think you've got corruption in your database. This site http://www.granite.ab.ca/access/corruptmdbs.htm will give you more info. HTH, Montrose Learn what you can and share what you know.
  10. montrose

    Many to Many Relationship

    Blue Monkey, Glad you've got it going well. Not sure if I'm following your last question?? A comobo box usually allows the user to see a list of choices and pick what they need. If you've got it bound to a field, then what has been selected is then entered into that bound field. The source...
  11. montrose

    Many to Many Relationship

    Blue Monkey, In the combo box properties, Data Tab, set the Bound Column to 1 (one). On the Format Tab, set the Column Widths property to 0; 1.5. The use of the 0 (zero) for the first column width in essence tells Access to 'hide' that column and your actual data in column 2 (I just picked 1...
  12. montrose

    Many to Many Relationship

    Blue Monkey, Could be just a one-to-many relationship. tblPictures PictureID (Primary key, Autonumber) (One side of 1:N relationahip) PictureName tblPictureDetails DetailID (Primary key, Autonumber) PictureID (Foreign key from tblPictures) (Many side of 1:N relationship) Category (Comes...
  13. montrose

    Can't link subform and mainform

    Nathan, Glad you got it to work. Will work anytime you have a one-to-many relationship. Best of luck in your future 'developing'!! Montrose Learn what you can and share what you know.
  14. montrose

    Can't link subform and mainform

    Nathan, If you have this set up as a one-to-many with cascade updates, you can just base your contractor form on the contractor tbl, and the subform on the job details tbl. Do your contractor form first. Make your job details subform. Then put your job details subform onto the contractors...
  15. montrose

    How to Increase Switchboard Options

    H. Jessen, See if this thread, "How to Increase number of menu items in a switchboard?" thread700-174910 helps. Montrose Learn what you can and share what you know.
See more

Part and Inventory Search

Back
Top