E
emerlita
How come when i tried to put all my tables into a form, Access doesn't
let me do it and gave me an error?
let me do it and gave me an error?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
You need to provide more information. A form may be based on a query
comprising several tables, but it is unclear what you mean when you say you
"tried to put all my tables into a form". In what way exactly are you
attempting to do that, and what is the error message? What do you hope to
accomplish?
comprising several tables, but it is unclear what you mean when you say you
"tried to put all my tables into a form". In what way exactly are you
attempting to do that, and what is the error message? What do you hope to
accomplish?
E
emerlita
You need to provide more information. A form may be based on a query
comprising several tables, but it is unclear what you mean when you say you
"tried to put all my tables into a form". In what way exactly are you
attempting to do that, and what is the error message? What do you hope to
accomplish?
- Show quoted text -
Im trying to create a form by using the form wizard. I have 33 tables
in my db and need all of them to create my 1st form.
When i tried to select fields from every single tables in the wizard
and clicked the Next button, i get an error "Subscript out of range".
What does that mean?
B
BruceM
Im trying to create a form by using the form wizard. I have 33 tables
in my db and need all of them to create my 1st form.
When i tried to select fields from every single tables in the wizard
and clicked the Next button, i get an error "Subscript out of range".
What does that mean?
I suspect a design flaw if you need 33 tables included in a form's record
source. Even without the error message you would almost surely be unable to
update the records. I don't know exactly what the error message means, but
a Google groups search for that exact text will produce quite a few hits,
one of which may apply to your situation.
With more understanding of what the database does I may be able to provide
some direction. You could try adding the fields one at a time until you
find one that produces the error, but again, I doubt a form that includes 33
tables in its record source will do what you need.
S
scubadiver
Personally, I think you need to sort out your tables and the design.
What is the database for and why 33 tables?
What is the database for and why 33 tables?
E
emerlita
Personally, I think you need to sort out your tables and the design.
What is the database for and why 33 tables?
- Show quoted text -
Thanks to all of you, i think i have to sort my db first and look at
the design.