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!

Search results for query: *

  1. BitTwiddler

    how do I get a combobox to scroll to a specific item in VB code?

    Thanks again Rick. I guess I should have known that already. It worked like a charm. Now the users can click little buttons with the letters of the alphabet on them and zoom to the first list item starting with that letter. The list usually has around 2200 items and this trick will speed-up...
  2. BitTwiddler

    how do I get a combobox to scroll to a specific item in VB code?

    Thanks Rick, I'll give it a try and repost the results.
  3. BitTwiddler

    how do I get a combobox to scroll to a specific item in VB code?

    I have a combobox with several columns and lots of records. I want to be able to cause the combobox to scroll down to a specified record in VBA code. I have looked throught postings and some come close to being like what I want but none directly address this trick. Can anybody help me? Please...
  4. BitTwiddler

    Looking for a way to open a report within a form like an OLE object

    I have a form that is opened as modal and a button on that form that opens a report. The problem is that report shows up behind the form. How can I get around that? I don't want the users to have to close the form or to change the form so that it is not Modal. Any suggestions will be greatly...
  5. BitTwiddler

    Compute Average (Aggregate Function) with Null Value in Query (Part II

    Here is one possible way. In a blank column in the query grid put: Intermediate1: iif(isnull([MonthA]),0,[MonthA]) + iif(isnull([MonthB]),0,[MonthB]) + iif(isnull([MonthC]),0,[MonthC]) + iif(isnull([MonthD]),0,[MonthD]) + iif(isnull([MonthE]),0,[MonthE]) in another blank column put...
  6. BitTwiddler

    Lookup Tables

    Select the comboBox on the form, open the properties dialog (View, Properties), click the Data tab, delete the field name value from Control Source property (first property on the Data tab). At that point it is no longer bound to any field yet it will still do the lookup and put the value in the...
  7. BitTwiddler

    Lookup Tables

    It sounds like you have the comboBox bound to a field in the same table that is the rowsource. When a comboBox control is bound to a field and you click one of the items in the list it will update that field in the current row of the form. If you just want to lookup a name but not have it update...
  8. BitTwiddler

    Access 2K forms GUI problem and free memory

    Does anybody know why an Access 2K form would display field contents in bold and the background of button captions as white. It alternates between a normal looking form and that while navigating from record to record. And then when I leave the form I get the error "There isn't enough free...

Part and Inventory Search

Back
Top