DoCmd.RunSQL error Help
From: chris (anonymous.chris_at_mercury-projects.co.nz.discussions.microsoft.com)
Date: 04/29/04
- Next message: Bill Taylor: "Re: Splitting a record in two"
- Previous message: B Nieds: "Re: Link table alternative"
- In reply to: Kate: "DoCmd.RunSQL error Help"
- Next in thread: Kate: "DoCmd.RunSQL error Help"
- Reply: Kate: "DoCmd.RunSQL error Help"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 14:34:43 -0700
RunSQL only works with action queries (insert, update
delete etc) that do not return recordset objects. A select
query needs a recordset object to store its results
>-----Original Message-----
>I'm trying to execute an SQL statement in a macro
attached
>to a form but get error A RunSQL action requires an
>argument consisting of an SQL statement. What is wrong?
>
>Dim strSQL As String
>
>strSQL = "SELECT AVAILABILITY.BookingDate,
>AVAILABILITY.Period, AVAILABILITY.Room," _
> & "AVAILABILITY.[Day Number], AVAILABILITY.[Booking
ID] "
>_
> & "FROM AVAILABILITY " _
> & "WHERE (((AVAILABILITY.BookingDate)=Forms![SINGLE
>BOOKING AVAILABILITY]" _
> & "!BookingDate) & ((AVAILABILITY.Period)=Forms![SINGLE
>BOOKING AVAILABILITY]" _
> & "!Combo8) & ((AVAILABILITY.Room)=Forms![SINGLE BOOKING
>AVAILABILITY]!Combo10))"
>
>DoCmd.RunSQL strSQL
>
>SQL should look like this:
>
>SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
>AVAILABILITY.Room, AVAILABILITY.[Day Number],
AVAILABILITY.
>[Booking ID]
>FROM AVAILABILITY
>WHERE (((AVAILABILITY.BookingDate)=Forms![SINGLE BOOKING
>AVAILABILITY]!BookingDate) And ((AVAILABILITY.Period)
>=Forms![SINGLE BOOKING AVAILABILITY]!Combo8) And
>((AVAILABILITY.Room)=Forms![SINGLE BOOKING AVAILABILITY]!
>Combo10));
>
>.
>
- Next message: Bill Taylor: "Re: Splitting a record in two"
- Previous message: B Nieds: "Re: Link table alternative"
- In reply to: Kate: "DoCmd.RunSQL error Help"
- Next in thread: Kate: "DoCmd.RunSQL error Help"
- Reply: Kate: "DoCmd.RunSQL error Help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
