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 strongm 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: *

  • Users: merlizbet
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. merlizbet

    Excel does not quit in Task Manager from VBA

    Hello good VBA folks, I've searched/reviewed this forum and many other pages on the web. I find lots of people who have had the same issue, but every fix I've seen that takes care of someone's problem like this does not seem to work for me. My code does what I need for it to do (make the top...
  5. merlizbet

    PeopleSoft Equation Engine (stem variables and Exists questions)

    Hello PS Experts, [smile] I and several other folks in my office are trying to learn PS Equation Engine. We are the functional folks with really the equivalent Equation Engine experience of having "stayed at a Holiday Inn Express last night". [glasses] Currently, I'm attempting to use a stem...
  6. merlizbet

    error 3188: "Could not update; currently locked by another session on this machine"

    I have a main navigation form that displays several subforms. When I update a field on one of the subforms, I need to then search a particular field on the main form for any records in the main form's source table that referenced the pre-updated value and replace that value with the new value...
  7. merlizbet

    import spreadsheet issue from form button = table locked

    I finally figured out the issue and have come up with a work around, but I'm hoping someone here has a less klugie solution. I normally link to spreadsheets, not import them, but starting with a test spreadhsheet pre-filled by the user, I found some bad data (a period only (.) entered into a...
  8. merlizbet

    Access 2010 crosstab/transpose/pivot data

    I need to crosstab/transpose/pivot some data in a table that has 2 columns. The table looks like this... <pre> ID Song --- ------ 927361283 If I Only Knew What I Was Doing 927361283 This Stuff Is Making Me Crazy 718263510 Hep Me, Hep Me 615243019 A Simple Solution Would...

Part and Inventory Search

Back
Top