Search results for query: *

Greetings! Here's what I'm wanting to do. Have tblContacts - ContactID (Primary Key) tblCategories - CatID (Primary Key) tblSubCategories - SubCatID (Primary Key) tblCategoryLink - ContactID - CatID - SubCatID tblCategoryLink serves as the M:M between tblContacts & tblCategories. The...

Greetings, I've spent two days looking for the exact code to do this, but I can't find a perfect fit and I haven't been able to modify the sort-of-fits for my purposes. Microsoft's User and Group Accounts 'wizard' is just terrible for the 'non-database,need something easier' user types, so I'm...

Greetings, I've hit a roadblock (and it is possible I will solve it by typing it out but otherwise I need help!!!!!). I am designing a database for membership and customer support. The conflict I have run into is some membership types are for TWO individuals who live in the same household...

Hi! Okay,okay, I need help so here is my situation. I have 2 tables. Entries (1) ------ (many) Judging Now each entry has 3 judging entries where they were ranked on a scale of 1 to 5... I can calculate the total score easy. Now, I want a control (text box, combo box, whatever) to update...

Greets! Okay, I feel really dumb for having to ask this question but not as dumb as I'd feel if I looked *another* 3 hours for the answer on the web and in these forums for what seems like a simple thing. I have a Continuous Form. What I want to do is display the relative value of the record...

Hi there. I am having trouble outputting mail merge formatting. This thread: thread68-235292 pretty much answered all of my questions and helped out great! The function: WorkPhoneP: "(" & Left([WorkPhone],3) & ") " & Mid([WorkPhone],4,3) & "-" &...

Hello! I've spent the last few days trying to figure this out without much luck. I have a report that needs to look like the Spreadsheet that was originally used. I have Case Managers and Client Names. CaseManager1 CaseManager2 CaseManager3 ClientA ClientD...

I'm looking for the necessary code to flag records based on birthdate of a client. Certain actions need to be taken when when they turn 5, 14, and 18. Never the same action. They should be flagged until the the phone call, letter, etc, has been done. Obviously I was thinking three different...

Greetings! I have figure that you guys know best how to answer the question rather then hear my theories. Here is what I want to do (but can't figure out and am not sure it is even possible). I am currently working in an office where we have lots of different letters we have to send...

Greets, Here is the problem: I have a shared network directory in Windows XP (all other computers on network use Windows XP). The problem first occured when I was using MDBTask to backup my database. The database was suddenly inaccessible via any of the networked computers, it would load...

Hold your horses, this is not a duplicate question. In the simplest form of the question, I need to have a query that draws from two tables remove duplicate listings of a certain field and continue to show the rest of the data. More detail: I have two tables, ParentFiles and StudentFiles...

Greetings! Simple question would appreciate any answer. I spent a few hours looking around and I cannot seem to locate the proper VBA code to have a button load up the Switchboard Manager. What is the VBA code for loading the Switchboard Manager? (More Info: I just simply want to...