Search results for query: *

Hi everybody, is it possible to do a keyword search on file names in a directory (unknown number of sub directories) like the file search in windows? The only workable method I know so far is using filesystemobject to list all files and subfolders then recurs using some kind of tree traverse...

Hi everyone, I have two tables, one with parts, the other with premium. Some parts don't have premiums. I need to build a query that allows me to add the premiums on to the parts if there is one, but as mentioned before, some of the parts dont have premiums. I get an error whenever I call...

This is sort of a silly question, but I have a couple of text boxes in my mdiFrom that disappeared somewhere. Since I can't see them anywhere, I am unable to delete them by clicking on them and hit "delete". Is there some way to remove these unused controls that are hiding?

Is there a way for VB to not close the DOS screen after a dos shell program is called and finished running? The DOS program is suppose to generate some output and/or error notifications but it is closed too fast for viewing :( I tried redirecting the output to a text file (shell("work.exe >...

Hi all, I've been working on an inventory type program with a combination of ADODC and ADODB.Connection objects with local development database file. The purpose of ADODC is that I want to have an updatable data grid. ADODB conns are used to populate dropdowns and inserting new records. The...

Hi all, can classic ASP pages every give real time display? One user came to me with a complaint about a web page that loads data from a database does not display loading progress in a sequential fashion anymore. The page basically loads data from various tables, and he claims that when while...

Hi everyone, is there a way to selectively choose the fields to display for each record in Crystal report? I was handed this very poorly designed database that is not helpful when it comes to reporting. The table looks something like this: Time Equipment DetailOfA DetailOfB DetailOfC DetailOfD...

Hi all, I've been involved with VB for quite a while and made a few not so complicated programs. However I always have a hard time deciding whether to include a procedure within a form or in a module. I am sort of uncomfortable when there are 5 procedures that are called UpdatePhoneNumber() in 5...

Hi all, :( I've been finding to a way do this for a long while and getting nothing. I want to have a visual basic exe that goes to a company-associated web site to obtain some status-type information periodically. So far the most promising method is to run some VBA script and web query from...

Thank you Ngolem and Kenhamady. I did tried to round the time but then I realized there instances where there could a time set like 1:04 and 1:05 in the same group, but with rounding, they will be seperated :( . If only the data is better. Kenhamady you are right, they are triggered by the...

Thank you for your sugguestion, here's what my data looks like, # of 4 DateTimeStamp Value 1 6/17/03 11:01 AM 2000 2 6/17/03 11:02 AM 4000 3 6/17/03 11:02 AM 5000 4 6/17/03 11:01 AM 5000 1 6/17/03 11:12 AM 5000 2...

That's a very good way if the time stamps are more or less near the 10 minute mark, however, it shifts over time and there could exist a time set such as 2:24 2:25 2:24 2:24 which will result in two groups.

Hi all, does anyone have some good idea to go about doing this? Approximately every 10mins, each part of a piece of hardware that has four parts in total will produce a value with a time stamp. The four parts are supposed to be synchronized but in reality one or two of them will differ about 1-2...

Although my colleague doesn't think so, I am wondering if anyone knows if Crystal Reports can create line of best fit or some form regression when including graphs/charts? If so, how? Thanks!

But formating the data axis only affects the vertical axis right? How do I format the horizontal "group axis"? I am using a "on change of" @Year(fldDate).

Hi all, Is it possible to change the group axis label to integer only on a chart? I've made a chart that shows data on change of a calculated field "year", however, the label looks like 2,002.00 2,001.00 2,003.00 instead of the perfered 2003. Is there a setting I might change like the...

Oh my god, I am so sorry, I posted the wrong code. The rs.close and set = nothig line should be ignored in the while loop. However, using an array to hold the rs values then close the rs before insert is a fantastic idea, I will give it a try!

it looks something like this, thank you: Set cn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") cn.CommandTimeout = 300 cn.Open DBConnectString cn.BeginTrans rs.open "Select * from table1", cn while not rs.eof rs.close...

Hi all, I've been getting "Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets." when I run my asp pages. I am using adodb connection with transcation. I did a very through check to make sure...

Hi all, I've been getting "Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets." when I run my asp pages. I am using adodb connection with transcation. I did a very through check to make sure...