Database Interface Wizard: remove unwanted fields

[EdH]

The DIW it generates a Submission Form which includes fields that I do not
want the users to fill in - like timestamp and UserID. Can I just delete them
from the submission form without creating trouble in the entry of data to the
database?

Thanks,
EdH

 

[Thomas A. Rowe]

You can disable these items under form properties, saved fields.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[EdH]

OK, thanks.

Follow up: DIW submission form works fine, but I want to change one of the
fields to be a drop down list. If I do that, the form does NOT feed the
database. No errors are reported. It just does not add any data. I tried
updating the database and fields seem to match between the form and the
dbase, but no luck. Any suggestions?

FYI the submission form is created from an existing database connection
which I created. Again, with no modifications the form feeds the data. If I
change one field it stops updating.

Thanks again,
EdH

 

[Thomas A. Rowe]

Sorry, I don't work with the FP database components, I do hand coding only.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Rob Giordano \(Crash Gordon®\)]

Instead of changing it to a drop down, try adding a dropdown (new field)...see if that works.

 

[EdH]

Thanks to both of you for your suggestions.

I believe that the problem was all along that the form fields did not match
EXACTLY the database fields. There is a flaw in FP as you can have a normal
submission form where you can enter the data, submit te data, get a
Submission Confirmation(!!!) and yet the database is NOT updated. Apparently
(and it was so in my case) error messages do not always appear when the
fields do not match exactly from the form to the database. It will just not
tell you! This is especially bad as fields are added without the users
knowledge.

I resolved my case with the following steps:

1. completely recreating my database from scratch, importing it into the
site and creating a connection

2. I created a submission form to this database using the Database Interface
Wizard thus insuring matching fields. I also removed all the fields created
by FP (or access?) and that were NOT in the original database

3. I replaced (thanks crash!) the fields that I wanted with a drop down list
(inserting a database results form) and named these drop down lists the SAME
name as the original fields I replaced.

Voila! it works!

Thanks for your input
Ed

 

[Rob Giordano \(Crash Gordon®\)]

I'm not an expert on that stuff, but have run into it before when changing fields and that was how I solved my prob.

Good luck!