How do I select a range of cells in an Excel table using the mouse
When I use the mouse to select a range of cells in an Excel table
(left-button-click-and-hold, drag mouse mouse over desired cell range), when
I release the mouse ALL the data in the top row of the selected range is
COPIED to the remaining rows in the selected range... How do I prevent this,
or what is wrong w/my selection technique.
John C. Lethco
Be more careful with your initial click.
I'm thinking that you got the edge of the cell, not the cell itself.
> When I use the mouse to select a range of cells in an Excel table
> (left-...visual basic
I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
'Calculate the average value of a given value.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim varBookmark As Variant
Dim numAve, numDaysAvg As Double
Dim intA, intB, lngCount As Integer
Set db = CurrentDb
Set rst = db.OpenRecordset("SGX Individual Historical", dbOpenTable)
Do While Not rst.EOF
intA = 1
intB = 0
varBookmark = rst.Bookmark
n...How to "watch cursor" over other application?
How to receive window object under mouse cursor in my app, when cursor
is over another windows application?
I think about function like "Watch Cursor" implemented in inspect32.exe
from MSAA SDK Tools:
When user moves cursor, inspect32.exe checks frequently what object is
under the cursor, and shows information about it (Options->Watch Cursor
must be set).
Maybe you know where is available source code for inspect32.exe ?
Maybe WindowFromPoint() and/or ChildWindo...Troubleshooting "Rules"
Hi, I am trying to cope with spam by creating rules from messages in my Junk
folder. I am hilighting the message and then selecting either the "From"
option or the "Subject" option. All seems to go well up to that point.
However . . .
After clicking OK and then selecting "run this rule in this folder now", the
only message that is deleted is the one that I am using to create the rule,
instead of going through the whole Junk folder, as expected.
Another problem that I am having is with the Search funciton. Again in my
failaing efforts to cope with over...Browsing on a single Subnet
My problem, and hopefully an easy problem for you guys with more knowledge on
the subject, is that sometimes I can see the list of computers/servers on the
network (one single subnet network) thru My Network Places->Entire
Network->Microsoft Windows Networks and sometimes I can't.
I have 2 DCs (windows 2003 Ent. Ed. w/ SP1), one member server (2003 ent.
ed. w/ SP1 as well) and 10 to 12 workstations, all XP Pro w/ Sp2 with the
firewall feature manually disabled on all of them.
On my DC1, I have forced it to always be the Domain Master Browser by doing
the registry hack. This D...Pivot Table
I built a pivot table by getting the data from an external datasource. It
works fin all the time but now I want to add a parameter to the source so
that everytime when I placed the parameter and click refresh. The pivot
table will give the result according to the parameter.
Do you have any idea on it?
Thank you very much!!
You could put the Parameter field into the Page area and then pick the
parameter there. However, if you code the data retrevial you can input a
parameter into the SQL statement.
So if the first one doesn't work record a macro that cre...Pivot table -Show Q3 and Q4 with non-filtered Total
Need help with the question detailed below.
In my Pivot Table:
Field "Qty" is xlDataField.
Field "Quarter" is xlColumnField.
The report shows the quantities for each quarter, like:
Q1 Q2 Q3 Q4 Total
2 5 4 5 16
I need to show only Q3 and Q4, but live the "Total" with the whole quantity,
Q3 Q4 Total
4 5 16
How can I achieve that?
Thanks in advance,
...Tooltips working in MFC app, but not from DLL
I have a class which is derived from CWnd. It creates a couple of
buttons, which have tooltips. Tooltips is implemented by calling
and by handling the generated messages:
ON_NOTIFY_EX_RANGE(TTN_NEEDTEXTW, 0, 0xFFFF, OnToolTipNotify)
ON_NOTIFY_EX_RANGE(TTN_NEEDTEXTA, 0, 0xFFFF, OnToolTipNotify)
The code works fine.
But, I have taken my code and placed it into a DLL. The DLL has one
entry point. There I create my class, including the buttons. When my
code is in a dll, tooltips no longer works. OnToolTipNotify never
In stepping through the code, ...How to implement the outer join in ACCESS for more than 2 tables?
I have three tables (Employees, Outsourced and Projects).
Projects table include
emp_id as foreign key to Employees.id
and Outsourced _id as foreign key to Outsourced.id.
I need a query to show the project name, Employee_name, Outsourced name.
Kindly, to help me to generate the SQL Statement.
The SQL you can use
Select Projects.[project name], Employees.[Employee_name] ,
Outsourced.[Outsourced name] From (Projects Inner Join Employees On
Projects.emp_id = Employees.emp_id ) Inner Join Outsourced On
Projects.Outsourced _id = Outsourced.Outsourced _id
But yo...Field changed from Single to Double issue..
I have an Access 2000 DB (I think it's 2000, it's
whatever comes with Visual Studio 6.0).. Simply put, I
have a field that is of type "Single" that contains the
value 0.3. When I modify that field and make
it "Double", access automatically converts the values, as
it should, but returns 0.300001192 in the field.. I
understand that there can be precision issues sometimes
in comparisons and such, but is this NORMAL for Access to
do as well? Is there any simple work around or patch? I
suppose I can write an SQL statement to take care of
this, but that isn...Adjust an Excel table with the width of a Word page
Hol=E0 has todos los Excel users!!
Here is my small problem (way of speaking, because for me it is
an enormous problem, but for you, it is undoubtedly nothing.):
Under Excel, I have a macro that creates several tables on several
sheets (1 table per sheet). This macro selects and copies each table
into a page in Word.
The problem is that the number of columns is variable : at the time of
copying, the table doesn't not fit the width of the Word page.
That's why I'm seeking a way to do the following things :
1) calculate the number of columns of the xls table
2) find the width of ...Pivot Tables
Is there a way to use pivot tables in Excel to accomplish the same result as
an MS-Access process to "join" two tables on matching fields? For example,
I have one range of data that contains employee time card information that
includes a costing code for each time entry. I have a separate data range
that contains, for each costing code, one or more records containing
percentages that are used to allocate labor to specific business units. The
desired result is a table or data range that contains all of the records from
the time card range and all matching record...Server Error 403 Forbidden: Access is denied
Running Windows XP SP3 attempting Windows Update.
Attempted to use the information in the below thread, however, I am not
having any success. I have attempted reinstalling the Update agent,
restarting computer and still receiving the same error. Part of the tread
was a little too technical and I was getting lost.
> Running Windows XP SP3 attempting Windows Update.
> Attempted to use the information in the below thread, however, I am not
> having any success. I have attempted reinstalling the Update agent,
> restarting computer and ...Pivot Table - Data Field
I trying to create a custom data field within a Pivot Table that
calculates the remaining sum, in a sense the opposite of the "Running
Total In" option fo the "Show data as" parameter in the Field Settings
bar. So for example if I have the follow data items in a column:
1, 4, 7, 3, 7
Column Total being 22
Then the running total would be
1, 5, 12, 15, 22
And the remaining sum would be
21, 17, 10, 18, 0
I cannot find any way of doing this. Since I cannot use GETPIVOTDATA
within a Pivot Table's calculated field, I cannot make a reference to
the Column Total. C...autofit whole table?
I'm sick of adjusting cell heights individually! Is there a way to make an
Excel table autofit contents to a cell automatically throughout the
document? I want the widths to stay stable, but the heights of cells to
adjust to the text. I want the whole document to work this way and not have
to go to each individual cell and adjust them. TIA.
Delete the obvious to reply to me personally.
You cannot adjust cell heights individually.
Perhaps you mean "row heights"?
Select your range of rows and Format>Rows>Autofit.
G...same x-axis with two sources of data
I am having trouble using different columns of data on the
same x-axis. When the a new series is added it swaps to
one or the other x-axis column rather than each having its
own sepatate data. Any suggestions?
> I am having trouble using different columns of data on the
> same x-axis. When the a new series is added it swaps to
> one or the other x-axis column rather than each having its
> own sepatate data. Any suggestions?
Sorry, but I do not have any idea what you mean. Can you try again?
dvt at psu dot edu
...Convert Access 2003 to 2000
I have two very similar Access databases in the 2003 format. I must convert
each to the 2000 format. One database converted without any difficulty.
The other one gives me an error message: "The report name 'DirDataCopy' you
entered in either the property sheet or macro is misspelled or refers to a
report the doesn't exist".
From what I find in a couple of forums, I am not the only one who has
received the message. Can someone please point me to some kind of a
solution? Or, at least give me some kind of idea as what to look for in my
Using Access 2...Re: Displaying Electrical Connections on Two Wires
Just wondered if someone may be able to explain to me - in layman's terms -
how to show electrical connections between two-wires on an electrical
schematic drawing in Visio. I am currently using Visio 2002.
Say for instance if I draw a three-phase diagram, and from the first phase,
I connect a single-phase switch and lamp, how do I show the black-dot
connection between the two wires?
On Thu, 1 May 2008 05:23:00 -0700, tips6
>Just wondered if someone may be able to explain to me...Sending a mail from Access to Outlook
I have a form in Access that sends mails through an Office Outlook profile.
DoCmd.SendObject , , , "myMail@hotmail.com", , , "subject", "Text", False
'So the email is sent without being displayed
This works perfectly, but Outlook displays an alert message saying:
"A program is trying to automatically send email on your behalf.
Do you want to allow this?
If this unexpected, it may be a virus and should choose No." [Yes] [No]
How can we avoid this message? so I can send my emails on a row.
Thanks for any suggestion
See htt...access 03 converted file size
I am migrating from Access 97 to Access 2003. I converted an access 97 file
to Access 03 db. the size of the Access 97 file was 7,778KB where as the
converted access 03 file size was 2,736KB. When I compared with a db
comparision tool for the differences b/n the two db's, it showed a difference
in table structure of memo field and unicode compression.
My question is: Is the reduced size in the Access 03 file due to unicode
compression or due to some other reason. Please some one clarify.
What is the reason for the difference in the size of the converted db's.
I'm a newbie on MS CRM. I tried to customize crm with external aspx file and
in onsave event then error pop up.
"There was an error with this field's customized event."
"Error: Permission denied"
I guess permission denied may came from IIS configure but I don't know how
to do. Can anyone help me on this problem ?
In the properties of the iframe you need to enable cross-site scripting.
Jeffry van de Vuurst
CWR Mo...Can Access 2007 be Run as Admistrator
Using Vista: have launched an .adp project created at another site on
another computer, using the SQL Server at that site. Now, from home, I want
to change the data source to the local SQL Server database on my PC here at
home. So, I entered the local SQL Server name in the Data Link Properties
dialog box, and pressed the Test Connection button. Getting an error
message: "Test connection failed because of an error in initializing
provider. Login failed for user 'SLINDEED\(My name). If I cannot run as
Administrator or change the server name, Catch 22?
&q...Invalid Argument Access 2003
I get an invalid argument when I open my database. The database is
the front end for a split database. I was working with some large
imports. The file has swelled to over 2 GB. It should be around
50MB. I have tried to repair the DB from inside access and using the
command prompt. I get a corruption error telling me to back up the DB
and repair/compact. I have tried to rebuild the DB by importing to a
blank DB. However, I get the invalid argument and corruption errors.
When I double click on a module, Access tells me it doesn't exist.
I have 40K lines of code and lots of forms and...Application to load driver
If anyone can tell me how to create an user mode application that can load
the driver in kernel space(identical to those given with sioctl.sys sample in
What type of driver? If it is a legacy driver take a look at
src\general\event\exe\install.c in the WDK. If it is a PnP driver then
you need to look at src\install\devcon and take the pieces that insall the
driver from there.
Don Burn (MVP, Windows DKD)
Windows Filesystem and Driver Consulting
> -----Original Message-----
> From: P...Vista and Access 2003
I am running an access 2003 application as a Client Server, with the front
end on users PCs and the _be on the server. Until now all pcs have been
using WindowsXP. A new HP laptop has been purchased with Vista. I had
difficulty initially running the application and relinking the _fe to the
_be on the server -which is normally a straight forward operation with an XP
machine but was unstable with the Vista machine. Eventually after a few
tries I got the link working and the application worked fine for an hour or
so but then just fell over. I have done the same thing a number of times but