Search results for query: *

Hello everyone, I have a problem that I have to believe has a simple resolution... hope someone can help me: Quick overview of what i'm trying to do: I am trying to export "monthly statement" information to a CSV file where we would then send the CSV to a company for printing of the...

Hello, Could somebody please tell me why the following code written in VFP8 does not work with Excel 2000? xlValue = -4163 XlMultiply = 4 oExcel.Range("H6").PasteSpecial(xlValue,xlMultiply,.F.,.F.) With the last line, I get the following error: "Unable to get PasteSpecial property of the...

Hi everybody, Can someone please tell me the syntax using a SELECT statement to do the following (if there is one, of course): I have the following data: Year Customer# TotalSales 2003 ABC $400 2004 ABC $800 2003 DEF $500 2004 GHI...

Hi Everyone, Got this darn recurring situation that seems to rear it's ugly head every 2 or 3 years and I thought i'd finally take a moment to find out if there is a solution to it or if I once again have to find a work-around... I have a one-to-many relationship setup between my parent...

Hello everyone! Just found out there's a MAS 90 forum... I sure can use some help on this one... There's got to be a simple answer so here goes: I'm using Visual Foxpro 8.0 to pull data down from our MAS 200 tables. Can someone tell me how to add some additional blank fields in a sql-select...

Can someone tell me how to add some additional blank fields in a sql-select stmt. For example, here's what I'm trying to do: Select CusName, space(30) as MyFieldName from SqlTable It doesn't like the space()! I could have sworn i've done this before... There's got to be an easy solution to...

Can somebody please give me the command to determin if an excel file is open by another person? Thank You Everyone! Jack.

Hi, i'm using VFP 8. I've got a report that has sub-groupings and I wish to reset the _pageno to 1 after each group. Unfortunately, when doing this, the _pagetotal no longer is correct. For example, if the last group has 4 pages total, then all other groups will show "x of 4" no matter how...

I've got an Excel XP worksheet which is Sheet Protected as well as "Range" protected. The range protected is from cell A4 to the very last cell (IV65536) and specify a password. Upon protecting the sheet I check the INSERT ROWS & DELETE ROWS options to allow for these options. I then SHARE...

I'm hoping someone can shed some light on the following problems i'm having: I created a spreadsheet in Excel 2002 for Windows that has password protection assigned to the entire sheet as well as another level of password protection on various cells (ie: allow users to edit ranges). It also...

Can anyone tell me how I can import data from an excel file that is currently open?

Hello everyone, I have a couple macros in excel that prints a specified range of rows/cells to a printer and then prints the same range to an html file. The "printer" version prints at 85% (per the Page Setup) and prints on one page. The problem is that the HTML file DOES NOT print...

I'm wondering if anyone can help me out on this. I simply would like to have our checkboxes display and print an "X" rather than a "checkmark". Please help if you can and thank you in advance. Jack.

I have been searching for an answer to my problem without any luck so here's another thread on this problem... I'm using sql 7. I just tried to restore a database from EM and I got an error saying there "wasn't enough disk space to expand..." something like that. Now the database...

This has to be an easy one! What's wrong with the following IF statement: ------------------------------------------------------- If {BBJOBCST.SHIFT} NOT IN [AllShifts] Then (TotalShiftsWithRuns = TotalShiftsWithRuns + 1; AllShifts = AllShifts + "," + {BBJOBCST.SHIFT})...

Can anyone tell me why the code I put in the VALID snippet of the Grid.Column.Text.Valid doesn't run? (it also doesn't run when I put it in the Keypress or LostFocus snippets). I'm using VFP6. Thank You!

Hi Everyone, I'm trying to program an inventory receiving program. Using a Handheld Scanner, inventory is scanned. First the item number and then the quantity... after the quantity is scanned, I need the cursor to automatically move down to the 1st column of the next row. (I'd also like this...

There must be an easy answer to this one! Can somebody please tell me how I can get around this problem: I'm simply trying to perform the following select stmt: Select PONO,LINENO,MATNO from bbpoline And I get the following error: Incorrect syntax near the keyword 'LINENO'...

I'm just wondering if anyone can offer a good reference on a third party vendor or two that have been around for awhile who provide a "solid" sql encryption package (works on tables). One that's tried & true. Thanks everyone, Jack.

I know that Microsoft doesn't provide the ability to Encrypt and Decrypt tables in Sql Server... What i'm wondering is if anyone out there knows of any third party software vendors that provide this ability. We are only interested in vendors that have been around a while and whose software has...