tiling two objects vertically

[WindAndWaves]

Hi everyone,

I have a main menu that opens a report and a form that I would like to
display at the same time (while hiding the main menu).

So far, I made the form a pop-up and the report a preview so that both are
visible. The form is really small so it works.

However, it would be much better if I could tile the report and the form
vertically where the form takes up about 5cm and the report the rest of the
screen.

I have been trying for a while, but can't find a solution.

Thank you for reading this, it would be cool to hear if anyone has an idea

Nicolaas


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

[WindAndWaves]

Forms allow you to group data in headers, a form can not

e.g.
***Day***
~~~Period of the day~~~
---RoomB---
Reservation details #1
Reservation details #2
Reservation details #3
---RoomA---
Reservation details #4
Reservation details #5
Reservation details #6
"Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
news:BB******** **********@news-server.bigpond. net.au...

WindAndWaves wrote:

Hi Bri

I think this may be a good idea.

Also, Bradley and salad, the reason why I would like to do it is
because the report shows the booking information (for the restaurant)
and the form allows the person to make the booking.

Surely this information can be represented in a form?

I can't make the report into a form, because the report is perfect
and vice versa.

Please explain what you mean by "perfect"? :) What prevents the
information being communicated on a form? (either in a similar format of
in a different way).

Asking why may help though because it allow you to think of other
ways to solve the actual problem. THat is, my problem is to let the
waiter make a booking while seeing the other bookings.. rather than
displaying two at the same time (that is just a solution really).

That was my reason for asking. I's sure a form based solution can be
used for this.

Bradley

"Bri" <no*@here.com > wrote in message
news:1CSqc.5391 52$Ig.55968@pd7 tw2no...

Nicolaas,

In the OnOpen Event of the form and report use
DoCmd.MoveSize [right][, down][, width][, height] (in Twips,
1440/inch) See the Help for more info.

Bri

WindAndWaves wrote:
Hi everyone,

I have a main menu that opens a report and a form that I would like
to display at the same time (while hiding the main menu).

So far, I made the form a pop-up and the report a preview so that
both are visible. The form is really small so it works.

However, it would be much better if I could tile the report and the
form vertically where the form takes up about 5cm and the report
the rest of the screen.

I have been trying for a while, but can't find a solution.

Thank you for reading this, it would be cool to hear if anyone has
an idea

Nicolaas


---
Please immediately let us know (by phone or return email) if (a)
this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

---
Please immediately let us know (by phone or return email) if (a) this
email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

--
regards,

Bradley

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

[Bradley]

WindAndWaves wrote:

Forms allow you to group data in headers, a form can not
I assume you meant reports can group data in headers? :)
e.g.
***Day***
~~~Period of the day~~~
---RoomB---
Reservation details #1
Reservation details #2
Reservation details #3
---RoomA---
Reservation details #4
Reservation details #5
Reservation details #6
You can achieve this in a form... although granted it may not be as
simple.. but some of the nicest solutions (for the client) aren't the
simplest :)

Ideas...?
- use the Treeview control?
- use subforms with a subform?
- build a query that displays the data (simplest way may be to write it
to a temp table?)

I'm sure there are many others. As a general rule for me is if you are
enquiring the data on the screen a form is best.

Bradley

"Bradley" <br*****@REMOVE THIScomcen.com. au> wrote in message
news:BB******** **********@news-server.bigpond. net.au...

WindAndWaves wrote:

Hi Bri

I think this may be a good idea.

Also, Bradley and salad, the reason why I would like to do it is
because the report shows the booking information (for the
restaurant) and the form allows the person to make the booking.

Surely this information can be represented in a form?

I can't make the report into a form, because the report is perfect
and vice versa.

Please explain what you mean by "perfect"? :) What prevents the
information being communicated on a form? (either in a similar
format of in a different way).

Asking why may help though because it allow you to think of other
ways to solve the actual problem. THat is, my problem is to let the
waiter make a booking while seeing the other bookings.. rather than
displaying two at the same time (that is just a solution really).

That was my reason for asking. I's sure a form based solution can be
used for this.

Bradley

"Bri" <no*@here.com > wrote in message
news:1CSqc.5391 52$Ig.55968@pd7 tw2no...
Nicolaas,

In the OnOpen Event of the form and report use
DoCmd.MoveSize [right][, down][, width][, height] (in Twips,
1440/inch) See the Help for more info.

Bri

WindAndWaves wrote:
> Hi everyone,
>
> I have a main menu that opens a report and a form that I would
> like to display at the same time (while hiding the main menu).
>
> So far, I made the form a pop-up and the report a preview so that
> both are visible. The form is really small so it works.
>
> However, it would be much better if I could tile the report and
> the form vertically where the form takes up about 5cm and the
> report the rest of the screen.
>
> I have been trying for a while, but can't find a solution.
>
> Thank you for reading this, it would be cool to hear if anyone has
> an idea
>
> Nicolaas
>
>
>
>
> ---
> Please immediately let us know (by phone or return email) if (a)
> this email contains a virus
> (b) you are not the intended recipient
> (c) you consider this email to be spam.
> We have done our utmost to make sure that
> none of the above are applicable. THANK YOU
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
>
>


---
Please immediately let us know (by phone or return email) if (a)
this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

--
regards,

Bradley

---
Please immediately let us know (by phone or return email) if (a) this
email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

--
regards,

Bradley

[Salad]

WindAndWaves wrote:

Forms allow you to group data in headers, a form can not

e.g.
***Day***
~~~Period of the day~~~
---RoomB---
Reservation details #1
Reservation details #2
Reservation details #3
---RoomA---
Reservation details #4
Reservation details #5
Reservation details #6

Doable in a form. Depends on your skill level.

[Salad]

Bradley wrote:

A fruitless question. Why someone wants to do something is
irrelevent.

Not at all! Knowing why allows you to determine if there is a better way
of doing it. You must always understand why a client needs something.
It's an important part of the analysis.

<snip>

True enough. However, why someone wants to do something, especially in
NG questions, is most often irrelevant. There may be reasons why they
want to do it one way and not another. I have posed questions before
and the people answering me tend to wonder why I want to do something
more than simply answering a question. When the question is about
methods then you get into a long drawn out explanation of why you want
to do something. If it is a question by someone that is a relative
newbie to a feature of the system, OK. But if someone knows the product
and how it works, there may be underlying reasons why a way of
implementing something is done.

In my responses, because I have asked in the past for some advice
normally beyond the scope of what I know of a product, I tend to not
focus on why something is being requested one way but answering the
question. IOW, I may provide a recommendation for a better method to
accomplish a task I may think may assist, but as to why they want to do
something I tend to find a waste of time.

[Salad]

Bradley wrote:

Salad wrote:

Bradley wrote:

WindAndWav es wrote:
Thanks Bradley

I tried that, but it seems that only reports can be embedded as
subreport s and forms only as subforms. We are mixing here, that is
a subreport in a form does not work

I think I need to set the size of each window or something like
that, but I am not sure how.
Hmm, ok.

The next question I have is "why?". Why do you need both open at
once? Can't you put the control of your form on the report? (Haven't
tried it myself:)

A fruitless question. Why someone wants to do something is
irrelevent.

Not at all! Knowing why allows you to determine if there is a better way
of doing it. You must always understand why a client needs something.
It's an important part of the analysis.

<snip>

True enough. However, why someone wants to do something, especially in
NG questions, is most often irrelevant. There may be reasons why they
want to do it one way and not another. I have posed questions before
and the people answering me tend to wonder why I want to do something
more than simply answering a question. When the question is about
methods then you get into a long drawn out explanation of why you want
to do something. If it is a question by someone that is a relative
newbie to a feature of the system, OK. But if someone knows the product
and how it works, there may be underlying reasons why a way of
implementing something is done.

In my responses, because I have asked in the past for some advice
normally beyond the scope of what I know of a product, I tend to not
focus on why something is being requested one way but answering the
question. IOW, I may provide a recommendation for a better method to
accomplish a task I may think may assist, but as to why they want to do
something I tend to find a waste of time.

[Bradley]

Salad wrote:

Bradley wrote:

Salad wrote:

Bradley wrote:

WindAndWaves wrote:
> Thanks Bradley
>
> I tried that, but it seems that only reports can be embedded as
> subreports and forms only as subforms. We are mixing here, that
> is a subreport in a form does not work
>
> I think I need to set the size of each window or something like
> that, but I am not sure how.
Hmm, ok.

The next question I have is "why?". Why do you need both open at
once? Can't you put the control of your form on the report?
(Haven't tried it myself:)

A fruitless question. Why someone wants to do something is
irrelevent.

Not at all! Knowing why allows you to determine if there is a better
way of doing it. You must always understand why a client needs
something. It's an important part of the analysis.

<snip>

True enough. However, why someone wants to do something, especially
in NG questions, is most often irrelevant. There may be reasons why
they want to do it one way and not another. I have posed questions
before and the people answering me tend to wonder why I want to do
something more than simply answering a question. When the question
is about methods then you get into a long drawn out explanation of
why you want to do something. If it is a question by someone that is
a relative newbie to a feature of the system, OK. But if someone
knows the product and how it works, there may be underlying reasons
why a way of implementing something is done.

The reply from the person whom I asked shows exactly why it was a
fruitful question to pose. :)
In my responses, because I have asked in the past for some advice
normally beyond the scope of what I know of a product, I tend to not
focus on why something is being requested one way but answering the
question. IOW, I may provide a recommendation for a better method to
accomplish a task I may think may assist, but as to why they want to
do something I tend to find a waste of time.

Everything a clients wants starts with a purpose (which is the "why").

Sure, I may think of a solution and then seek help in implementing it if
I have trouble. But if I also explain the "why" I may learn a whole new
way of looking at it at the problem at same time:) (ie. instead of
focusing on a single problem, look at the entire issue).

Holistic development LOL
-
regards,

Bradley

[Salad]

Bradley wrote:

In my responses, because I have asked in the past for some advice
normally beyond the scope of what I know of a product, I tend to not
focus on why something is being requested one way but answering the
question. IOW, I may provide a recommendation for a better method to
accomplish a task I may think may assist, but as to why they want to
do something I tend to find a waste of time.

Everything a clients wants starts with a purpose (which is the "why").

Sure, I may think of a solution and then seek help in implementing it if
I have trouble. But if I also explain the "why" I may learn a whole new
way of looking at it at the problem at same time:) (ie. instead of
focusing on a single problem, look at the entire issue).

I was on a MS Word NG, requiring something beyond the skill set or
knowledge scope of most people there. So I spent more time answering
why I needed to do something than attempting to get an answer to the
problem. I finally had someone that stepped up to the plate, looked at
my code, told me a couple of mods, and away I went. It was a real
esoteric requirement that 99.9999% of the people will ever need to do.

Recently I had a similar thing on the FoxPro newsgroup. I'm spending
time relaying why I'm doing something and inend didn't get an answer. I
decided that it was fruitless for them to attempt to understand the why.
It had no bearing on the problem.

I think if we spent time questioning why people want to add, edit, or
delete records instead of simply giving them a solution or an attempted
solution we'd never get anywhere. If something is obviously off base
I'll bring it up, but sometimes a detailed explanation of a problem
leaves out too many details, so we do our best with what limited
knowledge we have. I'll even help people continue on with concepts I
consider moronic. It's no skin off my back.

Anyways, my negative attitude comes from experiences on other groups. I
need holistic development therapy

Holistic development LOL

:-)