Online Form Submission Problem

[Dave]

I have an online form where users fill out
information...no big deal, but, I have had a couple of
users state they filled out the form, yet I never received
the data. (the data is sent to an access database.) They
receive the form confirmation page, yet I receive no
data. I have confirmed this isn't user error with a
person on the phone. Funny thing is, for my access, it
skips the autonumber field (meaning if I had 75 entries,
someone tried to enter and it didn't work...but then
someone else entered and it DID work, then the good entry
would get number 77.....76 just disapears.)

Anyone have any ideas on what would be causing this data
to be lost / the autonumber skip on the entries that are
lost?

 

[Kevin Spencer]

One possibility is that the Insert failed. An Insert into a table can fail
if, for example, you violate a primary key by entering a duplicate value in
a primary key or uniquely-indexed column. It can happen if you try to insert
characters into a numeric field. Are you sure that you're validating all the
input data correctly?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living

 

[Dave]

Well, I changed a couple things in my access portion of
the entry. I changed all fields that had numeric data to
a Number field from Text (that shouldn't matter, but it
should be done...only thing passed on those fields is a 1
or 0.) I think the changes that may have been causing the
problem was a comment field that was labled as text set to
255 characters...some comments go belong that amount, so I
changed it to a memo field. That is more than likely the
problem; however, it doesn't make sense why it would skip
auto numbers without entering ANY data at all. And, it
doesn't make sense why I was able to enter the exact same
data from here (on the network the server is on) using the
online form, and it worked, and why the end user wasn't
able to.

I also changed my validation on the date field to be just
straight text instead of date/time and a date format as
they enter in date formats differently (working on the
code to combine month, day, year as drop down menus and
combine them into one field to enter into the
database...thats later in life however