Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jode
  • Order by date
  1. jode

    Locking Powerpoint Pictures

    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......??
  2. jode

    Locking Powerpoint Pictures

    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...
  3. jode

    MS Excel Password Input

    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...
  4. jode

    Powerpoint Automation

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

    Powerpoint Automation

    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...
  6. jode

    Excel.Application

    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...
  7. jode

    Export Problem

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

    Export Problem

    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...
  9. jode

    Combo Box Crisis....

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

    SUMIF Query

    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...
  11. jode

    SUMIF Query

    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...
  12. jode

    error msg when form has no records

    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...
  13. jode

    Can Data Selected in One Form Be Set in Another??

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

    How do I create more than 7 nested If statements in Excel?

    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
  15. jode

    Hide Excel Sheet using VBA

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

    Hide Excel Sheet using VBA

    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??
  17. jode

    Hide Excel Sheet using VBA

    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
  18. jode

    Help - export

    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...
  19. jode

    Using the keyboard

    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...
  20. jode

    Queries and reports

    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!

Part and Inventory Search

Back
Top