?
Solved

Creating Web Application to accompany Access Contact Database

Posted on 2005-03-23
2
Medium Priority
?
161 Views
Last Modified: 2012-05-05
I created a relational Access Database as described in this previous thread:

http://www.experts-exchange.com/Databases/MS_Access/Q_21360503.html#13614326

I am now developing the Web Interface to accompany this in dreamweaver MX 2004.   I am using standard ASP, and am presenting the first of my questions.  

I need to find a way to create the master contact record first in my database, then be taken to a page to directly edit it.  My dilemma here is that at this point I don't know the primary key ID for this entry, and therefore can't do it my usual way with passing the ID.  Any ideas for this?  Or if anyone knows a better way to handle this that would be great.  I also do not wish to just pull the last record created in the database as multiple users can and will be using this at the same time.

Thanks

-JQ

P.S.  In the link above to the previous thread, there is a kink to a recent screenshot of my database at the bottom of the thread.
0
Comment
Question by:JQuartermaine
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
alexhogan earned 1500 total points
ID: 13630369
Are you trying to get intContactID after the record has been created?

if so you could simply use the contacts first and last name as the query parameters.


  "SELECT intContactID " _
&"FROM ContactTable " _ ' -- I forgeot the table name
&"WHERE txtFirstName = '" & varFirstName '" _
&"AND txtLastName = '" & varLastName '"

This will return the id of that recordset.  You will need to be careful because it is extremely possible, especially on large database, that you'll have more than one person with the same first and last names.  You might want to add the middle initial in the query to help confine the search.

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month9 days, 6 hours left to enroll

764 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