Search results

  1. P

    VBA to load all the tables with sql server data

    Hi, Below is my requirement 1. I have 5 tables created in Access (T1,T2,T3,T4,T5) 2. I have a button click event for each table which loads the data from SQL server 3. Now i need a single button which does this, instead of having multiple buttons A single button which loads the data from...
  2. P

    VBA to open report based on listbox dropdown and button click

    Hi All, I have a form with a list box, button and reports my requirement is: 1. Select the value form list box drop down 2. Click on button 3. Corresponding report should open based on list drop down selection Ex: When i select 'customers' in list and click on button, it should open customer...
  3. P

    VBA to query the data from sql server and save the recordset in a table/view

    Hi All, I have gone through few threads but nowhere i found the proper solution. Below is my requirement 1. Data is located in SQL server 2. From MS Access , i need to connect to sql server using sql server authentication and then query the tables 3. After that i need to create...
  4. P

    VBA to run compare query and highlight the mismatches in report

    Hi, I have a form which imports the excel spreadsheets as tables and display the mismatches in a data sheet view (Button control in form calls the comparison query) Now my requirement is: 1) To capture the data difference in a report by calling the report from button control in a form...
Top Bottom