Search results

Any body has a dummy library database , please post ...and help me

=DLookup("current_stock", "tblStock", "[Stock_Id] = 1") it works for Stock-ID=1 in the main form getting compie error in "0"

=DLookup("current_stock", "tblStock", "[Stock_Id] = 1") CODES working fine in the main form with stock ID =1 others are producing error The value of ITEMID is not being taken from subform (datasheet view)

Yes it is store in the Stock Table as field name 'current_stock'

In the details invoice section while entering records for invoicing it takes any value, thus after updation of the stock table it becomes negative. Howver, if stock value is 0 the item is not listed, so that time no problems. It the Stock held is 1 also it shows in the item list. I want the user...

Actualluy I want to verify the stock position before preparing invoice.. can you help me

No. it is giving the same error.

TXTSTOCK.Value = DLookup("current_stock", "tblStock", "Stock_Id " = [Forms]![SK Enterprice]![TblInvoiceDetail Subform].[Form]![ITEMID])

how to get the stock position before e ntry in quanity

its not working object require error 424

No I put the code in the after update event in thetext box ITEMID to get the stock position before entering the Quanity ...

Thanks ... but it does not display the stock position I put the code in the after update event in thetext box ITEMID to get the stock position before entering the Quanity ...

thanks! Can I put this in the After update event in the Quantity filed, I tried it is giving an error message type mismatch

I have a field Stock_id(auto-number: Foramt P00001, P00002 etc) When I use Doolkup function to get the stock value using tjhe code =DLookup("current_stock", "tblStock", "[Stock_Id" = [Forms]![SK Enterprice]![TblInvoiceDetail Subform].[Form]![ITEMID]) it returns nothing How to resolve.

where to call the function for getting stock at any time

Thanks for your prompt reply!!!! I have a form name FrmSale and a sub form Invoice_details in which Item, Qty and Amount are specified. I want to run a update query to change the Stock in the table TblStock on entering the Item qty.

how to make an update querry from the values in subform included in the main form

my codes are as follows: Function importscroll() Dim nameList() wkbookPath = "" & Application.CurrentProject.Path & "\Master\scroll.xlsx" Dim duplicatescroll As Integer Dim countscroll As Integer On Error Resume Next filePath = Dir(wkbookPath) On Error GoTo 0 If filePath = ""...

I having a form to entry data is it posible to place a virtual keyboard?

Thanks