Recent content by electrix

  1. E

    Auto resize tables in Access

    Okay. I've created buttons to open the forms I just made. When I access them from the list of forms they open into datasheet view. However, when I click the buttons, they open into form view. How can I set it so that clicking the buttons will open the forms up into datasheet view?
  2. E

    Auto resize tables in Access

    Hi. I have a main form that has three command buttons, each of which opens a table. Is there a way to set the default size of the window that opens when I click on one of these buttons? In other words, is there a way that I can do this and still efficiently utilize my window space in order to...
  3. E

    Sorting a listbox in a form

    By the way, my code looks like this now: Option Compare Database Option Explicit '* Define the RowSource for the listbox, along with different sorted variations Const mcRowSourceBasis = "SELECT DISTINCTROW User_First_Name, User_Last_Name, Phone_No FROM [Main]" Const mcRowSourceUnsorted =...
  4. E

    Sorting a listbox in a form

    Okay, thank you. Now, each of the four buttons reorders the listbox by the appropriate field (one button for first name, one for last name, one for phone number and one for product id). However, the User_First_Name field and the Product_ID field still completely disappear from the listbox when...
  5. E

    Sorting a listbox in a form

    And where does the following code go? QuickList.RowSource = TheConstantValue Me.QuickList.Requery
  6. E

    Sorting a listbox in a form

    What are you referring to by "TheConstantValue" ?
  7. E

    Sorting a listbox in a form

    Ah, okay. Well, it certainly did reorder the FORM! :) Perhaps you could shed some light on how to go about reordering the listbox?
  8. E

    Sorting a listbox in a form

    I tried this, and it did not reorder the listbox; it only populated the text boxes in the other part of the form with the first entry (based on whatever the button was sorting by) in the table that the form pulls from. However, the listbox pulls from a query; do I have to use something else in...
  9. E

    Sorting a listbox in a form

    Hi. I have a listbox with four fields in a form: User_First_Name, User_Last_Name, Phone_No, and Product_ID. I am trying to create command buttons for each field that, when clicked, will reorder the listbox by that field. So, I made four buttons in the form and tried to configure them...
See more
Back
Top Bottom