Search results

  1. J

    United States Election and celebrations

    Election is on Nov 6. We vote for National, State, Local candidates and various local propositions. Assuming your candidate(s) win, what kind of celebration you are planning on Nov 7 or the weekend? If my candidate for Presidency wins, there will be great celebration and joy in my heart and house.
  2. J

    Riots in Totenham

    What is causing the riots in London. We thought London is a very peaceful place where everyone gets along with everyone else. Sorry to see such riots in London? Did the economic problems trigger it? Hope things get back to normal soon.
  3. J

    Wall Street Casino

    Welcome to Wall Street Casino. The smart people make money in the Stock market. What about the ordinary folks like you and me. I am sure 401K investors are worried now. What do you all see?
  4. J

    Women's World Cup Football (or Soccer)

    Anyone watching this world cup games? The USA win over Brazil was like a suspense movie. The US win made me happy. Hope they win the tournament. Two great teams are already out: Germany & Brazil. I am sure there are many complaints about the Referees in regards to Yellow/Red Cards and PK's...
  5. J

    US Social Security Math

    There is a talk among economic pundits that SS recipients collect lot more money than what they contributed during their working years. That is not true in my case. My contribution over 38 years: $130K Employer contribution : $130K Total : $260K Assuming...
  6. J

    Complexity of United States tax code

    I saw this quote: Douglas Shulman says he uses a hired tax preparer because the U.S. tax code is so complex. That's a bad sign. He's the I.R.S. commissioner. my comment: what about ordinary folks like you and me?
  7. J

    America's standard of living in the future

    My question: Will America's (USA) standard of living go up or down for the next generation? For the first time in decades, I am wondering whether the next generation will have a lower standard of living. My observations are given below: 1. The prosperity of the 1990's (Clinton era) may not be...
  8. J

    Delete a worksheet from an EXCEL workbook

    I use WindowsXP and ACCESS2007. Using VBA (in ACCESS) how can I delete any one worksheet from an EXCEL file? I have an EXCEL file called STAFFING.xls. It has several worksheets like ENG, FIN, IT, HR etc. How can I delete just one worksheet (FIN) using VBA in ACCESS? Any help will be appreciated.
  9. J

    List box data display

    I have a list box that shows 3 fields: Invoice_number (text) US_amount (number) Foreign_Amount (number) The data is displayed left justified. I would like to see US_amount and Foreign_amount displayed right justified. How do I do that? Thanks in advance for your help.
  10. J

    Close ACCESS object window

    I use WindowsXP and ACCESS2007. I would like to programatically close the ACCESS object window on form Load. How can I do it? I know I can close it using 'Access options' on Microsoft buttoons. I would like to do it programatically. Any help will be appreciated.
  11. J

    format a row in a table based on a field value

    When I open a table using a command Docmd.opentable "tblA" Is it possible to format selected rows (color, Bold, Italics etc) based on a field value of that row. If possible, please let me know how to do it. I use WndowsXP and ACCESS2007. Thanks in advance.
  12. J

    create a new column using ampersand

    I want to create a new column by using ampersand with 2 existing columns in a query. I want to maintain a constant width for the new column. For example: (varA and varB are 2 existing columns.) varA varB July xyz August abcd When I concatenate Using a query, I...
  13. J

    Application.Followhyperlink

    I use WindowsXP and ACCESS2007. I want to open a .TIF file with ACCESS command: fname="D:\myfile.TIF" Application.FollowHyperlink fname I get an error message: Run-time error '486' No program is registered to open this file. How do I correct this problem? Thanks for your help.
  14. J

    ODBC link

    I use Windows XP and ACCESS 2007. We have ODBC link to an SQL server. Will there be any problem with current ODBC link when we upgrade to Windows 2007?
  15. J

    Invalid database object reference

    I use ACCESS 2007 with Windows XP. I have a big data base (in terms of size). When I compact the data base, I get a message "Invalid data base object reference." When I click on Help key, I see error # 3276. I am not hitting the 2GB limit. Data base is .MDB and uses 2000 file format. I did...
  16. J

    ACCESS 2007 database compacting

    In ACCESS 2003, I was able to compact a live data base (single user) with a command button (using SENDKEYS command). ACCESS 2007 does not use sendkeys. Is there any way to compact an ACCESS 2007 using a command button on the Menu?
  17. J

    Windows XP scheduler

    Is it possible to set up jobs to be run Monday thru Friday (skipping Saturday and Sunday) using Windows Scheduler? If yes, how do I do it? I would like see instructions. Thanks in advance.
  18. J

    ACCESS 2007 compact on close

    I started testing ACCESS 2007 today. Can someone please tell me how to do compact on close. Thanks, Jacob
  19. J

    ACCESS opens in notepad

    When one user opens his ACCESS file, it opens in Notepad. He uses ACCESS 2003. Now he has to right click on that file (on windows explorer) and select open with 'MS Access' to make it to work. Any one knows how this setting can be changed to open with MS ACCESS?
  20. J

    Happy New Year to all forum members

    I know most of you will be taking a day off on Monday, Dec 31. Enjoy. Happy New Year to all! May 2008 be a joyous and prosperous year to all. I do not have any new year resolutions, except continue to work for another year. I am working on a project and the boss treats me good. I am now...
Top Bottom