Search results

thank you guys....... its working well

Hey guys.... stucked in one thing..... I need to extract Month and Year together from a date in a Query. for example if date is 4/19/2007 i want to put this as April 2007. Any idea ...? thanks

wonder what kinda command that would be.......... :)

I have an access POS application which prints receipt on a receipt printer. I do not have a specified length of the receipt as sales vary in the quantity of items . Does anyone know how I can code it so that the last text is the end of the report and the paper is cut off right there? And also...

thanks dude... it works well.

Sorry to disturb you again. this code thing isnt working. now I am getting this message. Run-time error '3075' Syntax error(missing operator) in query expression 'ProductID=ProductIDAND purchaseOrderID=PurchaseOrderID' :( Please help me..

Private Sub ProductID_BeforeUpdate(Cancel As Integer) If DCount(tblinvInventoryTransactions, "ProductID = ProductID" And "PurchaseOrderID=PurchaseOrderID") > 0 Then MsgBox ("More than one product in same order") Else End If End Sub thats the code i used. thanks

Thank you very much for your help dude. that code seem to be okay but I get this error message. "run time error 13", "type mismatch" Any idea? Would appreciate if you could work it on my attachment and put it back. :) thanks

Guys, I have been working on this Inventory application using Ms Access and I am almost done. A big thanks to some beautiful tips on ur forum. However I ve got stucked on one little thing. Its, for example when I create a purchase order and start entering Product items in Purchase order, I dont...