Recent content by noobmaster

  1. N

    Duplicates in Table after adding data through a form

    FYI I am using this VBA code to update the table through a form Dim strSQL As String strSQL = "INSERT INTO Product(ProductName, ProductQty, ProductSupplier, MinimumStk, ProductLocation, ProductShelf, ProductDrawers, ProductUnit) VALUES ('" & Me!ProductName & "','" & Me!ProductQty & "','"...
  2. N

    Duplicates in Table after adding data through a form

    Hi, thanks for the reply, After adding a PK and editing the Indexes, I have an error message "Run Time Error 3022: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or...
  3. N

    Duplicates in Table after adding data through a form

    Hello, I have been facing some problems after adding data to a form which will update my table. Every time I make an entry, there will be a duplicate in the table, which I dont want. I have already set all fields index's to "No", and there is no primary key. Do help, thank you!
  4. N

    How to redirect to another report from a Message Box

    Is it possible to open a report through a MessageBox alert? For example maybe a button in the MessageBox that redirects to a report.
  5. N

    How to put up Message Box when field value is more than another field value

    I am having an inventory with two fields, ProductQty which is the quantity of product I have at hand and MinimumStk which is the minimum quantity required for the product. I have already made a query and a report for when MinimumStk > ProductQty, but I was wondering if I can make a Message Box...
Back
Top Bottom