Search results

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

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, 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...

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

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

Hi I have a query and I have 2 need 2 sorting within the query. 1st query is Product Name (I need this to be Secondary sort) 2nd query is Date (This to be primary sort). Can I do group, if yes. How to do (Sorry, I have forgotten how to do) Tks Regards,

Hi. I have a program which is design for everyone to use but I am not good in programming so I cannot write a program for multi users Any expert here can guide me how to convert from single user to multi user. Thank you

I have a question to ask. 1. Is there any limit of No. of users for MS Access XP Version. 2. Example, if the max number of users allowed for MS Access XP Version is 10 users and the no. 11 users who try to access will conrupt the database, it is true. Please help to answer the above 2...

Hi. I have a search field for multi-search which mean that you can either key in product code, product description or supplier code then you can find what you want). After I get my data, I double click it to go to another form to show full details. (Here is my problem - when I double click...

Hi I insert this code, but not working. DoCmd.OpenReport stDocName, acPreview, , "[Requisitor] =" & Me.[Requisitor] DoCmd.Maximize DoCmd.RunCommand acCmdZoom75 I have a form with a preview button and when I click this button, I can preview the report of whatever ID that is on the form...

Where is the error in my code. Please see below Private Sub Product_Description_Click() DoCmd.OpenForm "Check by Product Nam", acNormal, , "Product Description = '" & Me.Product_Description & " '" End Sub I get error mistake, pls see enclose attachment. Please help :confused: :confused:

Hi, I have a form and on the form, I have added a button. when click, it will open another form and link and will show all the relate link data. Can anyone help.

Hi I really need advise/help from you guy. I intend to create a inventory database. (Currently, I am using Excel to do it) because I have converted all my work from excel to access. Attached please see my inventory record in Excel form. I have created a table with many month field & also...

Hi, I have a form which I set a button to open up another form, I set criteria to read another form supplier_code. Please help to see the undermentioned code is correct. Private Sub Command68_Click() On Error GoTo Err_Command68_Click Dim stDocName As String Dim stLinkCriteria As...

Can someone explain what is a foreign key, any example in this access forum. Thank you