Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku
My account: Login | Sign Up
Loading... 

Microsoft Office (Excel, Word) forum -... - www.officefrustration.com | Site profile

Site profile page for http://www.officefrustration.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://www.officefrustration.com. This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional site profile information for http://www.officefrustration.com is also shown in the following divisions:

1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.

Title: Microsoft Office (Excel, Word) forum - OfficeFrustration - http://www.officefrustration.com Microsoft Office (Excel, Word) forum - OfficeFrustration
Url: http://www.officefrustration.com
Users activity: 3 posts per thread
site activity: 4,010 active threads during last week
Site rank: 226 (go to rank page)
Domain info for: officefrustration.com
 

Posting activity table on Microsoft Office (Excel, Word) forum - OfficeFrustration:

  Week Month 3 Months
Threads: 4,010 15,839 42,774
Post: 10,899 47,140 111,648
 

Authority Badge:

Microsoft Office (Excel, Word) forum - OfficeFrustration | Forum Authority Badge

Microsoft Office (Excel, Word) forum - OfficeFrustration posting activity graph:

Posts by:  day  week  month 
 

http://www.officefrustration.com Alexa graph:

Top authors on Microsoft Office (Excel, Word) forum - OfficeFrustration during last week:

Name
Posts
Shane Devenshire[_3_]
280
user's latest post:
vlookup vs sum
Published (2009-07-08 23:54:00)
Hi, These two functions don't serve the same purpose, they are not interchangeable. Suppose the entriy that you want returned from the other sheet changes. Then if you are using SUM you will need to reenter it or edit it. If VLOOKUP is correctly used it means the formula will be more dynamic and flexible and you won't need to modify it. Also, if you are simply referencing 1 cell, SUM is not the correct approach, just type = and...
Diane Poremsky [MVP]
272
user's latest post:
Auto archiving
Published (2009-07-08 23:12:00)
File, Data file management, open folder button - do you see archive.pst ? -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: EMO - a weekly newsletter about Outlook and Exchange: Let's Really Fix Outlook 2010 http://forums.slipstick.com/forumdisplay.php?f=34 "tta" wrote in message ... I can't find...
Jacob Skaria
220
user's latest post:
How do I insert hyperlinks in...
Published (2009-07-08 17:11:00)
By formatting cells to "" what ever data you put in will not be displayed.. If this post helps click Yes --------------- Jacob Skaria "VROSARIO7" wrote: Now do I have to remove the "" once I actually enter the data in the adjacent cell? This goes for both the '0' entry and the 'False' entries that I used this on. Thanks so much! "David Biddulph" wrote:...
Roady [MVP]
179
user's latest post:
Getting spam using MY email...
Published (2009-07-08 20:35:00)
In general the Junk E-mail filter will already catch these emails. A common cause for this not happening is by having your own name in the Trusted Senders list. Otherwise, you could still create a rule that looks at the address and not the display name. -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real...
Brian Tillman [MVP - Outlook]
175
user's latest post:
Restricting Folder Access
Published (2009-07-08 20:11:00)
"Christina Biddle" Christina
T. Valko
168
user's latest post:
Countif, multiple criteria
Published (2009-07-08 22:55:00)
You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "JS25" wrote in message ... That is great, thank you so much You're a genius, bravo bravo Once again, I thank you! "T. Valko" wrote: Try this: =--AND(COUNT(A1:B1)=2,A1=0,B11) Copy down as needed. -- Biff Microsoft Excel MVP "JS25" wrote in message ... Certainly: 'A' 'B' Expect Result - 0 0 0...
Suzanne S. Barnhill
167
user's latest post:
Change format of check boxes
Published (2009-07-08 16:04:00)
Do you just need to remove table borders? Use Ctrl+Alt+U. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "ginble07" wrote in message ... I created a form in Word 2007 using tables. One section of the form is a grid with a check box in each cell. Is there a way to remove the border around the check box? Right now the form looks a bit cluttered because of the...
John W. Vinson
147
user's latest post:
Simplified table creation
Published (2009-07-08 23:57:00)
On Wed, 8 Jul 2009 14:49:02 -0700, MaryJC wrote: I have an Excel file with a long list of variable names I want to use to create a table in Access. Is there somewhere I can paste them into the table design all at once so I don't have to type or paste them in individually? You can open Access and use File... Get External Data... and either Import or Link to the spreadsheet. Choose Excel from the "files of type" dropdown....
Graham Mayor
143
user's latest post:
How do I display file name in...
Published (2009-07-08 14:28:00)
The following macro will copy the full name and path of the current document to the clipboard Sub CopyFileNameAndPath() Dim dFname As DataObject Dim fFname As String Set dFname = New DataObject With ActiveDocument If Len(.Path) = 0 Then .Save fFname = .FullName End With dFname.SetText fFname dFname.PutInClipboard End Sub http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site...
Jeff Boyce
118
user's latest post:
Carriage Return on Access Report
Published (2009-07-08 23:56:00)
Roight! (what's an intrinsic?) Jeff "Douglas J. Steele" wrote in message ... Yes, intrinsic constants (such as vbCrLf) can only be used in VBA. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Jeff Boyce" wrote in message ... Thanks, Doug. I just can't seem to remember which works and which doesn't. The vbCrLf is reserved for VBA, right? Regards Jeff...
 

Top 10 active forums on Microsoft Office (Excel, Word) forum - OfficeFrustration during last week:

General Discussion - 1,595 new posts General Discussion - forum profile
Worksheet Functions - 1,494 new posts Worksheet Functions - forum profile
General Discussion - 1,417 new posts General Discussion - forum profile
General Discussion - 1,273 new posts General Discussion - forum profile
General Discussion - 1,179 new posts General Discussion - forum profile
Running & Setting Up Queries - 697 new posts Running & Setting Up Queries - forum profile
General Discussions - 667 new posts General Discussions - forum profile
Powerpoint - 656 new posts Powerpoint - forum profile
Using Forms - 533 new posts Using Forms - forum profile
Setting Up & Running Reports - 338 new posts Setting Up & Running Reports - forum profile
 

Top 10 forums on Microsoft Office (Excel, Word) forum - OfficeFrustration:

General Discussion - 39,107 posts General Discussion - forum profile
Worksheet Functions - 35,839 posts Worksheet Functions - forum profile
General Discussion - 34,246 posts General Discussion - forum profile
General Discussion - 32,259 posts General Discussion - forum profile
General Discussion - 28,930 posts General Discussion - forum profile
Running & Setting Up Queries - 20,409 posts Running & Setting Up Queries - forum profile
Powerpoint - 18,667 posts Powerpoint - forum profile
Using Forms - 18,417 posts Using Forms - forum profile
General Discussions - 17,899 posts General Discussions - forum profile
Setting Up & Running Reports - 13,472 posts Setting Up & Running Reports - forum profile

Latest active threads on Microsoft Office (Excel, Word) forum - OfficeFrustration:

Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 8 hours, 27 minutes ago (2009-07-09 16:06:00)  by Steve
Hi I send email to hotmail accounts, they go but do not arrive and no fail notice returned Steve
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (3 posts) Thread info: sending email to hotmail Size: 178 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "sending email to hotmail :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 13 hours, 16 minutes ago (2009-07-09 11:17:00)  by Twisty
I need to count lines/posts in i a report. The report shows dates or "no dates" (empty fields). I need a "Total-line" in the bottom of the report, which shows how many times a date is shown in a column in the report. I need this for two colums in the report.
Forum:  Running & Setting Up Queries Running & Setting Up Queries - forum profile
Thread:  Show this thread (9 posts) Thread info: Counting posts Size: 411 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Counting posts :: Running & Setting Up Queries :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 hours, 3 minutes ago (2009-07-09 20:30:00)  by ewall
need some assistance with creating a resume for a ministry. would i format the same way that a regular resume would?
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (2 posts) Thread info: how do i write a pastoral resume Size: 196 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "how do i write a pastoral resume :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 hours, 3 minutes ago (2009-07-09 20:30:00)  by Diane Busch
Using PowerPoint 2003. Why, after inserting a movie, does a black box appear sometimes, and other times, a still image of the video? I need the still image - not the box. I placed a still image picture over the movie and have it disappear a second before the movie starts, but I do not like doing that because I eventually convert my powerpoints to flash videos and it's not a smooth ...
Forum:  Powerpoint Powerpoint - forum profile
Thread:  Show this thread (1 post) Thread info: Inserting Movies: Black Box vs. Still Image Size: 843 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Inserting Movies: Black Box vs. Still Image :: Powerpoint :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 7 hours, 38 minutes ago (2009-07-09 16:55:00)  by songinthedark
I am working with Word 2003. I have auto-numbered heading styles used throughout my document to number the different sections. The styles are all formatted the same way (Times New Roman, bold, 14 pt) but the section numbers change based on the heading level used (1, 1.1, 1.1.1 etc) I generated a ToC based on heading styles in order to show the section numbers, the heading text and...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (4 posts) Thread info: Table of Contents problem Size: 783 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Table of Contents problem :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 hours, 22 minutes ago (2009-07-09 20:11:00)  by Parker Jones
I need a formula that says something to the effect of: IF the value in H=1 THEN transfer said row to sheet 2 IF the value in H=2 THEN transfer said row to sheet 3 etc. I need all the information in the row to transfer, and have no idea how to do it.
Forum:  New Users New Users - forum profile
Thread:  Show this thread (3 posts) Thread info: transfering data between sheets Size: 373 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "transfering data between sheets :: New Users :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 hours, 29 minutes ago (2009-07-09 20:04:00)  by hissmith
I'm attempting to change the font in Speakers Notes when creating my Power Point Presentation to Times New Roman to comply with APA format to download to my professor. It seems to keep defaulting to Calibri no matter how many times Times New Roman is showing up in the font box. Any suggestions.=?
Forum:  Powerpoint Powerpoint - forum profile
Thread:  Show this thread (2 posts) Thread info: APA format Size: 393 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "APA format :: Powerpoint :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 hours, 14 minutes ago (2009-07-09 20:19:00)  by Jamie Dickerson
I have a combo box on a form with two columns. The first is a numeric representation of the text values in the 2nd. I need the first column to run a Dlookup but I want the text value to be entered into the table. I have tried changing the bound column to the second but then the Dlookup does not work as it is looking or numbers. Is there anyway to use column1 for the lookup but use ...
Forum:  Using Forms Using Forms - forum profile
Thread:  Show this thread (2 posts) Thread info: Multi-Value Combo Box Size: 535 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Multi-Value Combo Box :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 hours, 8 minutes ago (2009-07-09 20:25:00)  by Bons
Hi! I don't know if you ever got your issue with your AOL contacts into Outlook working or not---BUT I just did it the "old fashioned way"---I copied and pasted into Excel. This is NOT a simple process and if you've not imported from Excel, that in itself is a learning process....but if you're familiar with it, it works like a charm! None of the other suggestions here worked for me....
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (1 post) Thread info: How do Import contact information (email addresses) from aol? Size: 1,166 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How do Import contact information (email addresses) from aol? :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 2 days, 1 hour ago (2009-07-07 22:44:00)  by Kathy
On multiple Windows XP Pro pcs, with Office/Word 2007, I can't get the Auto-text to work for the dates. I start typing in the first 4 letters of the month on some machines and get a pop-up saying to press Enter to enter the date. i.e. July 7, 2009. On other machines with the same build, you have to type the entire date in, or use Insert/ Date/Time. If someone can tell me why ...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (8 posts) Thread info: Auto-text for date not working Size: 603 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Auto-text for date not working :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
 

Hot threads for last week on Microsoft Office (Excel, Word) forum - OfficeFrustration:

Worksheet Functions
Started 3 days, 16 hours ago (2009-07-06 08:13:00)  by Cloud Strife
Hi, I'm currently stucked in my assignment, coz i need 2 do smtg like this. Currently I have a cell is General Manager, so I need to use a formula to find out manager can hav 15% deducted, so wat formula can I use?
Forum:  Worksheet Functions Worksheet Functions - forum profile
Thread:  Show this thread (44 posts) Thread info: Wat formula shuld i use to find the details in the cell? Size: 345 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Wat formula shuld i use to find the details in the cell? :: Worksheet Functions :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
New Users
Started 2 days, 1 hour ago (2009-07-07 23:17:00)  by Hedwig14
I have a table that shows the company name, start date, id number and a check box (yes/no) fields. My report currently allows me to select the month I want to report on but I need for it to only select those records in that month that have a check mark (yes) in the field. I hope you understand what I am trying to say. Thanks in advance
Forum:  New Users New Users - forum profile
Thread:  Show this thread (40 posts) Thread info: Need report to only select the "yes" based on month Size: 444 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Need report to only select the "yes" based on month :: New Users :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Running & Setting Up Queries
Query to add totals - 30 new posts
Started 1 week ago (2009-07-02 15:48:00)  by jenksonu
my table is called employes. In this table I have fields called NAME JAN FEB MAR throu DEC and YTD I'm wanting a query that will update YTD with the total combined numbers from each Month Thanks in advance for your help
Forum:  Running & Setting Up Queries Running & Setting Up Queries - forum profile
Thread:  Show this thread (30 posts) Thread info: Query to add totals Size: 327 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Query to add totals :: Running & Setting Up Queries :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
General Discussion
Started 5 days, 22 hours ago (2009-07-04 02:20:00)  by NDBC
I think I've left the hardest question to last. See data below H I J K L M N O P..... Name No lap1 lap2 lap3 lap4 lap5 lap6........ 5 Name / Name 100 0:00:08 6 Name / Name 101 0:00:10 0:00:18 7 Name / Name 102 0:...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (26 posts) Thread info: Sorting rows of data of varying lengths Size: 1,691 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Sorting rows of data of varying lengths :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Setting Up & Running Reports
Started 5 days, 8 hours ago (2009-07-04 15:49:00)  by Laurel
I have a report based on a SQL statement. The report is fairly old, but now I want to add columns to the SQL statement. Most of the time this is what happens. 1 - I go to the SQL statement via properties/datasource (probably the only way) 2 - I add the columns. I can see them in both the SQL View and the Design View. Sometimes I explicitly SAVE, and sometimes I wait for the ...
Forum:  Setting Up & Running Reports Setting Up & Running Reports - forum profile
Thread:  Show this thread (26 posts) Thread info: Can't add columns to report's SQL statement Size: 1,288 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Can't add columns to report's SQL statement :: Setting Up & Running Reports :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Calendar
Started 1 year, 2 months ago (2008-04-23 15:35:00)  by Jim Scaroni
When trying to enter a new appt, I now get an error message "The form required to view this message cannot be displayed. Contact your administrator" This just started happening and it won't allow me to enter appts. Any help is appreciated! -- Jim S
Forum:  Calendar Calendar - forum profile
Thread:  Show this thread (27 posts) Thread info: Calendar 2003 Error Message Size: 429 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Calendar 2003 Error Message :: Calendar :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Database Design
Started 1 week ago (2009-07-02 20:29:00)  by BKC468
I'm setting up a new database for all of the Projects that I have and subsequently I need to track the employees involved with each project. I started out creating a table of employees (( Empl ID (Primary), Fr Name, Lst Name, Title, Function, Manager, Pay Rate.)) Then I created a table for the projects ((Proj ID (Primary), Description, Type, Proj Value, Begin and End Proj Dates )) ...
Forum:  Database Design Database Design - forum profile
Thread:  Show this thread (24 posts) Thread info: New Db Setup Tables/Forms Size: 1,114 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "New Db Setup Tables/Forms :: Database Design :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Database Design
Started 1 week, 2 days ago (2009-06-30 13:59:00)  by adrian007uk
I have read up on best practice conerning displaying images in a database. I am planning to link the images from my PC. What i would like to know is if the location of ther folder where the images are stotred changes (e.g., from 'C' to 'D') is there any way it can be changed within the database quicly without having to change every image location as well? Thanks in advance for any...
Forum:  Database Design Database Design - forum profile
Thread:  Show this thread (27 posts) Thread info: Pictures/Images in Tables Size: 525 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Pictures/Images in Tables :: Database Design :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
General Discussion
Started 2 days, 1 hour ago (2009-07-07 22:41:00)  by cmc096
I have created several tables that all have data that is similar: name, address, phone number and other data. The problem is they do not really have any unique data to be set as the PK. What I have done in order to attempt to correct the problem is set an autonumber field for each table and use that as the PK. I set the relationships up using this field. The problem I am having is if I...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (23 posts) Thread info: Autonumber as Primary Key and Relationships Size: 674 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Autonumber as Primary Key and Relationships :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
General Discussion
Started 1 week, 2 days ago (2009-07-01 00:05:00)  by Jack Cannon
I have an application developed in Access 2002. It also works fine in Access 2003. However when I migrate to Access 2007 I run into a strange problem. The MDB file works correctly but I get strange error messages when I run the MDE file in Access 2007. The first of several error messages that appear states: Function is not available in expressions in query expression ... The ...
Forum:  General Discussion General Discussion - forum profile
Thread:  Show this thread (22 posts) Thread info: MDE problem in Access 2007 Size: 978 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "MDE problem in Access 2007 :: General Discussion :: Microsoft Office (Excel, Word) forum - OfficeFrust..."