Search results for query: *

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

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

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

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

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.

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?

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