Search results

Hi thank you for your response. this is my script Private Sub Create_PDF_Click() Dim myPath As String Dim strReportName As String Dim rs As DAO.Recordset Dim rs1 As DAO.Recordset Set rs = CurrentDb.OpenRecordset("NominalRoll_PDF") Set rs1 = CurrentDb.OpenRecordset("DivCNR") myPath =...

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...

Thank you ever so much :) I've added to your rep for the help!! works perfect.. :)

Thanks Steve. Please see attached - it works but the prompt makes you enter each cost centre (that's the bit trying to elimate) even though the process has improved as i no longer need to do each one and save as print to PDF :) Thank you:D

Thank you ever so much for responding so quickly Sneuberg! That work's perfect in the example but adopting the same script (tweaking it for datafield names and table names) the result throws up a prompt asking me for cost centre. I initially thought it had something to do with multiple rows...

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 I didn't actually think of having a separate field with default value of SHI so i'll do that.. with regards to autonumber are you suggesting that the script provided will be enough to get what I want to work? or is there more to it? (Sorry I am really rubbish at this code stuff :)! but...

Hi Thanks for the post - however i'm still struggling probably mainly due to not fully bein able to write code but able to understand. Is there a link somewhere which i can kinda follow to get the points mentioned above implemented? Thank you

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...