I plan to use access to manage a small tea house, but I was frustrated at
the first step.

The prolem is:

1. Within in the main form I would like to draw squares to symbolize 6
square tables (which is easy), and round to symbolize 3 round tables, I
failed to draw a round for the whole afternoon, I did not find any tool to
draw a round (circle) .

2. There is a table called "table", it is not difficult to use list box to
show all 9 tables in the main form, but what I want is to give tables shapes
(square or round) so that they will be very concrete and direct to the
users. How can I do this?

Thanks.

Paul

use something like MS Paint and save the files as GIFS, then place them on
your form. It may also pay to investigate if you can add transparency to
them.

Let me know how you get on, because it sounds like a very interesting
concept.

Thank you WindAndWaves for your good idea. This is what I get on:

I got the round tables with MS PAINT and placed them in the main form. The
result is: they have dramatically increased the size of the app (5.5mb an
almost empty mdb with only 5 gif files!). Ok, the size of the app is not a
big issue, but the most difficult thing is how to make this possible:

you click the gif pic1 on the form and the name of the related tea house
table, say, "table 1" will automatically appear in a text control called
"table" on the same form, when you click gif pic2, then it will be shown
"table 2", etc....

any idea? Any help will be very much appreciated.

Paul



"WindAndWaves" <access@ngaru.com> дÈëÏûÏ¢ÐÂÎÅ
:8_rAc.753$LT3.36350@news.xtra.co.nz...[color=blue]
> use something like MS Paint and save the files as GIFS, then place them on
> your form. It may also pay to investigate if you can add transparency to
> them.
>
> Let me know how you get on, because it sounds like a very interesting
> concept.
>
>[/color]

Paul,
Look at the mousedown event - I have used it on images to show when the XY
coordinate range is clicked

Private Sub Image1_MouseDown(Button As Integer, Shift As Integer, X As
Single, Y As Single)
If Button = acLeftButton Then
Me!Text0 = X
Me!Text2 = Y
'comment- for demo purposes, puts coordinates in textboxes
End If
If X < 1830 And (Y > 1425 And Y < 4335) Then
MsgBox "you clicked on Table 1"
End If
and so on.......


If I were designing this, I would put all my shapes in a single pic and show
on a single form. Then when a table is selected, your code will show which
one was clicked.

HTH
Damon


"Paul T.Rong" <etjsk@hotmail.com> wrote in message
news:gEwAc.91534$vP.37927@news.chello.at...[color=blue]
> Thank you WindAndWaves for your good idea. This is what I get on:
>
> I got the round tables with MS PAINT and placed them in the main form. The
> result is: they have dramatically increased the size of the app (5.5mb an
> almost empty mdb with only 5 gif files!). Ok, the size of the app is not a
> big issue, but the most difficult thing is how to make this possible:
>
> you click the gif pic1 on the form and the name of the related tea house
> table, say, "table 1" will automatically appear in a text control called
> "table" on the same form, when you click gif pic2, then it will be shown
> "table 2", etc....
>
> any idea? Any help will be very much appreciated.
>
> Paul
>
>
>
> "WindAndWaves" <access@ngaru.com> дÈëÏûÏ¢ÐÂÎÅ
> :8_rAc.753$LT3.36350@news.xtra.co.nz...[color=green]
> > use something like MS Paint and save the files as GIFS, then place them[/color][/color]
on[color=blue][color=green]
> > your form. It may also pay to investigate if you can add transparency[/color][/color]
to[color=blue][color=green]
> > them.
> >
> > Let me know how you get on, because it sounds like a very interesting
> > concept.
> >
> >[/color]
>
>[/color]

Damon,

great idea! too good. Thanks for advise.


"Damon Heron" <damon327@hotmail.com> дÈëÏûÏ¢ÐÂÎÅ
:KomdnbnP1d4zH07dRVn-sw@comcast.com...[color=blue]
> Paul,
> Look at the mousedown event - I have used it on images to show when the XY
> coordinate range is clicked
>
> Private Sub Image1_MouseDown(Button As Integer, Shift As Integer, X As
> Single, Y As Single)
> If Button = acLeftButton Then
> Me!Text0 = X
> Me!Text2 = Y
> 'comment- for demo purposes, puts coordinates in textboxes
> End If
> If X < 1830 And (Y > 1425 And Y < 4335) Then
> MsgBox "you clicked on Table 1"
> End If
> and so on.......
>
>
> If I were designing this, I would put all my shapes in a single pic and[/color]
show[color=blue]
> on a single form. Then when a table is selected, your code will show[/color]
which[color=blue]
> one was clicked.
>
> HTH
> Damon
>
>
> "Paul T.Rong" <etjsk@hotmail.com> wrote in message
> news:gEwAc.91534$vP.37927@news.chello.at...[color=green]
> > Thank you WindAndWaves for your good idea. This is what I get on:
> >
> > I got the round tables with MS PAINT and placed them in the main form.[/color][/color]
The[color=blue][color=green]
> > result is: they have dramatically increased the size of the app (5.5mb[/color][/color]
an[color=blue][color=green]
> > almost empty mdb with only 5 gif files!). Ok, the size of the app is not[/color][/color]
a[color=blue][color=green]
> > big issue, but the most difficult thing is how to make this possible:
> >
> > you click the gif pic1 on the form and the name of the related tea house
> > table, say, "table 1" will automatically appear in a text control called
> > "table" on the same form, when you click gif pic2, then it will be shown
> > "table 2", etc....
> >
> > any idea? Any help will be very much appreciated.
> >
> > Paul
> >
> >
> >
> > "WindAndWaves" <access@ngaru.com> дÈëÏûÏ¢ÐÂÎÅ
> > :8_rAc.753$LT3.36350@news.xtra.co.nz...[color=darkred]
> > > use something like MS Paint and save the files as GIFS, then place[/color][/color][/color]
them[color=blue]
> on[color=green][color=darkred]
> > > your form. It may also pay to investigate if you can add transparency[/color][/color]
> to[color=green][color=darkred]
> > > them.
> > >
> > > Let me know how you get on, because it sounds like a very interesting
> > > concept.
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

check that the gifs themselves are small, by saving them as separate data.
They should only be a couple of Kbytes.

It sounds like you have a great idea going there. Please feel free to ask
more questions. I would be keen to see your application as I work for a
restaurant myself.

Thank you

- Nicolaas

yes, Nicolaas, I made a mistake, I placed bmp files.... thanks again.

"WindAndWaves" <access@ngaru.com> дÈëÏûÏ¢ÐÂÎÅ
:CrUAc.1307$LT3.53446@news.xtra.co.nz...[color=blue]
> check that the gifs themselves are small, by saving them as separate data.
> They should only be a couple of Kbytes.
>
> It sounds like you have a great idea going there. Please feel free to ask
> more questions. I would be keen to see your application as I work for a
> restaurant myself.
>
> Thank you
>
> - Nicolaas
>
>[/color]

yeah, I am not sure who at MS invented BMPs, but they are pretty useless in
my experience.

WindAndWaves wrote:[color=blue]
> yeah, I am not sure who at MS invented BMPs, but they are pretty useless in
> my experience.[/color]


That's a bit like saying who invented 386, bit useless compared to a
modern PC.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer