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...
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...
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...
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...
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...
I have a basic publisher's Content Management database which contains among other things articles and their respective subject categories and subcategories. The categories and subcategories are displayed in a subform. Each article can have multiple category/subcategory assignment and these are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.