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!

Search results for query: *

  • Users: robbie59
  • Content: Threads
  • Order by date
  1. robbie59

    Create registry entrie

    I would like to put a button on a page so that it will add the current site to the list of trusted sites in IE. can this be done from a web page and if so How? If knowledge were power I would be a AAA battery!
  2. robbie59

    save form data in different place?

    I need to save form data to a different directory and text file based on a value from a dropdown list on a form. for example If the Physician name Smith is selected from the dropdown list and other form data is filled in I need to save it to d:\formdata\smith\formdate.txt the foldername would...
  3. robbie59

    (missing operator)????

    I keep getting this error when I submit any ideas on what is causing the error Syntax error (missing operator) in query expression ''''WHERE Jobnumber = '2940' Here is the update code: <% If Request("Submit") <> "" Then varRecIDs = Replace(Request("hidRecIDs"), "*", "") ' remove all the...
  4. robbie59

    Keep Getting Syntax Error! HELP!

    Syntax error in string in query expression '' WHERE JobNumber = 2940'. manage1.asp, line 28 I keep Getting this above error when I submit any Ideas on what I am doing wrong Below is actual asp code <%@LANGUAGE="VBSCRIPT"%> <!--#include file="Connections/RS1.asp" --> <% If...
  5. robbie59

    Use different Querystring based on session value

    I have an existing query as follows: SELECT state, JobNumber, DictatorName, DictatorID, AssignTranID, dtComplete, dtAtTran, JobLength, lExtraStatus, iPriorityLevel FROM Dictations WHERE DictatorName like 'vardictator' AND state Like 'varradio' and AssignTranID like 'vartran' Vartran's...
  6. robbie59

    Hide Drop Down Menu based on session value

    I am using a session to allow viewing of a page as follows <%If lcase(Session(&quot;Accesslevel&quot;)) = &quot;&quot; Then Response.redirect &quot;./login.asp?Redirect=&quot; &Request.Servervariables(&quot;URL&quot;) End if%> I also have a drop down menu I would like to hide unless the...
  7. robbie59

    Conditional Text?

    I know this is probably easy I just can't seem to make it work I want to show text if a record is other than zero such as if (RSEDIT.Fields.Item(&quot;AssignTranID&quot;).Value)='1' then response.write &quot;trannyname&quot; else if (RSEDIT.Fields.Item(&quot;AssignTranID&quot;).Value)= 2 then...
  8. robbie59

    How to Create Link from Filename?

    I have a field that may return a number such as 589 or 1287 I need to turn these numbers into hyperlinks to an actual file based on the number of charaters such as if 589 is returned i need to make it into a hyperlink to http://files/00000589.cmp or if a four digit number such as 1287 is...
  9. robbie59

    If Len Function Create hyperlink

    I have a field that may return a number such as 589 or 1287 I need to turn these numbers into hyperlinks to an actual file based on the number of charaters such as if 589 is returned i need to make it into a hyperlink to http://files/00000589.cmp or if a four digit number such as 1287 is...
  10. robbie59

    Open an embedded word document

    how do I place a control on a form to open a word document I have in a table as an ole object. If knowledge were power I would be a AAA battery!
  11. robbie59

    Multiple criteria in a query?

    I have a unbound form for query criteria and I would like to have the user be able to select for example a month for the query but I would also like for them to be able to select between a range of months I have tried using the or criteria box with the between function but it still shows all...

Part and Inventory Search

Back
Top