When I open the Query in the database it shows 11 which is the correct amount, It is just when I try and paste it into Excel through VBA that it pastes a different amount. (9) All I want is the query to paste in exactly as it runs when just ran from the database.
Have to admit I haven't read all 145 pages of jokes on here but this is my favourite - sorry if its been repeated.
A mother was getting onto a bus holding her child, as she climbed aboard the driver looked down at her baby.
"Wow" he exclaimed "That is the ugliest baby I have ever seen!"
The...
Hi, I have another problem with an Access 07 database I am building to write reports in Excel.
I have several queries that I paste into Excel and for some reason one of them is giving me different results when it pastes than when I run the query from the Access Window.
Through Access the...
Hi I have an issue with Access 07 that is driving me crazy.
I have a database that builds a report in Excel but everytime you click the command button to run the report it opens the code in Debug mode as if there is a break at the start of the code (there isn't) no error message comes up and...