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 12.79 seconds.
Search: Posts made by: Rich/rerat
Forum: Running & Setting Up Queries May 25th, 2010, 04:01 PM Posted to microsoft.public.access,microsoft.public.access.queries,microsoft.public.access.tablesdbdesign
Replies: 1
Views: 482
Posted By Rich/rerat
Trying to Siplify a Query in MS Access 2003

I am a real Novice to MS Access 2003. I am trying to create a query to
populate a form to be used as a subform in another form. I have created the
form that use a table view of the a table. But...
Forum: Database Design May 25th, 2010, 04:01 PM Posted to microsoft.public.access,microsoft.public.access.queries,microsoft.public.access.tablesdbdesign
Replies: 1
Views: 467
Posted By Rich/rerat
Trying to Siplify a Query in MS Access 2003

I am a real Novice to MS Access 2003. I am trying to create a query to
populate a form to be used as a subform in another form. I have created the
form that use a table view of the a table. But...
Forum: General Discussion May 25th, 2010, 04:01 PM Posted to microsoft.public.access,microsoft.public.access.queries,microsoft.public.access.tablesdbdesign
Replies: 1
Views: 148
Posted By Rich/rerat
Trying to Siplify a Query in MS Access 2003

I am a real Novice to MS Access 2003. I am trying to create a query to
populate a form to be used as a subform in another form. I have created the
form that use a table view of the a table. But...
Forum: New Users April 18th, 2010, 08:27 AM Posted to microsoft.public.access.gettingstarted
Replies: 1
Views: 522
Posted By Rich/rerat
Trying to combine multiple records into one record in a Query

I originally cross-posted this question in microsoft.public.access.queries &
microsoft.public.access.tablesdbdesign newsgroups, but did not get a
response.

I am new to Access, and very little...
Forum: Running & Setting Up Queries April 13th, 2010, 05:01 PM Posted to microsoft.public.access.queries,microsoft.public.access.tablesdbdesign
Replies: 1
Views: 100
Posted By Rich/rerat
Trying to combine multiple records into one record in a Query

I am new to Access, and very little knowledge about SQL. I read allot about
normalization, need to know if I went to far with it with my Family table.
Here is the structures for the tables I have,...
Forum: Database Design April 13th, 2010, 05:01 PM Posted to microsoft.public.access.queries,microsoft.public.access.tablesdbdesign
Replies: 1
Views: 488
Posted By Rich/rerat
Trying to combine multiple records into one record in a Query

I am new to Access, and very little knowledge about SQL. I read allot about
normalization, need to know if I went to far with it with my Family table.
Here is the structures for the tables I have,...
Forum: General Discussion April 8th, 2010, 03:29 PM Posted to microsoft.public.access
Replies: 5
Views: 118
Posted By Rich/rerat
Attaching a 2003 Access data base to an email for use with Office

TomC,
Have you tried making a "*.ZIP" file from your database file. Then attaching
that to the email message?

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) ...
Forum: Mailmerge March 10th, 2010, 06:02 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 1
Views: 179
Posted By Rich/rerat
How can I print labels on a partial sheet?

Dave U,
Add "blank" records to your data source above your filled out records. When
you select the records for the merge, include the same number of "blank"
records to your merge, as missing/used...
Forum: Installation & Setup March 5th, 2010, 09:30 PM Posted to microsoft.public.outlook.installation
Replies: 4
Views: 345
Posted By Rich/rerat
problems with Yahoo email & sbcglobal internet service

Brian,
There is a third alternative for at least , but may also apply
to . In MS Outlook & MS Outlook Express if you change the web
content of your Yahoo page to "Yahoo...
Forum: Mailmerge February 19th, 2010, 07:41 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 2
Views: 341
Posted By Rich/rerat
Mail Merge Switch Format for Currency

Peter Hibbs,

From G. Mayor site:
Formatting Word Fields:

http://www.gmayor.com/formatting_word_fields.htm

{ MERGEFIELD "BuildingInsured" \# ",0.00;(,0.00 ) }"

--
Forum: New Users December 13th, 2009, 02:41 PM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 127
Posted By Rich/rerat
Retrieving stored names of drop down lists

MZ,
If the range name is located in the workbook, you should find it under:
Insert Name Define Known Lists in Workbook will show.

If the range name is in another workbook, then you will need to...
Forum: Outlook Express November 29th, 2009, 07:54 PM Posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress
Replies: 14
Views: 344
Posted By Rich/rerat
OE6 downloads duplicate AOL messages

N.Miller,
Actually AOL/AIM Mail can be access through POP3, and has been for a few
years now.

See the following webpage for the settings, need to click on link for SMTP &
IMAP settings for...
Forum: Installation & Setup November 13th, 2009, 08:40 PM Posted to microsoft.public.outlook.installation
Replies: 1
Views: 141
Posted By Rich/rerat
My outlook e mail is being forwarded & I want to stop this ?

Chicken Farmer 01,
1. Go to the Email acct's web site, see if there is a rule or setting there
that automatically forwards the messages and turn it off.
2. In Outlook, check any rules that you have...
Forum: General Discussion October 31st, 2009, 08:31 PM Posted to microsoft.public.outlook.general
Replies: 2
Views: 115
Posted By Rich/rerat
Distribution lists

ladybug,
1. Create a new Contact in your Contact folder, such as Ladybug's Friends
2. Use your email address, better yet either get another email address from
Hotmail, or other mail...
Forum: Outlook Express October 30th, 2009, 04:47 PM Posted to microsoft.public.windows.inetexplorer.ie6_outlookexpress,microsoft.public.windowsxp.help_and_support
Replies: 10
Views: 276
Posted By Rich/rerat
Time Stamp problem on Incoming and Outgoing emails

Brad,
Remember this weekend is the end of Daylights Savings Time, so some ISP/Mail
server may have jump the gun, and made the changes to their system already.

--
Add MS to your News Reader:...
Forum: General Discussion October 29th, 2009, 03:02 PM Posted to microsoft.public.outlook.general
Replies: 9
Views: 158
Posted By Rich/rerat
IMAP - emails i send from outlook dont apear in Sent folder

John,

Open Outlook Tools Options General tab Email Options Make sure "Save
copies of message in Sent Items folder", is checked.

If this setting was not checked, then you probably do not have...
Forum: General Discussion October 28th, 2009, 04:43 AM Posted to microsoft.public.outlook.general
Replies: 3
Views: 122
Posted By Rich/rerat
Outlook 2003 attached jpg files

Peter,
Try deleting the temporary internet files in internet explorer.

In XP, there should be something similar if you are using Vista/Windows7:
Control Panel Internet Options General tab Delete...
Forum: General Discussion October 27th, 2009, 10:59 PM Posted to microsoft.public.outlook.general
Replies: 1
Views: 88
Posted By Rich/rerat
Outlook 2003 and comcast (SENT MAIL & Misc Folder Mail download issue)

kathryn,
You will need to move them into the Inbox in the webmail interface. Then run
MS Outlook 2003, and they will be delivered to the Inbox folder in Outlook.
1. If you want to leave these...
Forum: Mailmerge October 21st, 2009, 12:09 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 2
Views: 105
Posted By Rich/rerat
Date keep changing when opened

Frank,
Try inserting the field for the date in the Word document:

{SAVEDATE \*Mergeformat}
OR
{SAVEDATE \@ "MMMM d, yyyy"}

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
Forum: Worksheet Functions October 18th, 2009, 06:24 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 109
Posted By Rich/rerat
calculate the diffrence in cost

Calculate,
Here is a link to a work book for up to ten (10) stations that you can
compare for a month.

http://tinyurl.com/fuel-price-comparisons


--
Add MS to your News Reader:...
Forum: Worksheet Functions September 15th, 2009, 04:59 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 123
Posted By Rich/rerat
Designing master schedule

Kelli,
Here is a template that I created to help you. You can download it at:

http://tinyurl.com/r3r9fu

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message...
Forum: Mailmerge August 16th, 2009, 10:27 PM Posted to microsoft.public.word.mailmerge.fields
Replies: 1
Views: 101
Posted By Rich/rerat
how can I print a long date

SMS,

Add the following format to the Access "Date" field:



\@ "MMMM dd, yyyy"
Forum: New Users July 28th, 2009, 05:15 PM Posted to microsoft.public.word.newusers
Replies: 2
Views: 199
Posted By Rich/rerat
how do I add a strip of phone numbers across the bottom of a poster?

There are also templates for MS Word that you can look at, and decide to
use:
http://office.microsoft.com/en-us/templates/CT101043191033.aspx

--
Add MS to your News Reader:...
Forum: Worksheet Functions July 27th, 2009, 03:20 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 91
Posted By Rich/rerat
Using Networkdays with negative numbers

VainDM,
You're Welcomed.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate
Forum: Worksheet Functions July 24th, 2009, 02:57 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 91
Posted By Rich/rerat
Using Networkdays with negative numbers

If you data is set up like this
Column A Column B Column C Column D
JobID Est Fin Date Fin Date Difference

Enter the following formula in D2, and drag it down Column...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 12:37 AM.


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