Search results for query: *

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

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

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

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

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?

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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