Search results

  1. M

    Generate Report based on Drop-down Selection

    Dear Experts, Can someone please guide me how to generate the report based on the selection from the drop-down. For illustration purpose, I have added the sample database: So I have data that lists down the process names for multiple countries, and I want to generate a report based on the...
  2. M

    Error in converting a report to excel

    Dear expert, When I click on the generated reported and wanted to convert it into excel, I am getting an error. Please see screenshot Appreciate your guidance
  3. M

    Selecting a Record once system date is matched

    Dear Experts, I am here once again to seek your support. I have a database that has a list of processes for my organisations. Each process should be reviewed after 3 years. Here are the fields: Process Name (Type - Text) Last Review Date (Type - Date) Next Review Date (Type - Date) Process...
  4. M

    Solved Locking Certain fields

    Dear All, Appreciate your expert guidance please, probably it is very simple but I am making a silly mistake. I have 3 dates on a form (Last Review Date, Next Review Date, and Start Review Date). Last Review Date let's assume today (i.e. 18/08/2022) Next Review Date is "Last Review Date" + 3...
  5. M

    Database locking issue

    Dear All, I have a database which I have divided into front end for multiple users and backend (I.e database) on a shared server. This shared server is managed by IT team and the folder where I have database we have read and write permissions. we are around 10 users of this shared database...
  6. M

    MS Access Application Error after Accde File

    Dear Expert friends, i have developed one application for my friend using ms access 2010 and on windows 7 Professional platform. When i sent it to my friend he couldn't open it due to the following error (see attachment also) "The database cannot be opened because the VBA project contained in...
  7. M

    Query Setup / Report

    Dear All, i have a query which is getting generated (byBusno) and i have a form (ByBusNo) where there is a drop-down and showing bus number based on the query. i dont know why in drop down duplicate numbers are appearing plus when the report (Routeinfo-busno) is generated it is not getting...
  8. M

    Package

    Dear Expert friends, i am working on a database and would like to give this to someone in executable format, i want to know how to make such an executable file. Also what if the user will not have ms access installed on PC. Note: this database will be utilised by multiple users, i am planning...
  9. M

    Color Coding in VBA

    dear friends - if i want to change the color of a text box to light grey based on when someone click save let's say .. how do we write the color combination in vba code
  10. M

    Date Difference

    how to check in ms access vba whether a date is between 2 dates
  11. M

    Support Required

    Dear Friends, I have one table where i have multiple expiry fields, i would like to see the records which will be expiring in coming one month. So for example, in one record i have all these different dates if one of the date is even falling in the criteria (i.e. expiring in one month) the...
  12. M

    Expiry Date

    Dear Expert friends, i would like to ask one question, I have multiple dates in one table and i would like to check if one of the date is going to expire in a month then only the query will show the result. Can someone please advise how to do that.
  13. M

    URGENT Support Required

    I am trying to filter one report using a combo box on form, however, the report is showing as blank can someone please help urgently i am attaching database also. please let me know what mistake i am doing i have seen videos uploaded for the same with them it's working, i dont know i am doing...
  14. M

    Date Criteria in Queries

    Dear All, I have a date in the table which is a future date i.e. "Next_Review_Date", this table contains several records. What I would like to show is that only the records which are due in upcoming 2 months. For example: an item is due for review on 28-August-2017, it should appear in the...
  15. M

    Future Date Validation

    Dear All, I have the below code on a field that contains a date, I don't want user to enter a future date in the field. But unfortunately, it's not working, not sure the reason. I tried the same on lost focus event also. appreciate your advice. Private Sub...
  16. M

    Question Send Report through Email

    Dear All, First of all, many thanks to the expert users of this forum those who always helped me to develop access application for my department. Part of continuous improvement :), I need your support again and below is my question I have a query / report which will show the record...
  17. M

    End of Statement Error

    Dear All, I have a form which has certain drop-down, based on the value in drop-down I am concatenating them to a new field. the below is the code but it is giving me an error on serial "Expected : End of statement" Me.Ref_No.Value = Cntry & "/" & Ctgry & "/" & Lng & "/" serial...
  18. M

    Append Query

    How to add new record only using append query?
  19. M

    Charts

    Dear Expert Friends, I am done with my application, and my management would like to have charts also which I am yet unable to do since I have so much filtering such as year-wise, request type, SLA met or Not Met. I have a query which extract the information by taking year as an input...
  20. M

    Question Data Label in Pivot Chart View (Queries)

    I have a query in my database, based on that I made Pivot table and then Pivot Chart View. I have added data labels but once I close and reopen query or filter based on page field labels are disappeared.
Top Bottom