Search results for query: *

Hi All, I'm looking for a way to find and replace a block of text across multiple files. The files are .cfg files written with an XML style code. Each file is in a different folder for which I could identify easily. The subset of code that I'd want to replace, at least initially, may be...

Hi All, I have a database that has 3 columns in it (that matter for this discussion). IP_LOW - the low number of an IP Range owned by a company IP_HIGH - the high number of an IP Range owned by a company IP_EXPRESSION - the regular expression of the entire range I would like to company...

Hi, I've been experimenting with tables and searches and their corresponding times for searches. Orginally, I had a table with about 2500 results in it; when seaching for things, I was getting results in 20 milliseconds (according to the SQL Profiler). I've since taken that data and broken...

Hi All, I'm just starting to get in to SQL 2005 and have learned alot. I have a database that has just a few thousand records in it but I'd like to eliminate the possibility of having a duplicate entry of one of the fields WHILE ALLOWING Null values. I read on constraints and it said that you...

Hi, I'm trying to do a query on a database that will find me the owner of an IP address I've stored. I have IP addresses and hostnames; and the corresponding Regular Expressions. My query is taking about 7 seconds per lookup and I have hundreds of lookups; any tips to speed this up would be...

Hi, I have to export a variety of data from SQL for use within another program. I want to export my data to XML format so that it can simply be picked up and used by the other program. I have figured out how to export some basic queries (more complex ones to come) but need to know how to...

Hi, Just wondering if anyone knows if SQL Express processes at the same speed as SQL 2000 or 2005? My queries seem to take 17 seconds average to find one match out of 2200 records. In the big picture, that seems a bit slow. It is comparing regular expressions to exact values... Could it be...

Hi All, I have found a UDF that has helped me compare a value to a regular expression that is stored in SQL however, it seems to take forever when processing multiple records. I'm wondering if there is a way to log the action of the queries so I can understand what is actually happening in the...

Hi, I have a database that has a table with 2 fields; RegEx and Owner where RegEx is a regular expression of an IP address and and Owner is the text string name of the owner. I need to be able to search through the RegEx field and match it to an IP address than return the Owner name. Sample...

Hi All, I have the following function in a VBA App. I've developed in Access. It is to sort the worksheets in an Excel file. It worked great up till recent unrelated changes and now doesn't complete the process. The sheets are named and numbered (1. Name, 2. Name I, 3. Name II etc.). The...

Hi All, I'm having a bit of trouble populating an array in Excel. Here is the code I have tried and I get a 'subscript out of range error. Any thoughts? For k = 1 To topValues Top5Countries(k) = Worksheets(worksheetName).Cells(4 + k, countryColumn) Next k For l = 1...

Hi All, I've asked a question in the past but didn't manage to get the solution so thought that I asked the question wrong... I have a summary table in Excel and need to make a chart from the data. The first column is a name of a country, and the second is a numeric value. I'd like to make a...

Hi All, I have created a workbook that summarizes a variety of data. It creates 'charts' based on data on 'worksheets'. I'd like to set the zoom on the 'charts' window (not the pagesetup for printing) but am not having luck and when it does work, it leaves an Excel Process running.... Code I...

Hi All, I have a project that exports data from Access to Excel then creates charts as 'Worksheets' or Full Page Charts and my sort worksheet routine no longer works... It worked fine with just worksheets, but when added the 'charts' it started failing... The error is 'subscript out of...

Hi All, I've been working on a project that takes data from Access and generates a variety of reports in Excel. I'd like to automatically generate a number of bar/pie charts in that worksheet based on summary data. My problem is that I have a list of about 40 data records in rows, and would...

Hi, I would like to make some charts in Excel with some data that was created and exported from Access to Excel. When I generate the pie charts and set up all the data labels, they seem to overwrite each other when the percentages are small. How can set this up so that all the labels are...

Hi, I'm having problems with some code to create charts. Ultimately, I am generating a spreadsheet that contains multiple sheets (all with same data sorted differently). The code as follows generates the chart on the first worksheet, but does not on all others as it errors out on the...

Hi All, I'm new to alot of this stuff and I want to order the worksheets in Excel. I have written quite a bit of code that creates about 8 different worksheets, however, it seems to place sheet 8 at the beginning. I'd like to re-order the worksheets to have worksheet 1 as the leftmost tab...

Hi, I have a number of tables that are being produced from Access data into an Excel spreadsheet. I have created multiple ranges and wish to format the ranges... My problem is that in formatting the range with BorderAround Weight:=xlMedium is that the outside of the entire range is formatted...

Hi All, I have some simple code for formatting a few ranges in Excel (data that was exported from Access). I have just started on this project and am learning lots... I realize that I should use a WITH ... END WITH statement for the following code, but for now, the important problem is that...