Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Data Form and Macro!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey there, hope u guys/girls can help me!
    Im having a problem, Im trying to add a macro to open the data form but I keep getting run time error '1004', so I click debug, and it all looks ok, can anyone help me?
    My VB code looks like this
    Sub adddel()
    '
    ' adddel Macro
    ' Add and Delete Stock from Shop_Stock
    '

    '
    ActiveSheet.ShowDataForm (It tell me the problem lies here!!)
    End Sub

    Thanx
    Rutter

    [ This Message was edited by: Rutter on 2002-04-24 07:20 ]

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ActiveSheet.ShowDataForm (It tell me the problem lies here!!)
    End Sub
    I think it should be:
    NameOfYourDataForm.Show

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    no I want to open the data form avalible in excel, through the options menus Data>Form

    Anmore ideas mate?

  4. #4
    New Member
    Join Date
    May 2002
    Location
    NYC
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    it's a bug, check out
    http://support.microsoft.com/default...;en-us;Q213835
    for a workaround

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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