db filtering report need help... (1 Viewer)

[moi]

attached is my basic db, i have a problem in filtering my query for report source.. everybody is welcome to share solution..

please bear with me, just started learning access..

Area of concerns, queries and reports.. i used query to filter reports, but it gives me blank sometimes.. i.e. commission report buyer..

 

[arnelgp]

see the code on "commission per buyer" button on frmPrintMgr.

 

[moi]

see the code on "commission per buyer" button on frmPrintMgr.

Thanks a lot sir.. It does print the <all buyer>.. But no record to display for individual..

 

[arnelgp]

no, i did test it. only Buyer ddd dd, fff ff and ggg gg has commission (based on your query, see query qryCommission_Report_buyer).
actually if you print "ALL" you will see those 3 names on your report.

on second thought, why the Buyer have commission? how about the Agents?

 

[moi]

no, i did test it. only Buyer ddd dd, fff ff and ggg gg has commission (based on your query, see query qryCommission_Report_buyer).
actually if you print "ALL" you will see those 3 names on your report.

on second thought, why the Buyer have commission? how about the Agents?

oh sorry... my bad..

 

[arnelgp]

yes it should print the 3, and it is printing in my computer.

 

[moi]

oh sorry... my bad..

indeed they define the commission for "agent", "admin" and "mktg assist".. as shown on comm type.. and that is my struggle to make the total for the 3 comm type.. pls can you help me on that part also.. if you notice all my reports were not totaled on report footer..

 

[moi]

yes it should print the 3, and it is printing in my computer.

yes sir it is working very well, sorry my selection was pointed to the buyer with no comm..

 

[arnelgp]

is that on Same report? you want the Summary for Each commission Type?

 

[moi]

yes sir it is working very well, sorry my selection was pointed to the buyer with no comm..

is that on Same report? you want the Summary for Each commission Type?

yes sir, and also on the general report of the commission..

 

[arnelgp]

see your report, i added 3 textbox on footer section.
also see the formula on those 3 textboxes on design view.

 

[moi]

see your report, i added 3 textbox on footer section.
also see the formula on those 3 textboxes on design view.

wow thank you very much sir arnel.. those things are beyond my knowledge as new learner..thank you...thank you sir.

 

[moi]

see your report, i added 3 textbox on footer section.
also see the formula on those 3 textboxes on design view.

Sir is there an easy way to hide the Access menu/toolbars when my database open?. To restrict user to play with the objects?.

 

[arnelgp]

Navigation pane (left side window where you can see tables, queries, etc)? you can hide it using Access Option->Current Database.

 

[moi]

Navigation pane (left side window where you can see tables, queries, etc)? you can hide it using Access Option->Current Database.

A ok.. I will check... How about the one on top of the screen when you open Access, i dont know what to call those like menu or toolbars.. Is it posible to hide also.

 

[arnelgp]

kung medjo, hindi "expert" yung gagamit, pwede mo i-rename yung db mo, change the extension to .accdr (runtime). ribbon menus and nagivation pane will not show.

 

[moi]

kung medjo, hindi "expert" yung gagamit, pwede mo i-rename yung db mo, change the extension to .accdr (runtime). ribbon menus and nagivation pane will not show.

Nakita ko na ung navigation pane.. Ang masama ngayon, may napindot ako sa taas, nawala mga toolbars/menu.. Paano ko irestore sir.