General :: Program To Automate Timesheet Templates
Sep 13, 2013
I'm trying to make a simple program to automate timesheet templates. Each of our staff members work on a 4 weekly basis (week 1, week 2, week 3 and week 4). I currently use a word document with the template in and copy and paste it into the timesheet. The timesheets run from the 23rd of one month until the 22nd of the month after. The issue is the four weekly template doesn't fit the same every month so I am after an automated process.
I'm thinking of having forms to select a staff member and change their hours on the template, if you will, and then a button to create new timesheets where admin staff would just need to add the first date (ie 23/09/2013) and the timesheet would be made for each staff member and auto filled with the four week template.
My main issue is I'm not sure how to link the dates to the weeks in a table. I have attached a word template of my own hours.
Problem, ive got a work database which employees logon to and enter time against certain projects they have been working on. What i need is to somehow create some code that will look at each of the employees names and sum up there total time for the previous day. If this is less than say 6 hours of timesheets or even zero entries have been made, I want a pop up message to pop up as soon as they logon to the datatbase the next day and jsut mention they need to fill in there timesheets.
At the moment each person when they log on to the database has there name they logged in as, placed into a field (called "First Name") within form (called "Employee Startup Screen"). *** maybe use this as a way to identify who is logged on and when to run the code.***
Timesheet table has the following columns: Employee; Date; ProjectID; Timespent
PLEASE help im a noob at this and have tried using some code on a query that sums up the previous days times filter on a employee. When the "Employee Startup Screen" opens it runs the following code
Dim internal1 As Integer
internal1 = Me.SumOfTimeSpent
If internal1 < 6 Then
MsgBox " Less than 6 hours have been entered " & Chr(13) & " into your timesheet for yesterday. ", vbCritical, Title1
ElseIf DCount("*", Me.SumOfTimeSpent) <> 0 Then
end if
End Sub
----------------------------
BUT it doesnt work if no entries have been made on the timesheet as the query result is blank.
I have the following project that works as a timesheet manager:
Users enter in a form the employee name/date/hours worked/role/overtime (yes or no)/rate... on a daily basis. At the end of every week, they must create a report depending on the dates given in a query.
I have only one table (tbl_EmployeeHours) and a query to calculate the number of hours between two dates.
At the moment a report gives me all the information above (employee name/date hours worked etc..) but what I am trying to is a bit different.
I need Access to create a report (based on a date range given by the user) that would give me: per unique name, the number of normal hours worked in total, next column, the number of hours worked as overtime (rate 1.5), then, the number of hours worked as overtime (rate 2).
This means there are 3 different totals. For example, in the date range given, someone might appear twice but in the report he will appear only once with 3 different totals...
My guess:
I would say I need to create a different query for the 3 different totals (normal hours, overtime 1.5 and overtime 2). For each query you would need to ask the user to input the date range (which would not be so user-friendly I agree...). Then, I am not sure how access would create that list of names and combine the 3 different results from the queries...?
I have access database as FE and teradata and peoplesoft as BE. In access database, i have a table with 5 columns and around 50,000 rows of data. I need to create the pass through queries such that it selects the first row from the access table as a where clause and export the query results in excel format or access table. The query should then go to the 2nd row as a next where clause and append the results in the same excel sheet or table.This process need to continue for all rows in the access table.
I have encountered PC Lockdown when I tried this onClick Code. I am trying to post a data from MSAccess field into a specific cell in Excel. The Excel File is formatted already as document. It is submitted for Attendance records. But I couldn't find the problem and fix to automate it properly.
Code: Private Sub cmdRequery_Click() On Error GoTo Err_AttSum Dim xlApp As Excel.Application
I have a database for when our people are out in the field. The people will fill out large questionnaires that I want to import into our main database. How can I automate this?
I have made a program that can identify a entry in a field (ID) and change the quantity of a field. However, if can only identify numbers. I have the code as follows:
Code: Option Compare Database
Sub AddToInventory() Dim tb As DAO.Recordset Dim I As Integer I = 1 Do Until I = 2 On Error GoTo Canceled
[code]...
The "where ID2 = " only works with numbers. Is there anyway I can make this work with Strings? Basically, Find the string in a column and update the quantity.
I have been reading a lot about Access Runtime and the problems that occur when a runtime application is installed on a machine that already has a full version of Access. Any program that can be used to create an .EXE type file for an access application that will eliminate all of these problems? The cost of the compiler program is not a major concern if it works!!!
I have an access program and i want it to save a copy into a location... ive got it so it can save however - i want it to save to the current users documents folder (win 7)
I want to create a report for the Monthly cleaning plan of a hotel. For each day, how many rooms need new sheets, how many need new towels etc.
At this point I can generate a report for any given day.
This could be an example of what I want to achieve
Code: ------------ Date | Date+1 | Date+2 | Date+3 New Sheets 2 1 0 2 New Towels 1 3 0 1 Full Clean 0 1 2 0
"Date" is a date tat you can set, after which you'll get the following 30 days("Date+1","Date+2" etc)
I thought that a CrossTab query would give me what I want,but using the wizzard I can't get the result that I want. Haven't worked with crosstab queries before so maybe I'm doing something wrong, or maybe this isn't even possible with a crosstab query.
I am sending an email using SendObject. Sometimes it works, and sometimes it makes the computer freeze up with no error message. I have tried this with Outlook running or not running, seems to make no difference.
Code:
'The sub procedure below sends e-mail in response to a click on the Send button. Private Sub SendMessagesButton_Click()
'For Access, define some object variables and make connections. Dim myConnection As ADODB.Connection Set myConnection = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = myConnection
[Code] ....
I have added some MsgBox () to narrow down where it crashes. It is after 'Five' and Before 'Six'. On the line:
Set appOutlookRecip = .Recipients.Add(eMailAddress)
I am mystified as to why it works OK sometimes, and not others. The email address being used is valid.
I'm on a bit of an access learning curve and would like a little assistance if possible?
I created an access database for my uncle a year ago to deal with orders and delivery notes etc...
now he wants me to upgrade it a little, but i have no idea how..
What i want to do is:-
the database is quite simple in thought, really all i require is:
customer form (to add new customers) products form (to add new products and change stock levels etc) Create order form Job sheet form (same data as create order but formated nicer) delivery note (again same data as create order but formated nicer)
Currently when creating an order customers and products are entered manually which is very time consuming and prone to human error.
i would love to have a form that you can select customers & products from a dropdown list.
in the future i would like the stock levels to change as orders are raised but won't look into that till i've had a long read of some books
would anyone care to offer some advise? or link to a template?
I have an assignment that needs Access 2002 but I have Access 2007. The template I need is called the Mailing List Template. Is that available for Access 2007 or do I have to get a computer that has Access 2002?
Check around and can't find anything useful, more of a case of can't see the woods for the trees really :p but here we go:
I doing a very simple form which I want to output to HTML (directly), it work fine and is ideal for what I need but I want to use a template to alter the colours and add a meta refresh tag but I cant get it working.
Help file next to useless so I wondered if anyone can point me in the right direction - Is it a css file ? or can I use a html file ? I've tried with both but still no joy :(
I cannot create a db from a template in 2007, either from a local one, installed with the program, or downloaded. The online ones download with no problems, but as soon as I click on "create", I get the message: [QUOTE] "Template 'xxxxxxxx.accdt' could not be instantiated." it goes further to say "The table 'xxxxxxx' could not be read from the template file. The object may be in an unrecognized format or contain invalid data." [UNQUOTE]. I have read through everything I can find on here, and searched the internet repeatedly. Some places say that certain .dll files are not registered, but after downloading these files, I am unable to get them to register. I have uninstalled and re-installed the entire Office suite, and run the Repair tool 3 times, but to no avail. The files are stored in, and downloaded to, a Trusted location. Templates from 2003 will work, but not 2007. I'm at my wits end now.
I am working on a dataBase and I need to have it check if a set of tables exist based on the data of another table and if any do not exist create the table(s) based on a template. the caviat is that the data in one table are both names of tables and field in another.
Table1 has fields named 'first name' and 'last name'; the data in that field is for example Peter Adams, John Smith. I need to check on start that the tables named PAdams, JSmith.and so on exist, if not create them from a table template with fields 'vacation', 'personal', 'sick, etc. also i need to check on startup that a table named Department exist; if not, create it with fields named PAdams, JSmith and so on.... is that possible?
Hi everyone I am just about to start a database project for the company. The last one I wrote was over 10 years ago in Borland's ObjectPAL and has served us well.
After doing quite some research I have decided (well... almost) to use Access as the basis for the new project as I need the most efficient and 'slick' solution in the speediest time-frame (don't we all!).
The downloadable Templates from MS seem actually quite good as a starting point, but we would need to 'glue' them together to prevent replication of clients, prospects, employees etc.
Has anyone had any success with doing this? For example, we would need to integrate Marketing Projects; Customer Service; Sales Pipleine plus our own custome stuff besides modifying these standard templates.
I want to make a simple FrontEnd for my database for users to open reports to print them. I don't want them to mess with the linked tables or queries feeding into those reports. I want the front end to display a list of every report in the database that they can load up and use.
I'm using Access 97 and have merged the 'Event Managment' & 'Contact' templates. I thought that I would need to make 'Contacts' and 'Attendees' as the same table.
My knowledge is limited and attempts to change to 'AttendeeID' means I lose the ability to log 'Calls' to people.
Is there a simple way of combining the functionality of both databases given my limited ability in using access?
I've searched through this forum and found one thread that I thought would help me but have not heard back from the post I left requesting help so I thought I would try my luck here.
What I am trying to do is create a very simple timesheet for our employees to use. Basically we turn in timesheets twice a month - on the 15th and the last day of the month. Currently what we have is an Excel file for each user that has 12 sheets - one for each month with macros that print sheets for each half of the month.
What I've been assigned to do is shift our timesheets over to an Access database so that we don't have to recreate a new timesheet every year for each employee.
I have tables created for the users and the projects but can't really seem to figure out how I should create a table to hold the hours work for each day. In other words our timesheets basically look like this:
I am in the process of creating a timesheet for the office. So far I have a form with drop down lists to populate Officer name, Project, client and then manually type in the date and time spent on the project.
I am working on using a pop up calendar to enter the date and have several examples from other threads to work through but I am also wondering if it is possible to enter time in hours and minutes spent on the project? At the moment the officers have to add up the time and enter it in minutes but this is causing some difficulty as they have to think about it! Is there a way to enable Access to work in 60 rather than 100?
The second question is is it possible to keep the officer name and date the same for several records so they do not need to keep entering it for every project they do in a day. So that they could enter their name and date for the first record and then for all the others they can just enter time, project and client and name and date will remain the same as the original one, but then be able to change it if they are entering several days records at once?
Hope that makes sense as I am getting quite confused working through this, it is the first database I have built and I am pretty much teaching myself.
I'm building a simple time sheet database for a friend of mine.
I know that im going to have trouble checking there amount against the tax table and taking there tax out to finalise the amount they would actually get.
So basically im an intermediate access user, how would i get the database to do this when i press like a calculate tax button..???
My boss would like the Time Out field in my table/form to default to a PM time.Right now, when you enter Time In - it defaults to AM (ie: if you type in 9:00 - it enters 9:00AM, which is correct). But when you enter in Time Out field - it still defaults to AM (ie: if you type in 4:00 - it enters 4:00AM, when we want 4:00PM). We still want to be able to enter in AM times if needed. We just want that one field to default to a PM time.
I have a form for timesheet entry that has 2 subforms.
The main form has a combo box for selecting staff name and another for WkEnding date. The form is based on table "SELECT StaffRef, WkEnding, Status FROM tTimesheets".
SubForm sfTimesheets is based on table tTimesheets. The subform is linked by StaffRef and WkEnding. (This has been working for ages.)
Recently added second subform sfOnCall based on table tOnCall. The subform is also linked by StaffRef and WkEnding.
If the user has a timesheet entry for the date, then sfOnCall displays and operates ok. But if there is no entry in the timesheet table, the sfOnCall form doesn't show the appropriate entry from the OnCall table. - I did try basing the main form on a UNION of the 2 tables, but whilst the query showed the correct data when I ran it - all the controls on the form disappeared!
I'm creating a timesheet/check in system (log in when the person starts work so it logs it and when they log out it logs that also for the manager or someone with high power to see.) for a fictitious scenario for an IT major project but I'm not sure where to start!
At the moment I have a few tables that are like this.
Table: Employees Fields: EmployeeID, First Name, Last Name, DOB
