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

    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 20:31. Reason: spelling
    hope this help

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    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,418
    Provided Answers: 7
    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

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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