I've come up with a bit of a show-stopper issue. I have a form with a large number of controls on it and when I try and add new controls I get the error:
'Microsoft Office 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'
Well, I have tried as suggested and I can add a couple more controls but then come up against the same error again. I'm also guessing that there is no way around this error.
I do have one avenue of hope, but I need a little advice on how best to implement it, being something of an access novice...
A good number of the controls are used as temporary storage for values pulled from the database as this seemed the easiest way to handle them. Now what I'm wondering is if there's an easy way I could just pick them up from the database as and when needed by a calculation rather than reading them all into controls when the form loads.
I have had a bit of a play round trying to do this before but with no success. Basically what I would like to be able to do is reference a db field something like:
tbl_Houses!h_DataField
The problem I have is how to speicify which row to look at. The primary key is a simple id field.
I hope I've explained that well enough and I hope that someone can help me out here else I'm a bit screwed!
'Microsoft Office 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'
Well, I have tried as suggested and I can add a couple more controls but then come up against the same error again. I'm also guessing that there is no way around this error.
I do have one avenue of hope, but I need a little advice on how best to implement it, being something of an access novice...
A good number of the controls are used as temporary storage for values pulled from the database as this seemed the easiest way to handle them. Now what I'm wondering is if there's an easy way I could just pick them up from the database as and when needed by a calculation rather than reading them all into controls when the form loads.
I have had a bit of a play round trying to do this before but with no success. Basically what I would like to be able to do is reference a db field something like:
tbl_Houses!h_DataField
The problem I have is how to speicify which row to look at. The primary key is a simple id field.
I hope I've explained that well enough and I hope that someone can help me out here else I'm a bit screwed!