Search results for query: *

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

Cheers, I have done that now and it works...! Next problem - I am trying to change the background colour of some cells again using VBA.... Any ideas on that one??

Hi, I am trying to hide an Excel sheet so that when the user loads the system they cannot unhide it using the menu option. I believe this can be done by hiding the sheet with a parameter of xlveryhidden or something along those lines!! Anyone any ideas? Cheers

Hi, I am relatively new to Crystal Reports and need some help exporting from CRViewer within VB6. I have 2 problems. The 1st is probably very simple, but hey ho.... 1 - Export to csv. I get the titles on every row??? Any ideas?? 2 - Export to pdf. Run-time error -2147190548. Missing or...

Hi, I am using Visio (Version 5) and want to use the keybaord to move one of my processes up and down. Everytime I use the up or down keys the whole page moves as though I am using the scrollbar and not just my process. I have tried using the scrolllock key as I Visio 2000 but this doesn't...

For future reference I have found that it is easier to format the date to "dd-mmm-yyyy", then there is no confusion at all as to whether it is American or English. This saves re-creating the date yourself!