Search results

I was indeed not clear on my post, I am sorry for that!:o When an operator is transcripting a card into the database (Yes, it´s 2019 and we are still transcripting instead of offering an online form for that matter), he will will have to assign the card to a person (Observer) but if the person...

Hi Frothingslosh! I would like to see that! Can you post/point them?:D Thanks!

Hi mba_110! :) I have the same feeling about it and I have managed to change the combobox to textbox after changing a few things. Please refer to my solution below: First you need to create the txtUser and then you have to build the AfterUpdate event to handle all the code. Create the query...

I guess I will go with that solution, in fact it was my first thought but I wasn´t sure if that would create problems. Turns the other option is troublesome and that saying is always coming back to strike me: the simpler the better! I appreciate your comments, certainly I have not made a very...

Hello again! I have a pretty simple question (For you, of course, too complex for me): Considering you have to record information (Like a complaint) coming from people that wants to be anonymous what would be the best approach when comes to database design? First I considered creating a...

Seems I have got the code to work straight now! I left the Call on the Before Update event of the form: Private Sub Form_BeforeUpdate(Cancel As Integer) Call AuditChanges("CardID", "EDIT", Me) End Sub And I have also changed the code from the cmdSave: Private Sub cmdSave_Click()...

Hey Guys! I have tried to apply this Audit Trail to form that has the go to Prev/Next records and I noticed a couple of odd things: 1. If I put the calling code on BeforeUpdate Event of the form it is being called twice, the first one when I save it and the second one when I click on the...

:D:D Thanks, Colin!:D:D

Hey, jdraw! I removed the debugging and the code is working. After reviewing the code and trying it out on my own DB I noticed that 3 controls names were not being collected, after revising your code I realized that the isse was that you use this: ctl.ControlSource I changed to collect the...

Ok, I will work on it and get back to you. Sent from my iPhone using Tapatalk

But if I remove those specific pieces of code will I break the runtime? Sent from my iPhone using Tapatalk

Thanks, jdraw. I will take a look at the Data Macros. Personally, I have seen a lot of people saying we should avoid macros like the plague, but I have not studied them enough to understand the reason for such infamous. Sent from my iPhone using Tapatalk

jdraw, I have just tested the code on my project and it is working! I appreciate a lot the efforts you put on to make this fix possible.:) I just would like to check with you if I can remove the debbuging infomation from the code. Such as::confused: Public gRecID As Integer Public show As...

Thanks a lot jdraw! :) I think it is odd that he is maintaining the code there after so many people using it and many has contacted him to ask for the correction. Does anybody here know why Martin Green has not updated his article about the Audit Trail?:confused: EDIT: I decided to email...

Re: audit trail- handles forms and subforms :( I have just downloaded the file and the ModAudit is returning a compile error if you debbug: "User-defined type not definined", highlighting on Sub AuditChanges(IDField As String, UserAction As String, pMyForm As Form) Dim cnn As...

If I use the "DoCmd.RunCommand acCmdSaveRecord" then I will be putting my user on a , let´s say, error safe mode? At least regarding the 2046. :confused:

Hey folks! I have been working on the Save_Click event of my form and I have raised error 2046 sometimes, saying the SaveRecord wasn´t available. I have used RuralGuy´s advice to work this around: If Me.Dirty Then Docmd.Save acForm End If But then I found a similar command...

L&G, I have been thinking about the use of Queries saved on my database vs building them via SQL on the runtime. Because of this I am thinking about these: :confused: Is it faster to have thee SQL built on the runtime or it would be slower? Does having a lot of saved queries will bloat the...

Indeed when I first saw Arnelgp´s answer I noticed it was working and it was not necessary to convert that number to a string. The field I was searching was indexed though. BUT I decided to change the approach to this thanks to Colin´s advise to change that textbox to a combobox plus all the...

Hey Colin, I have just finish the revamp and recoding of the form, however I have not used the Form/Subform approach you suggested. The solution I used was Allen Browne´s "Using a Combo Box to Find Records" plus a couple of the tweaks you provided and some from my side. I also included the...