Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. compdrmt

    Server dropping connections

    compdrmt (Programmer) 7 Sep 07 0:12 I have a strange problem which I have been trying to solve for some time. every night within a two hour period logged on user lose all network connections. the internet still works but all shared drives and network resources are not available. If users...
  2. compdrmt

    server dropping logons

    I have a strange problem which I have been trying to solve for some time. every night within a two hour period logged on user lose all network connections. the internet still works but all shared drives and network resources are not available. If users log off and back on the resources are...
  3. compdrmt

    0bject reference error

    here is the code that causes the error I have tried the same thing various ways and always get the same error object reference nt set to instance of object Private conn As New OleDbConnection(sconnstring) Dim adapter As New OleDbDataAdapter Dim cmd As OleDbCommand ssql = "INSERT...
  4. compdrmt

    basic dataset question

    sure this is possible Dim tbl as DataTable = myDataset.Tables("tablename") or Dim tbl as DataTable = myDataset.Tables(tableindex) Dim selectedrows as DataRow() dim groupid groupid = ' code to get id to request tbl.Select( "groupid like %groupid%" ) You can also include code in the...
  5. compdrmt

    Create from from variable

    I will try this. It looks like it might just work Debugging is the process of removing bugs. Programming is the process of putting them in.
  6. compdrmt

    Parameters in SQL-statement

    this is reasonably simple to do. Do check out the SQL forum because excepting minor implementation specific tweaks, SQL is SQL whether against SQL server or Access. This is why you should use it, so that if you change you app to a different database it should work without problems. As to your...
  7. compdrmt

    Create from from variable

    yes the form will exist of course What I am trying to accomplish is ... In a database I have the name of the form which is used for a given record. for example I have a details form for type one input and another detail form for type 2 input etc. In the list box I want to list type one...
  8. compdrmt

    Create from from variable

    I have need to create of more correctly load a form dependent on which item is chosen in a listbox. This can be done easily enough in vb6 using the forms.add method. In VB.net however this method does not exist. Does any one know how to do this in .net or if it even possible...
  9. compdrmt

    Can not open SQL server

    I am using the crystal report viewer that comes with VB enterprise edition and have two questions When i try to open a report I get one of two things depending on how i open it. 1) if i use an action = 1 then I get can not open SQL server 2) if i use prinreport then a widow flashes for half...
  10. compdrmt

    Why cant I step through

    This is currently set to break on all errors shouldn't that do it ? Debugging is the process of removing bugs. Programming is the process of putting them in.
  11. compdrmt

    Why cant I step through

    I used to use Access quite a bit but eventualy got so frustrated with the limitations of the IDE that I switched entirely to VB with access only to hold the data. Now I am working on a project done entirely in Acces and I am trying to keep it that way. The question I have is this I have...
  12. compdrmt

    reqqueryvalueex returns nothing

    I am completly stumped Any one explain why this does not work This function Public Function QueryKey(hKey As Long, subkey As String, keyname As String) As String Dim lhandle As Long Dim lpType As String Dim rc As Long lpType = String(1024, 0) If Not RegOpenKeyEx(hKey...
  13. compdrmt

    Break in VB code

    I normally program in VB with Access backend so i have fallen a little behind in VBA development The problem that drove me nuts was that an event seemed like is was not firing. I finally discovered that it was firing but ignoring all the code due to an error in the code. As mentioned am used...
  14. compdrmt

    mdac_typ ?

    thanks The issue is that we do not know. The application will be distibuted to all kinds of people with all sorts of machines and skill sets. We were hpoing to put it on an FTP site bur users with modems are kinda stuck. It amazes me that a 300 KB exe requires 13 MB worth of support files...
  15. compdrmt

    mdac_typ ?

    I am trying to reduce the size of the package for an application i created. The problem is the setup wants to include and run mdac_typ.exe which is over 7 MB by itself The question then what does htis do I know it has to do with data access which my program uses but can a person get around...
  16. compdrmt

    IDE bug and IDE helper add in questions

    I use vb 6 version 8988 vba retail 6.0.8964 just re-applied SP 5 and still does the same thing. Has always done it throught several install on several machines etc. Very weird ! Debugging is the process of removing bugs. Programming is the process of putting them in
  17. compdrmt

    IDE bug and IDE helper add in questions

    It always happpens everytime I add a property using the class builder add-in without fail Debugging is the process of removing bugs. Programming is the process of putting them in
  18. compdrmt

    IDE bug and IDE helper add in questions

    2 questions 1) Has any one found a fix for the IDE bug involving the class builder utility, specifically that it adds the set keyword in the set method for a property example copied directly from newly created property method in IDE Public Property Get timestamp() As String Set...
  19. compdrmt

    assign to object within object

    I would still like to know however why I can not refer to an item in the collection by the key value sent in to the add method Debugging is the process of removing bugs. Programming is the process of putting them in
  20. compdrmt

    assign to object within object

    thank you rdroske Actually I am creating the only property needed (for this example) in the init function Private Sub Class_Initialize() Set mvarStudents = New tstudents End Sub I actually figured this one out. I was (for some reason I am still not sure) not getting a correct...

Part and Inventory Search

Back
Top