Recent content by peterpcu

Hi Paul, Excellent - Many thanks for your swift reply - I'll have a look at the content Best Regards peter

Hi, Could anyone advise how I can use VBA (which would be included in an Excel VBA module) to add the same logo image to the front page of number of word documents that are stored in a folder eg select the folder where the word docs are stored open the word docs one at a time add the logo to...

Hi Remou, Brilliant, I tried constructing a sub report and including it in the main report - it works a treat. Many thanks for you excellent help Regards Pete

Hi, I have two tables, one called 'Contracts' and one called 'Risks'. I have built a Report which includes the Risk table data and that report works fine. I have also built a report based on a query using the risk table data and that also works fine. How can I include data from the contracts...

Hi, I have developed a small database to hold contracts information. There is a main form named 'Contracts' which has several tabs. One of the Tabs is named 'Documentation' and it contains a subform (named Documentation SubForm) to hold all the documentation associated with a contract - the...

Hi, It it possible in Word to associate or connect a key with a given paragraph formatting style. Many moons ago, I remember being able to do this with a desktop publishing package (ventura?) Any suggestions gratefully received. Regards Pete

Thanks to Longhair and Hugh ....both ways worked OK Pete

Hi Longhair, Many thanks for your suggestion which does indeed close the workbook. It still seems to leave Excel open without a workbook in it - so how can I also close down excel as well?? Pete

Hi, Any suggestions on what the vba code is to cause a workbook and Excel to close without a save prompt. I would like to attach this code to a command button on a userform so that when the user clicks the 'close' command button, the userform ends and Excel closes without any further prompts...

Hi, I know how to change the background color of a userform using VBA - but is it possible to change the color of the top userform title bar? eg the bit that holds the caption text? Regards Pete

Hi there, Many thanks for the suggestions which worked an absolute treat! - I was indeed spoilt for choice. Just to answer Mike's curiosity, I may have mentioned before that I am building a userform generator which builds userforms dynamically based on outputs from a database. Its going...

Hi I have been using:- Screen1.show to display a typical userform. (Where Screen1 is the name of an existing userform) Does anyone have any suggestions on how I can display the same form by using a userform name (eg 'Screen1' which is held in say cell A1 of a worksheet? Regards...

Hi Skip, Sorry I did not respond to you offer - I have been out of the country. I have now solved my problem by using the .name= property route when defining the frame. Many thanks for your help Regards Pete

Hi Skip, Tried that correction - but still no show of the labels on the form. Regards Pete

OK, Now it runs without a compile error which is good but is not displaying the labels on the form. My code is now:- Set X = form.Controls("Fra" & Cells(inc, 3)).Controls.Add("forms.label.1") With X .Caption = Sheets("inputs").Cells(inc, 6) .Left...