Recent content by merlizbet

All good info! Thanks much!

Thanks, Duane. I tried that, but that didn't seem to do it. But I think I may have solved the riddle. Seems that I can't do this in the AfterUpdate event, but rather have to do it in the BeforeUpdate event. I thought I needed it in the AfterUpdate as I didn't think it would know the value...

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

Holy crap! It's working! :-) :-) I must have missed one of you saying I also needed to check the field property box "Calculate on Exit". Via a breakpoint, I could see the code was working to calc the written dollar amount, but it wouldn't display on the form even when I went to print preview...

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]

Thanks, Paul. Yes, I'm clear that Word 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...

I have an Access datasource that I'm merging into a Word document to be emailed. I need to include a BCC in each email. Web searches return a variety of code, but none of it seems to be doing exactly this. I was able to BCC myself, but the email it sent me didn't contain the Word merge...