Search Results - VBForums

Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.62 seconds.

  1. Replies
    2
    Views
    126

    Re: [RESOLVED] IDE Row and Column Position

    Thanks. I had the Standard toolbar showing but I had to Reset it.
  2. Replies
    2
    Views
    126

    [RESOLVED] IDE Row and Column Position

    There used to be a little display someplace at the top of my VB6 IDE that showed my current caret position by row and column. How do I get it back?
  3. Replies
    2
    Views
    155

    Re: Windows Theme not Remembered

    I saw that same article but it talks about doing some things that make me nervous,
  4. Replies
    2
    Views
    155

    Windows Theme not Remembered

    I use Windows XP (yes I'm an old dog) and recently when I've had to reboot, my windows theme is not implemented correctly. What I mean by that is that it looks like this with an ugly black title bar...
  5. Replies
    3
    Views
    179

    Re: [RESOLVED] Add-In OnConnection Problem

    I resolved the problem. I had an incorrect Reference.
  6. Replies
    3
    Views
    179

    Re: Add-In OnConnection Problem

    Sorry about that. Here's the missing module that contains the definition. Just add it to the project. In order to reproduce the error you'll need to compile to produce the dll, register the dll and...
  7. Replies
    3
    Views
    179

    [RESOLVED] Add-In OnConnection Problem

    Some time back I developed an addin called Annotate which helped in the annotation of changes to VB6 code. Everything worked well until I made some changes and now I get a "Type mismatch" error in...
  8. Replies
    25
    Views
    22,172

    Re: [VB6] Picture/Video Viewer

    It's been 3 or 4 years since I last did anything with this and so I'm not sure, but I don't think so. Besides there are probably better utilities out there for doing that.
  9. Re: I need some help with a formula please

    Thanks.
  10. Re: I need some help with a formula please

    You are correct, the test value should be 21 and I while I know that COUNTA is what I want to use, I'm not good with complex formulas and don't know how to add COUNTA to the existing formula.
  11. [RESOLVED] I need some help with a formula please

    The current formula is

    =IF(Topics!$T$2<Topics!$T$3-1,"▼","")

    I need to have an AND test added to the value_if_true portion so that even if T2 < T3 -1 it's only true if the count of non-blank...
  12. Re: Hide or disable a forms scrollbar on a sheet

    Never mind, I had the sheet name wrong :(
  13. [RESOLVED] Hide or disable a forms scrollbar on a sheet

    Is it possible to hide or disable a forms (not ActiveX) scrollbar on an Excel sheet?

    I've tried both of these to no avail.

    Sheets("Blah").ScrollBars("MyScrollbar").Visible = False
    ...
  14. Replies
    21
    Views
    2,034

    MsOf10 Re: [RESOLVED] Display the File|Print Window

    No, I wasn't saying that. It just takes me to the screen he showed in post #6, which, for lack of anything better, is OK.
  15. Replies
    21
    Views
    2,034

    MsOf10 Re: [RESOLVED] Display the File|Print Window

    Thanks. TnTinMN's approach works for 2007.
  16. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Rob, while it works for Excel 2010, neither sendkeys nor your approach works in Excel 2007. Do you know a way to show the printpreview window in that version?
  17. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Thanks Rob, that works!
  18. Thread: MartinLiss

    by MartinLiss
    Replies
    60
    Views
    5,292

    Re: MartinLiss

    I've always been a man of few words.

    Dropping out of thread.
  19. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Yes, thank you I figured out that it was interpreting it as ctrl+shift+p.
  20. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Thank you but that's similar to the code you can get if you record a macro while printing and it's not flexible. The SendKeys code takes me directly to the window and that's what I want to be able to...
  21. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    OK, you learn something new every day, but as I mentioned the code produces an error.
  22. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    End that code produces an Object variable or With block... error
  23. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Sorry, no, it's out-of-the-box Excel 2010.
  24. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    OMG Application.SendKeys "^{P}" doesn't work but Application.SendKeys "^{p}" does!

    I'll leave this open in the hope that there's a non-sendkeys option.
  25. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Unfortunately that gets me this.
    116211
  26. Thread: MartinLiss

    by MartinLiss
    Replies
    60
    Views
    5,292

    Re: MartinLiss

    To quote Mark Twain, "The rumors of my death have been greatly exaggerated", but sometimes I believe them.
  27. Replies
    21
    Views
    2,034

    MsOf10 Re: Display the File|Print Window

    Sendkeys of ctrl+P should work but I haven't been successful yet.
  28. Replies
    21
    Views
    2,034

    MsOf10 [RESOLVED] Display the File|Print Window

    I would like to use VBA to go to what's shown in the picture. Is it possible? I've tried both Application.Dialogs(xlDialogPrint).Show and Application.Dialogs(xlDialogPageSetup).Show but neither one...
  29. Re: Can't get WORD CHECK SPELLING window to be ON TOP always

    Note that this is a VB6 thread.
  30. Replies
    6
    Views
    628

    Re: Access a remote server

    Thanks and as soon as I find out the name of his PC I'll give that a try.
  31. Replies
    6
    Views
    628

    Access a remote server

    I'm working with someone who has given me his server name and I connected to it using VPN. In order to access the files on that server I assume I have to map a network drive. When I map the network...
  32. MsOf10 Re: Simulate database in use by someone else

    I understand the bad practice but after trying with just the one folder being shared and not being able to find it, I shared the whole drive. The complication here (and probably the reason I can't...
  33. MsOf10 Re: Simulate database in use by someone else

    Okay this is embarrassing. Wife wife's and my PC are on the same home network and we both use XP as our OS. What I did on my PC was to select the "share this folder on the network" for the folder...
  34. MsOf10 Re: Simulate database in use by someone else

    I'll try accessing the database from my wife's PC.
  35. MsOf10 Simulate database in use by someone else

    Without getting into locking strategies, I'd like to be able to simulate the situation where someone else has an Access database open and I want to write to it via Excel VBA. My user tells me that...
  36. Re: [RESOLVED] Restricting data in an SQL query

    Thank you both. I had to qualify a couple of the fields as follows and now it works.


    rs.Open "Select distinct [SalesOrders&Vendors].ORDER_NUMBER from [SalesOrders&Vendors] " _
    ...
  37. Re: Restricting data in an SQL query

    Here's what I'm doing but it says I'm missing an operator.

    rs.Open "Select distinct ORDER_NUMBER from [SalesOrders&Vendors] Where INSIDE_SALES_REP = '" & strInsideRep & "'" _
    ...
  38. Re: Restricting data in an SQL query

    How do I incorporate the RepName given that I only want to consider the set of OrderNumbers in Table1 where I have a match for a particular RepName?

    In other words Table1 may have 100,000...
  39. Re: Restricting data in an SQL query

    Yes I guess but I've never done one and don't have any idea if in fact that's the way to go, but throw something at me and I'll give it a try.
  40. [RESOLVED] Restricting data in an SQL query

    I have two tables:

    Table1 has OrderNumber and RepName
    Table2 has OrderNumber and PartNumbers

    Is it possible to create SQL which given the RepName only returns OrderNumbers that exist in both...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.