Search results

  1. Rx_

    Databases Fail - as 15% foreign owned tax causes panic in Real Estate

    Just a follow up to 3 weeks ago FYI: Three weeks ago, when we looked at the long-overdue sudden change in the Vancouver housing market, long a receptacle for Chinese hot and laundered money, we found that as a result of the implementation of the 15% property tax implemented by British Columbia...
  2. Rx_

    Databases Fail - as 15% foreign owned tax causes panic in Real Estate

    Welcome to the road to serfdom. We are all on the road together. Its not really supply and demand of real-estate as it is the Money Supply available to those with income brackets above ours. The Money Supply is increasing for all of our countries. It is the 1% and their close buddies that...
  3. Rx_

    Better Form Performance

    Just wanted to ask a 2 cent question. RE: Split DB, BE is in a shared folder on our LAN. Please describe where the Front-End is located. Is the Front-End located on the LAN or does each PC have a copy of the Front-End? Observation: One of my FE dB is around 90 MB (compacted). Many of...
  4. Rx_

    Unsolicited Advertising

    I was in NYC and saw the Book of Mormon the opening week from 3rd row in 2011. They even had "Cartman" as the stage announcer. Was among some of our Colorado natives that are part of the show. The Book of Mormon is a religious satire musical with book, lyrics, and music best known for creating...
  5. Rx_

    Databases Fail - as 15% foreign owned tax causes panic in Real Estate

    About politics, about databases crashing (perhaps billions of dollars at stake), about building a type of wall to keep out foreigners, ... This might be a trend for both UK and US...
  6. Rx_

    Shameless Plug for my 300th Thanks!!

    There are many people from California working here. Here is the trick: https://www.rentjungle.com/average-rent-in-denver-rent-trends/ Average 1 Bedroom is $1,406 a Month USD. 2 Bed is $1,814. The Golden Triangle, Cherry Creek, and Lodo are closer to most jobs. They range from $2,940 mo down...
  7. Rx_

    Shameless Plug for my 300th Thanks!!

    See! I told you it wasn't fun. So we will stick with our Mile High Stadium. http://www.9news.com/news/local/deadline-approaches-to-name-mile-high-stadium/281081351 Mile High is taken very serious here. There is still much research to be done on how it changes our lifestyle. In the USA, we have...
  8. Rx_

    Shameless Plug for my 300th Thanks!!

    Sorry, no. But, next time you are in Colorado, I promise to share a teaspoon of my retirement cup with you! Times are tough but we can get through this! Thanks for using the measurement of a teaspoon. Denver is known as the Mile High City. We banned all references to the metric system...
  9. Rx_

    Shameless Plug for my 300th Thanks!!

    Have been enjoying my retirement. But, turned out that 300 thanks doesn't buy what it use to! With my coupon and 300 "Thanks" I got a cup of coffee at Starbucks.
  10. Rx_

    Orlando Shootings

    Oh my? The media could be bias? LOL They might even exaggerate the wrong points to push some agenda? Like Radio Station DJ, there are many less news people as corporations gobble up the industry. Yes, Bill Gates MSNBC did change the standards according to those laid off who didn't meet the new...
  11. Rx_

    Highlight Row Based On One Cell Value

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

    How to Upload E-files from ms access to sql server and download it

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

    Discovery - Super-hard metal "four times titanium" for Super Human use

    Adamantium is a virtually indestructible steel alloy named after the fabled metal Adamantine of Greek mythology. The metal has its origins in the work of American metallurgist Dr. Myron MacLain during World War II when the U.S. government assigned him to military research and development...
  14. Rx_

    Discovery - Super-hard metal "four times titanium" for Super Human use

    For those of you needing better dentures or joints, this is big news. However, it brings up the possibility of Super Human implants too. Would athletes with a titanium / gold alloy superstructure and exoskeleton be the next fad? Reported on BBC: :eek...
  15. Rx_

    How to Upload E-files from ms access to sql server and download it

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

    Vote for Brexit the Sequel - Scripts

    July 20, 2016 The International Monetary Fund (IMF) has slashed its forecasts for U.K. growth following the vote to leave the European Union, yet the British economy is still expected to grow faster than that of Germany, France and Italy next year. The Telegraph Business article can be found...
  17. Rx_

    Summing the third column

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

    How to Upload E-files from ms access to sql server and download it

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

    Most Nasty and Negative US President Political Ads of all time? Bull-hits

    The news media and political spokesmen make the outrageous claims that our Political Advertisement this election (2016) are the most vicious and worst in US history. They are just too lazy to pick up a history book. Today's political advertisements are so politically correct, they are not...
  20. Rx_

    Democratic Candidates Debate

    Americans Settle for Horrible Presidential Outcome Regardless: Poll - Level of fear is double old record - Americans Settle for Less The vast majority of Americans say they are afraid of at least one of the two major candidates — Hillary Clinton or Donald Trump — winning the White House, a...
Back
Top Bottom