Search results

Can you show how you relate the separate tables such as through a screen shot of your relationship window? Once the relationships are defined, then you would create queries to bring the information together.

It was difficult to read your schema, I assume you tried to format it but it did not get carried over when you actually posted the thread. This is what I was able to make of it. Could you please confirm whether the following is correct? VoterInfo -VoterIDTxtPK -FirstNameTxt -LastNameTxt...

The tblResponses does not show a foreign key field to the tblVoters_Promotion, just having the voterID field is not enough since the response is dependent upon both the voter AND the promotion. tblResponses -ResponseID primary key, autonumber -fkVoter_PromotionID foreign key to...

You should be able to use the InStr() function in conjunction with the len() function to test for the presence of the decimal point. If so, adjust the value back to having only two digits after the decimal point. The code would look something like this: If InStr(Me.amount, ".") <> 0 And...

I would check your security settings to make sure that running code is not restricted. Also, if you are doing a FE/BE, each user should put a copy of the FE file on their local harddrives.

Since I cannot see all of the fields, I'll just have to give you some general guidance. The sales information will need to be obtained through the series of invoice tables. The costs will have to come through the purchase order related tables. The join will have to be made via the part number...

Many posters just post a screenshot of the relationship window (database tools-->relationships).

For some reason I could not download your database. You might have to zip it and then post the zipped file. You said that you only have 1 table. Based on your fields indicated above, you probably will need to separate distinct data into multiple tables: one for departments, one for people...

You're welcome. Glad to help out.

The calculations you mention can be done in the report design itself. What you have to worry about is extracting the data necessary to do those calculations. The data resides in tables in the back end file. You would use a query to extract that data. You would base the report on that query...

I do not see a particular issue with the code itself. Is the database file stored in a trusted location as defined in Access (file-->options-->trust center--Trust center settings-->trusted locations)? If the database file is not in a defined trusted location, no code will execute. I think the...

Since this is an assignment, I will just provide some guidance. First, it sounds like a promotion can have many questions so that describes a one-to-many relationship. I will assume that to each question, there is only 1 response. Now as to the responses, since the responses to a...

I'm still not clear as to what you want to have happen if someone enters a decimal point & characters after it. Could you please explain a little further?

I'm confused by your code. You said that amount was text; if so, then your code would have to look like this Private Sub btn1_Click() Amount.SetFocus If Amount > "0" Then Amount = Amount & "1" Else Amount = "1" End If btnEnterItem.Enabled = True btn1.SetFocus End Sub Also, this line...

Typically a frame is referring to the option group (in which your check buttons are located), so you will need to check the name of that option group and verify that it is indeed named frame0. By the way, if the option group and the command button (command12) are on the same form, you do not...

What I would probably do is create a query that gets the unique managerIDs: query name: qryManagerIDs SELECT DISTINCT tblSalesReps.ManagerID FROM tblSalesReps; Create another query that joins the above query back to the sales rep table and join the managerID to the salesrepID query name...

What is in the managerID field for those sales reps who are also managers?

I looked in the FAQ, but could not find anything. I would guess that it would be in the Thread Tool menu (located just above the first post on the page)

You can do it either way. The combo wizard will step you through the process--I do it this way. I've attached a screen shot of the specific wizard step where you assign the value of the combo box to the field (its the second option & you need to specify the corresponding field)

You need to use it to bind it to the applicable field in the junction table. For example, if you combo box is based on the vehicle table, then the combo box must be bound to the unitID field of the hire table.