Search results for query: *

Thanks. I'm working with the NotInList event and I guess I'm on the right track. My first problem is that I can't seem to "turn off" the generic Access 'Text isn't an item in the List' message. When I click 'Yes' in the dialog, the OpenArgs is passed to the second form and NewData gets...

I didn't think about LimitToList, thanks. Unfortunately though this combo box is bound to a hidden column (column width of 0")... bound to a Company ID but I am displaying only the Company Name, and that is what the users are typing and autoexpanding. Anyway, because the visible column is not...

I didn't think about LimitToList, thanks. Unfortunately though this combo box is bound to a hidden column (column width of 0")... bound to a Company ID but I am displaying only the Company Name, and that is what the users are typing and autoexpanding.

I have a combo box displaying a long list of possible values to select. The auto expand property is set to yes, so as you type, the selection matches, etc. My question, if the user continues to type and doesn't get a "match", winding up with a string not found in the list.... can that value be...

Whoops, stupid error. It is columns 0 and 1, not 1 and 2. Sorry to bother. Thanks.

I was working with that and I'll back and try again, but I was wondering if it was applicable seeing as I've set the column count to only 1 (only a single column).

I have a combo box with the following row source: SELECT Company.Name, Company.CompanyID FROM Company; The bound column is the Company.CompanyID (column 2). I use a column count of 1, so the combo box ends up displaying a pulldown of Company.Name. That's what I want. I'm trying to pass...

I've read a few posts on this topic and think I have it right, but obviously not. The form opens in add mode, but the field isn't populated. I'm hoping somebody can get me going in the right direction. I have a subform with a combo box field called 'CompanyID' and a button called...

PHV, yikes that's embarassing. Thanks very much. I re-used some code from a similar Form where I was filtering on a string.

I have a Form with various fields which is used to assemble a query and return results to a list box in another "Search Results" form. The user clicks/double-clicks on a result from that Form and a vb function executes to open up yet another Form using basically this code: strWhere =...

Per requirements, I've made a report with various sorts and subsorts. Available in the report is a hyperlink field which is different for each record/report row. The user would like to be able to click on a given hyperlink while viewing the report and to see the hyperlinked url in their browser...

Hi Darrylle, Thanks, good tip. Wrapping the query with DCount seems much cleaner than my IsNothing function (which probably wouldn't have worked anyway), but I still have the basic problem of DoCmd.OpenQuery(varSQL) not being the correct syntax where varSQL is a string variable, an sql select...

I have a database of magazine articles and I use a "Search" form for the user to build a custom sql select query, kind of a complicated one with lots of joins. The results get passed to a "Search Results" form. DoCmd.OpenForm "ArticleSearchResultsForm", , , , , , varSQL Before I pass the...

YES! I think it was the tab stop, but I put in the onCurrent code you suggested on the Main form too. We're cookin'. Works great! Thank you so much.

Ken, this is really outstanding. I can't thank you enough for taking the extra time. I suspected that was what was going on in datasheet view. And what a trick with the transparent text box! I'm happy to report it is working great! I have a quick followup... When adding a new subform record...

Eupher, thanks very much. Here is a screenshot of the relationships:

Thanks jebry, that works perfectly. Problem solved in under 5 minutes!

I'm trying to create a Search Results list which will be displayed in a listbox (Results) on a popup form (ArticleSearchResultsForm). The Search form (ArticleSearchForm) uses a function to build an SQL string that I'd like to pass as the rowsource for the listbox field. Here's what I have...

It is datasheet. I changed the two text fields to be combo boxes of course as described, but yes datasheet.

Eupher. Thanks for responding. The table that contains the category number and subcategory number information for each article is called CATEGORYINDEX which is related to ARTICLES by ArticleID. The names of the categories and subcategories are stored in tables called CATEGORIES and...