Search:

Type: Posts; User: dminder

Page 1 of 13 1 2 3 4

Search: Search took 0.24 seconds.

  1. Replies
    9
    Views
    1,113

    VS 2010 Re: Building a Where Clause

    You should be using parameters for your where clause. Setup an array with 2 elements, the first one is your filter column, the second one your filter value.
    You setup a loop to go through the array...
  2. Replies
    4
    Views
    611

    Re: Data Type Mismatch

    You should actually use parameters in all of your queries.



    MyCommand.Parameters.Add("@ParameterName", OLEDBTYpe).Value = MyValue


    This stops you from having to remember all the syntax and...
  3. Replies
    3
    Views
    1,024

    Re: Moving data from one listbox to another

    Easier than a loop:



    ListBox2.Items.AddRange(ListBox1.Items)


    HTH :wave:

    D
  4. Replies
    12
    Views
    2,290

    VS 2008 Re: Argument Out of Range Exception (ListBox)

    If there are no items at all in your listbox then you will get an out of range exception error. Your code should include:



    If ListBox1.Items.Count > 0 AndAlso ListBox1.SelectedItems.Count > 0...
  5. Re: How to make MDIParent form acts normally in VB.Net?

    What is the first control in your Child Form that has its TabStop set to True? This would be the control with the lowest Tabindex number (that is not a label).

    Second, what else is in your code...
  6. Replies
    3
    Views
    619

    VS 2005 Re: Need help with hospital program

    Ok, where to begin. First - your image did not load. Second, you will have to query the database to find the information you are looking for:



    Dim ds As New DataSet

    Using cmd As New...
  7. Replies
    24
    Views
    14,674

    Re: Display Access table in Datagridview

    This should hopefully help you to understand a little more about the differences and when to use each one. I personally rarely use datareader, only because I often need to filter, sort and redisplay...
  8. Replies
    7
    Views
    1,151

    Re: giving focus to a textbox after exit sub

    Wrap your Code in a Try...Catch Block. Add a Finally statement and then you can use one of the two options below:



    Try
    'Add your code in here
    Catch ex As Exception...
  9. Replies
    4
    Views
    5,066

    VS 2005 Re: Implement document level password protection

    It is absolutely my application, but is also is able to open various file types like XML, txt, XLS/xlsx, ect and I should be able to lock them from users even if they copy them to a datakey, another...
  10. Replies
    4
    Views
    5,066

    VS 2005 Implement document level password protection

    Hello again all. I am trying to figure out a way to implement password protection on documents that a program I am working on creates. They should remain with the document regardless of where it is...
  11. Replies
    1
    Views
    513

    VS 2005 Web Browser question

    I do not think this is your typical web browser question, so here goes....

    I am trying to make a form that has 2 browsers in it. I want them both to be able to login to a site....say for example...
  12. Re: Why do I have to manually setup form events?

    AHA!! got it!! Thank you so much!! You earned your creds today.

    Oh and as for VB, I never stop using it. But looking at the jobs that pay something decent, need to be more "Agile". :p

    D
  13. Re: Why do I have to manually setup form events?

    Yeah i realized i was in the VB forum (old habits die hard) after I hit submit. That is why I put the edit on there.

    I am not sure that I am following you there, where in the properties window do...
  14. [RESOLVED] Why do I have to manually setup form events?

    I am learning c# (finally) and am using VC# 2010 Express. Why do I have to manually declare events for them to trigger?? I have created my own form that I want to use as a Splash screen (see code...
  15. Replies
    5
    Views
    3,180

    VS 2010 Re: Get key name from KeyEventArgs.KeyCode

    You can use a select statement on the keycode to handle whatever keys are being pressed:


    Select Case e.KeyCode
    Case Keys.A To Keys.Z
    Case Keys.Enter
    Case Else
    End Select

    HTH!! ...
  16. Replies
    4
    Views
    681

    Re: Just starting to learn VB... Have a Q

    If you keep your statements simple you could 'technically' do this:


    If Single.TryParse(TextBox1.Text.Trim & " " & ComboBox1.Text.Trim & " " & Textbox2.Text.Trim, 0.0) = True Then
    ...
  17. Re: transferring data from one datatable to another

    What does the debugger show for "ds.Tables(0).Rows(1).Item(0)"? You can try adding a .ToString() at the end of your ds.Tables(0).Rows(1).Item(0) and see if that works.

    The error is the key to the...
  18. Replies
    1
    Views
    837

    VS 2005 Problem Using Process.Start()

    I am working on a project where I need to open microsoft word documents in a form with a panel (the document will be put into a panel). I have been working on this all week and am not having any...
  19. Replies
    7
    Views
    2,345

    VS 2010 Re: Palindrome Help

    Just to correct myself from above, I really botched up my code above. I have created 2 different methods to do this. They are not as involved as some of the other posts, but they are effective for...
  20. Replies
    7
    Views
    2,345

    VS 2010 Re: Palindrome Help

    I am going to guess and say that this is homework. Unless you are specifically told to loop through the string, you can use the following:


    Private Sub test()
    Dim Input As String =...
  21. Re: Selecting a folder path from an initial directory

    There is no specific variable to give you the folder path. You have to get it from the filename itself (which includes the full path):


    Private Sub test()
    Using OpenFileDialog1 As...
  22. Replies
    2
    Views
    6,841

    Developing on a Tablet

    I have been looking into getting a new laptop for development cuz mine is pretty old and needs to be retired. I started looking around and saw a tablet comparison that showed some of these tablets...
  23. Replies
    4
    Views
    5,206

    Re: RecordSet.Fields: Altering the data type

    That statement is so very inaccurate. You are programming in a .Net language and for best results, not to mention more functionality you should be using ADO.Net with DataTables, DataSets,...
  24. VS 2005 Re: Problems assigning date to variable

    If you are seeing the time portion of a date object then you have to have formatted it somewhere along the line....I have put/adjusted your code and have it returning a date in the format of...
  25. Replies
    3
    Views
    833

    VS 2005 Re: refresh open form

    Put the code that is in the Form Load into its own Sub or Function then when the form loads or you want to refresh it, you simply call that sub/Function.

    HTH and Good Luck!! :wave:

    D
  26. Replies
    6
    Views
    1,349

    VS 2010 Re: [RESOLVED] Sales tax class

    Glad to be of help! :bigyello:

    Remember to click on the scales by my name and rate my post!!

    Thanks again and good luck!!

    D
  27. Replies
    24
    Views
    1,622

    VS 2005 Re: Control looping.

    After looking back over the code, I noticed that I REALLY messed up on it. Here is a revised version that works - with checkboxes anyways!!


    Private trigger As Boolean = True

    Private...
  28. Replies
    6
    Views
    1,349

    VS 2010 Re: Sales tax class

    Well we will still have to deal with where the tax amounts are stored. However, I can get you started with adding a class and getting the procedure setup. In your project go up to the top menu...
  29. Re: Too many Excel.exe tasks are opened...

    This will kill EVERY excel process running, even those that you did not start....


    Private Sub KillExcel()
    For Each p As Process In Process.GetProcesses
    If p.ProcessName...
  30. Replies
    6
    Views
    1,349

    VS 2010 Re: Sales tax class

    Well, from my perspective you have one of several options:

    Database - wherever you are storing the data.
    Specialized list collection in project settings.
    xml file or flat file

    I would say...
  31. Re: How to get VB Windows Form application to display SQL PRINT statement...

    What tech is referring to is that you can declare the parameter another way:


    .Parameters.Add(New SqlParameter("@RetMessage", SqlDbType.VarChar, 100, ParameterDirection.Output, False, 0, 0,...
  32. Replies
    24
    Views
    1,622

    VS 2005 Re: Control looping.

    Here is my go at it, I have used this type of loop before and it has worked very well for me (well enough that I include a more enhanced variation of it with my base dll in all projects):


    ...
  33. Re: How to get VB Windows Form application to display SQL PRINT statement...

    tech's probably gonna shake his head at me, but I am going to expand a little on his post....it took me a while to get this concept from both sql and vb side.

    In your Stored Procedure where you...
  34. Replies
    5
    Views
    730

    Re: Class of public const

    I tend to agree with jm, as he is the resident expert. However, if you do NOT want to go that route then instead of using Consts, use Read Only Properties. This would give you as the coder the...
  35. Replies
    10
    Views
    1,128

    Re: Help in proceeding

    I sent you a PM.

    Thanks,

    D
  36. Replies
    6
    Views
    940

    VS 2010 Re: Adding Symbols to Text Howwwwwwwww?

    That is a rather vague statement. If you would, please post the actual code that you have right now and what you are expecting to be the output. That would give us a better idea of what you are...
  37. Replies
    5
    Views
    1,972

    VS 2005 Re: OLEDB parameter Issue

    Ayep, that is what it was. Even after all these years that kind of rookie mistake just messes up my day..... :blush:

    Ahhh well thanks again guys!

    D
  38. Replies
    6
    Views
    940

    VS 2010 Re: Adding Symbols to Text Howwwwwwwww?

    This usually works: Textbox1.Text += "?"

    D
  39. Replies
    5
    Views
    1,972

    VS 2005 Re: OLEDB parameter Issue

    Field type is Date/Time.

    The procedure that generates the query string and calls the execute:


    ''' <summary>Removes specified customer from active status.</summary>
    ''' <param...
  40. Replies
    5
    Views
    1,972

    VS 2005 [RESOLVED] OLEDB parameter Issue

    Hey guys and gals, it has been awhile. I have run into an issue using an OLEDB Parameter and am not sure how or why it is doing it. I have the following property setup in my program:
    '''...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width