Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. merlizbet

    SelStart SelLength issue

    All good info! Thanks much!
  2. merlizbet

    SelStart SelLength issue

    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...
  3. merlizbet

    SelStart SelLength issue

    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...
  4. merlizbet

    "spell dollars" function for WORD

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

    "spell dollars" function for WORD

    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...
  6. merlizbet

    "spell dollars" function for WORD

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

    "spell dollars" function for WORD

    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...
  8. merlizbet

    "spell dollars" function for WORD

    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...
  9. merlizbet

    "spell dollars" function for WORD

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

    "spell dollars" function for WORD

    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...
  11. merlizbet

    "spell dollars" function for WORD

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

    "spell dollars" function for WORD

    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...
  13. merlizbet

    VBA to include BCC in Word mailmerge to email

    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]
  14. merlizbet

    VBA to include BCC in Word mailmerge to email

    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...
  15. merlizbet

    VBA to include BCC in Word mailmerge to email

    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...
  16. merlizbet

    Excel does not quit in Task Manager from VBA

    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...
  17. merlizbet

    Excel does not quit in Task Manager from VBA

    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...
  18. merlizbet

    Excel does not quit in Task Manager from VBA

    >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...
  19. merlizbet

    Excel does not quit in Task Manager from VBA

    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 =...
  20. merlizbet

    Excel does not quit in Task Manager from VBA

    >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...

Part and Inventory Search

Back
Top