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
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).
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.