Search results

  1. F

    Criteria to get records not updated in last last week

    :confused::rolleyes:Gentlemen, I need your help as I have a query , where I have Column which shows Last Updated Date I use the below critereia to show the records which have been updated in last 10 days or week >=(Date()-10) but i am stuck to set the criteria which shows me all records...
  2. F

    Populate & Filter Listbox by Combobox selection with Multi User Access

    Gentlemen, Greetings i am working on a database with multi user access with different security level i created a search form "000-SEARCH PROJECT QUERY" based on query where i have 1- Combobox "combo41" (shows proponent values from the query) 2- Listbox "List50" (Populate the filtered...
  3. F

    Error on Executing Report based on query and with filtered criteria ..

    Greetings , Gentlemen i am using below code on all command buttons to execute the report in pdf format , but i got Error while i did the same with the report which is based on Query and i have filter criteria on query? Please guide if anybody have solution for this ERROR : Runtime Error...
  4. F

    Sub FOrm - CheckBox Dependency

    Hi Gentlemen, Greetings I am working on subform where I have fields List Items; Progress; Date;DataTickedoff(checkbox) Progress field is lookupwizard and I have manually added 3 entries NotCompleted ; Completed ; Not Applicable My plan for this subforms 1- on executing the subform it will...
  5. F

    Issue with Report Filter Property

    Gentlemen, Greetings I faced a issue with report filtering , my report is based on query data and I set one filter property which is not impacting the original query Propery Filter=([ERA Updates]) is not null I also want to add filter on ERA field which is a date field without impacting...
  6. F

    Solved CheckList Database Help Required

    Gentlemen, Greetings i am working on one database where i have to use checklist to count the Progress, before implementing the true data i always practice on any new thing with the raw data once its completed i understand completely and then i implement with the Right fields and data.. as...
  7. F

    Question Send Access Report in pdf attachment by outlook to No of Contacts

    Sir, i am working or reports on my DB i am able to convert reports in pdf format with specific file name and save that file in Document folder Now my concern is to send that pdf report to no of Recepients with Subject and Body of Email i tried from morning but not succeed fully , here is my...
  8. F

    Query Date Criteria to filter Current Year and next 2 years...???? :(

    Gentlemen, Greetings I have a query having a date field I want criteria to show complete current year records and future 2 years records I am stuck in this please any one can help me out ? I tried below criteria but it shows just next 2 years data Between(DateAdd("yyyy",+2,date()))...
Top Bottom