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 SkipVought 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: *

  • Users: edgarchado
  • Order by date
  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.
  16. edgarchado

    Update Statement

    PH, That was what I was lookin for. Much Apreciated. I have one question though. It works great, but I put the: If IsNull(strEntregada) Then strEntregada = InputBox("Your prompt here", "Your title here", "Your default value here") End If part of the code within a message code, the value...
  17. edgarchado

    Update Statement

    Remou, I have another problem. I would need to do two different tasks. 1 - Get the value from tblheladera when me.lstpedido exists in this table and update it in tbltarjetas table, and 2 - Ask for the value to update in tbltarjetas when me.lstpedido is not in tblheladera. (maybe through a...
  18. edgarchado

    Update Statement

    Remou, Thanks. I will give it a look. Edgar
  19. edgarchado

    Update Statement

    Remou, It works like a charm. Thanks a lot. Here a Star for you. By the way, so you know a way to aling the text in a list box to the right, not necesarily using VB. Thanks
  20. edgarchado

    Update Statement

    Remou, I tried to do it in two steps, but with no luck. How would you do it? Thanks

Part and Inventory Search

Back
Top