Please help... KRISH

[Guest]

Hi! everybody,
I am working on Guest House computerization. Kindly help for the following
how to do i get monthly report. I want my report should show if no entry on a
particular day then it should show all beds available (i..e., total beds in
guesthouse). Problem is that say there is only one entry i.e. from 5th Jan to
9th jan. My query is only showing status of 5th and 9th and ignoring all
other days. But actually status for other days should be total beds
available. Its also ignoring 6th,7th,8th jan, which is incorrect. Please help.
Thanks
Krish

 

[Tom Ellison]

Dear Krish:

You will probably need to supply all possible dates to the query, so it can
report them. A one-column table of dates would be best. You can write a
module to append them, too, rather than typing every one. You can make your
query starting from these dates. Just how, I don't know. Not enough detail
from your post.

Tom Ellison

 

[Guest]

Thanks a lot Mr. Tom,
Append and Delete dates to a temp table, what u mean is good but is it a
better solution for multiuser environment. Another thing is there any way to
stop dialog box saying no of records deleleting or appending to or from
table. Note that I want to stop the dialog boxes only when i run this
particular quiries. I know how to stop the dialog boxes from tools menu. but
that will stop for entire project. Please advise. If possible kindly give
code for how to overwrite the temp table without delete.
thanks
krish

 

[Tom Ellison]

Dear Krish:

I don't see where this is any more a multi-user solution than it is a
single-user solution.

You can programmatically turn options on and off in a VB module.

I don't know the basis for your temp table question.

Tom Ellison

 

[Guest]

Thanks for your response
Your have suggested a one-column table of dates would be best. Also you
have suggested to write a module to append them, too, rather than typing
every one. Kindly let me know how the above is possible without temporary
table. Please write in detail. I am not able to understand.
Thanks.
Krish

 

[Tom Ellison]

Dear Krish:

The module could prompt you for a starting and ending date, then go into a
loop. The loop would cycle once for each date between those limits. For
those dates not within a weekend, it would append one row to the table. You
could build in fixed date holidays, July 4 and Dec 25 for example. You
could build in other holidays by thier rules, Memorial Day and Labor Day,
for example. Other holidays may have to be removed from the result
manually. There are also "rules" for July 4 and Dec 25, because the day off
is the Friday or Monday adjacent when the date falls on Saturday or Sunday,
respectively.

A search of some of the web-sites provided by others who post here will
almost certainly provide many details about doing this. If you start a new
thread to ask about these, I think you'll get referred to many of these.
Even finding one of them is useful. They typically link to one another, so
finding one is to find many.

Tom Ellison

 

[Guest]

Thanks for replying Mr. Tom,
Could you please give me some sites or a sample code for solving the prob.
Thanks.
Krish

 

[Tom Ellison]

Dear Krish:

I have never needed this myself, so I don't have a ready code snip. I
recommend you post a new thread requesting this. Someone will almost
certainly provide the code or a reference to something like it.

I suppose I'm being lazy. I could work it up in an hour or maybe a bit
less, but it's more efficient to pass this on for someone who already has
it.

Tom Ellison