Search results

Hi, I require multiple descriptions to print on a report and that or not limited is there any way to achieve this task from one text box to enter all descriptions in one text box line by line and it will print on the report with borders each line separately? instead, I create multiple textboxes...

Hi All, I have a login form with a username and password and then after that, there is one combo box to select the project which will give the user access to that project only and restrict the users not login to other projects and to all my forms project combo box is disabled I am using this...

I have modern charts which is working fine on MS office full version users. But when open in access runtime 2013 the charts shows blank and when i try to select the date from the Combobox for charts it shows below error on after update event to chart requery. Private Sub cmbDate_AfterUpdate()...

I have one form named Charts_Dashboard there i have the textbox name txtUnder_Review so in my textbox Control Source I was summing values from one of the query names qryDateRange with the following expression =DSum("[Under Review]","qryDateRange") It works fine. But now i have one parent form...

Hi, I have linked Access frontend to SQL server backend through ODBC DSN file my table is having primary key and I am able to update record directly into the table without any issue but when I am trying to update in VBA I am getting below message. Runtime error 3157: ODBC Update on a linked...

Hi, I am migrating my Access DB to SQL server and i am very new to SQL server I was calculating one of my field in access with the below expression but I don't know how and where this can be done in SQL my calculated field expression is below. [Primary_Attribute] & "-" & [Project] & "-" &...

I have concatenated the data from 2 tables through the union query below to get my dates on Combobox for my modern charts. SELECT Format([Date_Report],"mmmm yyyy") AS Month FROM tblNcr_Sor UNION SELECT format([Date_Report],"mmmm yyyy")AS Month FROM tblWir_Itp; But when i use this query on my...

Hello, I need help I am not much familiar with Access I am trying to learn. I have created one DB from my idea I know it will not be more efficient but I need help from you guys. I have to store some records from one form but there is one column in my table is called Type and it's having...

I am trying to store values from textbox to tables first validate the empty textbox and then store the text through button but the button is not responding kindly check my code where I am wrong. Private Sub btnSave_Click() On Error GoTo Error Validation If valValue <> 1 Then Exit Sub...

I am trying to Dlookup and getting the following error Run-time error '3464' - Data type mismatch in criteria expression Me.Description = DLookup("[Description]", "qryRFIA", "[ID]='" & Me.rDocNo & "'") can someone tell me what is the issue in the above line?

Hello I need suggestions i am facing a database slowness issues due to high numbers of records in a single table. I have one combo box from where I have to select different activities but there are two activities one is Stormwater and the other is Sewer each activity is having more than 50,000...

I want to show the pie chart on the form like below image when i will select month from dropdown data for that month should show on pie chart and same for daily report when i select the date. I have status column in the table which having values like UR, A, B, C, D and i want to show on chart...

Hello guys, I am very new to access and learning i need help to yes/no create check boxes as follows i will select item from dropdown list and then for that item i will check yes or no on the form and it will automatically checked on report i need suggestions do i need to design extra tables...

Hi everyone I am new here, and i want to learn access database. I hope i will learn a lot with all of you guys Thank you 😊