Search results for query: *

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...

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

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 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...

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...

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...

I'm new to Windows XP Pro. I would like to stop the annoying auto logoff feature or at a minimum, lengthen the inactivity time so I don't have to keep logging on. I have searched help files on how to do this, but have been unable to locate the info needed. Can anyone point me in the right...

I'm having a problem with jpeg & gif files inserted into Access forms. The logos look fine before they are inserted but once they are inserted into an Access form the quality of the logo looks terrible. Has anyone else experienced this problem & have any suggestions?

I want to open a form showing certain records based on information entered by the user in a data entry form. There is a command button on a data entry subform which contains the open form code. I need to only present records based on two information fields - WorkDate & EmployeeID. Part of the...

I have a query that needs to select information based on a field entered by the user at the time of data entry. I receive the same error message if I use the query builder or format the SQL as a string. Can a variable be used in a query/SQL statement or is there another way to accomplish this...