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 Shaun E 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 edgarchado

  1. edgarchado

    Strange thing occurs when opening DB

    I tried to make a new DB in the PC where I have this problem. I can not create a new DB. I have the new dB menu grayed out. Is this possible???
  2. edgarchado

    Strange thing occurs when opening DB

    Hi All, The strangest thing is occuring when I try to open my DB. I have the DB protected by password, each user with its own password. The DB opens directly to a main form, with all the options for the DB. When I open it from a certain PC, It asks me for the user ID ans Password. I enter...
  3. edgarchado

    Select Higher ID

    I will give it a try. thanks
  4. edgarchado

    Select Higher ID

    caoamo, it is working as I need it to... The problem I have now is that if I have several records with the same date it selects the first one (the oldest) and not the last one of the day (the newest) Any ideas how to solve this??? Thanks
  5. edgarchado

    List Box - limit to list

    thank you Remou and PHV... It is working great...
  6. edgarchado

    List Box - limit to list

    Productora and Pelicula are 2 comboboxes which will help filter the Director_de_Fotografia textbox. I have changed the code but I get a Type Mismatch error. thanks.
  7. edgarchado

    List Box - limit to list

    this code is in an afterupdate event of a combobox. form this first combobox i select one of the items, which will populate a second combobox. I dont want this second one to be a combobox, but a textbox instead. I get to populate the second combobox with the previous code. I would like to...
  8. edgarchado

    List Box - limit to list

    this is my code for a combobox. how should I change it to use code or dlookup to populate a textbox? Private Sub Pelicula_AfterUpdate() Dim loDate As Date 'Get the company's last order date loDate = DMax("[Fecha_Pedido]", "tblPedido", "[Nombre_de_la_Película] = '" & Me.Pelicula.Value & "'")...
  9. edgarchado

    List Box - limit to list

    Another option that I am looking at is to populate the text box using a query. is this possible? Thanks
  10. edgarchado

    List Box - limit to list

    Sorry if I got you confused. I have a combobox which populates a listbox. I have no problem with that. What I would need is for the user to add a different value if the one in the listbox is not the one they were looking for. Thanks
  11. edgarchado

    List Box - limit to list

    I would prefer the users, to type directly on the text box. Or is there a way to populate a text box via Visual Basic? I mean by first selecting a value from a combobox and the textbox will automatically update itself? Thanks.
  12. edgarchado

    Select Higher ID

    hneal98, I do have an order date. How would I find the highest date? Thanks.
  13. edgarchado

    List Box - limit to list

    Hi all, When a field is a combobox you can decide if the values will be limited to the list or not. In a list, they are always limited to the list. Is there a way for the users to enter any data, and not only that of the list? Thanks. Edgar
  14. edgarchado

    Select Higher ID

    Hi all, I have a an order form. Each order has it's own ID. On of the fileds in the form is company. When I select a company from a list, it automatically fills other list fileds with data from older orders from that particular company. If that company had only one previous order it only...
  15. edgarchado

    Update Statement

    Ph, Thanks For the Quick response. It is working great. Here is a star for you. Thanks, Edgar.

Part and Inventory Search

Back
Top