Search results for query: *

I can't show a birthday on this report, like this, 8/17/1973. I am told it is against the law. But I can show it like so 3005. So in column a is the birthday field 8/17/1973 In column b is a formual that takes the yr and converts it =dateif(b3,now(),"Y") In column c is a...

Don't do much work in Excel, until now. I have three fields: Coverting a 8/17/73 field into a person's years and months and then taking the two and combining them into one field: In those fields, I am doing a formula to format the output: The years field: Datedif(L3,NOW(),"Y")...

Thanks everyone for your help. All of your answers are right on target!!! THANKS!!!

Doing a report for my boss and right now we are showing the age of a person like this: 8/17/73 My boss informed me legally we can't do this, it has to be in a format like this: 3005 30 means the person is 30 years old and 5 months. Is there anyway in Excel to create some sort of...

Created a form and I don't understand how to do the following. I have a form that has 10 fields and if they DO NOT enter in a number or don't enter anything, it is ignored. How do I write this in code? I don't want an error messasge either, just ignore blanks and non-numeric entries...See...

I'm very new to VB, so right now I want to keep it simple and just do what I have, not get into arrays yet. I only want to work with the code that I have. thanks

New to VB, and I've created a form that has ten entry fields that I only want to accept numbers. If text is entered, a message box pops up, and shifts the focus to the field where the error occured. I don't think the way I have it setup is correct. dbltxt10 = Val(txt10.Text) dbltxt9 =...

I'm converting my departments MS projects over from '98 to 2000. In the process I've updated a resource list project that list all potential resources, their user id, first and last name. All of these people are listed in order by their first name. When converting the projects over, when...

I have a document and I keep getting this error. I tried searching this site, but they are upgrading the search capabilities. I tried to Google it, but could not get a clear answer. Here is the problem: XML Parsing Error: junk after document element Location...

Here is a list of XML website, this is what I meant by information overload :-) http://www.xmlpitstop.com/default.asp?DataType=XML thanks -Chris

I almost feel overwhelmed with all of the info. about XML, so I have to ask. What should I convert an xml document into, so that it can be printed off and presented? HTML or XSL? Or is there a better format? Also, could someone point me to a tutorial online that would show me some of the...

I have never seen this error before. I did an upgrade for my parents from Win '98 to Win 2000. I backed up all of their old data, fdisked the hard drive, formated for NTFS, installed Win 2000, created their user accounts, no problem so far. When installing applications the screen didn't look...

I've moved my parent's pc into my place and I'm lookin' into the problem here. When booting up and seeing the Windows '98 logo, I get this error: A fatal exception OD had occurred at 203F:00000316. The current application will be terminated I don't think that will be much help in...

In my current class, we are using a really think book titled 'A+ Certification' by Mike Meyers. ISBN # 0-07-222274-3. It comes with a cd-rom study guide. Does anyone have an opinion on this book?

I've recently started to prepare for the A+ exam and have set a goal for myself to take it before the end of this year or early next year. Should I worry about the test being changed or updated at all due to the change of the year from 2002 to 2003? I didn't plan it this way, but I am...

Glister, your motherboard example is excellent and a great asset to anyone studying the A+ exam. You get a star for good work. thanks -Chris

This machine is at my parents place who live about 40 minutes away from me, and with me being in college/working fulltime, it is hard for me to troubleshoot it. The exact error message while trying to boot into normal mode, I didn't get but basically it is referrencing some hexadecimal number...

I am trying to troubleshoot an error with my parent's computer. They are running Windows '98 machine with plenty of ram/hd and AMD 500mhz processor. They are not sure if there was a power surge or what, but the machine now boots into a menu that ask a person to choose either safe or normal...

Well it happened again, DNS has failed on my Wind 2002 box. I checked the regedit file again that was referenced above, the MaxCacheEntryTtlLimit and its value is one. I don't know what has happened other than the data light on the modem was flashing on and off and I was losing my internet...

I've forgotten my password and user id on my Linksys BEFSR41 Router. Is there anyway I can reset it back to the default settings? thanks -Chris