Search:

Type: Posts; User: rocker123

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. MsOf10 Re: Powerpoint 2010: Randomly Display an image

    Fantastic my dear vbfbryce, your code and logic is much cleaner and clearer than mine, it's really fun to discuss coding and logic with you.Thanks a gain my dear
  2. MsOf10 Re: Powerpoint 2010: Randomly Display an image

    any way, your advice is still helpful in some logical way , i think so, thanks pro
  3. MsOf10 [RESOLVED] Powerpoint 2010: Randomly Display an image

    i have a presentation with 4 slides. Slide 1 contains a button with macro on click embeded to change visibility of images on slide 2 to 4.

    from slide 2 to 4 (3 slides total), i only have 3 images...
  4. MsOf10 ACCESS: How to add value from one table to other table automatically ?

    I have a table named tblfilm with fields like FilmName, ReleaseYear, Country, Genre

    i create a second table named tblFavouriteFilm with fields like FilmName, ReleaseYear

    i created lookup field...
  5. Replies
    6
    Views
    1,021

    MsOf10 Re: Access Adding multiples values at a time

    thanks pro Westconn1 , in the last 1 or 2 days i tried everything i know from append query, insert into statement event excel, it worked out in some ways but failed in other ways as well.
    is it ok...
  6. Replies
    6
    Views
    1,021

    MsOf10 Re: Access Adding multiples values at a time

    anyone knows something please ? i just want to enter 4 or 5 artists name (First Name, Last Name..), the same film name they took part in ( sometimes it's good to look up film name field if that film...
  7. Replies
    6
    Views
    1,021

    MsOf10 Re: Access Adding multiples values at a time

    can you give me an example Westconn1 ? i'm new to Access
  8. Replies
    6
    Views
    1,021

    MsOf10 Access Adding multiples values at a time

    i'm trying to create a database with access 2010 about Academy Award ( The Oscar )
    i have 2 tables , 1 to store information about artist ( actor, director, sound mixer, visual effect supervisor...
  9. Replies
    1
    Views
    846

    MsOf10 Re: Power Point: HTML object manipulation

    i did try to paste an range of cell with your code, it appeared to be a shape on PowerPoint slide.

    with a shape you can do something like this


    Public Sub PasteShape()

    Dim...
  10. MsOf10 Re: PowerPoint 2010 Array and Randomize

    Fantastic Logic. Thanks again
  11. MsOf10 Re: PowerPoint 2010 Array and Randomize

    My code with Select case worked , just the longer the range, the longer code i have to write

    i ask the above question for something like this ( 3 shapes on a slide, i want to show 1 one them at a...
  12. MsOf10 [RESOLVED] PowerPoint 2010 Array and Randomize

    i need to define 2 array.Array1, Array2. i use Randomize function to generate a random number between 1 to 3 and assign it to Array1. The Array2 will then contain 2 values ranging from 1 to 3 but not...
  13. MsOf10 Re: Visual Studio 2010, execute Windows Form

    anyone who encountered this problem before, MSDN just showed an example of custom task pane but not windows form and there is little help either in google or youtube for publishing add-in for MS...
  14. MsOf10 Visual Studio 2010, execute Windows Form

    i created a add-in for PowerPoint 2010 with a Windows Form in Visual Studio 2010. how can i run it. i tried to press F5 however my add-in just a Com Add-in and didn't show the Windows Form with all...
  15. Replies
    1
    Views
    881

    [RESOLVED] 2NF-Functional Dependency

    i have a table like this


    http://i469.photobucket.com/albums/rr60/rocker123_photo/2NF.png

    the primary key in that table is composite ( ECode + ProjectCode )

    my book says
    in the table, for...
  16. Replies
    3
    Views
    13,380

    Re: Open Adobe Reader from Excel

    dear strobinson1

    i've found an easy way to launch application within office.


    Private Sub CommandButton1_Click()
    Dim i As Double
    i = Shell("C:\Program Files\Adobe\Adobe Photoshop CS5...
  17. Replies
    2
    Views
    435

    MsOf10 Re: Random Number

    thanks seenu. it's not the variable declaration

    the real problem is strAnswer4 = 4 in my switch function.
  18. Replies
    2
    Views
    435

    MsOf10 [RESOLVED] Random Number

    i have a problem like this.

    Random number from 1 to 5. for each number is a corresponding string and display it though Msgbox function.

    Public Sub RandomAnswer()

    Dim strAnswer1,...
  19. Replies
    4
    Views
    692

    MsOf10 Re: String Replacement ?

    thanks seenu_1st. i actually thought of something like you but give up because i don't know there is a function called split

    thanks westconn1 again, your code is gorgeous, simple , complicated and...
  20. Replies
    4
    Views
    692

    MsOf10 Re: String Replacement ?

    for simpler string such as strMyString = "Array(,,O,R,,)". i nearly did it with the following code just a little bit wrong logic somewhere in the first character however i think i will fine-tune it...
  21. Replies
    4
    Views
    692

    MsOf10 [RESOLVED] String Replacement ?

    i have a string. let say

    strMyString = "Array(,Rectangle,Oval,Circle,,)"

    and i want my final result something like this

    strMyString = "Array("Rectangle","Oval","Circle")"

    i struggled a...
  22. Replies
    3
    Views
    524

    MsOf10 Re: Replace Function

    it's correct.Thanks westconn1

    can you explain why ",""" instead of ","".
  23. Replies
    3
    Views
    962

    MsOf10 Re: VBA Help font size

    up............
  24. Replies
    3
    Views
    524

    MsOf10 [RESOLVED] Replace Function

    i like to use the Replace Function to replace the mark comma (,) with the this text (,") however in VBA it seems that i can type my syntax like this.

    Textbox1.text = Replace(strMyString, ",",...
  25. Replies
    3
    Views
    962

    MsOf10 Re: VBA Help font size

    someone ..............?
  26. Replies
    3
    Views
    962

    MsOf10 VBA Help font size

    after entering VBA help system in Microsoft Office 2010 by pressing F1 in Visual Basic Editor, i try to change VBA help font size to make it a little bit more readable however, most of the time it...
  27. MsOf10 Re: PowerPoint 2010, add notes to many slides

    dear vbfbryce, i confirmed that your code work beautifully. For others who may encounter the same problem in the future as i do now, you just need to modify the shape named "Rectangle 3" as vbfbryce...
  28. MsOf10 [RESOLVED] PowerPoint 2010, add notes to many slides

    i have to add the same note to many slides. it's a pain just to copy and paste from slide to slide, i need some methods with VBA code to do this automatically (may be with the help of loop...
  29. Replies
    3
    Views
    13,380

    Re: Open Adobe Reader from Excel

    up , sorry but i don't know anything about your problem however it leads me to a new question for those who know , i create a command button (VBA form), how can i make it run another program like...
  30. MsOf10 Re: PowerPoint 2010 where does The Logic go wrong ?

    the answer may be this, men, code for deleting any effect applied to a specific shape ( in my case, a shape named "Rectangle")



    Public Sub TestEffect()
    Dim sldActiveSlide As SlideRange
    ...
  31. MsOf10 Re: PowerPoint 2010 where does The Logic go wrong ?

    i solved this problem myself men, thanks, let us look at a simpler example from this picture . in this picture i wrote code to delete all effect for a shape named "Rectangle"

    ...
  32. MsOf10 [RESOLVED] PowerPoint 2010 where does The Logic go wrong ?

    i have 3 shapes on slide 1 with some animations for each shape. it looks something like this
    http://i469.photobucket.com/albums/rr60/rocker123_photo/delete1.jpg

    i wrote code to delete all the...
  33. Replies
    1
    Views
    1,249

    MsOf10 PowerPoint 2010 Macro run at start up

    i have a presentation with macro inside it ( just display a message ).any time users launch this presentation ( say double click to open it ), i want that macro to run automaticly to display some...
  34. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    Thanks Spoo, nice code
  35. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    writing to a text file is fine Spoo, thanks
  36. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    i created my sub in PowerPoint 2010
  37. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    can any code (trapping error or some thing similar) tells which slide the above procedure get stop so that i can go there and check which shape is the problem, the error dialog is not friendly to...
  38. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    can you give me an example of FlexGrid, i have never heard of it before

    that's fine men, because my actual presentation contains all kind of shape, the test one is simple with a few shapes, i'll...
  39. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    one more question.

    the above code run fine on test presentation but not on actual presentation and it generated a message like this
    ...
  40. MsOf10 Re: PowerPoint Check what slide contains hyperlink then export to list

    I figured out something myself with this
    Public Sub TellHyperLinkSlide()
    Dim sldSlides As Slide
    Dim shpShapes As Shape

    For Each sldSlides In ActivePresentation.Slides
    ...
Results 1 to 40 of 84
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width