Recent content by richardplr

Hi, Can someone advise how to import from excel. include the heading. thanks

Yes, it is very helpful on this example but when I copy it on the actual spreadsheet, it doesn;t work. Please see enclosed real data on spreadsheet. Hope someone can help me. Thank you Regards

Dear All Please see enclosed and kindly help. I have 2 excel tabs, one is the inventory record and the other is a empty table with all the heading. I need to key in the serial number under the "serial number columns and then the rest will appear. Can someone please help, the function is some...

Hi DamFlard, Thank you for your kind respond. I got one question on this. You mentioned that I have to indicate what is the number barcode number is 1234 what if I don;t have a fit number, can I made the barcode number as dammies. Please advise

Hi, Anyone has experience for barcode. Example, if you scan the first time then it will appear total 1 and if you scan again with the same barcode, then the total will change to 2 ...etc. Anyone has experience, please share. Thank you Regards, Richard Tan

Dear Excel Guru I have enclosed a sample of a loan form. On the left hand column, it is a serial number column, if I enter the serial number on the left column, the rest 3 column will also show up other information. The purpose is that when I screen the barcode, the right c olumns will also...

Dear All I would like to know is it possible to auto add up the quantity, everytime I use my barcode scanner scan up the same barcode no. Example: I have few sample items with same lot no. when I do stock take, I scan all the items and if I scan with the same lot number, it will add up to...

Hi, I am just a new greenhore learning ms access and I am planning for a warehouse/inventory storage database. My question : 1) I have 4 product division (Do you think it is good to have 4 tables):confused: 2) The calculation field. (How does the mechanism work when I take the the item out...

Great work Thanks.

Hi Thank you for your help but I still got error, Please see below whole coding Private Sub Product_Code_BeforeUpdate(Cancel As Integer) If DCount("[product_code]", "[PRODUCT MASTER LIST]", "[product code] = '" & Me.Product_code& "'") Then MsgBox "This Product Code has already exists!!"...

Hi Please help. I have create the below code in red but what is the mistake. If DCount("[product_code]", "PRODUCT MASTERLIST", "[product code]"= " & Me.Product_code& "'") Then MsgBox "This Product Code has already exists!!" Cancel = True Me.Undo Exit Sub Else 'Do nothing End If Thank you

Hi all Please help. one of my table is confidential data and I don't want people from opening from the table. Can I block people from opening but people who has password can only access this information. eg. please see my enclosed attachment file and the table is cost. I don;t want people...

Well done. Thank you

Dear everyone I have enclosed a sample need someone to help. I have a form and in the form there are sentitive information such as cost price. Is there a way to make it invisible or make it protected (cannot see) and then set a button beside this field, if I want to see the data in that field...

Hi. I select those without check at the logical field to be print but it print some of the check logical field also. I not very good at coding, what other code do I need to add. Please help. :confused: I have attached a sample for easy understanding. You may use Biogen as supplier...