"JL" <design4online@REMOVETHISBIThotmail.com> wrote in message
news:l3YMa.503$PK2.151@newsfep1-gui.server.ntli.net...

> Hi,
>
> I have an Access database with a query that selects a set of records from
> one table (work categories) and inserts them (multiple rows) in to a
> timesheet table, along with the employee's name and selected week number
> (both of which are variables inputted by the user).
> i.e. each record from the employee's chosen work categories gets inserted

in

> to a new row in the timesheet table, with their name and chosen week

number

> inserted (these are the same for each row in this recordset instance).
>
> I want to execute this query from an intranet based ASP file, using two

text

> boxes and a submit button, but can't get it to work.
>
> The query works great from within Access (by double clicking), but I am
> having problems defining the code I need to pass the parameters and

execute

> the query from the ASP file.
>
> Has anyone got any ideas on what I can use here?
>
> Many thanks
>
> JL
>
>

The semi colon at the end of the statement could cause you some grief

cm

"JL" <design4online@REMOVETHISBIThotmail.com> wrote in message
news:l3YMa.503$PK2.151@newsfep1-gui.server.ntli.net...

> Hi,
>
> I have an Access database with a query that selects a set of records from
> one table (work categories) and inserts them (multiple rows) in to a
> timesheet table, along with the employee's name and selected week number
> (both of which are variables inputted by the user).
> i.e. each record from the employee's chosen work categories gets inserted

in

> to a new row in the timesheet table, with their name and chosen week

number

> inserted (these are the same for each row in this recordset instance).
>
> I want to execute this query from an intranet based ASP file, using two

text

> boxes and a submit button, but can't get it to work.
>
> The query works great from within Access (by double clicking), but I am
> having problems defining the code I need to pass the parameters and

execute

> the query from the ASP file.
>
> Has anyone got any ideas on what I can use here?
>
> Many thanks
>
> JL
>
>

The semi colon at the end of the statement could cause you some grief

cm