Recent content by Rundvelt

Sorry, found the solution after you posted. Apparently I needed to install a loopback adapter to have the server look at itself for the DNS resolution Everything works fine now. Thanks anyways. :D

The wizard cannot contact the DNS server that handles the name “test.domain.rmp” to determine if it supports dynamic update. Confirm your DNS configuration, or install and configure a DNS server on this computer. That's the error message I get when I use the active directory wizard. For some...

Good Morning / Afternoon: I've recently been asked to learn how to handle Microsoft Server 2000 as a step towards being a domain administrator. As part of my learning task, I've chosen to try and build a windows 2000 server and make it a domain controller. I've run into an issue that I can't...

That might be it. IF that's the case I'll probably have to sign the macro to have it work properly. More info to follow when I have it. Thanks, Robert

Good morning. I've put in an Auto_Open macro for my administrative assistants. However, when they use the application, the macro stops working. I have set her macro security to Low to allow the macro to work, however, when she shuts down her computer, the security setting reset. Is there any...

Sorry, bit of clarification. I used an example to represent the situation that is going on (which would have been a much longer and more drawn out explanation.) I know Access is the way to go. The problem is that the users are secretaries (you ask them to shut down the computer and they...

Thanks alot. I appreciate the help. :D

Thanks alot. I appreciate the help. It's a bit over my head, but I'll try and figure it out. Thanks.

I was wondering if anyone knew the Excel equations that would make this work... Let's say I have a sheet called Database. In database I have over 2000 lines of information about orders (containing delivery dates, order numbers, quantity, shipping costs, etc.) Now, in addition to the Database...

Actually, nevermind, took a low tech approach... Find: =ISN Replace: ISN Find: (INFOR Replace: ("INFOR Find: )) Replace: ")) Find: ISN Replace: =ISN Low tech but it works really quick. Sorry for the post without thinking it through

I was trying to use excel's find and replace wildcards. For example... Find: =ISNUMBER("INDIRECT(INFORMATION!$A$*")) Replace: =ISNUMBER("INDIRECT(INFORMATION!$A$*")) That's just an example of course, it doesn't actually work. I'm fairly new to the whole "IT" world, so any help you'd be...

One last question if you'd be so kind. I have about 60,000 entries I need to modify. How can I do it quickly (Can't cut and copy)

Actually, that didn't work. I inserted a column on the other sheet and it modified the formulas. Inserted a line below 13. Making a new 14 and moving one down to 15. On the equation sheet, line 13 remains 13, but line 14 now has the =isnumber(indirect(sheet1!$A$15)) Excel still seems to be...

Sorry, how would I use that in an equation. For example if I needed the equation =ISNUMBER(Sheet1!$A$1) Thanks.

We have secretaries. They use Excel to enter data about appointments. These databases somehow break the mail merge link every so often, be it a DDE error or word crashing or it just not showing up (it's a whole miriad of problems, not just one consistant error). These errors, because they are...