Planning – Adding Time Management/registration
Dec 18, 2007
Hi all,
I’m adding a new function to our Costumer Relations Management system – Time management. Or maybe “time registration” is a better definition for it. The idea is that our consultants can add their hours into our CRM, either from the “Project”, “Tasks” or “Costumer” part of the CRM. Note: This is a tool to keep track of hours spent on a project, not a planning tool.
I’ve made the input-form for the records (Date, ClockStart, ClockStop, TimeSpent, InvoiceHours, etc.). But now I’m basically without a clue on where to start – I want to make a function almost like the calendar in Outlook, where the consultants can input what they’ve been working on, say between 13:00 and 14:00.
It doesn’t have to be fancy graphically, but functional and give a good overview.
Any ideas?
View Replies
ADVERTISEMENT
Jan 9, 2006
Hi all, I havent' been around in a while (toddler, work, getting my BS degree and new baby coming in a week and a half) so I am hopefully not asking a previously posted question.
I'm suspecting my new work isn't accurately paying for the hours worked. I made a quick simple DB where I input my punch times in short time format. There's the typical In, Out for Lunch, In from Lunch, and Out. I've got it correctly adding the times so that it reports the total hours worked per day, though, in order for it to display correctly, that total is in short time as well.
The problem is, when I group a week together, as soon as the sum of the totals reaches 24 or more, it goes back to 0, as it's on the idea that there's only 24 hours in a day.
Hopefully, it's just a formatting issue or is there a function to convert the times (or just the sum) to number of hours?
Thanks and Happy New Year to all.
-Jim
View 2 Replies
View Related
Dec 10, 2004
Hi,
I'm looking for some basic ideas on how to change the registration proceedure for my company's conference from a basically all paper endeavor to an online form.
Would it be relatively simple to put a form on our website asking for basic information (Name, Company, etc) that would output into an MS Access file? Are there technical issues / problems that would make this very difficult?
Thanks,
--Jim
View 2 Replies
View Related
Mar 13, 2007
Hi All,
I'm Looking for a bit of advise. I'm about to try and build a new database that will have about 40 tables. One of these will be the main table. This table will have a primary key TAGNUM and several other fields containing data associated with each tagnum. Most of the other tables will then contain more detailed info about each tagnum.
So the obvious aim is to have all these secondary tables connected somehow to the main table so that when a new tagnum is added/deleted, the corresponding row in any effected secondary tables is added/deleted also.
My attempts so far have involved setting up a relationship beween tagnum in the primary table and tagnum in each secondary table. This appears to work ok but I'm trying to be sure that my setup is good. I have a one to one relationship in each case, I have selected referential integrity, and the cascade changes etc. My join type is "All records from main table and only those... secondary table". Is this correct?
The further complication is that I need to have Lookup?? tables (not sure if it's the correct word) tied to each of the secondary tables and 3 tied to the main table. The user needs to be able to select items from the fields bound to these lookup tables via a dropdown box on the field in a query. When the dropdown box is selected a descriptor for each option available need be seen The non bound fields in the lookup tables only needs to be available to a report bar the showing of the Description field during selection. Any ideas?
Sorry about the size of this and annoying you with what is i'm sure not difficult stuff! Pretty new to this.:)
View 14 Replies
View Related
May 10, 2006
Hello im new to this forum and I just recently became involved with access so please bear with me and my many questions. I work for a mining company in Canada and we have training events. These records must be kept showing who attended and what was covered.
I have used the event template and contact template and merged them into one to I have a listing of all employees and their personal information. I have another table with events that say what was taught or shown and so forth. I am trying to figure out the best way to have them register for these events.
Right now I have right now a registration form that has the employeeID and the eventID. The problem is I would like to be able to use a list view and just select the people who attended and with the press of a button have all the registrations be completed dynamically. As right now for each person I have to create a new entry. Hope I was not too confusing, and thanks for the time. Patrick
View 1 Replies
View Related
Sep 6, 2007
Hello
I wonder if anyone can help me?
I am currently creating my first Access database and in the planning stage but have come across one problem area. I need to create a database that holds and reports on information recorded on a clinical form. The section of the form I am stuck on contains a table as below.
123456
Catheter Type
Wire Type
Balloon Type
Type of Stent
Size of Stent
Target Vessel
Successful?Y / NY / NY / NY / NY / NY / N
The user works their way down this form starting in column one but free typing what make of Catheter they will use and then type of Wire and so on. The problem arises when a particular item doesn't work, e.g. a type of Balloon. They then try a different type of balloon and would enter this information in Column 2 and then if this works go back to column 1 to fill in the next field 'Type of Stent'. As below..
1 2 3456
Catheter TypeCathsRUS
Wire TypeWire 1000
Balloon TypeBAL001 BAL002
Type of StentST555
Size of Stent10
Target VesselLeft side
Successful?Y / N Y / N Y / NY / NY / NY / N
Not only does the user need to record all this information without duplicating anything else from column 1 into column 2 but there are also instances that within the same procedure number, that a second bleed occurs and they need to fill in the next available column, which in the example above wiuld be column 3. They would again work their way down, but this time they may not need to use a wire as they can reuse the last one.
1 2 3 4 56
Catheter TypeCathsRUS OpCa34
Wire TypeWire 1000
Balloon TypeBAL001 BAL002 BA3
Type of StentST555 ST333
Size of Stent10 5
Target VesselLeft side Right side
Successful?Y / NY / N Y / N Y / N Y / N Y / N
The access database needs to be able to hold all this information and show that 2 separate episodes in affect have occurred. The user wants to be able to report on various things such as, what type of Stent/Wire/Balloon/Stent size is the most/least used / successful/unsuccessful? Etc
If anyone can help shed some light on the best way to structure this information in Access I would be very grateful!
View 4 Replies
View Related
Sep 16, 2013
My form forces the user to send an email to me when using the database for the first time.
I now have a registration number on the form that is hardcoded into each copy by me. It is held in (frmRegister.RegistrationNumber). I already have code to get the email to send but now ned to add the contents of this field to the email.
Code:
.HTMLBody = "<HTMLtags>This email confirms that a new user " & _
olApp.Application.Session.Accounts.Item(1).SmtpAddress & _
" has registered a copy of Gundog Manager.
The registration number of this copy is (frmRegister.RegistrationNumber)</HTMLtags>"
View 1 Replies
View Related
Jan 4, 2015
Before my registration form is submitted i have created a message box saying "would you like to submit?"
but it pops up as if it were to be an error message.. i will attach my coding and the pop up ..
View 1 Replies
View Related
Dec 9, 2004
Hello again,
I think my subject heading explains it. How would you add or subtract two short time formatted values and produce a short time value? Also, how would you change a short time value into number minutes. (i.e. 5:30 into 330) Thanks!
G
View 1 Replies
View Related
Aug 11, 2005
Hi guys
Quick question. im running a planning database which has got 3 tables Objectors, Representations and Agents. Ive put these together using a one-to-many join matching up the index fields from Objectors and Representations. Ive just constructed a form which has a main form being the Representations and the sub forms with Objectors and Agents. When I want to update or add records a message saying " you cannot add or change a record because a related records is required in table Objectors.
Can any one tell me how I can get around this or possible solutions to this is? Any comments or feedback greatly appreciated!
Cheers
View 5 Replies
View Related
Oct 14, 2005
HI THERE. IM HAVING A FEW PROBLEMS TRYING SORT THIS PROBLEM OUT. I HAVE A DATABASE IM TRYING TO APPLY A FILTER ON THROUGH AN UNBOUND COMBO BOX. WHEN SELECTING THE DROP DOWN FILTER TO SORT THE RECORDS NOTHING HAPPENS. THE CODE IM USING IS
Private Sub Combo??_AfterUpdate ()
'Find the record that matches the the control
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[WARD_AREA] = '" & Me! [Combo??] & " ' "
If Not rs.EOF Then.Bookmark = rs.Bookmark
End Sub
Does anyone know why this filter is not sorting through the records. Any comments much appreciated!!
Attached is the database
View 1 Replies
View Related
Apr 20, 2006
Hi,
If I have a time like 22:00 and I want to add lets say 300 minutes to it; so it now shows 03:00 how do I do this? I can do it in Excel alright with the TIME function but cannot find a similar feature in Access
Liam
View 1 Replies
View Related
Dec 29, 2006
I have a report that adds time for as many as six people. This isssue is when the time goes over 24 hours in total it drops the hours. The field(s) is formated in "short time" format.
Can anyone help resolve this???:confused:
View 6 Replies
View Related
Jun 14, 2007
Hi,
ive searched the forums for this but cant find anywhere.
how can i add one hour onto a time stamp please.
many thanks:confused:
View 4 Replies
View Related
Jul 29, 2005
hi
i've got a time duration field that is formatted as a string. I want to be able to sum up the durations as i group the records in different ways. I can't convert it to time, because it changes the durations to a time value, not duration example: 12:29pm instead of 0:0:21
is there any possible way to work with time durations??
thanks
*j
View 4 Replies
View Related
Mar 1, 2006
Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry.
I am wondering if this would cause a problem for the auto numbering for the ID field.
View 2 Replies
View Related
Jun 9, 2005
I wan to create a table with a date / time starting at a specific time and then added a number of records with each record being a minute later than the first.
The starting point could be hard coded or by user entry and the loop would run for a certain number of times .....
Any ideas on how to do it ..... poss a macro :confused:
View 3 Replies
View Related
Jul 5, 2005
Hi
Apologies first if there is an easy answer to this post as I'm new to Access.
I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track who did what and when.
Is there an easy way to code this?
View 3 Replies
View Related
Apr 28, 2005
My table, TblTYPE, will contain two field.
TYPE
DURATION
There will only be 7 records in this table:
FUS, 30 minutes
POS, 30 minutes
PRE, 30 minutes
NOV, 90 minutes
FUL, 90 minutes
ANN, 90 minutes
NPB, 60 minutes
1st question: How do I enter only minutes in the table for field 2?
------
I want the following to happen.
The end-user enters the start time and the type. As soon as the type is entered, field three calculates an end-time based on the start time and the type. When the type is entered, the minutes listed in field two of the type table are added to the start time (giving you an end time).
Can anyone help me?
1.) How to properly format the minutes in the original table.
2.) How to add the minutes to the original time in a query.
Thanks!
Scott
View 2 Replies
View Related
Aug 2, 2006
Can you help we have a data with a list of jobs that scores points, I need to build a query or scirpt that will add 5 points every 30 day fro the date the job was submitted this will help old jobs come the top of the list.
View 1 Replies
View Related
Feb 22, 2005
I want to calculate total hours and mins by adding a load of times (in time format) on a report. I've got the total number of minutes and converted this to hours : [txtmins]/60
Now I want to get the remaining minutes by using : [totalmins] - ([totalhours]*60)
However, how do I round DOWN the [totalhours] before it goes into the above sum. I can round it, but it always seems to round up.
If anyone has an easier solution let me know
Recall
View 1 Replies
View Related
Apr 2, 2008
I am trying to add hours entered in a short time format. For example 08:15 or 02:55. I also would like it to give a total number of hours beyond 23:00. Here is a table with a Name Column and Hours Column
Name Hours
BETTER,HEATHER 8:00
BETTER,HEATHER 8:00
BETTER,HEATHER 5:41
BETTER,HEATHER 2:35
BETTER,HEATHER 1:15
WILLIAMS,R 2:30
WILLIAMS,R 0:45
WILLIAMS,R 11:20
WILLIAMS,R 8:25
WILLIAMS,R 8:15
WILLIAMS,R 10:20
How do I
A) write a query to add up the hours. I believe Heather would total 25:31 Hours.
B) Show this same total in a report? In my report I had a Name Footer which showed "=Sum([hours])". Will this work once the query is right or will I use the "=Sum([totaltime])"?
Also, is it possible for you to respond in a SQL statement so that I can copy? Thanks.
View 6 Replies
View Related
Mar 11, 2014
I want to make a table where in I have to input atleast 10 numbers in one reference ID which there is a start time and end time.
A form with inputing one reference ID and then adding multiple numbers at once and saving the data with a start time and end time. Is it possible to capture the time for that specific reference ID?
How to do it or a sample tracker on measuring it.
View 14 Replies
View Related
Feb 24, 2014
Here is the table info I'm working with:
class status changeby changedate statustracking
INCIDENT-RESOLVED- Person A-2/20/2014 9:05 -
INCIDENT-RESOLVED-Person b-2/20/2014 11:57 -
INCIDENT-QUEUED-Person b-2/19/2014 13:57 - 01:24:08
INCIDENT-QUEUED-Person c-2/19/2014 15:21 - 19:29:58
INCIDENT-QUEUED-Person c-2/20/2014 10:51 - 01:06:00
I need to be able to add the statustracking time together per person per status (so person c would need 19:29:58 + 01:06:00 added together). Access keeps trying to add dates to the field or reconfigure the numbers to date ime or zeros if I use any of the data type other then Memo or text.
View 1 Replies
View Related
Feb 10, 2014
I can make the DATE picker work, but I need to add the TIME to the same picker. At least that would be preferred.
View 6 Replies
View Related
Mar 6, 2006
I'm exporting a query from Access to an ASCII text file. It is automatically adding a time stamp (0:00:00) to the end of ALL of my date fields. I would like it if it didn't do this...:D
View 1 Replies
View Related