Search results

@Mihail i dont see the need for conversions from unit to other unit then grams.

You better leave the sistem date/time? If your aplication is used by more people from different timezones, maybe you will need to know the time that employee was working.each now() is different becouse it should be different. My now is now, at 10:22. I bet your now is later, when you read the...

According to you info, i see it this way: tblProducts and tblUnits. Betwen them a many 2 many relationship. Why? Becouse each product can be saled in many units and the same unit can be used on many products. On the junction table you will have the "g" field.

Re: Access 2007 - Multiple Many 2 Many Relationships I cant see how someone can sugest to avoid many 2 many relationship. This kind of relationship is used when the reality demands it. Keep us informed with your progress. PS: use the "thanks" button when you consider.

Re: Access 2007 - Multiple Many 2 Many Relationships The way i see it: each resource is located on a desk, on a specific building. Each team has acces to a specific resource. Tables needed: Resouce Desk (one 2 many resource) Building (one 2 many desks) Person (many 2 many resource) Team (one 2...

You can insert a field (name it whatever you want) that will have a validation rule (<1000 & >0) and a default value based on the max value. For the default value expresion, i'm sure that someone with vba experience will help you. PS: i dont see the logic for a "reset to 1" option. That means...

My advices: 1. Faculty and Courses should have a "many to many" relationship. That means that you will need a junction table. Why? Becouse a course can be teached on more then one faculty and one faculty can have multiple courses. 2. On the vertical table you have to erase the facultyID field...

@Pat, i understand your idea. But, the poster said "many funds to 1 (employee + account)". Assuming that the account has only one employee, i guess he would've said "many funds to 1 account". The poster's info about funds relationship makes me think the many to many relationship betwen employee...

All i know is that the last thing, the "_", is the placeholder, the carachter that apears before you insert data. The last "0"... i have no idea!

There it is in 2003 version. Check the after update code for text2. You will get the idea and work it for your project.

First of all, the address should be "split" into the smallest parts, each part on a separeted field (street, number, city, state, etc). Back to the problem: i would create a query with the complet address concatenated in a field. Then, the search will be made in a field based on the query, from...

@Television, you welcome. I bet it needs tinkering, i'm a newbie!

@Pat, i think that there is a many to many relationship between employee and account. The one to many relationship is between emp+acc in the one side and found in many side.

You want in the same db to use different schools with specific classes?

You will have to use only the junction table. Try doing it and after that you will see the logic for the forms. PS: use the thanks button if you feel like it! :)

Yes, it makes sense, but you need to redesign your relationships. You will need a 3th table, a junction table. So, you will have tblCompany, tblContacts and tblStatusHistory (or any other name you want). On the tblStatusHistory you will have tblContactsFK, tblCompanyFK, dateofstatuschange...

I have made a basic set of tables and a form (with subform) to insert data. Take a look!

I don't see the need of a database if you will still work in excel. To answer your question, it is possible to import data from excel without deleting the old data. But the risk of errors is huge, becouse the user will work "in the table". Maybe you should concentrate creating the database you...

I always prefer to use multiple tables. And that becouse a few reasons. For more help, i suggest that you attach the form that you use now, the printed one. And some aditional info on every field in it.

Use the query wizard: you will need to use fields Reagent (name/id) and the yes/no. On this second column on the criteria you will define the criteria you want. Then, on the combobox wizard, use the query as source.