Search results

Hi all, I have a query with MOP (mode of payment) column, like. Cash 500 Cash 300 GCash 400 Bank 300 Bank 600 Cash 300 Bank 300 GCash 200 Now, this one i could not figure out how to make a total for each mode (cash, gcash, bank) in separate column.

Thank you..

hi gasman, ok can you pls put that in code how these 3 controls look like on afterupdate event pls..

Hi can you pls expand to where should i put that code? And since i have 3 controls to fill, should i create 3 txtboxes with 3 different column assignment?

Hi little by little, through this forum kind help soon i will fix these wrong approach/design. Thank you all to your valuable help and advises..

let me try that tom, i have had enough for today..

column(1) is for the MOP ie Cash, GCash, Bank, Check column(2) is for the bank account number column(3) is for the bank account name..

yes am trying to duplicate your demo but i think i did it incorrect.. it turns out unupdatable..

i tried to duplicate your db demo, but my query turns out unupdatable..

hi theDBGuy, am trying to use the column property, i got it display for the 3 columns of the first row, but when i enter the data for the second row, it change also the first row, how would i fix that.. i use the below MOP Account Number Account...

hi pat, sorry takes time to answer, off to site. Anyway, i got it working with the orig code.. yes my bad, all i thought is a numeric, until i verify the table.. my apologies to all..

hi, here is the original code: If IsNull(DLookup("userID", "tbluser", "username = '" & Me.txtUserName & "' and password = '" & Me.txtPAssword & "'")) Then I tried all the suggestions above, but it throws same error..

Thank you, will try this one Am trying to implement the autofill from your demo, but may query is getting lock.. tblPayment and tblMOP.. I duplicated your query to my query.. Link field is "MOP" (number) of tbl Payment and MOPID (pk autonumber) of tblMOP..

it shows the (strwhere = "username = 'moi' and password = '123'"

nope, it throws the same error..

Yes because when i hoover over the username and password, it shows the correct value..

it shows the same error (Run-time error: 2471)..however if i hoover the mouse over the txtusername and txtpassword control it shows correct value..

how i wish that i do have a deeper knowledge on code.. at the moment i can create a simple db through "wizard".. and offcourse from this forum with the help of generous experts. am trying hard to learn..

hi pat, it is not the permanent solution, it is a quick fix so to say.. yes the report is coming from a query and the date criteria is a column on that query.. note the duedate is not a date, it is a number from 1 to 28/29/30/31..and it is manually entered, which i believe they just based on...

Hi all, Can someone please examine the code I got this code from a youtube video, i can't figure out what is wrong, it is working in the youtube video. If IsNull(DLookup("userID", "tbluser", "username = '" & Me.txtUserName & "' and password = '" & Me.txtPAssword & "'")) Then When run the...