Search results

Many thanks theDBguy... why i did not see this!:)

Good day, How could I show all my records in my data entry form by clicking a button.. I tried "ShowAllRec" but it is not working (Invalid use of property).. Thank you

Am using Overlapping Windows sir.. Id tried your suggestion "docmd. restore".. Let me see if this work..

Many thanks, i will try that sir.

Hello all, My form opens in maximize even there is no maximize command on open/current/load. How to avoid this to happen.. Thank you,

Yes.. i did read it.. the problem i am struggling to get work is the date range filter..

Hi CJ_London, Can you please expand the above, I am new to advance queries/crosstab, I can do a simple query as of now, please need more help.. Thank you.

Hi ebs17, Thank you for helping me to my query and crosstab.. I pasted your sql statement into the sql design view of my crosstab, then I copied your fctparDate function into module, and save as "fctparDate"..but when open/run my crosstab, I got the attached msg.. Can you please guide me on...

Hi CJ_London, Here is the sql view for qry_payment. SELECT tblPayment.PAYID, tblPayment.BUYERID, tblPayment.PDATE, tblPayment.ARNO, tblPayment.AMOUNTPAID, tblPayment.MOPID, tblMOP.MOP, tblMOP.BankName, tblMOP.AccNo, tblMOP.AccName, tblPayment.REFTRANSNMBR, tblPayment.REMARKS FROM tblMOP INNER...

Posted already..

Hi Pat, Can you please examine the sql view of my crosstab, i tried the put the parameter from the query that feeds the crosstab, still i could no get to work.. TRANSFORM Sum(qry_Payment_MOP_CT.AMOUNTPAID) AS SumOfAMOUNTPAID SELECT qry_Payment_MOP_CT.BUYERID, tblBuyer.byrFName...

Thanks the-doc-man..

Yes i have to admit, i can't do this at all.. if there is no easy way. When we sat and gather info, i was not told about this and it didn't came to my mind either .. so i will set aside this for now.. Many thanks to all..

Hi CJ_London, I have tried to filter the qry that feed the crosstab, but i always got the attached msg.. What I did is, I put "[Enter Date]" on the criteria row of my [PDate] field on my query that feed my crosstab, I don't if this is the correct way to filter the query..can you please help...

Hi pat, Thanks, i will try to put the parameters before the crosstab then.. Thank you pat.

Hi arnelgp, Many thanks. Can you please help me what utilities these are.. I can do manually exporting to excel what are tables affected, how can i consolodate those tables.. To tell you honestly i can't even imagine the process.. I need help pls..

In short this thing is impossible to newbie like me.. considering that this is my first project.. Thanks for all your feedback..

Hi Gasman, can you pls help me.. I need to filter by date, and presented to report.

Hello all, I am strugling to make a filter to my crosstab query, but i always get a "MS Access database engine does not recognize [Enter Remarks]as a valid field name or expression.. I think crosstab query is not same as ordinary query that can easily filter.. Can someone pls help me, i...

Hello all, Is there an easy way to syncronize record?. Situation, the main db is on the office (desktop) , 1 laptop is on site/off office.. My problem now is office desktop is updating/entering records, site is also updating/entering records, at the end of office work, site needs to upload...