Recent content by Asspin

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