Code:
TotalHours:DateDiff("h",[TimeStart],[TimeEnd])
Thanks for your answers..
jawbone
Last Activity: Feb 8 '12, 04:48 PM
Joined: Nov 9 '11
Location:
-
rounding time
This calculation is working great, but how do I round the total of this off in 15 mins intervals.
Thanks for your answers.. -
ok Mr Ross
im getting a run-time error 2103, :the report name you entered incorrect but i know its...Code:Private Sub Command151_Click() Dim strReport As String Dim strWhere As String strReport = "info" strWhere = "[maininfoID] = """ & Me![maininfoID] & """" DoCmd.OpenReport strReport, acViewPreview, , strWhere End Sub
-
print current report
hello educated friends
i have a question. i created a table name info. the primary key field is [maininfoID], i created a query from that table named it [info query], and a form from that query. On my form which by the way named [timesheet]i want my employees to enter data,then press the print button to print out a current report of the information that was just entered. report name is [yourcopy] i was told to use this event procedure... -
examle my time start is 11:00 and end time is 15.:15 im getting the answer 6 even thought we know that it should be 6hr15msLeave a comment:
-
i tried that sierra it just gave me a 0 for an answerLeave a comment:
-
ok how do i ask the function to give me hours, thats the only formula i know to get start time and end time to work.Leave a comment:
-
calculating time
help me with this. TotalTime:DateD iff("n",[starttime],[endtime])im getting mins instead of hours & mins. example" instead of 1.5 hr im getting 90. i know its something very easy to fix, but cant find it in Acess for Dummies. -
thanks NeoPa i change my datatype to DateTime instead of text and it calculated fine. Thanks for your time everyone.Leave a comment:
-
can i email you guys my dbf so you can see my problem, sorry im so dumbfounded.Leave a comment:
-
thanks Adezii it worked greatLeave a comment:
-
adding time
hello everyone, i have a problem that is probably simple to you to figure out. im using access 07 and novice as hell. I recently created a database form so that i can calculate my non-revenue miles for this transportation service im employed, unfortuntaly those particular hour i dont get paid for. Anyway i created a simple time sheet using military time. example. clock in time 13:00 til 15:00 which is 2 hours worked, but how can i get access to... -
That worked out perfect for my form, but maybe im not explaining the problem im having right. i want to add a button on my form that can access a report and print that report in a single form. filter that report so that it would only print the current record selected.Leave a comment:
-
thanks Adezii
that is what i want. so where do i include my form name and so onLeave a comment:
-
Printing Current Page on Form
Hell all, i really need some help.
I dont know how to use code at all, just started working with access07 for a month. Ive created a table name it freedom, i also created a Query from it named it freedom Query. and a report named new freedom. Here's the problem i have multiple clients on the form, but when i try to print the client info im currently viewing on my form on a report it prints all of the clients at once. i tried using a open...
No activity results to display
Leave a comment: