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
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
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
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?
I guess it would be to put this formula in an adjacent column, assuming G,
and copy down.
Then copy column H, pastespaceial values and delete column G.
...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" <firstname.lastname@example.org> wrote in message
>I can pen a hyperlink in a new web browser window but would like to open it
> in a new Explorer tab instead.
Microsoft MVP (Visio)
...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" 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
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
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
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
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
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
Thanks it advance,
...Getting an update query to run automatically
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
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?
auto <email@example.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
I am using MOSS 2007 Enterprise.
...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?
Sure. In the field name put what you want to see in the new table like so:
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.
> 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
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:
I have left the Access default form names
The actual SELECT from the SQL View is
SELECT ProjectToParticipant.ProjectID, Participant.NameLast, Participant.
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
I have many tables but 4 of them are "main", "formation", "play",
The main table has the following fields
the formation table has many fields including
the play table has the following fields (it consists of both a formation and
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 firstname.lastname@example.org - 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 email@example.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.