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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: njb
  • Order by date
  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...
  16. njb

    design help

    I seem to have lost my brain today and cannot figure out how to do this. I have 2 tables, positions & tasks. There is a need to specify if a task is valid for a position. This is a many-to-many relationship creating a 3rd table of position & task & valid y/n. So far so good. On a screen I need...
  17. njb

    Crosstab help

    I seem to have lost my brain today and cannot figure out how to do this. I have 2 tables, positions & tasks. There is a need to specify if a task is valid for a position. This is a many-to-many relationship creating a 3rd table of position & task & valid y/n. So far so good. On a screen I need...
  18. njb

    DB slow to open

    OhioSteve - another way to run is a module is to open in in design mode (look at the code). Highlight the name of the function or the subroutine. Click the run (arrow) button. It will run. I sometimes find it is easier to right code for a quick fix than put together screens and queries. How that...
  19. njb

    DB slow to open

    You are right - we are saying the same thing only differently. I guess I look at it in reverse because I copy the production system to separate folder, make my design changes and then signon to the production db and import the changes from the test db into the production db. But the way you...
  20. njb

    DB slow to open

    Oops you have it backwards. The test copy is fast to startup, the production copy is slow to startup. Which makes it even wierder. I agree it does seem to be searching for something but what? No linked tables, references the same, what else is there to look at? I did not split the database so...

Part and Inventory Search

Back
Top