Search results

  1. RickHunter84

    Item not found in collection - Error 3265

    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...
  2. RickHunter84

    Item not found in collection - Error 3265

    Same error. Access doesnt find it in the collection. do you think i am missing a reference?
  3. RickHunter84

    Item not found in collection - Error 3265

    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.
  4. RickHunter84

    Item not found in collection - Error 3265

    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...
  5. RickHunter84

    Audit Trail field name value - Rename to something for user friendly

    As I said in the initial thread it was a pure aesthetic issue, I called it a "problem". Thank you for your response (y) Rick
  6. RickHunter84

    Audit Trail field name value - Rename to something for user friendly

    Thank you so much for your examples! great insight on how to handle this situation. have a good weekend! Rick
  7. RickHunter84

    Audit Trail field name value - Rename to something for user friendly

    Man! you nail it!!! there was not need to do more coding but just replace one line in the code...the simplest solution! Have a nice day! Rick
  8. RickHunter84

    Audit Trail field name value - Rename to something for user friendly

    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...
  9. RickHunter84

    Audit Trail field name value - Rename to something for user friendly

    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...
  10. RickHunter84

    Getting Error 91 on Audit trail

    Thank you for that Doc :) - sometimes we need to step back and rethink. Have a nice day! Rick
  11. RickHunter84

    Getting Error 91 on Audit trail

    The code works when is an update event but gives the error when is a new entry, what would you set ctl value to? set ctl = ? Rick
  12. RickHunter84

    Getting Error 91 on Audit trail

    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...
  13. RickHunter84

    Report printing extra pages

    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
  14. RickHunter84

    Report printing extra pages

    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
  15. RickHunter84

    Report printing extra pages

    Hello Gasman, Yes, the underlying query doesn't have duplicates, if thats what you meant? Rick
  16. RickHunter84

    Report printing extra pages

    Dear forum friends, I need your help with the following. I'm working in Offer report that prints on PDF, this works without a problem. The problem is that if the offer has 3 items in it, the offer prints with 3 pages (see attached). I have other reports in the program I'm building that print...
  17. RickHunter84

    Solved PDF Report output Issue - Access 2016

    Hello, i realized what it was. the C Hello DBguy, I realized what it was. Apparently, I cant write the file temporally in the C:\ drive - I switched the path to my C:\Documents\ - and it worked. thank you :) Rick
  18. RickHunter84

    Solved PDF Report output Issue - Access 2016

    Hello there, I'm trying to print a report into a PDF file to later attached it to an email, but I continue getting the error : Runtime error 2501 on this line : DoCmd.OutputTo acOutputReport, PurchaseOrderReport, acFormatPDF, filepath I'm not sure what is causing this error as the...
  19. RickHunter84

    Execute a query in Local machine into an online MySQL DB

    Thank you! do you know of any examples? any place I could look? Thanks again! Rick
  20. RickHunter84

    Execute a query in Local machine into an online MySQL DB

    Dear friends, I hope everyone is well. Thinking out loud here. I was wondering if its possible to execute a local command with VBA to query an external MySQL DB in the internet, for example: MySQL is hosting user names, and this command will go into the MySQL database and check if the user...
Top Bottom