Search results

The way you have table 2 setup would be the proper normalized way. Setting it up to look like table 1....well that's where the problem comes in. Me personally, I would have a listbox on the employee record and just list the privilages that they have. Or are you trying to display the data like...

Yes, that is possible. First though, I would clean up your tables. You use some reserved words (Code for one). Also, I would take out any spaces in the field/table/query/form names. They will cause heartache later on. Second, none of your tables have primary keys assigned to them. Not good. Each...

It's your Child/Parent Link fields. When you link a subform to a form, you can only link 1 field. This is what you have: Link Parent Field: Full Name;Employee ID;Curr Hourly Rate - Actual Link Child Field: Full Name;Employee ID;Hourly Rate Pick one. I would assume that it should be Employee...

I dont have A2007, so I cant open it up. Can you save it as an MDB file?

It would REALLY help if you posted at least the db with the tables, forms and queries that you are having problems with.

Can you post the db? You can remove any sensitive data if you want (Or leave some dummy data). if using A2007, save it as a mdb file. Also, you can compact and repair as well as zip the file up if the size is too big.

is the subform linked correctly to the main form? I am assuming that your main form contains data on a person. The subform contains details about that person?

A bit more information would be helpful. Is the form bound to the queries? What happens when you run just the queries?

Here ya go. Simple little db that illustrates a form/subform. Check out Form1. The main form is the Project. There is a text box, a combo box and a command button as well. You can use that to add Inventory Items to the Project. I am assuming that you have a table that stores the ProductID and...

Try removing (MA2007_10.DestCity = [City Municipal Table].DestCity) AND What you are telling it to do is to join the table on both the Destination City AND the Orgininal City. If MA2007_10 doesn't have the DestCity (Which I am assuming it doesn't, else you wouldn't need an update query)...

Are you actually in the VBA editor (clicking on the little box with 3 dots at the end of the field? If you are entering it in just the field, then it will throw an error.

Based on your post, you have what is called a One (Project) to Many (Inventory) Relationship. In that situation, you should be using a Form bound to Projects and a subform bound to Inventory. The subform should be linked via the ProjectID field. Saving duplicate data in multiple tables is a...

*Headdesk* my bad! (Stupid Fridays!)

Well, a couple of them: 1. Set myRecordSet.Fields(3) = should be: myrecordset.fields(3) = 2. you have Wend, but not a With

Add the table with the field you want to change and the table with the new names. Create an INNER JOIN between the two tables using the Old city name. Then update the field on the old city name with the field containing the new city name from the second table. quick example attached edit...

The sql for a query would look something like this: SELECT sum(quantity) as SumOfQuantity, ProductID FROM IncidentDetails GROUP BY ProductID That should sum up the quantity of each unique ProductID in your incident table. You can then use that query along with the table that has your...

Access has some graphing capabilities...I've never had need for it so i'm unfamiliar with it. However, if you want to export sums into Excel, the best bet would be to create a new query with the totals displayed in them. To have the query sum up, click on the Sigma icon (Looks like an...

I misread your orginally post.... The query with the IIF statements shows the permissions, but doesn't put it in the format you wanted. The problem here is that table2 is normalized and table1 isn't. That's where your difficulties are being encountered. To get it to look like Table1, you are...

Well, you could write a query that uses IIF statements. Privilage1: iif([Privilage]=1,"Y","N") Privilage2: iif([Privilage]=2,"Y","N") Privilage3: iif([Privilage]=3,"Y","N") Privilage4: iif([Privilage]=4,"Y","N")

Glad you got it worked out!