Limitation in Number of Fields ...

R

Reda Hanna

Good morning everyone ...

I have created a long form on an ASP page using FrontPage 2003 with a total
of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
Boxes / Drop-downs ... The results goes directly to an Access Database on the
same local Server which has FrontPage extensions ...

After the time it took to design, layout and name Fields to show corretly in
the Results database, the form doesn't work correctly ...

When I hit the Submit button, nothing happens and the Confirmation Page
doesn't show ...

I created another ASP page and started copying groups of fields until I
found that the form will work with [22] fields as the Submit button will be
OK and the Confirmation Page will show ...

Also, I have verified that the went went through to the Access database
correctly ...

Appreciate informing me of what might be the problem ...

Thanks,
 
S

Stefan B Rusynko

Verify you are not
- using reserved access names to field names
(see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
- not using duplicate field names

The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
- 95 fields should be no problem

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Good morning everyone ...
|
| I have created a long form on an ASP page using FrontPage 2003 with a total
| of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| Boxes / Drop-downs ... The results goes directly to an Access Database on the
| same local Server which has FrontPage extensions ...
|
| After the time it took to design, layout and name Fields to show corretly in
| the Results database, the form doesn't work correctly ...
|
| When I hit the Submit button, nothing happens and the Confirmation Page
| doesn't show ...
|
| I created another ASP page and started copying groups of fields until I
| found that the form will work with [22] fields as the Submit button will be
| OK and the Confirmation Page will show ...
|
| Also, I have verified that the went went through to the Access database
| correctly ...
|
| Appreciate informing me of what might be the problem ...
|
| Thanks,
 
R

Reda Hanna

Stefan,

Thanks for your response ...

The last field that is captured by the database in called [PhysicianName]
(40 Characters)(Text Field)

The following field that nothing is captured after it is called [DrPhone]
(12 Characters)(Text Field)

So, what am I missing ???
 
S

Stefan B Rusynko

Post a URL to the form online
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan,
|
| Thanks for your response ...
|
| The last field that is captured by the database in called [PhysicianName]
| (40 Characters)(Text Field)
|
| The following field that nothing is captured after it is called [DrPhone]
| (12 Characters)(Text Field)
|
| So, what am I missing ???
|
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Verify you are not
| > - using reserved access names to field names
| > (see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
| > - not using duplicate field names
| >
| > The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
| > - 95 fields should be no problem
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Good morning everyone ...
| > |
| > | I have created a long form on an ASP page using FrontPage 2003 with a total
| > | of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| > | Boxes / Drop-downs ... The results goes directly to an Access Database on the
| > | same local Server which has FrontPage extensions ...
| > |
| > | After the time it took to design, layout and name Fields to show corretly in
| > | the Results database, the form doesn't work correctly ...
| > |
| > | When I hit the Submit button, nothing happens and the Confirmation Page
| > | doesn't show ...
| > |
| > | I created another ASP page and started copying groups of fields until I
| > | found that the form will work with [22] fields as the Submit button will be
| > | OK and the Confirmation Page will show ...
| > |
| > | Also, I have verified that the went went through to the Access database
| > | correctly ...
| > |
| > | Appreciate informing me of what might be the problem ...
| > |
| > | Thanks,
| >
| >
| >
 
R

Reda Hanna

Stefan,

The form is used for Athletic Registration and can be only accessed locally
from within the School District ...

Do you want me to send you the HTML Code ???

Thanks again for all your help and support ...

Stefan B Rusynko said:
Post a URL to the form online
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan,
|
| Thanks for your response ...
|
| The last field that is captured by the database in called [PhysicianName]
| (40 Characters)(Text Field)
|
| The following field that nothing is captured after it is called [DrPhone]
| (12 Characters)(Text Field)
|
| So, what am I missing ???
|
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Verify you are not
| > - using reserved access names to field names
| > (see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
| > - not using duplicate field names
| >
| > The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
| > - 95 fields should be no problem
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Good morning everyone ...
| > |
| > | I have created a long form on an ASP page using FrontPage 2003 with a total
| > | of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| > | Boxes / Drop-downs ... The results goes directly to an Access Database on the
| > | same local Server which has FrontPage extensions ...
| > |
| > | After the time it took to design, layout and name Fields to show corretly in
| > | the Results database, the form doesn't work correctly ...
| > |
| > | When I hit the Submit button, nothing happens and the Confirmation Page
| > | doesn't show ...
| > |
| > | I created another ASP page and started copying groups of fields until I
| > | found that the form will work with [22] fields as the Submit button will be
| > | OK and the Confirmation Page will show ...
| > |
| > | Also, I have verified that the went went through to the Access database
| > | correctly ...
| > |
| > | Appreciate informing me of what might be the problem ...
| > |
| > | Thanks,
| >
| >
| >
 
S

Stefan B Rusynko

No
And it is probably to long to post here

You need to check for a broken form
- tables or other block level tags breaking the form tags

And duplicate form field names
What happens when you insert the field named "DrPhone" before "PhysicianName"
- or rename the last form field named "PhysicianName" to "DrPhone"

PS
Are you doing all this in the DBRW or hand coding your forms and ASP form processing page
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan,
|
| The form is used for Athletic Registration and can be only accessed locally
| from within the School District ...
|
| Do you want me to send you the HTML Code ???
|
| Thanks again for all your help and support ...
|
| "Stefan B Rusynko" wrote:
|
| > Post a URL to the form online
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Stefan,
| > |
| > | Thanks for your response ...
| > |
| > | The last field that is captured by the database in called [PhysicianName]
| > | (40 Characters)(Text Field)
| > |
| > | The following field that nothing is captured after it is called [DrPhone]
| > | (12 Characters)(Text Field)
| > |
| > | So, what am I missing ???
| > |
| > |
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Verify you are not
| > | > - using reserved access names to field names
| > | > (see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
| > | > - not using duplicate field names
| > | >
| > | > The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
| > | > - 95 fields should be no problem
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > | Good morning everyone ...
| > | > |
| > | > | I have created a long form on an ASP page using FrontPage 2003 with a total
| > | > | of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| > | > | Boxes / Drop-downs ... The results goes directly to an Access Database on the
| > | > | same local Server which has FrontPage extensions ...
| > | > |
| > | > | After the time it took to design, layout and name Fields to show corretly in
| > | > | the Results database, the form doesn't work correctly ...
| > | > |
| > | > | When I hit the Submit button, nothing happens and the Confirmation Page
| > | > | doesn't show ...
| > | > |
| > | > | I created another ASP page and started copying groups of fields until I
| > | > | found that the form will work with [22] fields as the Submit button will be
| > | > | OK and the Confirmation Page will show ...
| > | > |
| > | > | Also, I have verified that the went went through to the Access database
| > | > | correctly ...
| > | > |
| > | > | Appreciate informing me of what might be the problem ...
| > | > |
| > | > | Thanks,
| > | >
| > | >
| > | >
| >
| >
| >
 
R

Reda Hanna

Stefan,

So, how to check for a "tables or other block level tags breaking the form
tags" ???

I basically used the Design of FrontPage to create the Table and insert the
different Fields ...

I have posted the Form online for you to review ... The URL is:

http://www.lcusd.net/lchs/2009/Athletic/AthleticRegistration.asp

Thanks again and looking forward to hear from you ...
Stefan B Rusynko said:
No
And it is probably to long to post here

You need to check for a broken form
- tables or other block level tags breaking the form tags

And duplicate form field names
What happens when you insert the field named "DrPhone" before "PhysicianName"
- or rename the last form field named "PhysicianName" to "DrPhone"

PS
Are you doing all this in the DBRW or hand coding your forms and ASP form processing page
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan,
|
| The form is used for Athletic Registration and can be only accessed locally
| from within the School District ...
|
| Do you want me to send you the HTML Code ???
|
| Thanks again for all your help and support ...
|
| "Stefan B Rusynko" wrote:
|
| > Post a URL to the form online
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Stefan,
| > |
| > | Thanks for your response ...
| > |
| > | The last field that is captured by the database in called [PhysicianName]
| > | (40 Characters)(Text Field)
| > |
| > | The following field that nothing is captured after it is called [DrPhone]
| > | (12 Characters)(Text Field)
| > |
| > | So, what am I missing ???
| > |
| > |
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Verify you are not
| > | > - using reserved access names to field names
| > | > (see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
| > | > - not using duplicate field names
| > | >
| > | > The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
| > | > - 95 fields should be no problem
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > | Good morning everyone ...
| > | > |
| > | > | I have created a long form on an ASP page using FrontPage 2003 with a total
| > | > | of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| > | > | Boxes / Drop-downs ... The results goes directly to an Access Database on the
| > | > | same local Server which has FrontPage extensions ...
| > | > |
| > | > | After the time it took to design, layout and name Fields to show corretly in
| > | > | the Results database, the form doesn't work correctly ...
| > | > |
| > | > | When I hit the Submit button, nothing happens and the Confirmation Page
| > | > | doesn't show ...
| > | > |
| > | > | I created another ASP page and started copying groups of fields until I
| > | > | found that the form will work with [22] fields as the Submit button will be
| > | > | OK and the Confirmation Page will show ...
| > | > |
| > | > | Also, I have verified that the went went through to the Access database
| > | > | correctly ...
| > | > |
| > | > | Appreciate informing me of what might be the problem ...
| > | > |
| > | > | Thanks,
| > | >
| > | >
| > | >
| >
| >
| >
 
R

Reda Hanna

Stefan,

So, how to check for a "tables or other block level tags breaking the form
tags" ???

I basically used the Design of FrontPage to create the Table and insert the
different Fields ...

I have posted the Form online for you to review ... The URL is:

http://www.lcusd.net/lchs/2009/Athletic/AthleticRegistration.asp

Thanks again and looking forward to hear from you ...

Stefan B Rusynko said:
No
And it is probably to long to post here

You need to check for a broken form
- tables or other block level tags breaking the form tags

And duplicate form field names
What happens when you insert the field named "DrPhone" before "PhysicianName"
- or rename the last form field named "PhysicianName" to "DrPhone"

PS
Are you doing all this in the DBRW or hand coding your forms and ASP form processing page
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan,
|
| The form is used for Athletic Registration and can be only accessed locally
| from within the School District ...
|
| Do you want me to send you the HTML Code ???
|
| Thanks again for all your help and support ...
|
| "Stefan B Rusynko" wrote:
|
| > Post a URL to the form online
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Stefan,
| > |
| > | Thanks for your response ...
| > |
| > | The last field that is captured by the database in called [PhysicianName]
| > | (40 Characters)(Text Field)
| > |
| > | The following field that nothing is captured after it is called [DrPhone]
| > | (12 Characters)(Text Field)
| > |
| > | So, what am I missing ???
| > |
| > |
| > |
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Verify you are not
| > | > - using reserved access names to field names
| > | > (see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
| > | > - not using duplicate field names
| > | >
| > | > The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
| > | > - 95 fields should be no problem
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > | Good morning everyone ...
| > | > |
| > | > | I have created a long form on an ASP page using FrontPage 2003 with a total
| > | > | of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| > | > | Boxes / Drop-downs ... The results goes directly to an Access Database on the
| > | > | same local Server which has FrontPage extensions ...
| > | > |
| > | > | After the time it took to design, layout and name Fields to show corretly in
| > | > | the Results database, the form doesn't work correctly ...
| > | > |
| > | > | When I hit the Submit button, nothing happens and the Confirmation Page
| > | > | doesn't show ...
| > | > |
| > | > | I created another ASP page and started copying groups of fields until I
| > | > | found that the form will work with [22] fields as the Submit button will be
| > | > | OK and the Confirmation Page will show ...
| > | > |
| > | > | Also, I have verified that the went went through to the Access database
| > | > | correctly ...
| > | > |
| > | > | Appreciate informing me of what might be the problem ...
| > | > |
| > | > | Thanks,
| > | >
| > | >
| > | >
| >
| >
| >
 
S

Stefan B Rusynko

Both your Submit and Reset form buttons are outside of the closing </form> tag

Make sure all form fields (and their containing tables) are inside of the opening & closing form tags
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Stefan,
|
| So, how to check for a "tables or other block level tags breaking the form
| tags" ???
|
| I basically used the Design of FrontPage to create the Table and insert the
| different Fields ...
|
| I have posted the Form online for you to review ... The URL is:
|
| http://www.lcusd.net/lchs/2009/Athletic/AthleticRegistration.asp
|
| Thanks again and looking forward to hear from you ...
|
| "Stefan B Rusynko" wrote:
|
| > No
| > And it is probably to long to post here
| >
| > You need to check for a broken form
| > - tables or other block level tags breaking the form tags
| >
| > And duplicate form field names
| > What happens when you insert the field named "DrPhone" before "PhysicianName"
| > - or rename the last form field named "PhysicianName" to "DrPhone"
| >
| > PS
| > Are you doing all this in the DBRW or hand coding your forms and ASP form processing page
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Stefan,
| > |
| > | The form is used for Athletic Registration and can be only accessed locally
| > | from within the School District ...
| > |
| > | Do you want me to send you the HTML Code ???
| > |
| > | Thanks again for all your help and support ...
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Post a URL to the form online
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > | Stefan,
| > | > |
| > | > | Thanks for your response ...
| > | > |
| > | > | The last field that is captured by the database in called [PhysicianName]
| > | > | (40 Characters)(Text Field)
| > | > |
| > | > | The following field that nothing is captured after it is called [DrPhone]
| > | > | (12 Characters)(Text Field)
| > | > |
| > | > | So, what am I missing ???
| > | > |
| > | > |
| > | > |
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > Verify you are not
| > | > | > - using reserved access names to field names
| > | > | > (see http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html)
| > | > | > - not using duplicate field names
| > | > | >
| > | > | > The limit of fields you can write to an Access DB is the limit of the # of field allowed in your version of Access DB
| > | > | > - 95 fields should be no problem
| > | > | >
| > | > | > _____________________________________________
| > | > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | > | > | Good morning everyone ...
| > | > | > |
| > | > | > | I have created a long form on an ASP page using FrontPage 2003 with a total
| > | > | > | of [95] fields, which are combinations of Text Boxes / Radio Buttons / Check
| > | > | > | Boxes / Drop-downs ... The results goes directly to an Access Database on the
| > | > | > | same local Server which has FrontPage extensions ...
| > | > | > |
| > | > | > | After the time it took to design, layout and name Fields to show corretly in
| > | > | > | the Results database, the form doesn't work correctly ...
| > | > | > |
| > | > | > | When I hit the Submit button, nothing happens and the Confirmation Page
| > | > | > | doesn't show ...
| > | > | > |
| > | > | > | I created another ASP page and started copying groups of fields until I
| > | > | > | found that the form will work with [22] fields as the Submit button will be
| > | > | > | OK and the Confirmation Page will show ...
| > | > | > |
| > | > | > | Also, I have verified that the went went through to the Access database
| > | > | > | correctly ...
| > | > | > |
| > | > | > | Appreciate informing me of what might be the problem ...
| > | > | > |
| > | > | > | Thanks,
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top