A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 7.20 seconds.
Search: Posts made by: Mark
Forum: General Discussion June 7th, 2010, 06:52 AM Posted to microsoft.public.outlook.general
Replies: 2
Views: 478
Posted By Mark
BLocking links in messages

When there is an email with a link to the internet I get the following message.

This operation has been canceled due to restrictions in effect on this
computer. Please contact your system...
Forum: General Discussion June 2nd, 2010, 09:47 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 410
Posted By Mark
Linking to Access table

Hi. Similar to a poster earlier today, I'm creating a Pivot Table based on
data in an Access database. When I link to my database, in the Select Table
dialog box I see my tables and one query,...
Forum: General Discussion May 28th, 2010, 08:57 AM Posted to microsoft.public.outlook.general
Replies: 1
Views: 359
Posted By Mark
How can I add shared tasks to the Outllook to do list ?

I have an additional Shared mailbox in my outlook profile which I need to
keep track of the tasks. Is there a way in which I can add the "shared tasks"
to my outlook to do list?
Forum: General Discussion May 20th, 2010, 07:13 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 211
Posted By Mark
Leave "formula cell J7" empty until H7 has a date.

I have the following formula in cell J7

=DATE(YEAR(H7),MONTH(H7)+6,DAY(H7))

This gives me a date in J7 that is 6 months forward from the date I will
enter in H7.

I would like J7 to stay empty...
Forum: Using Forms May 20th, 2010, 04:05 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 400
Posted By Mark
ComboBox formatting

Hi All,

In a query I formated a field to allow the sorting to come out in sequence.
x = 4
Number: format(x,"000000")

I have combo box based on this query and I would like to be able to type in
4...
Forum: Worksheet Functions May 18th, 2010, 10:36 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 102
Posted By Mark
Pivot Item Displaying Incorrect Value?

best I can tell, someone must have manually typed the 616 accidentally, and
the pivot table is set to accept/display that.

I guess.
Forum: Worksheet Functions May 18th, 2010, 10:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 89
Posted By Mark
Difference Between Dates WITH Conditional Formatting

for starters, try taking out the () in yoru C2() formula.

The () is a call to a formula, but C2 is a cell addres, not a formula

"DOUG" wrote:

I want cell C2 to turn RED if it is more than two...
Forum: Worksheet Functions May 18th, 2010, 09:56 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 102
Posted By Mark
Pivot Item Displaying Incorrect Value?

We have a pivot table, which has Project as pivot field 4.

The Project pivot field has 3410 pivot items, of which number 842 is
misbehaving.

The project value for this item is 10537 , and when you...
Forum: Worksheet Functions May 17th, 2010, 07:14 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 101
Posted By Mark
how do I attach a jpeg to a cell

I am trying to have a button or link in a cell that when clicked will open up
a jpeg that is also attached to (part of) the excel file.
Forum: General Discussion May 16th, 2010, 09:26 AM Posted to microsoft.public.outlook.general
Replies: 2
Views: 172
Posted By Mark
email signature

copying and pasting a new email signature and picture not visible on outgoing
mail but wording is ..could i have changed picture configurations by mistake?
Forum: General Discussion May 14th, 2010, 02:24 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 103
Posted By Mark
Input Box

Can someone show me how to use VBA to collect part of a folder and file name
from an input box?

e.g. Const CSVFile As String = "Z:\FILES\ACCOUNTING\PAYROLL\DAILY PROGRESS
REPORTS (DPRs)\WE...
Forum: General Discussion May 12th, 2010, 09:49 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 327
Posted By Mark
Excel File search function

Can anyone suggest how to search for a numeric value randomly across a
specific network drive to come up with the file it resides in ? I have two
laptops with office 2003 . One will search a...
Forum: Database Design May 12th, 2010, 07:41 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 543
Posted By Mark
Table design question

Hi All,

I just wanted to see if the design of some fields in the table are standard
practice.

The database admin set up a Code_Desc table with fields Code_Type_ID,
Code_Value and...
Forum: Installation & Setup May 11th, 2010, 06:47 PM Posted to microsoft.public.outlook.installation
Replies: 8
Views: 745
Posted By Mark
Outlook 2003 Not Connecting Over VPN with Windows 7

Cached mode normally. I did try with cache disabled, but as soon as I open
Outlook it gives Microsoft Exchange Server is unavailable error.
Only thing left that I can thing of trying is an update...
Forum: Installation & Setup May 11th, 2010, 12:59 PM Posted to microsoft.public.outlook.installation
Replies: 8
Views: 745
Posted By Mark
Outlook 2003 Not Connecting Over VPN with Windows 7

No error messages at all and nothing in the event viewer. The only visable
sign is the outlook status shows connecting briefly then disconnected.

If I try to create a new profile over the VPN...
Forum: General Discussion May 10th, 2010, 09:00 PM Posted to microsoft.public.outlook.general
Replies: 0
Views: 103
Posted By Mark
Outlook 2003 Not Connecting Over VPN with Windows 7

Just set up a Windows 7 notebook with OUtlook 2003 connecting to Exchange
2003. All current service packs are installed.

When the notebookd is connected locally, outlook connects to exchange and...
Forum: Installation & Setup May 10th, 2010, 06:40 PM Posted to microsoft.public.outlook.installation
Replies: 8
Views: 745
Posted By Mark
Outlook 2003 Not Connecting Over VPN with Windows 7

Just set up a Windows 7 notebook with OUtlook 2003 connecting to Exchange
2003. All current service packs are installed.

When the notebookd is connected locally, outlook connects to exchange and...
Forum: General Discussion May 4th, 2010, 04:24 AM Posted to microsoft.public.outlook.general
Replies: 9
Views: 154
Posted By Mark
Outlook Connector Update for Outlook 2007

I am experiencing the same thing, and, I cannot use Outlook 2007 to access
new .msn EMail messages.

"Sam C" wrote:

When I open outlook 2007 I am prompted to upgrade my outlook connector to
...
Forum: General Discussion May 4th, 2010, 04:23 AM Posted to microsoft.public.outlook.general
Replies: 3
Views: 161
Posted By Mark
Outlook Connector Issue...solved here for us.

This update did not solve the Outlook Connector 'upgrade' looping problem.
Still prompted to 'upgrade' connector. Still cannot use Outlook 2007 to read
my .msn EMail messages.

"Ironman" wrote:

...
Forum: General Discussion May 4th, 2010, 04:21 AM Posted to microsoft.public.outlook.general
Replies: 3
Views: 159
Posted By Mark
Is your microsoft office outlook download update looping?

Yes, I am experiencing same thing.

"lambeau" wrote:


--
PackersFAN
Forum: General Discussion May 4th, 2010, 04:14 AM Posted to microsoft.public.outlook.general
Replies: 9
Views: 223
Posted By Mark
Outlook connector prompting to upgrade

I experienced the exact same phenomena this afternoon at 5:00. I was prompted
to 'upgrade' to the new Outlook Connector. Endless loop resulted and Outlook
2007 can no longer access new .msn EMail....
Forum: General Discussion April 28th, 2010, 06:43 PM Posted to microsoft.public.outlook.general
Replies: 1
Views: 103
Posted By Mark
Save Attachment and deletes the email

Is it possible to set up a rule that will save the attachment to a specified
directory delete the original email
Forum: General Discussions April 27th, 2010, 02:09 AM Posted to microsoft.public.office.misc
Replies: 2
Views: 144
Posted By Mark
Office Default Mail Client

I removed the beta version of microsoft office and installed the MSDN version
this weekend but I can not set the defalut mail client as Outlook. It will
not let me edit it in outlook or through...
Forum: Running & Setting Up Queries April 19th, 2010, 06:23 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 137
Posted By Mark
export query with formulas to excel

Is there a way to export my Access query to Excel 2003 while keeping the
formulas in Excel. For example, in my Access query I have a field called
"Other" which is defined as the following:

Other:...
Forum: Using Forms April 15th, 2010, 08:17 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 114
Posted By Mark
Combo Box Search

Hi

I am fairly new to access and have just created a large database for work.
The only way I have found to search the records is through a combo box. I am
trying to browse people by surname. I...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.