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!

Register Log in
  • Congratulations derfloh 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: *

  1. RoCoPe

    Access SQL and SQL Server Differences?

    Thanks Bob. It appears that there is a bit of crossover between the two. A book or two a few late nights, and I should be up to speed. Any other input out there? RoCoPe "Learning on the Fly"
  2. RoCoPe

    Access SQL and SQL Server Differences?

    Hey everyone. have been out of the loop for about a year and a half, so I need to play catch up on a few topics. The following might sound like a dumb question but here goes: Is the SQL (transact sql?) used in Access a subset or smaller (mini)version of SQL server? Trying to get a...
  3. RoCoPe

    Access - Total Beginner Question

    Create a query using the Query Wizard. Keep it simple, use the help to understand. Step at a time. RoCoPe "You need it to do what?"
  4. RoCoPe

    Change Date Values on Related Records.

    Hey Everyone, Access 2000 DB. -Input form based on table with info about a specific project. Various date fields, specifically one "ProjectedHardwareShipDate", other date fields calculate based on this date. -Subform based on query from same table that lists any projects related...
  5. RoCoPe

    Problems Signing On

    Junior, Good ideas. All users have full access to the directory. Everyone access's the DB through shortcuts I have set up. These shortcuts point at the front-end which resides on the network. I have heard about individual copies on each PC, but isn't that a maintenance nightmare? We...
  6. RoCoPe

    "Opened Exclusively......". Ever seen that message?

    I have determined that the screen saver does cause this scenario. NT screensaver locks the application. I do have a timer on the database, I am testing different time periods of inactivity. One problem is that our company security policy requires screensavers be set at 5 minutes of...
  7. RoCoPe

    "Opened Exclusively......". Ever seen that message?

    Thanks for the idea. But, database is in shared mode. This problem only began AFTER converting to Access 2000. Definetely has something to do with NT or Idle time, or workstation security. Thanks again! Any other ideas? RoCoPe "Learning on the fly"
  8. RoCoPe

    "Opened Exclusively......". Ever seen that message?

    Quick scenario: I have been managing an Access 97 database on NT for about four years. Database is split, back-end tables, front-end forms, queries, reports, code. Database is used by about 50 people on the network. I do not use Access security, instead, I have user levels defined through...
  9. RoCoPe

    Problems Signing On

    I have a similar problem (I think). Quick scenario: I have been managing an Access 97 database on NT for about four years. Database is split, back-end tables, front-end forms, queries, reports, code. Database is used by about 50 people on the network. I do not use Access security, instead, I...
  10. RoCoPe

    Is it possible to create a calendar report with conditional formatting

    NICE!!!.... That's along the lines of what I had figured it would take. I can take that and make the necessary changes. Thanks for your help!!! RoCoPe "Learning on the fly"
  11. RoCoPe

    Is it possible to create a calendar report with conditional formatting

    Thanks for the link, but it refers to forms. What I need specifically, is a report that displays in calendar format. Information regarding scheduling is input via a "Projects" form, most users view this information in a traditional column report layout, sorted by due date. But of...
  12. RoCoPe

    Is it possible to create a calendar report with conditional formatting

    Did you ever get an answer to this question? I am trying exactly the same thing, and I cannot find a way of doing it. I assume it would take a considerable amout of code within the report to place the info on the appropriate date within the calendar.

Part and Inventory Search

Back
Top