Frontpage 2003 or Publisher 2003 ?
Which one should I use? I am not familiar with Publisher. I am familiar with
FrontPage. What kind of support is needed on the server side for a web ?
cgi? etc. Any info or a link to some info appreciated.
Hi Cracker Jacks (cjacks<nospamz)@verizon.net),
in the newsgroups
|| Which one should I use? I am not familiar with Publisher. I am
|| familiar with FrontPage. What kind of support is needed on the
|| server side for a web ? cgi? etc. Any info or a link to some info
I recommend FrontPage 2003. FrontPage 2003 doesn't REQUIRE FrontPage Server
extensions,...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...Is it possible to add a base line in excel
I have a graph the tracks test scores. I want to establish in a bar chart a
base line for acceptable test scores. I can do this by drawing a line on the
chart but I want to be able to include this in the chart itself.
Tom King wrote:
> I have a graph the tracks test scores. I want to establish in a bar
> chart a base line for acceptable test scores. I can do th...VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
>I want to insert a time when I start work and...Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
>I am using multiple monitors for work and it is great!
>there a setting that I can use so that it opens each new
>excel file in a new excel ...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...VBA Form Position
Here is a question for the community on VBA - I am puzzled and would
love some input as to why this behavior:
I am trying to open up a separate form to display some additional
attributes when Item Maintenance is opened.
This form is opened right below the item maint form, has the same
width as item maint and about an inch and a half tall, and displays
attributes from a custom table.
User may move the item maint form and I am moving this custom form
along with it. I am using the left and top properties of the Item
I then add the item maintenance form's he...Subtracting value from main form
I have a borrow module which will alow user to return item separately. So, I
have get the structure of returning it separately.
In my main form is the borrowing item, with the loaned quantity and the owed
quantity (will be calculated).
In the subform, there is the returning transaction. User will need to key in
the quantity returned and it will be automatically deducted from the quantity
But how am I supposed to get the quantity deducted while it 1 is in main form
and the other is in subform?
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-fo...Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
Check out Ron De Bruins "Send-Mail" tips:
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
> The email body should say: this has been submitted for cell B34 and...Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...cmbo box on subform fills fields on form when chkbx is yes
I have a multi-tabbed form that details bid data ranging from pricing to
contact info to departmental notes. Page two has a subform listing general
contractors to whom we bid. One bid may have 10-15 contractors listed. When a
purchase order is issued from one of these contractors I select a checkbox
indicating that GC. I would like the opening page on this tabbed form to show
the address and contact info for that GC when the checkbox is yes. Is this
Message posted via AccessMonster.com
On Mar 17, 3:04=A0p...graphing data
What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?
Graph them in exactly the same way that would have done if the numbers had
been typed into the cells.
"mikaman" <email@example.com> wrote in message
> What is necessary to graph the number(s) in cell(s) when the number in
> cell(s) is/are generated from a formula in those cells?
I copied my PST file from my D: drive to my F: drive.
I then went into "Data File Management" to get the new location
recognized and to have all future mail sent to that location.
After doing this, my custom settings, like new folders, date
settings, columns, etc, are all back to their default settings.
Is there any way I can get my custom settings working again on the F:
Could you explain yourself a bit more? What custom settings are you refering
to? You mean views? And what new folder settings?
Also post your version of Outlook.
Robert Spar...Copy filtered data
Let's say I have data in A1:Gxx. Now I use Autofilter to find all rows which has a "2" in column C. Let's say it leaves rows 1:4 and
8:10. Now I want to copy the filtered data in columns F:G and paste the values (not to an empty range which is easy) but to the same
cells in colums D:E.
Try Advanced Filter, excellent tutorial here from Debra Dalgeish, owner of
"Hans Knudsen" <Hans.Knudsen@mail.tele.dk> wrote in message
news:%23xtVdlR8FHA.740@TK2MSFTNG...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...subreport between each entry on the report
I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the entries
for the subreport show up in between those on the report. This is not what i
want. I want the subreport entries to show up below those of the main report.
How do i do this.
Put the subreport in the report footer.
Put the subreport in a group footer that is printed after your details
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
"...Dates in a form for filtering Report query
I have a form "Period" with two text boxes. One for startDate
and one for EndDate. I want to use that form to limit the query
for my Report by the dates. However, when I refer to the
Form it does not seem to understand it is a date? I use the following
statement in my query:
I also tried to convert it to a date like the following:
CDate(<=[Forms]![Perioder].[txtStartDate]))) but that did not work?
What should I do in order to the query to read the condition or dat...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <firstname.lastname@example.org>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...How do I create a pivot table if the pivot table icon or menu ite.
If rhe pivot table icon ...??? Please clarify in the body of the message.
"Lynn@WS" <Lynn@WS@discussions.microsoft.com> wrote in message
...EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...How to set tab order for a dynamically created CEdit?
Use SetWindowPos(...) and change the position in the z-order.
<email@example.com> wrote in message
> Anyone knows?
Ajay Kalra [MVP - VC++]
<firstname.lastname@example.org> wrote in message
> Anyone knows?
...Create pre-set margins & page no's.
How does one "pre-set" margins & desired page-numbering option so that most
Word files that a person creates or copies from the Internet automatically
are set to these specifications when a new document page is opened? (I am
tired of doing this "by hand"over and over again each day!)
Also, can I create one or more of this type of "template?" (I've never done
this sort of thing before.)
Create a template with the desired options specified. See
Microsoft Wo...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
...Excel Cells Contents to HTML Pages
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTMLCode clumn has actual HTML Code like:
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html