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 wOOdy-Soft 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: *

  1. benniesanders

    find text between <> tags

    I'm having a hard time searching for this answer. I have a SQL text field from which I need a query to extract the text between <> tags, i.e. <some text here> excluding everyting else in the field. There could be as much as a paragraph in the field. I'm absolutely blank on how to handle this...
  2. benniesanders

    need to get remaining records for dropdown

    Greetings, I have a simple delivery calendar project. In Access 2000 there is a calendar table with a date and time field and a time table with 8 different time slots. The user adds a new calendar item by choosing a date then chooing an available time slot. Here's where I'm having problems...
  3. benniesanders

    Validate forms when users enter spaces

    Greetings, I have a lengthy user form and we've noticed some of the site visitors are hitting the spacebar for one of the fields. I have a form validator in place, but if they hit the space bar, it moves on to the next field. Here's a snippet of my validation code for the rogue field: if...
  4. benniesanders

    compile error: automation error

    Greetings, I'm not sure I'm even posting in the right place, but I couldn't find a better place, so here goes... I have a very small excel spreadsheet that was created on a PC but many users run on a mac. The error occurs in the following vba: Sub Show() emails.show end sub That's it. These...
  5. benniesanders

    Import XML file into access with asp

    Greetings, I have an xml file with one field (field1) that I need to import into an access database table with the same field name (field1). Or I could just update the table in the access database with this XML file, whichever is better, easier. Any ideas would be appreciated. Thank you.
  6. benniesanders

    Find IP address in files FSO?

    Greetings, I have a gazillion files that an old, bad IP address could be buried in. Is there a way to open the files using FSO, look for that IP address and response write the filename? I've used this code in the past to get a file list excluding images. I'm not smart enough to figure out...
  7. benniesanders

    Maybe use mid function? to extract data

    Greetings, I have 300 records, each with a block of text I need to extract an email address from. Every email address has a space before it and a space after it and of course the @ between. So how would I go about extracting everything to the left of the @ and everything to the right of the @...
  8. benniesanders

    Extract email address from bounces

    Greetings, Is there a way to extract the email address from a bounce like this? (I am exporting all of the bounces from Outlook to an Access database.) This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. person@email.com I...
  9. benniesanders

    Email validation in Excel user form

    Greetings, I'm not very familiar with VBA, but I have a script I use in ASP to validate email addresses entered from a form. I need something like this for an Excel userform that will verify the format of an email address being entered and I don't know where to start: if...
  10. benniesanders

    Getting email addresses from emails

    Greetings, I know this probably isn't an asp question but this group is the only one I'm comfortable using and some of you might be able to answer my question. I have about 500 user feedback emails in Outlook that I'm supposed to glean the email addresses from to add to our mailing list...
  11. benniesanders

    SSN length validator

    Greetings, I'm not very javascripty, but I have this required field (last four digits of SSN) in a form on an active server page. I am using the following code to validate the required fields but I noticed some registrants must hit the space bar to move on and I need to validate that four...
  12. benniesanders

    File list using xmlhttp?

    Greetings, I normally work on windows servers but I have a non windows site that I am re-doing. I would like to get a list of images from the image file without having to drag each image to a page. Is there a way to do this through xmlhttp or some other form of xml? The reason I wanted to use...
  13. benniesanders

    search and replace FSO error

    Greetings, I am *trying* to use the following code to search for and replace a phone number in a gazillion files: <% Dim objFSO, objFolder Set objFSO = Server.CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.GetFolder("d:\inetpub\wwwroot\myfolder") Dim objFile...
  14. benniesanders

    total within an array

    I've never been good at this. I have some shopping cart software and I need to total the quantity of certain product numbers. Here's the array: acart=session("cart") for i=lbound(acart) to ubound(acart) acart(i,0) being the product ID and acart(i,1) being the quantity if acart(i,0)<>"" and...
  15. benniesanders

    Alert of duplicate usename without losing form focus

    Greetings, I created a registration form and I have it checking for duplication of the username after it's submitted but is there a way to let the user know without losing all the info they've already entered into the form? SQL = "SELECT * FROM myregistration WHERE myusername = '" &...
  16. benniesanders

    find first 4 rows, insert text then find next four

    Greetings, not sure how to do this. I've found some examples but I'm not smart enough to modify them for my needs. I have a photo gallery asp page pulling from an access database. I need to get the first four records of a category, insert a line of html code <span class="clr"></span> set...
  17. benniesanders

    Mass hyperlink edit in Word

    Greetings, I'm using Word 2003. I have a 39 page document with 20 hyperlinks on each page. this will be turned into a web page eventually. I need to change the target of each hyperlink to open in a new window. Is there a way to do a blanket change on all hyperlinks through VBA? Many...
  18. benniesanders

    Sorting displayed form variables

    Greetings, I'm building a lengthy contact form and when I test it, I'm using the following code: For Each sItem In Request.Form Response.Write(sItem) Response.Write "=" & request.form(sItem) & "<br>" Next Is there some way to display these in in the same order they are in the...
  19. benniesanders

    Wsyiwyg editor script and validator not working together

    Greetings, I know just enough to get into trouble, but I'm using innova studio's wysiwyg editor and a separate form validator. They work great separately but not together. I'm calling them like this: <script javascript src="/administrator/scripts/innovaeditor.js"></script> <script javascript...
  20. benniesanders

    different page shows on internet vs. intranet

    Greetings, we recently replaced our server and it's running on Windows 2003 Business Server. We have a subweb of the default web site that displays to the public. Here's the strange behavior. I set up a "notfound.htm" page a long time ago with a test message, "WOW I'll bet you never expected...

Part and Inventory Search

Back
Top