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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Populate one field based on data from another...
In Access 2000, I am trying to populate one field based on the input from another. The ORIGINAL field would be in one of the following formats: 64532-3 84-1234 45123 For the REVISED field, I need to strip the "-" out in the case of 64532-3 only, so resulting data looks like: 645323...- jojomore
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
data type problems w/ imported data
Hello, I have a csv file that contains new records that I need to update an existing table in an Access 2000 database that I have inherited. I want to automate the process, these are employee records and the csv file is updated weekly. I want to import the data then run some queries to update...- jojomore
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
New Record in form to create new Record in subform
I have a form/subform that I want to use not only to display related info (which works fine), but to add/edit records. The main form is "Product Number Info", subform "Product Images". When a new product number is added to the main form you have to re-type the product...- jojomore
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Parsing capture file from Meridian ACD
I need help with a solution to capture 11 pieces of data from a Meridian ACD... Right now I am capturing all output (hourly) into a text file, which is then copied to a network drive so customer service can access it and then the specific data is being re-entered into a spreadsheet for analysis...- jojomore
- Thread
- Replies: 1
- Forum: Aspect (Procomm)
