Search results

  1. Rx_

    Monitors - will 2017 introduce a new standard (yet affordable)?

    Since video games need a monitor, what will the future hold? The computers and graphics cards are now so powerful, many say an i7 fifth generation can never really use all of its resources. But, what about Monitors? Years ago, I spent a lot so my primary computer has two 32" way beyond 1080i...
  2. Rx_

    If a moon of Jupiter support life - should we introduce new life for Earth travelers?

    Re: no sunlight Europa, NASA revealed new evidence for water geysers shooting from the ice-covered satellite. (e.g. volcanic activity) http://www.bbc.co.uk/nature/habitats/Hydrothermal_vent It appears that the Earth had at least twice frozen over, ice over a mile deep at the equator. Life...
  3. Rx_

    If a moon of Jupiter support life - should we introduce new life for Earth travelers?

    With the news from NASA - that Europa may support life. It most likely has a warm salty sea under the ice. with the low gravity, the water might not be crushing as gravity is only a fraction of Earth's gravity. Oh, and it has oxygen that might support a lot of fish for example. Would it be...
  4. Rx_

    What's your best/worst joke?

    Innovation - American Style A little boy and his grandfather are raking leaves in the yard. The little boy finds an earthworm trying to get back into its hole. He says," Grandpa, Grandpa, I bet I can put that worm back in that hole." The grandfather replies, "I'll bet you five dollars you can't...
  5. Rx_

    What's your best/worst joke?

    One fall day Bill was out raking leaves when he noticed a hearse slowly drive by. Following the first hearse was a second hearse, which was followed by a man walking solemnly along, followed by a dog, and then about 200 men walking in single file. Intrigued, Bill went up to the man following...
  6. Rx_

    Macro to consolidate multiple files

    http://www.access-programmers.co.uk/forums/showthread.php?t=233117 I used a search keyword Harvest to represent Harvesting data from multiple Excel workbooks and then placing the data elsewhere. Others posted some great links too in this discussion. Perhaps this can proved some basic ideas...
  7. Rx_

    i want to allow user to download query data from mySQL server

    Just a suggestion to evaluate: https://azure.microsoft.com/en-us/documentation/articles/web-sites-php-mysql-deploy-use-ftp/ Last night, I attended the local Microsoft Azure Users Group meeting. The new Azure interface release at least appears to be very improved over the previous...
  8. Rx_

    Best data link provider to import and link access table into excel

    If you haven't had a good drink lately, then you are worrying too much! It probably doesn't make any difference. As a purely personal preference, ODBC comes in many great forms. Eg. ODBC, SQL Server Native Client, ... There is probably more code for ODBC (generally speaking). In this case...
  9. Rx_

    Security Access to SQL server

    If the Front End is just the standard format where people have access to the Object Browser (tables, Queries) and such, that is good advice. But, it still won't allow someone with delete rights from exercising that right. If the FE uses compiled code to control the user completely through...
  10. Rx_

    Best data link provider to import and link access table into excel

    LOL, yes you did confuse me! Well then, we have many other options to discuss. You can create a query directly in Access and save it there. If the database is set as an ODBC connection In Excel you can choose DATA> Import External Data> New Database Query> select the database from the list...
  11. Rx_

    Best data link provider to import and link access table into excel

    Thanks! Use the Linked Table Manager and choose Excel as the Data Source. http://www.informit.com/articles/article.aspx?p=102281&seqNum=3 There are plenty of step-by-step instructions, this one is not better or worse, I just googled it as an example. Be aware that an Excel worksheet can...
  12. Rx_

    Astrology - anyone every programmed it?

    Does anyone else work with Astrology / Astronomy data? Do you think it affects your life on this rock? After over 6 years on one large scope project with multiple interactive deliverables, the market took a turn for the worst. There are mass layoffs in the industry that include all of the...
  13. Rx_

    Security Access to SQL server

    Security, agree! My preference is to use VBA code to 1. Destroy linked tables 2. Recreate linked tables with vba code for the session. 3. If the DB is on a Citrix or Remote Terminal server - limit access to only admin 4. If the DB is not on Citrix - compile the vba code HIDE the Object...
  14. Rx_

    Best data link provider to import and link access table into excel

    Are you planning to: import it with a wizard? Write VBA Code to find the excel file at a some location and import it over and over Use a Linked Table to permanently link to one Excel Worksheet - the work book / worksheet can be updated or replaced so long as the location and names remain...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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.
Back
Top Bottom