Web Queries #3

I have a worksheet that contains several web queries.  When I try to refresh 
them sometimes it works, but most of the time I get error messages.  Can 
anybody let me know why there is this inconsistency.  
0
Quinn1984 (1)
9/12/2007 8:22:01 AM
excel 39879 articles. 2 followers. Follow

0 Replies
739 Views

Similar Articles

[PageSpeed] 24

Reply:

Similar Artilces:

querying similar databases plan
I'm working with hideously unnormalized databases, most of which have similar structures. (Of course, if they had the same structures, it would be too easy.) I work at a company that does cancer research, so they collect information about their patients over a series of visits. The questions they ask (queries) for parts of the final report are standard across all databases, and then some are specific to a the type of study they're doing. What is the best way to approach this, given that I have to summarize like 20 databases in maybe two weeks, and the column names are not necessari...

Cant send web pages and links
Ive had outlook 2003 for about 6 months all of a sudden I cant send web pages such as MSNBC or CNN...normally these sites have an email direct option...but Ive noticed lately that Outlook is considering these unsafe. I have forgotten how to change my settings so I can send normal web pages that I visit regularly as email attachments. Several of the sites I am able to send appear to reformat them selves so they don't look exactly like the web pages I was viewing. ...

Web Site Generator / Web "Store"
I am looking for a way to export selected products to a web "store" but I do not need a shopping cart feature. I just want to take my items and be able to generate an online catalog really based on the items I have selected to display on web site. It could also use the pictures I have in the RMS database. Any ideas? Jason, How about checking the box in the Item's Options tab for "Item is available on the website" then run a report or SQL query on that flag? -- * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of n...

Free Web Development Tutorials
Free Web Development Tutorials It offers all free web development tutorials, from basic HTML and XHTML to advanced XML, Multimedia and WAP. It also provides references covering all web-building technologies, including W3C standards like HTML, XHTML, CSS, XML and other technologies like ASP and ADO plus much more Go to http://free-tech-ebooks.blogspot.com/2007/02/most-comprehensive-free-web-development.html ...

Data Conversion #3
We have a large downloaded Excel sheet from SAP. It contains lots of figures with negative signs on the right of the numbers. This means that Excel does not recognise these as numbers. Changing the format to Number does not work at all. We need to convert these to normal numbers, that is, with the negative signs on the left of the numbers. What is the quickest way to do this? Thanks! Adeel Adeel, I guess it would be to put this formula in an adjacent column, assuming G, =LEFT(H1,LEN(H1)-1)*-1 and copy down. Then copy column H, pastespaceial values and delete column G. -- HTH ...

How do I add a hyperlink that opens in a new web browser tab in vi
I can pen a hyperlink in a new web browser window but would like to open it in a new Explorer tab instead. not possible yet :-( "jose0208" <jose0208@discussions.microsoft.com> wrote in message news:41369574-DB2B-4396-8E38-EEEAB433EF8D@microsoft.com... >I can pen a hyperlink in a new web browser window but would like to open it > in a new Explorer tab instead. -- David Parker Microsoft MVP (Visio) http://bvisual.spaces.live.com http://www.visualizinginformation.com ...

Web Based Newsgroups *NOT* working
I am unable to access the web based newsgroups from multiple computers. It has affected all Dynamics web newsgroups. Does anyone have a resolution for this or at least know what the problem is? Seems to be working again! -- Micheal LoPatriello Coordinator, Luna Development mlopat@lunadevelopment.com http://www.lunadevelopment.com "Micheal LoPatriello" wrote: > I am unable to access the web based newsgroups from multiple computers. It > has affected all Dynamics web newsgroups. Does anyone have a resolution for > this or at least know what the problem is? > ...

Creating a select query from multiple fields on the same table
Hi all, I've created a table for stores, the primary key is Store Name. I've created another table for input of deliveries to stores on an employee's shift. This is set up as Load 1,2 and 3 with Drop 1,2,3 and 4 in each load. Each drop is validated from the store name field in the store table. Each drop has an arrival and departure time. The relationship set up between the store and deliveries table is a one to many from store name in the stores table to the Load 1, drop 1 field in the deliveries table. The query i want to create is by store, summarising dura...

Serious problem with NET client and Axis web service
This is a repost, with additional information. I have a Net 2.0 client (C# Winform) calling an Axis web service. The .NET client can authenticate, create requested objects, serialize the objects and send. These are received without issue on the Axis server. The .NET client can also receive responses from the Axis web service when the response is a single value type (long, string, etc), or an array of value types. However if an object is returned, it always appears empty. Looking at NetMon, the response values appear in the SOAP message, but it seems that ..Net has trouble deseri...

Web address
I just had M/S Word 2007 installed. The prior edition had a area on the toolbar that supplied the location of the current document I was working from. It was listed in the Web toolbar and it resembled a window that contained the path to the document and the drive. I would use the feature to cut and paste the path of the document into messages when I wanted someone to view the document I was working with. Does anyone have an idea if the feature still exists in the 2007 edition? Add the Document Location item (from either the All Commands or Commands Not in Ribbon) group to the ...

Updating a web site produced with Publisher 2003
When trying to upload the amended file to the web host, my computer says it is publishing the file then is supposed to save it. The little box headed "Saving" with a picture of a file flying across to the recipient just freezes. I wait until I get tired, cancel it and the message Publisher gives is to 'check the URL or network settings'. I am not using a network so what URL am I supposed to check, please? Also, in the 'Publish to the Web' box, what 'File Name' should I type in? Is it "index.htm"? Is this where I am going wrong? see http://www....

Defrag #3
Hi All The PRIV.EDB on my Exchange 5.5 server has grown to 35gb. This server was the main server but I have since built a further two Exchange servers, added them to the site and moved mailboxes off it. This server is now primarily used as a Bridgehead with connectors to other sites, Public Folders and also hosts the Internet Mail Service The backups are still backing up the information store of 35gb, which I gather will only reduce after a defrag is performed. I am worried that if I perform the defrag, Internet and Intersite mail will stop. (Am I correct to assume this? What else can I do...

CRM 3.0 and SQL 2005 Workgroup
Anyone running SQL 2005 Worgroup Edition with CRM 3.0? We've done a few installation with SQL2005 Std and Enterprise and they went ok, but I did an installation against a Workgroup Edition yesterday and when I try to run reports I get the following big ugly error: "report history snapshot is not supported on this version of reporting services" Anyone see that before? I haven't come across any documentation saying that Worgroup won't work. More background, CRM and SQL on the same box, Windows 2003 R2. Thanks it advance, Dave Ireland ...

Getting an update query to run automatically
Hi, I wish to get an update query to run automatically (and first) when other queries are run. In the database are queries which are dependant on a table (Table A). This table contains information from another table (Table B) which changes daily. A query has been created to update my table (Table A) from the original (changing) table (Table B). Other queries have been created which play around with the information from my table(Table A). So in order for these other queries to be up to date there is a need for the update query to be run first and, hopefully, automatically. Where on earth do ...

Outlook Web Access Web Administration
I have downloaded the Outlook Web Access Web Administration package, installed it onto a Windows XP machine that is part of the same domain as the Exchange 2003 server we are running. I have ASP.net, .NET, IIS all running. When I attempt to connect to our Exchange server, I get a "page not found" error. When I connect to my own machine, I get a broken page with lots malformed XML. I have read the Readme, read numerous postings online, and I cannot seem to find anyone else that is having the same difficulty in getting to Outlook Web Access Web Administration to run properly...

problem refreshing data query on yahoos
Yahoo reports a connection has been made but the data is not available in my stock portfolios I have been refreshing for several years. This has been happening for the past few days. Anyone else having this problem? ...

Image attachments problem #3
I am trying to set up outlook 2002 (XP). When we receive a message from someone with image attachments (jpg, gif) we are unable to view them in the message. How do I make it so we are able to view image the images in the actual message. I have tried everything, well almost everything. Can someone help? Thanks Auto auto <anonymous@discussions.microsoft.com> wrote: > I am trying to set up outlook 2002 (XP). When we receive a > message from someone with image attachments (jpg, gif) we > are unable to view them in the message. How do I make it > so we are able to vi...

Business Portal Web parts in the top level site
Is it possible to show BP Web parts in the top level site? For instance, show the Company News from the BP home page in the / of the sharepoint site? I am using MOSS 2007 Enterprise. TIA ...

Can field names be changed with a query?
I've got a sequence of queries that culminates in a final make-table query. I would like to change the fieldnames with the final query, producing the table with new fieldnames. Is there a way to do this? Thanks, Patrick Sure. In the field name put what you want to see in the new table like so: NewName: OldFieldName What is before the colon ( : ) should be the new field name. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Pat" wrote: > I've got a sequence of queries that culminates in a final make-tab...

Publish to web issue
I am guessing someone else has posted this but I tried to read through the archives and couldn't find the exact answer. I publish a newsletter for a non-profit using Publisher. I originally had Publisher 2000 and never had any problems when I selected publish to web. It would run a checker and tell me I had images overlying text boxes but it didn't alter the publication in any real way. When I "upgraded" to Publisher 2003 and select publish to web...all of the images end up in front of the text . If I go to Format Picture and select inline it breaks the text in really...

Normal & Normal (Web) Styles
I have customized the top bar (the title bar?) in Word 2007 to display the Syle. In parts of the document that works well it says Normal(Web) and in the areas that I'm having spacing problems it says Normal. How do I format it to Normal(Web)? I believe you are referring to the Style drop down which can be added to the Quick Access Toolbar. In the Style drop down you can pick a style name, or you can type one in. In this case, you can try the latter. Note, however, that you can *modify* the built-in styles to suit your needs. Display the Apply Styles pane, for example ...

How to reference a control value in a row source query?
How to reference a control value in a row source query? I have two combo boxes on a form the value of cboA I want to use in the row source SELECT of cboB. In the query designer for the row source of cboB I have entered for the WHERE clause: =[Forms]![form_form1]![cboProjectName] I have left the Access default form names The actual SELECT from the SQL View is SELECT ProjectToParticipant.ProjectID, Participant.NameLast, Participant. NameFirst, Participant.NameMiddle FROM Participant INNER JOIN ProjectToParticipant ON Participant.ParticipantID = ProjectToParticipant.Particip...

creating query
I am getting a message about having an ambiguious outer joinin one attempt and duplicate records in another. I have a database containing information from all of the football plays in a game. I have many tables but 4 of them are "main", "formation", "play", "playdiagram" The main table has the following fields [mainid] score time formationid runid the formation table has many fields including [formationid] formationfamily backfield variation strength the play table has the following fields (it consists of both a formation and a play) playid fo...

Web to Lead or Web to Case
Does anyone know if it is possible to monitor a mailbox and automatically create cases/leads based on an email. For example, lets say we have a mailbox called support@mycompany.com - if a request comes into that mailbox, i'd like it to automatically create a case and enter the queue for the next available support technician. or, have a mailbox called sales@mycompany.com and have a lead automatically generated. We have CRM 1.2 installed and working very well with exchange 2003 - we are able to get the email messages into the crm system, but, since i can't do workflow on an email mes...

Web Query from multiple tables
I'm using a web query to import data from multiple consecutive tables. However when it imports the data, it leaves a blank row in between the data from each table. Anyone know of any way to get rid of this- meaning to just have it list one table after another with no breaks. Thanks Joel ...