Recent content by StuGreentree

Worked like a charm. Thanks again for your assistance....

I am trying to determine the screen position of an Access 2000 form through API calls. I know there are several steps but I do not know the correct sequence, nor do I know the proper syntax to work in Access. Is there anyone who has done this that can provide some insight. Thanks...

I'm assuming that Option94 is a control on the form from which you are scrolling records. If so try this... Private Sub Form_Current() If Me.Option94 Then Me.frm_SubfrmEmpInfo.Visible = True Else Me.frm_SubfrmEmpInfo.Visible = False End if End Sub You can streamline this even more by...

Are you returning focus to the control that called the form, or to a different control???

Does anyone know a way to determine the Form.left, Form.top properties for the first form launched in the Access environment. I am floating a listbox over a subForm and I can determine the offset of the subForm from the Parent forms edges but not the offset of the Parent form from the edge of...

I am currently adding a visual & audible alarm to a form I have created. The alarm is event driven and I am searching for a way to turn it off. I have tried both the getKeyState and GetAsyncKeyState, but it will not respond to either except in Debug Mode. I have enclosed the general code I...

Playsound is a Windows API call using the following context... Private Declare Function PlaySound Lib "winmm.dll" _ Alias "PlaySoundA" (ByVal lpszName As String, _ ByVal hModule As Long, ByVal dwFlags As Long) As Long Therefore the first value is obvious "Pathstring &...

I am currently adding a visual & audible alarm to a form I have created. The alarm is event driven and I am searching for a way to turn it off. I have tried both the getKeyState and GetAsyncKeyState, but it will not respond to either except in Debug Mode. I have enclosed the general code I...