Search results

  1. G

    Export Filtered ListBox output to a Excel Sheet

    Hi Currently i have a form Which has three combo box .then i have a search button which runs a query based on the values selected in the three combo boxes and shows the results in a list box below.see the image for the form here. Now i want to add a button called "Export to excel" which will...
  2. G

    VB to calculate count of distinct values

    hi i have attached the sample file in my previous post. I want to store the count values in the table because i am going to generate a report based on the skill , so only
  3. G

    VB to calculate count of distinct values

    hi i currently have a student_Details ms access table with the fields - "ID" and "Skills".and another table called Category with field "category" which stores the distinct skills of the students I have used the following VB code to calculate the distinct skills from the Student_details table...
  4. G

    Import excel sheet data into Ms-access using VBA macros

    I have a excel file with three sheets named "A","B","C". I have four columns: ID,Name_S,Age,City in all the sheets. Now i want these data to be imported into a Ms-access database file. I want three tables with their names same as the Sheet names ie.,A,B,C and also i want their field names as...
Back
Top Bottom