Search results

I will give it a try. I will probably be back. :-)

Found the problem. Turning the warnings back on revealed several Key violations. Course_ID is a Key field. Several old courses were being "combined" into one new course, so there were duplicates. This is a problem I didn't anticipate and should have mentioned to the folks creating the new...

Yeah this is a oneoff job. The new and old codes exist in an Excel spreadsheet. Some other people in my department used Excel to work through the process of renaming the codes. The example I posted was the simplest of 20 modules - the rest of the data is a little messier - like job titles...

I have a very simple module that runs a bunch of SQL queries to convert a database over to a new set of "course codes". The module is simple but long. There are a little more than 600 lines of code. A few sample lines are shown below. "Most" of the lines run with no problem but some at the...

I am overwhelmed by all the help! Thanks very much, I will work through all this tonight. About the loops I talked about... its sorta complicated... Most of my programming has been done in Excel using vba because our company thinks that Excel files will be more maintainable in the event that...

I guess that would be the correct way to do it wouldn't it. I was hoping there would be a way to keep everything in one table. I forsee a lot of loops in my future - instead of looking up an employee's one and only job title, we now have to loop through tables looking for all the employee's...

I'm not sure how "challenging" this will be for you experts, but I am stumped. I would like to write a new employee management tool for our company. We have decided on the following five levels of classification to describe where a worker works: (its a large company!) (1) Division...

Thanks guys I will give it a try......... SD

We have an old app that will only read its old Access 95 database. My copy of Access 2003 will only open the Access 95 database in read-only mode, so I cannot add the fields we need. Also, Access 2003 will not correctly perform an upgrade of the database to 2003 format. I have written new...