Search results

LOL...Is it something real stupid??

I think is: DateAdd("ww", -1, Date).....Thats 1 week DateAdd("ww", -2, Date)....Thats 2 weeks.

Why when I go to view the form I get a pop up that says enter parameter value.....Form!NameOfForm!NameOfCombobox???

I'm trying to build an unbound combo box that allows you to pick 3 options: Current Week, 1 Week Ago, 2 Weeks Ago. How do i calculate this? Say I have 3 months worth of records. When the user chooses 2 weeks ago - I want it to show 2 weeks ago from Now() and only that week.

I have a listbox and two buttons. ListEmployee, ButtonPunchIn, ButtonPunchOut. When the form loads all the employees show in the listbox. You have to select an employee so you can punch in. Once you select an employee and punch in, the ButtonPunchIn disables and the ButtonPunchOut Enables...

my form's recordsource is a different table that's linked called UsernamePassword But the table that the records get recorded to is Employees. So the ButtonPunchIn and PunchOut are in the form with the UsernamePassword record source but the time recordes goes into the employees table. So thats...

It gives me an error saying it can't find the field '|' referred to in my expression???

I have a Table (Employees) with the following fields: EmployeeID, EmployeeName, DateOfWork, TimeIn, TimeOut, and DayTotal. My form has a listbox (ListEmployees) and a ButtonPunchIn and a ButtonPunchOut. Everything is working. But what I want is to add to the ButtonPunchOut On click...

I put the code in and i get Run-time error '3075': Syntax error (missing operator) in query expression 'employeeId='. This is what I have: Private Sub ButtonPunchOut_Click() CurrentDb.Execute "Update EmployeeT set TimeOut=#" & Now() & "# where employeeId=" & Me.EmployeeID, dbFailOnError...

I have a form with a listEmployees (listbox), a ButtonPunchIn, and a ButtonPunchOut. When I select an employee from the listbox and click ButtonPunchIn the date and time saves in the EmployeesT. When I click ButtonClockOut I want it to update the selected employee in the list box. Can some...

yupp...it worked!! all i had to do was change As Long to As String. THANK YOU!!!

Im creating a punch in punch out system. I have 3 tables: UsersT(Where the name of all the employees are), EmployeesT(Where the data from that day is stored, punch in and out time), TimeSheetT(Where all the data is and only the administrator can go inn and change). In the form i have a...

Private Sub Button_In_Click() Button_ViewInfo.SetFocus Me.Button_Out.Enabled = True Me.Button_In.Enabled = False DoCmd.SetWarnings False DoCmd.RunSQL "insert into TimeSheet ([TimeIn]) Values (Now)" DoCmd.SetWarnings True End Sub

Why doesn't clock in and clock out save in the same line? For example, say i sign in with employee 3. When i click clock in it saves in TimeID 1 and when i click clock out it saves in TimeID2. I want it to save in the same line so i can add them up and have a TotalTime Field.

The TimeSheet Table is to store all the data. Which will include hours worked that day, that week, that month, etc. But Yeah, you're right, I'm going to just save everything into the TimeSheet Table...but how can i add the hours up using code. Like for example if the user clicks clock in the...

I have 2 tables: TimeSheet Table Employees Table The Employee Table is for when an employee clocks in and clocks out just for that day. The TimeSheet Table saves all the data (hours an employee worked) so when i make a report you can go back to whatever specific day you want to go back to...