Replies

This is a brand new clean install of Windows 2000-no service pack. I’m attempting to download whatever service pack is available when I do Update Windows. I have no firewall.

AVG called two of them backdoor.sdbot89.R and Y. There were others, but I didn’t write those down. I also got a window while trying to do the update that told me to run fixerror.exe. I didn’t do that, because I had heard it was not a legitimate command. Now, I’m all sluggish when I try to do anything.

AVG called two of them backdoor.sdbot89.R and Y. There were others, but I didn’t write those down. I also got a window while trying to do the update that told me to run fixerror.exe. I didn’t do that, because I had heard it was not a legitimate command. Now, I’m all sluggish when I try to do anything.

I have an old table from an old database (Filemaker) where job numbers have already been issued in one field. The numbers represent the job, the subjob, and the county. 0010-01-LE, and may have several subjobs where the number would be 0010-02-LE, 0010-03-LE, 0010-04-LE, and so on. Each county may have a job 0010 and a subjob 01, 02, 03, etc, so you might have 0010-01-LE, 0010-01-HT, 0010-02-LE, 0010-02-HT, and so on. Keep in mind, that these are presently in only one field in a table called JOBS. I’d like to convert this table to an Access table or tables where the Job Number and the subjob number are issued automatically like an autonumber. For instance, if I need a new subjob, which would be subjob 05 for job 0010 in LandsEnd County, I need to be able to pull up job 0010 in LandsEnd and create a new subjob 05. OR, I need a whole new job which is job number 4456 in LandsEnd, or job 1160 in HighTower.

What I’d like to do is:

1. Keep the job numbers (Old Jobs) and subjob numbers (Old Subjobs)
2. Issue new subjob numbers for the old existing Jobs
3. Issue new Job Numbers for any new jobs that we create
4. Issue new Subjob Numbers for any new jobs

If I can’t pick up where I left off, can I cross-reference the old jobs numbers to the new ones somehow? The old job numbers can be set up as primary keys in the tables they are in now.

I have an old table from an old database (Filemaker) where job numbers have already been issued in one field. The numbers represent the job, the subjob, and the county. 0010-01-LE, and may have several subjobs where the number would be 0010-02-LE, 0010-03-LE, 0010-04-LE, and so on. Each county may have a job 0010 and a subjob 01, 02, 03, etc, so you might have 0010-01-LE, 0010-01-HT, 0010-02-LE, 0010-02-HT, and so on. Keep in mind, that these are presently in only one field in a table called JOBS. I’d like to convert this table to an Access table or tables where the Job Number and the subjob number are issued automatically like an autonumber. For instance, if I need a new subjob, which would be subjob 05 for job 0010 in LandsEnd County, I need to be able to pull up job 0010 in LandsEnd and create a new subjob 05. OR, I need a whole new job which is job number 4456 in LandsEnd, or job 1160 in HighTower.

What I’d like to do is:

1. Keep the job numbers (Old Jobs) and subjob numbers (Old Subjobs)
2. Issue new subjob numbers for the old existing Jobs
3. Issue new Job Numbers for any new jobs that we create
4. Issue new Subjob Numbers for any new jobs

If I can’t pick up where I left off, can I cross-reference the old jobs numbers to the new ones somehow? The old job numbers can be set up as primary keys in the tables they are in now.

Please forgive my ignorance. I regret that I’m not very good with macros. Why do I keep getting “Argument not optional” when I try to run this macro? Also, the code changes the .5 (or whatever) to a fraction, but it doesn’t superscript the fraction. Do I run the macro before I do anything and then type the numbers?

dea

Please forgive my ignorance. I regret that I’m not very good with macros. Why do I keep getting “Argument not optional” when I try to run this macro? Also, the code changes the .5 (or whatever) to a fraction, but it doesn’t superscript the fraction. Do I run the macro before I do anything and then type the numbers?

dea

I’m looking for Microsoft Equation in Excel XP (Insert/Object), but I don’t seem to have Microsoft Equation. Any idea where I can find it to load it?

dea

I’m looking for Microsoft Equation in Excel XP (Insert/Object), but I don’t seem to have Microsoft Equation. Any idea where I can find it to load it?

dea

This works great, Steve, except it doesn’t put the fraction in superscript. When I type the number 1.5 (for instance), it changes to 1 1/2, which is a wonderful thing. I want it to change the fraction to superscript, though, and leave the whole number alone. Am I doing something wrong?

This works great, Steve, except it doesn’t put the fraction in superscript. When I type the number 1.5 (for instance), it changes to 1 1/2, which is a wonderful thing. I want it to change the fraction to superscript, though, and leave the whole number alone. Am I doing something wrong?

I have two macros for numbered lists. One starts the list over and the other one picks up where the last list left off. If I have to start at an odd number (for instance, my new list starts with number 5), I type in 5. type my text and when I press [enter] the next line starts at number 6. See if that helps.

I have two macros for numbered lists. One starts the list over and the other one picks up where the last list left off. If I have to start at an odd number (for instance, my new list starts with number 5), I type in 5. type my text and when I press [enter] the next line starts at number 6. See if that helps.

I don’t know why, but I am no longer getting the error message. It seems to have fixed itself for no apparent reason! Thanks for the replies!