Search results

missing menu items I 'inherited' a database that does that. The previous programmer set it up to limit the users access. I hope that I can explain this so it makes sense. First, to get into it, try PF11 to get past the menus and into the tables. Second, look for either a macro in the...

Maybe I am making this too simple, but isn't rank = 6 - [Primetot]? 5 to 1 4 to 2 3 to 3 etc. At least, that is what it looks like from the data you listed. However, I think all you need to do is sort by Primetot in Descending order. Then, all of your 5's are listed first, your 4's are...

Not sure if this has anything to do with the data being SQL, since I have not worked with a database that way. There are others who have. I suggest that you end this post here in the General folder and start a new one in the SQL folder. Just note that you started it in the wrong folder. Good...

Look for Update Query. Also, give some thought to how you want to round off the result. There should be posts you can search for both of these topics.

IMHO Moderators: Jon, if you feel you need them, then I support the idea to bring on a few to see how it goes. I caution you to not just pick them based solely on time zone coverage, else you could run into the problems mentioned by the other forum Admin and Moderators. (Admins and...

probably query Check your criteria for your query carefully, probably one of them lists the 'duplicate' field name without listing the table or query from which you want to limit the data. You can re-build the criteria if necessary. If that is all clear, then check the report sorting and...

documentation Been there. Here is what I did: First, tackle the technical side. Print each form (selected record only) and make notes on the print-out of what table or query supplies the data. Print the relationships and note relationships (one to one, one to many, Referential Integrity...

memory error I don't know the history, but here are a few suggestions based on my experience. Try reinstalling Access, especially if you can get into the database and run the report fine from another machine. Check virtual memory, mine is set to about 100Mb each for C and D (local...

unmatched query Use an Unmatched Query to give you a list of records that don't match up. For a one-to-many relationship, I usually list the many side. Most often, these become Orphan records -- meaning they don't have a Parent Record on the one side on which to be matched. Unfortunately...

assign auto num You could also have copied JUST your table layout, added the auto num field to the new table, and then run an append query to bring in your original data -- Access would have created the data for the auto num field.

Round to nearest penny Here's an example using two fields [quantity] and [rate], where I needed to round to the nearest penny for a price: Int(([quantity]*[rate]*100)+0.5)/100 HTH

benefits of autonumber primary key I just finished converting a few databases from Approach to Access with many to many relationships. For the junction table, I could have used the primary auto-number key from one combined with the primary auto-number key of another as my multi-field primary...

powerpoint? Have you thought about using Microsoft Powerpoint? It comes with MS Office, so you probably already have it. We have used it here for presentations. HTH

import thoughts How sure are you that it is a Paradox database? My first suggestion is to try dBase III or dBaseIV, maybe the files were stored with an extension of .db instead of .dbf. The other thought is to see if you have an older version of Access, which may import your older Paradox...

boblarson: Um, thanks for the reply -- but if you read my first post again, you will see that the tabs in the form were working properly. rich: Thanks! I changed it to requery the item in the sub-form (actually, I requery an item in each of two sub-forms). That worked like a charm. But, it...

Thanks to this forum, I have learned what cascading combo boxes are and how to set them up. I have at least three databases with them. I checked all 79 posts for cascading combo boxes, to no avail. Now, here is the problem that I am having: After I pick data for the first combo box, it...

import data If you can, I recommend you import the data rather than link to the data. You probably need to have a unique key in your imported data and your field names are all truncated to 10 characters, so check on those. Also, don't forget that Access does not import totals, which DBaseIV...

I have a database of vendors, each vendor could supply more than one product. I need to be able to allow the user to find the data they want (say, all coffee vendors), and then export the names and addresses of the vendors so the user can do a mail merge. I know that I can create a form with...

I just tried to connect two tables without primary keys, and got your error message, the relationship was indeterminate. After I changed a field to be the primary key in the parent database, the relationship now said one-to-many and I could try to enforce referential integrity. To sum up...

Does your projects table have a unique index? What field ties the two tables together and what kind of field is it?