Can't get the proper display of a field in my report.
I have 2 tables, both using autonumbers for their primary key. The first
table is for contacts (i.e. last name, first name, etc.). The second table
is for businesses (business name, etc.) I have a field in my contacts table
that has a number format so it can be used as a foreign key for the business
table. I then set up the relationship between them & enforced referential
integrity. When I run a query, I see the name of the business (after setting
up a combo box) - no problem. When I run a report based on that query, a
number is displayed (not the business name).
Suggestions, pleas...Limitation of Outlook Pesonal Folder
Can you give me a reference where I can find information about limitation of
personal Folder of MS Outlook? If its possible that the information was
stated the maximum size (GB?)
Here is a link to an article that talks about the Personal Folder file size
limitation for Oultook 97-2002,
2003 has a much larger limitation and here is a link to an article that
discusses its limitations,
I hope this information is helpful.
Robe...format changes when copying from one cell to another
I'm sure this is simple, but it is not clear to me...
I am copying the contents of a group of cells that exist on one worksheet to
another. In Sheet2, I tell cell A1 that it should equal Sheet1's A1 value.
That works fine. But if the cell is blank on Sheet1, it comes up as "0" on
Sheet2. I figured it was probably assuming numeric formatting, but when I
right-click > format cell on both Sheet1 and Sheet2, both show up as
"general", so why would Sheet2 take a blank value and populate it with "0"
I gather than you are putting a formula in one...Receive mails from one adr. to several computers
I have a problem receiving mails from one adr. to 5
computers in a network. One of the computers get's all
the mails. They should all receive the mails.
All the machines run's win Xp and office Xp.
Outlook on all computers are set to store the mails on
the server, even though they have been received on a
computer. When I check my WebMail, the messages are still
...I need the fix for Knowledgebase ID: 810999
Where can I get this from?
In the last exciting episode, "Stephen Aldous"
>Where can I get this from?
Other from Microsoft Product Support Services as stated in the
article? No idea.
-- ROT13 for valid SMTP address --
Call Product Support Services as listed in the article. If all you're
looking for is the hotfix, then the call should be free.
"Stephen Aldous" <firstname.lastname@example.org> wrote in message...With a Query in Access 2007, How can I Create This Query
I need a query that will list all records in table 1 for which there are no
auditor records (Table 3). Somehow, I need to use the relationship between
tables 2 and 3 to find what's not in table 1. The following query gives me a
list of all records that do have auditor records. I'm at a dead end on this
AuditDet...Can't send e-mails from Outlook 2003 after SP1
After installing service pack SP1 for Office 2003, I
can't send e-mails anymore. They are stuck in the outbox
folder. The error message states that the connection to
the server was interrupted. I did not change any settings
and checking them confirms that everything is as it
should be. Did anyone else experience the same issue and
how did you resolve it?
Thanks for your help
See if you can manually move those messages from your Outbox and then check
all your settings again.
"Mattliusa" <email@example.com> wrote in message
news:cb7401c48a5...Developing a robust database at one co. then using it at another c
Are there any legal implications of using the type of database listed above
to perform similar functions for another company? The 2 company's are in 2
totally different industries and the new database will have to be modified to
fit the requirements for the industry it is in. The database was developed at
the old company.
there is no such thing as a robust Jet database.
Move to SQL Server if you want to build a solution that will work for
the next decade.
Jet is and always has been depecrated
On Apr 7, 12:14=A0pm, BoaMan10 <BoaMa...@discussions.microsoft.com>
w...Can Line Chart Overlaps be Highlighted?
Can the overlap portion(s) of two lines in a chart be shown in a different
color, without having to manually draw a shape? I would like to show the
areas where Line A is above Line B as red, and the areas where it crosses
below in blue - is it possible to do this without manually drawing in shapes?
To some extent it depends how many times the lines cross. If it's just the
once then you can use area charts to provide the shading.
This may help if the used one line as a base line...Using the classes created with xsd.exe
I have created classes from several xsd files. These files create about 150
classes and spot checking them they do represent types in the xsd files. the
question is how do I use these files. How do I load data into them and create
xml from them. Is there some articles about this subject.
As for the classes you've generated, are they normal classes or dataset
classes? As for the normal classes you generated through xsd.exe, you can
use XML serialization to convert those class instances into XML content or
deserialize the XML content back into objec...Can't sign in to 2004?
Now, another problem. I can no longer sign in with my hotmail and password
if "use Money's online features that require a passport" even though I am
signed on to MSN with that passport. I tried resetting the hotmail password
for both MSN and Money 2004 but still can't get it to work.
In microsoft.public.money, MrEKJ wrote:
>Now, another problem. I can no longer sign in with my hotmail and password
>if "use Money's online features that require a passport" even though I am
>signed on to MSN with that passport. I tried resetting the hotmail password
&...Add items from an external application to RMS transaction grid
Is there a way to add items from an external application to MS RMS
transaction grid? I want to add items using windows application or web
application to RMS transaction grid. Kindly help how to add from an external
Thanks for help in advance.
You would need an Add-in for RMS to make this happen. If you are yourself
not sure how to make this happen, I would consult with your RMS partner, or
any of the other partners on this forum, including my company, that
specialize in creating customization for RMS. If you are interested in
getting an estimate for this work please f...Apply current view to all folders
I would like to apply a certain view to all sub-folders within my inbox
and would like to do it without having to go to all my folders. I have
many sub and sub-sub folders.
I have looked and looked for an 'apply this view to all folders' button
or the like but can't find.
Can anyone help??
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Me again... bottom line..
How can I make every message and information look alike wit...Can't open files
Hello -- I'm sure this isn't the proper place to post my problem, but thought
I'd start here anyways. Let me start off by saying that I'm extremely
computer-stupid, so please forgive my ignorance. I'm running Windows Vista
Ultimate, and yahoo email. For some reason, I'm unable to open attachments
that have been sent to me, and saved to my computer. PLEASE HLP!! These are
important documents that I really need to access. Thanks for your help --
It's not very informative to say you are not able to open attachments.
What happens when you try? Is ther...multiple balances on one printout
I want to print all the months on one sheet. with a total, is this
possible and if so how do I do so.
...How to merge columns and rows into one cell besides using Merge and Center Icon?
I had posted this question before, but I couldn�t find this thread in
any of the pages up till page 17. So I�m posting again.
I want to merge all rows and columns starting from A1 to J2, with no
lines in between into one cell. My text data value are in D1 and D2
respectively. Using Merge and Center Icon will only retain the
upper-left most data, resulting the data in D2 to be deleted. So how to
merge all rows and columns into one cell and yet prevent the data in D2
to be deleted?
Any help will be greatly appreciated.
~~ Message posted from h...Cannot launch 'manager.exe' Why?
This keeps on appearing in a small window when I have tried to re-download a
program that used to be on my old ISP and computer. I have recently changed
to Broadband and a new XP Home PC..
Roger C. Harris
How does this involve Outlook?
"Roger's in trouble again!" <Roger's in trouble
firstname.lastname@example.org> wrote in message
> This keeps on appearing in a small window when I have tried to re-download
> program that used to be on my old ISP and computer. I have recently
...email to Public folder gets NDR
When I try to send a message to PF I get a NDR and following message in Application log
Event Type: Warnin
Event Source: MSExchangeTranspor
Event Category: Exchange Store Driver
Event ID: 32
The following call : EcLocallyDeliverMsg2 to the store failed. Error code : 1238 (Message-ID <C8F74733BF2C7E4888545664F83970FC47162D@xmail.1111.ru> will be NDR'd). MDB : 0a07ea5d-c42f-41d6-9b26-1b91ceddf4dd. FID : 1-41. MID : 1-23E6CB. File : .
But some other users can send messages without problems..
What does this error code(...why I can not definition a variable in My Dll.
It's a dll support MFC
INT __stdcall RemoterPrint()
INT booklet1 = 1;
INT Pages1 = 0;
INT m_FileID = ::InitUMFFile(szFilePathName);//Insert Breakpoint;
I found the value is as follows
why ???? I am really puzzled.
I added someting in stdafx.h
using namespace std;
"zhang" <email@example.com> д����Ϣ����:u1SbT%23FbHHA.4656@TK2MSFTNGP03.phx.gbl...
> It's a dll support MFC
...Outlook 2007 Outlook.exe deleting itself
I seem to be having a very strange problem. When I start Outlook 2007,
it stalls and then deletes the Outlook.exe file. This is a relatively
new problem (within the last week). All other files seem to be present.
If I keep a full copy of Outlook.ext in another folder, that is also
deleted. In some cases, after restoring the file, Outlook will start to
come up but then stall and die. In other cases, it won't won't even
start to come up but just deletes itself.
I've run several different types of anti-virus software including AVG,
Avira, Spybot and none seem to find an issue or he...Rehoming public folders Exch5.5
Iinstalled a new Exch5.5 Serv into our existing site and decided to rehome
public folders using Admin console and MS Article Q185043.
Serv1 NT4SP5 Exch5.5SP4 is to removed from site Serv2 is the new server
My question is why do all my public folders (hidden view) still show in the
recipent container on serv1 after being rehomed 5 days a go to serv2 but
under the public folder hierarchy all my folder properties state the home
server as Serv2?
The only step i havn't perform in the article is 'propagate these properties
to all subfolders' and clear all optio...SQL 2005 Express
The New SQL Server Management Studio Express (that comes with SQL 2005
Express) is excellent and a huge improvement over MSDE tools we've had to use
in the past.
However, the lack of an import tool (SQL Server Integration Services) limits
our capabilities with larger RMS customers who need, for example, to update
thousands of item costs throughout the year. SSIS Express or at least an
Import feature would help us create a 'dynamic' (yes, I said it) solution for
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestio...How can I change order of pages in a fold brochure in publisher
When I work on the pages on the screen it shows pages 2 & 3 and the page
preview shows 2 & 3 but when I go to print page 3 comes out as page 5.
Is your publication setup as a booklet? When you go to print are you checking
current page or typing the page number? What version Publisher are you using?
> When I work on the pages on the screen it shows pages 2 & 3 and the page
> preview shows 2 & 3 but when I go to print page 3 comes out as page 5.
"Mary Sauer" wrote:
> Is your publication setup as a booklet? When you go to prin...Opens to Personel Folder by default...How to Change?
I cant seem to find a setting anywhere that will let me
change Outlook 2003 to open right up to the Inbox. It
keeps going to the Personel Folder....Even right after a
clean install....Anyone I know that uses Outlook never had
to set anything and it always went straight to the
Inbox. Any one know how to change this?? THANKS!
Outlook toolbar: Tools/Options/Further/extended options/Folder with program
Do you search this setting?
Outlook Network without exchange: Public OutLook
Share your Outlook PST with several users!
&...multiple one to many
I have a database with multiple tables that are populated with a form with
Basically I have Table A with a record ID field that has a one to many
relationship with two other tables (Table B and Table C).
I am trying to run a query (for a report) that will show the record ID (and
other fields) from Table A with each of the many corresponding fields from
the other two tables. But I don't want the info from Table A showing up
repeatedly in my report - just once.
How can this be done?
First do the query, and don't worry about 'repeating'...