At the moment I am working a little project at work and am stuck on how to calculate departments due date based on actual order due date.
example:
OrderID: xxxxxx-xx DueDate: 10/8/13
Now let say i have 5 different departments but I want/need to know what should be the due date for each of those departments based on the due date on top.
I have a form open with a Text box displaying todays date, I have used the default Date().
If the user leaves the form open over night the date is still set to yesterday, any ideas how I can refresh the default? I want to refresh just that object nothing else.
I have a field that works out the difference in time between two fields. However, whenever the end time goes past midnight, it calculates the difference as a minus figure. I understand that this is because of the date issue, but I cannot seem to find a way around it.
Here is what I have so far:
time_of_referral field. This is the start time. It is a short time field that is filled in by the end user.
time_of_arrival field. This is the end time. It is a short time field that is filled in by the end user.
Text31 field. This is not visible to the end user, and has the following control source =DateDiff("n",[time_of_referral],[time_of_arrival])
Text33 field. This is an unbound text box with the following control source =[text31]60 & Format([text31] Mod 60,":00")
This works out the time difference and presents it as hours and minutes.
I have seen solutions that add a day to the end time, but unfortunately this does not work when the end time DOESN'T go past midnight. Some will go past midnight, some won't.
I am trying to execute query every midnight at 00:05 and append data into a table. This query reads the data from a linked table and appends the records into the local table.
Access doesn't triggers so I have no clue which way to proceed.
Can anybody help me creating a logic to execute query at midnight?
We use a device called a site master to test frequency levels across a system. This device stores plots onto graphs which are then downloaded onto an Access (95) database. When the plots are captured before they are put into the database they are time and date stamped among other things. When I open the Database in access I can go into the fields and physically change each of the dates. Yet when I use the site master software to open the database the Time and Date stamp appear at the bottom as the original values and not the changed values that I have assigned. Also when you right click the plots table and go to the properties. The created and modified dates have stayed as the originals. What I would like to be able to do is adjust this date. And what I would like to know is this possible??? Is it like a Windows File 'System' that is giving this date or is it a function in Access that can be changed?
I have a query that sums downtime on equipment. The problem that I came across is that there can be multiple status items open up on the same piece of equipment. When the restored time on one status item occurs after the down time of another, the query still adds the total down time of both status items which is giving me greater downtime than there actually is.
I work for a chemical company, over the course of the day there are 2 shifts, one from 07:00 - 19:00 and the other from 19:00 - 07:00. I want to measure the amount of time a piece of equipment has been offline for, and Sum these times for each shift, these pieces of equipment can go offline multiple times per day which is why I need the sum function. The fields I currently have are:
[Date1] : The date at which it went offline [Time] : The time at which the piece of equipment went offline [Duration] : The length of time it was offline for
For each day I wish to sum the offline time in two fields called:
[Shift 1]: The previous nights shift (between 7pm the day before and 7am that day). [Shift 2]: The days shift (between 7am and 7pm that day).
Where to begin but the logic should be something like:
[Shift 1] = Sum of [Duration] For(([Date1]-1 and [Time] between 19:00 and 23:59) And ([Date1] and Time between 00:00 and 07:00))
[Shift 2] = Sum of [Duration] For([Date1] and [Time] between 07:00 and 19:00)
I currently have two tables storing all this data, one containing [Date1], and another containing the breakdown information such as [Duration], [Time] etc. They are linked by the [Date1] relationship. The reason for the first table only having the [Date1] field is because it is a Main Form which contains various sub-forms.
I am trying to build a query that depending on the value stored in a combo box called SHIFT, either lists all the entries that have been made by our dayshift (07:00-19:00) or our night shift (19:00-07:00)
Each of these components work if I seperate them out
IIf([forms]![FRMFRame74]![SHIFT]=1,Between #07:00:00# And #19:00:00#,Between #19:00:01# And #23:59:59# And Between #00:00:00# And #06:59:59#)
I have a database that keeps track of training hours for each employee. The Training Length is formated as Short Time. I just figured out that short time can only go up to 23:59:59. Some of my trainings will be over that. Does anyone know a way to get around other than splitting up my hours and Mins in the table?
Need to loop .wav file three times. (See "Sound") (Not tagged in origional code.)
Private Sub Address_Exit(Cancel As Integer) Address.BackColor = 16777215 On Error Resume Next
'If there is no matching record in communications do nothing. If IsNull(DLookup("[address]", "communications", "[address]='" & replacequote(Me![Address]) & "'")) Then Exit Sub End If
'Make button visable and activate alert beep. Command1796.Visible = True
PlaySound "H:GeneraldmediaBEEP_FM.wav", ByVal 0&, SND_FILENAME Or SND_ASYNC
Just practicing at the moment, but i have a query that stores durations in hoursminutesseconds
Anyway i want the query to add these times up and give me a total. For example 01:00:00 and 01:00:00 would total up to 02:00:00. Hoever when i use the sum function within the query, i get 0.0833333333333333.
Any idea why and do i have to format the field within the query to recognise it as a Time and not a number?
Worked Hours: DateDiff("h",[Start Time],[Finish Time])-[Breaks]
Start time and finish time appear as hh:mm and breaks is stored as a decimal i.e. 15min is 0.25, 30min is 0.5, 1 hour is 1.
The expression works fine when e.g Start 07:00 Finish 17:00 with breaks as 30min(0.5) gives the correct value of 9.5 hours worked but if the finish time was say 17:30, rather then show the correct value of 10 hours worked, it shows the wrong value of 9.5.
Could someone please tell me where I have one wrong and how to sort the problem, or offer me a different solution.
I am really new at access 2003 and queries s forgive me if this question is really dumb/simple/confusing...here goes
I created a query where I ask the user to provide the info for the date range..<[Before date]
it worked fine.
I then added something to the database and ran it again and it now asks me for my date not once, but twice..i then copy and paste query with a new name and it asks me for the same info 4 times
ok so im not sure how to explain this but ill give it my best shot.
I have an excel sheet that has a list of order info. heres a sample of what it looks like:
70144:37.0Starting order split <34010993;01>gregory_pm34010993 70245:16.0Script complete for <34010993;0106>Rx <24073318>gregory_pm34010993 70103:37.0Starting order split <34010995;01>knox_br34010995 70204:26.0Script complete for <34010995;0101>Rx <24239630>knox_br34010995 70126:49.0Starting order split <34011015;01>flander_ar34011015 70232:09.0Script complete for <34011015;0101>Rx <24008174>flander_ar34011015 70134:01.0Starting order split <34011015;01>flander_ar34011015 70127:08.0Starting order split <34011061;01>flander_ar34011061 70227:26.0Script complete for <34011061;0105>Rx <24240139>flander_ar34011061 70227:55.0Script complete for <34011061;0103>Rx <24240083>flander_ar34011061 70152:00.0Starting order split <34011173;01>parker_tp34011173 70252:46.0Script complete for <34011173;0101>Rx <24071140>parker_tp34011173 70103:35.0Starting order split <34011369;01>sexton_pa34011369 70204:00.0Script complete for <34011369;0101>Rx <24240569>sexton_pa34011369 70149:02.0Starting order split <34011668;01>knox_br34011668 70250:59.0Script complete for <34011668;0104>Rx <21441348>knox_br34011668 70134:20.0Starting order split <34011764;01>hicks_jo34011764 70234:44.0Script complete for <34011764;0102>Rx <22787965>hicks_jo34011764 70235:06.0Script complete for <34011764;0101>Rx <22787933>hicks_jo34011764 70236:11.0Script complete for <34011764;0103>Rx <22788283>hicks_jo34011764 70156:45.0Starting order split <34011855;01>knox_br34011855 ______^this line is the time
ok so here is my problem. I need two records, one for the start of the order(the earilest time) and one for the closing of the order(the latest time). I also need the time inbetween the two.
Hi again everyone, With help on my first question Ive now got my cascading combo boxes working to a stage that shows all the information I need,
Currently Ive got 4 cbs and they work bring in and updating depending on what is selected in the previous etc etc.
combo1 = 2 combo2 = 5 combo3 = null combo4 = null
how can I tell it to use combo2 since there is no values selected in 3 and 4
Ive currently got the combo boxes in a form of their own, basically in my main form Id like to be able to click on a button to update a value, and then it will bring up the form for the combo boxes, then id select the values till I had what i needed, and then it would fill in the value on the main form with my selection from the combo boxes,
to make it abit harder, on the main page, there is 3 values that will need to get their value from the combo boxes, will that just mean I have to make 3 forms with the combo boxes in them, one for each of the values on the main page, or could I just have one form and maybe put a button saying (Use this Selection for Value 1)(Use this Selection for Value 2) etc etc.
Ive looked through the net alot and cant seem to find any examples that suit my question... but if anyone knows of a good example that would be awesome.
I have my data updated 3 certain times in a day. So i dont want to bother opening the same access 3 times a day. That access can be opened whole day no problem for me. So, how to run macros automatically in a time which I determine before ?
i am unsure as to whether this can be acheived in a database..
basically this task is almost calendar like.
the company operates 7 days a week. i have a table of company drivers and each has their own driver ID.
my user would like to store what time each driver comes into work each day and what time each driver leaves. this needs to be quite flexible however because some days certain drivers wont work, but each day..if a driver has a 'come to work' time then they will for sure have a 'leave work' time.
each driver also pays rent to the company once a week. within this calendar like system i would also like to store on what day the driver paid what amount towards their weekly rent.
i cant quite imagine how this can be done in a database. but if these kind of applications are common, i would be most grateful for some direction.
thank you.
one more thing..
i would also need to record during each day what time the driver left and returned from lunch (sometimes our drivers leave for a few hours during lunch time)
i want to store this because if they miss a job while they are on an extended lunch break im gonna roast em.
I have an access2000 db. Many tables, forms, reps ect... at random times it will just close. Don't know why. No errors, no reason why. It just closes. Is this common and is there any fix?
