Results 1 to 8 of 8
  1. #1
    jcor is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    3

    Error on command button wizard

    Hi,


    I believe it's kind a newbie question.

    When I try to use to wizard to create a command button to open a form, in the end of the wizard I get this error.
    "Method 'HyperlinkSubAddress' of object '_CommandButton' failed"

    Anyone know what is the problem here? I used to create this buttons with no problem, but now (for something I did, probably) can't do this anymore.

    Thanks in advance,

    Jcor

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    Tell us more of the specifics of the click event for the button. (show the click event code)
    Give us a description of the context -- is this for a web application?

  3. #3
    jcor is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    3
    Hi, sorry for the lack of context.

    It isn't any webapp, I just designed a form (that is my entry form) with several buttons and each of them call other forms.
    I don't have any code by myself, the wizard is supposed to implement the call of the form.
    What I do is Insert button > Form Operations > Open Form > select my form > next > next > select the button name > Finish
    Click image for larger version. 

Name:	error.jpg 
Views:	19 
Size:	67.2 KB 
ID:	12284
    The weird thing is that "before", yesterday or something, I was able to do this.

    I found something, don't know if has anything to do with it, but in my code (VBA) window, in references I have a name (Database4 that is differente of my application name (Database 0605). Maybe is ome inconsistency here?

    Thanks for any help,

    regards,

    jcor

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    I don't understand how the message fits the situation.
    "Method 'HyperlinkSubAddress' of object '_CommandButton' failed" sounds like some other properties or setting must be involved.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    It's not really unheard of for error messages in Access 'not fitting the situation!'

    Also, although we usually think of Forms, and even entire Databases, when we speak of corruption, Controls, such as Command Buttons and Comboboxes, can and do become corrupted, and seem particularly susceptible to this during app development. The test/cure for this is short and simple...delete and then re-create the Control.

    If a new button repeats the error, you'd have to think about the Command Button Wizard, itself, being corrupted.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    Yes Linq you are correct. We've all been through those partial corruption special features %x##@#!.
    Very likely some corruption in the making.

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Hopefully just that button, and not the Wizard!
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  8. #8
    jcor is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    3
    Hello, I tried several times, off course, and the error remains

    I'll create a new app from the scratch with the same functionality an will let you guys know if the issue remains. I believe it will not.

    regards,

    jcor

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-24-2012, 12:44 PM
  2. Error Import Command Button
    By kowen091010 in forum Access
    Replies: 4
    Last Post: 12-15-2011, 07:56 AM
  3. Command Button Wizard and Matching Fields
    By tylerg11 in forum Forms
    Replies: 5
    Last Post: 10-07-2011, 01:07 PM
  4. Command Button Wizard
    By cscobba in forum Forms
    Replies: 7
    Last Post: 01-26-2011, 04:43 PM
  5. Replies: 1
    Last Post: 07-27-2010, 02:27 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums