Search results

llkhoutx, It was a tedious process, but I finally got the conversion done using Excel, autofilter, and a lot of UPPER and CONCATENATE routines. Let's not forget the cutting and pasting afterwards <smile>. The macro you spoke of...was that using Access or Excel? Do you have any examples to...

Greetings, Up front, I am posting this question in both Access-Queries and Excel forums. I am using Access-Excel 97 SR2 at work, and Access-Excel 2000 at home. I have a large Excel file where the addresses are all in one field (Address). Here are some examples: 807 E.South St. Apt.33 Crown...

Thank you both. It worked like a charm.

Greetings, Using Access 97, SR2. I have a query and a report that lists employees with college degrees. The criteria is that the degree was completed sometime during: A. The current fiscal year (10/01/2001 - 09/30/2002) B. The previous fiscal year (10/01/2000 - 09/30/2001) C. Show all for...

Can this be done with a text box, too? Greetings, I've been playing with the command button color routine discussed here. I've tried to adapt the same thing to a text box. I have an unbound text box which returns a value. I've been able to get the text box to behave like a command button in...

Hmmm....Still not working Rich, Still returning the same error as before. I created a new unbound textbox in the FOOTER of the subform, calling it txtEnd_Date. In the main form I created an unbound textbox, calling it txtDevAssgn:. I pasted this expression into the control source of...

Fizzio, I've placed an unbound textbox on the Main Form (frm_DNO_Developmental Assignments), and pasted the expression you provided. It returns a syntax error. Here is the error text: "The expression you entered contains invalid syntax. You may have entered an operand without an operator."...

Greetings, I am using Access 97, SR2. I have a form that tracks developmental assignments of employees (frm_DNO_Developmental Assignments) . On this form I have a subform (sbfrmDevelopmentalAssignments). The subform is set to display continuous forms. An employee can have more than one...

I'll try it tomorrow...! Thanks again, Jon. I'll try it out tomorrow at work. Sincerely, Bob in Indy

A new wrinkle Jon (Or anyone else), This is in the same database, different field. I've tried adapting the SQL you provided, but I'm getting a syntax error. I have a field called EOE (Element of Expense). It's a text field, length 4. I need an update query that will change all EOE <> 1198...

Works like a charm !! Thanks, Jon. Just what I needed.

Greetings, I've searched on Update Queries, but didn't find anything to do this. I am using Access 97, SR2 I have a text field called BLK, length is 3. I need to replace the first character with the number 9, regardless of what the other two characters are. Example: Current data: 0L3...

Thank you Peter, I had already seen those sites. So, are you saying that by using that code I can circumvent the error I'm getting on the Common Dialog? If nothing else, I would like to have something that would allow the user to name a text file that is going into a specific directory. When...

Greetings, I am using Access 97 SR2 on a Windows NT machine. I'm wanting to TRY to use the Common Dialog Control so the user can open a file from a directory, and also save as to a directory. I have verified that my Commdlg.dll is on my PC. Here is what Microsoft said of the location of the...

Disregard...Have the solution Well, I've a solution to my dilema. Using 2 update queries; Query 1: UPDATE t_Dix_Converted SET t_Dix_Converted.APC = Left([APC],2) & "OA" WHERE (((t_Dix_Converted.EOE)="4140")); Query 2: UPDATE t_DIX_Converted SET t_DIX_Bak.MANHRS = Left([MANHRS],3) & ""...

Greetings, Searched on Update Query, but could not find the answer, so here I am <smile>. I am using Access 97. Question 1: I'm working on a fincance and accounting (F&A) database at work. In this instance, I'm interested in PARTIALLY changing the values of data in one field based on...

Try this... See if this helps from the REPORTS forum, courtesy of Rich. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31419

Worked like a charm !! Jon, Your SQL worked like a charm. Many thanks to you. Sure will make the database easier to manage. Thanks to all who replied! Bob in Indy

Alas, I had to try... Rich and Doc Man, Thank you for your replies. In fact, there already exists a two-query and macro setup for this particular problem. Was hoping for a way to perform the task with just one. Well, at least I can get rid of 16 of the current 18 queries that are now being...

Greetings, I'm updating someone else's database using Access 97. I want to replace multiple queries that are being used with just one if possible. These queries are run every month on new Budget data. All fields are in the same Table Example: Query 1 Field Name: TA Field Type: Text...