Search results

  1. Z

    Copy Rows from 1 sheet to another sheet

    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...
  2. Z

    Why does it open two reports?

    Well... If thats the case, thank you.. i am not gd in VBA
  3. Z

    Why does it open two reports?

    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...
  4. Z

    Insert Parameter Query??

    Yeah... It works now... Thanks alot... Project dealine is on friday... You save me!:D
  5. Z

    Insert Parameter Query??

    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...
  6. Z

    Negative sign

    thanks, it works
  7. Z

    Negative sign

    i have tried >=0 but still can't work *1 is the amount to be chqarged... $1 per day late
  8. Z

    Negative sign

    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...
  9. Z

    reset TXBOX

    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...
  10. Z

    Sending Emails

    ah??? No idea how???
  11. Z

    Sending Emails

    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
  12. Z

    Date----year

    Thanks
  13. Z

    Date----year

    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
Back
Top Bottom