Search results

Go to conditional formatting for the Yes cell, enter anything. Go back to conditional Formatting Rules Manager (see attachment) This provides a little clearer idea of what is happening. Note that I fixed the location of the Columns with the $ but not the rows ($C2) Then fixed the Applies to...

With a FE and BE, tables can reside in two locations. 1. Shared data for all users on SQL Server - each FE has a Linked table to SQL Server. 2. Local Data for a specific user during a session - Use the Local Access Table If you have Upsized, more than likely all of your tables are now linked...

Since the upsizing - look at your FE table View. Do they resemble Globes (indicating SQL Server) with arrows (indicating linked tables)? In the FE table objects, double click (open) a linked table. Does the table's data appear? Scroll down to the last record (the one with a *). Can Data be...

Thanks for posting your solution! Since you are starting down the slope with SumIF, there are times the SumProduct will be needed. Alternatively, a "helper" column could be created. However, if the datasets are huge (e.g. 30K rows) with multiple columns, this can overwhelm the processor. Just...

Lets break the questions down to bite-size. 1. You upsized 2. The linked tables from the FE to the BE are working? 3. Explain the needs to change design SQL Server (give us some examples) 4. Code on the FE to meet the back end RE: 4 I prefer to create a local FE table that holds the...

YOU WIN - My 300th THANKS!!! - Now I can cash them in. Trust me, it is a curse knowing why that worked. It had to do with network Latency during a user session. Something I covered years ago in a MS WOSA I & WOSA II certified exam preparation book and interactive prep. Ancient...

The version of the Publisher can cause this. By default Excel saves a hidden table of the link values for calculation purposes. In some scenarios the values for the external links may not be the same as what was last calculated in the formulas. It is also possible to turn off the feature to...

Subscriber is the Excel that links to the Master to copy the data. Is Subscriber Excel located on the Workstation or on a Network drive? Is Master (what is being copied) on a Network drive? There are many reasons these Subscriber links can hiccup, try to recover but change a property...

Just a suggestion from someone else who has done this many times. Instead of making the total move all at once and risk being off line a day or more figuring out why... Break it up into manageable tasks with a fall-back option. 1. Split your existing Access DB into a front-end / back end...

Thanked 299 Times in 274 SO CLOSE - When I get 300, I can cash them in and retire? :D

We don't sue everyone else for every little thing! I sue you for saying that!!! LOL Thanks to smart phones, my app can sue your app? When I was a Microsoft trainer, I was teaching an advanced Access class in Hollywood. It was MGM Studios. The larger connected DB kept track of all the...

It is easy to miss the point when only focusing on one single element. http://www.fathermag.com/news/2778-stats.shtml Part of my Technical Education degree included summer sessions with teachers for inmates. There is one major element that has persisted over 50 years. With more homes raising...

Won't have time to test. Suggest using an object instead of counter. Sub highlightrows() Dim ColC As Range, ColD As Range, incrementMe As Integer Set ColA = Range("C1:C2225") Set ColB = Range("D1:D2225") incrementMe= 1 For Each Rng In ColC ' Take an extra step for My4char1 = Lert(...

OK, I can tell that you are talking about ME now. I will confess ... I think that I have personally done more dumb things than the UK. Can we forget about it and move on?

The answer above will work fine. Just to add a little more, this is an interesting article to keep handy. http://www.techonthenet.com/excel/pivottbls/empty_cells2010.php If using Excel Automation to read external data and create canned Excel outputs, then the use of Named Ranges in MS...

Late Night TV Shows - Jokes from Last Election "Hillary Clinton visited Egypt today for the first time since the uprising. When asked why she went, Bill Clinton said, "Believe me, if anyone can stop an uprising, it's Hillary." "Well, the talk is that Hillary Clinton is going to try and...

Those of us over 55 can have strong memories of this 45 year old song hit. This might explain to the generations that followed why this was a big news item. The verdict, from an eight-member jury at Los Angeles district court, came at the finale of an eight-day trial in which Jimmy Page...

http://searchwpplugins.com/tag/microsoft-azure/ Not moving forward as fast as expected. Building a Hybrid system - Access front end -> Azure back end <- WordPress The Access front end (Back Office Manager) will have a rich graphical interface and connect to all tables / views in Azure. The...

The best Greek post-Brexit joke yet: "Oh well, we didn't make it out of the EU last year, but today at least half the Parthenon did"! :) Day one of Brexit. The Zimbabwean dollar is up against the pound. (I wish I were joking). Photo from the Channel Tunnel this morning...

Sub main() Dim r As Range ' This is an Excel Object With Sheets("Sheet1") Set r =.Range(.Cells(1,1),.Cells(3,4)) ' cell 1 of a rangeEndWith Debug.Print r.Address ' Open your debug window to see value select_cells r EndSub PrivateSub select_cells(aCell As Range)'...