Recent content by steven.darby

Be brave Tumby you can do it!! (save a copy of your database, then play about till you get it to work --- this is how everyone learns, sooner or later you will discover the power of VBA, then you unlock the secrets of building a database worth putting your name to, I ain't no programming...

Thanks Gemma, done that and it works, thanks. Buy actually I was asking hitechcoach for late bindings method, which doesnt require to set to outlook reference, which means in future when IT install new version of outlook, it will still work, otherwise I have to go back and change the outlook...

Thanks, I had seen some notes on late and early binding but I certainly aint no expert in VBA or automation, generally I take snippets from different places stick them together and hash to do what I want to do, mostly in the end I understand how it works, like my code above (after a few hours!)...

Open Outlook email app. and attach a file using VBA OFFICE07 HI, hoping someone has something relatively simple, or can direct me to the right place, I want to open Outlook email application on click and attach a document (I have the full file path and file extension) To date I've only ever...

You can do this using vba, if I read right then when your main form opens it opens a subform displaying data which you have filtered(?) But now you need to open another form only when double clicked(?) If you got your first form to open using a filter sounds like you just need to code similarly...

I meant to execute the code and set value of 'Microbusiness' based on 3 other control values, that will work whether the controls are bound or not. (And, not necessarily, you can set recordsource and use Dlookup in code if you wanted to and still not need bound fields, all depends on what the...

Ok on your 3 entry fields, whether numbers or boxes add event procedure to After_update to all 3. In the code for all 3 afterupdates put in "Call UpdateMicroBusiness" e.g. Public Sub MEAC_AfterUpdate () Call UpdateMicroBusiness End sub then create the code for the function named...

post the code and I'll take a look, if I can help I will...

What's the error message ? (you said text1 not text5 ??) If you are not geeting an error are you sure you are actually running through the setting focus code? You can check by sticking docmd.beep in just before - just a thought, I often miss code when I'm using lots of If statements and dont...

Try < Docmd.Gotocontrol ("control_name") > instead of me.control_name.setfocus Note that you cannot send the focus to another control if you have a Lost_Focus event procedure also for that control since you give vba then a potential conflict (for e.g. if you tried to send the control...