Recent content by hrdpgajjar

This is what I want. But I have to learn a lot about this format and then apply in my format. But Thanks Though....

thanks, I will try and give you update Cheers!!

I've tried it but it gives me option to select any one district only. It does not serve my purpose. What I need is to select multiple checkboxes (Districts) at the same time to get data from query. cheers!!

Thank for the prompt reply. But my district numbers are fixed and my idea is to generate a report based on multiple districts selected as per my requirement. So please guide me how can I do this. Thanks

Hi there, I've a table named "clients" which contains following columns, - Client Name - Client City - Client District now I need to create a query which shows all data of specific "District" selected by checkbox. Note that there is no checkbox option selected in table design. And all fields...

Sorry for the late reply, but it worth it. Finally I've learned a lot about applying table/query in row source in combo box and my problem solved finally :). Thanks for the great suggestion.

does it stores unlimited data or i need to create a separate table to store data ?

I have only one table with all details and dealer name is one of the columns in my table. Now how can i've tried to create a separate table for dealer name only but i want to store dealer name in my table too. i am confused how can i do that as i am not a pro in access. Kindly Help me on this...

Sorry for the late reply. But my RowSource type is Value List

Hi there, I've created a form with a list box which contains all my dealer names.. I've set the list box property to locked to list box value only and able to edit list box items manually. Now my dealer list goes very long and after some count i am not able to edit or add more dealers to my...

this works for me, The process of updating data from one table to another follows these broad steps: Create an update query and add both the source and destination tables to the query. Join those tables on the fields that contain the related information. Add the names of your destination...

two tables because i've already develops database with very very large data in table-1 (i.e. TPA Data) and now I am in need of copy + paste another large data with regi. no and details sent date on daily bases which is not possible for me to do it in my main table. So I've created another table...

OK thats what i am looking for. will try to use update query and revert back to you. Thanks

Hi all, I have created a table with the details below, Table Name : TPA Data Column 1 : Registration No column 2 : Regi. date column 3 : details sent date now table-2 details are, Table Name : Client Details Column 1 : Registration No (it will be same as TPA data table) Column 2 : details...

Hi there, I've create two functions to get data of current financial year (1st April to 31st March) as under, 1. Financial year start function, Public Function fnFinancialYearStart(Optional ByVal start_date As Date = 1) As Date Dim x_date As Date If start_date = 1 Then start_date = Date End...