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 Rhinorhino 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: HobbitK
  • Content: Threads
  • Order by date
  1. HobbitK

    Parameter in SQL for Access ADODB

    Hi everyone ... I am using an ADODB connection in a .BAS module(it accepts a strSQL as its' input) to run a simple select statement on an Access DBase. I use the return to dynamically add Option buttons and name them according to the business names returned. That works great, but when I try to...
  2. HobbitK

    Hot key ?

    Hi Everyone, ms office 2000 premium sr1 - in MS Word & MS Excel, When I press the #8 key, it incerts a new line or goes to the next cell. Looked in macros & there is no recorded macro & no VB script. How do I remove this, so it functions normally again? Thanks, Michael
  3. HobbitK

    Multi-Select DataGrid

    Hi everyone ... I currently have a Datagrid connected to a few fields of a single table(I used a DataEnvironment and DECommand to do that). The DataGrid only shows the "Main" topics. I now need to design a method of retreiving/displaying ALL the info. on the selected items in the...
  4. HobbitK

    Word 2000 address label problem

    Hi everyone ... After years of using the Envelope and Label maker in Word2000 with Windows 98SE, a problem started today. Using Avery 8460 labels. I enter Name Address City then ,(comma) The label screen disappears and returns to a regular Word Doc. screen. I tried deleting the Normal.Dot file...
  5. HobbitK

    Setting Form BorderStyle in code

    Hi everyone ... If I use this code in the form Load,Paint, Initialize,Activate, or GotFocus events Me.BorderStyle = 0 The form actually loads with whatever is set in the properties window during design time. I also have tried using the VBConstants instead of the number. MSDN gives code syntax...
  6. HobbitK

    Win2k from MSDN subscription

    Hi everyone ... Running Win2k professional that I installed from my MSDN subscription. They are slightly different from standard installations. Been having trouble with System File checker not wanting to accept the CD, error saying "not original CD". Tried what MS suggests in the...
  7. HobbitK

    Excel - typing by itsself

    Hi everyone ... I just got a call from a client with a very strange problem. They have a DSL connection to the internet, WInXP and either OfficeXP or Office2000. When they open Excel, cells just begin filling in with Text. It appears to be Internet chatting. I am going to do all Win& Office...
  8. HobbitK

    WINDOWS 2000 PRO ERROR MSG.

    Hi All, From my MSDN subscription, I have installed MS windoes 2000 Porfessional. Now I'm getting an error msg that says "Files that are required for windows to run properly have been replaced by unrecognized versions. To maintain system stability, windows must restore origional versions...
  9. HobbitK

    Loop for time(s) needed

    Hi everyone .. I do not like the DTPicker control time. I would like to use a listbox instead. The project scope calls for 15 min. intervals from 7:00am to 5:00pm. I can not seem to figure out the syntax (or find a function) that would accomplish this. Any suggestions? Michael
  10. HobbitK

    IE VERY slow

    Hi everyone... I am running Win2K advanced Server on a very slow old machine. It all worked great until a few days ago, when I went to someones site that had (appearantly) been hacked !! Following a link landed me on a very bad site !!! Now, IE in this and several other programming sites in...
  11. HobbitK

    WinXP and photoshop7 error

    I upgraded to WIndows XPPro and now when I try to start photoshop 7 it comes up with a small error saying "the handle is invalid". Tried uninsatll/reinstall, Adobe & MS Knowledge bases. Nothing there. Worked fine on Win2k, but on XP it will not even open the app. Any ideas? Michael
  12. HobbitK

    Loop through range

    Hi everyone .. I am lost on how to start this as I am fairly new to VBA, and I know someone out there has my answer. I searched the Forum and FAQ area and did not find much help. Question... I have 5 named Ranges on a spreadsheet that are all different sizes. I need to loop through each cell of...
  13. HobbitK

    WorkSheetFunction Error 1004

    Hi everyone ... Trying to Sum a named Range in VBA and assign that to a variable. Here is the line of code iLastbalance = WorksheetFunction.Sum("LastBalance") iLastBalance is an argument in a Function. When the code runs I get an error box saying "RunTime Error 1004: Unable to...
  14. HobbitK

    Excel - Sum Range in VBA Error ?

    Hi everyone .. in a worksheet to sum a Range the formula in a Cell is simply =Sum(RangeName). This works perfectly, I am trying to do the same thing in VBA and assign that total to a variable. I have an Integer variable dimensioned Dim iFirstRange as Integer then further in code I am trying...
  15. HobbitK

    Select Case w/ Control array

    Hi everyone ... I know as soon as someones answers this I am going to feel foolish, but ... I have about 25 option buttons in a control array and on a command button click, I need to capture which one has a value = true. So, I need a Select case statement to do it and I am lost on how to start...
  16. HobbitK

    Word Template

    Hi everyone ... Just wondering if the typical solution would be to create a template for something like this ... and if not, then what would you use? I need to create several(probably hundreds) of documents that have the similar header and footer info. but the departments will be diferent and...
  17. HobbitK

    Excel - % ... Simple question

    Hi everyone ... I know I should(and probably do) know this, but ... I am simply trying to get the percentage of one number based on another number ... Example ... A1 = 6,000,000 (six million) A2 = 189,000 A3 = percentage of 189k of 6 mill. I keep coming up with 3175% ! And I simply KNOW that is...
  18. HobbitK

    Calendar/scheduler

    Hi everyone ... Looking for suggestions on a calendar/scheduler control like the one in Outlook. I found one that is close, but it appears to have alot of overhead. If no controls are available, suggestions on how you would handle this client request?(considering something like an Access DBase...
  19. HobbitK

    An Excellent Add-in

    This came highly recomended to me from a VB6 instructor.I have just begun using it, and it appears to be everything promised. http://www.mztools.com Anyone else have links to really good/useful add-ins? Michael
  20. HobbitK

    RegSvr32

    I need to register a DLL for a VB add-in I downloaded and cannot get RegSvr32 to run. I went to Run then passed it this line: RegSvr32.exe C:\Program Files\Microsoft Visual Studio\VB98\<DLLName>.dll I get an error that says &quot; LoadLibrary(&quot;C:\Program&quot;) failed - The specified module...

Part and Inventory Search

Back
Top