Recent content by PamelaG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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