Search results

Taking Stock in yourshelf is a worthy effort. We wish you the best of luck in your new abandonment. <Provided by Auto Responder AI - when you don't have time to send a personalized response but want to maintain your blog ratings. Try AutoResponderAI.com to solve all your social and business...

https://www.extendoffice.com/documents/excel/3445-excel-add-days-to-date-excluding-weekends-and-holidays.html#a2

This is just from memory Look up the Application.OnTime for Excel It is somewhat like an Alarm Clock In a Worksheet module - add the code. Place the sstartTime procedure in the Auto_Open event code something like this: Dim TimerActive As Boolean Sub StartTimer() Start_Timer End Sub Private...

I have been off for a while, saw this older post. Look at this: https://www.access-programmers.co.uk/forums/showthread.php?t=273254&highlight=objxl It is not exactly what you are asking for. But, it shows the process of how to evaluate a cell by cell and set the formatting, color and such. You...

This might also be of interest Application.DefaultSaveFormat = xlExcel4Workbook There are different versions of XLExcelXXWorkbook to fill in the XX

There is a Thumbs Up for a Thanks - that counts on a users profile Also, see the Scales icon on the user profile Clicking on the scales with an Approval note adds stars to the users profile I just added 10 points to your profile by clicking on the Scales. Welcome to the forum

Search on Rx_ user and Upsized I could not find my exact post years ago. After upgrading none of my previous Execute statements worked. It seemed that a dbSeeChanges was needed. Just in case: in another situation, it had to do with a sub-form updating. Take a look at this to see if it might...

One time I gave someone a positive review, and I actually noticed them seeing another Green rectangle. Other than that it is a mystery to me. Maybe if its negative, it is a coffin instead of a rectangle? LOL TEST: I just added to Ridders reputation. He has 1 green rectangle. Can others do...

thanks for the update, I said I would get to this later. I found the same problem. The basic stuff was easy. But, in the end, it is all web server access with a lot of refreshes and so many exceptions to the language as things progress in complexity. Then, there was CoffeeCup. CoffeeCup like...

Don't be discouraged by using API. Just go to the extra effort of creating documentation for test plans to test, test, test the API. Document the OS and Office versions they were tested on. You might even go so far as to create a really simplistic application that does nothing more than test...

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

Used a lot of API calls in my last environment. As said, it is necessary to check for 32/64 bit. The biggest problem comes into the testing of them across various platforms. Some of my API calls that worked great on the desktop, just would not work on Windows Servers for example. Since you...

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

Well, SIR Doc, your ancestors stayed ahead of the outcome. It is interesting how many of us Heinz 57 (http://www.urbandictionary.com/define.php?term=heinz%2057) have ancestry across the pond. After looking at Ancestry, would also love to go back to walk in the footsteps of my family. Just the...

This weeks Housing report: http://www.theweek.co.uk/house-prices/61987/house-prices-see-abrupt-reversal-in-momentum "Nationwide reports first monthly dip for two years and a sharp fall in annual growth rate" OK, but to be fair, they didn't mention your name and that your moving there was the...

How about some of us in the States chip in to set up a multi-room Skype VIDEO chat (or other service) so we can all have a toast together. The only reason a paid service is mentioned is because the free ones don't always seem to work that well. We want the least time-delay lag since Colorado is...

Burger King's Single Fries https://www.youtube.com/watch?v=mheyvx1kVJQ Burger king's Whopper Toothpaste https://www.youtube.com/watch?v=-fCRqsQBvPY Virtual Reality YouTube https://www.youtube.com/watch?v=DPEJB-FCItk&list=PLud_6cB_H2NVSD6sq1LH9ITo18qRoBOEl Down under...

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

Glad you found the solution. Being specif about the workbook referenced is easy to miss. Filling in the answer will help others who are searching for a solution later. Please feel free to use the Thread Tools and mark your post as [SOLVED]. And, also feel free to post the key parts of the entire...