All,
I am not sure where to actually put this question so if I am in the wrong forum I apologize. I am new to VB.NET and Access (still taking classes) so bear with me. Long story short I am trying to make my life easier at work. We have an Access database and an Excel spreadsheet that are not linked. What I am trying to do (based on your recommendation) is to either build a VB.NET app or link the files together. There is a master list of vendors in Access with all their information from name to inspection dates. This list is constantly updated, but not linked to Excel. The Excel spreadsheets 1 for each town have the vendor name, main phone # and alternate # in one field (row, column) even though they are separate columns in Access DB, and then there are 8 other columns with headings that are blank. These need to be hand written if a vendor is called as some of our computers don't have Inter/Intra net access for security. So each time a vendor is removed, I have to go into Access and click the field saying they are "offline", and delete them from the current database as well. Then I have to go in and delete the row in the Excel file as well. Is it easier for me to create a simple VB.NET program to accomplish this? Can I link the Access database and Excel template? Or can I create a custom report with Access to show this information? It has to be landscape page format due to the columns. Any help would be greatly appreciated (and yes I am doing this for my own sanity not because I was asked!)
I am not sure where to actually put this question so if I am in the wrong forum I apologize. I am new to VB.NET and Access (still taking classes) so bear with me. Long story short I am trying to make my life easier at work. We have an Access database and an Excel spreadsheet that are not linked. What I am trying to do (based on your recommendation) is to either build a VB.NET app or link the files together. There is a master list of vendors in Access with all their information from name to inspection dates. This list is constantly updated, but not linked to Excel. The Excel spreadsheets 1 for each town have the vendor name, main phone # and alternate # in one field (row, column) even though they are separate columns in Access DB, and then there are 8 other columns with headings that are blank. These need to be hand written if a vendor is called as some of our computers don't have Inter/Intra net access for security. So each time a vendor is removed, I have to go into Access and click the field saying they are "offline", and delete them from the current database as well. Then I have to go in and delete the row in the Excel file as well. Is it easier for me to create a simple VB.NET program to accomplish this? Can I link the Access database and Excel template? Or can I create a custom report with Access to show this information? It has to be landscape page format due to the columns. Any help would be greatly appreciated (and yes I am doing this for my own sanity not because I was asked!)
