Recent content by Killian01

For some reason, events in PowerPoint are hard to come by. Presentation_Open and Close aren't available in the traditional sense. Normally, custom functionality is added to PowerPoint using an AddIn. With PowerPoint AddIns you create routine in a standard module named Auto_Open and Auto_Close...

if you put a .Value at the end of each of those then you should get the result you're expecting.

Hiya, comboboxes don't have a Text property. When you load all the items you should set the first one (postion 0) as blank ComboBox1.AddItem "", 0 then for each control, set the list index to 0 ComboBox1.ListIndex = 0 K :-)

well there's the worksheet selection_change event, so you could use this... Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) If Target.Columns.Count = 256 Then r = Target.Row Cells(r, 1).Select msg = MsgBox("You may not select an...

Hi again, I've been out of the office for a while so maybe you've solved this already Generally, the way to do this is to check each control in the controls collection (all the controls on a form), test for something and perform an action if required. I would put this code in the clear button...

Hiya, It's not really clear what you mean here... You have a form with a tab control and on each tab there are frames? what's in the frames? I might be helpful if you posted an example so I get the idea (i'm having a very slow start to the day here... not enough coffee) K :-)

Hiya, I think this is because the AddFields method applies to a PivotTable object rather than the PivotTables collection as you have here regards K :-)

Hiya, it's a bit early in the morning for me still, but shouldn't there be a property, like .Value after txtElectricalSystem in your InStr function call? K :-)

Hi rob, I don't usually program in outlook but just a thought... you'll need to set a reference to the task you're actioning in your macro. then you can just use the MarkComplete method on it in the Send event of the MailItem you create. How easy this is will depend on how your get from the task...

and i don't think you can create them at RUN time either I'll learn to type one day too...

I don't believe it's possible to create controls at rum time in VBA (this would by done using a control array in VB) but can accept working within a range of possibilities (say 2 to 10) then you can create all the controls at design time and run a script that sets their 'visible' property and...

the easiest way would be to set up a rule that applies to all sent mail Tools|Rules Wizard in Outlook 2003 - i think this is also in Express

if you are importing a range using VBA you could use something like: Set myRange = Selection For Each Cell In myRange If IsEmpty(Cell.Value) Then Cell.Value = "" End If Next

Is this not what the Form_Terminate event is for? Maybe that isn't in Access VBA

yeah, I've seen this one a lot and no real answer has come up. (corp network, Off97, NT4) the lastest example was a fairly small file (<1mb) about 20 sheets, not much data, some formulae, no charts Ended up copying each sheet into a fresh workbook but when i got to the 2nd last, the copy failed...