I cannot see how to Create this form/section

[Lou_Reed]

I am running through the tutorial Microsoft Access Example Database : The Ceil In Hotel

The link is here:

http://www.functionx.com/access/appl...ns/ceilinn.htm

My issue/problem is with the following step:



Design the form approximately as follows:
 


Control
Name
Caption
Back Color
Control Source

Label


Available Rooms



Line






Label


Room #



Label


Room Type



Label


Bed Type



Label


Rate



Text Box

RoomNumber


RoomNumber

Text Box

RoomType


RoomType

Text Box

BedType


BedType

Text Box

Rate


Rate



Save and close the form

I have no idea how to design these two forms. I have been successful up until this location.



But how do I do this? it just says in the text design, but not how to do it.


Any help appreciated.


Thanks in advance.


Respectfully,


Lou_Reed

PS. Please note that I a trying to create this form and the one above it. I just cannot include it. Too many images for including.

[June7]

Add controls (labels, lines, textboxes, etc) from the Design tab on the ribbon.

Or click on the table then click the Form icon on the Create tab and let the wizard build for you.

[Lou_Reed]

You need to be more explicit. I go the top part of the form, but the bottom part is still eluding me.

That part is now shown here:

Control

Name

Caption

Back Color

Control Source


Label




Available Rooms




Line








Label




Room #




Label




Room Type




Label




Bed Type




Label




Rate




Text Box



RoomNumber



RoomNumber


Text Box



RoomType



RoomType


Text Box



BedType



BedType


Text Box



Rate



Rate



Save and close the form

I just do not see how to do that section. That section looks more like a table than a form.

Any help appreciated.

Thanks in advance.


Respectfully,


Lou Reed

[June7]

I don't understand. What 'section' - Detail?

Posted images do not look like form - just specifications.

Are you in Design View of form?

Don't know how more explicit can be. Building form is one of the most basic functionalities of Access.

[Lou_Reed]

The lower part of the Form that told you about does not even look like a form it looks more like a table. That is what I find confusing.

The top of the table/form says

Control Name Caption Back Color Control Source

followed by individual squares that contain Label Line Label Label Label Text Box Text Box Text Box Text Box

in the first column.


Then the second column shows various symbols from the MS Access 2010 IDE.

This clearly looks like a table to me. So how can one build a table and a form on the same

page? I know this may sound simple to a expert, but to some who started using MS Access last Monday - it is not.


As I said this is clearly some kind of table yet the tutorial for the Ceil Inn motel calls it a form.


That is why I am confused.


Any help appreciated. Thanks in advance.


Respectfully,


Lou_Reed

[June7]

Sounds like a Split form. A Split form shows a datasheet (table) at bottom (or side if chosen) and a single record on the top.

If you based the form on a table that has fields named Control, Name, Caption, BackColor, ControlSource then that is why the form shows those horizontally and the vertical info is the data in those fields. But that's not what you should do. Build a table and form with specified properties.

Build a table that has fields named RoomNumber, RoomType, BedType, Rate. Then establish controls on form as described. There will be 4 textboxes - one for each of the fields. Other controls on the form will be labels and lines as enumerated in the tutorial.

Why are you having difficulty with this table and form? It is the third table in the tutorial. Did you build the other two tables without issue? Did you build the other forms that preceded this one?


Suggest you experiment with the various form building tools on the Create tab then drag controls to form from the Design tab.

[Lou_Reed]

Of course, I have followed the tutorial and have completed every step.


Respectfully,


Lou_Reed

[June7]

If the issue is simply that the form is a Split form and you don't want that, change the form DefaultView property to the desired form type. Otherwise, I don't understand the issue.

[Lou_Reed]

I have created a split form. I used what I had in the top form - the form with "Available Rooms".



I then added the second form in datasheet view by pressing F4 and changing from continuous forms
to split form.

I then placed the datasheet view on the bottom of the screen below the first (Available Rooms) form.

It is there - the datasheet view only I see it in form view, but not in form design.

I am assuming that is where the other from input goes:





Control Name Caption Back Color Control Source

Label


Line


Label


Label


.

However, I am not sure how to populate that datasheet form.

As I said I only see it in form view not design view.


I realize these are simple questions to an experienced MS Access professional.

I am not one.

I have been using MS Access since Monday.

As I said, I created the split form with datasheet view on the bottom.

But what next? The pattern that I delineated above must go in there, but I do not see how.

Any help appreciated.

Thanks in advance.


Respectfully,



Lou Reed

[June7]

Not following that. If you want to provide db for analysis, follow instructions at bottom of my post.

[Lou_Reed]

I can create split forms and I can create what is at the top of the form. The problem is simply creating table like this:

Control
Name
Caption
Back Color
Control Source

Label


Available Rooms



Line






Label


Room #



Label


Room Type



Label


Bed Type



Label


Rate



Text Box

RoomNumber


RoomNumber

Text Box

RoomType


RoomType

Text Box

BedType


BedType

Text Box

Rate


Rate

I can integrate into the other form creating a split form. But how do create this table? I know that it is a little more elaborate that what I have shown here. That is

all I can do with cut and paste. But, I think that you know and understand my point.

How do you create this table?


Any help appreciated.


Thanks in advance.


Respectfully,


Lou_Reed

[June7]

I don't understand. Why would you create a table that has fields named: Control, Name, Caption, Back Color, Control Source?

The instructions are to create a table that has fields named: RoomNumber, RoomType, BedType, Rate.

If you have already built other tables and forms from this tutorial, this one should be simple effort. Provide your db for analysis. Follow instructions at bottom of my post.

[Lou_Reed]

The file is in this post compacted and repaired. If you need anything else let me know

Respectfully,

Lou_Reed

[June7]

Now I understand the confusion. Had to read the tutorial again. There is no table for AvailableRooms. This form is based on a query that uses other tables.

Why is AvailableRooms form set for Split? The instructions specify Continuous.

You used Textbox controls for labels in the form header section. Use Label control for label.


I never set Caption property in table. I want to see actual field names when I view tables.

[Lou_Reed]

The reason that it is a split is that on a previous post you called it a split form. I went with it.

I will try your recommendations.

Why do you say that the form is based on a query that uses other tables?

Is there a more elaborate version of the Ceil Inn tutorial. this version leaves stuff out.


Thanks.

Respectfully.

Lou_Reed