Search results

I already did change and added the field, my next problem is the outgoing quantity. If its blank the Total Qty is also blank. Please help Merry x'mas to all

Thanks for the reply, actually i already made a query please see attached file. may problem now is how to compute the Total, what i need is the incoming supplies - outgoing supplies. Please help Thanks in advance

Hi guys, I have a problem regarding the query calculation. I have 3 tables: -supplied inventory -delivered item -issued item In each table their is Item Description and Quantity how can i calculate the quantity of a specific item when delivered and issued. Thanks in advance

thanks again, how about this error Private Sub Command7_Click() Dim strPasswd strPasswd = InputBox("Enter Password", "Restricted Form") 'Check to see if there is any entry made to input box, or if 'cancel button is pressed. If no entry made then exit sub. If strPasswd = "" Or...

Hi Spikepl, my apology, Please see below Private Sub Login_Click() Dim Password As Variant Password = DLookup("Password", "Users", "UserID = '" & Me.txtUserID & "' ") If Nz(Password, "") = Me.txtpassword Then DoCmd.Close DoCmd.OpenForm "Purchase...

thanks for the reply John, I still encounter some error Compile Error: Expected:end of statement

Hi, I'm new in MS access and i have a problem with regards with the setfocus of certain form. i have a command button that will open several forms and once open i want to setfocus it in "Purchase Requisition" form. please see code below Private Sub Login_Click() Dim Password As Variant...

hello to all:)