Search results

  1. J

    Exportwithformatting - getting filename from the value in a field in the report

    Sorry for the delay in responding, Gasman; a few things got in the way🎅 I have adapted my macro (see attachment) The result is that the Save dialogue box pops up. As the relevant record is also opened, it is easy enough to enter the Invoice Ref as the file name. Not perfect, but it will do...
  2. J

    Exportwithformatting - getting filename from the value in a field in the report

    I have a macro that brings up one selected page at a time and I want to save this as a pdf with a filename from a field "Invoice Ref" on the form. I have attached a screen shot. Ignore the SetVar bit - that was somenting I saw on one of the other posts, but it didn't work. This macro will...
  3. J

    Hi I'm Jim and I live in Cumberland in the UK.

    I do a lot of work as a volunteer with a local charity and as Access is a hobby of mine, I'm working on an application to automate3 as muchof their admin tasks as I can. I havee been dabbling for 20+ years and have (nearly always) managed without using VBA. I've nothing against VBA, just the...
Top Bottom