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...
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...
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...
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...
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, 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...
Remember, 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...
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...
>Is the code you have presented here the exact code you are actually running?
Yes. The code at the top is what I was actually running. I copy/pasted it directly from my app to here (just with some color coding added here for y'all's reviewing). As I say, I've added and removed some things...
Andrzejek,
Using the step-through method, I can see that Excel opens in the provided code here:
Set xlApp = CreateObject("Excel.Application")
If I then use a GOTO immediately after xlApp.Visible = True to jump all the Workbook code and go directly to:
xlApp.Quit
Set xlApp =...
>The fact that Excel starts up when you start your Access app suggests that that your app is grabbing an unexpected reference to Excel.
Excel doesn't start until it hits the RunCode command for this particular function in my autoexec macro.
>The code yiu have provided us with so far is not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.