Search results

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

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

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

Hi, I have two tables, 1. Customer data 2. Supply table Now Customer data table has all my customer details, and Supply table has all material supplied details. Both table has only one filed in common is Registration No (its not primary key). Now I want to create a query to know how many...

HI all, I have a query designed on "Search Button" Click event as under, Private Sub btnsearch_Click() Dim SQL As String SQL = "SELECT DataBase.ID, DataBase.[Regi No], DataBase.[Farmer Name], Database.[MIS System], Database.[Area (Ha)]" _ & " FROM [DataBase] " _ & " WHERE...

Hi all, I need to get report of material sent by current week with a query. I am able to get report of current month by following funtion, Format([Material Sent Date], "yyyymm") - by this function I am able to get current month data and, Format([Material Sent Date], date()) - by this function...

Hi all, I've a material supplied entry form (and a table with same name also) which has two text boxes i.e Registration number and client name. Another table is "Data Table" where some other details about the client is saved (like address, pin code etc.). - Now I have created a search query...

Hi all, I need to get report of material sent by current week with a query. I am able to get report of current month by following funtion, Format([Material Sent Date], "yyyymm") - by this function I am able to get current month data and, Format([Material Sent Date], date()) - by this function...

Hi all, I've created my company data base on Access. Where there are two fields under customer table. 1. Village 2. Taluka I've put two combobox in my data entry form. 1. Villagecombo and 2. Talukacombo and put property settings to "Limit to list" and "Allow list edit on" but after some...

Hi I've created a data filter form in my access program. I have put 5 check boxes in the form which named as district (i.e. BK, SK, ARV, GN & NMD) now I've bound value to the check box as under, (note my first checkbox name is "Check0" and added code to after update event) Private Sub...

Hi, I've a table named inward & a column named inward number Now, For each time I enter inward number manually. So I want to know what was the last inward number I've entered in a Separate text box to avoid duplicate entry. - I've tried "DLookup" & DLast query functions but no luck...

Hi all, I have a Courier Register table which has following columns 1. Inward ID 2. Inward Date 2.Applications 3.Other Documents Every day I received multiple applications (i.e. 10 per day) and 5 other documents for a one Inward ID. Inward ID must be only one for a day as we are mentioning the...

Hi, We've inward/outward register in excel sheet at my office. I've to convert it to access form. But the problem is, 1. I've set primary key as auto number 2. Multiple entries done under same number during day. So how do i restrict or allow multiple users to do entry in a single primary...

Hi all, I've created a form for data entry. I've to do the following, If a Regi_No text box value is null then, automatically disable all other textboxes in form. I've implemented the code under after update as under, If IsNull(Me.Regi_No) Then Me.Village.Enabled = False Else...

Hi, i am new here...