Add a field in FP DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, I said nevermind to my post yesterday, becasue I thought that I found the
answer to my question, but it seems a little bit easier "said than
done"......I am trying to add a new field to a database which is already
present in my web, so I read some threads which have suggestions on how, but
they seem to have different wording, and all talk about adding the field to
"the form"........what form?
1) Is it the "database editor", or the "results page"?
2) Is it opened in design mode on disk, or on server......or does it matter?

The only place I can see "form properties" is in the upper frame of the
"database editor" screen, I have tried everything so far, and nothing works

Mike
 
If you have a FP Form set to use a DB (generated by FP) and you add a form Field
Using Form Properties Options you should get a Database Results Dialog which lets you select the DB (and Saved Fields, Additional
Fields) and then either Create or Update the DB (to add your fields)

Or
File Export the DB to say your desktop
Open it in Access and create your field in the table
File Import it back to the same location in your FP web
- Change your forms or wizards to use the new field


--




| OK, I said nevermind to my post yesterday, becasue I thought that I found the
| answer to my question, but it seems a little bit easier "said than
| done"......I am trying to add a new field to a database which is already
| present in my web, so I read some threads which have suggestions on how, but
| they seem to have different wording, and all talk about adding the field to
| "the form"........what form?
| 1) Is it the "database editor", or the "results page"?
| 2) Is it opened in design mode on disk, or on server......or does it matter?
|
| The only place I can see "form properties" is in the upper frame of the
| "database editor" screen, I have tried everything so far, and nothing works
|
| Mike
 
sorry to take so long but I haven't been able to check on this for a couple
of days.
You said if I have a form........this is a database, and results page. There
is no form. I did not check the option for a submissions page during setup.
so "add form field" is greyed out.
so, I was wondering how to add a field to a database which is already made.

Mike
 
Then you need to follow my other steps for exporting the DB, editing in Access to add the field, and importing the DB

--




| sorry to take so long but I haven't been able to check on this for a couple
| of days.
| You said if I have a form........this is a database, and results page. There
| is no form. I did not check the option for a submissions page during setup.
| so "add form field" is greyed out.
| so, I was wondering how to add a field to a database which is already made.
|
| Mike
|
| "Stefan B Rusynko" wrote:
|
| > If you have a FP Form set to use a DB (generated by FP) and you add a form Field
| > Using Form Properties Options you should get a Database Results Dialog which lets you select the DB (and Saved Fields,
Additional
| > Fields) and then either Create or Update the DB (to add your fields)
| >
| > Or
| > File Export the DB to say your desktop
| > Open it in Access and create your field in the table
| > File Import it back to the same location in your FP web
| > - Change your forms or wizards to use the new field
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | OK, I said nevermind to my post yesterday, becasue I thought that I found the
| > | answer to my question, but it seems a little bit easier "said than
| > | done"......I am trying to add a new field to a database which is already
| > | present in my web, so I read some threads which have suggestions on how, but
| > | they seem to have different wording, and all talk about adding the field to
| > | "the form"........what form?
| > | 1) Is it the "database editor", or the "results page"?
| > | 2) Is it opened in design mode on disk, or on server......or does it matter?
| > |
| > | The only place I can see "form properties" is in the upper frame of the
| > | "database editor" screen, I have tried everything so far, and nothing works
| > |
| > | Mike
| >
| >
| >
 
I guess that the problem is that everyone is assuming that when this database
was created that during setup a submission page was also
created............The database that I have been trying to make was only for
displaying data on a web page from a database which I will enter data into,
so I never created the db with a submission page.
I created a new db and checked to have a submission page created, and voila!
there I CAN add fields, and edit the existing ones.......
So now my question is........If you are making a db like mine, (to diplay
data from a db on a web page) where no visitor data entry will be made, would
you use the submission page to update your db data, or use the db editor like
I was trying to do?
It is obvious that if I want to be able to add or edit fields, that I will
have to let the submission page be created, but should I use it?

Mike
 
If you are not using Access to create / edit your DB, and relying only on wizards, yes you would need the DBIW to edit the content
of the DB (that you are just using for display)

--




|I guess that the problem is that everyone is assuming that when this database
| was created that during setup a submission page was also
| created............The database that I have been trying to make was only for
| displaying data on a web page from a database which I will enter data into,
| so I never created the db with a submission page.
| I created a new db and checked to have a submission page created, and voila!
| there I CAN add fields, and edit the existing ones.......
| So now my question is........If you are making a db like mine, (to diplay
| data from a db on a web page) where no visitor data entry will be made, would
| you use the submission page to update your db data, or use the db editor like
| I was trying to do?
| It is obvious that if I want to be able to add or edit fields, that I will
| have to let the submission page be created, but should I use it?
|
| Mike
|
| "Miklb58" wrote:
|
| > OK, I said nevermind to my post yesterday, becasue I thought that I found the
| > answer to my question, but it seems a little bit easier "said than
| > done"......I am trying to add a new field to a database which is already
| > present in my web, so I read some threads which have suggestions on how, but
| > they seem to have different wording, and all talk about adding the field to
| > "the form"........what form?
| > 1) Is it the "database editor", or the "results page"?
| > 2) Is it opened in design mode on disk, or on server......or does it matter?
| >
| > The only place I can see "form properties" is in the upper frame of the
| > "database editor" screen, I have tried everything so far, and nothing works
| >
| > Mike
 
Back
Top