Search results

Hi Good day to all, i sorted the P_Date in descending (thru Query1) and provided the result correctly. However, I prefer that the Blank row in RED (with default value of Date today on D_Data) should be on the top. I tried the option MySort: IIF(IsNull([P_Date],999999,[P_Date]) but does not...

Hi AWF Team, I would like to ask your help on my database. Below is combine screenshot of table, query and chart (chart is linked to query). On the query, I filtered the "Customer" for CustA, CustB, CustC by Group (refer to the attached DB), however no value was generated due to other condition...

Good Day to all, I would like to request your assistance to the below query. Attached is my sample DB. In the form below, there are AVG_Cust automated value from Customers. I need that the third column will have an automated value based on the value from AVG_Cust. As per below sampe if the...

Hi Team, I would like to ask help for the Chart color format. Trying to copy here the screenshot of the forms output but it doesn't allow me. Attached is the database, kindly open the form and you will see the chart output. Is there a way to manually change the color of each column and to...

Hi All, With the help of Accessworld Team, my dabatase is progressing well. I have attached the latest draft and would like to ask your suggestion on the next step. Based on the Database Query, its filtering the Customers, Product A etc...and the result form is as below. Since there are 5...

Hi XPS35, Hi All, XPS35 has provided the solution to my previous query and really works. Single average value per Cust_ I revised the query due to additional requirements by filtering the class"M" from ">#01/09/2022# And <#01/9/2023#" But the form display several values of Cust_A, Cust_B...

Hi AccessWorld Team, From the Database1 file that I'm woriking, I created a form called "Dashboard" and added 3 text boxes. The value of these 3 text boxes should be taken from the value of the text box "Average" from the forms namely "FCust_A", "FCust_A", "FCust_A" which are different forms...

Hi All, I would like to seek your assistance on the output that I wanted to generate. I made a simple database2 with Table, Query,Form, Report to show the required assistance I needed. In form there is a button (Send Email) with VBA code to generate an outlook email but due to lack of my...

Hi everyone, Hope someone can help me on this task. I attached the Database for your reference with table and form only. Query 1: I have a combo box Item with dropdown values Item1, Item2 and Item 3. Would it be possible that when I selected Item 1, the combo box "Distribution" will display...

Hi, Good day to all. Reference below, can someone please help me to create a code that when ActualD field is empty the SchedD field is flashing/blinking (in red color text) Once a value is added in the ActualD field the blinking in SchedD field will stop and back to color black text. Thank...

Hi, I created a Search box and search button that is working fine when the word to search is available. But when the word to search is not available the Form page will be displayed in blank and to return to original page I have to tick the "toggle filter"(below screenshot). Can some please...

Hi, I have a Search box and Search button that works fine when searching a particular word. The clear button works fine as well but the issue is the word stays in the search box. Can anyone please help on how to clear the text as well after the clear button is launched, below is the code that...

Hi Everyone, The sorting of Date in Ascending order displays the null value at the top. As per my project requirements, in ascending order the null values should display at the bottom? Can someone help me on how to do it?

Hi everyone, I am using Access 2010 and base on my research the option to link a calendar is not an option to this version. If there is other way, can someone please advise on how can I add the calendar in 2010 Access? Thank you

Hi Everyone, Thanks for accepting my request to be part of the Accessworld. I'm new in Access and interested in learning more