Search results

Yes its opening form nav pane. but when i try to link it to my charts through combo then its prompts me and if i click cancel on this prompt i can see the data in the combobox but charts are giving me this prompt below is the property of chart. Rowsource of combobox from this query

Hello. I create a separate new union query through the above SQL statement and then i use this query to my combo box rowsource .

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

Yes sir it's a public variable. Thank you so much yes i declared but it was deleted by mistake and didn't notice. Thank you for your help :)

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

Form structure is almost the same as this form. The values in combo name is a mixture of numeric and alphabetic values like CW-418-0009 and SE-418-0071 etc... Yes, the values in the ID is access default auto number.

This is the 2471 error i have used the same code line in another form it was working fine but here it gives such an error.

Yes Id is numeric and RDocNo is combo with numeric and laphabet mix values i have tried this one Me!Description = DLookup("[Description]", "qryRFIA", "[ID]=" & Me!rDocNo) but iwas getting Run-time error '2471'

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?

Yes, it is used to show the details of that specific activity and to store the details of that specific activity.

Thank you for the reply yes in Backend only tables in the server and link it through IP address to the front end and copy the front end for every user on their desktop it is not shared. the current number of records is almost 180690 for total in the table what I mention is 50000 for the activity...

Thank you for the reply yes brother every user is using a separate copy of the frond-end and to make sure I copy myself for every user to their desktop. I have tried the technique you suggested "Persistent Access Connection to backend" i follow the steps by making even separate dummy table and...

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

Thank you for your kind help :)

Hello sir can you please check what is missing in this new code i am still learning vba try to solve it but no luck. When i select the daily report date where there is no data its giving me this error. variables are not set in new code.

Thank you so much sir I appreciate your work .

Sir sorry to bother you again sir i need little help see the picture below the data of under review is no appearing on the monthly chart instead its showing rejected but when i see in the excel file its working perfect there i have no clue why its showing like that can you help me from where i...

Thank you crystal i got it and thanks for the book :)

Thank you so much sir i got it the way you have done is awesome i saw in some tutorials they just make pie chart and copy the same chart into access form and it was linked through excel file so in that case if the file is not in the same place it will not work and my DB will be used in different...