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 Mike Lewis 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. makeshift

    About .net?

    Where do Start...well .NET is a framework that consists of a few things CLR (Common Language Rutime), Class Library, Assemblies, JIT, MSIL and Application Domains to mention a few. The Common Language Rutime allows for managed code execution which is valuable for a number of reason which i want...
  2. makeshift

    Free resources on ADODC?

    Try this Adodc1.Recordset.Close Set Adodc1.Recordset.ActiveConnection = Nothing works for me...Good Luck
  3. makeshift

    Using Excel with databases

    U can do this with automation...Set a reference to Access 9.0 or Access 8.0 object library...then do the following add a command button call command1 Private sub command1_click() Dim a As New Access.Application a.OpenCurrentDatabase "c:\db1.mdb" a.DoCmd.TransferSpreadsheet...
  4. makeshift

    Transfer Data Between Two Table

    Try something along these lines DoCmd.RunSQL "INSERT INTO JT Name VALUES '" & me.Name & "';"
  5. makeshift

    Transfer Data Between Two Table

    Try something along these lines DoCmd.RunSQL "INSERT INTO JT Name VALUES '" & me.Name & "';"
  6. makeshift

    Displaying Records On a Form

    ur better off using an ADO Data Control 6.0 from the components menu (ctrl T) and using that as a DataSource for the data grid. use the following after u have bound the ADO Control to the data grid. Private Sub Command1_Click() sql = "SELECT * FROM tb1 WHERE PartNo = '" & text1...
  7. makeshift

    run time error while accessing compiled dll

    This can happen for a number of reasons...actually anything that causes ur dll to crash will show this error ive found. The only way to get rid of it is to debug ur dll...if u dont know how to do it ill leave a few pointers. - in project properties, select the debugging tab and select (wait...
  8. makeshift

    Closing form - vbModal

    I tried this in a number of ways and was always able to hide Form1 regardless of it being modal or not...anyway try this. 'in the event that opens form2 eg. command1_click on form1 Private Sub Command1_Click() Form1.Hide ' hide form1 first Form2.Show vbModal ' then open the modal form...
  9. makeshift

    To Get File permission in VB

    create a batch file and put the command in it then shell the batch file or set a reference to Microsoft scripting runtime then dimension an object as FileSystemObject and obtain file properties that way

Part and Inventory Search

Back
Top