Recent content by banterista

I've discovered that you have to specify margins as well, in Access 2010, to get a report printing properly. Why the margin defaults aren't set to coincide with the selection of either portrait or landscape, as in earlier versions of Access, is beyond me. Once again no response to my problems on...

I've got two customer systems that I've converted from Access 2003 to Access 2010 and all the landscape reports are now printing in portrait mode. I've tried using vba, and tried changing column settings and margin settings to correct this but to no avail. Any suggestions would be welcome.

Well due to the lack of response I'm using third party software. I'm not impressed.

I've now resolved this by assigning a key to the table. Then filtering out the key in a query which in turn, is used to drive the transfer text command.

I've written an application that involves matching payments against charges. I want to be able to highlight, in different colours, blocks of charges so that it is easy for the user to identify which payments relate to the relevant charges. I've tried using recordset clone to no avail. I need...

Although I've corrected my input file the output is still being produced in random sequence blocks.

Sorry guys I found a glitch in my input file please ignore this thread.

I have an Access 2003 database that I recently converted to 2010 and the automated vba generated emails no longer work because of the above. I know there is a third party product you can buy to overcome this but does anyone know of a way to bypass the Outlook security in access vba 2010. Outlook...

I am using transfer text to create a text file and the output is randomly writing blocks of records out of sequence. Is there something I can do to correct this please? My statement is :- DoCmd.TransferText acExportDelim,,"TASExportTrans", namespath, False