Excel hart has OLE onject errors in Access 2007
I am trying to build a chart on a form in Access 2007. I have already
created it in Excel and want it to look the same but it seems that the
formatting options are greatly reduced, fewer chart options, and formatting
variations in Access.
I tried to copy and paste the chart from Excel 2007 onto my Access form, and
gave it the query as the data source but got messages "The operation on the
OLE object failed. The OLE server may not be registered. To register the
OLE server, reinstall it."
If I remove the name of the query I get an identical chart to the one in
Excel, ...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...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...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.
...Can I insert Auto Text of Last Updated in Excel 2003?
Can i do the above on a sheet or in a Header/Footer?
Using a macro yes
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"jess_steven" <email@example.com> wrote in message
> Can i do the above on a sheet or in a Header/Footer?
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
____...Access Formula For Dates
I need to show on a weekly basis, the number of weeks left in the year. I
don't want to have to enter it, I want Access to calculate it for me and show
it on my report/database each time it is opened. For example , I want to say
there are 34 weeks left in this year. Is there a formula I can usethat will
determine the number of weeks remaining from today's date (whatever it is) to
One way to look at this is that, if you can identify the "week" of the
current date, you can subtract that from 52 to get an idea of how many weeks
.... o...Running a combo box on a continuous form
I have a continuous form bound to a table containing names, addresses and
post codes. A combo box, in each record, lists service agents covering the
area identified by the associated post code. On GotFocus, the combo box runs
a selection query taking the associated post code as the criterion. A
requery is necessary to ensure that the list of service agents is refreshed
on changing records but that all works fine. Clicking the combo box
drop-down arrow for any record confirms that the correct list of service
agents is displayed in each case. However, no selection can then be effecte...Exchange 2003 OWA customisation
Is it possible to change the title of Outlook web access pages? I have
found the logon.asp and logoff.asp pages and changed the wording and titles
on these but I can't find the main page.
Does anyone know how to do this?
maybe this articles will help
"Gary Hindson" <firstname.lastname@example.org> wrote in message
n...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 ....NET Webservice Accessing Exchange 2003
I would like to setup a .NET webservice that will access an Exchange
2003 server and perform the following tasks:
1) Given a particular email address, return all headers/subjects that
matches the TO or FROM field. The purpose would be to return all
emails from a particular individual in order to enhance a home grown
CRM system. It would have to search a select few exchange mailboxes.
2) Given the particular email, return the body of the email.
Is this possible? If so, what kind of performance am I looking at
here given upwards of 20,000 total emails in 3 or 4 mailboxes?
If this is possib...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...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...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...Public Form Classes
We (unfortunately) had an outside source write a utility app. (This is
the one using the Telnet session I asked about previously.)
The guy wrote a class that wraps the Winsock control utilizing.......
"Private WithEvents Socket As MSWinsockLib.Winsock" at the top of the
class....I'll call it clsROS.
Now here's the question......
There is a login form, and a GUI configuration form. You use the login
form, and when successfully logged in, the GUI config forms shows.
The login form has a privately dim'd clsROS on it.
The GUI form has a public dim'...Exchange 2003 OWA not loading messages
We have an issue where OWA (on Exchange 2003) logs in correctly & displays
the interface correctly but does not load any messages in any folder. Only a
"Loading..." message is displayed. Usually it is possible to compose new
emails but no current messages will be listed.
This problem does not appear consistent but behaves differently depending on
IE security level and IE version/patch level.
Using another browser almost always works and loads the messages correctly.
I have located the 3 or 4 ActiveX and scripting security settings whic...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...Microsoft money 2003 #4
When I try to enter a transaction into the register I get
the following response: "This transaction cannot be
enterred". This problem just popped up and has never
I would appreciate any advice.
In microsoft.public.money, Charlie wrote:
>When I try to enter a transaction into the register I get
>the following response: "This transaction cannot be
>enterred". This problem just popped up and has never
>I would appreciate any advice.
If you don't have a rec...Outlook 2003: Hiding Folders
Ignorant Outlook user here... Outlook 2003.
My office PC is potentailly viewable by many different people...
Is there any way to either hide, or encrypt individual folders inside
Specifically folders in my Inbox?
Any 3rd party apps if Outlook won't do it?
Are you using an Exchange server?
Do the others need to access your machine, or is it just that your machine
is in a fairly public location?
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post qu...access info
i want to make a form that shows info in subforms when i click on a name in a
combox box. HEELPPPPPPPPPPPPPPPPPPPPPPPPPPPPP
That's not the way subforms work. Forms/subforms are for one-to-many
relationships. The main form displays the one side and the subform displays
the many side. For example, suppose your database records customers and
their orders. A customer might have many orders so you have a one-to-many
relationship. The tables should look like:
<fields about a customer such as name and address>
<field...open continuous form
How can I set continuous form to open showing top of recordset, rather than
Switchboard manager opens to show empty new Add row, even when set to Open
in Edit mode. Can scroll up to top, but when open form right from database
window in a2003, opens form from top of recordset.
On Oct 31, 4:03 pm, nycdon <nyc...@discussions.microsoft.com> wrote:
> How can I set continuous form to open showing top of recordset, rather than
> Switchboard manager opens to show empty new Add row, even when set to Open
> in Edit mode. Can scroll up to top, but when open ...Excel 2003 tries to Set Up
I have Excel 2002 loaded on my PC. Just recently, when I try to open an
Excel file, it goes thru Windows Installer and comes up with MS Office 2003
setup window.....asking me for user name, initials, product key.
In order to get around this, I have to open my Excel 2002 program first, then
Open my file.
Can anyone please tell me why this is happening all of a sudden? It is very
Not quite sure myself but may be that the Excel files you are opening were
created in an earlier or later version of Excel and when you try and open
them they search for that vers...