Recent content by masoud_sedighy

regarding my previous question combine chart I did not get answer, I have used modern chart in Access 2019 and has been used link child fields and master fields, Now i want in the report depending on the data of chart it is determine Automatically secondary values axis minimum and Maximum for...

I have made a combination chart (Modern Charts) in MS Access 2019. 2 line charts and 2 column charts as below picture. with sample data like below: From_to Plan(Period) Actual (period) plan(C) Actual(C) FROM 01/03/2021 to 01/09/2021 0...

I want to add column chart in my report, I have created a simple query for data source of this chart, my problem is the Chart is prepared is small and I tried a lot but I can not fit the chart on the report and it seems small and not good looking like charts in Excel, Please help what is the...

Thanks, I fixed first error. about counting with subselect, I do not know other way, because it needed multiple filter, I did like this. I deleted spaces of fields but still has same error.

I have 2 queries one of them is crosstab query and second one is group by query like below: DCI_Crosstab: TRANSFORM Count(Doc_List.[Document Number]) AS [CountOfDocument Number] SELECT Doc_List.[Owner Discipline Code], Doc_List.Status, Count(Doc_List.[Document Number]) AS [Total Of Issued...

I do not use Sharepoint now, just I need to do a workflow form in ms access.

Thanks alot Gasman for your help, for getting more idea If you know or have some templates or samples have used this solution please inform to me.

Hi I need where the project gets assigned to the next department in a workflow automatically when completed and each person in that department gets notified that the project is now in their queue I appreciate if you can address me for some samples like this for download and getting idea.

Name of module is ( module1)

When I click the buttonA in my form, it runs a macro that there are some update query and a RunCode Action inside that. update queries will be run buy RunCode does not execute function Function Name of that is Update_Trend_Line_by_Month () I have made a module and put this function inside...

Yes, i have added columns in excel like (remark) column and i need manually typing some thing in this column, now when refresh this excel file that has been connected to MS Access query, the old columns there are the same in the query will be refreshed and new column i have added manually in...

I have an excel file it has been connected to one query in Ms Access file. now i need to add some columns to my Excel sheet and type manually some things. now after inserting some records in Ms Access table and then refresh my Excel file, excel file will be refreshed but what i have manually...

I have 2 tables; design of first table is like below: Table 1: id_Doc_line_sheet (pk),Autonumber DocNo (text) lineNo (text) Sheet No (text) Combination of fields (DocNo, lineNo, Sheet No) is index and unique. design of second table is like below...

thanks, if i wanted to do the same job with filtering subform (not changing record source of subform) how i have to do that? also for unfiltering the subform.

I have a main form and a subform. Now for filtering subform depending on a combo box on the main form,I have put 2 buttons one for search and another one for clear search, When i click search button it changes record source of subform and it works. When I click clear button it changes record...