Theres one video missing no.3 how can i get that video to continue  the project

best regards

Mamoun Madi

Auto PO Process Smart Inventory | Master Business Accounting 28

at 30:14 i solved the issue in following way; frm_Stock was bounded with a query "q_Stock". In the expression builder it was StockStatus: IIf(=0,"Zero Stock",IIf(<,"Low Stock","Stock Ok")). I changed it as StockStatus: IIf(=0,"Zero Stock",IIf(<,"Low Stock","Stock Ok")). I applied this change becasue i noticed that in "tbl_Items" we are changing ItmOTotal field througout this tutorial series. It solved the issue and now frm_Stock shows correct StockStatus. I want to know is this method is fine or we have to do some other changes? Is it the correct way?

I just want to share a valueable tip if you want to get the number format as a standard with one digit after decimal place then it can be useful if you write the SQL query in Video No: 20 

SELECT *
FROM (SELECT AcCommonID, AcSubNm AS NM, "G.Account" AS Type, AcCommonID, Nz(format(,"#,##0.0"),0) AS AcB FROM tbl_ChartofAccountsSub UNION SELECT AccCode,CName AS NM, "Customers" AS Type, AccCode, Nz(format(,"#,##0.0"),0) AS AcB FROM tbl_customer UNION SELECT AccCode,SName AS NM, "Suppliers" AS Type, AccCode, Nz(format(,"#,##0.0"),0) AS AcB FROM tbl_supplier) AS ;

I have noticed that int() function outside the format() is destroying the desired output result showing numbers only but not any comma or decimal place. However i used Nz function and format fuction. It worked for me.

I dont know why our tutor used ids fields twice i.e. AcCommonID, AccCode for customers and AccCode for suppliers?

I'm facing issue with my database working with images. Major issue is the location path of the images. While i'm using main PC it upload images in "D:\Server\Images" path and in Network share drive it upload in "Y:\Images" path. Due to that Images wont be display if one user uploads images and other user can't see that images displayed only the file path is display.

jpgNm = CurrentProject.Path & "\Customer Details\Images\" & jpgCd & ".jpg"

FileCopy myfile, jpgNm
Me.ProfileIMG.Picture = jpgNm 'Display Image
Me.ProfilePic = jpgNm 'Inserting the address or the path as text into the field

What will be the correct way to insert images to display in both the database? Please help me as i'm in the final stage of my project. Because of this i'm stuck. Previously i was using "Attachement" option because of that file size increased and after seeing your tutorial i'm using your method of handling images.

How do we restrict date field (Unbound form) for entry of future date ? I just wanted allow current date or past date to be entered not future date by mistakely.  What other criteria we can include for date field in unbound form to make form secured or to enter data correctly.

In my database, my major concern is Unique phone number no duplicate or matched with others. When i use below code it works fine in Add New record (Unbound forms) but when i use in update form( Bound form) it says Duplicate by checking that same customer records so i removed below code in update form. But if i remove the duplicate checking code then i might entered duplicate phone number in future. 

So, i wanted the code which checks the duplicate data but except that open records data. It should check the data with others customer not the opened customer.

If DCount("CustomerID", "Customer Details", "Phone=""" & Me.cPhone & """") Then
MsgBox "Phone Number Already Exist", vbCritical, "Already Exist"
End If

It should exclude checking the opened customer records and check other records weather it it is duplicate or not. Please help because this is my biggest concern not to duplicate the phone number and entered only unique phone number.s

Why does Access saves data automatic after making changes in bound form. If i makes changes and don't want to save data and click Close button directly without clicking update button it still saves data.

Below is the code for close button where it is mentioned acSaveNo but it still saves the data. Any other options, not to save while clicking close button? 

DoCmd.Close acForm, "CustomerMainUpdate", acSaveNo

Dim strSearch As String
strSearch = " Between #" & Me.txtDtFrom & "# and #" & Me.txtDtTo & "#"
Me.Form.Filter = strSearch
Me.Form.FilterOn = True