Search results for query: *

Richard, Other work prevented me from responding sooner. However, I get what you are saying and in fact it relates to my thought that I should directly link what I called the "SubCategory" table to the "MainContacts" table. Then have a link between that and the main category grouping. It's...

This is also a relevant link regarding our discussion: http://www.eggheadcafe.com/articles/20021019.asp Discussing the difference between Volume Number and internal Hard Drive Serial Number. - William ~^~ ~^~ ~ W . I . L . L . Y . U . M ~ wOrLd WiDe WhAt?

http://www.freevbcode.com/ShowCode.Asp?ID=3380 I trust the title spelling is no indication of the code accuracy ;-) I'd be interested in seeing this accomplished. However, how do you propose to protect the table from being written to? Let's suppose that someone stole the database and that...

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

WB786, that is an excellent idea, of course, when it is a possibility. Some of us are forced to use Windows 98. Maybe when Microsoft drops the price of XP Pro to something reasonable then my very small non-profit will be able to afford to implement that....... I'm thinking it'll happen...

Well 100MB is such a far cry from 98KB, I'd say the data is lost. If you can't open the database at all, you could change the file extension to TXT and see if there is even any recognizable data in there. Otherwise some even took place to severly corrupt the file (though I'd have no idea why it...

Oh, calm down... I think I have it! And me with no delete button. Obviously tblContacts being full of individuals is important to the expansion of the database, something I realized as I worked further. So how does Choice 4 look?! tblContacts atuContactID (Primary Key) txtFirstName...

Perhaps I've come up with an answer to my own question, writing it out helped a bit. What if I'm missing tblNumberThree -- Contact Types? Would this solution work: tblContacts atuContactID (Primary Key) tblContactNames ContactNameID (Primary Key) atuContactID ( 1 to many link to tblContacts)...

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

Thanks, a few more nests and that worked beautifully... However I wonder if it is possible to do that in a query somehow? Just curious. Thank you! - William ~^~ ~^~ ~ W . I . L . L . Y . U . M ~ wOrLd WiDe WhAt?

Hmmm, that seems like a tough task you have there. Is there any other way you can concieve of tackling your task, cause without some serious programming I don't know how this can be accomplished. - William ~^~ ~^~ ~ W . I . L . L . Y . U . M ~ wOrLd WiDe WhAt?

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

In the Relationships window, what fields are linked and does it confirm that it is a one-to-many link? (taking a stab) - William ~^~ ~^~ ~ W . I . L . L . Y . U . M ~ wOrLd WiDe WhAt?

Just to follow up. Because the DCount above referenced the table, it gave the relative Record Value in the *table* not the recordset of the filtered form. So I just created a query based on the Name that DCount could reference and removed the filter. Worked like a charm. Thanks, Everyone...

Perfect -- I really have no idea how it works... But, it does exactly what I wanted. Greatly appreciated. (Now off to figure out how it works). Thanks to everyone for their tips. - William ~^~ ~^~ ~ W . I . L . L . Y . U . M ~ wOrLd WiDe WhAt?

BNPMike, I envy you for having such reliable users. Unfortunately, mine are not, especially since not all three records can fit on screen at the same time (they are large). Adding that number would be useful. PHV, yes, for limiting the number of entries, that is definitely useful, any ideas...

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

Perfect! :-) Many Appreciations. - William ~^~ ~^~ ~ W . I . L . L . Y . U . M ~ wOrLd WiDe WhAt?

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) & "-" &...