Writing a book in Microsoft Publisher
I am currently writing a book using Microsoft Publisher and wanted to know
how to link the pages of the book together. \the only provisions in publisher
is to link four pages together and this does not work for something that is
above that number of pages. Since this is named Publisher, I figured one
could at least use it to write small or large pubications, with out have to
go through ninety gyrations. I need help, or is it that you really can't use
Publisher for a publication .
For long documents Word is preferable. You will have to link each text box in
Publisher, you can link a...how do I lock a field in a form and use for look up value only?
How do I lock a field in a form, yet still be able to look up value in this
Could you define your terms a bit more? I'm not sure what you are trying to
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disc...net passport
I changd my net passport and now when I enter it in money it tells me it is
...C#.net click event associated with database error
I would like to know what to do to solve the problem listed below:
When I am debugging a C#.Net 2008 windows application and click on the
'next' button, I am getting the following error:
'An unexpected error has occurred. The 'Microsoft.jet.oledb.4.0'provider is
not registered on the local machine'.
I think that I may need to change some setting I have in the visual
2008 professional edition to solve this problem prior to clicking on the
I am working on an workstation that is 64 bits, XP operating syste...HELP -- XP Address Book: No Microsoft Solution Listed
What is the plain and step-by-step simple solution for
this very annoying error:
"A new entry could not be added. You must have a personal
address book (PAB) to create an entry. Add a PAB to your
profile using the E-mail accounts command on the Tools
It doesn't allow me to create one!!! Even when I do this:
right click on my contacts folder, click on 'Properties',
then 'Outlook address book' tab.
The option 'show this folder as an email address book' is
blanked out and not available for me to check or uncheck.
You first. What is it t...net
Dear All ,
Can you please help in this
i'm creating excel sheet for finance purpose
and i need the number appear with color
for example if the net = +ve (i need it to appear with green color )
and if it is = - neg (i need to appear with red color )
any one can help me with the color
thansk for your cooperations
bn_dubai's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29568
View this thread: http://www.excelforum.com/showthread.php?threadid=492656
You can use Con...addition with a maximum value #3
> I have the following code
> but I don't want the results to display anything over 20.
> How do I accomplish this?
Okay, sorry but something else needs to be thrown into the loop.
If A+B equal more than 20 then only display 20 unless C has a value i
which case the sum can equal more than 20.
A B C
13 22 0 = 20
13 22 5 = 25
djarcadian's Profile: ht...MFC and .NET
We have a MFC application we are moving to VC 7.0 because we want to
use the latest C++ compiler that comes with it. For moving to VC 7.0
we need to install the .NET framework though. My questions are,
1. Has anybody moved thier MFC application to .NET framework? Did you
run into any issues?
2. What is the plan for MFC? Is there any end of life for this from
I use all of my VC6 MFC apps and DLLs just fine with XP and VS.Net 2003. No
need to port your code to .Net at all.
"David Mohandas" <firstname.lastname@example.org> wrote in message
news:ac...Copy Excel Chart from one book to other without links...
I wanted to know if there is a way that I can copy the chart from one
workbook to other with no external link.
Say, I have a chart plotting data from Sheet 1 (A1:B100,B1:B100 of
Sheet 1) and want to copy the chart to the next sheet with data at
Sheet 2(A1:100,B1:B100 of Sheet 2)
venkith's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37294
View this thread: http://www.excelforum.com/showthread.php?threadid=570074
If it's an embedded chart, co...VB.net
Hi, I am trying to update a field in a record of a Access Database
(whose structure I can not modify).
I got this error (translated from italian): "Data types do not match
in the expression" = "Tipi di dati non corrispondenti nell'espressione
The code is the following: (myField is a binary field as on Access
'determine new value
Dim newValue() As Byte = ... (valid data)
'write new attributes
Dim conn As OleDbConnection = myObj.getConnection
Dim cmd As OleDbComman...Authentication between asp.net 2.0 and asp.net 1.1
I am running CRM 3.0 which is running in its own app pool for asp.net
1.1. I've added a virtual directory under the CRM website which runs
under a different app pool for asp.net 2.0. This is where I put my
custom web pages. Both app pools are running under the NETWORK SERVICE
account. Both the CRM website and the virtual directory has windows
authentication. My question is why I am prompted to enter my
credential when I access the custom page through CRM the first time I
access the page? Have I not already been authenticated?
Hmm not sure whether this can help. Are you sure you put...SQL connection management in ASP.Net
I have to create a small website in ASP.Net 2.0. I have question about
working with SQL connections. What are the best practises? How and where to
create and store a connection? I see a few possibilities:
- create, open/close a connection on each web page
- create a connection on login page and store it on Session
- how to create a connection? ie. SqlConnection = new SqlConnection or
System.Data.Common.DbProviderFactory factory =
System.Data.Common.DbConnection conn = factory.Crea...sorting pivot table by sorts by "show value as"
In my pivot table I have, in the value area, a quantity that has the
value field settings:
*Summarize value field by: Count
*Show values as: % of row
The only problem is when I try to sort the pivot table by value, it
sorts by Count rather than the displayed % of row. I would rather it
sorted by the displayed % of row value.
Anyone know how to do this?
Just a little more information. I think this must be a bug because the
Summary section at the bottom of the sort dialog box suggests that it will
sort the list by the displayed '% of row' valu...FREE .NET EBOOKS , DOTNET TUTORIALS, CODE SNIPPETS
Visit this site u will find good .Net ebooks, .Net source code, .net
tutorials and lots more for vb.net, c#.net, asp.net and other dotnet stuff.
I don't like the site because
1) There are 3 sets of adverts on each page
2) The page is fixed with, which is very annoying. I am reading on a
wide-screen laptop but find I am limited to approximately 60 characters per
line, I can't read articles like that!
...Merging Address Books
Is it possible to merge more than one address book into a
single address book in Outlook 2000? If so, how?
When you say "address books", are they separate files like the old .PAB
format or perhaps a .WAB from Outlook Express? Or are you talking about
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
Fred H. wrote:
> Is it possible to merge more than one address book into a
> sing...Would like to show a Blank cell on a #value! error
I am entering a date in one cell, then in another cell I am using =sum(a1-7) to sub 7 days from the date entered in cell A1. The problem is that if a date has not yet been entered in A1, then the formula cell displays #value
I would like to hide this error or just show a blank cell.
Rick, =IF(A1<>"",A1-7,""). Also note that in your original formula the SUM
was not necessary -- A1-7 is all you needed so far as the arithmetic was
"DDM's Microsoft Office Tips and Tricks"
"Rick" <anonymous@discussions...xml DTD visual stdio .net 2k3 autocomplete
I'm using visual studio .net 2k3 to work with Xml intensive integration
App. When I using XML /XSD based documents I get autocomplete feature but
not when I use Xml /Dtd based. Somebody know How work around
<email@example.com> wrote in message
> I'm using visual studio .net 2k3 to work with Xml intensive integration
> App. When I using XML /XSD based documents I get autocomplete feature but
> not when I use Xml /Dtd based. Somebody know How work around
>...Can I call a macro from a specific book
I have a number of workbooks open all with a macro called 'MyMacro' in them
1. When there are a few open, how can I run the macro from a particular book
(I want something like: Call Workbooks("Book1.xls").MyMacro)
2. Also... How can I run the MyMacro macro from the ActiveWorkbook?
I have a number of workbooks open all with a macro called ...Disable/Enable all controls on a form based on value of another control
What is the best to way to exclude a specific control (or controls)
from the following condition? (e.g., I would like to exclude SubjectID
and MRN from being Enabled or Disabled):
Dim Ctl As Control
On Error Resume Next
If IsNull(Me.SubjectID) OR IsNull(Me.MRN) Then
For Each Ctl In Me.Controls
Ctl.Enabled = False
For Each Ctl In Me.Controls
Ctl.Enabled = True
I'm using this to ensure that the user enters the SubjectID and MRN
*before* entering more data for the subject. By disabling all the...Set Value Macro
I have Two Tables one table has a combo box with an tblEmployeeSalary. the
other table I have is called tblSalaryHours. In tblEmployeeSalaries I have a
combo box called Salary which represents the Annual salary of the employee. I
want to use the Set Value Macro to paste that salary value in to my other in
a text box in a form called currentsalary. Any suggestions please keep it
simple and be specific as you can kind of dumb with this stuff!!
If you have a "table [with] a combo box", you must be using the lookup
datatype. This causes considerable confusion, since any ti...Booking Future Meetings
I'm trying to book a meeting with 2 colleagues for sometime in May. However
when I go into the scheduling tab for the meeting, and add both their names
from the address book, every day in their calendar from May 1st is hashed
out, i.e. no information (white background with \\\\\ lines in). I've spoken
to the colleagues and they have both said that they have nothing scheduled
at all in May, so I don't understand why their calendar is saying there is
no information. Does Outlook only display a certain number of months in
advanced? If so is it possible to change?
I have a few questions about ASP.Net, as I've been using it for a
while but my knowledge of the "big picture" is patchy in some areas.
Any help would be appreciated...
- Where is the line between "native" language features (e.g. in
JScript), and those features which are part of .Net (or whatever),
common to all .Net languages? Or put another way, how are the .Net
facilities "mapped" onto a particular language? (I'm sorry of this
question is somewhat vague...)
- In a closely-related matter, do any languages have issues accessing
the full A...Offline adress book
Can I convert an offline address book (*.ost) to a
personal address book?
...Reset Batch Number to Zero
Looking for info on how to do this. Been playing around
with and would like to reset this info to zero once we go
...set a variable to value in a select statement
I know how to do this:
SET @total = (SELECT SUM(Salary) FROM Employee)
But is it possible to do soemthing like this without 2 separate SET
SET @total, @tipstotal = (SELECT SUM(Salary), SUM(Tips) FROM Employee)
If so, how?
SELECT @total = SUM(Salary), @tipstotal = SUM(Tips) FROM Employee
"Keith G Hicks" <firstname.lastname@example.org> wrote in message
>I know how to do this:
> SET @total = (SELECT SUM(Salary) FROM Employee)
> But is it possible to do soemthing like this with...