I have prepare a publisher flyer which I will be sending out in a group
e-mail. The view of the flyer shows the text boxes as well as the text. How
can I delete the text boxes only and not the text. This is the first time I
am using publisher.
The text box boundary will not print unless you have put a border around it.
Have you looked at print preview?
Go to view, clear boundaries and guides, you will see how the flyer will look
Mary Sauer MSFT MVP
"Ladybug" <Ladybug@disc...return value based on combo box selection
I have a combo box (cmbShipDate) in a form that is based on a table with drop
down values of ShipDate1, ShipDate2, ShipDate3, etc. I have created a text
box and I want the correct ship date to be displayed based on the combo box
selection. These ship dates are all stored in a table called tblOrder. I
thought I could use the DLookUp fuction, but I'm not doing something
I don't understand what you mean by "based on a table with drop down
And when you say the "ship dates are all stored in ... tblOrder", do you
mean tha...Highlighted text
I have 2 end-users using Word as their email editor, and
html as the format.
When one highlights text in an email and sends it to the
other, the recipient is unable to see the highlights.
Any ideas on resolving this?
...Numbers V Text
I want to print out a document but I don't want it all printed out in
numbers I want the text printed out.
Here is what I don't want it say 223, I want to say =SUM(C7:C11)/15
I am sure it can be done via "Options" but I can't work out how.
Toggle the view to Formula View - Ctrl + ` (that's the same key as the tilde
"James Ducat" <email@example.com> wrote in message
> I want to print out a document but I don't want it all printed out in
> numbers I wan...Outlook 2002 auto send/receive no longer working
For some reason my pop3 dailup no longer sends/receives automatically
when launching outlook, or at timed intervals. Can someone help with
suggestions on reseting this feature? XP Pro I'm using. I even did a
repair of Office XP and a clean install. Thanks for any help!
What are your Send/Receive group settings?
Have you checked in the File menu to see if you have set your installation
to Work Offline?
"circuit slave" <firstname.lastname@example.org> wrote in message
> For some reason my pop3 ...How to disable inline auto-indent/spaces when replying
When I reply on a message, and want to write between the tekst I
replied to, it automatically adds a space before and after my cursor.
So if I edit:
"Today it is 9 Oktober 2007"
To 9 October, I get this:
"Today it is 9 O c tober"
How can I turn this off?
Thanks in advance,
...Selecting text for Emailing
I have question that maybe someone could help me with. I have a database
where on the form I placed a command button to send emails. Works great and
in fact, I even got it to pull the information from selceted fields on the
current record. What I would like to know is:
Is there a way to pick up the name of the field and have the information
that was inputted in that field appear next to the name in the email?
Currently my email body picks up only the information so the loan number
field only shows the loan number and the Date In field only show a date.
1...Outlook Message Inline Text
I have Outlook 2002 and need to know if I can change my
received message format to inline text. Right now I have
e-mails that have been forwarded multiple times as
attachments instead of inline text but I can't
synchronize it with my Pocket PC because of this.
...Outlook Plain Text Setting
I am starting to move my users over to Outlook and Exchange 2003. I
noticed that by default Outlook is setting the users up as HTML
e-mail. Is there a way that I can set all of my users up with Plain
Text for e-mail?
That is a user setting, of course, under Tools-->Options-->Mail Format
You can use the following to ensure inbound email is read as plain text, and
therefor replies will be plain text:
"Jeff Grossman" <email@example.com> wrote in message
news:firstname.lastname@example.org...Text to speech particular cell
ive been trying for a while now to get the text to speech function to work
for a particular cell.
For example, i have a set of numbers and a total in D15, what i would like
is that if i change the numbers that contribute to that total, and the total
in D15 changes then excel will alert me saying "Change in Total".
ive tried and failed to get it notice the changed total and would really
appreciate some help
Thank You for any contributions
Let's put the message in a cell, say D16.
In a standard module insert the follow line:
Public OldVar As Variant
Insert the following...copies of email to sent box?
Last weeek we experienced a power outage and had to
replace power supply.
Since then ,when I send email ,copies will not send to
sent box. I have checked OPTIONS and have " send copy to
sent box",but it is still not doing it.
...Filter Datasheet based on Combo Box selection
I have a SubForm that displays in Datasheet view. I want to add a Combo Box
just above the SubForm that the user can select the Pay_Period_Ending_Date,
and once selected I would like the Datasheet to filter based on this date.
Can someone please direct me as to how I can do this?
Message posted via http://www.accessmonster.com
You can put your combobox in the header section of the subform. Then based
on the selection in the combobox, you can apply your filter like this (using
your fieldnames and combobox name). If the user will click on an item, you
can ...Auto-backup fails if "tmp" is on a FAT32 drive
Now this is weird. Money 2003 (which works almost perfectly for me) balks
at creating the automatic backup at program exit, IF the environment
variable "tmp" points to a folder on any FAT32 partition. A dialog box
says that Money cannot create a temporary file on P:\Temp. The folder
exists, and it's not marked read-only. (Since it's FAT32, it shouldn't be
a permissions issue.)
If "tmp" points anywhere on an NTFS partition, Money 2003 creates the
backup on exit just fine.
Although the message says that Money "cannot create a temporary file",...Help Text for Radio Buttons
I am trying to create a survey form with multiple choice radio buttons. I
want to add descriptive text that appears when you float your cursor over the
button (like that for a toolbar icon). I've scoured Excel help and couldn't
find anything. I don't have experience with macros or Visual Basic but am
willing to try if someone can hold my hand through it.
If the radio button is in a cell, add a comment to the cell. Then the
instructions will appear when the mouse hovers over the cell.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th...Separate data string into numeric and text
Can anyone help me with a script, to read in a string of mixed
numerical and text data, and separate them to a specific format of
This is the raw data:
11-11-11,44444444,JOE R BLOGGS,2757.42,
I need to convert the data into
11111144444444JOE R BLOGGS 2757.42
Firstly i need to remove the "-" and ",", so that it all joins up.
There needs to be 6 chars at the start for 111111.
At the 7th char i need to leave space for 8 digits (44444444 -
although sometimes the no. being read in will be less than this).
Then 15 chars must be left for name, and the amount will...inserting texts in cell based on conditions
I would very much appreciate if someone could help me
solving a problem, illustrated by the following example:
Column A B C
1 1 "LB"
2 1 "DK"
4 1 1 "LB/DK"
If there's a 1 in column A, the corresponding cell in
column C should get the text "LB" inserted into it.
If there's a 1 in column C, the corresponding cell in
column C should get the text "DK" inserted into it.
If both column A and B have ones in them, the
corresponding cell should get the...CSV formatted text file to Excel
I am writing a small VC++ application of how to import the CSV
..txt file to excel. I am facing problem while parsing the text file.
12534 , 763534 , 23
12345 , 624333, 24
The problem is in MFC there is a SetValue2(CoeVariant:column data)
method in which if i will pass an array(12534) then it will be
imported to excel.For example IfI will search for the "employee
number" field in text file then the values passed to SetValue2()should
be 12543 and 12345.But Using C++ I cannot do so as I...Auto Filling fields in form
I am new at creating code and would like to have two fields populated when
the record is reviewed.
One is the user name and the other is the date reviewed.
There is a form which contains the Member Name and ID number. I would like
to add the two auto fill fields in the Parent form and have it fill in the
subform fields for that particular member using a trigger of some sort.
Any advice would be appreciated.
Access forms display data... Access tables store it.
If you want to see data from a record in a table in your form, your controls
in the form need to be poin...allowing a text box to grow
Is it difficult to have a CEdit control and its dialog grow according to the
length of the string in the control? I'm interested in using such an
arrangement for my error messages and would like it to fit my messages.
Use DrawText to compute the rectangle required and resize your control to accomodate it.
On Tue, 27 Mar 2007 18:31:07 -0400, "SteveR" <email@example.com> wrote:
>Is it difficult to have a CEdit control and its dialog grow according to the
>length of the string in the control? I'm interested in using such an
>arra...Like criteria on a combo box ot working the way I want... Please help!
Below is a the standard code I use in a combo box.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[llListingID] = " & str(Nz(Me![cboTerritoryName], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.Form.AllowAdditions = False
The query used to find the data is...
SELECT qryLister.llListingID, qryLister.llTerritoryName
WHERE (((qryLister.llTerritoryName) Like "*"+[Enter any part of Territory
All works fine for the first look-up. But in order to refresh the combo box
so it allows one to &...Copy and Paste text to Word
I have a large spreadsheet of data. There are no values
or formulas. I need to cut and past this into word in a
way that shows the paste only as text - normally it has
an outline of the cells. Reason is that I need to save
this as a .txt file for an upload to another system.
Thanks in advance (again)
> way that shows the paste only as text
In Word, try:
Edit > Paste special > Unformatted Text
Please respond, in newsgroup
>I have a large spr...Parse multiple text lines into 1 line in excel
help. I am an excel beginner and can't find out how to turn multipl
lines of text into 1 row in excel. It's probably really easy but m
manual is USELESS. Can anyone help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
You're a little short on details. If nothing below fits the bill post back.
"Multiple lines" is how many and is each line in a separate cell down one
Do you want all lines to go into one cell?
You can use this form...save attachment dialog box
Does anyone know how to change the dialog box that opens
up when you click on an attachment to open, instead of
save? The boss thinks he wastes too much time changing
the checkbox. My guess would be somewhere in the
registry, but don't know where or how.
What exactly do you mean? You mean the dialog that comes up and promps you
to Save, Open or Cancel?
The "Confirm Open after Download" can only be modified with local
admnistrator permissions as it changes the registry of the local computer.
Control Panel-> Folder Options-> tab File Types
Robert Sparnaaij [MVP-O...change cell values from an edit box
Is there any way to change a cell's value with an edit box? I've used
drop down lists to change/update values, but I have no experience at
all with edit boxes. Any help would be greatly appreciated.
...Blurry text in Bold
Bold characters in excel cells are blurred (reduced clarity) regular text appears fine.
Please advise on remedy
I understand that Word 2003 has similar issues on regular font. (deactivate ClearType was solution for word)
I cannot find any info regarding Excel 2003 in knowledge base