Search results for query: *

All good info! Thanks much!

...I was locking the other fields on the form so the user couldn't just continue anyway. It wouldn't let me lock the other fields when I moved the code to BeforeUpdate, but it *would* let me disable the fields and that works just as well. So, I believe I've got it doing what I was hoping for now.

Hey helpful people, I'm trying to highlight the text in a textbox control if the user enters something incorrect. I put this code (and more) in the AfterUpdate event. With Me.txtCheckNum .SetFocus .SelStart = 0 .SelLength = Len(.Text) End...

How 'bout if I attach the template here. Then you can fill in the payor, too. :-D

...Saw that "Calc on Exit" checkbox and thought I give that a try. Not only did that fix the code-calc-display, but when I checked that box for the other fields, their values immediately displayed in the Bookmark REF fields, too. So *everything* works better now! Thanks to all for your help!!

Found it (via more Google searching)! It was in Design Mode and "Start Enforcement" is grayed out if it's in Design Mode.

OK, Tony, I *think* I was up with y'all on everything (including your last post to add another procedure, which I named TranlateAmount), but then when I tried to lock the form, that's not an option. I ran into this same problem yesterday when I was attempting to build this using "content...

I copy/pasted the function into a new WORD VBA module. I renamed the function fSpellNumber. In the Remittance area I have a field for: Check Date: { FORMTEXT } for which I've created a Bookmark named Date. And in the Check area I have: { REF Date } which dynamically displays the date from the...

How do I call the function from a WORD fill-in field?

I'm using "legacy" fill-in fields -- because I know how to make them work. I started out with "content controls" (I guess they're called), but I couldn't get the bookmark bit to dynamically repeat the field. The user will type things like check date, check amount, and payee into the Remittance...

Code is here... https://www.microsoftaccessexpert.com/Microsoft-Access-Code-Number-to-Words.aspx

Hey folks, I'm creating a simple WORD fill-in form for a co-worker to print checks. To help avoid errors, I was going to attempt to add a custom WORD function that would translate the number-formatted dollar amount into the long-hand dollar amount. I've found and am using a function written...

Thanks. I'll see if I can figure out how to work that into the other code I found. If not, I'll be back. [smile]

...itself doesn't provide a method to include CC or BCC. I have found other people's VBA that involves both Word and Outlook, but I haven't found *exactly* this scenario. I'm a functional person who is pretty OK with VBA in Access, but do basically nothing with VBA in the other MS products; so...

...myself, but the email it sent me didn't contain the Word merge document (and it didn't send an original email to any of the addresses in the datasource). If anyone has done this very thing, I would *really* appreciate you sharing your VBA! In the meantime, I will continue web searching...

...too, that I said I tested closing the 2010 ver on my desktop, then opened it in a 2013 ver on a separate laptop (it's on our network, so it is *the* exact file I'm opening in each), and I, also, did not get the same problem. I did, also, see a web post from someone saying they copied their...

strongm, OK. With your last post in mind, I set about searching to see if (Part 1) I could find a way to determine the number of Excel instances running in Windows and then (Part 2) find a way to reduce that number by 1. I have found code for Part 1 here http://tinyurl.com/nwcn5ul. For my...

...for y'all's reviewing). As I say, I've added and removed some things since originally posting it here (based on some things posted in this thread *and* some other web finds) (like the Set Range code I mentioned), but that original code leaves Excel running in my 2010 PC and nothing...

...Cell) ? that I'm not properly "disposing of". Based on the Msgbox output I inserted to tell me what Workbooks are still open (as suggested by yet *another* web article), it would *seem* it is *not* the closing of a Workbook that's the problem as all of those *appear* to be closed. I also...

...yiu have provided us with so far is not doing that I'm pretty sure this code is where the problem is. I've killed all instances of Excel and run *only* this code and this is where Excel starts and doesn't kill the instance. Also, this is the only place I need to open Excel in this app...