Search results

Thank you for code it's working. But, now I have new problem, if you see first picture "qSkenirano" I have one article ( artikl field ) two times because query show two barcod. How can I write code to sum qty for that article and show me only the main barkod?

Thank you, I will try

Hi All, I need help with reading data from table. My product table "Baza" has two field with Barcode. Barkod field is primary key and barkod2 field is non primary key. See picture "Table Baza". The name in table is on Croatian. I created query, when I scan barcode with scanner all data is show...

I can't get right form, can you help me? can you write me right form

Hello all, I need help with chose right table for delete row. My query ; DELETE Sken.Barkod, qSkenirano.Nalog FROM qSkenirano INNER JOIN Sken ON qSkenirano.Barkod = Sken.Barkod WHERE (((qSkenirano.Nalog) Is Null)); After that I get error ; Specify the Table containing the records you want to...

Thank you for detail explain. Can you tell me how can delete last record if get message: If MsgBox("Do you want to delete the scanned barcode?", vbOKCancel + vbCritical + vbDefaultButton1, "Delete article") = vbOK Then

Hello all, I need help with the Input Box and CancelEvent. The following is a function that I made. The point of all is that over the function Input Box it is import into a Sken table. At the same time, I need help how to stop import before if validation fails. I put the command CancelEvent...

Thx for helping, now is working. Private Sub Command7_Click() BARKOD = InputBox("Upiši barkod", BARKOD) DoCmd.RunSQL "INSERT INTO Sken VALUES (" & BARKOD & ");" DoCmd.RunMacro ("m_Refresh") End Sub How do I get to repeat the command. For example, now after each entry barcode must touch...

Hi, I'm doing a program to check the warehouse orders. I need help with InputBox. Does someone can help me with the command to update the barcode field. The table is called a scan, the field is called barcodes. Forth below is the process by which I have worked for the same to me nothing...

Hi, I need a little help with making criteria in excel. As is evident from the image attached here is a simple order by the scanner. Using COUNTIF formula I made that every bar code that is scanned in row "K" verify barcodes "B" and thus get a result in the row of the "H" and "I". In this case...

Hi, how to set up msg box in VBA for the entire row. For example, I want to let me know if size is greater then 0 in all row D. Sorry for my english.

Hi, I put attach the base I started to work. Its purpose would be to control the output of orders in the warehouse. I am interested in how to do when you open the form "fOrderEntry" following; EanCode the field should print a barcode which is scanned with the article, when repeating the same...

My name is Mladen, I live in Zagreb (Croatia). Recently I started a little work with Access and I am very intrigued by what can be done. My knowledge is superficial, but I am here to learn everything that interests me.