How to represent resources availability?

[Guest]

Hi.

I'm wondering if there is an easy way to represent resources availability.

Explanation:
Let suppose I'm writing a form application for managing e.g. two
rent-a-cars. Clients are reserving those cars for their needs. So client 1
reserved a car from Feb 1st to Feb 4th; client two reserved a car from Feb
7th to Feb 10th. The third client wants to reserve a car from Feb 5th to Feb
6th and the forth one wants to reserve the car from Feb 6th to Feb 9th.

I'm NOT going to implement any business logic to optimize car reservation. I
just want to represent free slots e.g. green colored and busy slots red
colored to the user. It would be great if it is possible to represent both
resources on the same screen, however this is not needed (the common
representation would facilitate looking for resources).

Is there any sugested way how to implement this? Any other hint would be
helpful too.

Best regards,
Dezo

 

[Wei Lu]

Hi Dezo,

Welcome to use MSDN Managed Newsgroup Support.

From your description, my understanding of this issue is: You want to
implement a form to represent the status of a car. If I misunderstood your
concern, please feel free to point it out.

I think this is related to your database design. You may need to define the
status in the database and try to represent it in different format in the
form.

Also this feature like the calendar in the Outlook. I don't thinks
Microsoft have any ActiveX Control to do this job but you may try to find
some third party ActiveX Control or you can write your own Control to
implement the feature.

Hope this information will be helpful!

Wei Lu
Microsoft Online Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Guest]

Hi.

Is there a way to display a simple table on a form and possibly on a report
using Access 2003? I need to programmatically control the number of rows and
columns and cells background color. An additional benefit would be a
possibility to trigger an event on mouse click and the detection on which
cell the click was generated.

Explanation:
I want to display a table similar to the one produced by the below HTML code.
----
<table border=1>
<tr>
<td class=bg_color0>Description1:</td>
<td class=bg_color1> </td>
<td class=bg_color1> </td>
</tr>
<tr>
<td class=bg_color0>Description2:</td>
<td class=bg_color2> </td>
<td class=bg_color1> </td>
</tr>
</table>

 

[Steven Cheng[MSFT]]

Hi Dezo,

I think the easist way to display a table on a form is using the Form
Design Wizard.

Open your access database file and choose the Form tab.

Click Create Form by using wizard and you can follow the wizard to create a
form.

As for the backgroud color, you can use VBA code to control the backgroud
color of a form.

In the Form Design View, click the Detail, then in the Menu bar, click View
-> Code, you can use VBA code to customize your form. Also you may use the
onmouseclick event in it.

Here is the article about the Access 2003 VBA Language Reference
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP011361681033&CTT=
1&Origin=EC010227011033&QueryID=KUA9_h5ZW0&respos=1&rt=6

Hope this will be helpful!

Wei Lu
Microsoft Online Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.