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!

Search results for query: *

  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...
  16. PamelaG

    I'm out of my depth! Check register...table or query or?

    Good going, Gus! This is going to be super-obvious stuff to you eventually, so hang in there! Pamela http://www.accessinsight.com
  17. PamelaG

    I'm out of my depth! Check register...table or query or?

    Hi Gus! Sounds good! Except that you are about to head down the same road again if you have separated Payees and Payers into two tables. If you think about that for a minute, and consider that a Payee can ALSO be a Payer, I think you'll see what you need to do! PamelaG...
  18. PamelaG

    how to make an executable file for microsoft access database

    Hi Robi! As Rob points out, the Microsoft solution to distributing MS application-generated files to non-Office users is the "viewer" concept -- limited functionality versions of the applications. Essentially, the user installs the viewer and can then view or use the file without...
  19. PamelaG

    I'm out of my depth! Check register...table or query or?

    Just to clarify, yes, all checks AND deposits AND transfers etc. will go into that tblTransactions. And then, as you said, you can print out the register grouping by date, month, type etc. This is a common structural problem people run into. Two things appear to be different and therefore...
  20. PamelaG

    Displaying absolute value

    Just to add to what Joe has responded -- remember that a format only changes the way things look, not the actual stored values. For example, I can change a date's format to look like this: 6/12/01 or this: June 12, 2001 and so on. Nothing, however, has changed in the underlying data when I did...

Part and Inventory Search

Back
Top