Search results

Hi, I have an Access database and I need to get data from an SQL Server database table using Access VBA. I need to be able to locate specific records and read the data only from certain fields. I don't need to edit or add records in the SQL table, just read it. However, I don't know anything...

Hi, Is there a way to somehow "export" an access VBA module into Excel, and then run it. I have a multiuser database that creates an Excel file in a user's computer and exports data into the spreadsheet. I would then like to change the formating of the spreadsheet (ie add some borders and...

Hi, How do I add/edit borders in an Excel file using Access. I have code that export's data to an Excel file and then formats the contents. Everything works except it gives me an error when i try to create borders around certain cells. I used Excel's macro recorder to get the code for...