Limitation in Number of Fields ...

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-odb...nd-sql-)
> - 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!" (-;
> _____________________________________________
>
>
> "Reda Hanna" <RedaHanna.TakeThisOut@discussions.microsoft.com> wrote in message news:BD56BD03-E8BF-4D2B-BAFB-8618EF533554@microsoft.com...
> | 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,
>
>
>

Post a URL to the form online
--

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


"Reda Hanna" <RedaHanna.RemoveThis@discussions.microsoft.com> wrote in message news:5BF6F63F-0CE6-41AC-8790-B7D0010D4CAB@microsoft.com...
| 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-odb...nd-sql-)
| > - 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!" (-;
| > _____________________________________________
| >
| >
| > "Reda Hanna" <RedaHanna.RemoveThis@discussions.microsoft.com> wrote in message news:BD56BD03-E8BF-4D2B-BAFB-8618EF533554@microsoft.com...
| > | 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,
| >
| >
| >

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!" (-;
> _____________________________________________
>
>
> "Reda Hanna" <RedaHanna.TakeThisOut@discussions.microsoft.com> wrote in message news:5BF6F63F-0CE6-41AC-8790-B7D0010D4CAB@microsoft.com...
> | 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-odb...nd-sql-)
> | > - 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!" (-;
> | > _____________________________________________
> | >
> | >
> | > "Reda Hanna" <RedaHanna.TakeThisOut@discussions.microsoft.com> wrote in message news:BD56BD03-E8BF-4D2B-BAFB-8618EF533554@microsoft.com...
> | > | 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,
> | >
> | >
> | >
>
>
>

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!" (-;
_____________________________________________


"Reda Hanna" <RedaHanna.TakeThisOut@discussions.microsoft.com> wrote in message news:C383985C-B780-4EC0-8444-DC59B27F9DFC@microsoft.com...
| 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!" (-;
| > _____________________________________________
| >
| >
| > "Reda Hanna" <RedaHanna.TakeThisOut@discussions.microsoft.com> wrote in message news:5BF6F63F-0CE6-41AC-8790-B7D0010D4CAB@microsoft.com...
| > | 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-odb...nd-sql-)
| > | > - 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!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > "Reda Hanna" <RedaHanna.TakeThisOut@discussions.microsoft.com> wrote in message
news:BD56BD03-E8BF-4D2B-BAFB-8618EF533554@microsoft.com...
| > | > | 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,
| > | >
| > | >
| > | >
| >
| >
| >

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!" (-;
> _____________________________________________
>
>
> "Reda Hanna" <RedaHanna.DeleteThis@discussions.microsoft.com> wrote in message news:C383985C-B780-4EC0-8444-DC59B27F9DFC@microsoft.com...
> | 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!" (-;
> | > _____________________________________________
> | >
> | >
> | > "Reda Hanna" <RedaHanna.DeleteThis@discussions.microsoft.com> wrote in message news:5BF6F63F-0CE6-41AC-8790-B7D0010D4CAB@microsoft.com...
> | > | 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-odb...nd-sql-)
> | > | > - 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!" (-;
> | > | > _____________________________________________
> | > | >
> | > | >
> | > | > "Reda Hanna" <RedaHanna.DeleteThis@discussions.microsoft.com> wrote in message
> news:BD56BD03-E8BF-4D2B-BAFB-8618EF533554@microsoft.com...
> | > | > | 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,
> | > | >
> | > | >
> | > | >
> | >
> | >
> | >
>
>
>

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!" (-;
> _____________________________________________
>
>
> "Reda Hanna" <RedaHanna RemoveThis @discussions.microsoft.com> wrote in message news:C383985C-B780-4EC0-8444-DC59B27F9DFC@microsoft.com...
> | 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!" (-;
> | > _____________________________________________
> | >
> | >
> | > "Reda Hanna" <RedaHanna RemoveThis @discussions.microsoft.com> wrote in message news:5BF6F63F-0CE6-41AC-8790-B7D0010D4CAB@microsoft.com...
> | > | 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-odb...nd-sql-)
> | > | > - 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!" (-;
> | > | > _____________________________________________
> | > | >
> | > | >
> | > | > "Reda Hanna" <RedaHanna RemoveThis @discussions.microsoft.com> wrote in message
> news:BD56BD03-E8BF-4D2B-BAFB-8618EF533554@microsoft.com...
> | > | > | 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,
> | > | >
> | > | >
> | > | >
> | >
> | >
> | >
>
>
>