I need to create a report of an Access table with a few parameters of what to show and what not to show and have this report show up in Excel format. I need to only show some records based upon a parameter. The information on the Excel sheet will be used to place orders. When new orders are imported into our Access database I would like them to sync to the Excel workbook automatically. While the orders are being placed they will be marked as Shipped in our Access database. I would like orders that are already marked as shipped in our Access database to be removed from the Excel sheet. I am thinking that the best way to do this is to create an odbc connection between an excel sheet and an Access table and then use Visual Basic to sync them together.
In addition to the requirements above the workbook will be viewed by multiple people at the same time who all need to see the changes being made.
I am in a jam and need to have this project completed right away. If you can start on it today and ideally finish it today, that would be best case scenario. Please contact me with any questions.
Thank you for your interest.