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!

Register Log in
  • Congratulations IamaSherpa 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: Beginner613
  • Order by date
  1. Beginner613

    Trimp

    Hi All, I want to creat a query (Delete query) which is going to erase empty cells in my table. How should I reffer to empty cells? "" doesnt work. I heard something with Function called Trimp? Can somebody please provide an example or something. Thanks a lot, B
  2. Beginner613

    DoCmd.TransferSpreadsheet

    THANK YOU!!!
  3. Beginner613

    DoCmd.TransferSpreadsheet

    Can u please clearify?
  4. Beginner613

    DoCmd.TransferSpreadsheet

    Hi All! I want to use "DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportSpecification", "FileName", True" and it does work. But what should I add in the code in order to specify TAB in my excel spreadsheet. This excel spreadsheet has 10 different tubs. I want specific one...
  5. Beginner613

    MACRO/CODE

    how? What should me the code?
  6. Beginner613

    MACRO/CODE

    HI ALL, Can somebody please help me. I have 2 excel spreadsheets. I want to create a form which will have a button. By clicking on this button it will take 1st excel sheet and put it in one table, 2nd spreadsheet in another table. And finaly third table would show me records that are similar in...
  7. Beginner613

    Excel File Export in to a table

    Thank you so much! Really helped. But now I have another issue. I am exporting the excel file to one table. But then when I receive another excel file I want to export it to another table...and then compare differences between both of them... I know how to export 1st excel and 2nd as well. But...
  8. Beginner613

    Excel File Export in to a table

    Hi All! I have a file in excel that we are getting on the daily basis. I want to create form in access with the button that when I will be clicking on this button it will export the excel file in to the table. Thank you, B

Part and Inventory Search

Back
Top