A Challenging Problem I"m Trying to Resolve ....

This is a multi-part message in MIME format.

------=_NextPart_000_0053_01C5E51F.5888BBB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

This is a copy of a message I previously posted in a Microsoft Access =
Newsgroup, but it was suggested to me that my problem is ASP related and =
not Access, and hence I'm posting in this newsgroup now instead.

Hi everyone,
I've got quite a specific query that I'm trying to resolve with =
Microsoft Access and I'm hopeful someone out there can offer a solution =
to my problem.=20

I have records that I'm displaying on a web page from an Access database =
and what I would like to do is include a 'Buy Now' button at the end of =
each record, so when the particular .aspx page is accessed through a =
users browser and the data pulled from the database, it looks something =
like the following:

Product A Description A Price A 'Buy Now Button'
Product B Description B Price B 'Buy Now Button'
Product C Description C Price C 'Buy Now Button'

I'm trying to avoid having to manually add the button to the record by =
way of an OLE Object field, I fear that could be really time consuming. =
I have some code that will work behind each button but I need to find a =
way around two specific problems:

Firstly, how to display the same 'Buy Now' button (or image) at the end =
of each record, without the necessity to add it manually to the web page =
- and for obvious reasons this would be a headache scenario because new =
records will be added and old ones deleted on a regular basis. I =
therefore need an automated way to include this button each time a new =
record is added.

The second issue I have is how to change two of the components within =
that code so each Buy Now button will represent the unique product it is =
displayed next to, for example I need to work out how to change the =
'Product Name' and 'Price' within the code so its identical to the =
'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time a =
new record is added.

I know this sounds complicated but I am sure there must be a way around =
this, perhaps using Visual Basic for Applications within the Access =
Database itself, but I'm not a programmer so I'm a little unsure how to =
apply the correct VB code to accomplish this task.

If anyone has a suitable solution for this problem I really would be =
grateful.

Many thanks
Wayne

As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 on a =
Windows 2003 Datacentre Server with ASP.NET 1.1 Installed


------=_NextPart_000_0053_01C5E51F.5888BBB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: A Challenging Problem I"m Trying to Resolve ....

Wayne wrote:
> This is a copy of a message I previously posted in a Microsoft Access
> Newsgroup, but it was suggested to me that my problem is ASP related
> and not Access, and hence I'm posting in this newsgroup now instead.
>
> Hi everyone,
> I've got quite a specific query that I'm trying to resolve with
> Microsoft Access and I'm hopeful someone out there can offer a
> solution to my problem.
>
> I have records that I'm displaying on a web page from an Access
> database and what I would like to do is include a 'Buy Now' button at
> the end of each record, so when the particular .aspx page

Oops! You're still in the wrong place.
There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-knowledgeable person here who
can answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.aspnet.

> is accessed
> through a users browser and the data pulled from the database, it
> looks something like the following:
>
> Product A Description A Price A 'Buy Now Button'
> Product B Description B Price B 'Buy Now Button'
> Product C Description C Price C 'Buy Now Button'
>
> I'm trying to avoid having to manually add the button to the record
> by way of an OLE Object field, I fear that could be really time
> consuming. I have some code that will work behind each button but I
> need to find a way around two specific problems:
>
> Firstly, how to display the same 'Buy Now' button (or image) at the
> end of each record, without the necessity to add it manually to the

This would be very easy using a datagrid. See the documentation at
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconCr eatingASPWebApplications.asp

Specifically, here:
http://msdn.microsoft.com/library/en-us/vbcon/html/vbconData GridWebControl.asp

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: A Challenging Problem I"m Trying to Resolve ....

This is a multi-part message in MIME format.

------=_NextPart_000_0091_01C5E530.42C16A50
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Thank you Bob, I appreciate your reply - I shall head over to that =
newsgroup now :)

Thanks again
Wayne

"Bob Barrows [MVP]" wrote in message =
news:uf1EiSS5FHA.3188@TK2MSFTNGP15.phx.gbl...
Wayne wrote:
> This is a copy of a message I previously posted in a Microsoft =
Access
> Newsgroup, but it was suggested to me that my problem is ASP related
> and not Access, and hence I'm posting in this newsgroup now instead.
>
> Hi everyone,
> I've got quite a specific query that I'm trying to resolve with
> Microsoft Access and I'm hopeful someone out there can offer a
> solution to my problem.
>
> I have records that I'm displaying on a web page from an Access
> database and what I would like to do is include a 'Buy Now' button =
at
> the end of each record, so when the particular .aspx page

Oops! You're still in the wrong place.
There was no way for you to know it, but this is a classic asp =
newsgroup.
While you may be lucky enough to find a dotnet-knowledgeable person =
here who
can answer your question, you can eliminate the luck factor by posting =
your
question to a group where those dotnet-knowledgeable people hang out. =
I
suggest microsoft.public.dotnet.framework.aspnet.

> is accessed
> through a users browser and the data pulled from the database, it
> looks something like the following:
>
> Product A Description A Price A 'Buy Now Button'
> Product B Description B Price B 'Buy Now Button'
> Product C Description C Price C 'Buy Now Button'
>
> I'm trying to avoid having to manually add the button to the record
> by way of an OLE Object field, I fear that could be really time
> consuming. I have some code that will work behind each button but I
> need to find a way around two specific problems:
>
> Firstly, how to display the same 'Buy Now' button (or image) at the
> end of each record, without the necessity to add it manually to the

This would be very easy using a datagrid. See the documentation at
=
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconCr eatingASPWebA=
pplications.asp

Specifically, here:
=
http://msdn.microsoft.com/library/en-us/vbcon/html/vbconData GridWebContro=
l.asp

Bob Barrows
--=20
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"=20


------=_NextPart_000_0091_01C5E530.42C16A50
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



charset=3Dwindows-1252">