Search results for query: *

where will i alter the code?

Cheech i am trying to put the above code into an update but cant get it to work, can you advise please. heres the code <input <%If (CStr((rsactedit.Fields.Item("InitialResponse").Value)) = CStr("True")) Then Response.Write("checked") : Response.Write("")%> name="InitialResponse" type="checkbox"...

I have a table, that is exactly like many other tables that i have used, but when i view it live the row height is twice as high as any others, have tried coding the height but it still stays the same....any advice?

have tried that but cant get it to do what i want....could i not create a layer and have its visibility set to true if more than one record displayed?

Thanks Cheech. Ive inserted a new column at the end of the repeat region and inserted the update form this works OK except that the update form is now on every row, how can i make it only appear the once?

Yes it works fine with a single record, i have an update record on the form and when i take that off it also works fine, here's the code <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../Connections/dbConn.asp" --> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim...

Hi, i have my recordset set up and working OK but as soon as i put a repeat region on it i get either BOF or EOF is Trues, requires a current record....can anyone tell me where i am going wrong?

No, for example ComplaintID 105 / CustomerID 129 / Action 203 ComplaintID 106 / CustomerID 129 / Action 199 I'm trying to show all actions against 105 / 129 but i'm getting all actions against customer 129

I now have this SELECT * FROM qryActDet WHERE ComplaintID = MMColParam AND CustomerID = MMColParam Name Default Value Run-Time Value MMColParam 1 strComplaintID MMColParam 1 strCustomerID but when i test it i get the message Syntax error missing operatot in...

Have tried changing the advanced recordset as so SELECT * FROM qryActDet WHERE ComplaintID = MMColParam AND CustomerID = MMColParam Anchanged the variable to Name Default Value Run-Time Value MMColParam 1 RequestQueryString("ComplaintID") MMColParam 1...

Worked a dream Thanks Cheech

Is it possible to base a recordset on two filters, at the moment it is filtered on ComplaintId and the URL Parameter set as ComplaintID, but i would like to filter on ComplaintID and then customerID. any help please?

I have a checkbox and i would like if the box is clicked then the date field is automatically filled in as the current date.....any help please?

I have a form with a drop down box so that when you select a category all the complaints within the category are displayed as such Category = Catering Short Description Poor service record 1 Poor service record 2 No variety record 3 No variety record 4 but what i would...

OK will try that and thanks for all your help

tblAction ActionID - A/N P/K has no CustomerID but is linked through History table

Hi Remou Have realised, tblAction is ActionID so i've changed that and got rid of the parameter boxes. Now the query shows as you have mapped except the data in status allacts and complete acts is still 0, we are getting there and thanks for all your help

This is where i'm going wrong. I also have a table called tblHistory that has 3 fields ComplaintID, CustomerID & ActionID which links all 3 tables together so when i apply your sql above it all go's to pot, ive included the history table into the query and my sql is as so SELECT...

Sorry have changed this but i'm still getting the same parameter boves open, then the message you are about to update 57 records

Cheech, just got back to working on this problem, tried the above and still couldnt get it to work. created another recordset on the page to include the action Closed field and placed this in my table as a hidden field, changed the code as follows but still not getting anywhere <% If...