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 derfloh 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: *

  • Users: Olaf4
  • Order by date
  1. Olaf4

    Please help with inventory project...

    I suggest two ways to do that. Way 1 – One Database in one file Create a table for Categories Create a table for Suppliers Create a table for Authors Create a table for Locations Create a big table for Items This last table has to have all fields for every detail of each item. Later in your...
  2. Olaf4

    Normalisation Philosophies

    I agree completely with Golom and lespaul. I would do this: a.Create a new T/F field in the main table: SpecialCase. b.Create the other fields you need in the main table. c.In the form, make all these fields invisible, but the T/F field. That way you do not see them all the time. Then when you...
  3. Olaf4

    How to fill in blank in a form

    Do this: 1. Create a new query. 2. Put your table you need to update 3. Take the field you need to update 4. In the criteria row, write: Is Null 5. Go to the toolbar and select Update query 6. In the Update To row put the number: 0 7. Now run the query (with the ! icon in the toolbar). You will...
  4. Olaf4

    Put Access on a Diet?

    Questions. How many forms do you have? How many reports? In others words, how many objects does your db have? And how many images?
  5. Olaf4

    Video System

    I have a question. In the real world do you keep this particular film separated in three groups (by purchase price) or they are mixed? If they are mixed, how do you know the 4 films you are selling belong to the first group?
  6. Olaf4

    Video System

    No. That is not solve the problem. For the first question, I suggest do this. 1. Create a table for Formats. Looks like FormatID, Format (to put DVD, VHS, etc.) 2. Create a table for the film. FilmID, Title, etc. Like your first table above. 3. Create a third table FormatReg. Looks like FilmID...
  7. Olaf4

    Code for pulling records based on "last weeks" date

    Hi! I hope this solve your problem. In your query add a field: LastWeek: DatePart("ww",[your field Date]), and in the criteria of this field put this: =DatePart("ww",Date())-1. That’s it.
  8. Olaf4

    Can't edit results of query

    You did well. I'm glad you're happy now. Your two first queries were correct. But the trick (suggested by dhookom & cheerio) was not to join them (like you did) but nest them (put one inside the other one). Join them is like compare two tables and you cannot make changes. Nest them acts like a...
  9. Olaf4

    Can't edit results of query

    I did it. Perfect!!! What dhookom and cheerio said it is worth a star! Do this. 1. Create a new query. Put the Student table and create the field for the Name. (It will look like your qsel#2) 2. Now see this. It is your query a little modified: In ((SELECT DISTINCT SumAcadStudents.SSN FROM...
  10. Olaf4

    Changing field from a number to an incrementing auotnumber

    1. Create a new table with the same fields the old one. 2. In the new table, add a field with Autonumber datatype. 3. Save it but do not open it nor write anything in there. 4. Create a select query with all fields of the old table. 5. Then, convert that query in append query and choose the new...
  11. Olaf4

    add ins

    Ok. Again. You have to uninstall Office completely. Then Re-install it. Choose the option "Custom" or "Customize" (I don't remember), then when you see the Office Application-tree (each application has a little arrow), choose from the most up level "Run all from my Computer" to get installed all...
  12. Olaf4

    Changing field from a number to an incrementing auotnumber

    Mitchy, You cannot convert a number field to autonumber field. You have to create another field with autonumber data type. Add a new field and the numbers to existing records will be added automatically. Same to new ones.
  13. Olaf4

    Need advice with relationships

    Thanks BnPMike. I thought I was missing something new. It's OK your point. But if people don't understand relationships, they cannot build a very good application and can lose data in orphan records. Orphan records can lead to inaccurate results. Thanks again. If in the future you know something...
  14. Olaf4

    Need advice with relationships

    This question is for BNPMike. Could you please give me a very good reason or reasons to not to use o worry about tables relationship? Thanks
  15. Olaf4

    add ins

    Hi! Go to Tools->Database Utilities->Link Table Manager. If you don't see it, probably you have not installed MS Access completely. Then, You should install it again and choose the option "Complete". Olaf4

Part and Inventory Search

Back
Top