Can't get a value from a querry into a forms text box
I have a main Shippin Control table, and a main Shipping Control form
with description of cargo and quantity text boxes. I have a querry which
is a join of tblValues and tblShipping_Control. The SQL is below
SELECT Shipping_Control.DescriptionofCargo, Shipping_Control.CargoQty,
tblValues.Value, ([Shipping_Control].[CargoQty]*[tblValues].[Value]) AS
CommercialValue, Shipping_Control.ShippingDate, Shipping_Control.ShipTo,
FROM Ship...Outlook catagories disappear...
I noticed that at times some of my catagories in
outlook sometimes no longer remain on my Master List, and
I then have to recreate them. I have Win server NT 4, and
Office 2000, Sr-1a. I am trying to get SP-3 on, but an
earlier post notes that a ""The Expected Version of the
Product Was Not Found on Your System" error, so if it's an
upgrade needed, I'm stuck untill I do a full backup of
this Exchange server and reinstall everything from
...pictures and objects appear blank in publisher 2002, but print ok
recentl when opening a file with pictures and objects in publisher 2002, they
all appear blank. But they will print ok. I tried copying and pasting an
object to a new page and its then visible but out of focus as if it has been
enlarged too much. If I select all and copy it to a new page then the problem
Read the third FAQ here
Q: Why can I not see images/shapes/lines when editing my publication?
Mary Sauer MSFT MVP
http://officebeta.iponet.net/en-u...Howto: Protecting specifig Ranges for inserting Rows
I would like to protect specific Ranges of my Sheet. The users should be
able to edit specific CELLS and additionally EDIT cells and INSERTnew Rows
intos a specific predefined RANGE. But users should not be able to add Rows
in the other parts of the Sheet.
Do you know its possible? How to realize that?
If you use a multi-cell array entered formula, Excel will prevent row
insertion (or column insertion) within that range.
For example, select A1:A10, type =ROW(), then press Ctrl-Shift-Enter. Then
select a cell in, say, row 8 and try to insert a new row: Excel will
protest, an...Background picture behind chart
In Excel I have successfully inserted a picture behind an interactive chart
so the chart (graph) is visible overtop of the picture. But when I Save as
Web Page the picture doesn't show up. The graph is fine, and is interactive,
but the background picture file (gif) has disappeared. How can I preserve
the picture so it will save as part of the Web Page? Thanks.
Not tested but could you use the picture as the Fill Special for the
chart or plot area?
> In Excel I have successfully inserted a picture behind an interactive chart
> so the...i forgot how to make my business card insert for word documents?
i had to restore my software and I read somewhere how to have my salutation
on my word docs into a buisness card insert, can anyone help?
...how do i up load from my pictures to advertising web site
how do i up load from my pictures to an advertising web site
On Wed, 25 Nov 2009 15:58:01 -0800, pictures
>how do i up load from my pictures to an advertising web site
Ask the administrator of the website. The technique will differ from site to
In any case, this question does not appear to have anything to do with Visual
Basic for Applications modules in Microsoft Access, which is the subject of
John W. Vinson [MVP]
...Checking text length.
I have a large list of names (about 2500) in microsoft excel but I need to
find all cells within a column that have a text length of more than 30
characters including spaces. Is there an easy way to do this or do I need to
- select your data (e.g. cells A1:A3000)
- goto 'format - Conditional Format)
- enter the following formula
- choose a format to highlight these cells
>I have a large list of names (about 2500) in microsoft
excel but I need to
>find all cells within a column that have a te...Text To Date Conversion
I run Excel 2000
I download information from a mainframe into Excel.
In cell F5 the data looks like this: 19.11.2007
This is formatted as text and is left aligned.
When I try to reformat it to a date (19/11/2007) it does not change.
I would like to have a formula in cell N5 that changes the original data to
a datevalue. (eg: 19/11/2007)
If column F contains a lot of the "date" values, then you could:
Data|Text to columns
Fixed width (but don't have any separator lines!)
choose Date (dmy order)
and finish up
Then give the range the date ...text not wrapping in column
I have an Excel spread sheet with columns of wrapped
text. At a certain point, the text stops wrapping. If I
try to shrink to fit, the text disappears. Any ideas?
...Automate text import
I've wrtten a batch file to audit all our servers, what
I'd now like to do though is come up with a way excel can
load these text files into one worksheet.
Can anyone please help?
Below is an example of the data gathered - the text files
are named after the computer.
Kernel version: Microsoft Windows 2000,
Product type: Professional
Service pack: 3
IE version: 5.0100
System root: C:\WINNT
Processor speed...Text Form Field Maximum Character Length
I want to have a text form field that has a maximum character limit of 300
characters. I go into properties and set the max length to 300 and select
calculate on exit, but it doesn't stop entries over the 300 characters.
Any suggestions? It is Word 2003.
...Trouble forwarding email as text message using SMS
I have set up to forward specific emails to my cell phone as text messages.
The content of the message does not come thru as part of the text (these
messages are SHORT messages)
Sheri <Sheri@discussions.microsoft.com> wrote:
> I have set up to forward specific emails to my cell phone as text
> messages. The content of the message does not come thru as part of
> the text (these messages are SHORT messages)
> Any suggestions?
No need to ask more than once.
Brian Tillman [MVP-Outlook]
...Inserting blank rows where numbers break sequence
How would I change a 2 column list to add the missing numbers left out of sequence?
...How do I add a floating text box in Excel?
I have a shared workbook with several huge spreadsheets. There are certain
things that other users/viewers would readily want to know without parsing to
the end of the spreadsheet. How can I create a floating text box in Excel
and include totals of certain cells from the same worksheet?
MS has lots of templates at:
And there's always google!
> I have a shared workbook with several huge spreadsheets. There are certain
> things that other users/viewers would readily want to know without parsing to
> the...Scatter with text on X
I am trying to construct one scatterplot for 2 groups of data A & B.
would like to have A and B as two points on the X-axis and the (Y
data values which pertain to A and B plotted as dots above them in
I have tried many different things and HELP to try to do this an
no-one at work knows either. I am obviously missing out on somethin
simple but important. Expert experience would be greatly appreciated!
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.c...Seperating text, backwards to frontwards #2
I have a field which is like the below example:
"Disappointed at failure - 68 Interior equipment - Repair group: Body -
Now I want to split this into fields, as per below:
A B C
..Archive Repair group: Body 68 Interior equipment Dissapointed
I know that I can use text to columns to split the field by the "-" but
then how do I get it reversed?
NOT all of the fields can be split into 4, sometimes there can be up to
7 or as little as 1.
Does anyone have an answer?
use ...How do I edit my logo picture?
I have loaded the Suspended Rectangle Logo into a Publisher 2003 document and
I would like to take the pyramid out of it but for some reason i cant.. I
select it but when I click delete, i deletes the whole logo...
Select the logo, arrange, ungroup.
Mary Sauer MSFT MVP
"thunderstruck_302" <email@example.com> wrote in message
>I have loaded the Suspended Rectangle Logo into a Publisher 2003 document and
...Pictures have turned to Red X's
I just installed Office 2003 and now all my html messages
that "used to" contain pictures have nothing but red X'x.
Anyone know what is up with that? This does not happen in
In Outlook, is that what youre talking about? If so, are
your picture download settings set to automatically
Tools> Options > Security > Download Pictures
Try that out.
>I just installed Office 2003 and now all my html messages
>that "used to" contain pictures have nothing but red X'x.
>Anyone know ...Insert a Row
How do you insert a new row imbetween rows
without bringing down the Color of the above
It always happen's
Any suggestions would be appreciated.
The only thing would possibly be a Macro with cleanup
I found a solution.
Copy a Blank row,
Then use copy insert
I would welcome other solutions
Tools>Options>Edit. Uncheck "extend data range formats and formulas"
Gord Dibben MS Excel MVP
On 6 Jan 2007 07:07:00 -0800, "smandula" <firstname.lastname@example.org> wrote:
>I found a solution.
>Copy a Blank row,
>Then use copy inse...Read Text File into Excel Using VBA
I'm a new VBA programmer. I know how to pull an entire text file
into an Excel Spreadsheet, but I only want specific information from
the text file not the entire text file.
What I have is about 25 text files stored in a folder, let's say
Each file is named by a property address as follows:
209 MAIN ST.txt
213 MAIN ST.txt
111 ELM ST.txt
2356 WOOD AVE.txt
On the 11th row of each file is as follows:
Property Address:209 MAIN ST
On the 31st row of each file is as follows:
What I would like to do is read each file located in the "C:\test
folder...I need 2 add a legend 2 pictures in a word or publisher document
can anyone help
My first suggestion would be to use proper words. Using cutesy shorthand is
Having said that - what exactly do you want to do? And in which program?
MVP Microsoft [Publisher]
"add legend to word or publisher document" <add legend to word or publisher
email@example.com> wrote in message
> can anyone help
Is this English?
"add legend to word or publisher document" <add legend to word or p...Outlook randomly inserts attachments in body or attachment line in header
Outlook randomly inserts attachments in body or
attachment line in header.
Why is that and is there a way to override this so that
attachments always appear as a line in the header portion
rather than appear in the body of the message.
Using Outlook 2002 SP-1 on Win2k SP-3 build 2195
Where the attachments sits is determined by the message format, Rich text in
body of message, Plain and HTML in its own field
"Richard Barber" <firstname.lastname@example.org> wrote in message
> Outlook randomly inserts attachments in body or
> a...Insert into a file
I am ready to try adding "edit" to my App. I have done some searching
for ideas and am (a little) surprised not to find quite what I am
Is there a way with CFile or some other file class to easily insert
(replace or delete) some data in an open file? What I have read seems
to indicate that I need to copy the file up to the edit point, do the
edit and change pointers and length as necessary and then copy the
rest of the file. This can be done by copying into a new file (and
rename, etc.) or read the whole file into memory and do it in the
buffer (either in-place or to a n...Count Text Values in Column
I converted a column of number cells to text to allow entry of 1a, 1b, etc.
and need to be able to count the totals of these cells. I can't give it
specific criteria to use DCOUNTA since the text value will vary. Is there a
way to get a count of non-blank cells in a column of text values?
As a note, I do not really care what the value is, I just need to count the
totals. If there is a way to reformat or remove text via a formula, that
would work as well. Thanks!
"Karl Burrows" <email@example.com> wrote in message