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

W

Wayne

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 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
 
A

aaron.kempf

what the **** are you doing running pirated software kid?

i mean.. did you BUY datacentre?

fucking idiot go screw yourself and buy the software

LEARN TO FUCKING PROGRAM

theres a good place to start.
 
T

tina

foul language and personal attacks are not welcome in this newsgroup. if you
have no *constructive* help, suggestions, or criticism to offer - in a
courteous manner - then please don't post.
 
B

Brendan Reynolds

This is something that would be done in the ASP page, not in Access. I
suggest you post your question in an ASP newsgroup.

--
Brendan Reynolds

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 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
 
W

Wayne

Thanks Brendan, I appreciate the reply.

Kind Regards,
Wayne

This is something that would be done in the ASP page, not in Access. I
suggest you post your question in an ASP newsgroup.

--
Brendan Reynolds

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 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
 
J

john sumner

tina said:
foul language and personal attacks are not welcome in this newsgroup. if you
have no *constructive* help, suggestions, or criticism to offer - in a
courteous manner - then please don't post.
Click to expand...
Nor is top posting tina, be bottom post if that is not too much of a problem
for you.
 
D

Douglas J Steele

john sumner said:
Nor is top posting tina, be bottom post if that is not too much of a problem
for you.
Click to expand...

There's nothing non-constructive about top-posting. I personally prefer it,
as it's consistent with the e-mail I receive, and it saves me having to
scroll to the bottom to see what the latest poster has to say.
 
J

john sumner

Douglas J Steele said:
There's nothing non-constructive about top-posting. I personally prefer it,
as it's consistent with the e-mail I receive, and it saves me having to
scroll to the bottom to see what the latest poster has to say.
Click to expand...

Oh please there a lot of people it annoys like me, and i am ready to start
plonking people who do that.
 
F

Fred Boer

Well John, plonk away! Like Doug, I am a dedicated top-poster! The way I see
it, the poster to whom I am replying will most likely already have read all
the earlier information, and will only be interested in the new post.
Scrolling to the bottom to see what's new is a pain...

Of course, it's horses for courses... ;)

Cheers!
Fred Boer
 
J

john sumner

Fred Boer said:
Well John, plonk away! Like Doug, I am a dedicated top-poster! The way I see
it, the poster to whom I am replying will most likely already have read all
the earlier information, and will only be interested in the new post.
Scrolling to the bottom to see what's new is a pain...

Of course, it's horses for courses... ;)

Cheers!
Fred Boer
Click to expand...
Frdd i can see it from your point of view, like when someone just writes two
line reply.
 
T

tina

well, i agree with Doug and Fred, so after all it is "too much of a problem
for me", john. thanks for offering me the exception. and never fear, i will
defend your right to bottom post, to the death. have a great day! :)
 
J

john sumner

tina said:
well, i agree with Doug and Fred, so after all it is "too much of a problem
for me", john. thanks for offering me the exception. and never fear, i will
defend your right to bottom post, to the death. have a great day! :)
Click to expand...
Ya now i know there are some people who just get anal about this, and i was
one of those those which i feel bad about.
 
A

aaron.kempf

so seriously.

do real people in the wild run datacentre edition?

i haven't heard of it except for webhosting and itanium

i just figured you were some punk kid that found it on kazaa
 
Top