Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by redbay

  1. redbay

    Date auto inserted

    where will i alter the code?
  2. redbay

    Date auto inserted

    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"...
  3. redbay

    Row height

    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?
  4. redbay

    Repeat region

    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?
  5. redbay

    Repeat region

    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?
  6. redbay

    Repeat region

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

    Repeat region

    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?
  8. redbay

    Recordset based on two filters

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

    Recordset based on two filters

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

    Recordset based on two filters

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

    Date auto inserted

    Worked a dream Thanks Cheech
  12. redbay

    Recordset based on two filters

    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?
  13. redbay

    Date auto inserted

    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?
  14. redbay

    Search Pages

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

    If Statement

    OK will try that and thanks for all your help

Part and Inventory Search

Back
Top