continued: multiple selections in a list-box
There was a thread started on 9/15 about this (see below) where a list box
with multiple selections would be dropped into a text field separated by by
commas (or whatever you want).
The corrolary to this then is: now that I've got a text / memo item filled
with multiple values, how do I extract that back to the list-box if the form
is opened up later to that record.
Secondarily, is there a way to pull each of the values from the list box and
have it populate a different table that has the record number and choice.
For example, the main form (tbl_main) has you choose three or more...Pivot Table not pulling all fields or data
Without getting too verbose, I have a 900 row by 26 column database I am
applying a Pivot Table to. The code seems to run fine, but it is not
returning some of the fields, and of course the related data. I have tried
reformatting the entire columns I am pulling from but no joy......however,
when I reformat an errant cell from General to TEXT, that row comes
in........and/or, if I change the value in one of the missing cells, it will
bring that row in. The code runs fine, and was mostly derived by recording
a macro in XL2k, but the data cannot be trusted becau...How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in
Collumn C. Right now Both are defined by rows 4 to 114.
I would like to be able to have the chart automatically redefine itself so
if I put a value in C115 the chart would automaticaly set Y value range to be
C4:C115 eithout having to manually define chart. Is this possible? If so
how? I've tried OFFSET bu so far no luck.
If you turn your data cells into a List, or Table in xl2007, the chart will
The named range approach will work if you set up the names correctly.
See here for more info...Formatting Text in a Forwarded Email Message
Odd problem in Outlook on one of our pc's. We are using Outlook 2002 SP3.
When attempting to forward a message, I sometimes change a few of the words
in the body of the message. I place the cursor within the word I wish to
change. As soon as I type one letter, any letter, the letter shows up two
font sizes bigger (from 12 to 14), and with a space on each side of the
What seems to make this more puzzling is that when I attempt the same task
on our other pc, everything functions as it should; no change in font size
and no extra spaces.
Any help in eli...Comparing text strings
I have two columns populated with names and I need to compare them for
duplicates. Some duplicate names may contain middle initial or middle names
and some don't. So they may not be EXACT. Please give me suggestions on
formulas or funcions that would help me accomplish this task.
On Fri, 27 Nov 2009 11:12:01 -0800, Comparing columns with text <Comparing
columns with firstname.lastname@example.org> wrote:
>I have two columns populated with names and I need to compare them for
>duplicates. Some duplicate names may contain middle initial or middle names
...Exchange data backup
I'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
SBS2008 Takes care of it.
look at the comments section
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Seco...Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save
records, where as the system administrator is able to save the same
information. Please advice on this error, what has to be done.
I have disabled the windows user ID of the Database owner. Thinking of this
made Dynasa as the DBO.
Database is having enough free space available.
How big is the company database? Is it over 10GB?
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
> GP Ver 6.0. Recently I...How do I expand the amount of text I can put in a cell?
I am entering text into a cell & can see it in the formula bar up top, but
it's giving me the #### in the cell that states it's too big. How can I get
it to show my text?
Put your cursor between the column you want to expand, and the column to the
right. When you see a four sided arrow, click and drag it to the right. You
may need to also Format, Cell, Alignment and click on Wrap Text.
Hope this helps,
> I am entering text into a cell & can see it in the formula bar up top, but
> it's giving me the #### in the cell...Change a text box to a combo box
I have created several forms in my database.
I realized that I should have made them combo boxes instead of text boxes.
Is there any easy way for me to change them into the format I need?
Thank you in advance for your help.
Right-click on the text box and select changeTo from the menu.
"forest8" <email@example.com> wrote in message
news:FD867B89-38CC-4F20-A9AE-C177444DA9DA@microsoft.com...the > Hi there
> I have created several forms in my database.
> I realized that I should have made them combo ...Pivot Table Text Only, No calculations
:confused: I have a spreadsheet of data, text only. An address list.
want to look at the table by city. Is there a way to do this withou
calculation? For example, I want to have a city has the page field an
look at all the addresses, including columns, within that city.
rmm30's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=835
View this thread: http://www.excelforum.com/showthread.php?threadid=26902
A pivot table is a good tool for summarizing data, but won't help...cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824
is not. I can find and replace in my formulas to correct the problem, but it
does it each time the data is refreshed. Any suggestions as to why?
I gave you the INDIRECT option y'day, but received no feedback from you in
that thread. Looks like you're more interested in knowing why? One simple
hunc...Message box error check box
I have built a databse, on a form i have a close button i want to do
a few checks to see if certain text boxes have data in them. I would
want message box and then i want it to set focus to that box ( and
highty llight it in red if pos)
I have about 10 checks to do on every form that the best way to do
"Simon" <S.Dickson@shos.co.uk> wrote in message
>I have built a databse, on a form i have a close button i want to do
> a few checks to see if certain text boxes have data in the...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...Incorrect Field Names Appear in PivotTable Field Dialog Box
I have found that items deleted from my source, standard worksheet,
are still appearing in the Pivot Table Drop down list. I have applied
the sollution in MS202232 but it did not clearup the outdated data. I
have refreashed the pivot table before and after runing the MACRO
Not sure what else can be done, I continue to search groups and MS.
This is the code for the MACRO based MS202232:
On Error Resume Next
For Each pvtfield In
For Each pvtitem In pvtfield.PivotItem...Displaying Text
I have an MFC application, where I'm interested in displaying some
text for the user in the client area. To do this, I create a device
context, and use the .TextOut method to display CStrings.
The problem begins when the window is resized, or when a menu that
hides the text pops - once the menu is closed, or after the window has
been resized, the text (or parts of it) are being erased.
How can this be solved? I read that when the window is resized,
OnPaint is called, and thus I tried displaying the text from there -
hoping to re-display it "after" it has been erased. The...Linking text to style for auto update
I want to auto update figure/table number in text to that in Figure/Table
Use Insert > Cross Reference to put the numbers into the text; they
don't update every time the numbering changes, but only when you tell
them to (Ctrl-A, F9) or when you print or switch to Print Preview.
On Dec 18, 4:05=A0pm, Taurus <Tau...@discussions.microsoft.com> wrote:
> I want to auto update figure/table number in text to that in Figure/Table
> style numbers
...Display comments as data #2
thanks a lot , this worked exactly as required, the comment go
converted to data
Now just one more thing . is the vice versa possible i.e if i have dat
in column A can it be shown as comment in column B.
the reason i need this is bcos i am shifting some data with thei
comments to MS access(Hence the need to convert omments to data)
processing them and again converting them to excel (the need to conver
data back to comments
sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Advanced Filtering
I've got a worksheet with four columns, one of which is a user name. I
would like to take all the user names that contain numbers (and their
respective data) and put it into a separate worksheet. So far, I
haven't had any luck doing this with any combination of wildcard
The format of the user names are two or three letters and then 4
numbers, or they are entirely text. So the list has data like abc1234,
ab1234 and abcdef. I want all the abc1234 and ab1234 entries in a
Thanks in advance.
Maybe you could use a helper column and filt...Count invalid data entries
I am using the following macro to identify invalid data entries in
cells with data validation applied.
' Application.CommandBars("Formula Auditing").Visible = True
MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) &
" Configuration and Parts_TakeOff Sheets")
Is there a way to count the number of invalid data entries (red
circles) and write the number to a particular ce...Copying Formula Text
Is it possible to copy and paste just the text of a formula from on
cell to another without going into the formula text window and usin
Ctrl+c. Can this be done from multiple cells to multple cells.
jpx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=101
View this thread: http://www.excelforum.com/showthread.php?threadid=37716
select new location
edit/paste special, select Values.
Right-click the BORDER of the selection and drag to the new location. When
you ...In POwer POint 2003 can I gradually add text in the same slide?
I want to gradually add text in my presentation within the same slide. For
ex: The beginning of an equation and click the mouse to complete the equation
as I explain it.
Read the instruction here:
Bart: "According to creationism, there were no cavemen."
Homer: "Well good riddance, their drawings sucked and they all looked like
"PP HELP" <PP HELP@discussions.microsoft.com> wrote in message
> I want to gradually add text in ...Multiple combo boxes on a form
I have a form based on two tables. I would like a combo box for a field from
each table that will fill in various fields from the relevant table. Does
anyone have any suggestions?
On Fri, 17 Aug 2007 23:58:37 GMT, "Malt" <u36720@uwe> wrote:
>I have a form based on two tables. I would like a combo box for a field from
>each table that will fill in various fields from the relevant table. Does
>anyone have any suggestions?
Why would you want to do that?
It sounds like you're trying to store data from one table redundantly into a
second table. This is essentially ...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...Text wrapping #4
I am just trying to create a document using publisher 2003. I have some
pictures on the page and have text boxes containing the text I want. The
problem is that it seems to be putting in the - in the text when it spreads
it on to the next line. How can I stop it doing this and move the whole word
on to the next line.
Tools, language, hyphenation, clear the box.
Mary Sauer MSFT MVP
"Glenn Clark" <glenn.(NOSPAMclark@btinternet(NOSPAM).com> wrote in message