Search results

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

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

Probably use a Sum IF formula. Look at this example - then search on the Internet - there are many variations and examples. Be sure to post your best solution! Others are sure to thank you for it. https://www.extendoffice.com/documents/excel/1419-excel-count-sum-positive-negative-numbers.html

The question is: How to take this Cross-Tab of Sun's days (Calendar) and bring them into Columns of Earth's Year, Day calendar for the Value (X, ., *). The following is a daily log of the Sun's Geomagnetic Field as observed from Earth. Or, as Affected by Earth. For those of you who didn't know...

That is a better idea, use the web version of a spreadsheet. I seem to remember a post somewhere that we discussed how to connect a google doc into Access.

Access won't run on Apple. But the new small business Citrix would allow Access to run on just about any platform over the Internet. It is most likely more than a small coffee shop owner wants to do. For a POS, it would be possible to just enter data in a spreadsheet then send that...

Any additional ideas on setting filters in an Excel Pivot Table? Also: Found TableRange2.Address - are there any other features for what seems to be an undocumented Excel object? The vba running from MSAccess to automate Excel objects: The...

This project also involved, filtering an area (in this case a Pivot) and copying the visible files over to another worksheet. Reminder: this is all remote automation from MSAccess to a newly created Excel workbook using object code. This problem did not occur when running the code from within...

Problem: Running the same .ActiveWorkbook.PivotCaches.Create a.k.a Create Pivot Table - in Excel vs MSAccess with remote automation: The Excel SourceData can be columns $A:$CC and run. From MSAccess using remote automation - it throws an OUT OF MEMORY error at the system level. Question: is...

Sorry it took so long to get back. After spending four hours to solve a simple problem, it turned out that it might help your question. Problem: Trying to insert a dataconnection in Excel to a make a worksheet linked. Using the Get Data using existing connections is well known. To do this with...

There are several ways to accomplish this. Be careful! using timers that spawn an object without closing the last object can be ... really bad. When TESTING - be sure to open Task Manager. If new instance of Excel are spawned every cycle, stop the session! The key words are below in some...

No, I can afford the full bike. Why is it people are impressed by more balls and less wheels? Things would be so much simpler if they wanted less balls and more wheels Until I saw a video on you tube of this guy riding down a set of stairs, so I just had to try it. I broke my neck before...

The fun part of the Europa deep oceans with high oxygen content and possibility of life being constant for over 100 million years is how things might evolve. Is evolution a result of normal but massive climatic change (including meteorites, volcano, and air-conditioning)? Or, would dinosaurs...

I think the term is Invasive Species? We all have our pet real-world personal experience of villains of conservation biology disrupting ecosystem and throwing native populations into disarray. The English Sparrow in the US Midwest, burrows on islands, Russian Tumbleweed in North America...

You bring up a good point. It is actually 2 1/2 D with the brain filling in the rest. A true monitor on a coffee table would let people sitting in a circle around it all see the perspective angle of a 3D image. So far, that kind of projector has not seemed to been announded.

Once upon a time, a man appear Once upon a time, a man appeared in a village and announced to the villagers that he would buy monkeys for $5 each. The villagers, knowing there were many monkeys, went to the forest and started catching them. The man bought thousands at $5 each and, as supply...

This Access club has a great site where a presentation and code can be posted for those who can't make it. The Microsoft sponsor also has the ability for live video streaming, and video archive. In general: if just 8 others would request the presentation be available for video later, I feel...