Search results for query: *

I have a database that keeps information about a user and their tasks performed for a manufacturing outfit. user table: Primary Key Employee Code Employee Name Title Dept Password Security Level LockedOut Present tasks table: Primary Key Assembly number Work Order Part Number Part Description...

I had a lot of success with this after readind "On Access" by Grover Park George. He builds an address database in access and on several of the chapters adds multiple subforms to the main form. He walks you through step by step. It was a really GOOD book. MistyWolf

I hope you have found the answer you needed. However, here is a way that I have accomplished this that seems fairly simple to me. I set up a setUserName and a getUserName procedure with a variable in a module I called GenModule as listed below. Private mstrUserName As String Public Sub...

I figured this out the other day when I was fiddling. This code will change the font name, font size, font font weight, and color so that the user can clearly see which button is selected when tabbing through buttons on a form. I also used it in text boxes to bold the text when the text box...

We have generated a report to track employee time by department and by date range. Each employees time is tracked within the dept and each department has a total for all employees. Finally, there is a grand total at the bottom of the report of ALL departments. My boss wants one of the...

I have an Employee data entry program that tracks multiple employees as they perform different tasks throughout the day. I want to be able to have a log of their attendance status throughout the day. The status being "LOGIN", "LUNCH", "LEAVE", "LOGOUT". I can set this up through a form/subform...

Here is the code: Public Sub setTableName(tblType As String, frmName As String) Dim rsTBL As DAO.Recordset Set rsTBL = CurrentDb.OpenRecordset("tblTableConfig", dbOpenDynaset) With rsTBL .MoveFirst .FindFirst "[FormsName] = '" & frmName & "'"...