Recent content by tpickrel

Thanks, I will see if I can get access to the dos command for the server, I dont work in the IT dept of my company, so This might be a problem, but I will try and see if this will fix it, thanks for your help again

Ill talk to the boss to see if we can disable the time clocks, but is there a way I can use the NOW() function from the server or a local station?

Hello Guys, thanks for your help in the past got a small problem I have created a clock in, clock out DB that sits on a server and has a link to 30 end users, they clock in when they come to work and clock out when they leave, however one of my smarter co-workers has learned to change his...

I hope that helps unless there is another way to format I tried to indent but it doesnt stay.

Hello I have a combo box (EmployeeTimeInfoSelectFrmEmployeeCmb) that has 3 values, 1. EmployeeID (Bound), Lastname, Firstname, When I select the lastname and enter the command to build a qry I get a parameter asking for the EmployeeID, When I Put double quotes around the combobox reference the...

Cool, the query sql string above is the problem. however the problem may be in that the records are stored in 2 tables. I have 3 tables, table 1 EmployeeID table it the Parent that connects the Time In table and the Time out table, The employee selects a radio button for clock in or clock out...

This is the query that takes the time in records from table 1, and compares to the time out records in table 2, hope this is what your looking for. sorry,after wasnt paying that close attention it was late. thanks SELECT EmployeeIdTbl.EmployeeId, EmployeeIdTbl.Lastname...

Private Sub LogInFrmLoginCb_Click() Dim TimeEntryFrm As Form Dim ID As Long Dim Idhold As String Static intLogonAttempts As Integer 'Check to see if data is entered into the UserName combo box If IsNull(Me.LogInFrmUserIdTxt) Or Me.LogInFrmUserIdTxt = "" Then MsgBox "You must enter a User...

Hello again Ive got a small problem with my clock in clock out DB I have 3 tbls, Tbl 1 EmployeeIdTbl has EmployeeId (PK), Lastname, Firstname, Password Tbl 2 TimeInTbl has EmployeeId (PK) TimeIn (Date Time Type PK) Tbl 3 TimeOutTbl EmployeeId (PK) TimeOut (Date Time Type PK) Everything...

Got the same problem here is the code it fails on Access 2007, trying to make command buttons visible when a form opens for certian employees and not others. Get a type 13 mismatch error. If Me.LogInFrmUserIdTxt.Text = "Drb00" Or "tep09" Then...

Nevermind fixed it, thanks though,

Hello I have a login form that an employee types his user id and password into 2 seperate textboxes, once the textboxes are validated then the login form closes and the time entry form opens, the value of the user id from the log in form is suppose to populate the time entry user id textbox...

Well I deleted the Pk from both fields and ran the code, however it now puts a value into the first field and leaves the datetime field empty, so I tried to put a default value into the first field so my query wouldnt have a bogus record and this doesnt help either, however you got me farter...

Ok Ill try it thanks

Thanks but still get the first field written over. My tables has 2 fields, both make up a composite key. The first field is the x58_Id text field set as the first primary key, then I have a datetimein DateTime Field. I can insert the first record but when I go to log in the second time with...