unhide multiple text boxes at a time after pressing a command buttonI want to be able to add a text box everything I press the Add Task button.
Something like this:
___________
| ADD TASK |
then a text box becomes visible
________________________
| |
|________________________|
and repeat up to six times
So far all I have been able to do is to get one text box to show
can any one help plz.
Mike
--
Message posted via http://www.accessmonster.com
mjquinon via AccessMonster.com wrote:
>I want to be able to add a text box everything I press the Add Task button.
>
>Something like this:
>
> ______...
Mapping Data During ImportI'm wanting to take data from one Excel worksheet and import it into another
existing worksheet . . . but I want to map the data as it is imported. Is
this possible?
EXAMPLE: I want to import the data from column "widgets" on one worksheet
into the existing column "really cool widgets" on another worksheet.
--
Brandon
...
XML Map Refresh on OpenHi All,
I have a spreadsheet stored on SharePoint, I have an XML Map in the workbook
that is being generated from another tool (SAS). I can get SAS to drop the
updated XML document where it needs to be, have the Connection Properties set
to 'Refresh data when opening the file'.
The problem however is, the data does not refresh unless I press the
'refresh all' button.
I'm using Excel 2007...
Any ideas why Excel is not refreshing the data when the spreadsheet is
opened from SharePoint?
Thx,
Casey
...
chart with map underlay / formatting / labels / suggestions?I am making a chart with a map picture (township map) as the fill effect and
the X Y as the data labels. (had difficulty getting the map pic to the right
scale)
The township map has only a few townships that I will have to plot
information/values for.
I have moved the labels to the appropriate place on the map but they don't
fit well and honestly do not look very good. (even after I change the
formatting on them)
I thought about having the point (ie specific township)radiate out with the
info but could not figure/find how to do it.
Or I thought about having the area on the map (ie...
Command Button Problem #2After installing Service Pack 3 I have a excel spread
sheet that includes many command buttons and once you
either print or use print preview all of the buttons will
move to the very left margin bunching together.
This did not happen prior to installing SP3.
Has anyone else had a problem with this or no of some
type of fix? I have sent 2 feedback emails to Microsoft
but have never heard a thing.
Yes, this is known SP3 problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;838910&Product=xlw
--
Jim Rech
Excel MVP
"Tom" <anonymous@discussions.microsoft.co...
Opening a sub-form from a command buttonI have a sub-form with in a main form. The sub-form opens with the form. I
want tthe sub-form to open separtely, such as with a command botton.
And if this cannot happen, then I want to delete the sub-form and have the
form (that was the sub-form) to open with a command button, but for it to be
sized to fit with in the area that the sub-form had opened in.
I acually have several sub-forms that open with the main form, each with in
their own page. The the database on the server and with multible users, the
database slows way down.
I want to open each sub-form as needed (ins...
expand grids with one commandI have msft Excel vsn 2002. The single printed page of a
spreadsheet is coming out too small to read.
Is it possible to expand the grids , both height and width, with a
single command for the entire sheet.
OR, is it possible to enlarge a sheet before printing?
best, Aaron
First, I'd make sure that only the range you want to print is being printed. If
excel thinks that it should print more rows or columns, you may see very small
print.
In xl2003 menus, you can change your print range via:
Select the range, then
File|Print Area|Set print area
But if you're just printing a smal...
About wrapping style, inlineshapes,shapes, and command buttonsHi,
I have 2 commandbutton controls ,one with an inLineWithText wrapping
style , the other with a different wrapping style, say behind text.Why
is one missing the top and left properties?..i know wrapping style has
something to do with the inlineshape and shape control but in object
browser both commandbutton-s show up as being of commandbutton type
thus belonging to commandbutton class; how come they have different
properties since they are objects of the same class? what am i missing
here?
Because one is an Shape, and the other is a InlineShape.
The one with BehindText is a Sha...
compact database from command promptHi, I want to schedule compacting access database. How do I execute compact
and repair from command prompt?
Thanx in advance.
alek_mil
"alekm" <alekm@discussions.microsoft.com> wrote in message
news:47EE233C-9FDB-456D-BF7D-75C74F561540@microsoft.com...
> Hi, I want to schedule compacting access database. How do I execute
> compact
> and repair from command prompt?
> Thanx in advance.
>
> alek_mil
From the help file:
1.. Open the folder where Microsoft Access is installed (located by
default in C:\Program Files\Microsoft Office\Office1...
command not found when using excel VBA function formatI have an extensive piece of VBA code that use the format function. The
macros run on my development machine and on one other in building. I tried
to use the code on an additional computer and got a command not found error.
I am assuming that means that there is some file missing on that computer.
Can anyone suggest what the specific fiel might be?
Thank you
On 7 dec, 19:40, OHCQ_DB <OHCQ...@discussions.microsoft.com> wrote:
> I have an extensive piece of VBA code that use the format function. =A0Th=
e
> macros run on my development machine and on one other in b...
Field Mapping to New Entities.If you have created a field in one of your entities, are you able to display
the contents of the field in another entity?
If so, how do you do this? It seems as though you can't add the created
field?
If you map one entity's field to a field on another, the data is transferred
at the point of creating the child entity from within the parent entity. For
example, if you map an account field to a contact field, the data will move
to the contact if you create the contact from within the account. Mapped
fields are not updated if you change them in the source entity after the fact...
mapping? columns from one excel workbook to anotherI have data with headers in one excel spreadsheet
A1 Item Code, A2 Item Description, A3 Department
I want to map the column data from A1 to a new worksheet template into
column A4
I want to create a macro that will automatically arrange the column info
from Worksheet 1, Column A1 into the new workbook under Column A4 under the
new correct headers.
Any ideas how to begin this process?
Thank you
Columns are A B C D etc.
Rows are 1 2 3 4 etc.
A1 A2 A3 A4 are cell references.
There is no such thing as Column A1 or Column A4
Please re-describe your needs based ...
Outlook 2000 doesn't print from command lineHi,
I have Office 2000 installed.
When i try to print a message file (.msg) from command
line with command : outlook.exe /p test.msg it diesn't do
anything. No error at all and am unable to print from
command line from outlook program which was working fine
sometimes back but suddenly it stopped working. However it
does work if i open outlook program from GUI and do file-
>print.
What could be the problem? Why it doen't work from
commandline /p switch?
Please help
Thanks
B
...
Open an Outlook folder when a user clicks on a command button ...Looking for a way to open a specific Outlook folder when a user clicks on a
command button in Excel. If Outlook is not currently running, I also need
the code to launch Outlook and then go to the specified folder. Is this
possible?
Anyone any ideas please?
Many thanks for your time.
Rob.
Here is a sample that would open the Contacts folder. After opening the VBE
editor, you would set a reference to Microsoft Outlook nn Object Library (in
my case, nn is 11.0). Then the following routine would display the Contacts
folder.
Sub ShowContacts()
Dim olApp As Outlook.Application
Dim olNS A...
mapping to customerid fieldHi,
I have created an entity called "project"; this entity is in fact an
entity above opportunitities. Which means 1 project can hold several
opportunities.
The project entity has a lookup field to the account entity
(new_accountid).
Problem:
I have mapped new_accountid to customerid (potential customer in the
opportunity) in the mapping page and
pubished the changes When I then try to create an opportunity, I see
that
the Customer field has a record in it that has the name of our
Account
but the icon of a Contact record.
When attempting to save the opportunity, or when clicking on...
relationships and mappings for the contract line1. It would be great to be able to create a relationship between a custom
entity and the contract line. We have a serialized piece of equipment that
we created a custom entity for and we would need to link it to the contract
line for warranty and maintenance contracts (among other objects). Currently
we are forced to link the custom entity to the Contract header which is an
unfortunate workaround.
2. It would be great if we could create mappings for Account to Contract
Line relatinship and have these mappings "kick in" when a new contract line
is created.
Thanks,
Sergei
---...
Multiple instances of Outlook when executing multiple DoCmd.SendObject commandsHello! The routine below works great when I send only one email. But
when sending another email, I have to kill Outlook via Task Manager
where it
is immediately replaced by another session of Outlook and Outlooks
again
comes up.
Any help or suggestions appreciated!
Rbollinger
=========================================================
Sub Send SendEmail()
On Error GoTo Err_Command11_Click
Dim stDocName, mTO, mCC, mSubject As String
stDocName = "frmSnapShot"
mTO = Forms!frmEmail!emailTO
mCC = Forms!frmEmail!emailCC
mSubject = Forms!frmEmail!Subject
mpath =...
Command Line/Script to Remove/Uninstall Program that can only be removed from Add or Remove ProgramsHello all,
I need to come up with a command line/script to uninstall a program that can
only be removed from Add or Remove Programs.
Can anyone point me in the right direction to
websites/tutorials/walk-thru's.
Thanks for any help anyone can provide,
Conan Kelly
---------------------------
"Smokin' weed kills your brain cells. Drinkin' only screws up your
liver...ya got 2 a those."
- Earl Hickey (NBC's "My Name is Earl")
If Milli Vanilli falls in the woods, does someone else make a sound?
"Conan Kelly&...
Mapping List Values during ImportHi All,
Does anyone know of an easy way to map list values while Importing Accounts?
I’m trying to Import accounts and I have a Picklist of values that exactly
match the data in one of the fields being imported. Even though the values
match, the import utility still requires me to go through one by one and map
the source value to a target value.
What makes matters worse is you cannot save the mapping so if you need to
re-run the import, you have to start all over. To make matters REALLY worse,
after tediously mapping all the values, the Import program threw an error and
didn’t do th...
Mapping Nested XML to Relational TablesI'm having a problem translating nested XML to relational tables and would
appreciate anyone's advice with it.
I've written some code in C# that retrieves a fairly complex XML document
structure from a remote server and loads in into a dataset. Originally, the
complete XML document would not load because of conflicts caused by nested
nodes of the same name in different parts of the document.
I generated a schema by separating out parts of the XML which would load
successfully, eliminating the conflicting nodes in the schema, and then
re-integrating the XML schema without the conf...
Integrating Visio & Access to Create a Road map (2007)I would like to create a road map in visio using information in
acccess database.
For example, a rectangle represents a project with a start and end
date in visio.
If access has a table with a start and end date defined, can I use
that information to define the length of the rectangle dynamically?
So the goal is to change/ add/ remove variables in access and then
import changes to visio and have visio re-draw the diagram.
Thank you!
Hello Abdar,
Have you considered using the Gantt Chart or Timeline templates under File /
New / Schedule?
Best regards
John
John Goldsmith
www.visualSig...
Looking for a U.S. map you can click on state for sales figure?I am looking for a tool or product where I can convert sales figures from an
excel spreadsheet to a map of the United States you can click on each state
for figures/statistics for each state. Any suggestions out there?
RicP
I found several USA state images that you could use with Google. I added a
hyperlink to the Ste name and linked it to range name for state - associated
with data.
http://en.wikipedia.org/wiki/Image:Map_of_USA_with_state_names.svg
This one is just one of many. Look till you find the one that fits your
need.
I used SnagIt to copy image and paste to a blank Excel wo...
command line to toggle Luna/Classic ?Is there a command line way, or registry hack to switch between
classic view and luna? Basically a way to do it without using the
control panel and display properties applet. Thanks in adance!
...
Shell command line to create outlook mail message with two or more attachmentsHi
I need to create outlook email message wit two or more attachments.
The following shell comand will work for one atachment-
"outlook.exe filename.jpg"
but
"outlook.exe file1.jpg file2.jp" or other variations would not work
Where can I get documentation for DDE or COM interface which will let me do
it instead of command line?
Thanks for any help
DVKS
You can also compress the file into a zip-folder by commandline and then
send that single file.
--
Robert Sparnaaij [MVP-Outlook]
www.howto-outlook.com
Tips of the month:
-FREE tool; QuickMail. Create new Outloo...
Closing FIle with Command Bar Button ProblemHi All
I posted this last week with a different title and didnt get any
responses - so perhaps my messages was not understood - so I am trying
again:
I am getting a very strange error which I have isolated but I do not
know how to get rid of:
I have a workbook with the following code:
Sub MYexit()
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub
When I run the macro directly from the macro with other workbooks open
or closed there is no problem
However...
When I create a toolbar with a single button and assign MYExit to the
button - I get an "Applica...