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...Forwarding rule doesn't work, Outlook 2002 & Exchange 5.5
My company's email is hosted on an Exchange 5.5 server.
In my Outlook 2002 (Office XP) client, I have set up a
rule to forward all inbound messages to an external email
address. This rule is only triggering, however, on
internally generated messages such as Outlook meeting
invitations or McAfee Groupsheild email alerts. No other
messages (internal or from the internet) ar being
forwarded. Any suggestions would be appreciated. Thanks!
...Converting website type project tot ASP.NET Web application
in VS2008 a new project type is born called ASP.NET Web application. From my
VS2005 development I had a website type project. This is still supported in
vs2008, but I would like to convert it to the new type.
Is that possible. How?
On Feb 3, 10:27=A0pm, "ton" <t...@nospam.nl> wrote:
> in VS2008 a new project type is born called ASP.NET Web application. From=
> VS2005 development I had a website type project. This is still supported =
> vs2008, but I would like to convert it to the new type.
> Is th...For Some Reason My Schedule is Working through Weekends
Is there anyway to correct this in one operation??
TMI Contractors's Profile: http://forums.techarena.in/members/216904.htm
View this thread: http://forums.techarena.in/microsoft-project/1338262.htm
Check the calendar for the project, and if a different calendar has been
assigned to specific tasks (Tools > Change Working Time, Project > Project
Information, and the Task Calendar column respectively).
Check the resources assigned to the tasks...CDialog::DoModal() doesn't work the second time
I have created a MFC dialog based application (using the wizard). it
works fine. then I decided to display the same window twice:
// the code generated by the wizard
m_pMainWnd = &dlg;
INT_PTR nResponse = dlg.DoModal();
// the code I added
nResponse = dlg.DoModal();
// the generated code follows
The second time when I invoke DoModal, the window appears for a very
short (sub second) time then vanishes. the return code is -1 which
means that the window couldnt be created. I tried with a new dialog
// the code generated by the wizard
m_pMainWn...adobe pdf printer taking over :(
I have a 3 page report I print in ms access. Each page is a separate print
job and recently I had to email page 3 to someone so I used the adobe pdf
printer. Now every time I run the report the 3rd page always tries printing
via adobe pdf instead of the default printer. I have tried printing the
single page using the default printer but it doesn't remember the choice. I
have also tried rebooting but that didn't help. Any suggestions on what to
do besides uninstall adobe pdf from printers?
This is really frustrating because now every time it gets to page 3 it tries
to print pdf...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.
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
____...remove space and chars. replace() does not work
I need to remove characters and spaces from a database field and
replace() is not working for me. I dont know if I am using it
properly. I am putting it in the queries window and it says I cannot
use it without select or update. Can some1 help me on how exactly to
Thank you in advance.
>I need to remove characters and spaces from a database field and
>replace() is not working for me. I dont know if I am using it
>properly. I am putting it in the queries window and it says I cannot
>use it without select or update. Can some1 help me on how exact...Convert year
When I import automotive data from another database which shows model year
in two-digit format, into excel, the model year imports as follows; 98 = 98,
but 01 = 1 02 = 2, etc. I have installed the date migration tool, but I
still can't seem to convert the year into a four digit format. Is there a
way to convert a column of one or two digit numbers to four digit year?
Thanx for any help.
"JaR" <firstname.lastname@example.org> schrieb im Newsbeitrag
> When I import automotive data from another database which sh...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 ...Why Won't this code work with different Bitmap Sizes?
Whenever I try to change the bmpWidth, and bmpHeight
very much, it only prints a blank page.
For example bmpWidth = 640, and bmpHeight = 480,
only prints a blank page. Why would this be?
you should contact the author regarding this.
visit me at http://alok.bizhat.com
"i think this will work"
"Peter Olcott" <email@example.com> wrote in message
> Whenever I try to change...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...PDF Attachments Stuck in Outbox
I am experiencing a problem with PDF attachments being sent out. They get
stuck in the Outbox and continue to send the message hundreds of times.
On Mon, 27 Mar 2006 13:43:02 -0800, Jason [IT/CAD]
>I am experiencing a problem with PDF attachments being sent out. They get
>stuck in the Outbox and continue to send the message hundreds of times.
Disable any AV on the workstation and server.
Disable just a certain aspect of the AV for attachments? If so, could you be
"Andy David - MVP" wrote:
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...working with multiple e-mails
We are working as two companies in our office. So every user in office has 2
e-mail account with the same username but with different domains. What we
need to do is let them work with both e-mails together in outlook.
But what important is I should prevent mistakes like sending mails from
wrong account and receipts shouldn't see anything with the other company..
Can anyone offer any architecture for it or any recource on the web..?
(sorry for the bad english)
...Setting up Outlook Express to work with an MSN e-mail account
Does anybody know how to set up Outlook Express to work
with an MSN e-mail account? There are instructions for
Hotmail but they don't work. Any help is appreciated...
"J.O." <email@example.com> wrote in message
> Does anybody know how to set up Outlook Express to work
> with an MSN e-mail account? There are instructions for
> Hotmail but they don't work. Any help is appreciated...
This newsgroup is for support of Outlook
97/98/2000/2002/2003 from the Office suite of products. Outlook
Expr...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...Manual archive failed to work
I want to manually archive e-mails in my Personal Folders- Inbox and Sent
Items subfolders. I have Auto Archive turned OFF for all Personal Folders
Subfolders. My Inbox and Sent Items folders are very large and I want to copy
everything in them prior to 01/01/2009 to the Same Folder Names in the
Archive Folders and have them deleted from the Personal Folders. When I
execute the manual archive nothing happens. I have been selecting Archive
from the File Menu, then clicking the Archive this folder and all subfolders
button, then selecting Inbox (under Personal Foldres) in the list,...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...Outlook Rules Not Always Working
Anyone with feedback on how to resolve this would be appreciated.
I have set up rules in Outlook to divert EMails sent to our corporate
Help Desk to a folder I have set up in Outlook called "Help Desk".
Some exceptions have been set up within the rules - EMails sent to Help
Desk from certain companies [my customers] are not diverted as I want
them to come into my Inbox. This setup worked fine until a couple of
weeks ago when it stopped working completely. Aside from un-installing
& re-loading Outlook completely we have done just about everything. We
deleted the rules & re-...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...Tables to PDF
I'm working with a table in Publisher at the moment & have formatted all my
column / row gridlines to 0.25pt. However, when I convert to Adobe PDF, some
of the lines appear much thicker than the others.
Have you tried printing the .pdf file? I've seen lines that look thicker but
print just fine.
MVP Microsoft [Publisher]
"ianp" <firstname.lastname@example.org> wrote in message
> Hi there,
> I'm working with a table in Publisher at...