Search results

Hi David, Let me clarify. There are 3 Access back end databases and 3 Front end database. The front end of each database has linked tables to the other 2 database. Thanks, Judy

Hi David, The situation is that there is already an Access database that was developed for this department. There are 3 groups within this department and there are 3 Access databases. The databases need to interact with each other. The person that created these databases made all of the tables...

Hi David, I think you are right, that would be easier to go from the Excel form and connect to Access, thanks for the suggestion! I have discovered another problem though. The excel button to populate the box connects to Access to get data from a table and populates hidden sheets. The macro...

Hi, Thank you so much for responding so quickly. In the excel file, I have a button to load the combo boxes with data. I did notice that every time I open the excel file, I would have to reload the combo boxes because there would be nothing in them. But if you select a value form the drop...

Hi, I am fairly new to using VBA in Access and Excel. I have an Excel form that I am using to collect data as the front end and an Access database to house the data as the back end. In my Access database I want to create a module that will open the excel files and retrieve data from Active X...