Recent content by SlimSquirrel

Hi, I have some sample code that I have been working on and cant seem to get right. I simply want to copy a range of Cells from an open excel document into a table in Access and thought the simplest way would be to paste (special) i.e. paste append. This works perfectly when done manually...

I have also included spaces between http: to break the links to allow me to post ;)

Hi, I have sourced two different functions off the internet that both work fine individually. I have tried to put them together and cannot seem to get it to work. There are no errors so I have nothing to go on. I have very little knowledge of VBA so I am hoping that the mistake on my part is...

spikepl, Sorry I should have been more clear, it is not a report I am after but rather a query or table. Concatrelated looks interesting though, I will look into that. Thanks.

I have a couple of tables in a database and following the rules of normalisation have separated the contacts from the companies. I have managed to display the data in many different ways using standard queries but cannot do a simple “transpose” like you can in excel. My tables are set out as...

Hi all, I'm based in the UK and use Access / Excel for fun and work. I seem to spend more and more time here looking at VBA and SQL related stuff and thought it was time I joined. :)