Search results

  1. J

    Connect two tables based on exact match

    Hello, I have the following problem: 2 tables that the input are from forms: Table A with the following Fields : Transport Number And Pallet_ID (Generated Automatically). The user only have to place the transport number and form will generate a pallet ID (Form 1); Table B: User have to...
  2. J

    Import tables from multiple different sources

    How I can never thought this.. The simple ideas are always the best! Thank you!
  3. J

    Import tables from multiple different sources

    Hi. The destination table is empty and the idea is to add new records, perform some delete queries and then append to a master table.
  4. J

    Import tables from multiple different sources

    Hello. I'm facing an issue that I don't know how to overcome. I have 5 different access with a table (called "store") that have the same structure than the destination table ("allstores") in my current database. I want to import the entries of these 5 tables (and perform some queries between...
  5. J

    remove last 3 digits from a number

    No, and it worked! I did a lot of testing and it was a single solution. Thank you!
  6. J

    remove last 3 digits from a number

    Hello. I have an excel file that have a field in a number format. The entries are like "703007082618934000". I have a local table that is my destination table and this field has data type "number", field size "double" and format "0". The problem is that I need to remove the last 3 zeros...
  7. J

    Import files sequentially

    That would be the best approach but unfortunately that's impossible. There are excel files generated by a client which I can't control.
  8. J

    Import files sequentially

    I can't control that. I'm importing the excel spreadsheets into a access database in order to work the data.
  9. J

    Import files sequentially

    Because orders change status where are picked, billed and/or shipped. The same order can be in two different excel files because it was a status update. I created a query to delete the old records (based on order number) and add the ones present in the new excel file.
  10. J

    Import files sequentially

    The date in file's name correspond to the extraction date from OMS.
  11. J

    Import files sequentially

    Hello. I have a bunch of files that I need to import sequentially. The files are generated by an order management system, and the format is like this: store_YYYYMMDDHH. I can't use this date because the number of characters are not static: store_20209111- this can be the file of 01/09/2020 at...
  12. J

    Hello World

    Hello, my name is Joao and I'm starting in Access (vba and macros). Thank you for your forum and hope to help me out!
Top Bottom