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 30
Search took 1.58 seconds.
Search: Posts made by: Dominic
Forum: Database Design May 28th, 2010, 02:53 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 621
Posted By Dominic
Populate a new field in an existing table

Thank you for the advice guys. The information in the field isn't available
elsewhere.

Dorian, the query worked perfectly, and thank you for the heads up on spaces
in column names. This has now...
Forum: Database Design May 27th, 2010, 09:59 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 621
Posted By Dominic
Populate a new field in an existing table

Hi all

Access 2003:

I have an existing Access table, containing 10,000+ rows called "Printing"
and I have decided to insert a new column called "Financial Year". However,
I am struggling of...
Forum: Setting Up & Running Reports January 31st, 2010, 08:51 AM Posted to microsoft.public.access.reports
Replies: 4
Views: 149
Posted By Dominic
Count distinct lines in a report

Hi John

I see what you mean now about the work order numbers - the second example is
more how my data is arranged, for no particular reason, just that the
original imported data is sorted by...
Forum: Setting Up & Running Reports January 30th, 2010, 11:33 AM Posted to microsoft.public.access.reports
Replies: 4
Views: 149
Posted By Dominic
Count distinct lines in a report

Hi John

Thanks for taking the time to answer.

I have a simple database table recording production - a list of work orders
(that may appear more than once) and against each order the machine ID,...
Forum: Setting Up & Running Reports January 29th, 2010, 09:14 AM Posted to microsoft.public.access.reports
Replies: 4
Views: 149
Posted By Dominic
Count distinct lines in a report

Hi all

I have a simple Access report that lists work order numbers, along with
various information against this order number. An individual order number
may appear more than once in this...
Forum: Powerpoint September 14th, 2009, 07:48 PM Posted to microsoft.public.powerpoint
Replies: 33
Views: 1,070
Posted By Dominic
PowerPoint 2007 crashes when moving Pie Chart

Same issue here...if I click multiple times on a chart in powerpoint it hangs
and I have to shut it down. ON the phone with MS now and its not getting me
anywhere.

"Jason D" wrote:

I have a...
Forum: General Discussion August 8th, 2009, 05:57 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 99
Posted By Dominic
Can I set a file to auto-open and save at each month begin dat

Appreciate the help!

"Gord Dibben" wrote:

See Chip Pearson's site for OnTime method.

http://www.cpearson.com/excel/OnTime.aspx

Here is an example using Chip's procedures.
Forum: General Discussion August 8th, 2009, 02:06 AM Posted to microsoft.public.excel.misc
Replies: 9
Views: 99
Posted By Dominic
Can I set a file to auto-open and save at each month begin dat

Thanks for the solution! Got the task scheduler to open the file, but how to
I employ the workbook event code to close and save?

"Gord Dibben" wrote:

Windows Task Scheduler can start Excel with...
Forum: General Discussion August 7th, 2009, 05:01 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 99
Posted By Dominic
Can I set a file to auto-open and save at each month begin dat

Well, let's just use TODAY() as an example. I save the file now, but want to
auto-open and save the file at midnight so the date on the file shows the
change in the date.

The need for this is...
Forum: General Discussion August 7th, 2009, 04:11 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 99
Posted By Dominic
Can I set a file to auto-open and save at each month begin date?

Want the excel file to open so the date-dependent formulas refresh to the new
month. Then save the file. Can this be done?
Forum: Setting Up & Running Reports April 15th, 2009, 04:22 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 89
Posted By Dominic
Ask the user to select report parameters

Hi Marshall

That's great. I will use the "crude" way for now, but using the fancy form
sounds like a great idea and is definitely the way to go.

Thanks for the tips and your time.

Dominic
Forum: Setting Up & Running Reports April 15th, 2009, 09:52 AM Posted to microsoft.public.access.reports
Replies: 2
Views: 89
Posted By Dominic
Ask the user to select report parameters

Hi all

I used to be able to do this, but have lost all the Access knowledge I once
had through lack of use.

I have a table (plus query, plus form) of staff absences and I want to
report on staff...
Forum: Using Forms March 18th, 2009, 01:13 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 59
Posted By Dominic
Representing two tables in a form

Hi Douglas

Thanks for your prompt response.

I will try this,

DB

"Douglas J. Steele" wrote:
Forum: Using Forms March 18th, 2009, 10:37 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 59
Posted By Dominic
Representing two tables in a form

Hi all

I used to be really good with Access, but I fell out of using it and now I
have to learn it all over again, so it's a really simple question, but ...

I have a form that I set up with a...
Forum: General Discussion February 13th, 2009, 06:36 AM Posted to microsoft.public.word.docmanagement
Replies: 6
Views: 98
Posted By Dominic
Unable to print multiple copies of a one page document

hmm so any idea for excel? i figured this would take care of both,,
"Beth Melton" wrote:

That's definitely something to try. Did you look at the KB article I cited
to see if your model had a...
Forum: General Discussion February 13th, 2009, 06:34 AM Posted to microsoft.public.word.docmanagement
Replies: 6
Views: 98
Posted By Dominic
Unable to print multiple copies of a one page document

Beth!!!! I love you!!. so i read the workaround you posted and read what made
sense to me. i changed "print directly to printer" and bam it worked,..,,
thank you so much for you time and...
Forum: General Discussion February 13th, 2009, 03:01 AM Posted to microsoft.public.word.docmanagement
Replies: 6
Views: 98
Posted By Dominic
Unable to print multiple copies of a one page document

Thank you Beth. It in fact an HP laser printer.
so just update the drive via the hp site?


"Beth Melton" wrote:

"Dominic" wrote in message
...
Forum: General Discussion February 13th, 2009, 02:22 AM Posted to microsoft.public.word.docmanagement
Replies: 6
Views: 98
Posted By Dominic
Unable to print multiple copies of a one page document

I am using Word'07 and I am unable to print multiple copies of a one page
document in Word and Excel. I can print multiple pages via quickbooks but jut
not with Office. What do i need to do to...
Forum: General Discussion February 13th, 2009, 02:19 AM Posted to microsoft.public.word.docmanagement
Replies: 0
Views: 86
Posted By Dominic
unable to print multiple pages of same 1 page document

I am fairly knowledgeable about word and computers, id like to think anyway..
i have word '07 and have never been able to print more than one copy at a
time of the same document.
I hit print,...
Forum: General Discussions January 20th, 2009, 11:03 PM Posted to microsoft.public.office.misc
Replies: 18
Views: 293
Posted By Dominic
Classic Mode ?

Thank you all for your input. However I have absolutely no intention of
learning a new system. I downloaded and installed Open Office from
openoffice.org, and best part its free. I am one of the...
Forum: Worksheet Functions October 29th, 2008, 12:32 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 1
Views: 64
Posted By Dominic
Does excel have a reminder function like outlook does?

I am trying to set up a function that will prompt me 3 weeks from a specific
date in a cell.
Forum: General Discussion August 4th, 2008, 04:36 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 71
Posted By Dominic
Forum: General Discussion April 24th, 2008, 10:04 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 69
Posted By Dominic
What does the & symbol in a formula do?

I an looking at a SUMIF formula that includes the & symbol. See below. What
does the & symbol do?
=SUMIF($AN$6:$AY$6,"="&$D$5,AN8:AY8)
Forum: General Discussion August 17th, 2007, 07:42 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 97
Posted By Dominic
Worksheet protection question

Jim,
Thanks very much....that was ALOT less painful than I thought!!!!!
Take care.
Dominic

"Jim Thomlinson" wrote:

Assuming you have XL2002 or better you can look at Tools - Protection -
...
Forum: General Discussion August 17th, 2007, 07:26 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 97
Posted By Dominic
Worksheet protection question

Hi all.
I have a spreadsheet with 20 worksheets. I want each worksheet to be
protected by
1: an administrator password,
2: a user password.

the user password for worksheet 2 MUST NOT be able to...
Showing results 1 to 25 of 30

 
Forum Jump

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


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