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 wOOdy-Soft 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 cehepker

  1. cehepker

    Highlight a row in a cont form

    Hello, This is Carla again...Never mind the above question. I got it to work. Carla Documentation: A Shaft of light into a Coded world
  2. cehepker

    Highlight a row in a cont form

    Hello, I am not sure what I am missing. I tried both methods listed above, and both of them did the same thing that Kenneth mentioned - the screen flashes, but the formatting does not change. Any ideas? Carla Documentation: A Shaft of light into a Coded world
  3. cehepker

    Is there anyway to get a query like this to work?

    Hello, Could you do two select statements? In the first you could pull the forecasted date - 1 into a variable, and then use that variable in the second select. Carla Documentation: A Shaft of light into a Coded world
  4. cehepker

    VBA Code Commenter and Error Handler

    Thanks and I agree. The problem is I don't know what file it is! I have read (and read and read) the documentation on installing it and it just says to pick it from the list of add-ins, but it does not show up in the list. Any idea what file to look for? Carla Documentation: A Shaft of light...
  5. cehepker

    VBA Code Commenter and Error Handler

    I have the MOD VBA Code Commenter and Error Handler add-ins installed on my machine. But when another programmer uses my machine, logged on as themselves, those add-ins are not available. I know it is installed on the machine. What do I need to do in Access to get it to show up for the other...
  6. cehepker

    VBA Code Commenter and Error Handler

    Hello, I have the MOD VBA Code Commenter and Error Handler add-ins installed on my machine. But when another programmer uses my machine, logged on as themselves, those add-ins are not available. I know it is installed on the machine. What do I need to do in Access to get it to show up for the...
  7. cehepker

    Open a Database (Visual Fox)

    Hello, You should also make sure that you have the same ODBC connections on the server that you have on your desktop. This can also cause a scheduled DTS to fail. HTH, Carla Documentation: A Shaft of light into a Coded world
  8. cehepker

    Possible to add db role to server role ?

    Kim, Good point, I was not looking at the actual "server" roles. Sorry. Carla Documentation: A Shaft of light into a Coded world
  9. cehepker

    how can i transfer whole database(all the values in the table) ?

    Hi again, In the wizard you should see a choice to overwrite or append the data. Carla Documentation: A Shaft of light into a Coded world
  10. cehepker

    Possible to add db role to server role ?

    Hello, I have never had occasion to do this, but I went in an added an application role to the server role just fine. So it seems like it is possible. Carla Documentation: A Shaft of light into a Coded world
  11. cehepker

    Permission problems Executing DTS from Stored Procedure

    Hello, What kind of error message are you getting? Do you have the same DSN's on both machines? I am not sure what you procedure looks like that you are using to run the DTS. While I know there are several ways to do it, here is a copy of one way that we have found that works: CREATE PROCEDURE...
  12. cehepker

    how can i transfer whole database(all the values in the table) ?

    Have you tried using the export wizard? It will give you options to select all the tables if that is what you want to do. You may want to use the wizard to create the DTS and then tweak it as needed. HTH, Carla Documentation: A Shaft of light into a Coded world
  13. cehepker

    copying .mdf files from one server to another...

    Hello, Another way might be to just back up the database on the one server and restore it on the other server. You may need to move the physical file that you backed up to, but other wise it is very straight forward. Carla Documentation: A Shaft of light into a Coded world
  14. cehepker

    Views vs. Temp Tables

    Hello, A view is like a query, it does not store any information. A temp table does store information for a finite period of time (until you drop it or the connection is severed). As to which is better to use, that depends on your needs. Carla Documentation: A Shaft of light into a Coded world
  15. cehepker

    Trigger

    Hello, You should be able to find an example in Books on Line. I would use the Columns_Updated() function in the trigger. Books ON Line describes how to do that. Carla Documentation: A Shaft of light into a Coded world
See more

Part and Inventory Search

Back
Top