Last Activity:
Jan 11, 2019
Mar 8, 2005
Likes Received:
Trophy Points:


Trusted Advisor, Male, 72, from UK

Trusted Advisor
OBP was last seen:
Jan 11, 2019
    1. VANESSA1
      Hey OBP, may I ask what version of access are you using?
      1. OBP
        Access 2007.
        Jul 16, 2016
    2. Ballistic_Weasel
      Dear OBP, Since the database you created last time, i have fallen in love with access database. I have about 2 projects i want to create in database and before i begin, i would like to know if it is even possible to do so.
      1. I want to create an invoice program that allows me to create invoices for multiple people.
      2. I want to create a report based program that allows me to add photos to descriptions
      1. OBP
        I have created databases to do both of the things that have asked for.
        If you search my posts you will probaly find versions of them.
        If not let me know.
        Jun 17, 2016
      2. Ballistic_Weasel
        Hi OBP, cant ssem to find anything. hope you might be able to help.
        Jun 22, 2016
      3. OBP
        Do you still need help?
        If so start I suggest you email me with the details at
        [email protected]
        Jul 16, 2016
    3. Garth H
      Garth H
      OBP I have sent you a Gmail message. Please can you assist asap. Thanks
    4. BoaterJohn
      Thanks for response OBP
      the error was a form field error
    5. OBP
      I have replied to your Forum question.
    6. roshni007
    7. SlowHnds
      Sorry to be a pain but rather than post in the forum on a thread that is marked solved or start a new thread I thought I'd ask directly.

      An issue has popped up with the 30 working day fix you had helped me with
      Access 2010 Set a date field to today plus 30 working days

      For whatever reason when I exit the field and the macro runs after update event. I get the error message
      "No current Record" it sets the return by date correctly (at least I think it's correct)

      I hope you can help me with this. It has just started happening apparently and no one is too excited as it appears that it is still giving the right return date.

      You can email me direct at [email protected]
    8. BoaterJohn
      just wanted to wish you a healthy bd.
    9. Garth H
      Garth H
      Hi OBP,

      Left you a message on gmail.

      Thanks Garth H
    10. BoaterJohn
      Hi OBP,
      I was away for awhile fishing. Thanks for responding to my thread. The two queries were the key. I had to make the join a 1 to many. worked like a charm
      Thanks Much,
    11. Garth H
      Garth H
      Hi OBP. Greetings from the south. Do you still have your Gmail address? Garth H
    12. vinwin06
      HI OBP,
      how are you? i think you could remember me we work together last year for one thread called "MS access query". I have attached the file too with this message. Now i am facing a big problem in the database while running that macro its generating more space and database size became more than 2 gb. As you already know 2 gb is the maximum size of the database.

      Kindly let me know if there i can do with this macro or u can help me on this. I know the problem would be like the data volume is huge (approx 4 million).


      Vinoth S
    13. OBP
      If the dates for the query come from a form, then use
      =forms!! etc.
      If they are not I suggest that you put them on a form.
    14. ade7985
      Hi OBP,
      Help again pls.
      I was trying to figure out how to setup Date range in report header.
      I got to setup query date range but on my report I setup text box on controlsource I put this: =Format(,"mm/dd/yy") & " through " & Format(,"mm/dd/yy"). then after I tested by entering date and is not showing on report header its says' #Name? on text box. I need your assistance. Thanking you in advance.
    15. Cambium
      Just wanted to leave a message saying that OBP is superman. Thank you for your help and making my idea happen with my data on excel. This member is amazing, what goes around comes around in one way or another. :-) Thank You.
  • Loading...
  • Loading...
  • You must be logged in to view information.
  • Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice