Search:

Type: Posts; User: SeanK

Page 1 of 13 1 2 3 4

Search: Search took 0.18 seconds.

  1. Re: What measures do you have in place at your house to take care of intruders?

    I have never, in my life, lived in an apartment complex that had an armed guard.

    I think if I were being shown around to available apartments and passed armed security I would not, under any...
  2. Thread: Grouping Data

    by SeanK
    Replies
    0
    Views
    858

    Grouping Data

    Lets say I have an Access 2007 database table with two fields called MyNumber and MyText.

    There are seven records as follows:

    1 A
    1 B
    1 C
    2 D
    2 E
    2 F
  3. Thread: printing form

    by SeanK
    Replies
    3
    Views
    566

    Re: printing form

    See the posts by Code_Doc

    http://www.vbforums.com/showthread.php?t=456226
  4. Replies
    7
    Views
    1,592

    Re: Happy birthday wossname!!

    Too late for that I think....Happy Birthday anyway.
  5. Replies
    1
    Views
    733

    Re: Open files with VB6 Application

    Use a small MS Access database and load the file names into a table field.

    Have you code loop through that field and play the files one at a time.
  6. Replies
    5
    Views
    1,208

    Re: Arranged text in Textbox control

    Why any kind of textbox? I'd use a ListView for this.
  7. Replies
    4
    Views
    856

    MsOf07 Access 2007 VBA - Looking For A Better Way

    I have an Access 2007 database application that I’m taking over. In one of the tables there are 13 fields, and I need to run a query to see if any of those fields contains a zero. The typical...
  8. Replies
    4
    Views
    538

    Re: Easy Printer Question...

    It is an easy printer question...you need to change the selected printer to be the default printer otherwise, nothing will print there.

    As a procedural matter add language in your help file or...
  9. Replies
    11
    Views
    5,406

    VS 2010 Re: how to center my form

    I know how to do it but I can't tell you because this is my source i got the solution by my self so i can't give the source i'm sorry again
  10. Replies
    6
    Views
    5,768

    Re: Find All Mondays In A Month

    Thanks to all for the code and the responses. :)
  11. Replies
    6
    Views
    5,768

    [RESOLVED] Find All Mondays In A Month

    How would I determine what the dates are for all Mondays for any given month, for any given year?

    For example: If I put 6/2011 in a textbox, what would I need to do in order for my program to...
  12. Replies
    3
    Views
    619

    Re: Return UNC

    I probably should have posted this in Office Development because I am use VBA, but, regardless, it works great.

    Thanks.
  13. Replies
    3
    Views
    619

    [RESOLVED] Return UNC

    If I have the letter W mapped as a network drive to \\ServerName01\FolderName02 how do I get drive W's UNC.

    In other words, I have a drop down combo with 10 letters in it.

    I click on "W" - I...
  14. Replies
    12
    Views
    1,348

    VS 2005 Re: Is There A Better Way Than This?

    I tried
    ListView1.Font = New Font(ListView1.Font.Name,
    If(ListView1.Font.Size = 8, 12, 8), FontStyle.Regular) and got three errors. Two said “Expression Expected” and one said “End Of...
  15. Replies
    12
    Views
    1,348

    VS 2005 Is There A Better Way Than This?

    I have a listview and I’ve been asked if I could set it so that the font size got bigger when a selection was made. So, I have thisPrivate intToggleFontSize As Integer = 0

    Private Sub...
  16. Replies
    18
    Views
    12,526

    Re: Finding initials from a full name in a text box?

    The )) after .ToUpper generates and "End Of Statement Expected" error. Removing them takes care of the error.

    "Function" is underlined and generates a "Expression Expected" Error. Perhaps n...
  17. VS 2005 Re: Adding Up Numbers In ListView Column

    That is where I was going wrong...I was still using a 1-based loop. :rolleyes: Thanks.I know I can do it that way, but I don't, and I won't.

    I find it far more clear to use variable = variable...
  18. VS 2005 Re: Adding Up Numbers In ListView Column

    I did add the Text property to it originally, but that gave me an error.
  19. VS 2005 [RESOLVED] Adding Up Numbers In ListView Column

    I found this from a Google search and I need the VB.NET equivalent to Martin Liss' code
    Dim lngIndex As Long
    Dim lngTot As Long

    For lngIndex = 1 To lv.ListItems.Count
    lngTot...
  20. Re: Problem With Access Date/Time Fields From VB6

    It is a locked textbox that is populated from a datetime picker selection. I never, ever allow users to actually type in a date.As I indicated, I did try the pound signs, but I encapsulated them...
  21. [RESOLVED] Problem With Access Date/Time Fields From VB6

    I am using Access 2003. I haven't worked with Access as a backend since Access 2.0. Even back then I used Text as the data type for date fields because they are such a pain to work with. Now,...
  22. Replies
    2
    Views
    971

    Re: Reading Mail In Generic Outlook Mailbox

    Thanks westconn1. When I check Tools/EMail Accounts I get this for a server name:

    ServerName.ent.corp.blah.com

    So, I'll use that as my SMTP server name and see what happens.
  23. Replies
    4
    Views
    741

    Send EMail With Generic Id

    I've decided to give SMTP a shot as it seems you can specify a from address using this protocol.

    It requires I give my SMTP Server, and there in lies my current problem.

    In the Outlook...
  24. Replies
    2
    Views
    971

    Re: Reading Mail In Generic Outlook Mailbox

    Ok, I figured out what is causing the type mismatch.

    GetDefaultFolder is looking for a MAPI Folder name, not a mailbox name. When I add olFolderInbox, it works. However, it is reading my...
  25. Replies
    2
    Views
    971

    Reading Mail In Generic Outlook Mailbox

    This works just fine if I want to do stuff with the unread messages in my own mailbox. But, I have a generic mailbox that I'm supposed to write some code against that will detect unread messages,...
  26. Replies
    13
    Views
    1,545

    Re: Trouble Shooting Tips/Assistance Requested

    Brilliant...it blew up on: Set testCON = CreateObject("ADODB.Connection"), and I got the exact same error message.

    So, if I'm reading you correctly, I need to put in a request to get MDAC...
  27. Replies
    13
    Views
    1,545

    Re: Trouble Shooting Tips/Assistance Requested

    I gave myself an idea from my last post.

    I can put an Excel spreadsheet on other machines, so I created one that connects to my SQL Server. My suspicions were/are correct. The error occurs...
  28. Replies
    13
    Views
    1,545

    Re: Trouble Shooting Tips/Assistance Requested

    InstallShield is used as the installation and setup package. It is created by our deployment department. We (the developers) are not permitted to install anything on anyones machine.

    In order...
  29. Replies
    13
    Views
    1,545

    Trouble Shooting Tips/Assistance Requested

    I have an VB6 application, which connects to a SQL Server 2000 database, running on about 75 machines.

    All machines are running XP with Server Pack 3 installed.

    One machine, and only one...
  30. Replies
    15
    Views
    4,433

    MsOf03 Re: Excel VBA - Deleting Blank Lines

    Same error message, but now it highlightes .End
    With objSheet.Range("A7:G" & lngRowCount)
    .AutoFilter
    .AutoFilter Field:=1, Criteria1:="="
    '~~> Get the...
  31. Replies
    15
    Views
    4,433

    MsOf03 Re: Excel VBA - Deleting Blank Lines

    This produced a "Error 9 Subscript Out Of Range" error on the highlighted line at the very end (it did go through all lines. There were 170 and at the time of the error, i = 167) and because of...
  32. Replies
    15
    Views
    4,433

    MsOf03 Re: Excel VBA - Deleting Blank Lines

    Well, I tried it in VB6, and it errors on the highlighted line with "Wrong Number Of Arguments Or Invalide Property Assignment"
    With objSheet.Range("A5:G" & lngRowCount)
    .AutoFilter
    ...
  33. Replies
    15
    Views
    4,433

    MsOf03 Re: Excel VBA - Deleting Blank Lines

    I’m doing this from VB6, so I guess that makes a difference.

    I got this from recording the macro
    Range("A7:G170").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=1,...
  34. Replies
    15
    Views
    4,433

    MsOf03 Re: Excel VBA - Deleting Blank Lines

    I put an autofilter on row 5

    Each cell in the row received a dropdown menu with:

    Sort Ascending
    Sort Descending

    All
    Top 10...
    Custom...
  35. Replies
    15
    Views
    4,433

    MsOf03 Excel VBA - Deleting Blank Lines

    I have a spreadsheet in which I need to delete blank lines when they occur after a load of records has been dumped to it.

    The number of records will be completely dependent on the query run, so...
  36. Replies
    9
    Views
    1,075

    MsOf03 Re: [RESOLVED] Print Selected Sheets

    Works great. Thank you anhn!
  37. Replies
    9
    Views
    1,075

    MsOf03 Re: Print Selected Sheets

    anhn: I'll need to do some pretty extensive testing and get back to you, but #2 looks like it will work for me (Yay!!)
  38. Replies
    9
    Views
    1,075

    MsOf03 Re: Print Selected Sheets

    It does print what I select, however, the page numbering is off.

    As I indicated, I need all tabs selected to have their pages numbered consecutively.

    Each sheet/tab will have multiple pages. ...
  39. Replies
    9
    Views
    1,075

    MsOf03 Re: Print Selected Sheets

    Attached is an example.

    The path to Book1.xls is hardcoded in the "Open" button on the userform so you will want to change that.

    The userform is on the PrintSheetExample.xls

    Thanks...
  40. Replies
    9
    Views
    1,075

    MsOf03 Re: Print Selected Sheets

    No, that wasn't what I was doing, but I tried it, and got the same error. This time my sheet array string was
    Sheets(Array(""Sheet1", "Sheet3", "Sheet4"")).SelectTwo double quotes at the very...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width