Search results for query: *

Appreciate the help. I was able to manipulate that to what I needed. Thanks again!

I'm looking to make a macro that takes data in column A and seperate it into three columns. I'm able to do it by setting up the macro manually, but is there a way to loop it to do it automatically as long as there is information in column A...

Sorry John, That didn't do exactly what I needed b/c the D5 will not always be a negative number. This is pretty much what I'm looking to do, but all in one statement. ------------------ IF D5>0 Then H5 > D5 Then I5 = E5 or H5 < D5 Then I5 = 0 or H5 = D5 Then I5 = 0 Or IF D5<0 Then H5 >...

I guess I didn't explain it too well did I, haha. A B C D E F G H I 3 Team A 19 -2 ??? 4 at Team B 8/1/06 -7.5 1 21 2 ??? 5 Team C -7.5 1 15 8 ??? 6 at Team D...

Is there a way to have two If Functions running together. The second one is attempting to place an greater than or less than equation into the first If loop based on if a specific cell contains a negative or positive number. ie This is what mycurrent attempt has produced, but doesn't work, the...

Thanks! I will see if this helps at all.

2002

Does anyone have an idea why a movie file won't run on one persons computer but run on anothers. I have a presentation with 4 media clips attached to it, the presentation runs flawlessly on my computer and anothers, but will not run others. I'm dumbfounded. Thanks for any ideas in advance.

Is there a way to take 11 seperate reports and combine them into one continuous report (the reports each have different fields). report1 followed by report2 and then report3, etc all are apart of reportall. The program was originally set up to print off all 11 reports, but the user now wants...

Thanks Duane, That worked perfectly. I really appreciate the help!!

That centers it horizontally, I want to do it vertically like this: ----------------------- john smith abcd lane washington, dc 45642 ----------------------- not this: ----------------------- john smith abcd lane washington, dc 45642 -----------------------

I have a report that prints out 10 Labels to a page and some information doesn't take up the whole Label, so I was wondering if there was a way to vertically center the information so that the whitespace isn't so drastic. You can do it in Excel, but I can't seem to figure out a way to do it in...

Figured it out.. Can Shrink Property in the Detail Section was set to "NO", needed to be "YES". Thanks for the help hneal98

Lines It will Look like this Bob 2034 W st arlington, va 22202 703-656-6456 703-646-6456 Bob@Bob.com ------------------------- Kevin 2034 W st arlington, va 22202 703-656-6456 703-646-6456 Kevin@Kevin.com Instead of Kevin starting just after the break line

No

In a report I have a bunch of personal information for multiple people. They are listed in such a fashion: Name Address1 Address2 Address3 CityStateZip HomePhone WorkPhone1 WorkPhone2 etc... When information isn't present I have the textboxes become invisible and the information then moves...

I had been using that format.. But I did figure it out or found a way to get what I wanted. I made Month[Birthday] in the query visible.. took out the sort in the query, and in the sort of the report made the visible Month[Birthday] my main sort criteria. While I was doing almost the same...

This is my SQL statement for the Query: SELECT tblInformation.Birthday, tblInformation.Rank, tblInformation.FirstName, tblInformation.LastName FROM tblInformation WHERE (((tblInformation.Birthday) Is Not Null) AND ((tblInformation.CurrentEmployee)=True)) ORDER BY Month([Birthday])...

In a birthday report, I am sorting the birthdays by month. In the group header I have this as the format of the text box: =Format([txtBirthday],"mmmm") The information being brought in is from a query and is being sorted/grouped by this action: =Month([Birthday]) =DatePart("d",[Birthday]) Those...

I figured that out right after I sent that last reply. thanks for your help!