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...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.
...Outlook 2002 provided with Pocket PC 2003 won't reinstall
I originallly installed Outlook 2002 in early 2004. Because I suddenly
developed sync problems, and because I had not originally installed it
as a mail/news reader, I decided to reinstall.
I uninstalled the original installation, which I now see may have been a
big mistake. When I reinstalled, it asked for the Product Key. I keep
all my software keys in a password protected file. When I input the key
I had listed as "Pocket PC 2003 Premium Outlook/ActivSync (Dell)", the
installer said it was an invalid number.
Can someone tell me what I do now? I'm not a regular Micr...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...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" <email@example.com> 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...How do you change a field name in 2002 Excel
I have copied and pasted a whole database from Works into the Excel
program but can't seem to find a way to change the field names from A,
B, C, to what I want as Last Names, First Names, etc.
Aarrrrgh. It can't be THAT difficult! <G> Using the HELP did nothing
for me thus I am here asking this silly Q.
AnnE in MN
You cannot change the Column letters from A, B, C etc.
You can choose to have column and row headers not shown under Tools>Options>View
Enter your titles(names) in row 1 then select A2 and Window>Freeze Panes to lock
row 1 in view.
Gord Di...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 ...Cancelling Receipts in Outlook 2002 (XP)
I'm experiencing a problem that I think is due to read
receipts. I have an e-mail account (POP3) that is set up
twice in Outlook. The primary version is for receiving mail
from either home or my office, as well as for sending from
my office. The secondary version of this account is used
only for sending e-mail from home (uses a different
outgoing server, to accomodate my ISP's restrictions). The
problem is that when I receive my e-mail on this account at
home, Outlook attempts to send the read receipts using the
primary (office) outgoing server setting, which fails. This
esse...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...Y-axis title truncated excel 2002
I can't get excel 2002 to show the complete y-axis title along the y-axis.
It truncates in the plot whatever I type
in the Chart Options, Value (Y) axis box. No problem with the Chart Title
Is it worth changing from excel 2002 to excel XP (which I have). I'm running
Others have reported this problem. One solution is to add some extra
characters to the y-axis title and to format these to a colour that makes
them invisible on the chart. I have never seen this myself - I use XL2002
"T-Rex" <T-Rex@foo.co...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...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 ...Outlook 2002 #133
How do I create other entry options in the 'Select entry
type' category when establishing a new entry under
a "Personal Address Book"?
Susan <firstname.lastname@example.org> wrote:
> How do I create other entry options in the 'Select entry
> type' category when establishing a new entry under
> a "Personal Address Book"?
You should not be using the "Personal Address Book" service. Outlook stores
its address information in the Contacts folder.
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI...RMS Integration user access
How can I give users in GP access to the RMS Import (Transactions > Retail
Management > RM Import) function? I found KB 900636, but it did not work.
I'm using GP10 and HQ & RMS 2.0.
...bug in Excel 2003; need to install Excel 2002
I have Office 2003, and I found a bug in Excel 2003. The linear regression
results using Excel 2003 differs with that of Excel 2002 for some cases.
How do I can uninstall Excel 2003 (and install Excel 2002) without affecting
the other Office apps (like Word 2003 and Powerpt2003)?
Excel 2003 has solved some bugs/errors with statsitical functions. So I
would guess the 'new' result are more correct than the old ones
"Speqter" <Speqter@discussions.microsoft.com> schrieb im Newsbeitrag
news:451EE055-7023-4C3B-B816-829BA9FC6E...Visio 2003 Organizational Chart 2002 Compatibility
This is a multi-part message in MIME format.
I have an organizational chart created in Visio 2003 Professional, and I =
have saved the chart (with synchronized pages) in the 2002 file format.
My problem is that when a Visio 2002 Standard user opens the file, the =
pages are no longer synchronized, nor can the 2002 users expand and =
collapse subordinates. Is this the norm, or what am I doing wrong here?=20
------=_NextPart_000_0045_...Outlook 2002/2003 auto-complete function
How do i clear out the "database" of the auto-complete
function in the To,cc and bcc fields. i know how to do a
single name clear by clicking delete is there a way to
clear all the names out?
To clear the entire cache, follow the instructions here:
"Brian James" <email@example.com> wrote in message
> How do i clear out the "database" of the auto-complete
> function in the To,cc and bcc fields. i know how...Money 2002/ Money 2003
Have money 2003 installed on windows XP. Trying to import
money 2002. Can someone walk me through it. I would reload
money 2002 but I can't find my disk.
It should pull in directly for you when you load 2003.
If not, copy the .mny file and open it after you install
2003. Hope this helps.
>Have money 2003 installed on windows XP. Trying to
>money 2002. Can someone walk me through it. I would
>money 2002 but I can't find my disk.
In microsoft.public.money, Richard Conley wrote:
>Have money 2003 installed on ...MISSING features on PUBLISHER 2002 that where there in 2000
On Pub 2000 you could click on a picture frame type in part of a name and the list diolog would list all picture files with that part of name in the folder for you to insert
with Pub XP 2002 you have to use wild cards to get the same result
also XP 2002 is not refreshing my pictures Properely on rezise is there anyway to correct this
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Bex In Da House <bex123abc@<removethis>...
> On Pub 2000 you could click on a picture frame type in part of a name
> and the list diolog would list all picture fi...