Multi Table Queries
At my job, I use enter data through generated queries. However it appears
that I can only ENTER data in a query when it is based on two tables. If it
is three or more, it doesn't let me enter any info.
Is this normal? Am I doing something wrong?
>At my job, I use enter data through generated queries. However it appears
>that I can only ENTER data in a query when it is based on two tables. If it
>is three or more, it doesn't let me enter any info.
>Is this normal? Am I doing something wrong?
Yes, that's common. You should only edit data ...microsoft money #10
I tried to open Money on my computer (version 2003) The original page was
replaced by Microsoft. How did this happen? How to I get my original files?
What "original page"? What makes you say it "was replaced by Microsoft"?
Have you tried opening your original files? (Money File|Open or double-click
on them from Windows Explorer.)
"DR support" <DRsupport@discussions.microsoft.com> wrote in message
>I tried to open Money on my computer (version 2003) The original page was
> replaced by Mi...SQL Reporting Services and GP 10
Is it possible to associate SQL Reporting Services reports with SOP invoices
in GP 10.0 rather than with Report Writer?
I know that Accountable Software has Forms Printer, but I believe that that
only works with Crystal.
And, I know that there are SRS reports written to display data from GP but I
do not think that these reports will work in terms of printing invoices or
orders from SOP.
No not really.. The problem is that when an SOP or POP document is printed,
GP needs to be updated. Accountable does that with their Crystal interface
but I dont kno...IIF stmt in query
I would like to return different results for different conditions more than
one field. here is my IIF stmt:
any help is greatly appreciated. Thanks
You can AND the conditions, but it would be preferable to use a table to
make the translations.
iif( type = "A" AND country = "USA", "FMYHF002",
iif( type = "A"...Report of sales by month based on a cross tab query
I have a cross tab query that will provide sales by month for 2008. Right
now it is sales for January08. As there are sales for future months, they
will appear as well. I want to create a table that has all of the months
listed out already. Right now, on the first day of the month, I go into the
report and add the new month. I want it so that all month are listed which I
have done. The problem is that when I run the report, I get an error that
says "the Microsoft Jet does not recognize February as a valid field name.
After today, there will be February data but no March ...only the first 5 columns of a 10 column excel spreadsheet sort
How do I get the whole spread sheet to sort? There is a blue lox for the
first 5 columns that limits the range of the sort. How do I remove it?
Using Office 2003.
Maybe if you remove the Data|list
Select a cell in that blue box.
Data|list|convert to range
> How do I get the whole spread sheet to sort? There is a blue lox for the
> first 5 columns that limits the range of the sort. How do I remove it?
> Using Office 2003.
...Combo Box problem 08-04-07
Why is my combo box in both the table and the bound form not accepting the
hand-typed value and produces a "value not an item in the list" error even
though I know for sure the value IS in the list? When I select the value
from the list it wqorks fine and goes on to the next field.... Thanks
> Why is my combo box in both the table and the bound form not accepting the
> hand-typed value and produces a "value not an item in the list" error even
> though I know for sure the value IS in the list?
No, the value _isn't_ in the list, because you ...ODBC Failure In JOIN Query ??? (BUT....)
I have a query that is simply a combination of 3 other queries (joined by 1
common field in each).
Each of the 3 "sub queries" will execute fine, Individually....
But....that final query which simply combines them all will display an ODBC
I'd always assumed that if each individual query ran okay....the query which
combines them should not get such a data-access related error (since the core
data is already being successfully accessed).
Has anyone else experienced this and found a solution?
Thanks very much
Message posted via AccessMonster.com
http://www.a...LINQ related query
I have a question regarding joining xml files on a key which is present in
all file, following is my code
docFTR is of type XDocument
xdList is List(Of XDocument)
Dim doc = From x In docFTR.Descendants("Data") From i In xdList.GetRange(0,
1) Join d In xdList(0).Descendants("Data") On x.Descendants("Guid").Value
i need to programmatically replace xdList(0) with the current XDcoument
which comes from "From i in xdList.getRange(0,2)"
GetRange(0, could be 2 to 10)
Any help is welcome...GP 10.0 Fails to install .Net Framework 2.0 not installed
I'm trying to install GP 10.0 on server. We have .net framework 2.0 sp1 and
3.0 installed. We have windows sharepoint services installed on framework
3.0. When we try to install, it is returing error .Net framework 2.0 not
installed and ending prematurely.
I've tried the workaround provided in Partnersource (KB ID 947538) for .Net
2.0 sp1. However it is not working.
Jack - unfortunately, unless you write out the command line scripts exactly
as they say in the KB, it will continue to bomb. Microsoft is costing us
hours and hours worth of unbillable time to work aroun...problem opening word 07
When I open word, a dialog box comes up which contains. among other things,
the following instructions which I follow up to step 4 then I hit a snag as
>The document contains macros. Macro language support for this application is disabled. Features requiring VBA are not available, Would you like to open this document read-only?
Hide Help Open in Help Window
• Microsoft Office Access, Microsoft Office Excel, Microsoft Office
PowerPoint, or Microsoft Office Word -¬To check your macro security settings,
click the Microsoft Office Button, click <program nam...upgrading to exchange 2003 07-09-04
We are upgrading to exchange 2003 from exchange 2000.
What do we need to do to keep our crm 1.2 working?
Might be necessary to re-install the CRM email router on
the exchange server once you've completed the upgrade.
>We are upgrading to exchange 2003 from exchange 2000.
>What do we need to do to keep our crm 1.2 working?
>Might be necessary to re-install the CRM email router on
>the exchange server once you've completed the upgrade.
>...Query Not Working 06-11-07
I have set up a query for 1 table.
The field I'm trying to run the query on is a text field. I enter a name
(="smith, john") I get zero results. However I have confirmed that this
user exists in the table.
Also (if this helps), this field gets populated via a combo box on a form.
The table being used for the lookup contains a "user" field which is also a
sometimes this is caused by a leading blank in the field. It displays very
one solution sname: TRIM([field])
"CT" <firstname.lastname@example.org> wrote in message ...Microsoft Query #4
I receive message SQL0104 when changing a column heading
in Microsoft Query while using the Client Access ODBC
driver to connet to an iSeries 400 server. I have been
informed by IBM that this is a problem with Microsoft's
Query in that it incorrectly quotes the new Column Heading
name before sending it to the ODBC Driver . Is anyone
aware of a update or solution?
Thanks everyone, I just located the following Microsoft
Knowledge Base Article 298955, I followed the procedures
below, and the SQL0104 error went away.
1. Quit all Office programs..
2. Click Start, and ...CRM 1.2 07-27-06
My company wants to move away from CRM 1.2. They want to keep using the CRM
database because of the volume of data that resides their. Can they still use
the CRM database after the CRM 1.2 license expires?
Yes. You own the data. As for the "license", it doesn't really expire.
You have the rights to use the software, but you have a support contract
which will expire. Once that expires, you will not be able to get free
upgrade tot he software, but you can still continue to use the app.
MVP - Microsoft CRM
"Hammer" <Hammer@discussions.microso...Combo values from query based on form fields
I am setting the values for a combo box in a form(s) via a query that
'filters' the results with criteria based upon the values of other fields on
the form. The combo is a field that is bound. However, this is giving all
kinds of problems ranging from Access completely crashing to being asked for
the parameter values of those criteria fields when closing the form. I have
tried making the combo an unbound field and then setting the value of the
bound field to that unbound field after update, but that still leads to the
same issues. How can I do this?
As example - I have a form w...Auto Filter 03-10-10
When I use Auto Filter and select the criteria I want to filter by and then
go back to select all criteria certain rows are hidden, it does show all
rows. Anyone know why?
Did you mean "it does NOT show all rows"?
If yes, then I'm guessing that you have more than one field/column filtered.
In xl2003 menus, I'd use:
On the xl2007 ribbon, I think it's:
Data tab|Sort & Filter group|Clear
> When I use Auto Filter and select the criteria I want to filter by and then
> go back to select all criteria cer...SFO error message "write protected change are not synchronized" 07-28-05
When I am changing (closing) an kalender activity from my CRM SFO
recieve an message that "The item is write protected in Microsoft CRM.
Changes are not synchronized to the Microsoft CRM system" (translatet
Do you have any ide what i wrong?
...WMDC in Windows 7 Ultimate 05-17-10
I installed Windows 7 Ultimate (32 bit version), and now I can't sync my HTC
smartphone with my PC. Worked fine previously with Win 7 Home Premium, but
now whenever I try and use/install Windows Mobile Device Centre, I get an
error message saying WMDC can't be installed because one or more Windows
components are missing.
restarting and reconnecting my smartphone
rebooting my PC and reconnecting phone
installing windows updates
donwloading WMDC 6.1 and re-installing - all with same result
where do I find the missing Windows components to make WMDC work?
...Union Queries and Foreign Keys
I have a Union Query that combines two tables with identical
fields/data types. The problem I am having is trying to get the
resulting recordset to display the names of the organizations instead
of the OrgID value. The recordsets that display when running the
Queries that the Union Query is based on display the Organization name
properly. Is there a way to do this using a Union Query?
First they ignore you. Then they laugh at you.
Then they fight you. Then you win....Mahatma Gandhi
Russ Rollins wrote:
>I have a Union Query that combines two tables with identical
>fields/d...<no subject> 04-27-10
...Microsoft query returns no data, Office 2000, Excel
I run a query in Microsoft excel, with Microsoft access as the data source
This spread sheet is accessed throughout our company, and works fine on all PC's but one
The query returns no data on this particular PC
In addition it does not return any errors
Could someone assist me regarding this quandary
...e-mail location 04-13-04
Can anyone tell me if I have a default e-mail location
for my Excell program that came with my new Dell?
wow................I don't know where to even begin with this one......
"Bob Kasper" <email@example.com> wrote in message
> Can anyone tell me if I have a default e-mail location
> for my Excell program that came with my new Dell?
If you have bought a new DELL you should have support with it as well. I
would suggest giving Dell a call and they can walk you through some of your
The following quote is posted on behalf of a client using Windows and
Office 2003 Standard. Please email responses directly to me, too,
since I do not read this group much.
Any help/insight would be most appreciated. I'll do my best to relay
any questions people have and bring back any answers to said questions.
In an effort to come up with a new way of looking at organizational
structure, I employed Excel's 'Donut Chart' function. My goal was to
have the head of the organization in the middle of the chart and then
that person's direct re...Open one form with different queries
Is it possible to open one form using a different query depending on what
button the user selects. For example:
I should also mention that this form has a subform.
Got it. Below is what I put behind a button on the form for Sort High/Low and
it filters using a query.
Dim stHighLow As String
stHighLow = "SortHighLow"
> Is it possible to open one form using a different query depending on what
> button the user selects. For example...