I finally figured it out. In case anyone else has this same question, the answer is to surround the variable with #, instead of ' e.g., as in my situation:
#"&sevenyearsago&"#"
Does anyone know how to reference a variable to be interpreted as a date in an SQL string. I keep getting a "type mismatch" error. I know the field, usdatabase.TransactionDate will accept only dates.
I have tried substituting the &'s in the sevenyearsago variable with #, and it...
Is there a way to make a MSGBox come up exactly where you want it to on the screen, even if the window is minimized.
The default location of the MSGBOX always overlays an importatnt message to my user.
TIA.
Please help. I may be overlooking something obvious. I have included the error message when the page is published.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage...
In VBScript, I am trying to use onfocus to change the background color of a form field named T1 to green, Then onblur to change it back to white. It's simple in VB, but I keep getting an 'Object Required : T1' error in VBScript. I can put a MsgBox in the Sub and it'll work fine.
sub...
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.