Search results for query: *

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")...

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...

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...

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 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...

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...

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

Recently on my Windows 2000 pro box, I am unable to pull up any web pages thur any browser. I have a LAN and both of my Linux boxes could still get out to the web, so I knew it wasnt the router or the cable modem. So, I called my ISP's tech support and we worked thru it for an hour before I...

I'm not sure if this has been asked, I've done a search and nothing came up, so I'm sorry in advanced. What else can I do to keep my WIndows 2002 Pro. box up and running ok? I run the defrag everyday and that seems to help, but what else can I do? Is there anything else to clear out memory...

I've created a database based off of three tables that tracks what I buy for groceries. There is a main table which tracks the item and then the price and the location. I've set it up under the index on each table to allow for duplications. When I enter in a duplicate entry into a form...

When creating a form from many tables, is it possible to order the tabs? I've created a form using three tables, that are linked together, but for some reason under view/tab order it only shows two of the tables. Two of the tables have to show up as subforms or, this is leading up to my next...

I've seen some examples on some forms where a person can click a button and the calendar appears and that person can select a date and it writes to whatever field/table. Can anyone provide a simple example of how to code this thru VBA? thanks -Chris

When clicking on the mdb icon to start whatever Access DB, I always get this error output: "The command line you used to start Microsoft Access contains an option that Microsoft Access doesn't recoginze. Exit and restart Microsoft Access using valid command-line options" Is this...

I've searched previous post on here for Table Relationship design. There are some things that I understand and I think that I would have a better understanding for the whole scheme of things, if I posted what I am working on here and had some help/input on it. I work in HR, and we keep track...

Looking to take the next step with Access and I see the O'Reilly has two books on it: Access Cookbook and Access Database Design and Programming. Does anyone on here have these and can they say what they liked or didn't like with either one of these books? thanks -Chris

Trying to get back into C++ and doing about an hr of programming on it for each day. I've writing a simple program where an end user inputs three #'s, and the output is a sum, product, and then it compares the three to see what is the largest and the smallest. When I go to compile, I get an...