Search results

Here is the code I am trying to run: Forms!frmHistory![textarea].Value = [textarea] & vbNewLine & "Task Assigned on " & Now() & " by " & Environ("UserName")

I have a memo field on a form. I want to write certain events to that field, either on that form or into the underlying table. I want new event text added to that, preserving the data that may or may not be there. example: Issue opened on 5/5/2009 Isue assigned on 5/9/2009 Issue worked on...

I apoligize- the original code does work correctly as posted. Thank you for your help, again. I copied the block of code from the last set of filters [several filters available for this form] for a starting place- and forgot to change the frame number. Stupid mistake. Also stupid not to have...

I am storing the 2 filter combos and the 3 filter combos to work with after this :) This new code won't run, tho.... Dave

This won't run: DoCmd.ApplyFilter , "[casestatus]<>'Closed' AND [TickleDate]<>null and [Assignedto]= '" & Environ("UserName") & "'" Help. please? Thanks, Dave

Perfect- thanks, Bob :)

This code won't run: DoCmd.ApplyFilter , "[CaseStatus]<>'Closed' AND [TickleDate]<>null" I want all CaseStatus that are NOT closed and all tickle dates that are NOT null Help, PLease? Thanks, Dave

Haven't a clue why that worked- but it did. Thank You! Off to the next problem :)

No i haven't- just add the same code to on current?

Sure have- my little brown buddies that check my code without telling anyone :) I have been working on this since last Thursday and am pretty frustrated with myself. The tracking number that the code asks for is correct- when i look at the first line of code the TrackingNumber matches for both...

The db won't run unless coneected to our data warehouse and contains confidential info. Thanks for trying :) Dave

Exactly what I am trying to do. If DLookup("Changed", "TblClaimAllowance", "TrackingNumber = " & Forms!frmlocalrecords!TrackingNumber) = -1 Then cmdClaimAllowance.ForeColor = vbRed Else cmdClaimAllowance.ForeColor = vbBlack End If does not change the button font back to black. If the button...

so trying to use your sample code I now have: If DLookup("Changed", "TblClaimAllowance", "TrackingNumber = forms!localrecords!TrackingNumber") =-1 Then MsgBox "code is OK" Else: MsgBox "Code not running" It returns code not running because I don't have all the pieces in place yet- I need to...

The problem I am trying to solve is getting the second form to go to the matching record when it opens. After it is open for a few seconds it then loads the correct record. There is another process that runs that depends on the two records matching. The pause between opening and matching is...

I just need the record [trackingnumber] on the second form to open to the matching record on the first form. Right now it just displays the first record [lowest tracking number] of the second form.

The code below will not open the correct record- that is, the record that matches the tracking number. It runs agains the very tracking number instead. If I put this code on a button and run it after the record loads it works correctly. Help with the code, and a little VBA lesson, please...

This changes the color, but will not stay when you close and reopen. cmdClaimAllowance.ForeColor = RGB(255, 125, 0)

Actually I was looking for something like: cmdClaimAllowance.ForeColor = #ED1C24 That doesn't work, YET...

I have a form with about a dozen command buttons that open forms. My customers are asking if I can make the command buttons a different color if there is any data in the form the command button opens. They would like the color to remain changed forever once data is entered. Any suggestions...

Kryst51, thanks for the suggestion:) Tried your code Bob [Thanks as always for your help] and it still doesn't limit the records to that range- still does nothing. I have other filters on this form and they work the way I wanted- just this date range is a problem?