Search results

Anyone know why the following would happen: I have a form that is linked to a single table. For some reason some controls populate one line in the form and others populate another line. Each time I complete the form it creats two records with some data in one row and other data in another row.

I'm creating a database that keeps a track of questions and scores. The questions in the database need to be dynamic and are changed frequently. I have a scorecard table which keeps a record of scores and the applicable question at the time the record was saved. I need to do this because in 6...

Same problem Hi I'm having the same problem. I have the following code behind a command button: Private Sub cmdUpdate1_Click() DoCmd.Close DoCmd.OpenForm "frmUpdateQuestion1" End Sub When i click the button I receive the following error msg: "The expression On Click you entered as the...

I can't get my head around this, i want to add up a set of values from different text boxes. Currently i'm using the following in the default value property of the text box which I want to display the total: =txt1 + txt2 txt1 contains value 50 txt2 contains value 40 The result displays 5040...

Many thanks this works great

I want to add to values based on if yes or no is selected in an option group. My thinking is to use DSUM. When 'yes' is selected I want to grab a value from one field and add it to a value in another field giving a running total. I am currently using the following code but it throws back an...

Hi Thanks for the advice on using the DLOOKUP function. I have tried implementing however I receive: #Error in the text box. Ihave entered the following into the control soure property of the text box: =DLookUp(" [Q1]"," [tblQ1]") I've tried an number of variations with no luck. Am I doing...

Thanks Bob. I think maybe I need to look at doing this a different way. The problem is I don't want to use a listbox or combo box. I either want to use a text box or better still (though i don't think it's possible) a label. Basically I have a question table and I want to display the question to...

Thanks. So am i thinking correctly, I should implement the lookup on my form? I have tried this however within the properties of a text box there is nowhere to enter a query. I just want to get the text box to show the value of a record in a different table

I'm sure this one is out there but I just can't find it.... I have created my tables and selected a lookup from one table to another. The value displays ok however in a combo box. How can I change so the value is displayed in either a text box or better still as a label? I have right-clicked...

Many thanks for your reply John. I have attached a copy of the relationships though i can't help thinking it's incorrect. Also if i am to store all questions and scores in one table how would i define a key?

Hi I am trying to create a question and answer database that will hold agent scores for future reference. My idea is that I will have the following tables: • Team • Marker • Agent • Scorecard • Question & Score I want to have a Scorecard form which the marker completes based on the agents...

I have developed a form and used code to disable the append messages Access displays the user such as: 'You are about to append data, do you want to continue'. The form works great on my machine and I don't see the messages. When i use it on another machine the messages appear?? Please help.

Thanks that worked fine!

Have a number of tick boxes on different forms. When the form is opened the tick box appears to be greyed out however it is enabled. Is there any way that these tick boxes can appear enabled???

I have four seperate databases each of identical structure. Each database has an option which exports the data to a Excel spreadsheet. I want each database to dump data to the same spreadsheet. I have used the code below and this works however when i execute on a different database the data in...

Sounds good This sounds logical but im unsure how to implement would this be part of an Insert statement?

I have searched the forum and just can't find an answer. I'm hoping someone can point me in the right direction. I have a main form with a combo box that links to a table called tblSTC. There are however hundreds of records to choose from. To make the serach more simple for the user there is a...

I have tried this and it works for me. How can you use the same code to populate a text box, say for instance if the customer only has one product associated with them. A text box doesn't have a row source option in its properties??

I have a form with a combo box this combo box looks up values in my STC table. The STC table has two fields STC & Resolver and each STC has a unique associated Resolver. What i want to happen is after the user has selected the STC from the combo box on the form the associated Resolver be...