Echo On: "NO"

Apr 21, 2005

Where and how do I write in this code that is a command button to open up a form to set the Echo off. I know how to do it in a marco but not how to write it in VB code.

Below is the VB code for my "open form" button...

Private Sub LookUpOpenFormButton_Click()
On Error GoTo Err_LookUpOpenFormButton_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_Account"

stLinkCriteria = "[ID]=" & Me![LookUpAccount]
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "Switchboard Lookup"
Exit_LookUpOpenFormButton_Click:
Exit Sub

Err_LookUpOpenFormButton_Click:
MsgBox Err.Description
Resume Exit_LookUpOpenFormButton_Click

End Sub

View Replies


ADVERTISEMENT

Access Macro - ECHO Yes / No ???

Oct 20, 2006

As I can't seem to find another way to make Access add together two seperate columns of numbers (i.e in Excell it would be A2+B2 = ) I've created a macro of some 42 lines long that copies information from a form into a table, from where it's summed in a query and the results shown on another form. The macro "Steps" through the process without a problem and will rune through the process with "ECHO - YES" selected. However, if I select "ECHO - NO" the screen freezes (although from the "Bong" it appears the macro has finished running) with the tool bars at the top missing and only the initial form infront of the Database window, on display. I've left the computer (actually a couple of computers - a laptop, a high spec desk top and the works' networked computer) for up to 15 mins without anything changing. Once (I think) I was able to shut down the database using the normal windows red / white X button in the top corner of the programme screen, otherwise I've had to Ctl / Alt / Del to end the programme. The other strange thing seems to be that I can open and work other programmes while the Access screen is frozen so it looks as if the computer isn't freezing (The task manager CPU useage bar is only up to 15 - 30 % as well)
Any ideas what may be going wrong or how I can get round this? I'd perfer to be able to run the programme in the "ECHO - NO" state as one of the guys I'm building it for is blind and has his computer talking to him. It makes a hell of a racket as the macro runs in "ECHO - YES"!!!!!!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved