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 Chriss Miller 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. Asspin

    Comparing times in excel

    Ok, so now I had a problem with times greater than 9:59 due to the 0 being added to the front it was causing the time to end up like 010:00 etc. Here is the solution I came up with, in case it helps anyone else. If StringCheck(Range("Z19").Text) > StringCheck(Range("Z25").Text) Then...
  2. Asspin

    Open form with DoCmd?

    Hmm ok, maybe I set this form up wrong... This seems to work for the main form, but I have subforms and the data isn't recording right, it is just saving to the first record in the database. Any ideas? Dan
  3. Asspin

    Open form with DoCmd?

    Spot on Ace! :) Dan
  4. Asspin

    Open form with DoCmd?

    Ok so I am trying to open a form with another form and have it pull the record that corresponds to the date selected on the first form. I am trying to use the following, but it is just opening a blank/new record on the form. Private Sub cmdOpen_Click() DoCmd.OpenForm "fData", , ...
  5. Asspin

    Displaying data from form on report

    Well sheesh, I was right, nevermind! :) Off to get caffeine! =[Forms]![fReporting]![comLocation].[Column](1) Dan
  6. Asspin

    Displaying data from form on report

    So I have a combobox on a form with 2 columns in it. The report needs to get the data that is currently selected and in column 2 of that box. This is what I am using for my control source for the text box in my report, but it doesn't work. I imagine I just have this formatted wrong...
  7. Asspin

    On Exit Event Requery?

    Awesome answer as always, works perfect! I can't believe I missed that! Dan
  8. Asspin

    On Exit Event Requery?

    Is there a way to do a save and suppress the error message perhaps? Dan
  9. Asspin

    On Exit Event Requery?

    That works the same as what I had, still have to save it, and it gives me a "write conflict error" saying another user has made a change to the data. (I assume this is caused by the SQL. Dan
  10. Asspin

    On Exit Event Requery?

    I wasn't entirely sure where to put this post, but here goes anyway. I have 2 text boxes on this form, on top of each other. What I am doing, is displaying one text box which has a time in it, but when it gets focus, it moves the focus to the other box which has the time in seconds. The time...
  11. Asspin

    Move items in listbox with autonumber?

    Ok, so I figured it out, apparently I can't change the autonumber field, so I ended up just moving the program names around the box and updating it in the table. Works pretty slick. Private Sub imgDown_Click() Dim iTop As Integer, iBottom As Integer, sTopName As String, sBottomName As String...
  12. Asspin

    Move items in listbox with autonumber?

    Ok, well I am not sure this is the best way to get this done, but here goes. I have a database which lets users select items from a list on the left which will be added to the list on the right. When the forms opens it loads their preferences from the table based on their windows login name...
  13. Asspin

    Problem with duplicate items in list box and deleting from table

    Because I didn't think about it! ;) Good catch! Dan
  14. Asspin

    Problem with duplicate items in list box and deleting from table

    Ok, so I have a table with the following columns: UserName, ProgramName, OrderInList What I am trying to do is setup some code to update the "OrderInList" field, everytime a row is deleted. Here is how I am adding the data to the table... DoCmd.SetWarnings False DoCmd.RunSQL "INSERT...
  15. Asspin

    Simple DELETE doesn't work?

    Sorry, I had jsut renamed that variable! ;) That was the fix though. Thanks as always PHV! Dan
  16. Asspin

    Simple DELETE doesn't work?

    What the heck am I doing wrong here? strAlias is a global variable set on load. I am getting "Run-time error '3464': Data type mismatch in criteria expression." DoCmd.RunSQL "DELETE * FROM tData WHERE sName = '" & strUserName & "' AND iRow = '" & lstStart.ListIndex + 1 & "';" Dan
  17. Asspin

    IF THEN ELSE in query?

    Hmm, that looks like it might be a simpler option dhookom. I will give that a shot, I should be able to generate it off one query then filter from there. Perfect! Dan
  18. Asspin

    IF THEN ELSE in query?

    The field is actually a normal text field. I can try changing it to something else if that helps. I think the database started off having names stored in that field, instead of location numbers. Dan
  19. Asspin

    IF THEN ELSE in query?

    I have tried it written as you have it lameid, I get no results on the query. Annoying isn't it? :( Dan
  20. Asspin

    IF THEN ELSE in query?

    Yeah the double quote was a typeo by me. The SQL seems to work. That's how I put it into the query editor, it's much cleaner than what I was trying to do. I am still trying to get it. Here is what it is currently... Like before, everything is working, except for the 'TRUE' statement...

Part and Inventory Search

Back
Top