Search results

Just had to share this, spent way more time than expected for a simple solution. Started a question, then found the answer mid way. Access code automating Excel where ObjXL is an object that is set to Excel.Application The Excel workbook has FreezePanes on column F other sheets might be G or...

The MSAccess calls a SP that runs a significant amount of code and creates tables. The Tables are the Linked Tables in MS Access. After the tables are refreshed on SQL Server, a MakeTable is run to get the data over to MSAccess quickly. From there the Access vba code uses Excel Object Model...

That worked perfect on a workbook in a macro. Added many rows of Formatting below the last row with data. Will have to try this in other code such as Sorting and Grouping. Thanks for the tip!

Just wondering if anyone knows of a shortcut or shorter solution to this issue? Problem: Using a Template or existing Excel Workbook with headers, all the formatting ready to go. Then use MSAccess code (set ObjXL as Excel.Application) to automate custom data and use CopyFromRecordset to populate...

Search DAAUG Just learned about this today. What is in store for MSAccess? Thought I would share. Join us on March 14th with our guest Michal Bar, Microsoft Access Program Manager at Microsoft! Learn about the future of Access, see demos on new features the Access team has worked on and get...

In the past, my code demonstrated using Excel object code from MS Access for remote automation. The recommendation is to turn off (xlManual) the calculation when dumping big amounts of data into an Excel worksheet then using vba to insert custom Formulas in cells to work with the data...

Sorry to apply so late, have some big deadlines on my side of the Pond.... While this won't directly answer your question, it might provide another way to sort and copy the results to another worksheet. This is only code segment, but it might give some ideas about SpecialCells. It is just a...

Saw this in my email - thought it had some interesting topics. Given the strength of the USD, I wish I wasn't so busy on a contract. Could probably actually afford to go there given the exchange rate. Hope they have a video or other media after the event. Some of the subjects look very...

This is the Sorting and Grouping part of that develops an Excel workbook Budget Forecasting Analysis tool. The end workbook has zero VBA. Basically the ObjXL is a reference to Excel Public ObjXL As Excel.Application The iStartRow is a reference to where the Public DB As DAO.Database Public rs2...

The macro recorder won't replay a Group and Subtotal. It requires a custom macro update with a custom Array. I will try to post that here when I get a break today.

Using MS Access with reference to Excel Set OBJXL as Excel.Application In a reporting system with Access Linked Tables to SQL Server Then using code for custom Sorting and Grouping The result of the Grouping (where Subtotals formula appear) are not bold in the Grouping Rows. I use to use...

Totally agree with how they cancel great shows, and it seems it is to make room for yet another zombie one. Of course that is a gross exaggeration since zombies are gross. Highly suggest looking at the fan base that drives this one. They have a committee of advisors from the set design to the...

Probably... It is a SP run from an Access front-end We are in an environment with combined slow network, sharing an extremely under-resourced virtual server and running large T-SQL queries to return a recordset that is can be reused for several MSAccess Linked Table calls. The Query was running...

Sorry for the late response. A Table Valued Function on SQL Server Stored Procedure runs a lengthy query and repopulates a table. The table is used by Access Lined Tables to create reports or other functions. Before creating the Budget report, run the SP. Private Sub cmdRunReports_Click()...

Crowdfunded episodes on SiFi network with teams of writers who actually understand .... engineering and science. Warning: don't watch the 2nd season just released until watching the first season. The Expanse has the record for the largest budget of any TV series. We can only hope this quality is...

Just a suggestion. Use Early Binding during development, then after the product is completed switch to late binding. This has saved me a lot of brain cells that can be wasted on television later. My present contract involves a lot of SQL Server programming to provide recordsets for financial...

Yes, access 2016 and SQL Server 2015

Any ideas of how to call a Table Based Function from MSAccess on SQLServer when there is an ALTER? In SQL Server - there is a table based function that must be run every time the base table data changes to update a couple of dozen views. These views are connected by Linked Tables to MSAccess...

? objxl.Application.WorksheetFunction.CountA(objxl.Range("L6:L20")) Hard coding the Range works perfectly. Thought the Activecell with a range might work too. Stepping through the code, it actually highlights the exact range to be tested. Problem is, the return is always 1 Really liked the...

SQL Server Linked Table (a view) --> MS Access --> Excel MS Access report generator using Excel with remote automation. Will be using a Recordset to move data (copy from recordset) into an Excel template. Using the recordset, will evaluate 27 columns. On average, about half of them will...