Search results for query: *

Well I have this "working": stLinkCriteria = "[Processor]= '" & Me![AssociateDrop] & "'" & " & [Active]= " & " '" & "0" & "'" (The [Active] is in refernece to a check box returning 0 for non active files, which is what I want) However though I have files with that Associate and [Active] with...

sorry.. please note that I did look (and searched online first) and found a similar question only it didn't have any replies. Just thought that I would mention that I am not trying to be utterly lazy.

All, I am a VB bumbler so this is very simple but I really need a little help. I just want to place a filter on a form with two criteria. I have it done with one: stLinkCriteria = "[Processor]= '" & Me![AssociateDrop] & "'" but now need two, something like: stLinkCriteria = "[Processor]=...

It WAS that simple! You guys have really been great! Thanks again! (I seem to love !'s more than I thought)

It actually does make sense and I have designed db's in the past that have certainly been more "normal". At this point though I really just want to get past this facet and move on. The question really comes in how to incorporate the nested if, that is the condition between LMStatus1 and...

I'm sorry for this but the one aspect not addressed was my question: 2) Just from an advice standpoint: I should be able to recreate this "plan" by just nesting IF's down (i.e. LMStatus3, LMStatus4 etc.) right? I'm just not positive how the test AFTER LMStatus2, going on to write to LMStatus3...

Victory is mine(well yours PHV)! I'm sure i'll be back in a few days as the process develops but thank you again.

PHV - that is outstanding it is working (almost) perfectly! Two things (I really hope last!): 1) I'm not sure if you saw my question concerning writing to the current record or not; now it is doing this but with one hiccup. On each record after the first it is writing the first "capture" to...

FYI: this is the code thus far. Private Sub Capture_Status_Change_Click() Dim dbCurr As DAO.Database Dim rs As DAO.Recordset Set dbCurr = CurrentDb() Set rs = dbCurr.OpenRecordset("WorkingTable") If Not rs.EOF Then ' Make sure that some records were returned...

I will gladly go in another direction if necessary as I am having obvious dificulties with the current approach, such as a "Write Conflict" message that I am getting in my, not even fully working approach!

Well there are just the two fields: Loss Mit Status and Approval Date on the Form, while there are mulitple columns on the table (the fields LMStatus1, LMStatus2; ApprovalDate1, ApprovalDate2) that I need to write to..? I'm not sure that I understand your last piece of advice, but thank you...

I dont't have a PrimaryKey defined. The form is simply bound to the table (workingtable). The fields in question are: Table: LMStatus1,LMStatus2; ApprovalDate1,ApprovalDate2 Form: Loss Mit Status, Approval Date So the idea is each click will capture each subsequent "status" change and date...

Oh sorry, also I inserted this: msgbox Me.CurrentRecord which does show me which record i am in (though it still writes to the first!), so maybe something with this "CurrentRecord" would be going in the right direction?

I am pretty much self taught and have pretty good success with most aspects but have not really gotten too in-depth with the SQL clauses. I assume that my goal makes sense to you (a table with columns for multiple instances for saves (the status changes every couple of days and i need to...

After just a tiny bit of tweaking I have this code working pretty much as expected but one point that Golom pointed out and I did not really realize, is that It is only writing and subsequently OVERwriting the table field "LMStatus2" of the first record within the form - even when i cycle to the...

Thank you very much Golom! I am going to go play around with this but am certain that it is just what I was looking for. (Especially thank you for taking the time to actually associate my needs with the provided code. All the stars that i can give!)

I may understand a bit more (emphasis on may). I have this now: Private Sub Capture_Status_Change_Click() Dim dbCurr As DAO.Database Dim tdfCurr As DAO.TableDef Set dbCurr = CurrentDb() Set tdfCurr = dbCurr.Table("WorkingTable") If WorkingTable![LMStatus1] Is Null Then...

The "Table![workingtable].[LMStatus1]" is referring to the (possibly)filled table field... So I need to somehow initiate the table before my IF test? I'm not sure that I know what you mean, or what to do at this point really.

Hello all. I am trying to write data from 2 form fields to a table based on whether this is the first time or subsequent time it has been written. Something like: Private Sub Capture_Status_Change_Click() If Table![workingtable].[LMStatus1] Is Null Then Let...

Alright now I am even more sorry! I did not catch that was what Remou was saying.. truly sorry Remou, PHV, and ZOR.