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 Chriss Miller 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. saunan

    Cascade Delete and Relationships

    OK. I think I've got the concept... Form 1 Allows user to search for and display Media Contacts by Organization. No editing allowed. Command Button will open Form 2 for editing related records. Form 2 Main form displays the SendAddress, the total number of Recipients for the address, and a...
  2. saunan

    Cascade Delete and Relationships

    Richard: Thanks for your help. I've come to the conclusion that cascade deletes are too dangerous... I designed a couple new forms, but still can't figure out how to delete only what needs deleting. I used a "record delete" command button, and a delete query with a macro that calls the query...
  3. saunan

    Cascade Delete and Relationships

    Richard: Thanks for the reply. I just realized that different Organizations sometimes share the same SendAddress (newspaper chains, for instance). So I can't always delete the SendAddress when I delete a Recipient. So ... the form that deletes records in tblRecipient DOES need to delete a...
  4. saunan

    Cascade Delete and Relationships

    I'm setting up a Media Contact database in Access 2002 (converted from Excel data) and cascade deletes aren't working on two of my tables. I've got Referential Integrity and Cascade Updates established between all Primary Keys. All my forms properly update the proper tables (so far). One of my...
  5. saunan

    Access 2000 to SQL server migration help

    What if I don't have Enterprise Manager? I'm using MSDE and the Access 2002 Upsizing Wizard isn't supported by the vendor an ASP application I use.
  6. saunan

    Group survey results by response

    Well, I can't use the Group By clause because Answer 47 is a Memo field. <%For i = 1 to 1000000 Response.Write &quot;Rip Out Hair&quot; & vbCRLF i = i + 1 Next%> Any suggestions out there?
  7. saunan

    Group survey results by response

    I need to create a report for a survey, grouping the results by the answer to Question 47. Something like this (there are 9 possible answers, so I need up to 9 different groupings): Answer to Q47: &quot;Group 1&quot; Question 1, Answer 1, # of Answers, % of Total Question 2, Answer 2, # of...

Part and Inventory Search

Back
Top