One of the features i like from Open Office, is the auto-suggest /
auto-complete word as you type. Say for example i type accommo the program
will show accommodation as an option and i just hit enter to make the choice
Can Word do this too?
It could through Word2003, and it's been reported that the feature was
restored in Word2010.
Although if you've already gotten as far as "accommo," that particular
AutoCorrect doesn't do you much good, since in that word it's the
number of c's and m's that's tricky, and how would it know wheth...Auto sort in real time
Is it possible to auto sort data so that changes update themselves i
real time without using VBA.
I have sorted a column of data in decending order but when I change
value in that column it does not update its self and re-arrange th
order of values automatically. Can I make it do that for me? I know ho
to create a macro that will re-apply the sort but a realtim
re-arrangement of data (like in Access) would be much better. Ca
anyone help me?
Bernard Jordan - Liverpool U
Message posted from http://www.ExcelForum.com
If you've already written the VBA, try putting...Create a smart textbox that display a list as you start typing in
Is it possible to start displaying items once I start typing in a textbox?
For eg, I have a userform connected to access database, Once I start typing
in Name text box it displays the result below (something like google search)
SO if I type in "A" i get all the names starting with "A" such as:
Name: [ A.... ]
If I type in a number, "2" I get the list of phone numbers starting with 2
and so on.
Can this be done in VBA?
Hope I made it clear.
Thanks in Advance
Yes it i...auto comlete a row of data
in exel say for instance g1 is a lisence plate number (variable) how can i
get A1-f1 to be filled with spesific data dedicated to each licence number
You could use a lookup table and VLookup formulas or a macro. More info OR
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
Microsoft MVP Excel
SalesAid Soft...Auto receive
How can I receive messages automatically when opening OE 2003 rather than clicking on the Send/Receive? I have set auto receive every 15 minutes, but it should still do it automatically when opening OE
There is no such beast as OE 2003. Are you using Outlook or Outlook Express?
If Outlook, tools->Send/receive->set an automatic polling interval.
If Outlook Express, this newsgroup is for support of Outlook 97-2003 from
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
mi...Auto name completion and .NK2 file
I was helping a friend troubleshoot why her Auto name
completion and name checking (in OL 2002) suddenly quit
working. I verified all the appropriate settings. Then I
checked into the .NK2 issue as suggested by the Microsoft
website. She didn't have one but in my quest to discover
her problem I discovered I don't have a .NK2 file either
but by name completion and checking work just fine. I
have "show hidden files" checked but an automatic and
manual search come up empty. Any ideas?!?! Thanks.
What OS are you using? Did you look for it in the right folder?...Publisher 2007 Getting Started
I attended the Las Vegas Launch program yesterday and have successfully
downloaded and installed Microsoft Office Professional 2007. Thank you
When I open Publisher 2007, I get the page "Getting Started with Microsoft
Office Publisher 2007." I simply want to open to a blank one-page document,
and I'll open the document that I want.
How to change?
Not sure which task pane is opening for you. Tools, options, general tab, clear
"Show Publication types when starting Publisher."
If it is the task pane that is on the screen when you open Publisher,
righ...auto populate gl account
How can I set a GL code for the PURCH type in the Payables transaction entry
There are some credit memos we process and we want the default Purch GL
account to be automatically set to a predefined GL account.
This will apply to only "some" credit memos. A new field (checkbox) has
been created on the payables form, when the user checks this field I want
to set a predefined gl acount to PURCH TYPE.
You may need to use Continuum API to get and check for account type from
distribution combobox and fill the account number only when the type...So many Auto MS Updates lately
All the updates being downloaded recently (past 3 days) is screwing up my
computer. Any suggestions about what we can not download???
Thank you, in advance.
"~*Laughingstar*~" <email@example.com> wrote in message
> All the updates being downloaded recently (past 3 days) is screwing up my
> computer. Any suggestions about what we can not download???
> Thank you, in advance.
Any of them that don't fix something.
> ...Auto Invoicing
What are my options for automatic invoicing from Great Plains - either
electronic transaction to third party who will do US postal service print and
mail OR electronic directly to customer?
...Starting Outlook 2003.
I notice that it is possible to start OneNote with the /tsr option so
that it appears in the notification area for a quick start when needed.
Is it possible to do the same thing with Outlook 2003?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Luke Vogel asked:
| I notice that it is possible to start OneNote with the /tsr option so
| that it appears in ...Auto color-shading of rows
Can I automate an excel worksheet such that if ,say, "436" is written in a
certain cell it shades that row yellow, or if "437" is in that cell it
shades the row blue. It would then be easy to visually tell in an excel
chart which lines belonged to ,say, specific companies.
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "A1"
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
Select Case .Value
Case 436...Trouble with Data entry with the name starting with O'B...
Don't know where to look, but had this problem before. With names like
"O'Brien"? Getting a Syntax error #3077 ( Access database seems like it
doesn't like the apostrophe character ('). Any solution to this problem?
On Mon, 3 Mar 2008 06:59:01 -0800, Rocky <Rocky@discussions.microsoft.com>
>Don't know where to look, but had this problem before. With names like
>"O'Brien"? Getting a Syntax error #3077 ( Access database seems like it
>doesn't like the apostrophe character ('). Any solution to this problem?
Us...Auto update query
Can someone walk me through the steps for creating an update query? I have
two tables named "posnow" and Suppliers. both contain the same fields
"suppliers, contact, telephone and fax". (The supplier table contains the
information and the posnow table is the main design table)
I want to auto update fields on a form with the same name using this query.
Also should what should be used on the form, a list box, combo box or other
to look up the main field(supplier) to fill in the balance of the fields?
Please be definitive with you anwser for I am just a amatuer at this....Auto-adjust column width
Is there a way to set a column width so that it auto-adjusts to the widest
entry in the column? And what about the widest numerical entry, excluding
word-wrapped cells containing text?
I realise that I can double-click on the edge of the column header to
achieve most of the desired result passively, but this does not work if the
worksheet is protected.
Return email address is not as DEEP as it appears
depending on your Excel version you can allow formating columns in the
protection dialog. (I think starting with Excel 2002). In all other
cases no chance but to remo...Outlook 2000 will not start up
I am running XP XP2 with Office 2000 Premier. I was running outlook 2000 and
it was OK except for trying to get MSN mail to it. That wasn't a show stopper
but I got pocket PC 2003 for my Dell Axim5 which came with an Outlook 2002
load disk. I attempted to load it but it didn't go too well so removed it.
Outlook would not start... I removed Outlook with the old stand-by "Add and
Remove Programs" rfrom Control Panel . Re-loaded Outlook 2000, would not
start with the error message (six times each attempt)
"HrCreateNewWrappedObject@28 could mot be located in MSMAPI32....Problems auto sending email from IE using Outlook
When I right click on a picture on IE I get the option to
send as an email. If I select this an email is created
and put in the Outbox of Outlook but it's not sent. I
have to remember to open Outlook and send/receive. Anyone
have any ideas how to make this send happen
automatically ? I've checked all the various options and
can't see anything useful.
Have Outlook open when you do this.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my perso...auto replay for a e-mail activated public folder
I have a problem with the automatic reply for a e-mail activated
public folder. If I try to set up a rule for the folder I get the
Changes could not be saved.
I have full permission on the folder and I also have the right to send
as for the folder.
We are using Exchange 2000 with SP 3 on a Windows 2000 Server with SP
4. The clients use Outlook 2003 on a Windows 2000 System with SP 4.
Any help would be appreciated.
...DropDown aand Auto Fill
I have column with DropDown List.. The items are
Is there a option to automatically fill a cell, if I type the first letter
of an item?
Also when I type alt+ down arrow the list appears. I would like to fill the
cell when the first letter of an item is typed.
Is that possible?
If you have your three (or any other) values, above or below, in same column
"continued without line-gap", then this works the way you are asking.
If its Excel 2007, then;
> Click on round "Office Button" ...auto save settings
I have loaded the "auto save" option in the tools menu, but
the settings I make revert back to the default settings
after every session. Is there a way to make my settings
permanent or the default?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
For some reason my auto reply is not working now...I have had the same set
up for a few years now. But when I set up auto reply the message is sent to
my out box but never gets sent....it just stays there.
this is how I have my rule set up...see link to photo.....any
http://i284...Auto reconcile problem
As soon as I download transactions from any of my online accounts, all of
them are marked as reconciled, even before I accept them. (I do not have
"Automatically accept all downloaded transactions from banking statements"
or "Automatically mark accepted transactions as reconciled" chacked.)
Does anyone know why this might be happening? It makes balancing an account
very difficult, since I have to go through and mark transactions as
unreconciled before I balance.
...Macro to Click on Alphabet Letter to go to Cell Where that Alphabet Letter Starts in Large Spreadsheet
I have a very large spreadsheet with text entries and would like to set
it up so that I could click on a letter, for example, "d" and I'd be
taken to the first cell with an entry beginning with "d". I also need
to be able to continue to add data to the spreadsheet.
I've read a lot of posts and the best solution seems to be setting up a
macro. My problem is that I've never been able to record a macro and my
attempts to try these in both Word and Excel have failed miserably.
I've basically been self-taught in the Microsoft office programs for
the past few yea...PC Slow at Vista Start
When I start my PC using Vista Basic in the morning it will run really
slower than usual for both IE and Windows Mail connection. If I re-start it
fixes itself. I use "selective start up" and when I check start up programs
only my very view programs are running. Suggestions? Thanks!
"Even Stephen" wrote:
> When I start my PC using Vista Basic in the morning it will run really
> slower than usual for both IE and Windows Mail connection. If I re-start it
> fixes itself. I use "selective start up" and when I check start up program...Auto-import word tables into excel?
Campers - I need to automatically import the contents of
one table from Word into Excel, for about 1500 word
documents. Any ideas on how this can be nicely done?
"Andrew Harder" <firstname.lastname@example.org> wrote in
> Campers - I need to automatically import the contents of
> one table from Word into Excel, for about 1500 word
> documents. Any ideas on how this can be nicely done?
Probably Visual Basic, to export the tables from Word and import them into
Excel. VB can control both of them.