Search results

Why do you think Brexit and Trump happened? Is it a one time thing? Is it a trend? As a fan of observing the Brexit, the outcry across the pond indicates that the "People are Revolting", as depicted in Mel Brooks "Count D' Money" https://www.youtube.com/watch?v=sztf4hcGrB4 One theory is that...

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

A few years ago, I posted DSN-Less or DSNless connections. Several great programmers from this site chipped in. It is basically a vba subroutine that deletes all links then uses a script to create the linked tables with out an DSN (on the desktop). It is basically the same process used for...

A view with no unique data (part of a cube) didn't have unique columns to select with the Linked Table Manager. So, we used the Row_Number() function to create unique values in the view. Using Linked Table, and selecting the Entity_name column with the unique number returns #Deleted# in all...

Now in India, the Central Banks won't honor anything much over a $7.00 USD bill. Then, they froze the accounts of the gold and jewelry dealers before the festival. They are making decisions on if and when to unfreeze these accounts. The RBI sits on a board for the Bank of International...

Did anyone notice the VLookup when used with Access VBA remote automation fails to auto refresh? The VLookup was working on multiple PC for several weeks. Around December 8-12 of 2016 - it stopped working on multiple PCs. An application that processes a large text file, processes...

Has anyone run up against a limit of elements used in the Array used in the VBA automation of DATA Sorting and Grouping? The latest project takes SQL Server views, pairs them with an Excel Template, then processes three levels of Sort and Grouping plus all kinds of fun Excel enhancements...

You mentioned using the Excel Forms. It has been a while since I did that. Basically, on the change, look up a Buddy Control. For example, a slider bar can be used to update a cell - and that cell might be used to control a chart view degree, or other aspects of your calculated areas...