Help me !

[Kate]

I want to set the follwoing SQL up as a string so that I
can do a DoCmd.RunSQL strSQL but I keep getting syntax
and other errors. What should this look like:

Update AVAILABILITY
Set AVAILABILITY.[Bokking ID] = BOOKING.[Booking ID]
WHERE (((AVAILABILITY.BookingDate)=Forms![SINGLE BOOKING
AVAILABILITY]!BookingDate) And ((AVAILABILITY.Period)
=Forms![SINGLE BOOKING AVAILABILITY]!Combo8) And
((AVAILABILITY.Room)=Forms![SINGLE BOOKING AVAILABILITY]!
Combo10));

Thanks for your help

 

[tina]

you've asked this question over and over again in multiple threads. and
you've been given more than one workable solution. you're wasting
everybody's time with these repetitive posts. go back and look for your
previous threads, in the various newsgroup categories you've posted in, and
utilize one of the answers already given to you.

 

[Alphonse Giambrone]

Should
Set AVAILABILITY.[Bokking ID]
actually be
Set AVAILABILITY.[Booking ID]

 

[Douglas J. Steele]

Or if you can't get the suggested solutions to work, post back the exact
code you've changed to, and say what's not working. Give the exact error
message(s).

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

you've asked this question over and over again in multiple threads. and
you've been given more than one workable solution. you're wasting
everybody's time with these repetitive posts. go back and look for your
previous threads, in the various newsgroup categories you've posted in, and
utilize one of the answers already given to you.

I want to set the follwoing SQL up as a string so that I
can do a DoCmd.RunSQL strSQL but I keep getting syntax
and other errors. What should this look like:

Update AVAILABILITY
Set AVAILABILITY.[Bokking ID] = BOOKING.[Booking ID]
WHERE (((AVAILABILITY.BookingDate)=Forms![SINGLE BOOKING
AVAILABILITY]!BookingDate) And ((AVAILABILITY.Period)
=Forms![SINGLE BOOKING AVAILABILITY]!Combo8) And
((AVAILABILITY.Room)=Forms![SINGLE BOOKING AVAILABILITY]!
Combo10));

Thanks for your help

 

[Kate]

Thanks, That was it! I just couldn't spot it amongst all
those quotes!

-----Original Message-----
Should
Set AVAILABILITY.[Bokking ID]
actually be
Set AVAILABILITY.[Booking ID]

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us

I want to set the follwoing SQL up as a string so that I
can do a DoCmd.RunSQL strSQL but I keep getting syntax
and other errors. What should this look like:

Update AVAILABILITY
Set AVAILABILITY.[Bokking ID] = BOOKING.[Booking ID]
WHERE (((AVAILABILITY.BookingDate)=Forms![SINGLE BOOKING
AVAILABILITY]!BookingDate) And ((AVAILABILITY.Period)
=Forms![SINGLE BOOKING AVAILABILITY]!Combo8) And
((AVAILABILITY.Room)=Forms![SINGLE BOOKING AVAILABILITY]!
Combo10));

Thanks for your help

.