Search results for query: *

  • Users: Troy
  • Order by date
  1. Troy

    Whats wrong with my Add File Routine?

    Let me first start by saying I really do appreciate the time you put into replying to my posts.... all of you. I'm not trying to be stubborn here, maybe it's just inherent to me, Right now it's because I don't know of any alternative to do what I want my app to do. I want the user to be able...
  2. Troy

    Whats wrong with my Add File Routine?

    I had to reply to this statement, because it sounds to me like you don't care to understand why things are the way they are. You seem to just say oh this does what I want and move along. Not everyone feels this way. Forexample let's say I like the way a control works but not enough that I don't...
  3. Troy

    Whats wrong with my Add File Routine?

    Funny, I used .add to begin with then VS 2008 suggested I use .addwithvalue as .add was outdated it said. Ok for one, having a wizard generate your code for you isn't always going to work and get it right in every situation now is it? Also, I lost nothing..... Doing this myself taught me...
  4. Troy

    Question Help with Database class

    Hi, ok for starters The first thing you need to do is change a few lines. To open an access DB with code you you will need to specify it as OLEDB This line: Should be: Imports System.Data.OleDB this line: should be this: Private database_Connection As New OleDbConnection() Next you...
  5. Troy

    Whats wrong with my Add File Routine?

    Fixed it , Works perfectly!!! conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & _ My.Settings.dbPath & "; Persist Security Info=False") cmd = New OleDbCommand("INSERT INTO Contact (LastName1, FirstName1...
  6. Troy

    Operation must used an updatable query..

    If you are using the 64 bit version of Vista you must complile your application as an x86 application to use the x86 Jet Drivers. There are NO Vista x64 bit Jet Drivers.
  7. Troy

    Whats wrong with my Add File Routine?

    The only one I can think of that might be is CurrentState so I changed it to " WHERE [CurrentState] = ?CurrentState" but I still Get the error.
  8. Troy

    changing the database runtime

    Hi this is what I use for it, and The .mhm extension is still an access format mdb I just renamed to associate the database and any created to work by default with my app. You can change .mhm back to .mdb and use it with any access db. Hope it's what you were asking. Private Sub FileOpen()...
  9. Troy

    Whats wrong with my Add File Routine?

    Hey guys it's me again and it tooks some time to understand everything you were feeding me. I'm still a bit fuzzy but now I'm using Parameterized Query's. I'm getting the following error when i attempt to add a new record to my DB. Here is my code: conn = New...
  10. Troy

    Office 2007 Child form style?

    umn The problem is a MDi child doesn't have the same appearance that the children do in Office 2007, See the blue background with the white workarea, and the 3d shadowing? The scrollbars only scroll to what is within the white area. I'm trying to figure out how to create a child form that uses...
  11. Troy

    Office 2007 Child form style?

    I'm already using an mdi Parent. This is what i want my child form to look like. Notice how there is a background and that the document is centered. Scrollbars appear to the right and bottom and effect whatever is displayed inside the white area. The background would be for all MDI Children...
  12. Troy

    Need Help setting the BindingNavigator Position

    Thankyou Very Much!
  13. Troy

    Office 2007 Child form style?

    I'm trying to figure out how to make my child form look like Office 2007. For instance, When you open a word document it has A background that is blue with the Page centered in the background area of the child form. Now this I can do but I want the Shadowed look like Office 2007. I took a...
  14. Troy

    Need Help setting the BindingNavigator Position

    Hey all, I'm having trouble figuring out how to set the position of the Binding Navigator. I'm Displaying a child form and when I hit the edit button I've setup I want my next form, which contains a BindingNavigator bar, to be set to the correct file location of my databas so all of my bound...
  15. Troy

    Question Need Help constructing SQL Query.

    Anyone have any ideas?
  16. Troy

    Question Need Help constructing SQL Query.

    ok now I'm having trouble still trying to implement this. Here's my code: What am I doing wrong? I'm trying to set the compare value to id which is the value I have stored in me.ActiveMDIChild.tag. if the ContactID is 1 for instance I want my SQL to read WHERE ContactID = 1.
  17. Troy

    Question Need Help constructing SQL Query.

    Any help here would be appreciated. I'm sure there is a way to create an SQL Query that will display only the Information in Packages with the same ContactID as in Contact. Anyone?
  18. Troy

    Question Need Help constructing SQL Query.

    I need help contructing an SQL query that allows me to select only Packages from my db that have the same ContactID as whats in Contact. I've been using QueryBuilder and I can get this, but it gives everything not just those with the same ContactID in Contact. As you can see it gives...
  19. Troy

    dynamic crystal report?

    Hi there. I've received alot of help from others on this site so I figure maybe I can help return the favor to some people. I found this information on another VB site. I use this method in my own programs for accessing Pre-created Crystal Report forms. Hopefully this is what you are looking...
  20. Troy

    Webbrowser Search

    lol works like a charm you so rock.....
Back
Top