Recent content by mtwildtrout

Thanks for your quick response! I'll give your suggestions a try.

I have the following code behind the OnKeyDown event for a command button in order to disable use of the Tab Key: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 9 Then KeyCode = 0 End If End Sub The form's Key Preview property has been set to True. After...

I put the code in the form events.

One question, how do you re-enable the Tab key after you move off the control containing the disabling code?

Thanks for pointing me in the right direction. I appreciate you taking the time to help. This code is exactly what I was looking for.

Can any suggest code to disable & enable the use of the Tab key?

Thanks for the suggestion, I'll give it a try.

I have a main form with one subform. When the form opens it sets focus on the Employee number. After entering the employee number, the next tab sequence takes you into the first tab field in the subform. After entering all information required by the subform, the very last field is a Save...

I'm not sure what you mean by references. Would this problem be avoided if I compiled the code, split the database & creat the FE/BE on the NT Network?

I created a time reporting application on my home computer for use in our office. Everything works as it should. I compiled the code with no errors on the home computer. I then split the database & created front & back end applications on the home computer. When I install the front & back...

Thanks Rolliee, that did the trick!

I'm having a problem with the Date() function not working when I install my Access application on a network. The Date function is used as a default value on my sign-on form. It works perfectly when I install the front and back end applications on a single computer. When they are installed on...

Is there a way to determine if a control has focus from VB code? I need to determine if a command button has focus so I can trigger some additional code. I would envision the code to be placed in the Before Update or Close event. Also, is there a way to know if the user has clicked the...

Bill, When I try to get to your site I get an error message that Host was not found. Is there a problem with the site?

I have a Main & Subform as a data entry form. An Exit button is on the Subform. If the user enters partial information in the form (main or subform) then chooses to close the form, the partial information is saved. I don't want any information saved if the Exit button or "X" close...