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

    Searching for an elegant solution

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

    Resticting use to one PC

    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?
  3. WillYum

    Resticting use to one PC

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

    Searching for an elegant solution

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

    Allow Non-Admins to add Workgroup Users

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

    Add users Set Permissions

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

    Retrieve Back End Data!!!!!!!!!!

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

    Design Challenge with Customer Names

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

    Design Challenge with Customer Names

    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)...
  10. WillYum

    Design Challenge with Customer Names

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

    Need Accepted/Denied based on Number Ranking

    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?
  12. WillYum

    Export from Access to Excel

    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?
  13. WillYum

    Need Accepted/Denied based on Number Ranking

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

    Simple Many-to-One Problem

    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?
  15. WillYum

    Display Relative Record Value of Recordset

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

    Display Relative Record Value of Recordset

    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?
  17. WillYum

    Display Relative Record Value of Recordset

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

    Display Relative Record Value of Recordset

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

    Mail Merge Phone Number Formatting

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

    Mail Merge Phone Number Formatting

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

Part and Inventory Search

Back
Top