Recent content by Pablos

One last thing - how do I close this post?

For anyone interested. I changed the output line as suggested by my knowledgeable friends DoCmd.OutputTo acOutputReport, StrRptNm, acFormatPDF, strPathNm & "BCSP_Summary" & "_" & "CPD" & ".pdf" Also for SND, PPD,BPD & PSD

Thanks pbaldy (had to google who is John Galt !) & Sketchin - FIXED IT :-)

Firstly thanks for the interest in this. The Output to that is visible in the folder has the name BCSP_Summary_CPD and is filtered showing only CPD. So it does create a filtered PDF. Just stops at the first hurdle.. Somehow I need to work out how to get Access to move to the next variable...I am...

Good afternoon fellow Access devotees :-) I've been trying for a while now to get my code going..Feeling bit like my friend to my right..... :banghead: Allow me to explain. I have a Report that has a 'Division' as a Header. A Division can be one of five variables...

Hi PNG Bill, Bob might have pipped you to the post with a solution - I'm mighty grateful to you both for giving your time to put me right . xie xie ni ! (sound like share share knee = thank you ! in Mandarin! Pablos

Bob - your a TOP man ! Thanks, that's done the trick. I'm new to this forum - Do I need to close the thread? More importantly do you need me to give you positive feed back? More than happy to do so! I can now watch the footy with a peaceful mind knowing my code is good. Not bad for a beginner!

Hi PNGBill, I don't quite follow your suggestion. 'Try your code on an unbound text box control' Surely, I need them both bound as they populate my table? My aim is on my Form use unload event take one text box and use it to determine a second text box by a set of rules..I can't quite get it...

Hi Bob, I've tried case without "" on case statements, still greeted with a run-time error, this time says '2448 you can't assign a value to this object. When I go into debug, the expression I have put together is in yellow, it's like the me.txtRoot_name = " whatever in here" is causing the...

Thanks for thread reply PNGBill :-) Form property control is Yes to allow edit. Both text boxes are yes to enabled and no to locked. Am still puzzled. It's got to be something simple - I'm gonna go away and try and recreate something simpler in a smaller access model...wish me luck! Should...

txtRoot_Name is the control name, it is bound to Root Name in my table called Hyperion Codes. I started off with the control name as Root name but learned quickly that in vba it is better not to have spaces so i renamed to txtRoot_Name. Could it be an issue that txtRootname is a combo box...

Hello! As well as learning MS Access I'm also learning Chinese - like to keep the brain matter ticking over. I'd love to find some one on this sight to give me the heads up on VBA programming as I love the power of access and want to learn more! I've got a maths back ground and find...

Thanks for the reply. Both text fields. All the me keywords now dot. Greeted with a run-time error '-2147352567 (800200009) you can't assign a value to this object. Both fields are not locked on form properties. Am I missing something so simple?

Hi 'Access' community, I love MS Access. It's a great tool. I'm self taught in it and use Access 2003. I've been trying to put together a select case statement in a form unload event. I've tried different scenarios of using the Me keyword, puting control names in [] and I can't seem to escape...