Database query, spreadsheet size
I have a spreadsheet with several database queries from
SQL Server. As queries are refreshed, spreadsheet size
continues to grow. Even when I wipe out the queries, the
file stays around 300K. Does anyone know where this
extra data is sitting and how can I clear it out.
300K is not that big but have a look at:
>I have a spreadsheet with several database queries from
>SQL Server. As queries are refreshed, spreadsheet size
>continues to grow. Even when I wipe out the queries, the
>file stay...Assistance request with Transaction.DropAmount
I have been tasked with making an addition to the status.htm that will
display a notification when the cash in the drawer has reached a
I'm familiar with HTML and VB Script, but I've been going over the
customization guide provided by MS and I'm a bit lost. The syntax
that I see doesn't appear to be working for me or perhaps I just
forgot how to do things.
If anyone has any advice on how to access the values of
Transaction.DropAmount or the value of cash in the cash drawer, I
would really appreciate it.
I want to make a query where i can see the members of an administrative group or Distribution list. Is there someone who has such a query?
administrative group would be based on something similar to
(legacyexhangedn="/o=Microsoft/ou=First Administrative Group/cn=Recipients")
dl would be based on (memberOf="DN of Group") This works fine as long as
the group isn't the users primary group
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this...Use Stored Procedure developed in C# in a SQL Query
I created a Stored Procedure by selecting a SQL Server Project in Visual
Studio 2008 using C#. It receives a SqlString as a parameter and return how
many times a specific character was found. I deployed the procedure to a SQL
Server database and can see it listed under the database. One caveat is that
it has a small lock icon on it.
I have a select query where I want to use the stored procedure. I am
thinking this is doable in a select query but can't seem to get it to work.
What I want to do is to have a select statement listing some fields and one
of the fields being th...Union Query
A union query I developed has suddenly stopped working. The syntax
SELECT * FROM [myQuery - Part 1] UNION SELECT * FROM [myQuery - Part
Pulling up each query individually works fine. When i run the above
union query I receive "Invalid use of Null". The number and order of
the columns in each query are identical. Access 2003 here.
Any ideas what could be the problem?
I suspect it is the VBA code that you are using around the query, not the
query, that stopped working. To confirm, does your query is executable from
the query editor?
If it does not, you also confirm t...Select subform's query criteria from form's unbound cbo
I want users to be able to select a name from a form's unbound combo box and
that selection to automatically become the criteria for the subform's
underlying query, without the parameter box for the query popping up. How do
I do this? I'm new to VBA and not an Access 2003 whiz either.
TIA for your help!
> I want users to be able to select a name from a form's unbound combo
> box and that selection to automatically become the criteria for the
> subform's underlying query, without the parameter box for the query
> popping up. How do I do t...Insert Database doesn't "see" half my queries?
I am trying to insert a database” from Access 03 into Word 03 using the
database toolbar in word. When I click “Insert Database” in word, and then
browse for my query, the wizard doesn’t “see” any of the queries in which I
changed a field name (ex. Dept: Department). Does anyone know a workaround
for this? Right now, it’s only showing about half my queries which is a
little odd. Is there a different way to insert my database?
If you check Word Tools->Options->General->"Confirm conversion at open"
and go through the whole insertion process aga...Downloaded transactions must be re-accepted every time
I bought Money 2005 last week and got it all set up. But when I turned on
the auto-reconcile downloaded transactions option, I found that every
transaction it pulled from my bank servers for the last month had to be
re-accepted even though it had been downloaded, accepted, and reconciled.
Turning this option off didn't fix the problem. It is very frustrating
because I can't tell what's new and what's not now. It treats all my old
dowloaded and reviewed transactions as something new. Anyone know why or how
to fix it?
In microsoft.public.money, BASIC since TRS-80 wro...Relationship error in a query
I have four tables in a databse. Each database has at least one column
containing prices of goods & services. However, these columns are not
related in anyway (some other colums are). I am trying to summerize these
price information in one query where I am trying to list the sum of prices
from every table. When I try to do so I am getting an error part of which
"One or more of the tables isn't related to the others. Click OK to edit
At least according to the error message (and this would have been my
question anyway),...Query table using criteria from an Excel document
I have a Access table of names and addresses. There is a postcode (zipcode)
text field. I also have an excel spreadsheet with a single column of
postcodes; no duplicates.
I need to get query to return each name and address in the table which has a
postcode listed in the spreadsheet.
Typing each postcode manually into the query seems clumsy.
Add a link to the Excel data.
Create a new query joining the linked Excel data and your Access table on
the postcode field.
Those that match will result.
Microsoft Office/A...query criteria 12-29-07
I have a criteria test in the [DR].[Received Date] field of a query. The
criteria is based on data which is entered into a form.
>=(IIf(IsNull([Forms]![CSR dg]![txtEarliestReceivedDate]),[DR].[Received Date],[Forms]![CSR dg]![txtEarliestReceivedDate]))
The true side of the IIF allows for all received dates if no data is entered
into the form. I would like to instead not do a criteria test at all if there
is no date entered into the form. I've tried things like "" or NULL in the
criteria, but to no avail.
The reason for wanting to do this, is that I have two tables linke...Still stuck: rerunning a query to change criteria
My form lets one set criteria for a query, from which some textboxes display
several Dcounts of the selected clients (grouped and counted by age and
gender). Now I need this query to be rerun once different criteria are set.
But I believe that as long as the form is open, the query wil be run ones and
then never again!
I could of course have people close and open the form again and again, but
that is cumbersome.
Me next try would be to have the criteria be set i the form and then as next
step run and open the query, including the data to be displayed in a subform.
But is ...fail to create IXSSO.Query object
I'm moving classic asp sites from Windows 2000 / IIS 5 to Windows 2008 R2 /
We have the "Indexing Service" started. Catalogs were created OK.
However, I am unable to create an ixsso.Query object.
Get the following error message
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
/HC/ECO/Announcements/Headlines/SearchResults.asp, line 39
ASP code :
...Item Transaction Entry
We currently have two companies and would like to know the best way to
transfer inventory from one to the other.
Currently we use Transactions-->Inventory-->Item Transaction and enter a (-)
Qty to get the item out of Compay A, and do the same (+) Qty in Company B to
get the item into the Inventory of Company B.
We follow up with a report (using a batch name to mark these transactions)
to do Intracompany transactions to match the totals. Without purchasing a
3rd party software to handle advanced intercompany transactions, what is the
best practice at this point.
Ric...Priv.edb query utility
Recently I ran across a utility on technet somewhere that you can run against
the priv.edb for exchange 2003, and it can spitback how much of a percentage
that each users mailbox is compromised of specific attachment formats, by
extension name, not by querying the attachments mime information.
It spat back graphical information in pie chart format, to show for example:
user 1's mailbox is 15% compromised of mpegs, and avis etc
It can also spit back the total % of the overall priv.edb is comprised of
15% specific formats(in our case, movie file formats, mpeg, avi etc). Does
anyone...random incomplete query results
Hi to all,
on a form I'm filling a "box" (I don't know the english name, is like a
combo without the input selection row) from a table on the same database.
To do that, I'm using the property "RowSource", also to change the ordering
The problem is that, when I'm using the database on a PC with Windows 2000
and Office 2000, "sometime" (exactly! not all the times!) the list on the
box is covering only a fraction of the entire table! After some trials I get
the full list...
The same database, on my PC (XP and Office 2003), is working alw...Need query to return absence of record
Hello all, hope everyone is doing well this fine morning!
I need some help in constructing a query. I have three tables,
designed as so:
TrainingHistory *Junc table between Personnel and Classes*
TrainingHistory records every instance of a class taken by all
personnel. I need to be able to find people who HAVE NOT taken a
given class. I need to be able to pick what class I search for each
time I do the query. For example, I need to know who in the
organization has NOT t...One query to multiple databases
I have five different databasesd that I access through five different odbc
connections. They bases are identical, but the data in them are not. Several
times, every day, I run the same query on each of them, and then I combine
all the results I get from each base.
Is there anyway that I can do this automatically?
Use a UNION query.
Build a little, test a little.
> I have five different databasesd that I access through five different odbc
> connections. They bases are identical, but the data in them are...Local Data Queries Stored? Client or Server?
I have 3 complex queries I need to deploy to 35 users. After creating the
5th one from scratch, I figured the data's gotta be stored somewhere! I
looked around in the registry and couldn't find any clues.
Where are the local data queries stored? I'm thinking I could copy the
queries (update for any unique GUIDs, of course).
It is stored on server
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. firstname.lastname@example.org
> I have 3 complex queries I need to ...Recurring Investment Transaction
Is there any way in Money 2004 to have an investment transaction set up in
Bills / Deposits as a recurring transaction?
This would be extremely useful for:
1) Automatic Payment Plan into an investment each month / quarter
2) Scheduled dividend income
3) Scheduled interest income
Any ideas? I do not know why you can not add an investment account
transaction to the Bills & Deposits section ?
Are these things possible?
1) Yes. This isn't even particularly hard or cryptic. I'm wondering if you
have something different in mind than I do. Please describe precisely ...Canadian Payroll Transaction Report
When the CanPay menus were improved in release 8.0, (ie. setup actually is
under setup now), all the reports associated with a pay run are now under
Reports, not transactions.
Since they are an integral part of a pay process, they should be put back
where they were on the old Transactions - Payroll-Canada palette so the users
don't have to scroll back and forth between Transaction menus and Reports
menus to do the payroll.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the &...Processing / releasing large numbers of sales document holds?
Looking for a way to processing multiple holds without having to use the
existing processing windows. Finding is very time consuming when having to
select by hold type and then add restrictions to get a listing.
Is there anything available to list all holds and then flag the documents to
release from hold?
Thanks to all the experts out there.
Smartlist Builder, Crystal Reports, SRS...
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"DTMMICHAEL...Why does MSAccess cut query after 2886000 records
We have a large database (Access 2007 on XP) with a data table containing
over 10 million records. We have a series of queries and observed that one
query failed to return all records - It stopped after returning exactly
2,886,000 records. Rerunning the query produced results from all 10 million
We made a copy of the database and issued the same set of queries.
Sometimes the set of queries produces the desired results from all data
records, while other times one (not always the same query) will truncate
after processing exactly 2886000 records.
Why does this ...Z Report missing sales transactions
We have 42 stores connecting to RMS HQ and stores blind close and then
perform a Z Report every morning.
When looking at our year end procedures, we have found hundreds of sales
transactions over the past year which appear on the detailed sales report but
for some reason are not included in the Z Report sales figures. It is usually
just 1 or 2 missing items per Z Report. Any ideas what causes this and how to
first step of diagnosing would be.. are these sales missing at the store
level? or are they only missing at the HQ level?
sometimes not all sales are posted...Problems with account payments for transactions from different st
Our Client use RMS 1.3Refresh 1006. Database on SQL 2005.
We have encountered a big problem when trying to pay in one store (let's say
store A) for the transactions from other store (store B). All the information
are saved in the table ARHistoryMirror but when the system tries to send data
to HQ during worksheet 401 Data Upload there is an error "-2147217900: There
are fewer columns in the INSERT statement than values specified in the VALUES
clause. Number of values in the VALUES clause must match the number if
columns in the INSERT statement".
Transactions stays ...