Search results

Ok Thank you Arnel, yes that is the clue, it works now.

Arnel, whem I tried in the example attached, there is an error message for one record. Did I miss something? Thank You

Thank you Arnel I will try it

no duplicate Arnel, As I have ever raised my question, on how to make multi unit of measures in Access, it seems difficult so I decided to 2 databases, one in Case, and one in EACH Unit of measures. So instead of key in to the unit price of each, I just exported in excel, than I modified the...

Instead of typing in the new table one by one, how can we make updated query to update unit price & UOM of the table B to table A Unit price and UOM fields on the same Itemcode of the 2 tables. Thank you for any samples

Thank you Arnel, I will study first.

In the main switchboard, we create another switchboard?

Below is my Log in Table. The AccessType, I have Admin, User, User2. How can we make it that User2 can only View/browse reports of forms.

Ok, thank you Arnel, we are not a big company, we are just school's housekeeping dept. So actually it is ok, I have made it, and I think it is very rare to revise the item code

Thank you, I see the sample on youtube... I understand now

What is Cascade update DBGuy...

Hello, I just suppose a user make a new itemcode(in inventory table itemcode is a primary key), say "40x42C", that should have been "40x42B", then the user already make a receipt transaction for this item code. The table below is the db relationship. When I tested to change it to "40X42B" , an...

Yes Gemma, it seems I just make a simple way, on the Admin Form, I just make a button to open a form of Edit Item, in edit mode when open. It is more simple. Thank you,

It hang here Gemma, fyi I do not have userID field in the form, I just have user name and password to fill.

I think is UserID when we login, because the purpose is only Admin, that can edit itemcode in the "Edit Item Form". because I locked the itemCode field in the form, when common user open it

UserID is a autonumber

Arnel, do we need to make this on the on unload event of the loginForm? Private Sub Form_Unload(Cancel As Integer) If Len(Me.UserID & "") = 0 Then Application.Quit End If End Sub Because I have tried to adopt your suggestion to mine, the same problem existed like before. Syntax...

OK Arnel I will try to adapt it to mine. Hopefully there will be no more miss match compile error.

Thank you Arnel, I will try it tomorrow, I am ready to sleep now, coz tomorrow will work at 6 am as a blue color job. How can you do it Minty

What is the password Arnel. To be honest, I am not expert in all of this, I just watched on Youtube and I follow step by step, so my login system is still very simple one. As I already shew that my table fields just consist of , UserID, Name, password, and Accesstype. So I need to study from all...