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

    upload image to access (need help)

    library database for my school" Hope your not a student. This isn't a site for students. You do not store images in an Access database. It'll extremely bloat the database. An image, at least, is a mb. Do the math. Here are two references: faq181-279 How to display an image from a folder in a...
  2. fneily

    Project Management DB - Maintain Milestones

    Ah yes, Project. Forgot about that. You're right. Still waiting for clarification.
  3. fneily

    Why use Excel?

    Interesting. Having for the past 11 years teaching in college and in businesses, most "administrative assistants" know Word. So do their bosses. So anytime they need a table, they create one in Word. Then try to do things like sort/filter. They also do their math in Word. Reason - nobody ever...
  4. fneily

    Project Management DB - Maintain Milestones

    It seemed to me that those number of days that are to be added are arbitrary and he won't know those until, let's say, minutes before he does the update. And they'll be different fot every project. Let's say something really bad happens and all the projects are delayed with their own different...
  5. fneily

    Project Management DB - Maintain Milestones

    Got confused with "milestones for each project are based off the release date." Can you link to the IT table from your Access database? How do you pull in the original dates?
  6. fneily

    Project Management DB - Maintain Milestones

    Since the milestones are calculated from the release date, then you'd only store one date and calculate the rest in a query/form/report. If a project is delayed, you'd just add the appropriate amount of time to the calculations. You'd need to add a field to track the amount of time delay for...
  7. fneily

    Create a many-to-many relations table

    If you're new to Access, I'd suggest you buy at least three basic Access books and take some courses at your local community college before trying to create your own database. AutID, ArtID, PubID are primary keys of their associated tables. They must be there. They assure no duplicate records...
  8. fneily

    Create a many-to-many relations table

    Better posted in:Microsoft: Access Tables and Relationships Also some reading: Fundamentals of Relational Database Design http://r937.com/relational.html You could have more then one author on an article. You'd have three main tables: tblAuthor AutID Primary Key Fname Lname Address etc...
  9. fneily

    Can I have a calculated field in a table?

    Yes, it is possible. But bad table design. You don't store calculated fields in tables because it's against normalization. Here's a beginner course on normalization: Fundamentals of Relational Database Design http://r937.com/relational.html
  10. fneily

    Forms and Tabbing Automatically

    You created a document, not a form. You wouldn't use the table format. See: faq68-5299 Forms allow user input to only places you want. The rest of the document is protected so there would be no interaction in such places as the title/item heading.
  11. fneily

    Many-to-Many relation

    IF that's all the data you are storing, I'll buy it. BUT if you are going to add fields, for example: supplier part cost or manufacturer part or distributor part cost or purchaser date price etc. etc. then you can not use that table. Adding any fields to it will make it non-normalized. So...
  12. fneily

    Many-to-Many relation

    another question: what is the meaning of SuppID, ManID, DistID, and CRID?" Those are primary keys of their respective tables. All Access tables have primary keys. Oops. Noticed a typo. In tblCompanyInfo, it should be CompanyID not CompID. My fault. SupplierID, ManufacturerID...
  13. fneily

    Many-to-Many relation

    tblCompanyInfo ---> tblSupplier <---- tblCompanyInfo CompanyID -----> CompanyID SupplierID <---- CompanyID Same scenario for Distributers and Manufacturers. "because it have the same fields". You have different Categories - Suppliers, Distributers, Manufacturers...
  14. fneily

    List Box conditional count

    Something like: Private Sub List7_DblClick(Cancel As Integer) Dim listrs As Integer Dim listsum As Integer listrs = Me![List7].ListCount x = 1 Do If Me![List7].Column(2,x) = 1 Then listsum = listsum + 1 x = x + 1 Else x= x+1 End IF Loop Until x = listrs Me![Text9].Value = listsum End Sub You...
  15. fneily

    Many-to-Many relation

    Have you seen: Fundamentals of Relational Database Design http://r937.com/relational.html Can a supplier be a manufacturer or a distributer? Or can any other combination be made? You could have one main table: tblCompanyInfo CompID Primary Key Name Address etc. Now have four category tables...
  16. fneily

    Build a PP Pres. From Multi Files

    Are you running these manually or automatically? If manually, you can create invisible hyperlinks. Click on the Rectangle button and draw a rectangle. While rectangle is selected, change the Fill to No Fill and Line Color to No Line using the appropriate buttons. Right click the rectangle...
  17. fneily

    Proper table design for proper queries, how to normalize

    See that. When you're not the primary developer, like I, then I forgot you populated the game table with future matches. I was just thinking you populated on the fly, which, of course, is dumb. Oh well. Nice creative idea to use the score field for played on not played. Good call. After you get...
  18. fneily

    Make table query requires deleting relationship

    Also, make table queries bloat the size of an Access database.
  19. fneily

    Proper table design for proper queries, how to normalize

    First, let me congratulate you on trying to keep to the rules of normalization. Most people wouldn't recognize that the score is a total of the goals and would want to store it. Take the query that produces: game_id team_name score 1 Dortmund 3 1 Portsmouth 2 2...
  20. fneily

    Query?-one date 3 fields checked within a table

    reporting-needed-date1 reporting-needed-2nd-time-date2 reporting-needed-2nd-time-date3 "different names". No, they have the same name - date, date, date. So should be three records, not fields. Again, you have a category laid out horizontally. Thus your problem. You can do a union query on...

Part and Inventory Search

Back
Top