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

    Using subforms on tab controls

    The simplest thing to do is simply click the desired tab (otherwise, the subform will appear on all tabs-as ZOR pointed out). Then use the "Subform" wizard to add the desired subform to the appropriate tab. Use the wizard to determine the linked fields. If the subform is already in place, go...
  2. SammyTBlue

    Please any help appreciated!

    If I understand, as a result of deleting the bottom record from the subdatasheet, it is adding the 'first' record from a primary table into the subdatasheet? Is it truly adding the entire record, or is it only the date field that is filled...if so, could it be a default value on the date field...
  3. SammyTBlue

    Combo Search Box - Displaying message if record not found

    Bingo! That worked. I greatly appreciate it. Thanks
  4. SammyTBlue

    Combo Search Box - Displaying message if record not found

    I tried your solution (which was similar to one I tried earlier) without success. The focus simply moves to the assigned field (Provsvc) without displaying any message. Is there another approach perhaps?
  5. SammyTBlue

    Combo Search Box - Displaying message if record not found

    I have a combo box that is used to search for a particular vendor. I want to display a simple Message box if the record is not found. How would I do that? Below is the code that does the searching. It was created using the Combo Box Wizard. Dim rs As Object Set rs =...
  6. SammyTBlue

    AutoSelect the first entry in a combo box

    Oh, by the way. to answer your last question. The filter is simply being applied to the underlying SQL query in the Row Source of the combo box.
  7. SammyTBlue

    AutoSelect the first entry in a combo box

    Whoa, we have a winner. [Vendor].Value = [Vendor].ItemData(1) I had to change the zero value to 1. When zero, it pulled the column heading. Although, if I had column headings turned off, I wonder if it would have worked? No bother...thanks for the help. You're a life saver.
  8. SammyTBlue

    AutoSelect the first entry in a combo box

    O.K. I tried the second approach with limited success. Here's the total story. I have a filter on the drop-down list that causes the list to show only those vendors from the consumer's county. The county is on the main form. It appears (I could be wrong) as if your second approach is pulling...
  9. SammyTBlue

    AutoSelect the first entry in a combo box

    Sure, Save_Referral: DoCmd.RunCommand acCmdSaveRecord If [Reason] = "NP / LC = No Preference / Lowest Cost" Then GoTo Provider_byDate Else GoTo Provider_byCounty Provider_byDate: [Vendor].SetFocus After the last line is where I tried your code suggestion. It did not...
  10. SammyTBlue

    AutoSelect the first entry in a combo box

    This didn't work. I got the message: "Property let Procedure not defined and property get procedure did not return an object" ??
  11. SammyTBlue

    Sorting A Combo Box thru Code

    That sounds logical, but the RowSource knows which box to sort based upon the fact that it is attached to the desired combo box. How do I get the AfterUpdate event of the first combo box to know which combo box to sort? [Combo2] = ? Thanks
  12. SammyTBlue

    AutoSelect the first entry in a combo box

    Hi Everyone, I have two combo boxes on my form. When the user makes a selection, I want the focus to move to the second combo box. This is simple enough. However, is there a simple way to have Access automatically select the first entry in the second combo box, rather than having the users...

Part and Inventory Search

Back
Top