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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dusterb

  1. dusterb

    Combo Box AutoExpand

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

    Combo Box AutoExpand

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

    Combo Box AutoExpand

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

    Access Value from Unbound Column in Combo Box

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

    Access Value from Unbound Column in Combo Box

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

    DoCmd.OpenForm With a WhereCondition Filter

    PHV, yikes that's embarassing. Thanks very much. I re-used some code from a similar Form where I was filtering on a string.
  10. 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 =...
  11. 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...
  12. dusterb

    DoCmd.OpenQuery to Test Search Results

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

    Combo Box Requery in SubForm

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

    Combo Box Requery in SubForm

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

Part and Inventory Search

Back
Top