Prefix + AutoNumber as Item Code

[GinaWhipp]

I did not get to look at this before I left obviously... sorry, it's been crazy. I will try to get to by end of week.

 

[johannaellamay]

I did not get to look at this before I left obviously... sorry, it's been crazy. I will try to get to by end of week.

No worries. I just really want the user to see the historical data of employees including the change of contract date. For better explanation, I wrote it in another post that no one replied to. HAHA.

 

[johannaellamay]

Wazzup?

 

[GinaWhipp]

I'm back! Geez, went away for a week and got swamped when I returned, looking now.

 

[johannaellamay]

Thank you! Hmm. In my frustration, I just deleted all "audit trail" objects. If I couldn't figure it out, might as well just get rid of it. Still, I really want to make it work. I just don't know how.

 

[GinaWhipp]

Wait, so what I just did does not exist anymore?

 

[johannaellamay]

It still exists but for the purpose of presenting a prototype to the end-user, I got rid of it first. I'm still keeping the t_AuditTrail but I don't how how I could make the end-user see the information.

 

[GinaWhipp]

Did you try the query I posted in the other post? Does that give you what you want?

 

[johannaellamay]

Yes. I will try it now. Will let you know how it turns out. Thank you!

 

[johannaellamay]

Gina, I now have a few troubles with the Macros. I'm still trying to get the t_AuditTrail to work because it's being really stubborn.

I'm really open to the possibility of just making the audit trail in VBA code. If I do, do you have a sample that I could take a look at? I would want to track historical data, the same purpose for my Data Macros for t_AuditTrail.

 

[GinaWhipp]

Here are two choices...
http://allenbrowne.com/appaudit.html
http://www.access-diva.com/vba10.html

 

[johannaellamay]

Here are two choices...
http://allenbrowne.com/appaudit.html
http://www.access-diva.com/vba10.html

I can never fully understand Allen Browne's although I know it's explained really well. I just really focus on this. Thank you. I'll try to contemplate on this and weigh my choices. Gosh, this is taking me forever.

 

[GinaWhipp]

Sometimes, lessons take a long time but once learned will never be forgotten!

 

[johannaellamay]

Hi, I have a problem with the code from Allen Browne. I copied the four functions according to instruction. But when I tried to Debug the code, Access highlights Call LogError and tells me

Sob or Function not defined

.

I'm a bit afraid to alter anything in the code because I might not be able to fix it back.

 

[GinaWhipp]

Well, sounds like LogError is not in a separate Module, like you put it in the Forms Module OR you changed the name from LogError to something else OR you did not copy that Function in to your database. So, you will need to tell me which one.

 

[johannaellamay]

Well, sounds like LogError is not in a separate Module, like you put it in the Forms Module OR you changed the name from LogError to something else OR you did not copy that Function in to your database. So, you will need to tell me which one.

It would be the last one. I didn't copy it. I have no idea where to look for it, or I'm just really stupid and code-illiterate.

 

[GinaWhipp]

Not stupid you just didn't see the it... please provide the link for the web page so I can look... I think there's a link to it but I don't remember which page you got the code from.

 

[johannaellamay]

Not stupid you just didn't see the it... please provide the link for the web page so I can look... I think there's a link to it but I don't remember which page you got the code from.

I got the instructions here:

http://allenbrowne.com/appaudit.html

And the code here:

http://allenbrowne.com/AppAuditCode.html

 

[johannaellamay]

What do, where should, and how do I write the code for LogError?

 

[GinaWhipp]

First let apologize... First the Holidays and then I got sick and all that in between my *day job*. So sorry, I didn't reply in a timely fashion... That said, do you still need this?