Change link between form and subform
I have a form with a subform in it.
I would like to change the way they are linked so instead of linking from
Old ID, they link to New ID
I don't know anything about code, is there a way to just change the cell it
Bring up the properties of the subform, and change the values in 'Link Child
Fields' and 'Link Master Fields' on the Data tab of the properties dialog
box. Make sure you have the subform selected, not the form within the
> I have a form with...Problem Printing out Outlook Contacts
I'm using Outlook 2007 as part of Microsoft Office Small Business. Today I
tried to print out a contact listing for the first time (installed only a
couple of months ago so I don't know if this has been a problem the whole
time or if my problem "just started") when I print out all my Contacts,
Outlook is merging the names of some of my contacts and using the address of
one of the contacts. Example: Mary Smith Mark Sutter 123 Main st. anytown
, USA 12345 prints out when in fact Mary Smith and Mark Sutter are 2 separate
contacts with 2 different addresses. ...outlook blocked access
getting the following message on one of our sales computers when a customer
attempts to send a document
Outlook blocked access to the following potentially unsafe attachments.
1st what is a pdf.url ? some type of adobe document but what ??
How do i keep Outlook from blocking this ??
it could be a virus/worm. (they use a double tapped extension to fool the
user into thinking that it is a safe attachment type like *.pdf) has the
user written back the sender to confirm that it was something they sent to
"m macon" <email@example.com> wrote in m...Outlook 2003 name resolution
I have had a few people ask why one day all of a sudden, when they type in
the first few characters, the auto name resolution just stopped responding.
They type the first few letters, and usually the drop down appears with
option, but now it doesnt.
We are using OL2003 w. SP1 on WinXP boxes.... Thanks in advance....
Chris <firstname.lastname@example.org> wrote:
> I have had a few people ask why one day all of a sudden, when they
> type in the first few characters, the auto name resolution just
> stopped responding.
> They type the first few l...Mail merge using Excel data
Using P2003 and mail merge
In Pub, whenever my "zipcode" field (that I am getting from an Excel
file) has zip +4 digits, "0" shows up in the Pub merge results. In the
Excel file, I have tried having the column attributes set as Custom,
Text, and others to see if that was causing the problem, but still the
How can I get the zip + 4 to display correctly in the Pub merge? Thanks
much for your help.
Try inserting an apostrophe before the figures in Excel. This tells Excel
that the cell contains text. Does this work for you?
I am trying to link and .slk file to a .xls file all the
links appear to be updating but i keep getting a message
that excel cannot update 1 or all of the links. Is this
common when linking with an .slk because i have several
linked wrk books and have never had this problem.
Hello, I am doing a project that requires two forms.. The first form
contains the data for a business the second form contains data for the
How do I link the two forms together...?
Send a common key piece of data from the first form (say the company name) to the second form page and include it in the second form
as a hidden form field
(then if using a database to store the results link with a relationship the 2 results tables by the common field)
For form passing information see http://irt.org/articles/js063/index.htm
____...Links not linking
I have written a fairly big spreadsheet linking through the pages with SUM,
SUMIF and SUMPRODUCT formula's
What I am now finding is that when I update one page it doesn't update the
rest, even if I am only typing in a figure to the SUM function.
I have check and the calculations function is on automatic.
is there a fix or something that I could run to make sure that all the
formulas are working correctly.
Just a guess (since you already checked tools|options|calculation tab).
How about selecting all the cells (ctrl-a (twice in xl2003)) and then
what: ...Linked Table Manager in ACCESS
I am trying to change a field in an ACCESS table and get an error message
that says the table is a linked table and fields can't be changed. After
googling for some answers, I think I should be able to find out the link
using "Linked Table Manager" in ACCESS. However, the "Linked Table Manager"
button is grayed out. Any ideas/suggestions are welcome.
Open the table in Design View. Reduce the window so that you can see the
window's top bar. Right click in the top bar of the window (usually blue in
color) and select ...How do I import OE .dbx files into outlook?
Old machine crashed but had fortunately backed up data, including important
OE .dbx files.
How do I import these .dbx files into outlook (no longer have OE) so I can
access the content?
> Old machine crashed but had fortunately backed up data, including important
> OE .dbx files.
> How do I import these .dbx files into outlook (no longer have OE) so I can
> access the content?
Why do you no longer have OE on the old machine that crashed that we are to
assume where you will reinstall the same version of Windows that before had
See http...outlook icon in status bar?
I have a small icon in the outlook status bar since 1
day. It is a harddisk connected to a network and there is
a red cross thorugh the network. ANy idea what it means.
Everything seems to be working fine.
It probably means you're working offline. Try clicking "Work Offline" on
the File menu to toggle back to Online mode.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> I have a small ico...Mails Combined
I mistakenly delete all mails from Inbox and then found them on the deleted Items and selected all and ask to move folders back to Inbox.
the problem is all mails were combined into one email and moved back in to Inbox as a single email.
How do i go back to the original version. How do i uncombined all the mails in to individual mails from the right recipient? Please help ASAP..
Submitted using http://www.outlookforums.com
...Setting up Outlook 2003 #2
I am in the process of setting up Outlook 2003 on my new computer. I believe
I may have click the wrong answer and have put in incorrect information for
outlook to start. I keep getting a box that ask for Username and passcode.
When I put in the information I think it should be, I receive this message:
Unable to open your default e-mail. The file C:\Documents and
Setting\Owner\Local Setting\Application Data\Microsoft\Outlook\outlook.ost is
not an offline folder file.
Please tell me what I should do. When I click OK. Outlook closes. Thanks.
Trying to keep up with technology
G...Cannot send E-Mails, but can Receive them -- Outlook 2003
Okay, I'm completely baffeled by this one. I have two Windows XP machines
(one desktop and one laptop), both with Service Pack 2 (and up to date), and
both have Outlook 2003 installed on them. I've set them both up with the
exact same account with the exact same account configuration options; the
desktop sends and receives just as it should, the laptop can only receive.
On the Laptop, when I go into the "E-Mail Accounts" configuration screen and
click on the "Test Account Settings..." button, a dialog box comes up with
two tabs. The first tab shows that th...Send e-mail to newly created user
I know I can change the Welcome.msg file to customize the Welcome message
generated when Outlook is first started.
I want this welcome message to be initiated from the server and not the
I can write a script, looking at the creation date of a user and send it an
e-mail and schedule this script.
But is there another way to this?
On Mon, 2 Oct 2006 04:52:02 -0700, Gerdo Lansing
>I know I can change the Welcome.msg file to customize the Welcome message
>generated when Outlook is first started.
>I want this welcom...Location of outlook emails
I am trying to retreive some messages from my outlook. I
recently had a crash and have slaved my hard drive into
another computer. Can anyone tell me where the email data
is kept so I can pull off those old emails?
Thanks in advance for your help!
search the drive for "*.ost" or "*.pst"
"Jen" <email@example.com> wrote in message
> Hello all,
> I am trying to retreive some messages from my outlook. I
> recently had a crash and have slaved my hard drive into
&...e-connect error after install hotfix
i have security problem with e-connect after install kb902400 on server2003
if i uninstall kb902400 the module run well. i talk to my MBS about this
problem, but he says the problem came from microsoft in e-connect module
some one have a work around.
...Outlook 2003 Marked as Read
When I ran Outlook/OfficeXP Pro - as I received email the
new mail was highlighted in bold / black and after I
scrolled thru it, clicked on it, or opened it, the
message un-bolded. I migrated to Office Pro 2003 because
Sharepoint is not integrated to XP Office (linked events,
Now new mail comes in and the envelope icon appears. I
literally have to open it for it to be marked as read.
Where is the option to have new mail in bold and marked
as read without having to open it or physically
click "Marked as read"? I looking for the mail option
like I had in all prev...OFFICE 2007 ENTERPRISE english version
I have an original CD with OFFICE 2007 ENTERPRISE hebrew version. In order to
install the english version (menu/toolbars in english but all the documents
features available in both languages) i asked from the vendor for and I get a
supplementary CD (MS-OFFICE-ENG-SLP). How can I install the software, the
hebrew OFFICE first and after that the english kit or invers? Thank's - Niki
Here you will find the Phone numbers and email addresses as to where and whom to
contact about Office Enterprise and your issue.
Scroll down to the bottom of page to North America or to the nearest s...Mail Merge Empty Lines
How do I mail merge postcards and remove empty lines in the address? ex.
Name, Company, address, city, state, zip but some of my addresses don't have
There is a check off in the Print Merge screen *Don't print lines that contain
only empty fields.* Do a test from the print screen if you are unsure.
"Karena" <Karena@discussions.microsoft.com> wrote in message
> How do I mail merge postcards and remove empty lines in the address? ex.
> Name, Compa...Link To A Cell From Chart
I have a text box in a chart worksheet. Can I link it to an information from
any cell in other worksheet in the same workbook.
Yes. Click the text box icon, then click on the chart sheet to insert the
text box. Click in the formula bar and =Sheet1!A2 (or whatever cell you want
Greeting from the Gulf Coast!
"Salza" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Hi all.
> I have a text box in a chart worksheet. Can I link it to an information
> any cell in other worksheet in...links
It is very critical for my business to learn the basics
and the backbone of links in Excel. Are there any
tutorials or articles that gives wealth of information
about MS Excel links? (in Excel 9.0.6)
Web addresses are also welcome.
You can also post to my e-mail above.
Thank you in advance.
I would advise you go to the newsgroup "microsoft.public.excel.links", and
read everything you can about their troubles there and the
Vaya con Dios,
"Mustafa" <firstname.lastname@example.org> wrote in messag...Outlook Ldap distribution groups
Hello all, does anyone know how to setup distribution groups for Outlook in
the LDAP directory. I am using corp LDAP and can create security and
distribution groups in AD with email addresses associated with them, but when
you select them from ldap list, they come back undeliverable. I have a couple
of other posts on this and nobody seems to have the answer. Can anyone help??
...Mailing system for access
We have an in-house access app which runs on windows LAN. We are looking for
an email newsletter mailing solution that can work with contacts data from
the access app. Currently I am looking at this;
http://www.constantcontact.com/index.jsp. The problem is this does not
access data straight from an access database. Does anyone have had
experience with this? Anything that works well with access? Any
recommendations would be appreciated?
On Tue, 24 Jul 2007 03:11:19 +0100, "John" <John@nospam.infovis.co.uk> wrote:
>We have an in-house...Cascading Messages in Outlook 2003
This has been annoying me since the day I installed
Outlook 2003 over my Express 6.0
sometimes when I have a conversatin going on the same
subject with multiple receipients, Outlook cascades
messages, in a Message Board format, so you can see
the 'chain' of replies like this:
and so on....
Other times, Outlook decides it doesn't want to cascade
the messages, so it just lists them on top of one
another, like this:
Why is that? I check all settings under Views, ...