Search results

(Seriously, I have no idea what I'd do without this forum. Thanks to all who continue to reply to everyone's queries!) I suppose this is a general design question. I have a number of settings and parameters - editable by the end-users - throughout my database. Things like SMTP information...

After much fruitless searching, I've broken down and decided to start a topic. This issue has been mentioned before on these forums, but never answered, so here goes: I have a shortcut menu, "smnuContact", which appears when a user right-clicks on a series of search results. I have the items in...

Okay, so I have a table structured somewhat like this: [ID] [Category] 1 | 7 1 | 2 1 | 3 2 | 7 2 | 9 3 | 6 3 | 7 3 | 2 I'd like to be able to find all the IDs where Category = [some variable criteria statement]. For example, a query to find all the IDs having a...

[I wasn't quite sure where this belonged in the forums, so I tossed it into General. Sorry if it seems a bit out of place!] I have a query that takes two parameters, both specifying IDs to limit the search. The recordset returned by the query has only one text field: strCategoryName. I would...

Hey. I'm looking for the most efficient way to store the following data. Whatever the solution is, speed is the primary concern as the records will be accessed very frequently. Alright, each contact in my database belongs to zero or more categories, where the catergories are sorted into four...

Sorry the title is so ambiguous, but I really couldn't explain this clearly in several words. That being said, here's the more long-winded version :rolleyes: : I am unsure how to "properly" structure this relationship: Each person in my database has four* "extra data" fields associated with...

Another question / yes indeed / some brilliant answers / that's what I need. Sorry, but it's been a long day. You can't blame an aspiring poet! Anyhow, I'm having trouble counting records. Here's the situation: For every person in my database, there is either zero, one, or two sets of...

A quick dilemma to resolve in my continuing quest to produce a functional database: I have a main form, on which is a single subform. Based on certain settings chosen on the main form, the source object of the subform changes. This is all fine and good - under admin access. However, if I log on...

In my continuing quest to create a functioning contact management database, I have come across this problem: I have a main "contact" form, on which is displayed a "specific contact info" subform. When a user clicks a button on the main form, I would like to call a sub on the subform...

Hello all! Thanks for taking the time to read this post, and for any help you may be able to offer. A bit of background to begin: I'm a student working on a volunteer basis for a community organization. This organization deals with hundreds (if not thousands!) of contacts, however the...