Search results for query: *

Chris, This is an internal app for a pos system. its all self contained. And they only use IE for the pos system. That what the forms within the system were designed around. I know, alot of common security is soooo breached, and if I werent learning as I created this I definately would have...

It was tried with and without the parenthesis. No worky But I did find a way to do it which took more programming knowledge than I started with. For some reason the sendkey commands didnt like pasting to itself so I set up an array and an outside file to save the data then read it back in. I...

Well I finally got it working. Main form is an HTA and to grab info from SQL it call an exe. Had to convert my vbs to exe to get it to work. Seems to run pretty good. Bosses like it and the client likes it. Thank for the guidance

Nothing like learning on the fly. I am starting to get the code cleaned up in both files. I really am sorry for any confusion about what I was doing to get this to work. Sooooo not a programmer.

...Set objFile = objFSO.OpenTextFile(strfile) itemno = objFile.ReadLine objFile.Close sqlrs.open "SELECT * FROM [IM_INV] where ITEM_NO = '"&itemno&"' AND LOC_ID='MAIN'", CONNECT_STRING sqlrs2.open "SELECT * FROM [VI_USR_MARGIN] where ITEM_NO = '"&itemno&"'", CONNECT_STRING...

Well, almost there. I have gotten this dang thing to create an input file for the item number using javascript, then in vbscript I am able to read that file and display the returned data back to the html form. Only hiccup it creating he correct results file. I run the vbscript on its own and...

ok, how about this then... I modified my script to read from for input and create an output file for results. Is there script that will work in the html form to create the input file(only needs to contain the txtItem field) and then read the results file to input into my description, average...

Ugh the horror story... I work on POS systems and a client is asking for a margin calc so his sales people can find current margin and determine new prices and margins within limits. So my first go'round was easy. I wrote a quick vbsscript to pull the data from sql but they wanted it to...

Ok that is why the box doesn't popup. But that was only for testing anyways. Is that also why it wont read into SQL and fill the variables? Would doing something like writing to a text file and read it into vbscript work better then read the results into another text file to go to html through...

...Set sqlrs2 = createobject("ADODB.Recordset") dbconnection.Open CONNECT_STRING itemno = "999999" sqlrs.open "SELECT * FROM [IM_INV] where ITEM_NO = '"&itemno&"' AND LOC_ID='MAIN'", CONNECT_STRING sqlrs2.open "SELECT * FROM [VI_USR_MARGIN] where ITEM_NO = '"&itemno&"'", CONNECT_STRING If...

That was how my vbs code was written for another project that works fine. This exploration into html and java with vbs has been an experience

That was the name of the view it is pulling data from since it comes from 3 different tables

That has been the biggest help so far. It is the select statement. Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Thank goodness. A new place to look

Well, I am still trying different thing I find. No luck. All this needs to do is connect this stand alone form to the clients sql database when the button is clicked to pull the item and display the info. if there is a better way please advise. I am not a programmer and the parts that work are...

That why they are inside the quotes. SQL needs them

The highlighted. For somereason I cannot get the on_click to run to the vbscript Just using the vbscript grab database info to display it in the html window

...(document.MARGIN.AvgCost.value > "") { AVG = document.MARGIN.AvgCost.value }; document.MARGIN.AvgCost.value = eval(AVG); MRG = (PRC - AVG) / PRC * 100; document.MARGIN.NMargin.value = dm(eval(MRG)); } function Pcalc(){ MRG = 0 AVG = 0 if (document.MARGIN.PMargin.value > "") { MRG =...

...> "") { AVG = document.MARGIN.AvgCost.value }; document.MARGIN.AvgCost.value = eval(AVG); MRG = (PRC - AVG) / PRC * 100; document.MARGIN.NMargin.value = dm(eval(MRG)); } function Pcalc(){ MRG = 0 AVG = 0 if (document.MARGIN.PMargin.value > "") { MRG =...

What am I doing wrong? I can copy and paste my relevant data into notepad, word, and even point of sale software but I cannot seem to get my vbs script to paste into it's own input box. I am very confuzzled. First part copies item number to be pasted into script: WshShell.AppActivate...

Nevermind. Forgot to change database name to table name. What a Homer!!! DOH!!!!