Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by njb

  1. njb

    Set focus in gridview when in edit mode

    When a gridview row is placed in edit mode, is there a way to set the focus to a control being edited? I've tried and am not having a lot of success. There is only one field being updated. That portion of the gridview is listed below. I would like the cursor to be placed at the RMKS control...
  2. njb

    Need Design/code Help

    I need help and I am not even sure where to start. We have an existing asp web page that reads a DB2 database to display information about how a specific parcel (property) is effected by our General Plan. This very long page (they call it a checklist) has a section for individual General Plan...
  3. njb

    Export from Access to Excel question

    Great! Thanks for your help. I knew there had to be a way to do it, I just couldn't figure out the how.
  4. njb

    Export from Access to Excel question

    I need to export data from my Access database to this Excel spreadsheet: http://www.co.el-dorado.ca.us/vendor_interface.xls I know how to do a straight export but that leaves a basic grid. Is it possible to export and keep the formatting? Is this possible? If it would be better to import from...
  5. njb

    Repeating control totals at the end of the report

    I'm looking for suggestions on how to repeat subtotals at the end of a report. I am working on a billing statement that has a master account with multiple sub-accounts. At the end of each sub-account, the billing charges are totaled. Each sub-account also starts on a new page. There is a...
  6. njb

    Need help writing a query

    I couldn't figure out how to do the star! Got it now. :o)
  7. njb

    Need help writing a query

    Yes, I discovered that but once I dissected your solution, I was able to fix it. (I was getting all zeroes) Tommorrow I will write the asp page and then the user can approve it. You did a great job of pointing me in the right direction and have been a big help. It's a good ending to the day...
  8. njb

    Need help writing a query

    You are AWESOME!! I would never have come up with this solution. Thank-you so much. You've saved me a lot of time. Now I can finally move forward. Hope you have a great day. No make that year!
  9. njb

    Need help writing a query

    I could use suggestions on how to write this query. A bit of background first. I work for a small rural county government and they are surveying residents about their satisfaction with their trash company. Once they fill out the survey, it needs to pop up with the overall survery results for...
  10. njb

    Problem with opening database

    I emailed you at the email address on the webpage. When I click on your name here it says the page is under construction.
  11. njb

    Problem with opening database

    That's ok. Parts of the Braden side of the family migrated to California from Canada at one time. I think in the late 1940s. Do you have any long ago or distant Canadian relatives? We have several family lines we have lost track of. Like your pics BTW.
  12. njb

    Problem with opening database

    The files are located in the same drives and folders as they used to be. This is a typical target path: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /wrkgrp "I:/PlanningTimeTracking/system.mdw" "I:/PlanningTimeTracking/PlanningTimeTracking.mdb" I'm thinking 2003 doesn't recognize...
  13. njb

    Problem with opening database

    Nobody has any ideas? I really need help!
  14. njb

    Problem with opening database

    My PC was just upgraded to XP and Access 2003. And now I am having problems opening my databases (access 2000). Each desktop shortcut has a target path that points to Access, the wkrgrp, and then the database. The open fails because Access is trying to open the mdb as a data access page...
  15. njb

    Security question

    I have what I thought was a secured database. Admin has a password and I created a workgroup for it and created user ids, passwords and assigned groups and permissions. I set-up icons on the desktops to point to the correct db & mdw files and that works fine. But the users have found that they...

Part and Inventory Search

Back
Top