Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,472
    Provided Answers: 10

    Unanswered: Can't Create CreateReportControl

    I get this Error

    Run time Error 29054
    PMP can't add,rename,or delete the control(s) you requested

    Code:
    DoCmd.OpenReport "MAP_IT", acViewDesign
    
    Set rpt = Report_MAP_IT
    REPORT_NAME = rpt.Name
    rpt.map.Picture = Get_Image_Path(Me.cdbmap)
    MapHeight = rpt.map.Height
    MapWidth = rpt.map.Width
    MapTop = rpt.map.Top
    MapLeft = rpt.map.Left
    
    Set rpt = Nothing
    SQL = "Select * from Map where map.map ='" & Me.Combo12 & "'"
    
     Set rst = db.OpenRecordset(SQL)
        
        Do Until rst.EOF
            NewPlotY = ((MapHeight - (MapHeight * rst("plotx"))) + MapTop)
            NewPlotX = ((MapWidth - (MapWidth * rst("ploty"))) + MapLeft)
            Set TempImage = CreateReportControl(REPORT_NAME, acImage, acDetail, , , NewPlotX, NewPlotY, Me.marker.Width, Me.marker.Height) 
            TempImage.Picture = Get_Image_Path(rst("image"))
            TempImage.SizeMode = 1
            TempImage.PictureType = 1
            rst.MoveNext
        Loop
    Im trying place an Icon(s) on top of a Image I have in report.

    what am i missing
    Last edited by myle; 03-03-15 at 19:31. Reason: spelling
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 15
    What are the values of NewPlotX, NewPlotY, Me.marker.Width, Me.marker.Height when the error occurs?
    Have a nice day!

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,472
    Provided Answers: 10
    They are in twits and with in the range

    I thought that I recheck my maths and ok

    If a do a CreateReport It work as plan
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •