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 = ':
arentEmail::' ,
| > > > 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 = ':
hoto::' , DVD = ':
VD::' ,
| > > > Craft = '::Craft::' , CarePackage = '::CarePackage::' , ClimbingWall =
| > > > '::ClimbingWall::' , ZipLine = '::ZipLine::' , AgreeWithPolicy =
| > > > '::AgreeWithPolicy::' , Payment1 = ':
ayment1::' , Check1 =
| > > > '::Check1::' , Payment2 = ':
ayment2::' , Check2 = '::Check2::' ,
| > > > Payment3 = ':
ayment3::' , Check3 = '::Check3::' , RegiteredOnline =
| > > > '::RegiteredOnline::' , Allergies = '::Allergies::' , Cardiac =
| > > > '::Cardiac::' , Kidney = '::Kidney::' , Seizures = '::Seizures::' ,
| > > > Lungs_Asthma = '::Lungs_Asthma::' , Diabetic = ':
iabetic::' ,
| > > > DietaryConcerns = ':
ietaryConcerns::' , DietyaryConcDesc =
| > > > ':
ietyaryConcDesc::' , InfectiousDis = '::InfectiousDis::' ,
| > > > Chkd4Lice = '::Chkd4Lice::' , DrugReactions = ':
rugReactions::' ,
| > > > DrucReactionsDesc = ':
rucReactionsDesc::' , AllerghPen =
| > > > '::AllerghPen::' , RestrictedAct = '::RestrictedAct::' ,
| > > > RestrictedActDesc = '::RestrictedActDesc::' , TetanusBoster =
| > > > '::TetanusBoster::' , CurrentImm = '::CurrentImm::' , ImmunzExplained =
| > > > '::ImmunzExplained::' , Doctor = ':
octor::' , DocsPHone =
| > > > ':
ocsPHone::' , PreRegFee = ':
reRegFee::' , 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.
| > > >> > |
|