Word merged with Access
I am using both Word and Access 2003.
When I merge a Word Letter with Access, sometimes not all of the queries
show up, in the drop down box, to link the letter with. Does anyone have any
ideas of why this happens? Is there a way to make all of the queries show
up? Are the queries limited to a certain number? I would appreciate any
help or ideas that you can give me.
Without more information, I can only guess...
Any chance any of those queries that are not showing up are NOT "select"
queries (i.e., they are Make Table, or Delete or Insert queri...Access 97 Runtime question
We are using Access 97 runtime for some of our staff.
I noticed today that in reports if they right mouse click, they don't get a
shortcut menu. I want them to be able to Export the report they are viewing.
Would Access 2003 runtime have the shortcut menu?
"Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message
> We are using Access 97 runtime for some of our staff.
> I noticed today that in reports if they right mouse click, they don't get
> a shortcut menu. I want them to be...The Item could not be deleted. It was either moved or already deleted, or access was denied.
This is a multi-part message in MIME format.
I had to rebuild a corrupt database this morning. My Priv.edb and =
Pub.edb were the files I worked on with the ESEUTIL. Everything is =
working except users are complaining that they cannot delete e-mails =
that were "zapped" during the rebuild process. The message they're =
receiving is " The Item could not be deleted. It was either moved or =
already deleted, or access was denied...adding months to an inputted date
I need a function that will take a date that a user has typed in a different
cell and will then add two months to the date. For instance, if I type
"2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help
that you may be able to give.
however what do you want the date to be in C2 if B1 is
> I need a function that will take a date that a user has typed in a different
> cell and will then add two months to the date. For instance, if I type
>...Web Services install error on AD LDS
I am trying to install GP 10 Web Services (with the SP3 installer) on a
Windows 2008 SP2 x64 server. Every time I try the install I receive the error:
The Active Directory Lightweight Directory Services role must be installed
on the computer before installing the Microsoft Dynamics GP Web Service.
I have installed AD LDS, and didn't receive any errors on install. I have
rebooted a couple of times, still the same error. I have uninstalled and
reinstalled AD LDS and still have the problem.
You may want to check the following KB articles for resolution to your
System...Adding 2nd server in an Exchange 5.5 environment
Is there an easy way to move the IMS connector from one Exchange 5.5 server
I recently added a new Exchange 5.5 server running on Windows 2000( No AD).
Now I would like to move the IMS connector so I can remove the original mail
server from the network. ( The Original server is a dog)
I have just started this process and the goal is to get my old P2 system out
of the network and replace it with a much faster Dual Xeon box, then upgrade
the new mail server to Exchange 2000..
Any suggestions would be greatly appreciated...
I believe the correct process is to instal...Adding a second line on a two axis column stacked chart
I have a stacked bar graph showing 4 data series on the x-
axis with a line showing 1 data series on the secondary
Now I want to add a second line to the secondary axis
When I do so it automatically becomes a bar instead of a
line, regardless which axis I am plotting it on.
Is there anyone out there that knows what I am doing
wrong and/or what the trick is ?
The trick is this: Don't use the "built-in custom" chart types, but make
your own. Make your chart with all series as stacked columns, then
select each one you want to change, and use Chart Type on the Ch...Purchase order generation rules are not followed by RMS Manager
When I generate a purchase order according to reorder information and to
order from the supplier with the lowest cost, Manager does not always order
from the supplier with the lowest cost. I can verify this by clicking
through the ILC on the purchase order, clicking the supplier tab and the
cost info on the two suppliers shows that the cheapest one is not the one
that the PO is generated for.
Any idea what is going on and how to fix it?
Bikes, Parts, Repairs
& GREAT Customer Service!
124 State ...SQL Server Reporting Services Reports in Access
Using Access 2007 and SQL Server 2008.
Is there a way to display SQL Server Reporting Services reports in Access
If so, links to documentation/examples would be appreciated.
No,there is no compatible interface for converting SSRS report to Access
2007 now.You may consider first export your SSRS report to an Excel file
and then embed an OLE object "Microsoft Office Excel 97-2003 Worksheet". If
you only need the data, you can directly import data from Excel to your
Charles Wa...Access 97 to 2000 conversion problems 08-08-03
I am trying to convert an Access 97 database to Access
2000 but with great difficulty.
If I try to load it in Access 2000, the conversion is
attempted but on the apparent completion the new database
is not saved and the screen is blank.
If I try creating a new database and importing everything
then this works fine for the data, but no reports or forms
I have tried all the latest patches to MS Office.
Any suggestions would be very welcome.
I am trying to set up our Business Portal to be as easy as possible for our
One of the requests they have made is the ability to find out WHAT PO is
COMMITTED to the SPECIFIC line item in an order. Similar to actually looking
at GP Sales Transaction Entry window where it gives an icon to show that the
item has been purchased, what PO it's been committed to.
I have spent hours trying to make this happen. Has anyone else been able to
do this? If so, I would appreciate detailed steps.
...Using Outlook to access and compile information in calendar
I want to create an application that will compile schedule information from
Excel worksheets or an Access database and display them in a calendar type
format. I know this type of application can be built using PivotTables in
Excel, or forms in Access, but I was wondering if I could use the calendar
in Outlook to display the information rather than creating PivotTables or
custom forms which would wind up looking something like a calendar anyway.
Before I start the job I'd like to know if I can work Outlook into the
equation or if I really have to build it from scratch.
I've been doing a lot of research and purchased (but haven't completely
read) Sue Mosher's book. However, before I spend much more time I'd like to
find out if my idea is even feasible. The basic idea is to create an
appointment system for multiple therapists that can be used by a
receptionist and other staff. Using Outlook and Exchange is very nice but
the appointment data needs to end up in an Access table immediately.
We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool
for calendar sharing whichever would be the easiest to use. I currently...Is it possible to add a "View" button under the purchase order section?
Would be nice to have the abilty to allow someone to be able to view the
purchase order as opposed to the given "new, delete, edit, or receive"
buttons. This way someone who needed the information and did not have the
appropriate security would not be able to delete or change the PO. I tried
to CTL S the new, delete, edit and receive buttons, but that basically locks
them out completely. Is this something that may be possible?
You can make excel pivot table so any employee can view that worksheet from
their terminal. This way you can define the fields you want to show as well
...Adding % of total sales to a sales report
How would I add a field that shows what percentage is the value of sales for
an item compared to the report total?
Which report and what do you want to see?
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.
"Geoff" <Geoff@discussions.micros...SBS 2008 RWW Internal web site access
I have a strange issue. I have a client who has four laptops on an SBS 2008
domain. Three are windows 7 one is XP. All work great inside the office.
However, when any of the users attempt to connect to the internal website
through RWW on the outside they get a page cannot be displayed message. I
verified that port 987 is open on the firewall. Using computers at our
location or any other computer, from any other site not associated with their
domain, can connect successfully to RWW and the internal web site. I’ve
verified that the certificate is installed on their computers. I ver...access 2000 to 2003 files
I have many databases created in Acces 2000 on a comp.
w/98SE, which always worked fine. I copied these files to
new comp. running XP home, and using MS office Prof.
When I attempt to open these databases from Windows
explorer, I get anerror saying the <path><filename> is
unrecognized. Anyone know why?
"Rick K" <firstname.lastname@example.org> wrote in message
> I have many databases created in Acces 2000 on a comp.
> w/98SE, which always worked fine. I copied these files to
> new comp. running XP h...access a cell in a range
I have variables:
dim myrange as Range
dim myString as String
myrange specifies a specific column. How can I specify the cell in row
1 of myRange so I can set it's contents to myString?
Hi there keyser soze,
(Fan of the movie, eh? ;) <g> )
Like so ..
myString = myRange(1).Value
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
<keyser_Soze@usa.com> wrote in message
>I have variables:
> dim myrange as Range
> dim myString as String
> myrange specifies a specific ...Access to Server
I install CRM 1.2 in a Windows 2003 Server.
From the server with a Administrator Logon and by the explorer, i access to
CRM Administration without problems.
If i use the Implemetation aplication or if i try to install the CRM
Outlook, the message is: "The Localhost server is not responce"
Thanks for a possible help.
Can you do a 'nslookup' and 'ping' to the server name?
"Rui Sousa" wrote:
> Hi All.
> I install CRM 1.2 in a Windows 2003 Server.
> From the server with a Administrator Logon and by the explorer, i acces...HTTP access from Outlook
Will HTTP access from Outlook work with exchange 2003 and windows 2000
server sp4 combination? Also, how do I configure my server and remote
clients to utilize this feature. Your help is greatly appreciated and thank
you in advance.
On Mon, 20 Jun 2005 08:38:03 -0500, "Henry" <Henry@fake.com> wrote:
>Will HTTP access from Outlook work with exchange 2003 and windows 2000
>server sp4 combination? Also, how do I configure my server and remote
>clients to utilize this feature. Your help is greatly appreciated and thank
>you in advance....Outlook blocks access to potentially unsafe attachements
Outlok 2003 has blocked many of my work emails with legitimate attachments.
just yesterday, it block an Access database file that I was expecting to
recieve. I've always thought, great way to keep desktop safe. But this time,
I needed that document right away. So my opinion has changed.
Question is: Where is the menu to change the security feature so it doesn't
block attachments? The only security menu I found was for restricting
Thx in advance
Tools, Options, Security, Change Auto d/l settings, UNcheck Don't
download.....but leave Warn me etc...checked
"T...adding same note to a group of contacts
As we know there is no histroy in CRm, can not see what has been done to
contacts in past or what changes have been made. So if I whated to add the
same note to a group of contacts such as : email jhfahf sent on afjak"
how would I do it. Or is it just not possible.
Well, you could mess with workflow and stubs do get a kludgy solution -
or you could just buy VAST, the ISV add on that solves this problem,
and shows you all of the historical change made to CRM! (Please
excuse blatant sales pitch - but I don't get such a good leading
question too often!)
I would like to enable the "filter recipients who are not in the directory"
option under Global settings/Message Delivery/Recipient Filtering.
However we allow an IIS server in the domain to relay email though the
If the “filter recipients who are not in the directory" option is selected
will this cause e-mail relayed by the IIS server to non AD recipients to fail?
Recipient Filtering and Relaying are separate pieces of functionality and as
such you should not have any problems.
"SuperPlay" <SuperPla...Do you need MS Access to query on an Access table?
I'm asking these questions because I have looked at a lot of stuff in the
discussion groups and still confused. I am fairly good at Excel programming
but haven't been able to get Excel and Access to talk.
First, I have Office 2003 Professional at work and Office 2003 without
Access at home. I want to work on developing Excel programming at home which
will get data from Access to Excel with either MS Query or with programming.
Is it possible to just have the .mdb files on the home computer for Excel to
work with, or do I need the Access program too?
The info I want ...purchase order posted
a purchase order was received and posted, in error. the posting was the
mistake. Is there a way to void the posted transaction or another way to
bring it back to the received status?
I think you mean a receipt was posted, right? POs don't get posted.
There is no way to void a receipt in GP. You must perform a Return
transaction and then modify the PO (add a new line to the PO) to add
the quantity received back to it.
MCP-GP, MCT, MVP
East Coast Dynamics
get your gptip42today at www.gp2themax.blogspot.com
When the receiv...