Results 1 to 6 of 6
  1. #1
    endlessd is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    3

    [Need Help ASAP] Form VBA Code

    Hi All



    I don't know why the VBA Code for my Form in Access 2010 always show up like this

    "Private Sub Command0_Click()

    End Sub"

    ^ This is only a simple Form which previews the report in the database

    I tried exactly the same thing with the file created by Access 2007, the VBA code shows up normally.

    It's driving me crazy since I got my ICT test tomorrow.

    Thankyou

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you saying your procedures are surrounded with quotes?

  3. #3
    endlessd is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    3
    Have a look at these screen shots,

    The only code that shows up is

    "Private Sub Command0_Click()

    End Sub"

    Which shouldn't be right.

    Screen Shots

    This is what I did: A simple preview report form

    http://img146.imageshack.us/i/23421848.jpg/

    This is the VBA code I get after clicking "View Code"

    http://img84.imageshack.us/i/92551044.jpg/

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So you are saying your Command Button wizard does not seem to be working, is that right? Have you already defined your Trusted Location?

  5. #5
    endlessd is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Posts
    3
    My command buttons does work perfectly fine.

    I disabled all the [Trusted] security part.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Well you have succeeded in loosing me there. Your Command Button works without any code in it?

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

Similar Threads

  1. Search Fields Queastion NEED HELP ASAP
    By Nelson12 in forum Access
    Replies: 9
    Last Post: 03-29-2010, 11:04 AM
  2. Access Database Problem: HELP required ASAP
    By maverick in forum Queries
    Replies: 1
    Last Post: 01-06-2010, 04:47 AM
  3. Need to map excel feilds to access database ASAP (will pay $ for help)
    By Steven Thibault in forum Import/Export Data
    Replies: 22
    Last Post: 12-27-2009, 09:37 PM
  4. Help me asap... I need this for my exam
    By freelance_jhoe26 in forum Access
    Replies: 1
    Last Post: 04-20-2009, 02:30 PM
  5. Query help needed asap!!
    By msaccess09 in forum Queries
    Replies: 1
    Last Post: 02-25-2009, 09:39 PM

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