Search results for query: *

Yes this works, but only for the one Agent (taxIdNumber). I need it work through all agents (taxIdNumber's) in the agent table, updating them with the value calculated in the scalar-valued function. I supposed I could use the method you propose from user-interface, creating looping structure...

Thanks for your reply. No row in the result set from the scalar-valued function is a duplicate, they are all unique. The problem is that there is more than one row - I think we understand that to be crux of the problem. Perhaps my understanding of the inner workings of SQL is at fault: I...

I've written an SQL statement to update a database as follows: UPDATE Agent SET previousBalanceDue = (select isnull(dbo.fnGetAgentTotalBalanceDue(taxIdNumber),0)) The statement fails with the follwing message: Subquery returned more than 1 value. This is not permitted when the subquery...

Hi Here goes Problem 1 I have two tables populated with data, then i have a a query and a report. What i want to do is insert two fields one field from table A & one field from table B into the single report i am having problems so far due to the record source (as it only allows one linked...

Hi there thanks scking, JoanneM shortie. I was using the recordsource instead of rowsource thank you very very much for yourhelp it is most appreciated. Thank you very much once again.

Hello there I am trying to show some query results in a combo box by using code. The only problem i am having is that i get mismatch type errors and then when it works it shows the line of code in the box (Instead of being in the drop down menu)! How do i get the code to tell the combo box to...

Hello there I have a problem where i have 6 queries & three combo boxes. When selecting the first combo box (in a form) you have three options. Clicking on one of these three options will determine the information shown in the other two combo boxes. As i am using 3 queries for combo box 2 and...

I have a problem when I am mail merging an Access query to a word document. The problem is that one of the fields I am merging is an OLE object (it has a picture of a signature). When merging all the fields (companyname, name address, etc) work with the desired results apart from the signature...

I have a problem when I am mail merging an Access query to a word document. The problem is that one of the fields I am merging is an OLE object (it has a picture of a signature). When merging all the fields (companyname, name address, etc) work with the desired results apart from the signature...

I have a problem when I am mail merging an Access query to a word document. The problem is that one of the fields I am merging is an OLE object (it has a picture of a signature). When merging all the fields (companyname, name address, etc) work with the desired results apart from the signature...

Hi I want to design a query just to show duplicate records. I have tried using the greater expression in the criteria but I do not thinK this is correct. I want to show duplicate records using these fields Title Initial Surname Add1 Add2 Add3 Add4 Add5 Postcode I tried >"1" but...

Thank you very much for your help it has worked impressivley with flying colours. Once again thank you AccessIsFun & Katerine.

Hi I have a form and it has text boxes where you enter data. There is a button at the bottom and once clicked it opens an email with the senders name and subject. The problem i am having is to put all the data enetered in to the message text of the email. I can insert a single entry but not...

Hi I have a query which i am running but it shows duplicate data. What i want is to be able to do is to write, type or code a command which will take ONLY 1 of every duplicate entry and show it in the database query. I already have tried the group by in a cobination of fields but it does not...

Hi I am designing a very basic query and i want to alter or modify the query so that there are no duplicates in the Surname, forename and postcode fields Does anybody know how i would accomplish this? I have tried using the unique values and unique records in the properties box but it...

Hi I want to have an operation using a button that will enable me to cancel changes made by an operator. At present I have an input screen which is filtered so any changes made to the fields will be automatically saved (as the text boxes in the form are linked directly with the table where the...

Hi I want to have an operation using a button that will enable me to cancel changes made by an operator. At present I have an input screen which is filtered so any changes made to the fields will be automatically saved (as the text boxes in the form are linked directly with the table where the...

I keep on getting a type mismatch with the line of code below Set rs = db.OpenRecordset("temp", dbOpenDynaset) Below is the code Private Sub Text43_Change() Dim db As Database 'Dim qdf As QueryDef 'Dim strSQL As String Dim rs As Recordset Dim i As Integer Set db = CurrentDb...

I keep on getting an error "User-defined type not defined" and it hight lights the below text in yellow "Private Sub Text43_Change()" and higligths the below text in blue "Dim trs AS DAO.Recordset" why is this? what does this mean? How can i fix it?

I keep on getting an error "User-defined type not defined" and it hight lights the below text in yellow "Private Sub Text43_Change()" and higligths the below text in blue "trs AS DAO.Recordset" why is this? what does this mean? How can i fix it?