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 Chriss Miller 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: baltman
  • Content: Threads
  • Order by date
  1. baltman

    Visual Studio 2017 VB COM object Windows 7 compatible?

    I recently installed VS 2017 and went to create a COM object project and was notified the minimum supported OS would be a build of Windows 10. Is that in fact the case, or might it still work with Windows 7? If I develop on a Win 7 box would it just be a matter of what does the compiling? I...
  2. baltman

    Word table paste/pastespecial into cell issue

    Hi all, I am trying to pastespecial an image into a specific cell in a word table. When I use the simple paste it is placed into the correct cell but when I use pastespecial it always goes into the 1st column of the table. I'm in Office 2013 and creating a chart in Excel and then trying to...
  3. baltman

    Precison too large error via Excel/ODBC solution needed

    I am creating excel driven ODBC SQL reports on a Sybase 16 database and some of the numeric fields have precision too high for the Excel ODBC driver. I am not at all concerned with precision loss - I am happy with <15 decimals. Without handling Excel is simple crashing upon the rs.Open cSQL...
  4. baltman

    _screen/menu not responsive to mouse

    Hi guys! I have a problem... The standard menu in a VFP install on a Server 2008 R2 isn't responsive to mouse clicks but responds to Alt+Key shortcuts. Clicking on it seems to be selecting the toolbar instead. An additional symptom is that I cannot move or resize the _screen except through...
  5. baltman

    Quickly navigate/set default to a directory

    Hi everyone! I haven't been around much at all lately and don't use VFP everyday like I used to. I've been using this trick for years and just had to set it up on a new install. Hope someone else out there finds it helpful. Quickly navigate/set default to a directory faq184-7360 Brian
  6. baltman

    Log Scale Axis Label Issue

    I'm trying to make a log scale chart with a min 20, max 120, major/minor units at 10. Got it to look exactly like I want until I add the log scale option, then the min/max goes 10 to 1000 and has one 100 tick. My data is ~30 to 101. Once the log scale is set excel won't let me change the min/max...
  7. baltman

    Reg Key / Jet DLL conflict / Access Stability Question

    My work office set-up has a dll conflict. I have little control over the environment. The software install was DESIGNED to share the same key and need different values/dlls. I need the below reg key vale to point to two different dlls depending on if I want to use a connection string to connect...
  8. baltman

    Extracting data from Excel Pivot Table

    I have an Excel workbook with a pivot table created with an external data source (MDB) that is not available. The data was saved with the sheet. I need to query the data out or export it to a csv. There are several hundred thousand records so the double click doesn't help me. Any suggestions...
  9. baltman

    How to identify points missing from series

    I'd like to identify deleted records from a table. The field I'd like to use is an auto increment. A deleted record would be a hole in the series. Any tips or triks? thanks, Brian
  10. baltman

    Map a network drive on the fly

    I have a third party application that I call and have to pass paramaters to including a path. This particular application chokes on a UNC even though the user's behavior may cause the UNC to be passed. Additionally, there is no garantee that the share is mapped to a drive letter. The following...
  11. baltman

    programmatic access to user status

    Is there a way to programmatically access the current user's active/inactive/disconnected status as seen in the task manager? I would like to be able to quit a particular application if the current user isn't active. Thanks, Brian
  12. baltman

    whitelist Vs. blacklist approach

    Why Antivirus Technology Is Ineffective" advocates a whitelist instead of the current blacklist approach. If it were that easy (profit motives aside) wouldn't it already be the standard? http://www.newsfactor.com/story.xhtml?story_id=113003W94IYA&page=1 Brian
  13. baltman

    IE zone setting for share drive on 2003 TS

    What do I need to do to have a share recognized as part of a trusted site? The (terminal) server has a company defined default security set-up that we need to work around (e.g. users cannot alter IE security options). Typically users are double-clicking or applications are shell executing the...
  14. baltman

    Query Optimization

    Why does the first WHERE clause take so much longer than the sum of the parts? Anything I can do within the WHERE clause to improve the processing time? I can't change the DB. There are also 5 inner joins and 3 outer joins with a few addition filters embedded... e.g. LEFT OUTER JOIN B ON (A.ID...
  15. baltman

    WShell.Popup Timeout Bug?

    Using VFP9 on XP Pro I do not get the expected behavior of a 1 second time out. I get an hourglass mouse cursor until I button click instead. This a VFP bug or is there something strange with my setup? Thanks, Brian WShell = CREATEOBJECT("WScript.Shell") WShell.Popup("My Timeout isn't...
  16. baltman

    Visual Studio Express

    Free, lightweight, easy-to-use, and easy-to-learn tools for the hobbyist, novice, and student developer." http://msdn.microsoft.com/vstudio/express/default.aspx
  17. baltman

    Turnoff File Download Complete Sound

    I'm automatting a bunch of downloads in the background and I'd like to disable the chime that signals the d/l is complete without affecting other media. Any ideas would be appreciated, especially if automatable. Thanks, Brian
  18. baltman

    Creating a service

    Calvin says it's easy, but I can't get this to work. The service doesn't show up in my Administrative Tools -> Services. The registry entry is present and the exe works. I installed srvany. I am testing on an XP Pro box but ultimately want to install on Win2000/2003 servers. Any ideas...
  19. baltman

    pass thru float rounding issue

    I'm connected to a MS SQL Server database via a DSNless connection string and pulling out data using a FoxPro front end. I'm having an issue with float fields. No matter what is stored I only get back 2 decimals. I have a work around of multiplying within the query and dividing back with the...
  20. baltman

    Excel 2000 -&gt; 2003 performance issues.

    If you take a look at the last bullet point in http://support.microsoft.com/default.aspx?scid=kb;en-us;825012 • In some cases, Excel may appear to calculate very slowly compared to Excel 2000 and earlier, particularly when a full recalculation is performed by using Ctrl+Alt+F9 or when the full...

Part and Inventory Search

Back
Top