Is it possible to create a document in publisher (mine is
a certificate) and then merge the desired information from
a select querry in access?
Hi Tina (email@example.com),
in the Microsoft� newsgroups
|| Is it possible to create a document in publisher (mine is
|| a certificate) and then merge the desired information from
|| a select querry in access?
Yes, you can. Which version of Publisher and Windows are you using?
Microsoft Office Publisher MVP
Official Publisher MVP Site:
This posting is provided "AS IS" wit...Auto table name change in Access queries
Do anyone know how to disable automatic table name change in Accessqueries?Currently, I am testing a set of 30 queries in an Access database andneed to have these 30 queries run on different tables, for example,tblA, tblB, and tblC. I have all 30 queries built using tblA. Iwanted to test the data in tblB, so I renamed tblA to tblA_BK and tblBto tblA. However, when I ran the queries, some queries are referringto tblA but some are referring to tblA_BK. Why it that? How toprovent this from happening?Thank you in advanced for your help.- Grasshopper - That is done by Name AutoCorrect, which i...changing budget period -how?
WE have set up a budget in Money 2002. But my paycheck
gets deposited a few days before the 1st of each month.
Thus, when I run the buget report for that month, it shows
that I have no income yet for that month but plenty of
expenses already. Is there any way to ge the budget
period to change from the calendar month to a period
starting on the date of my paycheck deposit and running
until the day before the next deposit?
"CLP" <firstname.lastname@example.org> wrote in message
> WE have set up a budget in Mo...Merge same transaction
I've had transactions that I've placed in my register with detailed info in
the memo area only to have the same exact transaction download with no info
and unrecognized as the same transaction. Traditionally I've copied and
pasted the info into the downloaded transaction and then deleted my
transaction. This is a real PAIN... Is there a way to tell Money that these
two separate transactions are the SAME transaction and then have it merge
It works exactly as intended when Money recognizes the transaction that's
already in the register and then merges them beautiful...Merging 2 Companies into 1
Are there any guidelines or outline for what tables you need to look at to
gather the various information you need in order to merge 2 companies
together as well as issues to consider when undertaking such a project?
It is a project and a half. I got approval from a major client yesterday to
proceed with just this project.
You literally need to look at all of them!
I understand that MS Professional Services will do this project for you. In
my case the client cannot be down and has too many 3rd party products for us
to pass it off.
When does your project need to be completed?
Ri...Can't find how to change Y-axis range to show new data in Excel Mac 12.2.4
Operating System: Mac OS X 10.5 (Leopard)
I have a simple bar chart that I created some years ago in a previous version of Excel. I add data each month and it shows miles I drive per month over the year, very helpful to keep track of distance and gas mileage. I've extended the Y-axis range downward a few times before, but can't find out how to do it this time. I always install the latest updates from Microsoft and now I'm running Excel 2008 for Mac version 12.2.4 (100205). My Y-axis range in this chart starts at 800, but I drove only 772 miles ...Change color of the border..
There are some components as the combobox that doesn't give option to change
the color of the border, there is some form of making it
...Word mail merge
After printing a document there exists a activity with subject "Word
Mail Merge" to the contact with status completed.
Is there a possibility to change the subject name or to make a link
to the original Word document?
I think that the subjct name is hardcoded. The issue of only adding this
paltry information to the activity and not showing what document was sent is
a problem many have asked about.
Microsofts workaround to this glaring gap in functionality is to then add a
copy of the word document to the record using notes. Totally unworkable if
you have just mail merg...How do I change the shadow color on a 3-D chart/Graph
I'm trying to align colours in a 3-D chart. But the shadow on the 3-D is
staying one colour even when I change the surface colour.
So when I have a green 3-D box on my chart and the next box is red - the
shadow on the red box stays green. I would like it to be red.
Can anyone help. I'm sure it's an easy one but it's frustrating me!!
You say "shadow" but it sounds like you are asking about the depth portion
of a 3-D object? What version of Excel are you using - in 2003 and 2007 if
you change the color of the individual data point (a single bar) ...only one letter shows typing shortcut name
Windows XP pro SP3
This isn't really a big problem. I'm just curious about what is going
Recently I notice that typing in a name (or changing a name) for
desktop shortcut does this:
The first three letters show up, then only one letter (the letter just
typed) shows as the typing continues. The field expands as the name is
typed but only one letter is visible as it is typed, until I am
finished and hit return. Then the whole name shows up.
Again, no big issue. Just curious. Any thoughts appreciated.
...mail merge/merging 2 address lists...
Is there a way to merge two of your address lists in Publisher 2002? I have
two address lists in my data base folder and would like all the addresses
merged into one as there are some addresses different in each and some the
Hi Robin (email@example.com.NOSPAM),
in the Microsoft� newsgroups
|| Is there a way to merge two of your address lists in Publisher 2002?
|| I have two address lists in my data base folder and would like all
|| the addresses merged into one as there are some addresses different
|| in each and some the same.
No, you cannot. You nee...merge and compare
We have two versions of the same work sheet from differnt dates.
Some of the cells have been changed in the latest version and we need to
compare which cells have had changes and selectively merge the two.
Is there any hope???
> We have two versions of the same work sheet from differnt dates.
> Some of the cells have been changed in the latest version and we need
> to compare which cells have had changes and selectively merge the
> Is there any hope???
have a look at
An add-in which compares two worksh...Column headings in Excel showing up as numbers, not letters
I think I accidentally hit a wrong key at the wrong time -
and all of a sudden, my column heading labels in Excel are
showing as numbers (i.e. 1,2,3, etc.) instead of letters
(i.e. A,B,C, etc.) - can anyone tell me how to recify
Go to Tools>Options>General and uncheck the box marked R1C1 Reference
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dickster" <firstname.lastname@example.org> wrote in message
> I...I Need to change reference sheet for all cells on a form
I am copying a spreadsheet to make summary sheet and I need to change which
sheet the cells are referncing on my copy. Some of the cells refer
to for example, =PRIOR YEAR!B3, some of the cells use a command
to Round(PRIOR YEAR!B3/100), I would like to change all the references that
currently refer to "PRIOR YEAR" sheet and make them "CURRENT YEAR" sheet, so
my references would look like this =CURRENT YEAR!B3 and Round(CURRENT
YEAR!B3/100). I am curious if a paste special, or shortcut exists that can do
this quickly so I dont have to go in and manual...Changing Requirement Levels when a Regarding entity is selected
I was wondering if it is possible to change a field from a business
recommended to a Business Required mode when a custom entity is selected on
the Regarding lookup field.
...How can I get bar codes w/ Excel & mail merge?
I want to send out a bulk mailing with large postcards. I want the addresses
printed on the postcards via mail merge. I am using Excel, but don't see
where or how to add the bar code to the address, which would save me a lot of
money. Can you help?
>I want to send out a bulk mailing with large postcards.
I want the addresses
>printed on the postcards via mail merge. I am using
Excel, but don't see
>where or how to add the bar code to the address, which
would save me a lot of
>money. Can you help?
I not entirely...Merging worksheet into MS Word mail merge
I am merging a letter and an Excel worksheet. When I merge an Excel field
that contains $ and commas separating the hundreds and thousands, the $ and
the , do not show up in the merged letter. Any suggestions on how to solve
Instead of just referring to the cell e.g. A1 use
"Briggs" <Briggs@discussions.microsoft.com> wrote in message
> I am merging a letter and an Excel worksheet. When I merge an Exc...Changing the user password without the use of SA or DYNSA accounts
Is there any way to save a user password in GP v10 without the use of the SA
or DYNSA login? I would like to grant security to one user to do this.
Currently the save button is greyed out unless they log in as SA or DYNSA.
You can do this by granting that user sysadmin rights in SQL management
Studio. In SMS, expand the Security folder, then logins, then find that
user, right click the user, go to properties, click server roles and check
the box for sysadmin.
"Junior De Alba" wrote:
> Is there any way to save a user password in GP v10 without the use of the S...Error in Mail Merge when selecting Edit Individual Labels
We are noticing an interesting error when trying to perform a mail merge
within CRM and Microsoft Word. We have created a view in contacts and we
perform all the typical mail merge functionality using the Labels option. At
the end, instead of printing the labels without any edits, we click on “Edit
Individual labels” and we get the following error…
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE has encountered a
problem and needs to close. We are sorry for the inconvenience.
We are on CRM v4 Update Rollup 8 using Outlook 2007 and the CRM Outlook
(Online only) client.
Has an...Shading A Line Using Accent, etc. Why Other Changes Also ?
Using Excel 2007 and W7.
Have a simple spreadsheet where the first column is dates, and then the
next three are blood pressure readings (systolic, diastolic, and rate).
I thought it would be clearer if I shaded in the Rows that had PM readings.
So, I went to Home\Cell Styles, and selected the 20% Accent 1 for shading.
After selecting the line, it works just fine.
But, each and every time I try it, it changes my font size and font type
for the line. Seems to automatically revert to some default, or... ?
Also, if I have a cell in the line Bolded, it eliminates the Bold.
I though...Help! Powershell changes text file sizes??
When I run a command with invoke-expression in Powershell, it creates a file
almost twice as large as the same thing run from command prompt. Can anyone
tell me what is going on here?
If I run the following command from a command prompt, I get a 14K text file:
dfsradmin rg list /attr:RgName,ObjState >> report.txt
If I run the following command from a Powershell prompt, I get a 27K file:
invoke-expression -command "dfsradmin rg list '/attr:RgName,ObjState' >>
> When I run a command with invoke-expression in Pow...Pasting into merged cells #3
I want to copy information from an area that doesn't have merged cells to an
area that has merged cells. When I do this I either get an error message or
when I use the Paste values and number formats it only pastes every other
entry. Is there another way to paste that I don't know of that will paste
into the merged cells?
best would be to get rid of merged cells.
You could of course paste cell by cell
> I want to copy information from an area that doesn't have merged cells to an
> area that has merged cells. When I do ...Sudden Change to Database Forms
We have a database that has been in use for a few years. Recently we upgraded
our MS Office to 2003. Since that time on one of the desktops that uses the
front end there was an event that has rendered the front end unusable. The
user was entering data to a form when she suddenly found a screen that said
something like "the computer will need to reboot". Unfortunately the person
making observations was not careful in observing exactly what transpired, but
since that time all of the fields that have lookups based on queries do not
work. If you check the underlying queries in des...Autofit Row & Merged Cells
Is this just me or is it a common problem:
I have some text in a cell. The cell is merged along a row with the adjacent
cells, I have put word wrap on. Now Autofit Row doesn't work and only shows
the first line of text.
Is there anything I can do, apart for manually adjust the row height?
Take a look at this macro by Jim Rech:
If you need help getting started with macros, look at David
McRitchie's Getting Started with Macros page:
In article...Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has
date in field code and atty wants to change it from Jan 5 to Jan 4. She does
search and replace but the date automatically updates on print, even if we
change that setting.
"Serena K." wrote:
> Merged letter and made changes to merged letters. Final merged document has
> date in field code and atty wants to change it from Jan 5 to Jan 4. She does
> search and replace but the date automatically updates on print, even if we
> change that setting.