Search results

Great! I got my form work as i expected. Thanks June7. I'm okay if my text box won't show all the history. the remarks on each history are usually 5 to 10 words and i can fit it to to a longer text box and maybe a 1.5" tall text box just to show the last three history. User can always...

i found a code to parse the history but it was originally be displayed in list box. What I want instead is to display this in a textbox. I tested the code below and it displays the History individually in a msgbox. I just don't know how i can concatenate these results inside a textbox and...

June7 This works for me. Thank you. Is there a way that I can arrange the sequence from Latest to oldest? I mean the access columnhistory is displayed from oldest on top to the oldest below. How i can reverse this that what will show on my text box is from latest to oldest

The column is set to long text and the append only is set to yes. I know that my column history code works because it already gets the history of the field on my table. my only issue is, when I do Me.txtHistory = Application.ColumnHistory("tbl_RegistryJob Query", "JobTimeline", "ID=" &...

How can i display the access columnhistory in a text box in a continuous form? I tried to use this code : Private Sub Form_Load() Me.txtHistory = Application.ColumnHistory("tbl_RegistryJob Query", "JobTimeline", "ID=" & Nz(Me.txtID, 0)) End Sub but when my form loads, all the column...