Move C5 to C10 in Excell (no cut/ copy/ paste)?
How do I move C5 to C10 (without using the cut/copy/paste commands)?
You can "drag" it with the mouse.
Put the cursor on the border of the cell, so that the cursor changes to a
cross. Press and hold the right mouse button, drag to the other location and
release the button.
Microsoft MVP - Excel
"kandieclaire" <email@example.com> wrote in message
> How do I move C5 to C10 (without using the cut/copy/paste commands)?
...What is the basic format of a Access VBA module
I am almost completely new to Access VBA so pardon me if this question
is asked before.
Anyway, I came across somewhere that I have read before that before I
exit an Access VBA module, I am supposed to clear the database or do
something to free the database is it? May I know how it is done and
why should I be doing that?
<firstname.lastname@example.org> wrote in message
> I am almost completely new to Access VBA so pardon me if this question
> is asked before.
> Anyway, I came across somewhere...Insert & link a graphic file in Excel 2003 --> updatable pictures!
I want to insert a graphic or a picture, it should be visible in Excel, but
linked with the file, so that when the file content changes, it is changed in
I have charts in png-format as automated outputs of a statistics application.
The file names are constant, but every month the content of the file is
different. Because the application produces new charts and saves them under
the same filename.
The links were updated automatically in Excel sheets with the XP version of
Office. It was also possible to insert the pictures as linked object in the
earlier version. What happened...excel and works spreadsheet
Is there a way to get a works spreadsheet into excel with out having
to type it in?
Save it in Works 2.0 format. Then open it in Excel.
<noone@noonoo> wrote in message
> Is there a way to get a works spreadsheet into excel with out having
> to type it in?
Worked great. thanks for the help.
On Sun, 26 Oct 2003 13:31:24 -0500, "Tom Ogilvy" <email@example.com>
>Save it in Works 2.0 format. Then open it in Excel.
...Uninstall SQL2005 Reporting Service
I try to uninstall SQL 2005 reporting service from add/remove program,
but it didn;t work because it's still there.
Does anyone has any idea on how to remove it once & for all?
By "still there" do you mean you still see it in Add/Remove programs, or does
it mean you can still start the service and browse to the virtual folders and
I suspect it is just still in Add/Remove programs and this is usually a
registry thing, not getting cleaned out all the way.
Why remove it at all? It doesn't take up all that much room, and you ca...VB Macro to VB Application
I have a VB macro. I want to move it to a VB application, using my VS 2008.
I don't know how to get the Application to run against an Excel Worksheet.
Can someone help?
"JCO" <firstname.lastname@example.org> wrote in message
>I have a VB macro. I want to move it to a VB application, using my VS
If you mean a VBA macro then moving it to VB is usually pretty easy but VS
2008 is not VB, it is VB.Net, and that's a very different language. This
group is for VB 6 and earlier versions and doesn...Import from InfoPath Expense Report form into MS Money?
does anybody knows if it's possible to imports expense data from InfoPath
Expense Report form into MS Money expense transactions? I really don't feel
like retyping all this manually...
Dmitry Korolyov [email@example.com]
MVP: Windows Server - Directory Services
Hi Dmitry - what kind of formats can you get out? CSV?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq/default.aspx for tips and fixes for MS
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx
I do not respond t...MSCRM and coding experience
Hello All you gurus out there
I have had a brief search to find an answer to this however, I think
it will be quicker if I just ask the question...
I have just joined a company that has MSCRM installed. It is my job to
"make it work". I have no coding experience to speak of (and that
means 'nil') and some of the concepts in MS CRM seem back to front.
Which probably means they are right and I'm just ignorant.
1. we installed the vanilla sales process and activated it
2. I can see it - but not for all opportunities (what the...!)
3. other staff can't see it ...Access Class
I was wondering if anyone knows of any good corporations that offer
Microsoft Office classes that could focus on Access? I am from the
Philadelphia area and would need recomendations from that area.
Thank You in advance.
Have you tried local community colleges?
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I was wondering if anyone knows of any good corporations that offer
> Microsoft Office classes that could focus on Access? I am from the
My database appears to have wiped all the code off all my command buttons!
This is the second time that this has happened. I cannot work out what has
happened. Please can someone help, with suggestions of what may be happening?
What exactly does
"My database appears to have wiped all the code off all my command buttons!"
mean? There's code in the form's module but the buttons don't work? There's
no code in the form's module pertaining to the buttons? What?
Also, you should post the Version/Service Pack you have.
There...GP Security Report that lists edits made beyond most-recent
During a GPUG.com webinar discussing GP v10 security earlier today, a
participant asked if there was a report that listed all modification dates
and the user who made the modifications.
For example, in SY09100 (Security Roles Master), there are two fields in
this table, MDFUSRID & MODIFDT, which record the User ID and Date for the
most-recent edits to a Security Role. The participant indicated that he was
often asked by his auditors to show ALL edits by date and User ID over a
period of time so that the edits could be investigated by the audit firm to
comply with regulations (mos...How to output only the first page of a report as a rtf file
In an application that generates four different reports, there is a need to
limit the pages of one of the reports to only the first page when outputting
that report as a rtf file. Is there any way to do this?
check out DoCmd.OutputTo
"RC" <RC@discussions.microsoft.com> wrote in message
> In an application that generates four different reports, there is a need
> limit the pages of one of the reports to only the first page when
> that report as a rtf file....Use Excel to work on another Excel workbook?
Web site recommendations for the given subject line? Jon Peltier's site give
good examples for PowerPoint but I'm a VBA beginner/intermediate so actual
Excel examples would be nice.
Excel 2002 in Windows XP
you may provide some more details what you're trying to achieve
"Toby Erkson" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Web site recommendations for the given subject line? Jon Peltier's
> g...Cant open Messenger
When I try to open Messenger, I get a messenger than says I have to accept
the Service Agreement and Terms of Agreement. When ai press a "continue" box
to view/accept these, nothing happens. Any help is appreciated.
...What's the EOL code for Editbox?
I added a "Value" variable to a Editbox control in a MFC
VC++ dialog, it's CString tx. The editbox has already been
set MULTILINE=ENABLE and ACCEPT_RETURN=ENABLE.
I try something like:
The two messages are still shown in the same line, no line-
break is added in between.
Could anyone tell me how I can add line-break to a Editbox-
linked CString variable?
Thank you very much,
> Dear all,
> I added a "Value" variable to a Editbox control in a MF...How to get Access to ignore subform records when browsing form
I have an Access 2007 form that has a primary record in the main form that
draws data from three separate tables. It's an asset database tracking photo
usage; each photo has a unique ID that's the main key. A fourth table, which
records uses of the photo, is on a subform, linked to the unique ID. This is
a 1 to many relationship. There are about 4200 unique photos in the
database, and about 8700 records in the table in the subform. I notice that
after adding the subform to the form, when I attempt to browse through
neighboring IDs, the table treats each subform record as a ...Report account totals by banK?
I have 12 accounts set up under one banking institution, others under 2
How can I print account totals for just that bank?
Fort Worth TX
In microsoft.public.money, Rex B wrote:
>I have 12 accounts set up under one banking institution, others under 2
>How can I print account totals for just that bank?
What you could do is to customize a report to include only the 12
accounts. You could save that as a favorite with its own Title. View
it with Favorites->FavoriteReports. Then you could Reset ...Excel to PDF taking too long
In excel 2007, I could export data to PDF using 'Save As' which is nice...
but it is taking too long to convert file to PDF.
Currently I have 35 worksheets in a workbook (soon it would be 100) and it
takes 10-15 mins to convert XL to PDF... Now I am worried when I will put
another 65 worksheets it would take ages to convert into PDF...
Can I do anything to reduce my time? Any advise on this would be highly
On 2/23/2010 7:10 AM, Milind Keer wrote:
> In excel 2007, I could export data to PDF using 'Save As' which...Enterprise Reporting Issue
We are on ER 7.5. My users are having an issue with a filter formula. It is
=(-amt+ AC[40000:89999] D4['01-????':'04-????'].AMT)/1000
The above formula returns all account amounts for 01-???? through 03-????
but it does NOT include 04-???? as it should.
However, the following formula works, but is too cumbersome to actually
apply to their work:
Could someone let me know what might be going wrong?
...Pivot Table with MS Access as DataSource
Hello all. Thanks for the help in advance.
I am trying to use a UNC to pull data from a MS Access database as a
external datasource for a pivot table in MS Excel 2003. I can actively pull
the data, since I have a network drive mapped to the location, but others who
have the drive mapped to another letter are unable to open the document and
I am trying to figure out the best way to create this pivot table utilizing
the shared network UNC. Please help!
I would use a SQL query to pull the data out of the Access db. Then
everyone can push...How to set variable to cell value in excel macro
How do I perform a "do loop" using a cell value as criteria? (i.e.-do while
x < value($c$1). Thanks for your help.
the help files are your friend
While...Wend Statement Example
This example uses the While...Wend statement to increment a counter
variable. The statements in the loop are executed as long as the condition
evaluates to True.
Counter = 0 ' Initialize variable.
While Counter < 20 ' Test value of Counter.
Counter = Counter + 1 ' Increment Counter.
Wend ' End While loop when Counter > 19.
Debug.Print Counter ' P...Access Crystal Error
I've somehow managed to get this error:
Unable to Acces Crystal;Check to see if you have enough licences. Unable to
communicate with crystallogon.csp
I've checked the Knowledge base 821672, and done everything that was stated
in the article, but no go.
M SAN Group
Try article 821676. That should give you the answer. It worked for me.
"Sascha" <sascha@nospam> wrote in message
> I've somehow managed to get this error:
> Unable to Ac...Error trapped only while stepping through the code
I have an xla application that includes a number of macros that I am
trying to Error-proof. I am particularly interested in doing so
because some other things I have going on in this app led me to employ
some of Dave Peterson's LockWindowUpdate code (details in the code
below). The first of the 3 macros below is an example of the macros I
am trying to error-proof (& the only error I am really concerned with
trapping is Error 18 which is supposed to be generated if the user
cancels), the other two are supporting macros that might be invoked.
I presently have coded for both E...VB
I've modified some windows with VBA to perform database queries and
return the results in a field in those windows. In one particular
window, the SalesTransactionEntry window, I create the
ADODB.Connection, ADODB.Recordset, and the ADODB.Command. The problem
is, I want to manipulate them in the SalesTransactionEntryDetail
(Grid). So I made the Recordset and Command, rst and cd respectively,
public. My question is pertains to the scope of the public variables.
Where else are they visible? If I create a public variable called cn
in this window and in another totally unrelated window, am...Delegate Access
Is there a way to setup delegate access through some sort
of administrative account? Currently each user must
logon to their Exchange account via Outlook and set their
delegate access. The issue is that users are either not
doing it or they are doing it incorrectly. We would like
to have one person setup all the correct permissions
without having to logon to each person's Exchange account
via Outlook and make these changes.
Any suggestions are greatly appreciated.
this is something that really must be done from the client...I had to write
up a little instruction memo and p...