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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pull a Vbscript object into a Javascript function??
I used a global Javascript variable. And it worked. Thank you. <script Language="JavaScript"> <!-- var QT = <%= rsprod("QOH") %>; function FrontPage_Form1_Validator(theForm) { if (parseFloat(theForm.Qty.value) > QT) { alert("Please enter an amount less than the amount in stock.")... -
Pull a Vbscript object into a Javascript function??
I will try a global and see what happens. Im kinda new at this. Thanks! -
Pull a Vbscript object into a Javascript function??
I am trying to pull the "Quantity on Hand" value in Vbscript into my Javascript function. I have tried everything and its not working. Please help... Thanks! Code: <%@ LANGUAGE = "VBScript" %> <!-- #include file="db.inc" --> <!-- #include file="config.inc" --> if stage="" or stage=null then... -
Maximize Values in a Row
From what you described, it sounds like you are trying to make the query table behave like an Excel spreadsheet. This is not possible through a query alone. When someone wants calculated fields you could possibly run another query with the max of the fiels as "new fields" and use these values...- WorkrAnt
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Show me how to throw a ADODB.recordset field into a variable
Thank you very much!!!! Since I was trying to get the max value of a field, I had to change a few things, but it worked. strSQL3 = "SELECT max(S_CUSTNO) as newnum FROM CUSTOMER" rcd0.Open strSQL3, cn2, adOpenStatic, adLockReadOnly, adCmdText cn.Execute strSQL3 g =...- WorkrAnt
- Post #3
- Forum: Microsoft: Access Other topics
-
Show me how to throw a ADODB.recordset field into a variable
I want to find out the value of a single field in a sql stmt and put it into a variable for later use. I dont want to add, or update the table. For instance.... Private Sub cmdCustomer_Click() 'Recordsets Dim cn As ADODB.Connection, _ rcd0 As New ADODB.Recordset, _ fldDealerNo As ADODB.Field...- WorkrAnt
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
