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!

Register Log in
  • Congratulations derfloh 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: jedel
  • Order by date
  1. jedel

    Search functions

    Hi, My work PC use Office 2003. I'm looking for a feature where I can use MS Office to search for text in multiple files and produce a result for people to go to the file and read. I'm sure, as always, that this forum would have the expertise to point me in the right direction or assist me in...
  2. jedel

    COnnecting to a secure Backend DB

    Good Site link!!! Been looking for something like that for a while. Going give that one a star. Thanks for that. ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around...
  3. jedel

    COnnecting to a secure Backend DB

    Possibly, is "general" a saved word? ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."
  4. jedel

    COnnecting to a secure Backend DB

    AS it turns out, I discover that I did not need to enter the password. Seems that it saved into the connections in the linking process. I am having another problem with this database now and that is trying to get it to run as an MDE file. Keep getting run time errors. Basically, I have a...
  5. jedel

    COnnecting to a secure Backend DB

    ...through how it's done? Here is what I think is the connection code, but there are a number of these snippets in my example db: strSQL = "SELECT * " & _ "FROM tblUpdateSQL " & _ "WHERE (((tblUpdateSQL.Run)=False)) order by autoref asc;" strLocalPath =...
  6. jedel

    Detail of a record below the repeat region

    Hi all, I'm not sure if I can explain my issue clearly, but I'll give it a go. I have an ASP page with a list of events running horisontally across the page. These events consist of a date in text format, the title of the event and an image. The events are listed inside DIV tags, and, as I...
  7. jedel

    Syntax Error in UPDATE statement

    gmmastros, take a star. That was the problem. Stinkin' reserved words!!! ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."
  8. jedel

    Syntax Error in UPDATE statement

    ...this error. Here is the UDPATE code. It comes from Dr Devs pages <% If Request("UDBtn") <> "" Then intRecIDs = Replace(Request("hidRecID"), "*", "") arrRecIDs = Split(intRecIDs, ", ") For i = 0 to Ubound(arrRecIDs) DESC= Replace(Request("txtDesc" & arrRecIDs(i)), "'", "''")...
  9. jedel

    Delete Multiple records

    It's OK, I found it. Stupid mistake really. I did place a condition around it so it ran when the page loaded. The code above worked nicely. Thanks for your thoughts ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if...
  10. jedel

    Delete Multiple records

    Hi All I'm trying to set up a SQL that will delete multiple records but keep getting an error. Its the same code as the thread here thread181-27567. But my problem is that I am not getting any values in the SQL at all, i get the error Microsoft OLE DB Provider for ODBC Drivers error...
  11. jedel

    CODE NOT UPDATING

    Drex!!!!!!!! If I could give 10 stars I would! What a mongrel little letter. Don't you just love code!!!!!!! That was the issue. All is working well now. Cheers Dean ------------------------------------------------------------- "The most overlooked advantage of owning a computer is that if...
  12. jedel

    CODE NOT UPDATING

    ...it, I'kk give the the code for the entire process. The javascript code <script type="text/javascript"> function RecUpdate(RecID){ var ThisID = "*" + (RecID) + "*" if (document.mbrsFRM.hidRecID.value == ""){ document.mbrsFRM.hidRecID.value = (ThisID) } if (document.mbrsFRM.hidRecID.value !=...
  13. jedel

    CODE NOT UPDATING

    ...out of Dr Dev tutorial on multiple updating of records. <% If Request("Submit") <> "" Then intRecIDs = Replace(Request("hidRecIDs"), "*", "") arrRecIDs = Split(intRecIDs, ", ") For i = 0 to Ubound(arrRecIDs) txtsurname = Replace(Request("txtsurname" & arrRecIDs(i)), "'"...
  14. jedel

    CODE NOT UPDATING

    ...but when I go back to the records, they have not been updated. <% If Request("Submit") <> "" Then intRecIDs = Replace(Request("hidRecIDs"), "*", "") arrRecIDs = Split(intRecIDs, ", ") For i = 0 to Ubound(arrRecIDs) txtsurname = Replace(Request("txtsurname" & arrRecIDs(i))...
  15. jedel

    Export to excel register

    Hi All, I'm running a database (Access 2003) at work. I have run this database for many years over different locations in Access 97 and 2003 quite successfully. Over the years, I have found that the people that take over the database are not real competent PC users (I know its hard to...
  16. jedel

    Explode - Implode Arrays is ASP

    Robert, I agree, and yes, I am working on converting this clients site to php and MySQL, However, they still need to operate and in the meantime, I must still manage their ASP site. ------------------------------------------------------------- "The most overlooked advantage of owning a...
  17. jedel

    Explode - Implode Arrays is ASP

    OK Guys, I found the problem. It was in the Repeat region. Once I placed the function outside of the repeat region, away it went. I guess after writing that, it was a pretty dumb thing to do. Love the code snippet vicvirk, have a star. Thanks all for your input...
  18. jedel

    Explode - Implode Arrays is ASP

    DreXor, SOrry I agree with vicvirk. I do have HTML in the field. Nice thought though. vicvirk, sorry for the delay, here is the page from the container div tags. I've used Dreamweaver to build the page up. All of the connections to the databsae work fine. <div id="container"> <div...
  19. jedel

    Explode - Implode Arrays is ASP

    Sorry I copied and pasted your code above, even to the point of using straight text (Lorum Ipsum) etc to see if the code will work on my page, I came up with this error: Microsoft VBScript compilation error '800a03ea' Syntax error /men/index.asp, line 247 function...
  20. jedel

    Explode - Implode Arrays is ASP

    vicvirk I can see how that works, now how do I call the code on the page? This is what I tried: <%Response.Write(shorten((ComingUp.Fields.Item("Short Description").Value),20))%> Got a Type Mismatch error I placed your code in the header of the page...

Part and Inventory Search

Back
Top