Pull data from access based on what user fills out in ASP form

Posted on 2001-06-08
Last Modified: 2013-12-24
I want to be able to have users fill out an asp form and then have after hitting submit, I want it to pull the data from my access table (based on what the user enters in the form). I've been able to create a form that lets users enter data and have it save to a table. I also know how to have it display all records, but I want to have it display based on what a user fills out on a form? Anyone know how to do this?  
Question by:jcollins1
  • 2

Accepted Solution

weesiong earned 50 total points
ID: 6170709

>but I want to have it display based on what a user fills out on a form

Maybe this is what you want:

'Your connection string

Set rs = Server.CreateObject("ADODB.Recordset")
userid = Request("userid")

SQLStr = "Select * from yourtable where userid ='"&userid&"'"
Rs.Open SQLStr, conn, 1, 3

Wee Siong

Expert Comment

ID: 6177175
Wee is on the right track...what you need to do is create a select statement based on the criteria you want to pull from the db.

Post a follow-up with specific examples from your page if you need more assistance.

Expert Comment

ID: 6204099
jcollins...are you still there?

Do you require more information or can you close this question?

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Intrasite icons that launch citrix 8 84
HTML Editor That Indents Code As Illustrated 11 138
Problem to get function 52 100
Problem to echo 6 83
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and Log…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now