Search results

I've just put the following forumla into the cell of an Excel sheet however I got the error 'Forumla too large'. Is there any way I can reduce the size of the syntax? I've been looking at nested forumlas but can't work out if this is what i need...

I have the following statement which exports data based on a query to a .xls: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryreportsbydate", "C:\Documents and Settings\pdainty\Desktop\RawQualityData_Weekly.xls " This works fine it exports the data and names the sheet...

I've written the following routine however it's not working for some reason. Basically I want to set the value of AG3 to match the value of H7 on sheet 2 when number 1 is selected in the combo box. Is there something wrong with my syntax? Private Sub ComboBox1_Change() If Me.ComboBox1.Value =...

I have the following statement which exports data based on a query to a .xls: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryreportsbydate", "C:\Documents and Settings\pdainty\Desktop\RawQualityData_Weekly.xls" This works fine it exports the data and names the sheet...

I want Excel to add up at set of values that correspond to someone’s name. The number of values can vary. The following is how my data looks in Excel: Dave 25 Dave 30 Dave 42 Paul 35 Dave 9 Paul 44 Paul 78 Dave 4 Dave 21 I want to use some kind of lookup...

I need to be able to add up and display the total of a number of values. My thinking was to use an expression behind a txtbox as follows: =([S1])+([s2]) The value of S1 is 100 and the value of S2 is 50 My expression doesn't seem to add the values it just displays them like this: 10050 I...

I have the following code below which works perfectly. I am trying to add a series of IF statements to the end of it. However, when i execute the code I get an error. Does anyone know why? I know the IF statement works as I can execute it behind a command button Private Sub TicketRef_Click()...

I'm trying to get the following code working when a form loads: Private Sub Form_Load() txtQ1.Value = DLookup("[Q1]", "tblQ1") Basically the value of txtQ1 is populated with the value of Q1 in tblQ1. When opening the form the text box doesn't populate. It's strange becasue I can get the...

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

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

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

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.

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

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

As part of my data structure I have a Fault table, Transaction table & Resolver table. The Resolver's are dependant on the Transaction that are selected in the fault table. What I am after (and it's not happening) is when selecting a Transaction in the Fault table the only resolver that is...

I am working on a form that will be used to search records in a table. I have created the query shown below: SELECT tblSTC.STC, * FROM tblSTC WHERE (((tblSTC.STC) Like forms!frmsearch!txtsearch)); I want my user to be able to enter search criteria and allow the use of a wildcard. When i run...