hey Pat,
I adjusted the code, but when i run the code i actually get the prompt from the query to enter the parameter, so searchCriteria is not being picked up by the code. The comment you made regarding the Where DS = [EnterDS] , Do I need to put this in the Query design screen (criteria...
Not sure how to apply that. This is my first time using QueryDef to be honest, i used a template code and slightly adjusted...any feedback on how to define it is greatly appreciated.
hello friends,
I need your help to spot an issue that I've tried to figure out for at least 2 hours. Im trying to export a query to a csv file based on a criteria. The code works fine until it reached the parameter to filter the query, see code below:
Public Function...
I understand and agree with some of your points. However, the first comment "A properly-built database shouldn't really have that many fields" - this definitely doesn't apply to every project.
Also, in my industry experience, the audit trail of new/edit/deleted is used quiet a lot. So in my...
Hello friends,
I'm trying to come up with a simple solution to what I think it should be simple problem :unsure: :ROFLMAO:, but of course it cant be that simple...
So I have an audit table with the usual fields:
AuditID
TimeStamp
UserName
FormName
Action
RecordID
FieldName
OldValue
NewValue...
Hello forum friends,
I hope everyone is doing fine.
I'm trying to get pass over an error I'm encountering within my module. When function is called to record the entry in the tblAuditTrail, i get an error on
![FieldName] = ctl.ControlSource - Error 91 - Object Variable or With block...
Hey Pat,
Thank you! You were right, I had an unnecessary join, extra pages are gone. I will follow your suggestion as well on no. 2.
have a nice day!
Rick
that's going to be quiet difficult to be honest. I have a special online validation that requires knowing the user IP address to enter the program, wanna do a teams call? I don't mind showing it to you, if you want.
Rick