Recent content by jode

I have tried locking it and unfortuately it then means that you cant even copy a slide and paste it into another presentation which we want them to be able to do (But still not amend the picture). I think master slides may be the way forward......??

All, I am hoping someone can help. I have a powerpoint presentation that has a picture inserted. If you double click the picture it allows you to edit and I do not want that. If I save a a JPEG etc it seems to lose quality and if I lock the presentation for editing nobody can use the slide...

I am trying to create an input box that allows a user to input a password but I want the password to show as stars or something that anyone overlooking their shoulder cannot see. I am using excel 2003 and I have searched numerous different options for this and cannot find an answer. Anyone any...

Thanks - could you offer suggestions how as I have tried and failed miserably.....

I am not sure if this is even possible or not or if powerpoint is the correct tool - however I am hoping someone out there may be able to help. Basically I want 5 images vertically each with a line to the right of them going horizontal. On the click of any of the images I want them to move a...

Please help me the following code does not work for me and I have been out of coding for a while and getting very frustrated Dim appExcel As Excel.Application Dim wbk As Excel.Workbook Dim wks As Excel.Worksheet If I create a new object then I cannot work out how to reference the...

The report exports fine from Crystal Reports, but only fails when viewing through the crystal report viewer from VB.

I have searched and searched for a solution to this problem, but as yet still seem no closer to solving it! I have a report created in Crystal Reports but opened in Visual Basic using the CRViewer. I click the export button and select the type to export (for my purposes it is Excel 8.0...

You could try to requery the 2nd combo box using the on_change event of the 1st.

xlbo - apologies - it was meant to say SUMIF($C$8:$J$25, D8, $J$8:$J$25) The initial range was slightly wrong, but yes it is very bizarre. I have solved the problem just by using an array formula as below, but I still feel I should have been able to use a SUMIF...

Hi, I have a spreadsheet and have had to use the SUMIF function for the 1st time, and so don't know if I am doing something wrong or if I have found a quirk! Anyway, what I am trying to do is sum the values in column J if the values in D match..... SUMIF($C$8:$C$25, D8, $J$8:$J$25) My...

Using the OnLoad event of the form you need to check whether you have data or not. A sub routine similar to the following will work: - Private Sub Form_Load Dim db as database Dim rs as recordset set db = CurrentDB set rs = db.openrecordset("Select * from your table&quot...

In the event which opens the form you need to add the following code... forms![YourFormName]!p_type = me.[yourcomboname] Hope that helps.

Or you could try a case statement eg Select Case bookno Case 1 Do something Case 2 Do something else Case else Do something completely different End Select

Cheers Rob, Application is almost complete now! Any ideas what the RGB code is for light grey???