Trusted Advisor, Male, 70, from UK
Hey OBP, may I ask what version of access are you using?
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
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.
Hi OBP, cant ssem to find anything. hope you might be able to help.
Do you still need help?
If so start I suggest you email me with the details at
OBP I have sent you a Gmail message. Please can you assist asap. Thanks
Thanks for response OBP
the error was a form field error
I have replied to your Forum question.
Thank you for helping me earlier. I was wondering if you could help me wight his as well. Thank you so much in advance.
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]
just wanted to wish you a healthy bd.
Left you a message on gmail.
Thanks Garth H
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
Hi OBP. Greetings from the south. Do you still have your Gmail address? Garth H
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).
If the dates for the query come from a form, then use
If they are not I suggest that you put them on a form.
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.
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.
Separate names with a comma.