Search results for query: *

thanks. just what I needed.

Hi, On one Excel worksheet I have a list of company names and numbers. The second sheet lists records showing every date that those customers have been contacted year to date. (could be one record, could be dozens). How can I create a formula on the first sheet that would show the last date...

Hi All, On a weekly basis I receive a workbook of 15 worksheets that contain some date columns. The date formats on the worksheet columns (and my computer settings) are set to dd/mm/yyyy. However, Excel is not recognizing dates that don't fit the the US standard format of mm/dd/yyyy. Excel...

Worked Perfectly. Thanks

Hi Thanks for the quick replies but Window|New Window only opens a new window within the existing instance of Excel. I want to have multiple instances of Excel running so that I can put separate instances on separate displays (preferably maximized). Arranging multiple windows within one...

Hi, I have split my display between my laptop screen and my monitor. This makes it extremely efficient for looking from one application to the other. (ex. Outlook on the laptop, Excel on the monitor.) Some applications such as Internet Explorer, Word and Outlook allow me to have multiple...

Hi Skip, I was trying to keep things simple in my example. Every month, we receive 4 different reports from siloed billing applications. Each bill is for a separate product line. The employee wants a summary of these reports :column1 - report1, column2 - report2, etc. They want to see each...

Hi, I've been asked to create a workbook that will contain monthly summaries of 4 workbooks. My master workbook will contain 12 worksheets - one for each month of year. Each worksheet will summarize information from 4 product workbooks. Since most of the product workbooks don't exist yet...

Hi, While the secondary applications were originally 2.6, they were totally rewritten in VFP 6.0. The application that is used to launch these programs is an original VFP 6.0 application - and this is the one whose buttons are disappearing. Thanks.

Hi, I have a VFP 6.0 application with several command buttons that is used to launch other VFP 6.0 applications. On some of the PC's in my company, when the user launches the secondary applications, the buttons and graphics on the main application disappear. If you click where you think a...

Hi, I'm trying to create some formfields (textboxes) in MS Word 2002 from VFP 6.0. I can create the textboxes where I want them. However, when I try to set the textinput properties, I get a 'Command failed' error even though the properties are successfully changed. Needless to say, I'm trying...

Oops. Sorry about that.

Hi, I'm trying to create some formfields (textboxes) in MS Word 2002 from VFP 6.0. I can create the textboxes where I want them. However, when I try to set the textinput properties, I get a 'Command failed' error even though the properties are successfully changed. Needless to say, I'm trying...

Hi Mark, 'Selectonentry' doesn't give me the desired effect. It will only highlight the contents of the textbox when you tab into the field. I want to highlight the contents even when I click the field. I usually add the following code to my textboxes: TextBox::GotFocus() This.SelStart = 0...

Hi, I recently took over an application and I would like to alter the features of the controls on the forms. There are many textboxes (~50) on about 10 forms. I want to add code to the 'gotfocus' event so the textboxes highlight when they receives focus. There is other code behind these...

Hi, I am using a menu designer created menu to navigate through my forms. ie File Form1 Form2 Form3 I open the selected form using 'Do Form' and then use the following code to close any other open forms. This works fine until I put scrollbars on my forms. It seems as though VFP6 is...

Each time I try to run the Setup.exe to install, I get the initial setup window but then the system hangs. I have to use the task manager to kill it. I have tried running the setup from a cd as well as from a network drive but with no luck. I have also copied the installed fpw26 directory...

Hi, When I create several pivot tables in an Excel workbook a 50 - 500kb file increases in size to 2 - 5 mb's. Once the tables have been created, is there any way to 'compact' the workbook? Thanks

Hi, I generate several reports on a network based database with 5 tables. The reports are all based on select queries with inner joins to connect the tables. The main table has only about 20,000 records. Whichever query is run first takes several minutes to run. Any subsequent queries take...

Hi, My client uses a mix of Win95/98, NT 4 Workstation, and Windows XP. (Eventually, they'll all be XP) I've always developed Apps for a Win95/98 world. How can I tell which O/S is installed and are there any 'gotchas' that I should know about XP. Thanks for your time.