Search results

Hi @theDBguy I even tried this from one of your post but it doesn't work for me. Feb 12 2010, 07:07 PM Post#3 UA Moderator Posts: 78,509 Joined: 19-June 07 From: SunnySandyEggo Hi, Welcome to Utter Access! You can nest two DLookup() statements. For example: DLookup("TextField"...

HI All, I have been successful in copying the data from my existing main form and create a new record but when I am trying to do the same for my sub form, it doesn't work? I am using D-Lookup to copy and create a new record on click here's the code that worked for my main form Private Sub...

Hi @MajP You are a Life Saver!!!!!!!!!!!!!!!! Thank you so much i wish i could connect with you on any another other social media. Thanks once again!!

Hi @MajP Thank You so much. ill keep your information in mind, when i create a new database. 1 last question my searchme textbox doesnt work. i did put this code below on click event Private Sub searchme_Click() Dim sFind, sField, sFilter As String searchme.SetFocus sFind =...

Hi @MajP there is one more thing that i just noticed. when in my date search form, if i put my date From and Date To then i am able to create a report but when i use my third filter which is category i.e complete or in-complete then it works fine on my form but when i hit report it force...

Hi @MajP Thank You so much for making changes to my code and helping me out, i just cant thank you enough. I still have 1 issue that when i click on report it only shows me completed task and doesnt show me in-complete task. is there a work-around for that ? Thank You once again I really...

it allows to download only 1 template per day and its not allowing me to download the template that i actually need.

Hi @June7 , i tried this to display records based on filter on my report but it displays only first record from the database. DoCmd.OpenReport "DemoReportSubform", acViewPreview, , "ID = " & ID. Can you tell me whats wrong ? i want to display all the records based on my search criteria from...

Can Someone Please help and guide me on what should i do to create my report ? I need to complete this by day end or else my manager will eat my head by asking me trillion questions on why its not done. Please help me

I tried using this but output still stays the same. Thank You

Hithere, Thank You so much for your prompt reply. I have used vba only to display my records on form. but frankly i am new to ms access and i am using it because i am asked to do so or else i would prefer something else. I dont know how to create report using Vba? I have my vba code to...

Hi there, Thank You for your prompt response. My name is Akash By null i mean i want to show fields as per my category. my category consist of complete and in-complete task. i am using parameterized query in which input for date search is through textboxes. textboxes are dateFrom and DateTo...

In my tasksearchformbycombobox i have kept search by date to and from and search by task category and %complete. all the functionalities are working fine in my form but when i search by date it only shows me complete task and it doesnt show me incomplete task when i try to generate report using...

In my tasksearchformbycombobox i have kept search by date to and from and search by task category and %complete. all the functionalities are working fine in my form but when i search by date it only shows me complete task and it doesnt show me incomplete task when i try to generate report...

Hi All, I am creating my log database and in that i want to perform date search for my task. my date search functionality works fine, but i want to be able to display my complete and in-complete task for particular search please see the attached copy of my database and let me know where am i...