O
Reaction score
50

Profile posts Latest activity Postings About

  • Are u still using this site? I havent talked to you for several years...
    O
    OBP
    No, I had a very serious disagreement with the Administrators on the Controversial Topics Forum.
    Are you the Margo from Greenes Jewellers?
    You can contact me at [email protected] if you need to.
    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
    O
    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.
    B
    Ballistic_Weasel
    Hi OBP, cant ssem to find anything. hope you might be able to help.
    O
    OBP
    Do you still need help?
    If so start I suggest you email me with the details at
    [email protected]
    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]
    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,
    boaterjohn
    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).

    Regards,

    Vinoth S
    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.
    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.
  • Loading…
  • Loading…
  • Loading…
Top