Recent content by farhanleos

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

I have fixed it today hardly.. thanks guys but unfortunately you wont get my query. but thanks really appreciate Farhan

and main and most important concern is when I load the search form it will auto filter the combobox and display just those proponent which is related to Login Person , I used multi user security login to access the database and keep tracking and filteration when a user with whose whose...

Minty , Thanks for your reply I will change the names of text & comboboxes before finalizing here below is the Row source of my combobox , this is the list of Proponent column where I have duplication so I put like that I renamed the queryname without space what I want I have big list of...

Sir , How are you its long I did not post , I faced an issue with my database I need your help. 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. 1- Combobox "combo41" (show proponent values...

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

Sir I update the code but having same error & it leads me to DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strFilePath Private Sub Command50_Click() ''''Open C1 Projects Under P&TSD/CPM Report in Pdf''' 'initialize variables Dim strReportName As String Dim strPathUser As String...

sir, you are right i think inplace of my documents only docuemtns but i check my all existing reports which i am poplulating by other command button are the same with my documents and those are working

Sir Arnel, I need your professionalism on below threads , Kindly see Appreciate your teaching and quideline https://www.access-programmers.co.uk/forums/showthread.php?t=296701 https://www.access-programmers.co.uk/forums/showthread.php?t=296710...

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

Sir Arnel, I have worked on it and modified the code to get the required task its working perfect for me Kindly have look and if there you find any correction ? Private Sub Command43_Click() Dim strReportName As String Dim strPathUser As String Dim strFilePath As String 'set variables...

Dear Arnel, its not calling the subject and body text of the email I know why because I haven't put the code in Module , but the reason behind I prefer repeating code to each Command button for different email because I each email will have different Report if its fixed then I could paste once...

Thank you sir Arnel

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

I did it by this way .. on query of report as new last field i put ERAYear: Year([ERA]) , and under crieteria ..Year(Now()) it filter me the current year & For filter notNulldata simply I put isNotNull under ERA Updates as Criteria its working perfectly now ;)