Recent content by EricTheRed

Yeah, but 20 is just the beginning. I imagine as the database grows there will be need to add more settings. It is entirely possible that I will hit the width limit eventually, which is 255 is it not? Though maybe its not really a problem and I'm making a mountain out of a molehill. Hmmm.

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

Unfortunately, I have to build the query myself. Both the number and position of the ANDs and ORs varies depending on user input. The query I'm trying to create is actually the SQL version of my own little simplified query-builder I've creater for my users. For anyone who's interested, I've...

Thanks. That seems to have worked. Now all I have to do is figure out how to build the queries dynamically. Bleh!

Unfortunately, I cannot simply ignore the behaviour. I have a feeling that my end-users will be rather annoyed to have their reports printed three times! As for the event repeating, I've put the function under the OnAction property of the menu item. I see no logical reason for the code to be...

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

Sorry for the somewhat laggard reply, but things have been ... hectic to say the least. I hate deadlines passionately. As for the IN operator, unless I'm understanding things incorrectly, doesn't it work much like a series of OR statements? Whereas I need both OR as well as AND. Taking my...

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

Jadar, A quick heads-up. I PMed you, and we can continue from there. (Sorry to have wasted a post simply for this, but I know I rarely check my PMs and have popups disabled, so better safe than sorry I suppose.) - Eric edit: An idiotic spelling error.

Great. Thanks again. (I'll finish this thing if it kills me!)

Ah well. Thanks anyhow. A quick related question: if I have a query that accepts two parameters, is there any way to specify them when I perform the query in my code? - Eric

Thanks for the link. Unfortunately, it deals only with creating a list for a report. I need to display this information on a form. Unless I've missed something in the article, I can't see a way to apply the technique to a form. So I'm back to square one, I suppose. Any other ideas? - Eric

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

Thank you for the help - the many-to-many example was especially useful. I think I have everything sorted out now, which is a Good Thing. For anyone who's interested, I used the basic many-to-many structure, with some extra controls tacked on to group my categories (as shown in my original...

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