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 SkipVought 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. ChakaTheApeMan

    run query in SQL on Form Load

    This is a little off topic but… This thread deals with ADP vs MDP and speed issues. I thought you might find it enlightening. http://www.pcreview.co.uk/forums/thread-1627588.php I don’t use mdb for anything significant. You know the office pro cd has a copy of developer sql server. SQL...
  2. ChakaTheApeMan

    Deploying Access Projects

    If you wanted to do this terminal server thing, I guess you could with the NT user name and Domain name from the Active DS Type Library. You can get all the NT authentication information via Active DS Type Library. I use this to find full usernames and set visibility and access by what domain...
  3. ChakaTheApeMan

    Why Does "Server Filter" Get Stuck?

    If you set client side filters including orderBys the server filter appears to be stuck. For example if I was setting, on close event, me.filter = "". This empty sting seems harmless, however is breaks the server filter without an error. You can no longer change the server filter after...
  4. ChakaTheApeMan

    Why Does "Server Filter" Get Stuck?

    I found some strange behavior and have found no documentation to explain it. Maybe will find this useful or someone could elaborate on these issues. Refactoring, to use filters has yielded some questions. I have just converted an access ADP that used MS SQL 7.0 to use MS SQL server 2000...
  5. ChakaTheApeMan

    ADP Form Problem

    Whoops, I got ride of this error by making the child tables link the primary key. I had the PK set to an identity, allowing me to change names without orphaning records. Whatever, Access didn’t like this. Not sure doing this makes good db normalization sense either. What can I say, Dose this...
  6. ChakaTheApeMan

    ADP Form Problem

    This server filter issue seems to be more specific then previous resolutions. I was thinking that the cause of this issue was linking to a primary key that is an identity. Maybe other users have more insight on that? I would like to try resetting the sever filter first. Bbrendan if you...
  7. ChakaTheApeMan

    ADP Form Problem

    I ran into this problem today. It seems that Microsoft has a Knowlde Base artical on the subject. It seems to be telling me that all my problems would go away if I upgraded my MS Sql 7.0 --> 2000. Other wise use a view for a resolution. That would be an icky resloution, can't update views...

Part and Inventory Search

Back
Top