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 Rhinorhino 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 PamelaG

  1. PamelaG

    Database design help.

    Hi! Sorry to be late responding -- I was away from my office all day... You're welcome! Pamela
  2. PamelaG

    Table accepting duplicate entries in primary key field

    Hi Elviajero! To prevent duplicates in a field, set the indexed property (bottom of the design screen) to No duplicates. Pamela http://www.accessinsight.com
  3. PamelaG

    Database design help.

    Hi! You said: We have Directors that manage suppliers who in turn have products. Simple structure. There are tons of exceptions. =========== tblDirectors, tblProducts, tblSuppliers ============= You said: Directors can have products assigned without suppliers, however, they still need to be...
  4. PamelaG

    Re-establishing Existing Relationship

    And just to add to that... The thing that gets the cascading update is the primary key value. This won't work if the primary key is an autonumber. Let us know if this is not what you needed! Pamela http://www.accessinsight.com
  5. PamelaG

    Database design help.

    Hi! Hey, try me out with your REAL data! That will probably be more productive in the long run. Give me a brief description of the scenario and then the table listing. Believe me, I've seen it all! As for the wizards, if it were in my power, I would disable that functionality permanently, but...
  6. PamelaG

    Database design help.

    Hiya! Hey, you're doing great so give yourself a pat on the back! The issue here is what we call "business rules". In fact, you CAN have children without parents! In the relationship window, double-click on a relationship line to see the options. You'll notice that "enforce...
  7. PamelaG

    Change a field to a lookup field without losing info

    Hi Beth! This is a pretty common scenario, so you will want to add this to your bag of tricks! 1. Create a query that shows Names2 and States. 2. Drag a relationship line from the State field in Names2 to the same field in State (this allows the records to match up by the state name). 3...
  8. PamelaG

    How can I set the # of Dps for a field using vb code?

    Hi Cooleen! Yes, you want to set the field size property at the table level to start with! Pamela
  9. PamelaG

    Bound Text box and Tables, Queries and Reports???

    Hi Csegal! If I understand your question correctly, then you have created this new calculated field on a form -- yes? I always recommend that such calculations be done in queries for this very reason. When you locate calculations in forms or reports they cannot be used elsewhere without being...
  10. PamelaG

    Background BMP

    Hi JJ! Larry's suggestion will give you a splash screen, which is maybe what you were looking for? Otherwise, it sounds to me like you are trying to set a background for the database window, which is really not something you need to do! I assume that you are trying to make your user interface a...
  11. PamelaG

    How can I set the # of Dps for a field using vb code?

    Hi 3321! It sounds to me like you are wanting to change the actual storage method of the field periodically. That is not a good idea! You need to think about what sort of data is going to be stored in the field and then pick the appropriate field size for the number. The field size property in...
  12. PamelaG

    Combobox help!!!!!!!!!!!!!!!! (second try)

    Hi tlaksh! It sounds like you want to do a Find function to look at a record. Just build your form to show the data, then add a Find combo box. To add the Find box, start by making sure the wizard button at the top of the toolbox is turned on, then click on the combobox tool. Drop a combobox...
  13. PamelaG

    Access Lookup Field

    Hi Delinda! As you move into data storage in relational databases as opposed to spreadsheets, there are some adjustments you have to make in how you know to do things! What Joe is telling you is that you want to just relate the two records, not copy the data from one record into another. Yes...
  14. PamelaG

    Need a little direction

    Hi! A good reference book is the DDC Access 2000 reference guide. I give these to all of my students and clients for all the Office apps. You can get these at any bookstore (they may have to order them) or directly from the publisher: http://www.ddcpub.com/htmlnew/results3.asp?id=638 This is...
  15. PamelaG

    address from db to Word

    Hi Alan! Actually, there are two parts to what you are trying to do: 1. select a record for merging 2. merge specific fields in the selected record This should be pretty easy if your tables are constructed correctly. I am assuming that you already have a table that looks something like this...
See more

Part and Inventory Search

Back
Top