Search results for query: *

I'm writing a routine to upload a .dbf table to a mySql table. Using some code I found on these forums, I'm able to generate a .sql script. What I'm stuck on is executing the .sql script in foxpro. The issue is that I can't get multiple commands to execute from a single script. Only a single...

I've got a .lbx pulling in data to print out to a sheet of 2 columns of 2"x4" labels. Everything works great, but I'd like to have the ability to skip labels in order to avoid wasting labels and having to use a new sheet of labels every time. The only way I can think of right now is to insert...

When I search for "Excel" or "excel" I get no returns. Yet I know they're in here! What's up with that? Chandler I ran over my dogma with karma!

I've been looking for a way to name the workbooks and worksheets I create using VFP 9.0 So far I've found ways to create and select, but not to name. Any help is much appreciated. Chandler I ran over my dogma with karma!

I'm using the fputs() function to send text to a text file, but the beginning of each line in the text file is showing 2 squares for some control characters. Am I missing a parameter? FSEEK(_splits,2,2) fputs(_splits,ALLTRIM(pname)) Chandler I ran over my dogma with karma!

I'm trying to create a header row for a comma delimited file using STRTOFILE(), but the variable for the cExpression property is greater than 255 characters. Is there a workaround? && Header Row hdr='"FIRST","LAST","OR CURRENT RESIDENT","STREET","CITY","ST","ZIP4","JOBNUM","PART","OPT...

I've got a routine that computes the mean and standard deviations from an array ($closeData). However, I'd like the routine to skip the the first 97 records. Here is my code that can process the entire array: #Function for calculating Standard Deviation function standard_deviation($std)...

I'm trying to create a new window with window.open, but I need to pass the referrer info so that the request doesn't get "locked out" by my .htaccess file. Is there a way in php to pass that info? Chandler I ran over my dogma with karma!

Is it possible to do conditional cell formatting in HTML tables similar to Excel? I'm trying to change the cell's background color depending on the value in the cell. The table cell values will come from PHP returned values. Chandler I ran over my dogma with karma!

Hi, I'm trying to take a csv file and create an array for each "column". So far, everything I"ve seen deals with creating a multiple dimension array, but what I need are multiple arrays. Thanks. Chandler I ran over my dogma with karma!

Is there a function that can return the data type of an array? Somewhere along the lines, the data types my array is reading in from the spreadsheet may be getting converted from numeric values and dates to something else. Thanks. Chandler I ran over my dogma with karma!

I'm sure it's simple.. I just can't put 2 and 2 together right now. Anywho... I have a range that I need stored into an array in for some macro calculations. Here's what I've been using that isn't working: 'The data for the bar chart data = range("A2:A31").Value Chandler I ran over my...

Disable automatic cell conditional formatting I have an Excel Worksheet that uses a live DDE feed of the current prices of currencies. I have multiple cells with conditional formatting that show specific price levels in a different color when the live price is near that level. However, because...

I've been searching all day and can't figure out how to get the Y Axis of my chart to show up on the right side of the chart instead of the left. The only way I"ve found to do it is to reverse the Y axis. Not feasable because this is a stock price type chart. The only work around I've found...

Is there an easier way to either export or copy/paste each worksheet in a workbook to a new file? Chandler I ran over my dogma with karma!

I have a table with address info and job numbers. There are about 30 different job numbers and I want to get a count of how man duplicates there are between job numbers. For example, how many duplicates are there between job number 55326A and 55326B, 55326A and 55326C et al. The first...

I would like to append a header row to the top of a txt file without using copy to file type csv. The header row column names will contain spaces and characters not allowed in dbf column names. I tried using SET ALTERNATE ON ADDITIVE, but that appends to the bottom of the file. What I'm...

I'm running the following macro that selects a range and sorts it z->a. Then, the macro will do some find and delete stuff. However, the macro gets to the sort phase and then loops back up to the beginning instead of continuing. I used the macro recorded insted of typing in the code. What's...

Is there a way to set-up "searchable" regions of a document? I have about 15 html documents that all have a navigation menu table. When I do a search with Verity, I'm getting unwanted results because a search term may be in the navigation menu. Setting up frames is not an option right...

When I click on a returned result from a search using verity, I get an error 404. If verity can find the file, what do I need to do to open the file? html, txt, pdf, word and excel documents all give the 404 error. I used the verity wizard in studio. I'm also using 4.5. Chandler I ran over...