Recent content by Gmio

very helpful thank you, but 1 thing i dont get it which is "This way you can run a query that looks for unprinted transactions and groups them in a report by advice number." can u make an example for me to look at? i dont quite get it thank you pro!

yea i just figure it out ;( !!! but if i view the report in pop up view ! there is no print function tho? how can i bring it up so the users can view the report and print

hey, i create a startmenu for my project and it works fine... but the Menu keeps appearing on the top of everything. For example, when i click report from the startmenu button, the report will then show behind the Startmenu Form. I HAVE to turn the startmenu off to be able to see the report :(...

hey, i am in the final progress to finish the project. this database basically enter merchants details and sales record and at the end it will print out a Remittance Advice for them to look at. i have done all the calculation for the report.... such as GST on sales, merchants detail etc. i got...

hey, where can i set or how can i make the access automatic generate the the number. like i want it start from: Account number: Ra-b200 Account number: Ra-b201 Account number: Ra-b202 cheers

so whtever i used i should put.requery at the end right?

i have a form that shows products and customer and also have adding new products and new customers form... my problem is when i add a new product and customer it doesnt show it straight away? i have to turn the form off and turn it back on again so the new details will be there is that normal...

i have been using this template for over the months and i like it, where can i look at the dialogue form and u mean i do all the calculation in the report instead of form?

oh forgot to say , i want this access database to print a monthly report(diffrent month) for the merchant so its show the gst, commission and item cost etc many many thanks <3

hey, i got this template from microsoft template online, and trying to modify a bit for my own experience and company :confused: alright here is the problem: 1- Client try to record the customers detail ( It works well) 2- Client record how many items the customer sells per month (all good...