473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Show time in scheduler?

Hi!

On a form I have a calendar control that user can click in order to
make a contract for a customer. The form also contains a listbox that
will be refreshed and show all current contracts.

What I try to obtain is showing all times for the day - empty or
occupied, not just those that are made, like:

06:00
06:30 Mr. Doe - repair tyre left back
07:00

Is there a way to make this happens with the listbox control in access
2000? This way it looks nicer to the user of the application :-)

By the way...I have a table - tblTimes - which holds all the times to
be used for the scheduler.

Jul 5 '06 #1
2 1383
You do realize that we can't see the structure of your tables, right?
Well, we could if you'd move a little... Based on the information
provided, my guess is that you need to outer join the two tables
TimeSlots and Appointments or whatever. (All records from time
Slots)...

Jul 5 '06 #2
pi********@hotmail.com skrev:
You do realize that we can't see the structure of your tables, right?
Well, we could if you'd move a little... Based on the information
provided, my guess is that you need to outer join the two tables
TimeSlots and Appointments or whatever. (All records from time
Slots)...

Structure: TimeSlots->Appointments

Query in code (Form_Open):

With Me!lstTimeEnter
..RowSource = ""
..BoundColumn = 1
..ColumnCount = 6
..ColumnWidths = "0cm;0cm;5cm;2,25cm;2,25cm;1,75cm"
..ColumnHeads = True
..RowSource = "SELECT tblApp.AppID, tblCust.CustID, tblCust.Name,
tblEmployee.Initials, tblApp.MyDate, tblTime.Time " _
& "FROM tblCust " _
& "INNER JOIN (tblEmployee INNER JOIN (tblTime INNER JOIN tblApp ON

tblTime.TimeID = tblApp.TidID) ON tblEmployee.EmployeeID =
tblApp.EmployeeID)
ON tblCust.CustID = tblApp.CustID " _
& "WHERE tblApp.MyDate = Forms!APP!MyCalendar " _
& "ORDER BY tblApp.TimeID;"
End With

TimeSlots contains all times from 06:00 up to 16:00 with 30 minutes
steps like:

06:00
06:30 and so on.

I could, maybe, have a default value of some text e.g.: 'FREE' and then
try a query to fill the listbox. Problem is that access only returns
records with values and not the empty records. However...I'll try and
experiment with your suggestion :-)

Jul 5 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Neil Ginsberg | last post by:
I am having trouble using Windows Scheduler with an A2K database that has a password. The password is a db password, not a user-level security password. I have a routine I am looking for Scheduler...
7
by: srinivas | last post by:
Hi I'm having VB console application. I want to schedule this app so that it can run for every 30 mins. I don't want to use Windows Services here. Is there any way where i can run scheduler for...
2
by: yamca | last post by:
I want to write a task scheduler. But i cant make the logic between the scheduler and tasks. For example a have an external process which can add and delete tasks from scheduler. Every task has...
4
by: Sid Price | last post by:
Is there a .NET (2003) class available somewhere that might provide a comprehensive task scheduler with a better granularity than the one minute of the built-in scheduler on XP? Even down to 15...
4
by: matthiasjanes | last post by:
Hi all, I have a application where I use different threads. actually all is working - BUT I just discovered that the CPU is always 100 % used. on the 32-bit machine athlon XP, as well as on...
1
by: =?Utf-8?B?QW5keSBTLg==?= | last post by:
I have an application written in Visual Basic .NET in Visual Studio 2005 that runs on a server and simply uses the filesystem.copydirectory to backup folders from my pc to a server. The problem I...
1
by: =?Utf-8?B?YXVzdGlyb2I=?= | last post by:
Hi, While I realise that this may not be a very nice solution architecturally, I kick off a Scheduler in an ASP.NET 2.0 webservice in Application_Start() which is supposed to call a stored proc...
5
by: greg | last post by:
sokol wrote: The sched module is *not* designed for multithreading. It assumes that the thread waiting for events is the only one putting events into the queue, so it's impossible for an...
9
by: muffins | last post by:
Hi, I was wondering if any body could help me. I am using the calendar below as a template but I need to include within it a time scheduler. So for each day (per employee) I would like a time...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.