Recent content by paulcrigh

Hi There, I have been reading the Access help manuals on how to build a condition within a macro but cannot seem to get it working. Can anyone help me with the syntax please: All I am trying to do is set a condition which will do a count of the values populated within the "ItemGroupCode"...

FOUND IT - I HAD TO CLICK ON "SHOW ALL ACTIONS" HA HA! Paul

Hi Boblarson - I was hoping to use RunApp but it isnt one of the Action items in the drop down list......now forgive me If I am being stupid but I am not a great user of Access - is this normally not available within Access 2007 as that is the version I am using?

Hi Guys, This surely cant be as difficult as I am finding it :) I have a batch file that works perfectly, which FTP's files from my local machine to one of my servers. All I want to do is have a step in my Microsoft Access Macro which runs this batch file Is there a way of doing this...

Hi All, I have created multiple queries which is now pulling the data I want. My question is a simple one - Is there a better way of automating the execution of the queries and exporting the results to CSV files other than wrapping the queries up in a macro, exporting them to text files and...

Apologies Brian - You did indeed give me the where clause. Thank you very much for your help Paul

Hi Brian, Thanks ever so much for the pointer. To be totally honest because I was going into it blind and only knowing SQL and minimal Access querying I used everything including Datediff, IIF statements, CASe statements but not once did i try the DateSerial so thanks for the pointer...

Hi All, As I am suggesting in my title, I am trying to export from a single table only the current and previous months sales transactions based upon a date field dd/mm/yyyy. Exporting only current and previous months is straight forward, however if like this month we are in period 1, the...