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 gkittelson 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. ADWoods

    SQL Triggers are not showing in Access.

    Hi, I hope you can help. I have an Access front end database consisting of a large number of forms and queries. I connect this to an SQL Server 2K via ODBC. I have written a number of Triggers on the database. The triggers are to alert a user to update a field if it has not been done. This...
  2. ADWoods

    Trim command is not working.

    Eurika, I found a whole bunch of stuff that was missing. I have reregisterd it and it seems to work. Thanks Ken you have saved my sanity for today!!
  3. ADWoods

    Trim command is not working.

    Hi, Hope you can help. I have a database working fine on 7 PCs. However on the 8th PC the user cannot run any report with the 'Trim=' function in it. When I run the report I am asked for a value for Trim as if it were a parameter. I have written the database in Access XP. 7 of the users...
  4. ADWoods

    Write Conflict using Access 2K and ODBC/SQL.

    Thanks for the advice. I will try ADO route. ADWoods.
  5. ADWoods

    Write Conflict using Access 2K and ODBC/SQL.

    Hi, I hope somebody can help. I have an Access 2002 SP2 database that will not let me make changes to data in a SQL database via the Access link. I have two parts to my database. A backend, MS SQL 2000 database located on a server. This is working fine and I can update any data I want. The...
  6. ADWoods

    Access 2002 will not shut down.

    Hi Mistereli, That is odd as I am currently running Office XP sp1. It seems to affect all users in my office. We all currently run Office XP SP1. Can you tell me what Service pack you are using. Thanks, Andrew.
  7. ADWoods

    Access 2002 will not shut down.

    Hi, I have a problem with a Access 2002 that I hope someone can help me with. When I exit Access all appears to be fine. The screen will go and the LDB file is no longer present. However I still have MSACCESS.EXE running on my process list. I cannot start Access now until I kill the process...
  8. ADWoods

    Access and Web pages.

    Hi all, I have been thinking about making part of my database available to users via the internet. But am a little lost where to start and was wondering if someone could offer some advice¡K Firstly some back ground. I have a small MS Access database (2000) that I use for logging in user...
  9. ADWoods

    Counting over a date range for different items.

    Hi Fred, I have been able to create the report from the queries as you suggested and it now works. Thanks for your advice!! ADWoods.
  10. ADWoods

    Counting over a date range for different items.

    Hi, I am trying to create a report that will allow me to count the number of items logged in to my database per month. Then do another count for each item in the month. For example I have 6 items. I have tried to create separate queries for each item I want to see and then merge them in...

Part and Inventory Search

Back
Top