Search:

Type: Posts; User: dmaruca

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    12
    Views
    2,519

    Re: Type Mismatch in SQL Data Query

    I'm not sure which driver/flavor of SQL that you're using to query Excel in your connection string, so I don't know which conversion function to use. I would recommend doing the data conversion in...
  2. Re: Add a filter to all queries in Access database

    Another good way is to make some list tables that hold the values you want and inner join them inside the queries. The best method really depends on where you're calling the queries from, how they're...
  3. Re: No troll. What are the (legitimate) reasons people are still using VB6 ?

    Agreed. My earlier remarks were against the crowd in #2 that you spoke of.
  4. Re: No troll. What are the (legitimate) reasons people are still using VB6 ?

    Seems like there are a lot of people talking about OOP now. I wasn't trying to derail the thread, but it appears the original poster only pointed out that OOP was his beef with VB6, so that's why I...
  5. Re: No troll. What are the (legitimate) reasons people are still using VB6 ?

    The truth of why you post this comes out about which is really just ignorance. Let me guess, do you also use hungarian notation? Do you wear "goto is bad" tshirts to impress your alumni friends?

    I...
  6. Re: Trouble with Vlookup Equivalent function in Access

    There's a problem with your data. The raw data table and the final query that you want to arrive at seem to be grouped up by dates, but there is no date field in your price table. How exactly are...
  7. Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System

    Chances are this is a 64bit component like westconn said. You can verify this by creating a vbs script with one line like:


    Set objPassport = CreateObject("PASSPORT.System")

    Save it as...
  8. Replies
    4
    Views
    1,829

    MsOf10 Re: [RESOLVED] Find macro bottleneck

    Here's a class I've been using over the years. It uses vb's Timer function and keeps track of timers by name. Timers accumulate if called multiple times.

    Usage:

    Sub TimeStuff()
    Dim sw as...
  9. Re: Excel VBA conditional insert of page breaks

    It shouldn't matter. All of the properties I'm using use points instead of inches or centimeters. I did test the code and it worked before posting.

    This is only the line you change to what you...
  10. Re: Excel VBA conditional insert of page breaks

    Hey, you should use row height. It will give you a more accurate measurement. Row height is measured in points which is 72 points her inch height and 12 points per inch width. Then you no longer have...
  11. Re: CreateObject("Word.Application") very slow with Word version 16

    I don't think the problem is early/late binding. Some other possibilities could be slow addins, a problem with the normal template, hardware, or just a faulty office install. I never thought the last...
  12. Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Look at the screenshot in the original post.
  13. Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    Hey Spooman,

    Gold seems to be the color used by 2010. That's the version I'm using and it's gold, also. More controls can be found by clicking "Insert" next to "design mode" and it's the bottom...
  14. Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed

    If this is a vb app that is going to be used by other people than yourself, I don't recommend using the date picker. As you've seen, the installation of the control is not consistent and it will...
  15. Replies
    2
    Views
    1,814

    MsOf10 Re: VBA PropertyBag

    I don't know of any way to do that directly in VB without one. You can find ready made TLB's that could save a lot of work if that's what you want to do at...
  16. Replies
    3
    Views
    919

    Re: [Access} After Update Event

    Eh, ignore my last post. It should be working, but the event isn't firing. I can't mess with it any longer.
  17. Replies
    3
    Views
    919

    Re: [Access} After Update Event

    Edited out
  18. Re: Can't debug after upgrading my office to MsOf16

    This is not a very well put together question.
  19. Re: How do I manipulate data in variant arrays using RtlMoveMemory with VB6/VBA

    Hi DaniCH,

    I do not have an answer specifically to your question and I'm not going to try to dissuade you from your quest. I would like to offer some alternatives, however. Maintaining something...
  20. Re: Excel VBA run-time error 1004 "Application-defined or object-defined error"

    hi keko10.

    In Excel, error code 1004 is one of those ubiquitous errors that Excel gives sometimes that is kind of a catch-all for "we didn't code in a specific error for this scenario." Looking at...
  21. Replies
    9
    Views
    943

    MsOf10 Re: Clearing Duplicate Data

    The code will work assuming your data is always sorted.
  22. Replies
    5
    Views
    812

    MsOf13 Re: Excel Advice 440K rows

    It sounds like you're just wanting to vlookup the values to test for duplicates. If they're all #N/A then they are unique. A lookup on 440k rows with a low hit-rate could take a long time. You could...
  23. Re: Interaction between Excel and Using vba to edit bmp-image in MS Paint

    Any VBA/Paint/Bitmap automation would involve image editing libraries or some kind of klunky sendkeys stuff. Have you tried putting the image in Word and doing a mail merge?

    If you do want to go...
  24. Replies
    1
    Views
    1,486

    Re: Newest Poll - Average Project Times

    Are the results of these polls shared?
  25. Re: [RESOLVED] Copy Visible Rows to Variant Array Without Looping

    The reason you can't do this without creating a new sheet is because SpecialCells(xlCellTypeVisible) will most likely, but not always, return a range with multiple areas. Range.Value will only return...
  26. Replies
    13
    Views
    65,663

    Re: [VBA] Run Application - Capture Output

    I'll try to get to a 64 bit version sometime soon. you have to do more than pointer safe. every pointer has to be a longptr
  27. Replies
    13
    Views
    65,663

    Re: [VBA] Run Application - Capture Output

    Hi guys. Sorry, I did not see the message from November. I just tested in my copy of 2013 and it works fine. What version specifically are you using and what command are you trying to run that gives...
  28. Re: VBA - instantiate multiple ojects using variable name

    OP, it sounds like you want to make a "dictionary" of employee objects. The idea is not to name each variable after employees. The idea is to create an employee object that can be located based on...
  29. Replies
    3
    Views
    1,189

    Re: VBA Error help for MS Access

    Hi pancakes. In my experience when you start getting compile errors on things that you know are not errors, there is either a missing reference (Tools->References) or file corruption.
  30. MsOf07 Re: IE navigate was loaded, but data is not ready. How to make detect readiness?

    ssal, the two properties you check offered by the IE object are Busy and ReadyState. These properties don't give a complete picture of how the page is loading with sites that use scripts to...
  31. MsOf10 Re: [ACCESS] IsNull() function in Access

    Hi techgnome. I wasn't advocating the use of =Null :) Have a great night.
  32. MsOf10 Re: [ACCESS] IsNull() function in Access

    In your example it could also be false. IS NULL is there so you don't use "[Column]=Null". (I'm not trying to quibble)
    ...
  33. MsOf10 Re: [ACCESS] IsNull() function in Access

    Use the IS NULL keywords... IIF([Column] IS NULL, 'It was null', [Column])
  34. Replies
    6
    Views
    1,655

    MsOf10 Re: [TIME-CRITICAL] TCP/IP over VBA

    You can use the example in my signature to read back in success/failure if you go the exe DOS route. I would definitely either use exe or dll instead of ocx since that would mean you would need...
  35. Re: [Outlook] Warning message before sending email to external address.

    I agree seeking a commercial product for this. Titus labs also makes one. I would not put my professional reputation on the line for something like this. This goes beyond the scope of VBA. Who will...
  36. Replies
    13
    Views
    65,663

    Re: [VBA] Run Application - Capture Output

    Hi there. There is no license associated with this code. Do whatever you wish with it.

    I've primarily used this class to do pdf to text conversions and 7zip over the years. I've used it for other...
  37. Replies
    12
    Views
    1,761

    Re: Print tray problems

    Quick glance you are using Select Case Left(ActivePrinter, 11) but the printer names are longer than 11 characters.
  38. Re: MS Word 2010: Increment date in header of microsoft word

    Hi,

    I don't have much to work on, but my first guess would be the header enum could be the wrong one for the type of sections on your document. Try changing wdHeaderFooterPrimary to one of the...
  39. Re: Vba macro code for grouping the data based on 2 hours time...

    You can use a formula to create groupings. I can't open your attachment here at work, but this will work as long as your date data is an actual date (a formatted serial number).

    A formula for...
  40. MsOf07 Re: [Access 2007] VBA procedure for parsing XML database connection

    Hi Smartacus,

    I'm sorry that I don't have time to write a detailed response, but I would recommend using MSXML to parse XML instead of re-rolling your own method. See here for more info:
    ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width