Search results for query: *

I've worked with simple databases before. They were glorified spreadsheets. Now I'm working on something more complicated. I may be over thinking this, but can't figure out what to do. Here is my goal: Create a database of junk cars by make, model, and year. (I can do this part) Create an...

I've worked with simple databases before. They were glorified spreadsheets. Now I'm working on something more complicated. I may be over thinking this, but can't figure out what to do. Here is my goal: Create a database of junk cars by make, model, and year. (I can do this part) Create an...

I have made a program that captures data from a webpage. This action is repeated a few hundred to a few thousand times. Right now it is taking about a second per capture because of the time it takes to load each page. Here is an outline of what I'm doing. 1) use web client to retrieve the...

This isn't necessarily VB.net, but I'm using VB.net to control a webpage. At one point I need to go directly to a webpage based on a text name. example...

I am using vb.net 2010 express to query an Access database. I understand how to query 1 item at a time. My users may need to add additional filters to the query. How would I query where 2 or more items are found. Here is the code I now use for individual querries. cmd = New...

I have made an app that auto fills out a web form. There is one option I want to let the user choose before the app continues automatically Would you just parse through the code from the site to fill in the combo box, or is there another way to get this info into the combo box? Another...

I am using vb 2010 express. I have setup a windows form with 12 labels. I have made it so that when a label is clicked it will change color to show that it is selected. When 2 are selected I will check to see if they match. I am going to populate these labels with words and definitions from...

My company recently switched from Procomm to Putty. I had several scripts written in Aspect(part of procomm) that capture text from the telnet session. Is there a way to have VB.net capture text from another application?

My company recently switched to putty because of SSH. I have several aspect scripts I use daily that no longer do me any good. My most important one captures text from the screen in procomm and saves it to a file. I either need to make procomm/aspect capture text from the putty screen, or...

I have a table setup to track inventory and provide pricing, tax rate, quantity available, etc. The tax rate could change so I don't want to set the tax rate individually for each item. The tax rate column is an integer which will correspond to the correct tax rate for the item I'm selling(if...

I am writing a program to keep track of inventory. I am using vb.net express with mysql. Every place I need to query the DB I setup a new connection, fill a new dataset, do what I need to do with the data, and close the connection. I know I should probably put the connection into it's own...

I am making a timeclock program to keep track of hours worked. I'm trying to figure out the best way to calculate the hours worked in a week. Here is the mysql table where the information is stored: +----+---------------------+--------+---------+------------+ | id | date_time |...

I'm writing a web page parser with VB.NET. I need to use regex to find the info I'm looking for, but have zero regex experience. I need to find the following lines: <span class="pricing">$119.99</span> and <span class="rebate">$20.00</span> And just pull out the numbers with the decimal...

i want to use vlookup to find infomation in a spreadsheet that will change name daily according to the date. Is there a way to have the table array change with the value of a cell? here is my vlookup: =VLOOKUP("Volume",'C:\DailySales\CD2767\[CD2767_06-01-2009.xls]Sheet1'!F1:H50,2,TRUE) As...

I want to find a specific occurance of a name in an external spreadsheet. Below is an example A B C 1 Johnson Frank 10% 2 Dowers Chris 12% 3 Johnson Dan 20% I need to be able to find Dan Johnson and get the data in column C. I can't modify the original...

I have 2 workbooks - a.xls, b.xls. i want the value of A1 in a.xls to = ROW?:COL20 in b.xls by searching ROW# by a name in COL3 I've tried using vlookup without success.

Is there a way lock the keyboard/mouse while a script runs?

I am trying to encrypt a string to a txt file and then decrypt it later. Usually it works, but sometimes I get the wrong characters back after decrypting. Any ideas why?

How would I convert a string to and integer and keep the numbers after the decimal? strtonum cuts them off.

New to aspect scripting. I've used basic, c++, and a few ohers years ago, but havn't had a need to recently. Now work has an annoying/time consuming login process. I want to be able to enter my username/password once, have that passed to procomm twice, then pass the f1 key to accept a...