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!

  • Congratulations SkipVought 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. MiggyD

    Barcode Inventory Management

    If you feel good about using Excel AND using VBA to (possibly) program in, then I would definitely suggest that you use it. --MiggyD I close my eyes, only for a moment and the moment's gone.
  2. MiggyD

    Business Cases with 5.25 bays

    Glenn9999 - I really understand what you are getting at. I definitely prefer full size tactile keyboards than to have to type on a flat silent laptop--let alone on a smart-phone/-tablet. I prefer a display monitor for my icons instead of swiping every which way just to find a document I need...
  3. MiggyD

    How to read an excel file using VB 6?

    For lngRow = 1 To UBound(vArray, 1) For lngCol = 1 To UBound(vArray, 2) - 1 strTemp = strTemp & vArray(lngRow, lngCol) & vbTab 'change above line to: strTemp = vArray(lngRow, lngCol) 'add code here: YourCombo.value(indexKey)=strTemp 'add code here to setup...
  4. MiggyD

    QB45 - ASCII 31 (downward pointing triangle)

    @ joewillerols, I know its been a while since I've been on ... glad you've figured something out for your dilemma. I hope you continue learning new things AND, hopefully at some point soon, you upgrade your version of QuickBASIC. [wink] It may prove more fruitful than you know. @ mikrom, Ahh...
  5. MiggyD

    Business Cases with 5.25 bays

    Glenn9999, I used "pc cases non-gamer" in duckduckgo and found a few articles. One discussion in Reddit was for "Non gamer-y case". So, you are not the only one that doesn't care for flashy LEDs going throughout your keyboard or a housing unit covered with LED tubes. (Unless you're a secrete...
  6. MiggyD

    QB45 - ASCII 31 (downward pointing triangle)

    Good job mikrom! I've totally forgotten about QB45's assembly link library for low memory stack manipulation. I can honestly say I'd used it only twice in my life. And both of those times were for experimental purposes, not for any rollouts. Back in those days RAM was extremely limited as I'm...
  7. MiggyD

    Problems with Office 2007 on Windows 11

    I'll just throw this out there (but you've probably already done it). I remember there was a "repair" option available through the control panel. Have you already tried it? Found a recent link to MS Support which can possibly guide you. Good Luck. --MiggyD "If a tree falls in the forest and...
  8. MiggyD

    QB45 - ASCII 31 (downward pointing triangle)

    Hi mikrom, Thanks again for reminding me to update QB64Win to v2.0.2. It IS a larger program than it used to be but the enhancements to RPD are kind of worth it, I MUST say. I know the stress of that something being just out of reach...its infuriating. ----- Hi joewillerols, I HIGHLY...
  9. MiggyD

    Access to QLB variables.

    I don't understand your question. When you make your OWN libraries, your SUBjective/FUNCTion modules have to be made with "private local" pass-through variables to process and to return an output. The CALL ABSOLUTE is from QB. Type ABS move your cursor back and press F1 on the keyboard for...
  10. MiggyD

    QB45 - ASCII 31 (downward pointing triangle)

    @mikrom I had QB64win v0.953 and am going to check out this v2.0.2 after all 16,200+ files have extracted. Thanks for the reminder and possible upgrade. [thumbsup] @joewillerols If memory serves correctly characters 0 through 31 were primarily for printer controls...especially for CANNON...
  11. MiggyD

    Need to populate two columns based on content of adjacent two columns.

    Glad that's resolved. You may want to consider getting more memory or turn off any background processes while you continue using your workbook. Good Luck --MiggyD "If a tree falls in the forest and no one is around, does it make a sound?" I finally got the REAL answer!
  12. MiggyD

    Need to populate two columns based on content of adjacent two columns.

    AHH! Therein lies the problem. You are not communicating clearly. Even I have a hard time understanding. I am guessing you mean the content combination of C and D; not ... If you are using your original workbook. You really shouldn't until you understand what is happening, why it works one...
  13. MiggyD

    Excel Form - Compile error in hidden module.

    This one is going to be interesting to watch... they all have Excel 2010 (most likely everybody is using Win7pro? [at least?]) the remote user's AV aren't mentioned (some of those are such sticklers for TCP and Identity issues) did you try this from your house? (better control/access to...
  14. MiggyD

    Need to populate two columns based on content of adjacent two columns.

    As far as I know, you cannot have a Function inside a Sub. Even though a module may iterate itself to completion (or get stuck in an infinite loop and crash). I have never seen it done as in the manner you have posted.... I labeled it raisinmacro. I probably made a mess of it: Sub...
  15. MiggyD

    round Cosine

    Based on your code, I know you are still learning to use QB. You will need to have a " DOUBLE-LONG " variable memory space. PLEASE NOTE: this will eat up some of your 65k memory allocation to QB...use it sparingly or RE-use a common D-Long variable through-out your program AS NEEDED. (yes you...
  16. MiggyD

    Problem: Userform is inserting the same data to all three worksheets.

    Umm, OK??? Glad to have helped?? Although, I'm not sure how. Anyways... Sorry if by "studies" you thought I thought you were a student. That was not the case. I am self-taught in several languages. Currently 'studying' php on my own. Also, I am confused but I thought you might have gone with...
  17. MiggyD

    working with x509 certificates

    Well I don't use COM either. After doing some quick searches it appears you may/would need to use PowerShell instead of vbscript. Maybe these sites can better help you: http://www.example-code.com/vbscript/cert_load_base64.asp...
  18. MiggyD

    Invalid use of null

    Glad you solved it. After pondering the riddle (for many years I might add) I finally got the answer (inadvertently through a movie): "If a tree falls in the forest and no one is around, does it make a sound?"
  19. MiggyD

    Problem: Userform is inserting the same data to all three worksheets.

    Well, you have this ONE (1) cmdOK_Click() for all 3 Sheets. And the way you have it coded is what you are getting.... When you click on OK (see your code above) no matter what sheet it is running on; you told it to GOTO SHEET1 and put this info. After that is done, GOTO SHEET2 and put this...
  20. MiggyD

    UBasic Modulo Function Update

    In case the wiki is gone, I'd thought I'd follow up.... In short MODULO (in UBasic) simply means "REMAINDER" -- and -- the mathematical expression to activate it is by using the percent sign (%). So based on that info, if someone gave you (US) 459 pennies you could use modulo to tell you...

Part and Inventory Search

Back
Top