Recent content by allanlai

Hi all, Thanks a lot for the feedback. Here is the complete picture. This is a simple ERP with back-end MYSQL database and Access front-end user interface which I am creating. Around 20 users may concurrently working on it. The interface include: Sales Order, Production Order, Inventory...

Hi, I have a form with some unbounded textboxes and an Edit button. When the Edit button is clicked, it should run a SQL query then retrieve a record from a table into the recordset then the record source of those unbounded textboxes set to the fields of the recordset. Before I clicked the...

Thanks essaytee. I use the combo box for a simpler procedure.

Thanks essaytee for the suggestion. I tried to move the codes to the AfterUpdate event but it is not performing exactly what I want. It allows user to click the cancel button but also allow the user to move to other controls after the message box popped up. What I want is: If the customerID...

Hi, I am creating a form for invoice input. This includes a textbox for customer number (tbxCustomerNo) and a read-only textbox (tbxCustomerName) for customer name. I have a DLOOKUP function in the onexit event of tbxCustomerNo to look up for the customer name from a table. If found, the...

Hi everyone, Nice to meet all of you!