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: smith7255
  • Content: Threads
  • Order by date
  1. smith7255

    Find and Replace

    I was wondering if it is possible to have a table with two columns in it, let's call them OldValue and NewValue, find the OldValue in a text file and replace it with the NewValue. Any information on this would be helpful. If it can't be done in Access, are there any other suggestions. I use...
  2. smith7255

    creating a quiz in Access 200

    I would like to create a quiz in Access 2000 for end users to take a required annual test. I don't want to be the one each year entering the information so I am looking for a way for the "super user" to enter the questions in. Once an employee enters their name and department, I want the...
  3. smith7255

    copying multiple txt files to one txt file

    Hello, I am hoping that someone can help me. I have an Access database that exports 5 queries to an ASCII txt file. I need to append them in a certain sequence and that will need to happen everytime the application is used. Let's say I have one.txt, two.txt, three.txt, four.txt and five.txt...
  4. smith7255

    macro to run an update query

    Is there a way to run an update query using a macro? I have an update query that I would like the end user to be able to click a command button to run it. I tried the way that I usually run a query in Macro but when I choose "OpenQuery", my update query is not in the list.
  5. smith7255

    txt file has no pk and the table needs one

    Hello - I have a txt file that I need to import into a table in Access. I have created an import spec, but the file doesn't have a pk. I need one in the table but the file will not import (using a macro) because the fields are not the same. Now, I can do it manually because it asks me if I...
  6. smith7255

    Runtime 2003 with previous version of Access

    Has anyone ran into any problems with Runtime 2003 with Access 2000/2003 databases?
  7. smith7255

    Crystal Reports on the Web

    I have Crystal Reports and Crystal Enterprise 9.0. I'm having a hard time finding good documentation. I want my end-users to use their browsers to view a crystal report. It is not necessary for them to modify anything other than dates. I want it to prompt them for the date range they want...

Part and Inventory Search

Back
Top