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.