Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pampolk

    loop not working - drop down menu

    I can now close this thread. Thank you all for posting your comments. I appreciate how helpful this is! I was told that all I had to do was to move a variable initilaiztion to a different area in the program. So the initialization: topic_cat_id = pcRS("topic_cat_id") had to be...
  2. pampolk

    loop not working - drop down menu

    Yes I agree the top_cat_id is not changing for the record in question. Top_cat_id is determined by the below sql statment which is in the first posting: strSql = "SELECT mt_id, meeting_id, topic_cat_id, topic_id, notes FROM meeting_details WHERE meeting_id = 27 " The second sql...
  3. pampolk

    loop not working - drop down menu

    Here is the code that deals with getting the TopicCatagory. This hides the topic_cat_id and shows only the topic_catagory. The topic_cat_id from the main query(pertaining to the record) will populate this drop down. user can then select from the list to change the value if they want to. The...
  4. pampolk

    loop not working - drop down menu

    I have an asp program using a drop down menu. For the record in question(I am hardcoding for testing purposes) 2 detail records should be returned. This part is correct. However because of the way I used coding to populate the drop down menu field(TopicCatagory), I am getting the same value...
  5. pampolk

    asp-insert into multiple tables question

    Thank you for your help. I thought that was what I should do. I am using ASP with MS Access 2000. How would I work the syntax for the @@Identity? -- -- Below is my connection information: DIM bSubmit, theserver, errorID, errorText theServer =...
  6. pampolk

    asp-insert into multiple tables question

    I have an asp form that will insert form values into two tables. In the db this is a master/detail relationship(meetings - > meeting_details) and I am going to build the form in asp the same way. -- -- meetings(master table)-> meeting_id, meeting_date, quorum, visitors, notes...
  7. pampolk

    ASP/Frontpage 2000/IIS 5.0-How do I enable the Database Command on Ins

    I have installed windows 2000 professional (along with that came IIS 5.0 and frontpage 2000). All options were installed. I think the server is working fine as I can bring up the blue.asp page the sw wants me to bring up. I have also checked and frontpage server extensions are installed...
  8. pampolk

    grouping detail records for labels

    Hi Randy and Pierre Thank you for responding to my post! I am going to take your ideas this weekend and implement them. I did receive a reply on another way to do this via a temp table. It did work out great. If you would like to see the code I can attach to this thread or I can attach the...
  9. pampolk

    how to group detail records for mailing lables

    I have a query that returns the below results (I am using a small sample of data): levelid levelname bookid title 1 A 974 A zoo 1 A 500 Aaron and Steve 1 A 765 Amazing Animals 1 A 257 Avengers 1 A 430...
  10. pampolk

    grouping detail records for labels

    I have a query that returns the below results (I am using a small sample of data): levelid levelname bookid title 1 A 974 A zoo 1 A 500 Aaron and Steve 1 A 765 Amazing Animals 1 A 257 Avengers 1 A 430...

Part and Inventory Search

Back
Top