Queries :: Shows Time Slots (4) Available In A Row During Day
Sep 20, 2014
I have a mismatch Query that shows time slots available during day that have not been booked (15 minute intervals) the problem I have i want to just show the time slots that are available depending on what treatment has been chosen so if it was a one hour appointment then it checks that 4 slots available in a row and just displays that
Available
11:00
11:15
12:00
12:15
12:30
How I would try to do this
12:45
13:00
13:15
13:30
so would show for a 1 hour appointment
12:00
12:15
12:30
View Replies
ADVERTISEMENT
May 16, 2005
I have a flexigrid control which shows 15 minute slots throughout the day. I have a table with timeslots in (start time end time). I need to shade in my flexigrid cells depending on whether on not that slot has been filled in. (booking time twice or more IS allowed)
Whats the best way to do this, do i read through each timeslot record and work out which cell it starts in and which cell it fineshes in - then shade the cells in beween?
Or is there a more efficient way?
Paul
View 3 Replies
View Related
Jan 24, 2012
I would like to design and build a database that can match one to one meetings between companies with specific time slots.
For example, we have two sets of people: buyers and sellers. A buyer could specify which sellers they would be interested in meeting. The database would then work out which buyers could meet with which sellers, and when.
View 5 Replies
View Related
Oct 20, 2014
The recordsource is a query with over 6,000 records. The form currently lists the records in datasheet format with header and footer for things like buttons and filtering. The client wants to be able to go from page to page of the souce query, showing 100 records on the form at a time.
But at the same time, they should be able to filter or sort the data source in it's entirety. The person who created the form came up with what seems like an awful solution to the problem. It seems to use a random number generator to determine how many records to portray at a time. I see this in the code as well as in operation, because the number of records on page to page varies. It doesn't even start out at 100! Worse yet, using a sort on the page only sorts the records that are visible.
View 9 Replies
View Related
Aug 21, 2013
i have a combo box ,and when i should select "all",this button after update code should show me all the column of table test ,but looks like for no reason the record set shows nothing and its not working.
Code:
Private Sub cboTaskListName_AfterUpdate()
'On Error GoTo cboTaskListName_AfterUpdate_Err
Me.Refresh
Dim db As DAO.Database
Dim SQL As String
Dim rs As DAO.Recordset
If Me.cboTaskListName = "111111" Then
Set db = CurrentDb()
SQL = "SELECT no1 from test"
Set rs = CurrentDb.OpenRecordset(SQL, dbOpenDynaset)
End If
End Sub
View 1 Replies
View Related
Dec 4, 2014
I hve a query that I want to total soldAtPrice *quantity This information is stored in my order details table and mus not change .I can do a calculated field to get the answer but the Problem is if there are 2 recodrs to be totaled the query displays 2 records if there are 3 records the query dislplays 3 records and so on .I need one record to be displayed with the total of all the recodrs
View 3 Replies
View Related
Sep 17, 2014
I have an Access 2010 table which shows Latitude and Longitude. However instead of it being in a decimal format it is displayed as 4000000000. I need to add a decimal point so that it looks like 40.00000000. If I configure the Field Properties to Decimal with a scale of eight and decimal places set to eight I can manually convert all of the data to the correct format. But I would like to have this happen automatically from a query.
View 4 Replies
View Related
Jul 18, 2013
I am trying to create an Access database where I can let the employees enter their time-in and time-out, at the end of their shift. I already created this function working, but running into another issue. Everyday, employees need to enter a break. Sometimes they take a break and sometimes they don't, if they work shorter hours. Thus, the break is not a default 30min and has to be enterd by the employee.
Below is the code I have to calculate the total hour:
txtCalcTime has the below code in control source:
=Int([CalcTime]/60) & ":" & Int([CalcTime] Mod 60)
Control source for this form "FrmTimes" property, in which Txtcalctime resides:
QryTimes
"QryTimes" query has the code below:
SELECT TimeID, TimeIn, TimeOut, Brake, DateID, DateDiff("n",[TimeIn],[TimeOut]) AS CalcTime
FROM EmpTimes;
This shows the total number of hours worked. But how can I make it to substract the break time entered by the employee in "txtbreak" on FrmTimes
View 12 Replies
View Related
Nov 3, 2014
I have finger print machine and i already connect to it and get all log.then i tray to get data and here is the code that im using
SELECT Format(CHECKINOUT.CHECKTIME,"dd/mm/yyyy") AS CDate, IIf([CHECKINOUT.CHECKTYPE]=I,Format(CHECKINOUT.CHECKTIME,"hh:nn:ss ampm")) AS StartTime, Format(CHECKINOUT.CHECKTIME,"hh:nn:ss ampm") AS EndTime, USERINFO.USERID, USERINFO.Name, CHECKINOUT.CHECKTYPE
FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID=USERINFO.USERID
WHERE (((Format([CHECKINOUT].[CHECKTIME],"dd/mm/yyyy"))='10/04/2014'));
how i get end time due to CHECKTYPE]=O
View 1 Replies
View Related
Oct 9, 2014
I need a Select Query to display data on a form. When an order is appended to my table the field named Printed is updated with the time it was appended. When my form opens it needs to display the field Printed and a field I call MinutesFromPrint. This field needs to display the total minutes elapsed from the time in the Printed field to the current time. My expression is not working.
MinutesFromPrint: DateDiff("n",[Printed],Now())
Here are a couple of samples of my results when I run the query at 7:49 A.M.:
Printed MinutesFromPrint
2:35 60366554
5:07 60366402
View 11 Replies
View Related
Mar 13, 2014
I have a database with date and time each stored in a separate field. Now I want to query the database based on a start date/time and an end date/time. I started with the code below but it only returns events within the same time range on each day when what I really need is every event from a specified date and time through a specified date and time.
SELECT myTable.ID AS myTable_ID, myDate, myTime, FirstName, LastName
FROM Staff INNER JOIN myTable ON
Staff.ID = myTable.StaffID
WHERE myTable.myDate >= #3/2/2014#
AND myTable.myDate <= #3/3/2014#
AND myTable.myTime >= #8:00PM#
AND myTable.myTime <= #11:00PM#
ORDER BY myDate desc
In the above example what I want is every event from 3/2/2014 8:00PM until 3/3/2014 11:00PM. But what I get instead is every event between 8:00PM and 11:00PM on 3/2/2014 and every event between 8:00PM and 11:00PM on 3/3/2014.
View 4 Replies
View Related
Jan 18, 2006
I have 2 cascading combo boxes which control what appears in my subform (AuditYear,Company).
Once I select both, sometimes the subform info shows up and a while later I try again, and it doesn't. Then I try some other AuditYear + Company, then THAT shows up...then I try again, it doesn't.
Any ideas?
View 2 Replies
View Related
Mar 22, 2006
I just added my third record to my new form and it is gone. However, it shows up in the table. I think it is because there are two record selector bars on my screen. I have two subforms and each one has a record selector bar on them and then there is an additional bar at the bottom that is like for my main form, which is blank. (I don't use the main form. I just have subforms over it.) I think the second record bar is goofing things up? And where is my record I just added. It only shows as two records total. Should I get rid of the subforms record selector bars?
View 1 Replies
View Related
Mar 31, 2015
I am getting 2 problems what I am trying to do is depending on the user logging in I want to open form (Aform) on specific record for that person ID. However where Y=1 I am getting a popup asking for AForm ID and where Y=2 I am getting run time error 3075 Syntax error (missing operator) in query expression.
Code:
Private Sub Command6_Click()
If IsNull(txtUsername) Then
MsgBox "Invalid username"
Exit Sub
End If
If IsNull(txtPassword) Then
MsgBox "Invalid password"
[Code] ......
View 1 Replies
View Related
May 23, 2006
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still shorttime but when you read the time within the code it comes out in AM/PM format. Also, when the defaul tiem should be #20:00:00# but this changes to #8:00:00 PM#
Weirdly though, when you just open the table, the times are in the correct shorttime format.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Any ideas?
This screen shot may help:
View 2 Replies
View Related
May 23, 2006
I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network.
The link works fine but the time formats are different.
On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format
However on PC 2, opening the same database via the network, the time format is still short time but the format is in AM/PM or medium time.
Guessing, it must be a setting within the main core of Access 2003 that is different between the 2 instances?
Any ideas?
View 1 Replies
View Related
Sep 4, 2006
On one of my queries, the dataset is shown with a * as the last record.
There's nothing in it apart from blank data but it is appearing on my forms.
All my other queries do not seem to have this.
Is there a setting to stop these from appearing ?
View 1 Replies
View Related
Jun 14, 2005
I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value.
Also another form running has the same subform and it and the updated value is shown perfectly in this one.
Anyone know why this may be happening?
View 2 Replies
View Related
Aug 19, 2005
I wondering if anyone knows of an automatic way that changes can be tracked on a form.
Ex. The last time a record was updated in that specific form
View 2 Replies
View Related
Oct 26, 2005
I have a form with a subform which has a listbox on it which lists all the letters sent home to a student. However despite the subform being linked by admission Number the list box is showing all records and not just the ones associated with the student.
I know this is going to be really obvious but please can someone tell me what is wrong?
View 14 Replies
View Related
Mar 7, 2007
Hi i am trying to delete all my queries in one go, is there an easy way to do this using a macro, module please?
View 2 Replies
View Related
Jan 3, 2007
I have the following feilds in a query: Timein Timeout
I need a subtotal feild that totals the two across midnight
I also need a Lunch feild
Then I need a total feild with the subtotal and total subtracted
I tried using this expression please help anyone if you can
Format([Timein] -1 -[Timeout], "Short Time") this created my subtotal feild
then I had a made lunch feild with 30 mins of time into it
then i tried Format([subtotal] -1 -[lunch], "Short Time") and called this one my total box.
The first one worked the second reported an error. Please any suggestions??
View 3 Replies
View Related
Mar 8, 2007
Hi i am trying to delete all my queries in one go, is there an easy way to do this using a macro, module please?
View 1 Replies
View Related
Nov 27, 2014
Ive found alot of reference to using dates to find records but not time, I need a query to pull up records entered on that day before lunch time and another query will pull the records entered after lunch.
receipt date is date/time field
receipt time is date/time field
to get records for that day i use date() which works but cannot get the time part to work??
View 12 Replies
View Related
Aug 4, 2005
Hello,
How would I go about in making a command button bring up a report to show a result of items for the end of the month?
For example, when a user clicks on this button it will bring up a report showing all the items that are out of date for the end of the month. I am having problems with the query as for months have different lengths e.g. 28/29/30/31 days. How would I make a query show the end result for each month correct as February if going to be different each time i.e. when it is a leap year. I have got far but having trouble with this part.
Hope you can help.
View 3 Replies
View Related
Feb 9, 2006
I know this is probably posted in a dozen places, but I don’t think I have the smarts to find stuff with the search.
I use the results of a combo box for the criteria in a saved query. Can anyone tell me how to make it show all the record if no selection is made?
Thanks again Folks,
Joe
View 2 Replies
View Related
