Search results for query: *

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

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

Spot on Ace! :) Dan

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", , ...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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