Edit User Information in Database Error Message

  • Thread starter frontpagecustoms.com
  • Start date
F

frontpagecustoms.com

I'm using the Database Interface Wizard and on some of the Access
tables it works great on others I get the following error message.

Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

Please help me troubleshoot this.
 
S

Stefan B Rusynko

Post the code for your sql statement

--

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


| I'm using the Database Interface Wizard and on some of the Access
| tables it works great on others I get the following error message.
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| Please help me troubleshoot this.
|
 
F

frontpagecustoms.com

I'm guessing this is what you need. I think this is the sql statement
from the update page.

UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
CamperFirstName = '::CamperFirstName::' , CamperLastName =
'::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
CamperEmail = '::CamperEmail::' , CamperFallGrade =
'::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
ChurchName = '::ChurchName::' , RoommateRequest1 =
'::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
'::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
'::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
'::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
'::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
'::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
'::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
'::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
'::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
'::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
'::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
, Adjustments = '::Adjustments::' , AdjustmentReason =
'::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
::CamperID::)

from which page? The edit page or the update page.

Post the code for your sql statement

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| tables it works great on others I get the following error message.
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| Please help me troubleshoot this.
|
 
K

Kathleen Anderson [MVP - FrontPage]

Count is a reserved word in Access 2002 and Access 2003, and you may have
others. Check all your field names against this list:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


frontpagecustoms.com said:
I'm guessing this is what you need. I think this is the sql statement
from the update page.

UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
CamperFirstName = '::CamperFirstName::' , CamperLastName =
'::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
CamperEmail = '::CamperEmail::' , CamperFallGrade =
'::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
ChurchName = '::ChurchName::' , RoommateRequest1 =
'::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
'::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
'::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
'::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
'::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
'::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
'::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
'::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
'::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
'::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
'::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
, Adjustments = '::Adjustments::' , AdjustmentReason =
'::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
::CamperID::)

from which page? The edit page or the update page.

Post the code for your sql statement

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
messageusing the Database Interface Wizard and on some of the Access
| tables it works great on others I get the following error message.
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| Please help me troubleshoot this.
|
 
F

frontpagecustoms.com

So if I rename the access field then the database should work?

Count is a reserved word in Access 2002 and Access 2003, and you may have
others. Check all your field names against this list:http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/

frontpagecustoms.com said:
I'm guessing this is what you need. I think this is the sql statement
from the update page.
UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
CamperFirstName = '::CamperFirstName::' , CamperLastName =
'::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
CamperEmail = '::CamperEmail::' , CamperFallGrade =
'::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
ChurchName = '::ChurchName::' , RoommateRequest1 =
'::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
'::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
'::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
'::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
'::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
'::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
'::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
'::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
'::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
'::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
'::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
, Adjustments = '::Adjustments::' , AdjustmentReason =
'::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
::CamperID::)
from which page? The edit page or the update page.
Post the code for your sql statement
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
messageusing the Database Interface Wizard and on some of the Access
| tables it works great on others I get the following error message.
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| Please help me troubleshoot this.
|
 
S

Stefan B Rusynko

Yes, but you will need to redo the wizard so it recognizes your new field names

--

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


| So if I rename the access field then the database should work?
|
| On Jan 23, 8:45 am, "Kathleen Anderson [MVP - FrontPage]"
| > Count is a reserved word in Access 2002 and Access 2003, and you may have
| > others. Check all your field names against this list:http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web:http://www.spiderwebwoman.com/resources/
| >
| >
| > > I'm guessing this is what you need. I think this is the sql statement
| > > from the update page.
| >
| > > UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
| > > CamperFirstName = '::CamperFirstName::' , CamperLastName =
| > > '::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
| > > CamperEmail = '::CamperEmail::' , CamperFallGrade =
| > > '::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
| > > ChurchName = '::ChurchName::' , RoommateRequest1 =
| > > '::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
| > > RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
| > > HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
| > > MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
| > > ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
| > > Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
| > > '::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
| > > '::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
| > > '::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
| > > Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
| > > '::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
| > > '::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
| > > Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
| > > DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
| > > '::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
| > > Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
| > > DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
| > > '::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
| > > RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
| > > '::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
| > > '::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
| > > '::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
| > > , Adjustments = '::Adjustments::' , AdjustmentReason =
| > > '::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
| > > ::CamperID::)
| >
| > >> from which page? The edit page or the update page.
| >
| >
| > >> > Post the code for your sql statement
| >
| > >> > --
| >
| > >> > _____________________________________________
| > >> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > >> > "Warning - Using the F1 Key will not break anything!" (-;
| > >> > _____________________________________________
| >
| > >> > message| > >> > using the Database Interface Wizard and on some of the Access
| > >> > | tables it works great on others I get the following error message.
| > >> > |
| > >> > | Database Results Wizard Error
| > >> > | Description: Syntax error in UPDATE statement.
| > >> > | Number: -2147217900 (0x80040E14)
| > >> > | Source: Microsoft JET Database Engine
| > >> > |
| > >> > | Please help me troubleshoot this.
| > >> > |
|
 
F

frontpagecustoms.com

Can I simply change "COUNT" to "Count1"

So if I rename the access field then the database should work?

Count is a reserved word in Access 2002 and Access 2003, and you may have
others. Check all your field names against this list:http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:http://www.spiderwebwoman.com/resources/
I'm guessing this is what you need. I think this is the sql statement
from the update page.
UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
CamperFirstName = '::CamperFirstName::' , CamperLastName =
'::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
CamperEmail = '::CamperEmail::' , CamperFallGrade =
'::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
ChurchName = '::ChurchName::' , RoommateRequest1 =
'::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
'::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
'::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
'::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
'::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
'::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
'::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
'::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
'::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
'::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
'::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
, Adjustments = '::Adjustments::' , AdjustmentReason =
'::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
::CamperID::)
from which page? The edit page or the update page.
Post the code for your sql statement
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
messageusing the Database Interface Wizard and on some of the Access
| tables it works great on others I get the following error message.
|
| Database Results Wizard Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| Please help me troubleshoot this.
|
 
S

Stefan B Rusynko

sure

--

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


| Can I simply change "COUNT" to "Count1"
|
| > So if I rename the access field then the database should work?
| >
| > On Jan 23, 8:45 am, "Kathleen Anderson [MVP - FrontPage]"
| >
| > > Count is a reserved word in Access 2002 and Access 2003, and you may have
| > > others. Check all your field names against this list:http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
| >
| > > --
| >
| > > ~ Kathleen Anderson
| > > Microsoft MVP - FrontPage
| > > Spider Web Woman Designs
| > > web:http://www.spiderwebwoman.com/resources/
| >
| >
| > > > I'm guessing this is what you need. I think this is the sql statement
| > > > from the update page.
| >
| > > > UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
| > > > CamperFirstName = '::CamperFirstName::' , CamperLastName =
| > > > '::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
| > > > CamperEmail = '::CamperEmail::' , CamperFallGrade =
| > > > '::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
| > > > ChurchName = '::ChurchName::' , RoommateRequest1 =
| > > > '::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
| > > > RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
| > > > HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
| > > > MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
| > > > ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
| > > > Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
| > > > '::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
| > > > '::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
| > > > '::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
| > > > Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
| > > > '::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
| > > > '::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
| > > > Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
| > > > DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
| > > > '::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
| > > > Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
| > > > DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
| > > > '::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
| > > > RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
| > > > '::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
| > > > '::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
| > > > '::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
| > > > , Adjustments = '::Adjustments::' , AdjustmentReason =
| > > > '::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
| > > > ::CamperID::)
| >
| > > >> from which page? The edit page or the update page.
| >
| >
| > > >> > Post the code for your sql statement
| >
| > > >> > --
| >
| > > >> > _____________________________________________
| > > >> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > > >> > "Warning - Using the F1 Key will not break anything!" (-;
| > > >> > _____________________________________________
| >
| > > >> > message| > > >> > using the Database Interface Wizard and on some of the Access
| > > >> > | tables it works great on others I get the following error message.
| > > >> > |
| > > >> > | Database Results Wizard Error
| > > >> > | Description: Syntax error in UPDATE statement.
| > > >> > | Number: -2147217900 (0x80040E14)
| > > >> > | Source: Microsoft JET Database Engine
| > > >> > |
| > > >> > | Please help me troubleshoot this.
| > > >> > |
|
 
F

frontpagecustoms.com

Thanks that is working great now!

sure

--

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

|
| > So if I rename the access field then the database should work?
| >
| > On Jan 23, 8:45 am, "Kathleen Anderson [MVP - FrontPage]"
| > > others. Check all your field names against this list:http://support.microsoft.com/default.aspx?scid=kb;en-us;286335
| >
| > > --
| >
| > > ~ Kathleen Anderson
| > > Microsoft MVP - FrontPage
| > > Spider Web Woman Designs
| > > web:http://www.spiderwebwoman.com/resources/
| >
| >
| > > > I'm guessing this is what you need. I think this is the sql statement
| > > > from the update page.
| >
| > > > UPDATE CamperRegistrationInfo SET ParentEmail = '::parentEmail::' ,
| > > > CamperFirstName = '::CamperFirstName::' , CamperLastName =
| > > > '::CamperLastName::' , CamperAdditlFamily = '::CamperAdditlFamily::' ,
| > > > CamperEmail = '::CamperEmail::' , CamperFallGrade =
| > > > '::CamperFallGrade::' , CamperBirthDate = '::CamperBirthDate::' ,
| > > > ChurchName = '::ChurchName::' , RoommateRequest1 =
| > > > '::RoommateRequest1::' , RoommateRequest2 = '::RoommateRequest2::' ,
| > > > RegisteringFor = '::RegisteringFor::' , Count = '::Count::' ,
| > > > HealthNotes = '::HealthNotes::' , Medications = '::Medications::' ,
| > > > MedInstructions = '::MedInstructions::' , Shirt = '::Shirt::' ,
| > > > ShirtSize = '::ShirtSize::' , Photo = '::photo::' , DVD = '::DVD::' ,
| > > > Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
| > > > '::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
| > > > '::AgreeWithPolicy::' , Payment1 = '::payment1::' , Check1 =
| > > > '::Check1::' , Payment2 = '::payment2::' , Check2 = '::Check2::' ,
| > > > Payment3 = '::payment3::' , Check3 = '::Check3::' , RegiteredOnline =
| > > > '::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
| > > > '::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
| > > > Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = '::Diabetic::' ,
| > > > DietaryConcerns = '::DietaryConcerns::' , DietyaryConcDesc =
| > > > '::DietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
| > > > Chkd4Lice = '::Chkd4Lice::' , DrugReactions = '::DrugReactions::' ,
| > > > DrucReactionsDesc = '::DrucReactionsDesc::' , AllerghPen =
| > > > '::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
| > > > RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
| > > > '::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
| > > > '::ImmunzExplained::' , Doctor = '::Doctor::' , DocsPHone =
| > > > '::DocsPHone::' , PreRegFee = '::preRegFee::' , Tuition = '::Tuition::'
| > > > , Adjustments = '::Adjustments::' , AdjustmentReason =
| > > > '::AdjustmentReason::' , Gender = '::Gender::' WHERE (CamperID =
| > > > ::CamperID::)
| >
| > > >> from which page? The edit page or the update page.
| >
| >
| > > >> > Post the code for your sql statement
| >
| > > >> > --
| >
| > > >> > _____________________________________________
| > > >> > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > > >> > "Warning - Using the F1 Key will not break anything!" (-;
| > > >> > _____________________________________________
| >
| > > >> > message| > > >> > using the Database Interface Wizard and on some of the Access
| > > >> > | tables it works great on others I get the following error message.
| > > >> > |
| > > >> > | Database Results Wizard Error
| > > >> > | Description: Syntax error in UPDATE statement.
| > > >> > | Number: -2147217900 (0x80040E14)
| > > >> > | Source: Microsoft JET Database Engine
| > > >> > |
| > > >> > | Please help me troubleshoot this.
| > > >> > |
|
 

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