I have a query which displays all sold products total correctly, but the heading is the product code NOT the product name
TRANSFORM Count(tblPayments.Product_ID) AS CountOfProduct_ID
SELECT "Total Count" AS Remarks
FROM tblScale INNER JOIN tblPayments ON (tblScale.AMOUNT =...
I used now your code from the actual selection,
*********************************************************
Private Sub cmdAppWindow_Click()
On Error GoTo Err_Handler
If Me.cmdAppWindow.Caption = "Show Application Window" Then
'can't do this if form maximized & fills screen...
I have added the following code (from your sample) into the load event
****************************
On Error GoTo Err_Handler
Me.cmdRestore.Caption = "Maximize Form"
cmdRestore_Click
Me.cmdTaskbar.Caption = "Hide Taskbar"
cmdTaskbar_Click
UISetRoundRect Me, 0, False...
i have removed the tool bar with
****
DoCmd.ShowToolbar "Ribbon", acToolbarNo" and 'Me.Caption = " "
****
but it still shows
can i remove this?
Thank you ver much
Sepp
I have a table (see below) which has field "Product_ID", ( numbers 1 to 7).
I would like to create a query to give me in seven field the count of each product.
I tried but failed.
Thank you
Sepp