Search results

Hi all, I've got a report I want to export to PDF but not sure how to go about it. I know it's done using DoCmd.OutputTo acOutputReport, "rptNominalRollCC", acFormatPDF, The report itself is based on a query that I've created and whilst the report works I'm struggling to get the loop to...

Hello all, Thank you for taking time out to read this Before I start investigating was wondering if anyone can assist in telling me if it is possible and advise on what route i should take to accomplish my aim. Basically i'm trying to get a Access Report to export to PDF but would like the...

Hi all, thank you for taking time out to read this hope you can help :) I have a module which generates an autonumber based on a table content (Tbl:Numbervalues) and a prefix (prefix held in Tbl: TextValues) the module itself works fine and after every getprefix & getnextnumber it updates...

Hi all, I have a query which is a make table one (code is shown below - sorry for it being so big!!) I want another code now which will export the outputted tables to *.txt, I can do it manually but my issue is say for example invoicenumber max length field in table design view is 10...

Hi All, I'm currently trying to identify an easier way of doing the following task. If I try to explain the current process and where I want to go hopefully somebody will be able to understand me and as a result think of a faster way of doing it. Three parts of the database one form and two...

Hi all, So a bit about me.. being an accountant we're usually known for our excel love but I've since taken a turn to MS Access and found loads of useful features that will help my job be that little bit easier (still using excel as well and linking the two) My current project is with a...