Search results

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...

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...

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.

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...

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...

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...

i have a main form and it's name is:[frmTranstoCon-vp_New] and this main form has a continuous subform and it's name is:[fsubTranstoConDoc-vp_New] now i want after click one button from a subform i call the current event procedure of main form, i have done it in several ways but i got error...

I have two tables. In table1 I have 2 columns like below, Doc No is (pk) Doc No Title -------- ----------- Doc-0001 test-0001 Doc-0002 test-0002 In table 2 I also have two columns Doc No (pk), Transmittal (pk) Doc No...

I have a main table that is consists of 4 fields like below and Doc No is a primary key in the table. <code> Doc No Rev Transmit Ct_Cs </code> data of my table1 is like below: <code> Doc No Rev Transmi Ct_Cs BB2-004-8115-1(4) 00 tt-0001 ct-cs-0001...

in my macro there are several append queries, now when i run the macro i got error "record is deleted, error 2950" on one of append query. before migration tables to sql server i was running this macro without problem , now after migration tables to sql server i got error "record is deleted" i...

after migration to sql when i run the macro for running append queries i got alot of error like "you can not set null value...." and error "primary key could not be duplicate" , .... i have tried to correct these queries with using NOT IN (SELECT.....) in the append queries but i still got...

how to solve error "Violation of PRIMARY KEY Constraint "XXXXXXXX". Cannot Insert Dup i am using 3 different append query for inserting records from ms access front-end to migrated sql server back-end. because of slow execution i changed theses queries to pass-through query, now when i run...

when i wanted to create a macro in my database, Add new action combo box is empty and does not show any action for selecting, i do not know what is problem? i can copy-paste in new action combo box but it is empty for selecting and adding new action in my database. for checking i made a new...

Before splitting my database I was using a macro for importing excel file to my table and it was okey. Now after splitting database when I use that macro from front-end I got error “You cannot record your changes because a value you entered violates the settings defined for this table or list...

I have a query inside that there is a hyperlink that comes from a hyperlink field in the table. now when i open this query in Excel, it shows hyperlink field like below text, 38687901-000-BE-DR-1011-00#\\bb2-1\DCC\Detail-ENG Documents\EQP\TBE\ZP11\38687901-000-BE-DR-1011-00.pdf# please help...

In my query there is a sub query, now when I join tables with inner joint there is no problem according to below code. <code> SELECT tblDocuments.[Owner Document Number], tblTransmittals.POI, tblPurposeofIssue.[Purpose of Issue Description], tblTransmittals.REV...

in my database i have imported several modules like (modAPI,modReportToPDF,ComDlg) from one trusted sample database. when i am working with my database on laptop it works without problem.but when copy it on another computer i got error ("The code in this project must be updated for use on...