Search results

  1. S

    Join multiple tables and then lookup

    My data is layed out in three tables as follows: I hope someone can understand what I am trying to achieve. Best regards SW
  2. S

    Code to fill data with zeros or spaces

    Hi I've been looking for a VB code that can go through every row in my table and fill the cells with blank spaces or zeros to the maximum field length. It would need to go through every column and row. For example: If I have a field that has a maximum field length of 10 characters and the...
  3. S

    Add table name to column then combine all tables

    Hi I would like to be able to combine several tables which all share the same fields. The only way to ascertain which data relates to which company is by looking at the table name as the last three characters of the table name tell you which company it is dbo_SALFLDGASL would be for company...
  4. S

    Vba code to append table based on dynamic table name

    Hi All, I am trying to combine these two bits of code together so I can basically select the data from one table and transfer this to another table however the table name of the table I am copying to would be based on tblDatabase & the value from the record in the table we're copy from. It...
Back
Top Bottom