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...
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...
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...
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...
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.
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...
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 @...
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...
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...
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...
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...
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...
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...
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...
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 = '" &...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.