|
More site info...
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.
|
|
|
|
|
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:
|
|
|
BoardReader Authority Badge code for Microsoft Office (Excel, Word) forum - OfficeFrustration (http://www.officefrustration.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Microsoft Office (Excel, Word) forum - OfficeFrustration posting activity graph:
|
|
http://www.officefrustration.com Alexa graph:
|
Top authors on Microsoft Office (Excel, Word) forum - OfficeFrustration during last week:
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...
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...
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:...
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:
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...
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...
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....
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...
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:
|
|
Top 10 forums on Microsoft Office (Excel, Word) forum - OfficeFrustration:
General Discussion
- 39,107 posts
|
Worksheet Functions
- 35,839 posts
|
General Discussion
- 34,246 posts
|
General Discussion
- 32,259 posts
|
General Discussion
- 28,930 posts
|
Running & Setting Up Queries
- 20,409 posts
|
Powerpoint
- 18,667 posts
|
Using Forms
- 18,417 posts
|
General Discussions
- 17,899 posts
|
Setting Up & Running Reports
- 13,472 posts
|
|
|
|
|
Latest active threads on 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
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.
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?
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 ...
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...
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.
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.=?
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 ...
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....
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 ...
|
|
Hot threads for last week on Microsoft Office (Excel, Word) forum - OfficeFrustration:
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?
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
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
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:...
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 ...
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
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 )) ...
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...
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...
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 ...
|
|
Size: 178 bytes
