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 have developed a small hotel booking system which inserts records into a reservations table. The table looks like this: [ReservationNr][StartDate][EndDate][RoomNr]
I am now trying to add a constraint which prevents a room from beeing booked twice on the same day, hence the time period defined by StartDate and EndDate in a record must not overlap with another record. Is Access capable of adding such a constraint? It was easy to add a constraint that prevents a booking where the StartDate is before the EndDate, but this one needs to reference already existing records. Any help would be much appreciated.
I have a report whose fields are arranged in a table:
I need all fields to be able to grow in the event that there's more text than the box can hold, so I have all fields "Can Grow" property set to Yes.
However, when any of the top row fields (Field1, Field2, Field3) need to grow, the entire top row grow but the bottom row stays put and doesn't move down, which causes the top and bottom rows to overlap -- like below (look at ID # 4):
Green is the top row, Blue is bottom row:
how I can get the bottom row to move down when the top row grows?
I have made several extractions from back ups from our ERP system using maketable querys. Each time when I renamed the table after running the maketable query. I now want to add them to create one big table showing the records which I extracted. I now found that each time when I extracted from my back up tapes there was a little overlap in time which gives me double entries when I use an append query to add them al together.
Is there a way to set parameters which filter our double entries and only adds the unique records to this table?
I have an Access form that is tied to a recordset. When I Set Focus on 1 text box in particular, I move the caret with the keyboard arrows left-right, and the caret moves and flashes on top of the text characters, basically overlaps the character. When I then try to delete or edit the text, it moves the caret by itself to a different location in the text box and starts adding the text to that location. When I finally get the text how I want it, I set focus on another control, and it occasionally deletes random characters in the text box.
The only way I have been able to work around this is to copy and paste the current text into Notepad, edit it there, and then paste it back into the text box.
I'm trying to create a report that pulls from two tables [tblTelephony] and [tblSales]. All data in my query is limited to a date range entered through a form.
For every record in [tblSales] (showing the agent made a sale) there is a record in [tblTelephony] (showing all the stats for the agent's day worked). [tblTelephony] has one date for each record. [tblSales] has two dates for each record. The sales dates are the date the services were ordered (matches the date worked in [tblTelephony]) and the date the services were installed.
In order to get an agent's MTD Sales stats I have to query the date range on Install dates. MTD Telephony stats are run on the same date range on telephony date. Where I run into an issue is with the sales that are ordered before the date range in question and installed during it.
I've run a separate query to sum the sales installed during the date range and used that sales value in my Telephony query. In order to get my data to show as accurately as possible, I had to create a relationship between the Order Date and the Telephony date. I'm really hoping to find a way to force the sum of sales in sales query to show in the sales column in the telephony query, regardless of the telephony date range and without adding telephony data for dates outside the range.
Example: Date Range = 2/1/14 - 2/24/14 Telephony Date = 2/3/14 Order Date = 2/3/14 Install Date = 2/14/14 Appears on report
Date Range = 2/1/14 - 2/24/14 Telephony Date = 1/31/14 Order Date = 1/31/14 Install Date = 2/3/14 Does not appear on report
How to get the sale example on the bottom to show without removing the relationship?
I'm creating an equipment hire database, and I was wondering how I would not permit overlaps of equipment hire ie. equipment being borrowed before it is returned. I have a query that lists all bookings that overlap, but I am unsure of how to implement this into the table to prevent overlaps.
I have a form (frmMain) which has a header with some basic links and text boxes I would like to keep as a frozen pane on top as the user are scrolling down the detail section of the form. The detail section does include a subform if that makes a difference (frmhome). When going to Options>Current Database> tabbed documents, the form header stays frozen perfectly.
I however would like to use "Overlapping windows" as the form center aligns in the Access window instead of left aligning when using "tabbed". So either :
1) how do I keep the header frozen in "overlapping" or 2) how do I center align the form in "tabbed" view, as right now the form just wants to go as far left as possible in the full Access window.
I have a database consisting of two tables. One is "articles" and the other is "tasks". To put it simply, I would like to find how much time the article spends in tasks, but one article can have many tasks, and they often (but not always) overlap. Tasks have a start and end date field.
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 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.