Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Access Annnoyance


  • Please log in to reply

#1
rrush

rrush

    Member

  • Member
  • PipPip
  • 66 posts
This has been bugging me for a while. Whenever I'm working on a db in Access 2000 or 2003, if I try to edit the vb code and then run it from the editor window to test, I get a "run Macro" window popping up. Since the code I'm working on isn't a macro per se, I can't select it to run. In Word, I can do this and so test the code for errors or debug by stepping through, but Access isn't doing it.

Any ideas, suggestions?
  • 0

Advertisements


#2
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
im guessing ur trying to run specefic subs (subroutines)

this works thru all office apps

click anywhere inside the subroutine and then press run

sub test()

'clicke here *******

end sub



this should work

stu design
  • 0

#3
rrush

rrush

    Member

  • Topic Starter
  • Member
  • PipPip
  • 66 posts
That's what I'm doing, but instead of running, it brings up the choose macro box.
  • 0

#4
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
did you do this?

click anywhere inside the subroutine and then press run

ill look into it anyways
  • 0

#5
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
im using 200 and 2003

i tried it

in a module, in a sub,

click in the middle of the subroutine block
then press eitehr run or hit F5

this should work

if not then i do not know
  • 0

#6
rrush

rrush

    Member

  • Topic Starter
  • Member
  • PipPip
  • 66 posts
Attached are screenshots taken as I went through the steps. I know it should work, but this happens every time in Access. In word, when I'm working on forms using VB it isn't a problem.

Attached Files


  • 0

#7
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
in the second screenshot, i see you curser at the beginning of the sub routine

try placing utr cursor in the middle of the sub routine

ill keep working on this project

ill keep u informed
  • 0

#8
rrush

rrush

    Member

  • Topic Starter
  • Member
  • PipPip
  • 66 posts
I've tried from all kinds of postions within the subroutine. (Starting from error when debugging, editing routine and trying to run etc.) Always does the same @*#^ thing.
  • 0

#9
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
i dont have access to access 2000 or 2003 at this moment...
but i had a brainwave

have a macro that opens the main form of your project
or of any form when you run that macro

so create a new module called run_opencomplaint()

so code would be like

sub run_opencomplaint()

Form_Switchboard.Show

End Sub

Try this it may work

so everytime you wanna run this form u would have to run the corresponding macro(Module)

i dont have access bc im at school now
but ill try this out and try other stuff later

stu_design

Edited by stu_design, 03 May 2005 - 07:31 AM.

  • 0

#10
rrush

rrush

    Member

  • Topic Starter
  • Member
  • PipPip
  • 66 posts
I'm up to my neck in other user's problems today. Will try when I get time and let you know. Thanks.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP