Search results

  1. M

    Controlling Excel from Access

    Hi, I use VBA on a button click to run a macro which uses the TransferSpreadsheet process to export a query to excel (and keeps it open). What i want is to then format the excel workbook to how i like it using the VBA still. Is this possible? I am trying to get my head around how to make...
  2. M

    Query to list all blank fields for one record

    Hi, I have a big table which lists all of my customers, and their associated details (address, phone number, etc). I want to produce a report for any particular customer (chosen by combobox on form) which lists the fields which are blank in the following format: XXX Co Ltd Address Line 2...
  3. M

    Returning multiple columns from one table??

    Hi all, i have a table like this: SUPPLIER QUESTIONUMBER ANSWER supp1 1 answer 1 supp1 2 answer 2 supp1 3 answer 3 supp2 1 answer 1 supp2...
  4. M

    Importing Multiple XML Files

    Hi All, I need to import multiple (1000's) of XML files into a database. They are all in one folders however they do not have common column headers, there is a certain number of column headers available and each file will only show that header if the file has any data related to that. Can...
Back
Top Bottom