Can't create any more controls

[jaanisf]

When I try to make a control it gives me this error:

"Microsoft Access can't create any more controls on this form or report.
If you have deleted controls from this form or report in the past, you may be able to rename the form or report and then add more controls to it."

I tried to rename the form, but it still gives this error when I try to make a control. What should I do? How should I increase the limit of controls in a form?

 

[R. Hicks]

Number of controls and sections you can add over the lifetime of the form/report is 754 ......

If you have anywhere near this amount I suspect you have serious structural problems in your application.

To reset the control count on a form/report to the actual number of controls .... create a new form or report and copy and paste the controls from the old form/report to the new empty form/report.

HTH
RDH

 

[ColinEssex]

In addition to R Hicks answer.

If you like the design of a form and decide to copy it and re-use it over and over in different databases making only minor changes, the form will still remember the controls used in previous databases. Eventually you will reach the 754 and thats the end.

Col

 

[jaanisf]

Well, thank you for answering but..
I need about 850 controls on this form. So, there's no way, I could make it?

What I'm trying to make is a table with 26 rows and 33 columns. That's 858 labels (controls)
The column Col1 goes for room numbers in a hotel. The column Col2 goes for room cathegory, and columns Col3 to Col33 goes for dates of a month. Rows R2 to R26 goes for reservations for the room ColXRowY. When I click on a label ColXRowY a new form opens where I write a guest's name and a number of days he/she will stay. After updating that form, the label ColXRowY turns Red, for example.
So, maybe you got some recommendations, how I could make it differently?

 

[Rich]

You need to normalise your structure, search here for posts on the subject

 

[jaanisf]

what subject?? there's no subject ;D

 

[Mile-O]

The subject of Normalisation.

 

[jaanisf]

Did You read my lates reply?
-
What I'm trying to make is a table with 26 rows and 33 columns. That's 858 labels (controls)
The column Col1 goes for room numbers in a hotel. The column Col2 goes for room cathegory, and columns Col3 to Col33 goes for dates of a month. Rows R2 to R26 goes for reservations for the room ColXRowY. When I click on a label ColXRowY a new form opens where I write a guest's name and a number of days he/she will stay. After updating that form, the label ColXRowY turns Red, for example.
So, maybe you got some recommendations, how I could make it differently?
-
See picture attachment, that I found in the internet of what I want to create. There's no need of normalisation, but of a way, how to make it, when 900 controls are forbidden.

 

[raskew]

Bubba,

Looked at the gif file. I've seen that format before and, although I can't immediately pinpoint its origin, it's very obvious--from your input-- that it's not something you created. You've borrowed someone else's hard work and made it your own.

To say 'There's no need of normalisation' immediately identifies you as a complete rookie. Your situation begs for normalisation!! No competent database programmer is going to put 100+ controls, much less 900+ controls, on a form or report. We leave that to the folks who haven't a clue.

Guess that means you, Bubba!

 

[jaanisf]

gh, i don't take others work and take it to mine, it is just a picture of what i want to make. that picture is all i have of your "someone elses hard work" ;D . and i already made all i needed just with less controls, Col1-Col17 (two weeks insted of a month). And i never said I'm something of a top programmer, of course i'm just a newbie. and you're too, if you cant get what i'm asking, lame.

 

[Rich]

Your missing the point jaanisf, you're trying to re-create a spreadsheet in Access, like I said, you need to normalise your data and do some reading on the subject

 

[ColinEssex]

i'm just a newbie. and you're too, if you cant get what i'm asking, lame.

jaanisf - I would be very careful how you phrase things, and I recommend you to take heed of what Rich and RHicks and Raskew are saying, they are all excellent programmers and they would not give out duff advice.

You need to think about your hotel bookings. You have a number of rooms - each of which can have many bookings. This indicates that you need one table of room data (RoomNo, Category,Size etc etc) that data will always be the same and will never change.

You will then need a second table with the RoomNo as the key field , an inDate and an OutDate plus any other data you need like customer name or whatever. This table will grow in a DOWNWARDS direction (i.e. one line for each day)

Your database therefore is a "One to many" (one room and many bookings for each room)

Col

 

[jaanisf]

You just can't figure out what I'm asking, "programmers". Ok, you're of course good programmers, but not good on perception. You're too good programmers, maybe and can't figure simple things ;D
I have all the tables, and it all works just perfect. What I wanted is, to make a main form where I could see all the reservations for all rooms to a whole month. Well, that had to be 900 label controls or such. Well, but never mind, I've done it already with 450 controls for 2 weeks, not fully what I wanted, but will do.

And on phrasing things, how could one say, that I borrowed something and made it as my own? I never told such. Picture is just an example of a programm I found on internet, and there you can see that programms name: ROS2000. That layout uses every hotel I know, and it's not something new. We use it too, 4 years allready since we're open, just on paper.

ps. And what does it mean: "bubba"?
ps2. every rookie can say: that begs for normalisation. but, have you had a single idea of how it's done in that gif?

 

[jaanisf]

Ha, it's a spreadsheet control. It solves everything. Why didn't you tell me this, seniors?

 

[raskew]

Colin-

You obviously are a mediator with a lot more patience than I possess!

Your response was extremely well put!

Best wishes,

Bob

 

[ColinEssex]

Thanks Raskew - when you've been married as long as I have you become good at mediation techniques and treading the thin line

Jaanisf - its obviously a spreadsheet as Rich pointed out in his earlier post. We were under the impression that you wanted to re-create it in Access and we were right - you can't (not in that way anyway)

Col

 

[Hayley Baxter]

Let's hear it for Col

 

[ColinEssex]

Tonight Matthew - I'm going to be ........Henry Kissinger

 

[Rich]

Tonight Matthew - I'm going to be ........Kissing her

that's very romantic of you Col, after all these years of married life

 

[ColinEssex]

Romantic.......Hmmmmm.........have to look that one up I'm afraid, you've lost me there Rich.