Search results

Hi, I am very poor in programming, however i would like to learn more, as i have find out it can create magic in daily work if i have the knowledge. Please help me with your expertise. I download inventory details from a web-system and it will run in excel or openoffice. It will have the...

I want the macro to open a report name "rental1" when [Forms]![Receipts]![returndate]>[DateDue].... And open report name "rental2" when [Forms]![Receipts]![returndate]<=[DateDue].... How do i do it? My current project open two reports, one the desired one, the other the error one? Plz help...

Hi there, I post a attachment. Please help, why is it when i preview my Borrowing receipts, it ask me to Insert Parameter Query?? Whereas Return Receipts is ok?? When i switch the macro to ReceiptsFrame=1 infront of ReceiptsFrame=2, The return receipts seems to have this problem.... Please...

SELECT Rental.BookNumber, Rental.ICNumber, Rental.DateBorrowed, Rental.DateDue, Rental.DateReturn, (([DateReturn]-[DateDue])*1) AS Fines , BookMast.Title FROM Cust INNER JOIN (BookMast INNER JOIN Rental ON BookMast.BookNumber = Rental.BookNumber) ON Cust.ICNumber = Rental.ICNumber; How do i...

PROBLEM: I have got a frame, two option_box called-----Borrowing Receipt and ReturningRecipt, they control theTextbox to retrieve the correct data(receipts), my macros are working well, the problem is, whenever i have type in the data in the textbox, after i click the print or preview button...

How can i send email to all my custmer and particular customer without entering the email add manully?? I stored their Emails in my customer table... Thanks

I have got a date/time field named [DateBorrowed] Now i wanna create a field call [Year] which show the year in [DateBorrowed] How am i supposed to do this?? Thanks