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...

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!

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...

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...

I am trying to develop an application that keeps track of equipments and their configuration in detail and I can't make up my mind whether I should go with VB6 front-end backed by Access DB or pure Access DB with queries and access forms. On one hand, I like the fact that VB forms doesn't have...

Is it possible to write a single SQL query that include a aggregate function (say Max()) with Group By multiple non-aggregate columns and, here is the catch, include a Non-aggregate column that is not to be grouped? For example, a table with column 1, 2, 3, and 4, I want to find the value of...

Hi all, every time I try to import an Excel speard sheet into an Access table (existing or new), a few thousand empty record always show up in the resulting table followed by all of the correct data (around 1000 records). This is quite annoying, is there a way to fix this? Thank you in advance!

Hi all, is it possible to use JavaScript or any other means to alter browser page setup so that it doesn't print the header, URL, page title, etc? :)

Hi All, I've trying to use ADO to access database files from permission based folders. Since giving full permission of the folder to the default interenet guest account (IUSER_COMPNAME) doesn't work, I tried specifying an existing account on the network and then give permissions to that account...

Hi All, I've trying to use ADO to access database files from permission based folders. Since giving full permission of the folder to the default interenet guest account (IUSER_COMPNAME) doesn't work, I tried specifying an existing account on the network and then give permissions to that account...