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...linking #4
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.
...sharing outlook with 2 or more computers?
I have 2 networked computers both running windows xp i
want to share the same out look program and files is
there any way of doing this??
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
____...outlook 2003 has 2 "send" labels in the send receive drop down
hi, sometimes, i have to reboot my machine because the send recieve button in
outlook does not work, when i go to the drop down menu, i dont see any of my
"accounts" listed, and I see the word "send", then the next line is
duplicated and also says 'send". the only way to get back to "normal" is to
reboot the whole system until it happens again. This usually happens once per
Close Outlook. Do a search for the outcmd.dat file (this is a hidden file so
you'll have to either tell Windows Explorer to unhide it or search hidden
files and folder...Email forwarding #2
Is there anyway to get your outlook emails forwarded
Microsoft Outlook, not Express?
1). Tools\Rules and Alerts...
2). Our Redirect add-in (www.mapilab.com), it redirect email and new
recipient will receive the full copy of message, including internet
headers and the same sender as in original email.
> -----Original Message-----
> From: Jason [mailto:Jason@nts.uk.net]
> Posted At: Wednesday, June 30, 2004 3:46 PM
> Posted To: microsoft.public.outlook
> Conversation: Email forwarding
> Subject: Email forwarding
> Is there anyway to get your ...Upgrade Path sbs2000/sbs2003r2 and CRM1.2/3.0
We currently have CRM 1.2 installed on a sbs2000 server. We are looking to
upgrade this server to sbs2003r2 and we also want to upgrade CRM from 1.2 to
3.0. Can someone recommend the best upgrade path?
This is partial book smarts and partial experience...
Upgrade to CRM 3.0 on the SBS2000 box (assuming SQL 2000)
Redeploy to SBS2k3R2 box using CRM 3.0 redeployment tool
Upgrade to Rollup 1
My experience was to take it from a 3.0 to 3.0 on R2, so I had a SQL 2000 ->
SQL 2005 on a new domain. I recommend that you backup and follow the
directions to a T.
The up...Address Book Problem #2
Outlook version: 2003
When in a Distribution List, I click on [Select Members] and get this MS
Office Outlook message:
The list could not be displayed. The Contacts Folder associated with this
address could not be opened; It may have been moved or delected, or you do
not have permissions. For information on how to remove this folder from the
Outlook Address Book, see Outlook Office Outlook Help.
This is a recent problem.
Sounds like you have an invalid reference to a Contacts Folder. reset those
Tools > E-mail a...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: ...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
is there a formula for a continues monthly calendar?
not exactly sure what you're after here but if you enter
01/01/05 in a cell and drag down (autofill handle, little back cross bottom
right of cell) it will increment by a day for each row.
If you'ld like more assistance please feel free to post back with additional
"tg" <firstname.lastname@example.org> wrote in message
> is there a formula for a continues monthly calendar?
...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 ...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" <email@example.com> wrote in message news:firstname.lastname@example.org...
> 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" <email@example.com> wrote in messag...Text Wrap #2
Is there anywhere in Publisher that i can customise my preferences? I would
like to change the default settings for inserting an image to no text wrap.
This is a time consuming process everytime i insert an image (right click,
format object, layout tab, wrapping style "none", ok), would be so much for
efficient for me if i could change the default settings so that the image
came in like this when inserted (currently the default wrapping style is
"square"). Any ideas?
...Linked Tables Over A LAN
Hi, I have a problem with a PC that is sharing an Access database over
a LAN. I'm hoping someone may be able to give me a little advice. By
the way, I'm a bit of an amatuer so go easy on the technical
I've got four PCs networked through a router which provides internet
access. Two PCs are running XP Pro and two are running Vista Business
32bit. One Vista machine holds my full database while the other PCs
have a similar database but with tables linked to the first machine.
Been running this setup for several years, on various older PCs, with
My proble...Upgrade to CRM 1.2
I just updated CRM to version 1.2 on our demo server(we
are using Adventure Works Cycle database).
In the grid section (grid_data.aspx), everytime I want to
select a row in the grid (onmouseover and onmouseout
events) a message will show saying "Object required.".
That's because the function on() and off() that are
called for these events cannot be found in the grid.js
<table id="gridBodyTable" onmouseover="on();"
The version that I have is CRM v1.2 North America - RTM.
Doru...Address Book Question #2
How I can I change it so the address book in Outlook 2002
shows if the address is the email address or the fax
number or a second email address? Right now it just shows
the person's name in the address book when you choose
contacts and you have to scroll over to see the display
The only to tell is the way you are already using i.e. by scrolling, no help
to you but this has been greatly enhanced in Outlook 2003.
"Mellisa" <firstname.lastname@example.org> wrote in message
> How I can I change it so ...Links
Every time I open a spesific workbook, I get the question if I want t
use the old or the new data. This is very irritating! How do I disabl
the link that is the reason for this message??? Please help me befor
this drives me CRAZY!!
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You will have a formula somewhere within the wordbook that is linked to
another workbook. You can look for them manually and the copy>paste
special>values... to kill it. or you could d...library not registered #2
I am using Windows 2000 & Office 2002. When clicking on Outlook today I get
the following error:
An error has occurred in the script on this page.
Error: Library not registerd
Do you want to contine running scripts on this page? Yes No
I have tried the following to fix the problem:
repair outlook, uninstall/reinstall office; disable script debugging;
renaming the .olb files & runnining a repair
none of which seem to work can someone please offer some alt suggestions?
...email links in Publisher pdf
Why won't Publisher 2007 convert my email links correctly when saved in pdf
format? It puts "mail to:" in twice automatically. It is converting website
links without a problem.
If memory serves the Office 2007 SP1 fixed this in Publisher. The SP2 is
also now available. There have been some reports of not being able to open
existing Publisher files after installing it, and a report that a fix for
that bug is due by the end of the month....you might want to wait to install
SP2 until after the first of the month, or just install SP1.
"Rora" <Rora@discu...Chart template and links
I have something "strange " (at least for me) going on ...
I have an xls workbook, containing some data sheets and also 3 chart
templates. These chart templates are copied via a macro to the output
xls with the statement :
When I now look to this chart template in the output xls I got a link
to the original xls workbook in which the macro is running. (I can see
that via EDIT>LINKS...)
Now I do NOT want that link to the originator xls workbook at all !
Is there anybody who knows how I can co...HQ Client Configuration #2
From one store, in HQ Client config, I set the server name as "MYHQPC". Over
a VPN, it connects to my HQ laptop (only after I ping from mylaptop to the
But from another store, the server name does not work so I have to enter the
current IP address of my laptop.
So my question is where does the HQ Client traslate the server name to IP
address? Is it at the router?
The translatin is done through the FQDN (Fully qualified domain name system)
or we can say DNS, do you running any internal dns or not. since connecting
through VPN have some obsticle so I suggest yo...Linking to ODBC Linked Tables
I wonder if you have any suggestions for this. We have moved our Access
tables into Oracle and have created a MS Access Database that links to these
ODBC tables. Each of our users has a local copy of our Reporting Database
that formerly linked to Access tables, but now we want them to link to the
Ms Access Database which contains the linked ODBC tables on our shared
drive. In trying to link to already linked ODBC tables, Access gives an
error and will not link to these tables.
Is there a way to let our users link to the Access database that contains
the linked ODBC tables?
Any...messages with subject part 1/2 not showing up in mailclient
We have a scanner in house and it emails documents we scan to us via exchange.
The problem is, it breaks documents up in to multiple messages subject part
1/2, part 2/2 etc to us. When ever it does this, we don't recieve the
In the exchange tracking center, it says the messages is delivered locally
SMTP Store Driver: Message Delivered Locally to Store to email@example.com
(my email address)
is the last message, but I never see the message... it isn't in my junk
email or anywhere... and I don't know where else to look. I'm trying to