Help me !

  • Thread starter Thread starter Kate
  • Start date Start date
K

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
 
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.
 
Should
Set AVAILABILITY.[Bokking ID]
actually be
Set AVAILABILITY.[Booking ID]
 
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)



tina said:
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.


Kate said:
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
Click to expand...
Click to expand...
 
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
Click to expand...


.
Click to expand...
 
Back
Top