Recent content by aiden

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