Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.

Notifications

Clear all

Coding the Summary Boxes on the customer, supplier and orders forms

FStetson · 2024-11-18T00:12:30Z

Okay, I am having a lot of trouble figuring out how code the count bar at the top of the listed forms. Currently I am 2/3 the way of getting the Orders form to work right, whereas I can count Hold and Pending, but the NotInvoicedOrders line is killing me. I have checked all my instructional information on DCount and using the instructions you gave3 in lesson 7 (Stock & Inventory) video. I keep getting Error Message 3464, data type mismatch. (see code that is causing this below) Private Sub Form_Current() Me.txt_OnholdOrders = DCount("OrderStatus", "tbl_Orders", "OrderStatus = 'Hold'") Me.txt_NotInvoicedOrders = DCount("OrderIsInvoiced", "tbl_Orders", "OrderIsInvoiced = '1'") Me.txt_PendingOrders = DCount("OrderStatus", "tbl_Orders", "OrderStatus = 'Pending'") End Sub On Hold and Pending works fine. PLEASE HELP! I do not need the code, although it would help. but a more in depth understanding of how you are using DCOUNT in this application would be wonderful. I think there must be away to count the IsINV field, but I am lost as you see. BTW, I fixed a small glitch on the OK Stock Items counting your source file. It was counting all records, small change and now it is counting just the Ok Stock Items. Private Sub Form_Current() Me.txt_OkStockItems = DCount("StockStatus", "q_Stock", "StockStatus='Stock OK'") Me.txt_LowStockItems = DCount("StockStatus", "q_Stock", "StockStatus='Low Stock'") Me.txt_ZeroStockItems = DCount("StockStatus", "q_Stock", "StockStatus='Zero Stock'") End Sub Thanks as always, hope this helps everyone else! ErrorScreenshot.png

Page 2 / 2 Prev

Master Business Accounting Project Forum

Last Post by ursh 7 months ago

6 Posts

2 Users

2 Reactions

301 Views

RSS

Posts: 18

ursh

Admin

Dec 02, 2024 3:43 pm

(@ursh)

Member

Joined: 1 year ago

That sounds a clear picture of grouping, the idea and efforts are appreciated. Contact info would be better in place of just a Phone Number.

Page 2 / 2 Prev

4 Forums
27 Topics
105 Posts
0 Online
20 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed