Search results

I've tried adding "Error Handling in VBA" codes, but have a little trouble of knowing where to put those codes. And I've tried removing the 4 reference to function LogError(). But still showing the same error. The "missing reference" was suggested by MS VBA Help. But this was the code I was...

When I was trying to compile a module code, (from allen browne website) there's seems to be an error, Err_Handler: Call LogError(Err.Number, Err.Description, conMod & ".NetworkUserName", , False) Resume Exit_Handler End Function So when I compile the code, it says: Compile error: Sub...

Let me try it out first. Thanks for the suggestion!! Wait, any thing more simpler? I'm a newb in Access.

I'm having a problem with the audit trail I got from, http://www.access-programmers.co.uk/forums/showthread.php?t=44231&highlight=audit+trails , which works perfectly. But it seems, an audit trail is not enough. So I need something that will label/highlight/number an updated entry. Though...

Okay! I've tried it and it works! Thanks!!:D

So that would unabled people to edit the whole text??

Well, that settles then, thanks a lot for your help, bob!

I did the whole, Enabled = No, Locked = Yes, under Data. BUT, there's a whole grandmother story in the textbox, and there's no scrollbar to view the whole text. I've tried the scrollbar align thing and no scrollbar appeared. :) Help me please and thank you!

LOLS, thanks for the pictures to make it clear. But should I put the code in both OnChange in the text box and in OnCurrent in my main form??

Erm, it didn't seem to work out. :confused: And I'm still confused what type of form is it. So sorry.

If I'm not wrong, its Single form. I'm very new at this, and kind of clueless.

My audit trail is doing fine, but now my boss needed the "memo" to be highlighted or numbered so its easier to see whether the record was updated. (And the date wasn't enough:mad: ) So is there any possible way to have it highlighted/numbered after edited?? Help me, Thanks!

sure, thanks you guys.

Is there by any chance, using access, keeping the original data after being deleted or edited??