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!

  • Congratulations John Tel 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: *

  • Users: dusterb
  • Content: Threads
  • Order by date
  1. dusterb

    Combo Box AutoExpand

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

    Access Value from Unbound Column in Combo Box

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

    Open Form in acFormAdd with Pre-Populated Field

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

    DoCmd.OpenForm With a WhereCondition Filter

    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 =...
  5. dusterb

    Custom Toolbar Button to Open Hyperlink

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

    DoCmd.OpenQuery to Test Search Results

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

    Pass Rowsource from Module to Form Listbox

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

    Combo Box Requery in SubForm

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

Part and Inventory Search

Back
Top