How can I get the MS Access Record ID back to my confirmation page? The
Record ID is the autonumber unique identifier for the record just added to
the DB by the SUBMIT. I can get all of my submitted fields on my
confirmation for but not the record where the information resides.

Also, I want to inject that Record ID into a hidden field for paypal so I
have a direct link to the form data submitted.

http://home.att.net/~codelibrary/Fro...htm#Autonumber

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"sandrocket" <(E-Mail Removed)> wrote in message
news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
> How can I get the MS Access Record ID back to my confirmation page? The
> Record ID is the autonumber unique identifier for the record just added to
> the DB by the SUBMIT. I can get all of my submitted fields on my
> confirmation for but not the record where the information resides.
>
> Also, I want to inject that Record ID into a hidden field for paypal so I
> have a direct link to the form data submitted.

Kathleen, Thank you for the perfect assistance. I successfully added the MS
Access record ID to my confirmation page with your awsome help. With the
addition of the code tip ID is now appearing in my FrontPage 2003 as
Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
now appearing on my confirmation form.

Now, I want to pass that same record ID into a PayPal hidden field which are
controlled by web bots. I need to set the item_number to the MS Access record
ID

The hidden field code looks like this:
<input type="hidden" name="item_number" value=???>

I need the code to insert the Record ID into the hidden field. When I am in
the code view, the Insert --> Web Component is muted out, so I cannot use it
and the ID is under control of the web bot. Logically it may look like this.

<input type="hidden" name="item_number" value=fp_rs(0)>

Paul

"Kathleen Anderson [MVP - FrontPage]" wrote:

> http://home.att.net/~codelibrary/Fro...htm#Autonumber
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "sandrocket" <(E-Mail Removed)> wrote in message
> news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
> > How can I get the MS Access Record ID back to my confirmation page? The
> > Record ID is the autonumber unique identifier for the record just added to
> > the DB by the SUBMIT. I can get all of my submitted fields on my
> > confirmation for but not the record where the information resides.
> >
> > Also, I want to inject that Record ID into a hidden field for paypal so I
> > have a direct link to the form data submitted.
>
>
>

Using that same example it would be
<input type="hidden" name="item_number" value="<%=FP_SavedFields.Item("ID")%>">


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"sandrocket" <(E-Mail Removed)> wrote in message news:0CC3DD56-354A-41E2-848B-(E-Mail Removed)...
| Kathleen, Thank you for the perfect assistance. I successfully added the MS
| Access record ID to my confirmation page with your awsome help. With the
| addition of the code tip ID is now appearing in my FrontPage 2003 as
| Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
| now appearing on my confirmation form.
|
| Now, I want to pass that same record ID into a PayPal hidden field which are
| controlled by web bots. I need to set the item_number to the MS Access record
| ID
|
| The hidden field code looks like this:
| <input type="hidden" name="item_number" value=???>
|
| I need the code to insert the Record ID into the hidden field. When I am in
| the code view, the Insert --> Web Component is muted out, so I cannot use it
| and the ID is under control of the web bot. Logically it may look like this.
|
| <input type="hidden" name="item_number" value=fp_rs(0)>
|
| Paul
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > http://home.att.net/~codelibrary/Fro...htm#Autonumber
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| >
| >
| > "sandrocket" <(E-Mail Removed)> wrote in message
| > news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
| > > How can I get the MS Access Record ID back to my confirmation page? The
| > > Record ID is the autonumber unique identifier for the record just added to
| > > the DB by the SUBMIT. I can get all of my submitted fields on my
| > > confirmation for but not the record where the information resides.
| > >
| > > Also, I want to inject that Record ID into a hidden field for paypal so I
| > > have a direct link to the form data submitted.
| >
| >
| >

Excellent support! Thank you!

"sandrocket" wrote:

> Kathleen, Thank you for the perfect assistance. I successfully added the MS
> Access record ID to my confirmation page with your awsome help. With the
> addition of the code tip ID is now appearing in my FrontPage 2003 as
> Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
> now appearing on my confirmation form.
>
> Now, I want to pass that same record ID into a PayPal hidden field which are
> controlled by web bots. I need to set the item_number to the MS Access record
> ID
>
> The hidden field code looks like this:
> <input type="hidden" name="item_number" value=???>
>
> I need the code to insert the Record ID into the hidden field. When I am in
> the code view, the Insert --> Web Component is muted out, so I cannot use it
> and the ID is under control of the web bot. Logically it may look like this.
>
> <input type="hidden" name="item_number" value=fp_rs(0)>
>
> Paul
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
> > http://home.att.net/~codelibrary/Fro...htm#Autonumber
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > web: http://www.spiderwebwoman.com/resources/
> >
> >
> > "sandrocket" <(E-Mail Removed)> wrote in message
> > news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
> > > How can I get the MS Access Record ID back to my confirmation page? The
> > > Record ID is the autonumber unique identifier for the record just added to
> > > the DB by the SUBMIT. I can get all of my submitted fields on my
> > > confirmation for but not the record where the information resides.
> > >
> > > Also, I want to inject that Record ID into a hidden field for paypal so I
> > > have a direct link to the form data submitted.
> >
> >
> >

Thank you! Yes, this worked! I love this ! -- Paul

"Stefan B Rusynko" wrote:

> Using that same example it would be
> <input type="hidden" name="item_number" value="<%=FP_SavedFields.Item("ID")%>">
>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "sandrocket" <(E-Mail Removed)> wrote in message news:0CC3DD56-354A-41E2-848B-(E-Mail Removed)...
> | Kathleen, Thank you for the perfect assistance. I successfully added the MS
> | Access record ID to my confirmation page with your awsome help. With the
> | addition of the code tip ID is now appearing in my FrontPage 2003 as
> | Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
> | now appearing on my confirmation form.
> |
> | Now, I want to pass that same record ID into a PayPal hidden field which are
> | controlled by web bots. I need to set the item_number to the MS Access record
> | ID
> |
> | The hidden field code looks like this:
> | <input type="hidden" name="item_number" value=???>
> |
> | I need the code to insert the Record ID into the hidden field. When I am in
> | the code view, the Insert --> Web Component is muted out, so I cannot use it
> | and the ID is under control of the web bot. Logically it may look like this.
> |
> | <input type="hidden" name="item_number" value=fp_rs(0)>
> |
> | Paul
> |
> | "Kathleen Anderson [MVP - FrontPage]" wrote:
> |
> | > http://home.att.net/~codelibrary/Fro...htm#Autonumber
> | >
> | > --
> | >
> | > ~ Kathleen Anderson
> | > Microsoft MVP - FrontPage
> | > Spider Web Woman Designs
> | > web: http://www.spiderwebwoman.com/resources/
> | >
> | >
> | > "sandrocket" <(E-Mail Removed)> wrote in message
> | > news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
> | > > How can I get the MS Access Record ID back to my confirmation page? The
> | > > Record ID is the autonumber unique identifier for the record just added to
> | > > the DB by the SUBMIT. I can get all of my submitted fields on my
> | > > confirmation for but not the record where the information resides.
> | > >
> | > > Also, I want to inject that Record ID into a hidden field for paypal so I
> | > > have a direct link to the form data submitted.
> | >
> | >
> | >
>
>
>

In Frontpage I list a set of records using the DRW. I want to drill down
using the Record ID into the details of the record using the Record ID.

For example I may show ID and Name and I want to hyperlink using the ID to
show more specific fields in the record when I pick on the ID hyperlink but I
dont know how to do the drill down.

"sandrocket" wrote:

> Excellent support! Thank you!
>
> "sandrocket" wrote:
>
> > Kathleen, Thank you for the perfect assistance. I successfully added the MS
> > Access record ID to my confirmation page with your awsome help. With the
> > addition of the code tip ID is now appearing in my FrontPage 2003 as
> > Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
> > now appearing on my confirmation form.
> >
> > Now, I want to pass that same record ID into a PayPal hidden field which are
> > controlled by web bots. I need to set the item_number to the MS Access record
> > ID
> >
> > The hidden field code looks like this:
> > <input type="hidden" name="item_number" value=???>
> >
> > I need the code to insert the Record ID into the hidden field. When I am in
> > the code view, the Insert --> Web Component is muted out, so I cannot use it
> > and the ID is under control of the web bot. Logically it may look like this.
> >
> > <input type="hidden" name="item_number" value=fp_rs(0)>
> >
> > Paul
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> > > http://home.att.net/~codelibrary/Fro...htm#Autonumber
> > >
> > > --
> > >
> > > ~ Kathleen Anderson
> > > Microsoft MVP - FrontPage
> > > Spider Web Woman Designs
> > > web: http://www.spiderwebwoman.com/resources/
> > >
> > >
> > > "sandrocket" <(E-Mail Removed)> wrote in message
> > > news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
> > > > How can I get the MS Access Record ID back to my confirmation page? The
> > > > Record ID is the autonumber unique identifier for the record just added to
> > > > the DB by the SUBMIT. I can get all of my submitted fields on my
> > > > confirmation for but not the record where the information resides.
> > > >
> > > > Also, I want to inject that Record ID into a hidden field for paypal so I
> > > > have a direct link to the form data submitted.
> > >
> > >
> > >

http://www.spiderwebwoman.com/tutorials/picklist.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"sandrocket" <(E-Mail Removed)> wrote in message
news:7DEB334B-E1D5-4E58-9DE6-(E-Mail Removed)...
> In Frontpage I list a set of records using the DRW. I want to drill down
> using the Record ID into the details of the record using the Record ID.
>
> For example I may show ID and Name and I want to hyperlink using the ID to
> show more specific fields in the record when I pick on the ID hyperlink
> but I
> dont know how to do the drill down.
>
> "sandrocket" wrote:
>
>> Excellent support! Thank you!
>>
>> "sandrocket" wrote:
>>
>> > Kathleen, Thank you for the perfect assistance. I successfully added
>> > the MS
>> > Access record ID to my confirmation page with your awsome help. With
>> > the
>> > addition of the code tip ID is now appearing in my FrontPage 2003 as
>> > Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It
>> > is
>> > now appearing on my confirmation form.
>> >
>> > Now, I want to pass that same record ID into a PayPal hidden field
>> > which are
>> > controlled by web bots. I need to set the item_number to the MS Access
>> > record
>> > ID
>> >
>> > The hidden field code looks like this:
>> > <input type="hidden" name="item_number" value=???>
>> >
>> > I need the code to insert the Record ID into the hidden field. When I
>> > am in
>> > the code view, the Insert --> Web Component is muted out, so I cannot
>> > use it
>> > and the ID is under control of the web bot. Logically it may look like
>> > this.
>> >
>> > <input type="hidden" name="item_number" value=fp_rs(0)>
>> >
>> > Paul
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> > > http://home.att.net/~codelibrary/Fro...htm#Autonumber
>> > >
>> > > --
>> > >
>> > > ~ Kathleen Anderson
>> > > Microsoft MVP - FrontPage
>> > > Spider Web Woman Designs
>> > > web: http://www.spiderwebwoman.com/resources/
>> > >
>> > >
>> > > "sandrocket" <(E-Mail Removed)> wrote in message
>> > > news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
>> > > > How can I get the MS Access Record ID back to my confirmation page?
>> > > > The
>> > > > Record ID is the autonumber unique identifier for the record just
>> > > > added to
>> > > > the DB by the SUBMIT. I can get all of my submitted fields on my
>> > > > confirmation for but not the record where the information resides.
>> > > >
>> > > > Also, I want to inject that Record ID into a hidden field for
>> > > > paypal so I
>> > > > have a direct link to the form data submitted.
>> > >
>> > >
>> > >

Kathleen, That was the fix; it is working. Thank you !

"Kathleen Anderson [MVP - FrontPage]" wrote:

> http://home.att.net/~codelibrary/Fro...htm#Autonumber
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "sandrocket" <(E-Mail Removed)> wrote in message
> news:8B77D560-1820-48FE-8AA4-(E-Mail Removed)...
> > How can I get the MS Access Record ID back to my confirmation page? The
> > Record ID is the autonumber unique identifier for the record just added to
> > the DB by the SUBMIT. I can get all of my submitted fields on my
> > confirmation for but not the record where the information resides.
> >
> > Also, I want to inject that Record ID into a hidden field for paypal so I
> > have a direct link to the form data submitted.
>
>
>