Recent content by shep6

Hello, I'm new to using reporting in VB2005, so wonder if anyone can help?? In my application I've created a dataset at run time (therefore have no datasource set up). I want to report on the results of this dataset and produce a couple of graphs. I was wondering what would be the best way to...

It was only £17 from www.tekheads.co.uk. The difference between the cpu temp now and what is was before is amazing.

Finally got my Arctic Freezer 7 Pro cooler. CPU temperature now never exceeds 45-50 degrees, so if you've got a socket 775 processor and are looking for a new cooler than I'd look no further than this one (the stock intel one was running at 80-85 degrees under load!).

Thanks guys, went out and bought some Akasa Tim clean, did the trick perfectly, only cost £3.99, guess thats around $6, the bottle should last for years I reckon! Only problem is my new Arctic Cooler heatsink didn't turn up on Friday, even though I paid for next day delivery!! So I've got a nice...

I've just ordered an Arctic Freezer 7 Pro cooler to replace the Intel heatsink that came with my new socket 775 processor. I've always previously used the stock heatsink that came with the processor however this time I've been experiencing some very high cpu temps (around 90 deg when loading...

thanks!

Hi This is probably dead easy, but in powerpoint vba how do I find out the name of the current slide? Is there not something similar to Excel's acitvesheet.name property? I've tried ActivePresentation.Slides.Name, but this requires the slide index, I probably need determine the slide index...

Thanks, this works fine, except the chart doesn't look that good as it appears to have "lost" resolution when it was saved as a gif (eg, the x & y axis are unreadable). Is there any way round this? I have since been told about the Microsoft Office Web Components - Microsoft Office...

Hi there I have a user form in Excel 2000 which has a list box, the data source of which is a selection of data in an excel worksheet. I also have a chart on this worksheet. I would like to display the chart on the user form alongside the list box. I've looked at the controls available and...

Is it possible to create an array of user forms in excel vba, like you can do in Viusal Basic? I have a spreadsheet which contains 175 questions, these are to be split onto approx 20 user forms. I'm fine with creating 20 forms up front, but if the end user chooses to add, say, another 10...

Thanks anyway Dan. The source workbook is maintained by our IT dept, therefore any small change like removing the "[" is likely to be considered a major change by them! I found when I was trying different things out that I couldn't enter a "[" in the sheet name without a...

I've tried opening both the source and summary workbooks and simply clicking in the source workbook to see what happens, when I try to set a cell reference in the summary and I receive the same message from excel, "Invalid external reference to a worksheet, check the path and name&quot...

Hi there Using the vlookup function I need to lookup values in a different workbook, the problem I have is that the workbook which contains the values has sheet names which are enclosed in square brackets (eg "[Sheet1]". This is because the data in the sheets is loaded into a...

Hi there Can anyone help me out the the code needed for when the user clicks a command button within a form on database1, it opens up a form on database2. Both databases are held within the same path/directory. I have managed to open database2 using: Dim wsp As Workspace Dim dbs2 As...

Here is what I have used in the past, this will change the font color of cells A1 and B1 to our companies' corporate colour, using the Red Green Blue function: Cells(1,1).Select Selection.Font.Color = RGB(70, 104, 228) ActiveCell.Offset(0, 1).Select Selection.Font.Color = RGB(70, 104, 228) cheers