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.
View Replies
ADVERTISEMENT
May 24, 2007
hiya, just posted a message today.
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.
ANY help would be muchly appreciated.
Thanks Keith
View 4 Replies
View Related
Jul 7, 2014
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...?
View 14 Replies
View Related
Apr 8, 2015
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.
View 14 Replies
View Related
Mar 6, 2013
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
[code]...
View 9 Replies
View Related
Nov 1, 2012
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?
View 10 Replies
View Related
Oct 10, 2012
I have this following problem:
I want to program a textbox. In the expression builder of the properties sheet's control source I've programmed this following code:
=IIf([word1] Or [word2]=1,1,0)
It works. But I have to add 37 other "words" and I can not.
I tried:
=IIf([word1] Or [word2]=1,1,0) or =IIf([word3] Or [word4]=1,1,0) Or....
But it doesn't work.
View 5 Replies
View Related
Aug 2, 2012
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.
View 14 Replies
View Related
Dec 12, 2012
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!!!
View 12 Replies
View Related
Aug 31, 2014
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)
What file path would i use?
View 5 Replies
View Related
Jun 12, 2012
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.
View 4 Replies
View Related
Nov 9, 2012
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.
View 2 Replies
View Related
Oct 19, 2005
Hello everyone,
I just surfed in from google :)
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?
many thanks
john
View 7 Replies
View Related
Mar 26, 2008
Hello all,
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?
Thanks.
View 1 Replies
View Related
Jan 23, 2008
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 :(
View 1 Replies
View Related
Mar 23, 2014
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.
View 14 Replies
View Related
Aug 29, 2014
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?
View 1 Replies
View Related
Dec 10, 2007
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.
Looking forward to your replies
Regards
CD (UK)
View 3 Replies
View Related
Apr 3, 2013
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.
View 1 Replies
View Related
May 21, 2005
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?
Any help would be greatly appreciated.
Many thanks
Adrian
View 2 Replies
View Related
Nov 1, 2005
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:
User: Mr. Smith
Period Ending: 1/15/2006
Projects 1/1 1/2 1/3 etc. Total
XYZ 5 4 5 14
ABC 2 4 1 7
123 1 2 3
_________________________________
Totals 8 8 8 24
Don't know if the above will look ok so I've attached a screen print of part of our current timesheet.
Any ideas would be greatly appreciated as I'm not the sharpest Access guy around.
View 6 Replies
View Related
Mar 23, 2005
Hi,
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.
Thanks
View 2 Replies
View Related
Jul 10, 2007
Hi, Guys
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..???
Cheers
Tristan F
View 1 Replies
View Related
May 9, 2013
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.
View 14 Replies
View Related
Sep 22, 2014
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!
View 3 Replies
View Related
Apr 12, 2013
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
Table: PayRates
Fields: RateID, EmployeeID, HourRate, TotalHours
Table:WorkTimes
Fields: EmployeeID, PayPeriod, WorkDate, StartTime, EndTime, TotalHours
I'm not entirely sure if this is all correctly structured, it just doesn't look/sound right to me.
View 1 Replies
View Related
