Search results for query: *

Hello, I am sending a value from an input form to a database/e-mail processing page which works fine, but I need to parse the value: TEST,TEST2 What I need to do is before the value even submits, parse out the text before the first comma, along with the comma itself, so I am left with: TEST2...

Hello, I am using MS Query to pull external data conditionally which is working fine. I have a field where the user enters an order number, and associated fields for that order number (row) from the Orders table (SQL Server 2000) populate the cells as I have them mapped. Now I am trying to...

Hello, I have an Excel sheet using the MS Query tool (QBE grid) for pulling data from a SQL Server db into the sheet, works great. My question is, do the intended users ALSO need to have MS Query or can this sheet be distributed as a normal Excel sheet. Thanks in advance, CB

Hello, sorry if I didn't explain it very well before. Actaully, what I'm trying to do is populate other fields on the form based on the value from a combo box which displays the id number, but the other fields are from different fields in the table. I'm populating the order_ids into the combo...

Hello, below I am populating a combo box using ADO/SQL Server connection. Could someone show me an example of how to populate other cells on the Excel sheet based on the value selected from the combo box? My code module: Public Sub PopulateControl() Dim cnRetailData As ADODB.Connection...

Hello, I have an Excel 2000 sheet I am able to bring data into and map to certain fields via the Query Wizard, no problem. But, it seems that I could do this through VBA automation and/or macro which might be better. Could someone show me an example of how to do this with VBA automation? My...

Hello, I'm running a java-based web app on JBoss. In IE on a PC, these are not a problem: <%@ taglib uri="struts-logic" prefix="logic" %> <%@ taglib uri="struts-bean" prefix="bean" %> <%@ taglib uri="struts-html" prefix="html" %> In Mozilla/Firefox, Safari and IE on a MAC, I get this JSP...

Hello, I'm running a java-based web app on JBoss. In IE on a PC, these are not a problem: <%@ taglib uri="struts-logic" prefix="logic" %> <%@ taglib uri="struts-bean" prefix="bean" %> <%@ taglib uri="struts-html" prefix="html" %> In Mozilla/Firefox, Safari and IE on a MAC, I get this JSP...

Hello, I have a function which removes ALL leading zeros, but is there a way to remove only the FIRST leading zero? Any help would be greatly appreciated. Below is my function to remove ALL leading zeros. Thanks in advance, KP Public Function RemoveLeadingZeros( _ ByVal strValue) As...

Hello, I have a finite list of values that I need to use to validate what users enter as a valid number. I would like to simply put these numbers into a flat file (txt or csv) and be able to use a javascript to use this file to compare the value that the user entered with a match in the file...

Hello, I have been trying to come up with a IIF function to do the following in a QBE grid: If a number is 10 digits or less, then add leading zeros to fill up 11 spaces. Examples: 1234567899 = 01234567899 02356 = 00000002356 If a number is 11, 12 or 13 digits, leave it alone...

How can I make the following link which I am creating on my asp page open in a new window? strBody = strBody & vbCrLf & vbCrLf & "http://test/test/Test_Admin/loginEdit.asp?key=" & key I've tried surrounding this with <a href> tags, using a jscript 'open' function, I thought this would be a...

I've been researching this for three days now. For the past 2+ years I've had local ASP apps working fine with Access databases I use to test with. All of a sudden, I start getting this error: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]...

Hello, When I try to insert records from table 1 into table 2, I get the following error: DTSTransformCopy: Schema validation filed; see Extended Error information. TransformCopy 'DirectCopyXForm'validation error: Cannot convert (possibly due to type or length mismatch) column pair 7 (cource...

Hi all, I have a string, "1234_testfile.doc". Can someone please show me how to parse out everything to the left of the "_"? This number will grow so this would be the best solution. Thanks in advance, KP

Hello, I've been racking my brains over this one. I have a Classic ASP edit form with many fields, one of them a Status drop-down. If the Status (option value) has been changed to "Pending" for instance, I do a objMail.send, otherwise it doesn't send. No problem, but how can I prevent the mail...

Hello, I am trying to throw an alert from the onClick event of a radio button based on the &quot;checked&quot; state of a checkbox. I am testing with several dynamically created checkboxes, which start out empty but the user then clicks. If they don't click one, they should not be able to delete...

I am able to create folders and subfolders with ASP with this: <% set objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot;) ' name your folder dim basefolder basefolder = &quot;testing&quot; sub createfolders() ' create root folder objFSO.CreateFolder (&quot;c:\Inetpub\wwwroot\&quot; &...