Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Wayne, Nov 9, 2005.

  1. Wayne

    Wayne
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    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

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message
    news:e2j3f7P5FHA.884@TK2MSFTNGP14.phx.gbl...
    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
     
  4. Wayne

    Wayne
    Expand Collapse
    Guest

    Thanks Brendan, I appreciate the reply.

    Kind Regards,
    Wayne

    "Brendan Reynolds" <brenreyn@discussions.microsoft.com> wrote in message news:e1FN0ZR5FHA.3428@TK2MSFTNGP10.phx.gbl...
    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

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message
    news:e2j3f7P5FHA.884@TK2MSFTNGP14.phx.gbl...
    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
     
  5. john sumner

    john sumner
    Expand Collapse
    Guest

    "tina" <nospam@address.com> wrote in message
    news:5Micf.36732$qk4.34565@bgtnsc05-news.ops.worldnet.att.net...
    > 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.
    >

    Nor is top posting tina, be bottom post if that is not too much of a problem
    for you.
     
  6. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    "john sumner" <josumner1964@cs.ccom> wrote in message
    news:4371f1e0@usenet.zapto.org...
    >
    > "tina" <nospam@address.com> wrote in message
    > news:5Micf.36732$qk4.34565@bgtnsc05-news.ops.worldnet.att.net...
    > > 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.
    > >

    > Nor is top posting tina, be bottom post if that is not too much of a

    problem
    > for you.


    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.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)
     
  7. john sumner

    john sumner
    Expand Collapse
    Guest

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >
    > 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.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >


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

    Fred Boer
    Expand Collapse
    Guest

    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



    "john sumner" <josumner1964@cs.ccom> wrote in message
    news:437209aa@usenet.zapto.org...
    >
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >>
    >> 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.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>

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

    john sumner
    Expand Collapse
    Guest

    "Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message
    news:uYT0ExT5FHA.1416@TK2MSFTNGP09.phx.gbl...
    > 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
    >

    Frdd i can see it from your point of view, like when someone just writes two
    line reply.
     
  10. tina

    tina
    Expand Collapse
    Guest

    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! :)


    "john sumner" <josumner1964@cs.ccom> wrote in message
    news:4371f1e0@usenet.zapto.org...
    >
    > "tina" <nospam@address.com> wrote in message
    > news:5Micf.36732$qk4.34565@bgtnsc05-news.ops.worldnet.att.net...
    > > 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.
    > >

    > Nor is top posting tina, be bottom post if that is not too much of a

    problem
    > for you.
    >
    >
     
  11. john sumner

    john sumner
    Expand Collapse
    Guest

    "tina" <nospam@address.com> wrote in message
    news:RSpcf.67401$zb5.54730@bgtnsc04-news.ops.worldnet.att.net...
    > 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! :)
    >

    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.
     
  12. Ron Hinds

    Ron Hinds
    Expand Collapse
    Guest

    Brendan is correct - the answer is in the ASP pages (it will require at least two). And, it's not nearly as complicated as you think, Wayne. Here is an excellent place for you to look for examples:

    http://www.asp101.com

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message news:u1esE%23R5FHA.3388@TK2MSFTNGP11.phx.gbl...
    Thanks Brendan, I appreciate the reply.

    Kind Regards,
    Wayne

    "Brendan Reynolds" <brenreyn@discussions.microsoft.com> wrote in message news:e1FN0ZR5FHA.3428@TK2MSFTNGP10.phx.gbl...
    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

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message
    news:e2j3f7P5FHA.884@TK2MSFTNGP14.phx.gbl...
    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
     
  13. Wayne

    Wayne
    Expand Collapse
    Guest

    Thank you very much for taking the time to reply Ron, I'm going to spend a couple of hours reading through that site you posted and see if I can pick up some hints and tips.

    I really appreciate your input.

    Thanks again
    Wayne

    "Ron Hinds" <__ron__dontspamme@wedontlikespam_garageiq.com> wrote in message news:#63MJvY5FHA.1536@TK2MSFTNGP12.phx.gbl...
    Brendan is correct - the answer is in the ASP pages (it will require at least two). And, it's not nearly as complicated as you think, Wayne. Here is an excellent place for you to look for examples:

    http://www.asp101.com

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message news:u1esE%23R5FHA.3388@TK2MSFTNGP11.phx.gbl...
    Thanks Brendan, I appreciate the reply.

    Kind Regards,
    Wayne

    "Brendan Reynolds" <brenreyn@discussions.microsoft.com> wrote in message news:e1FN0ZR5FHA.3428@TK2MSFTNGP10.phx.gbl...
    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

    "Wayne" <waynesmith1971(NoSpam)@hotmail.com> wrote in message
    news:e2j3f7P5FHA.884@TK2MSFTNGP14.phx.gbl...
    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
     

Share This Page