Search results

While enjoying my breakfast of kippers vindaloo, my message board alerted me to a question on the site. The Access industry in my area that require any levle of programming have seemed to evaporate. Every so often I get fooled into talking to some company that really want's some web development...

http://www.sqlsaturday.com/734/Sessions/Schedule.aspx This might be of interest to MSAccess programmers that tap into a SQL Server platform to create an application for a small business unit. Of interest is a Free Power Point download for beginners regarding SQL Server Security. It is a quick...

Microsoft ODBC Driver 13.1 for SQL Server - Windows, Linux, & macOS https://www.microsoft.com/en-us/download/details.aspx?id=53339 3/26/2018 Release A friend called me to solve a problem. Saw an update a month ago about the update. Sorry I have been too busy to update. More related use for...

Received this in an email today: Join in these fun and informative events all about Microsoft Access! Learn new tips & tricks, connect with other Access developers and hear from noted Access MVPs! Armen Stein will be speaking at the following events in April 2018: April 7-8 - Access DevCon...

Many of us remember the stock market and world markets made a 1,000% gain. We were all comforted by Experts that it could extend forever because "It was different this time". In Celebration yesterday, Wall Street hit a new High. Computer trading is now High-Frequency-Trading. What is next? The...

More information at: https://accessusergroups.org/calendar/ USA Chicago, Ill Access User Group reminder for our next Access SQL Server meeting, which is Tuesday October 10th. Microsoft Access has long been a stalwart solution as a desktop database and application development solution. With...

First Prototype - looking for code to count the number of columns in a specific Row starting at either column H or L. Will use that result in place of hard coded 30 in For HideColumnCount = 0 To 30 Note: just in case a cell is empty - exit the loop. Not shown is custom Sort and Grouping...

UPDATE: Found a workaround that reduced the need to try this. If anyone tries it later, send me PM and I will mark it as Solved Does anyone have experience in creating a mapped network drive from MSAccess? Any other suggestions over the code listed below? On my schedule is the ability to Map...

I am going to submit the Guardian stories. These are great! https://www.theguardian.com/theguardian/2017/apr/01/fake-news-the-best-and-worst-april-fools-day-stories “Science correspondent” Rollo Piaf (no prizes for unscrambling the anagram) reports that a polar bear is living on a Hebridean...

Here is yet another number to memorize, 218 Evidently, when Excel uses a Link to another workbook / worksheet in a formula, the string length of the worksheet is reserved as part of the total SaveAs Path Length. For Excel VBA remote automation from MSAccess code, the handshake is not pretty...

Found several code samples to start. If anyone has suggestions for creating a multi-tier directory structure for a SaveAs - please chip in. Sorry, had a last minute design change - nobody responded so will update the requirement and code. Will add more code as day progresses. Output: General...

Just wondering if anyone had recent experience with MZ Tools. Used it for years at one assignment, but it has been a year now. Saw there was a new version. https://www.mztools.com/blog/ The VBA tool was updated in Jan 2017. Will hope to install trial today if system admin allows. Of great...

http://www.appspro.com/Utilities/Utilities.htm Found this, must try at home before installing on production device. Looks interesting. Does anyone else have Excel Utilities to share?

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

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

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

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

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