Search results

that's true, i never thought what would happen if ou had more than one open. This is the process: 1. user selects from a combo box. 2. user clicks a button 3. clicking button runs some code which runs a macro to export a query to excel based on the combo box result. 4. (this is where i want...

Cheesr for the help, however the file that i want to control is already open in excel, it hasn't been saved yet. How do i state that it is this file i want to control?

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

Hi, Thanks for that, however there are 30+ fields to list. Is it possible to only show the fields that are blank? currently it is bringing back all fields i am checking, which kind of defeats the purpose of checking (i.e. i may as well bring back the whole 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...

Yes it is sort of a pointing system for scoring answers to question, however i have very little knowledge of using cross-tab queries etc. I will have a play around with a cross tab query now, however if someone could give me some advice that would be superb. Thanks

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

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