Re: room chart problems

I would probably create an unbound report with text boxes or labels
positioned exactly where you want in a big detail section. Then in the On
Format event of the detail section, use code to open a recordset of the
current days room assignments. If your text boxes are named similar to your
room names, you can simply loop through the recordset once to set the value
or caption property of the text boxes or labels.

--
Duane Hookom
Microsoft Access MVP


"_Bigred" wrote:

On Feb 19, 8:07 am, Philip Herlihy <bounceb...@xxxxxxx> wrote:
_Bigred wrote:
On Feb 18, 9:37 am, _Bigred <nelli...@xxxxxxxxxx> wrote:
Hello All,

I have a report that has unbound boxes for each room, and each unbound
box is named for a room i.e N047A,N047B,N048A,N048B etc..

Is there a way that I can use the label name such as "N047A" as the
criteria for a dlookup or other function .. that would populate the
unbound box with the persons name [tblFullName] and date they were
placed in that room [AssignDate].

This particular report will have 34 total rooms, and I need it to
autopopulate each persons information in the appropriate box on the
report.

TIA,
_Bigred

If I setup a table for the rooms and then a table for the people, and
then setup a join query how do i then put the occupants of each room
in their "very specifically layout" rooms on my report (chart)? There
is only 1 occupant to each room # i.e. N047A, N047B etc...

I just figured since I already had the chart made with unbound boxes
and named them for each room, I could some how easily do this.

Am I right in now thinking that the boxes on the report are, in effect,
a map of the rooms? That makes a difference - normally you'd want a
solution to be as general as possible so that it can adapt to changes,
but this might be an exception.

If this is right, then for this very specific (and inflexible)
application you could do something like this:

Blow normalisation for once (shudder). Create a table with two fields
for every room; one for the name of the occupant, and one for the name
they were assigned to that room.

On your form, lay out your "rooms" but use two text boxes; one for the
name, and one for the date. You may want labels (you get one free with
every text box unless you delete it) with captions "Occupant" and
"Assigned" (or similar) for these boxes, plus a free-standing label
giving the name of the room (you could put a "Rectangle" around each
group purely for cosmetics).

Make the text-boxes bound controls, by setting the ControlSource
property to the name of the corresponding field in your table.

Yes, I still think this is weird. The whole point of a database is that
it manages changes in your data, and this is very static. Since what
you want appears to be a graphic map, why not use a graphic tool to
create one? Any graphic tool which can draw rectangles, lines and label
them with text will do, including PowerPoint, Fireworks, DrawPlus (free
edition available at freeserifsoftware.com) or even Paint. The effort
of drawing this in such a package will be less than the effort of
mangling Access to do this, and the effort of updating changes will be
about the same.

In fact, if you drew up a form in Access, and used only rectangles and
labels (no tables!) you could achieve everything you seem to want
perfectly well!

Phil

PS: Good grief...- Hide quoted text -

- Show quoted text -

Yes the boxes on the report are the layout of 164 total beds spread
across double occupancy rooms and 44 single bed rooms. The physical
layout will never change, I the occupants will change on a frequent
basis - on average 12+ room changes every 7-14 days. The reason I want
to create a report in access is so when the tblCenterInfo data is
modified the Room Charts are updated right along with Room Directories
and other reports that are pulled from tblCenterInfo - since I'm not
the only user of the database, if I can keep in ALL in access would be
extremely beneficial .

Thanks for your time,
_Bigred

.

Relevant Pages

  • Re: Referencing objects in option group
    ... I also like your approach to additional check boxes. ... >provide the data for the report. ... >>>BlankI have a series of check boxes and associated labels within an ... >>> cbxLabel.caption = myText ...
    (microsoft.public.access.reports)
  • Re: How to Make my report show only complete fields
    ... I do not have yes/no boxes but I have about 30 text fiels with labels, ... >>I have report that I created using the Report Wizard. ... >>Right now I see blank lines where the field are incomplete. ...
    (microsoft.public.access.reports)
  • Re: room chart problems
    ... then setup a join query how do i then put the occupants of each room ... in their "very specifically layout" rooms on my report? ... Am I right in now thinking that the boxes on the report are, in effect, ... labels you could achieve everything you seem to want ...
    (microsoft.public.access.reports)
  • Re: combine last name and first name
    ... the report view shows the data in boxes, ... Went to Design view and selected both the labels and data, ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Parameter query with multiple check boxes
    ... Does the report get the info from the query which gets info ... "Duane Hookom" wrote: ... assuming you have check boxes on your criteria form and the ...
    (microsoft.public.access.queries)