Using a button to copy contents of one file into another.
I have a form with 2 address physical address and Mailing address.
Frequently the two are the same thing.
So I want to have a button that copies the data across.
Private Sub cmdCopy_Click()
Me.Address2.Text = Me.Address1
Me.cboSuburb2.Text = Me.cboSuburb1.Text
Me.State2.Text = Me.State1.Text
Does not work I get an error 2185 that says
"You can't reference a property or method of a control if the control
does not have focus"
On 20/03/2010 11:42 PM, Avid Fan wrote:
> I have a form with 2 address physical address...When I press key DX of the Mouse puts to us approximately 7 second ones to visualize the options
When I press key DX of the Mouse puts to us approximately 7 second ones to
visualize the options single in Outlook 6. All it is happened after the
modernization of Windows Update of August.
Are you refering to Outlook Express 6, since there's no Outlook 6? If so,
you might want to check in the
If that group isn't carrie...Anyone know how to set accelerator text for menu commands?
I have created a menu with text like this:
"Do something\tCtrl+Left Arrow"
When I run the program, this gets output in the menu as
"Do something CTRL+NUM 4"
Either Windows or the MFC has detected the accelerator and changed the text
of the accelerator part of the menu command for me - i.e. "Ctrl+Left Arrow"
has somehow become "CTRL+NUM 4". But I don't want this text. I prefer what
I had. Does anyone know how to stop this happening?
I can't see how it could possibly know what text you had there. It looks like it...Attachment Is Path Not File
I have two users running Outlook 2002 on an IMAP server
(IE 6x, WinXP) with the same problem. When they attach a
file to a message, it is actually the path to the file,
not the file itself. Any ideas?
Carole <firstname.lastname@example.org> wrote:
> I have two users running Outlook 2002 on an IMAP server
> (IE 6x, WinXP) with the same problem. When they attach a
> file to a message, it is actually the path to the file,
> not the file itself. Any ideas?
Exactly how do they try to include the attachment? What message format are
...How can i create in one cell scroll-down different options?
I am working in excel and I would like to create like a menu/scroll-down in
one cell with different options (like including kind of transport, train,
airplane, car, etc...) where you have an arrow on the right side and you can
choose one of the options given.
Thanks for your help.
You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and here:
> Hi there
> I am working in excel and I would like to create like a menu/scroll-down in
> one cell with different op...How to extract a word from a text file
I need help to create a small batch script /procedure that extracts a piece
of information from a text file:
-Skipp first two lines in a file
-Extract a piece of text from the 11-th character until the first blank /
space character and store it into an environment variable.
- Compare this info against a constant
Any examples ideas please ?
Please post your query here:
"TIA" <TIA@discussions.microsoft.com> wrote in message
news:416630B6-8A60-4B7E-AB50-1818361CEA66@microsoft.com......Backup .pst files #2
I have around 20 users running Outlook 2000 all with their own .pst
files held locally on either PCs or laptops. I would like to move
these .pst files to a central server so that they are backed up every
night. The problem with this is that if the server goes down or a
laptop is moved off site, they don't see their email untill they are
reconnected to the server.
Is there a way to have their .pst file on the server and held locally
and any changes are made to both copies. Also, if a user goes off site
and sends/receives new email, can these changes to their local .pst
file be replica...Hyperlink with #
Encountered err "Cannot open the specified file" when hyperlink path
consists of "#", example "C:\My document\1# Pictures\Picture1.gif"
how to overcome this; but do not want to rename folder name as there are too
...Double-Clicking a cell for Multiple Options
I recently came across a spreadsheet where a cell was double clicked for the
multiple options to become available.
This was similar to a drop-down list, but there was no drop down list!!
The cell currently shows a value of "A".
I double-click on this cell ... the cell changes to "B".
The new value is not random, but coming from a pick list or a pre-determined
Does anybody know how such a feature is created?
If you rightclick on that cell and choose "Pick from DropDown List" do you get
the same effect?
If yes, ...Transform xsl file into xml file
I have an xsl file and would like to transform it into an xml file. The same
way as if i would open the xsl file in excel and then save as... xml file
is there a way to do it in c#(or whatever else) in visual studio .net?
and how can i then transform it back from xml into an xsl file?
thanks for your help
> I have an xsl file and would like to transform it into an xml file. The same
> way as if i would open the xsl file in excel and then save as... xml file
> (Office 2003).
??? XSL document is XML document. Do you need just to ...QIF file not recognized in M2006 Deluxe
Had 2005 Deluxe running along with the 2006 Trial and QIF importing worked
fine. Purchased 2006 Deluxe, uninstalled 2005 and completed the upgrade from
2006 trial to full 2006 Deluxe.
My bank uses the old OFC format for Money, so I am forced to use QIF to
import my downloaded info. Tonight, for the first time, after downloading
the QIF file, I get a message saying, roughly, that the file type is not
recognized, pick a program to open it with. The QIF is downloaded to my
desktop and no longer has a Money Icon associated with it. It worked with
the M2006 Trial edition just fine.
Ide...Outlook won't open and can't find my .pst file after XP crash
Windows XP crashed on my computer and I could not repair
it so instead i installed xp again on the same partition
hoping that I would be able to just copy all the files i
wanted out of my old install of xp into the new and then
delete the old. so far this has worked fine except for
Outlook 2000. I re-installed it from Microsoft Office2000
Small Business but it will not open (I get a "The
operation failed message") and I cannot find my old .pst
file anywhere in the old install.
To find your old .pst file, you need to enable viewing hidden and system
folders in t...proforma option
I now use office 2007 in work and at home but I am having a number of
teething problems with it in that it seems far less intuitive to me. My
current issue is that I want to produce a word document which would have key
information within the text based on entries I enter on to an access form. I
used to do this in previous versions of access by creating a form and linking
it to a word document I had left in the ‘pages’ tab (between reports and
macros). I can’t seem to find the pages option in the ribbons. Can this
still be done? If not is there a quick solution? All I need to...No "Direct Debit" Option in Money 2006?
Ok, I just went through a disastrous upgrade from 2005 and ended up
starting from scratch. Wee.
I am setting up my transactions and for some reason, I can't see
"Direct Debit" in the list of options in Payment Method field. What's
Money 2005 used to have it, why not in 2006?
Nevermind. You need to switch to "Advanced Bills" to see it. Why does
it have to be so complicated? Sheesh.
<email@example.com> wrote in message
> Nevermind. You need to switch to "Advanced B...Missing Tools Menu Item
Home Use Program installed Office Pro 2003 and is missing
the Tools menu item to restore deleted items. Anyone
experience this or know what to do?
This option only exists when you are connected to an Exchange server
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Pam B." <firstname.lastname@example.org> wrote in message
> Home Use Program installed Office Pro 2003 and is missing
> the To...file and folder help. Please :)
Hi I have a list of files in an excel sheet in the first column I would like
to know is there a way I can get excel to search for these files by giving
it a dirctory and then it would copy the files to a directory I set, so say
I have the following in an excel document
now they are under directory X
and the directory I want them to be copier to is XX
is there a way to do this, I would appreciate any help
Range("A2").Select ' starting cell
Do While Selection <> ""
FileCopy "C:\x\&q...Microsoft Outlook/Word AutoCorrect File Errors
Microsoft Outlook/Word AutoCorrect File Errors
Upon opening Microsoft Outlook and Word, I get the following AutoCorrect
“Your AutoCorrect file, symbolsMSO1033.acl, could not be saved. The file
may be read-only, or you may not have permission to modify the file.”
I click the “OK” button and receive the following message.
“Your AutoCorrect file, FICE12\1033\MSO.ACLMSO1033.acl, could not be saved.
The file may be read-only, or you may not have permission to modify the file.”
I click the “OK” button.
If I close the Outlook or Word apps., I get the following m...Using accelerators in a dialog menu
In a MFC dll I have a simple dialog consisting only of a multiline rich edit
box and a menu.
One of the dropdown menu choices is to Search the contents of the edit box
with Find, Next and Previous options.
All is working fine but then I thought I would like to add function key
accelerators for next (F3) and previous (Shift+F3) as shown below. But
pressing F3 or Shift+F3 nothing happens and Spy++ shows no messages are
being sent to the dialog when the keys are pressed.
We have another small application which uses similar accelerators without
any problem but that is on a mainframe window ...how do i open a file in excel that is encrypted or read only
i am trying to open a file in excel but i am getting message file is read
only or encrypted..clicking ok then says excel says cannot access file. Any
...Outlook and Zip Files As Attachments
I am really puzzled by Outlook when I am trying to attach
some zip files. I usually attach files by using the
command button provided by Outlook to browse and attach
the required file...
The problem here is that I am not able to find zip files
in Outlook's dialog box and because I cannot find them, I
cannot attach them...
But the strange thing is that sometimes, I have no
problems at all... I am able to see the zip files and
attach them... Does anyone have such experiences
before...? If yes, how did you resolve the problem...?
When you are looking in the dial...how to write data to file
I wonder if anyone knows a simple way to write a selection of fields from a
single record out to a local file on the server.
I then need to automate this in a simple way. click a button or workflow
this is a job for the SDK..pretty simple but requires coding
Microsoft CRM MVP
"DMcL" <DMcL@discussions.microsoft.com> wrote in message
>I wonder if anyone knows a simple way to write a selection of fields from a
> single...Files Used when Deleting Item from Site
Does anyone know what files Great Plains looks at when
you are deleting a site in Inventory?
KB850294 tells me how to do it. I have an item which
shows a Quantity On Hand for that item at that site of
zero. When I attempt to delete the assigned site for that
item, I get the message, "You can't delete an item if
quantities are assigned to it."
I had to use SQL to get the Quantity On Hand to zero by
modifiying IV10200 (IV_Purchase_Receipts) and IV00102
I am now trying to figure out what is triggering that
Thanks for you help.
...Menu shortcuts assigned certain keyboard
Hi, I was sing excel yesterday and apparently I pressed a keyboard
combination and what happens now is that whenever I press SHIFT 7,
instead of getting "&", I get the menu shortcuts, where the little
save disk becomes 1, the undo arrow becomes 2, etc.
First of all, I would like to know how to undo this change that I made
so I can write "&" again, and also, go back to the default keybord
combination to perform the task of getting the menu shortcuts.
On May 6, 4:06=A0pm, wonka <wester...@gmail.com> wrote:
> Hi, I was sing excel yesterday and appare...What is the best option vlookup is killing me
I have a workbook that has two work sheets. Sheet 1 has 3 columns Item
Number, Quantity sold, Year. Sheet 2 has two columns Item Number and Quantity
on hand. I need to add a fourth column to Sheet 1 that is the Quantity on
hand if The Item numbers match on sheet 1 and 2 since not all Item numbers
are present on Sheet 1. I have been trying to use vlookup to accomplish this
but I am failing to get anything but an error. Is Vlookup the right function
or is there a better way.
If your item numbers are not duplicated on sheet2:
Where...Radio/Option Buttons on a Form in Word
I am new at creating a form in Word. I created an application style form
with radio/option buttons, however, when testing the form once I select one
radio button in Section A, when I go to select a radio button in Section B,
the first selection disappears. I am only able to have one radio button
selected at a time. Is there a way to have mutiple radio buttons selected at
On Sat, 6 Mar 2010 10:51:01 -0800, Aj <Aj@discussions.microsoft.com>
>I am new at creating a form in Word. I created an application style form