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 dencom 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: *

  • Users: m4dd0g
  • Content: Threads
  • Order by date
  1. m4dd0g

    Need Help in vb and access

    OK i've created my database and in my table called "Table1" i've got the entries of all my data which i imported from and excel sheet but now i've got data entries with the same name like this 0000P,LP Gas,9,6.1,8.9 which i need all of those entries add up and put in a table called "Table2"...
  2. m4dd0g

    excell and vb

    What i've done so far is i export my data from an pervasive database to excell but now i need to caculate the sum of all the duplicate entries and export that to excel so that i will only give me the customer number the name and the sum of all the stuff he brought for the specific month.
  3. m4dd0g

    Add duplicate entries together

    Is there a way with a SQL query to add the duplicate entries in two tables together so that the entries that have more then one value only give me one value but all of them added together
  4. m4dd0g

    Working With Two Tables

    Ok what I want to do is I want to export data from two tables into one excel sheet but the tables have the same name and what i want is to export the information from the tables where the customer number is the same it must put the number and name from one table and the cash data from the other...
  5. m4dd0g

    Help with VBA

    OK i'm new to this VBA stuff so what i want to do is I got my excel workbook with data which was imported from a database and i want to create a form with two textboxes and a button which will search my workbook between to dates with i specify in the textboxes and then display that data on the...
  6. m4dd0g

    Invalid Date,Time Or Timestamp

    This is the error i get when i search a pervasive database between to dates need help Invalid Date,Time or Timestamp And here is the code i Used: Private Sub cmdSearch_Click() Dim rsTemp Dim lc Dim k Dim sRecords 'Connect To Database Set objConn = CreateObject("ADODB.Connection")...
  7. m4dd0g

    Pervasive SQL V8

    Just one question does pervasive encrypt the data in a pastel database.
  8. m4dd0g

    Help With ODBC

    Well I need help with some code what I need Is to search a table by date by using two textboxes one for the start date and one for the end date here is the code that I have use so far: Private Sub cmdExcel_Click() 'Excell Object Dim rsTemp Dim lc Dim k Dim sRecords Set objConn =...

Part and Inventory Search

Back
Top