Recent content by illusion

Thanks a lot!! Most of the things you changed i don't know how to because i am new to access.... :rolleyes:

hello, i missed a link (http://allenbrowne.com/AppInventory.html) in a post, this is very helpful but i have a problem, instead of the list box you said i am using text boxes. I have TblProducts(ProductId,UntiPrice....) TblProduntsOrdered(ProductId,OrderId,Qty,UnitPrice) how i will assign the...

hello, i have 2 problems, 1 how the stock control will work? I found similar posts saying to calculate the items sold and compare them with items in stock. When there is restocking the items in stock field will be increased? 2 i want to store the total amount paid from a customer in each...

ok thank you Uncle Gizmo, cheers :p SJ McAbney i was wondering y that happened and then realise that it's case. thnx

should i remove those lines ? still not working with dt01pqt's way. :confused: is an expression in a query, this report has to do with paymets, showing which months(lbl1,lbl2....) member hasn't payed and counting the months that hasn't payed (i=i+1)

thanks for the reply. i don't know a lot about access or vb coding. i don't know what those are used for.. anw this is for current month i changed the code to what you told me Option Compare Database Option Explicit Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)...

i don't know if this is the right section but i need some help with my code. i am wondering if it's possible to reduce this code or if it's the right structure.. i have a lot of if statments... check the attachment

some1 helped me and i have attached an example. now i want to change it doing this: list all members that have not payed until this month and which months are owing. i tryed to change the query in the example to this but is not working... WHERE ((month([PaymentDate]))<month(date())); thank you

i am working on a project which a part of it has to do with payments. what i am using for payments is a table where for each month that member pays the date of payment is recorded. i have tblpayments(memberid,jan,feb,mar,apr,may,jun,jul) if the member hasn't payed means that the month field...

thank you for your reply, Not In (SELECT MemberID FROM tblPayments) worked just fine but it doesn't work if i put the tblpayments in order to have all toogether in one query. Nevermind i can create 2 queries/reports... my main problem is i know how to set sorting but how i do the other...

hello, Thanks for your reply. I tryed the code u gave me What i got is the firtst month when the student paid. ex.:[ 12/09/2003 ] but i think i diferent than what i want what i think is that, in somehow (which i don't know how) check for every student in my tblmembers if the last date in the...

Please help!!! Very important, find records that doesn't exist hey, I am a newbie using ms access and i need help as soon as possible. :( I have already check the forums but I haven’t found anything I have a private institute system where the students select their courses and then every...

hello, I am using a query to display my report and i want to have 2 criteria, I want the user to be able to select the values from a list insteat of writing them into a text box (use of [Please enter mpla mpla] in query>field criteria ). I have 2 forms, each to select the value they want.In...

OH sorry its ok... it inserts the month but the caption on the new record row writes "error" but when u insert a new record it puts the current month automatically. Thanks.

it doesn't work. it returns on my list #error.... i want to show e.g March as the first choice is that the needed code ?