Search results

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()...

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...

The advertisement on the site are AZURE It claims one can use "any language" and then list the typical java, php, and the rest. Of course, the one language that isn't included in "any" is VBA. :eek:

Any suggestions on how to build a Quality Assurance Query that could identify small changes between three joined fields that don't exactly match? A large set of database downloads from Oracle across the nation comes in as multiple Excel files. The first one (or two) can be 1 M rows in Excel...

Validated: Changed the two columns in Excel data type from General to Text. That prevented the conversion error. Objxl.ActiveSheet.AutoFilterMode = "False" Objxl.Columns("L:M").Select Objxl.Selection.NumberFormat = "@" Objxl.ActiveWorkbook.Save DoCmd.TransferSpreadsheet _ acImport...

Guess one could have looked a little longer before posting? Found this on MSDN: My Comment: Of course, adding data to the process is not the best solution. Since the error isn't actually hurting anything, maybe a routine to delete all tables with the name like import errors? Still...

Can anyone suggest any ideas as to why this would be causing errors? For a few months, a copy of a Spreadsheet named ProjectSummary has been transferred to a local Access table for use in query operations. Recently it was noticed that an ProjectSummaryS_ImportErrors table began to appear. This...

B.T.W. I did notice that I get 1 single advertisement per page now, as a Gold Member. Did I miss a renewal? would be glad to renew if only to provide a Thank You via tax deductible membership. Disclaimer: I recently invested heavily in Silver, not Gold mining stocks when Silver was under USD...

On win 10 - IE - never noticed any problems - have yet to attempt upload. If it makes any difference, Denver is a Mile High - that implies our OS are not Metric. Thanks for all you do Jon!

WOW! Testing two reporting systems. One creates a workbook with 8 tabs (8 views) x 9 Organizations (later around 30 orgs). The DBSnapshot increased its time about 12%. Given the network and shared SQL Server (virtual machine) it isn't too uncommon to see 15% variance through the day. On...

I will try the snapshot today. In a previous post (couple of years ago) the snapshot was found to be slower despite all we learned in the previous years. However that was SQL Server 2008 and Office 2010. Since this site has the latest and greatest (but a slow network), it is a great...

First workday after New Year's Day 2017, guess nobody wanted (or dared to) school the old man? Or... maybe it was too much celebration? LOL Here is the answer NOT: Set rs = DB.OpenRecordset(TableName, dbOpenDynaset, dbReadOnly, dbOptimistic) <---- DONT USE, returns an empty recordset Was...

Pretty simple really. Some code opens up an Excel Template. Using a start location, it copyfromrecordset to populate the Excel document. The data is a Linked SQL Server table. Why is one view so much slower (100 times slower) than the others. general process: Open a template, populate...

Please be encouraged to post any solution for the rest of us. This kind of thing is on my "to do" list for the end of Jan 2017. Would really enjoy taking this thread and adding a little more functionality. Sharing your achievements and challenges would be very beneficial!

debug.print Left(Application.CurrentProject.Path, InStrRev(Application.CurrentProject.Path, "\")) I am creating many MSAccess Applications that use SQL Server, Excel Object Model Programming, Excel Templates, output folders (for Excel), .... One folder has sub folders with each of these...