Multiple sessions logged on
I just converted a DB to Access 2002 format. Now, every
time I open it, the .ldb file shows two open sessions.
Because of this, every time I open it, it won't let me
edit anything or save any changes, because it thinks more
than one user has the file open (No one else could
possibly have it open - I just created it, so no one else
even knows it exists!)
...using one combo box to determine content of a second combo box
I have been trying for several days to figure out how to use one combo
box to determine the content of a second combo box.
I am creating a database listing equipment by manufacturer and model #
I would like to create one combo box that gives a drop down list of
Then, based on the manufacturer chosen, I would like to have a second
combo box which gives a drop down list of model #'s offered by the
It seems like a fairly simple concept, but I have poured through the
"using access 2003" guide with no luck
Access version I'm using: 20...Calc date one year from today
Im trying to calculate a date range that will monitor
warranty (364 days) from date of purchase order ??
Thanks for the help
It will even cover the difference between Leap Years and non-Leap
years which your 364 has a problem with.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Ken" <email@example.com> wrote in message
news:firstname.lastname@example.org......Copying E-mail Templates
Is there a way to copy an email template, instead of creating a similar one
from scratch everytime
On Jul 7, 1:18 am, Lee <L...@discussions.microsoft.com> wrote:
> Is there a way to copy an email template, instead of creating a similar one
> from scratch everytime
you can't copy the entire template, but you can go into the template,
copy the parts you want, and paste them into the new template.
Hope this helps,
...why is it that lately my sent mail fills up with EMPTY messages?
Yesterday I had something like 296 empty messages in my sent box. No subject,
no addressee but the date is there. Some have the opened envelop icon and
some are closed. What is going on????
Virus, malware, spyware whatever you may call it. You do need to scan your
system with MSE immediately.
"NBgorf" <NBgorf@discussions.microsoft.com> wrote in message
> Yesterday I had something like 296 empty messages in my sent box. No
> no addressee but the date is there. Some have the...Combo Box Search Time
I have a combo box that I currently use with the Auto Expand feature
on. This combo box points to a field in a query with 400,000
records. The box works fine but has about a 30 second latency delay
from the time it gets focus to the time where it will display the
records. I would like to cut this latency down to as little as
As a side note, I have 2 forms each with a combo box pointing to 2
different queries each with 400K records. The first combo box is a
zip code lookup and works super fast; the moment you click it the
results pop right up. The second combo box ...Is it possible to have 2 excel version in one computer?
i just installed a 2003 version office... i liked the new features but
when i wanted to open an excel file that has been created by 2002
version excel, i was shocked that i can't open the file successfully.
When i opened and enabled the built in macros in the file, an error
message popped out and said that the data may have been lost. After I
have closed the error message, i checked the file. the data is still in
the worksheet but all the words, format, buttons, and other information
have all disappeared. However, if I open it in another version other
than 2003, the file work...auto fillin box for e-mail show deleted addresses ... how do I get rid of them?
I go to create a new e-mail (with Outlook 2007) and fill in the 'To' field
with one alpha character. I see a drop down box (to speed things along) but
at least one of those 'suggestions' is not valid; that particular address
does not exist. It did exist at one time though.
How do I flush out those helpful though inaccurate\old e-mail addresses?
either select it using the arrow key and press delete or delete the nk2
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24...I can not see all contents in one cell. Help me pls!
Please help me! By default when I write some text in cell and the text is
longer then cell's width, I can not see his contents in next cells. But in
one excel file when I sellect all cells in worksheet and then draging them it
can no longer seen all contents in one cell. What I should to do? Thank you
If you have wraptext turned on (format|cells|alignment tab), then the cell will
expand its rowheight to show you all the data. (unless you use merged cells or
have adjusted the rowheight manually).
If you have wraptext turned off, then the text will overflow to the cell to ...Highlighting just one record in an unbound form
Long time user of Access, First time programming it.
I have an unbound form that takes employee ID's and work order job
information. When they arrive on the job they call in and I run an app to
enter the timestamp of when they arrived.
I may have a list of employees with jobs. My question is how do I or can I
highlight (Bold) the records that I have already timestamped? I have be
trying to use FontWidth but I keep getting all or nothing Bolded.
I tried to look at the Arrived field and if it has no value yet to regular
text. If it has a value then Bold.
Th...Re: New Build Of Windows Live Mail 2010
This is a multi-part message in MIME format.
In the new beta =E2=80=93 not this version.
"Nancy Jackman" <email@example.com> wrote in message news:...
The problem of WLM=E2=80=99s =E2=80=9Cstepping on itself=E2=80=9D when =
compacting and freeing up empty space seems to have been fixed as well.
Windows 2003 server with Exchange 2003 SP2
This is a very strange problem. I have one user who turns on his out of
office assistant and the out of office messages are not sent internally or
externally. All other users use out of office and the messages are sent
properly both internally and externally. I have the option configured to
allow this (http://support.microsoft.com/default.aspx?scid=kb;en-us;262352).
I can't for the life of me figure out why this one user is having this
problem. Everything appears to be configured for that user exactly the same
as all the other users who ar...cannot send email messages from Window Mail
I have email on mail2web.com and I use it from windowsmail so my problem that
I can recive email messages but Icannot send
Do you get an error message when you try to send? If so,=20
right-click on your error message, copy, then paste it into a reply =
We can't do much troubleshooting without the complete error message.=20
Gary VanderMolen, Microsoft MVP (Mail)
"Hassan" <Hassan @discussions.microsoft.com> wrote in message =
news:DA2310DC-3838-43A4-9701-36C4F01F6391@microsoft.com...Sending Mail from Windows Explorer Q
When you send a mail via Windows Explorer i.e send to mail recipient,
how can you do that without the message on the Subject line reading "e-
mailing: file that is attached" and also the message that appears
within the message body? I always manually delete, but is it possible
not to have these messages displayed in the first place?
I'm using Outlook 2003
Sean <firstname.lastname@example.org> wrote:
>When you send a mail via Windows Explorer i.e send to mail recipient,
>how can you do that without the message on the Subject line reading "e-
>mailing: file that is a...OFFSET for multiple columns & combobox format
Is there a way to have an OFFSET range of two columns? I have been using
multiple columns for my X axis values with non-dynamic charts. Now i'm
designing a dynamic chart, but Excel will not let me select two columns
(month/wk) for my X axis.
Another simple question > how can I format a comboBox text in a chart?
when u change the way u look @ things, the things u look at change.
To create an offset for multiple columns, first define a range name that
makes up those columns. For example, the name "XAxisCol" covers columns A
and B and refers to the formula / r...hiding mail folders
is there a way of hiding windows mail folder/folders from the folder listing?
"depe" <email@example.com> wrote in message
> is there a way of hiding windows mail folder/folders from the folder
MS-MVP. MAIL. [DTS] UK.
You can hide all of them, but not just specific ones:
View, Layout, uncheck Folder list. You may want to enable Fold...Multiple Sheet Protection
I have over 75 sheets in a workbook that I want to protect so that the contents of the cells remain hidden. Is there a way to apply protection to multiple sheets at a single time or do I need to open each sheet and apply protection.
You have to protect one by one. However, tedious repeating tasks is what macros do well,
so running those two won't take half a second:
Dim Wk As Worksheet
For Each Wk In ActiveWorkbook.Worksheets
Wk.Protect ("Harald is great")
Dim Wk As Worksheet
For Each Wk In ActiveWorkbook.Worksheets
...need to retrieve recently deleted email in live mail
How can I retrieve mail that was accidentally deleted before it could be read?
Open the "Deleted Items" folder under the affected account.
Windows 7 Ultimate
"manspirit1" <firstname.lastname@example.org> wrote in message
> How can I retrieve mail that was accidentally deleted before it could be
If it is(was) a Hotmail type account(Hotmail.com, Live.com, Msn.com) using Pop3 and the message is not in your ...mail want be delivered for the 2nd domain
we have registered another domain
made an MX record
added @domain.com in defaul policy
now i can get mail only for email@example.com, but not
what should i do?
Add or modify email address format in Recipient Policy.
"guzzi" <guzzi@_DOT_yandex.ru> wrote in message
> we have registered another domain
> made an MX record
> a...Multi-view selections in one chart.
Here is my goal... I would like to be able to select a pull down with
sorta lookup of e.g A, B, C, etc. program which reside on differen
tabs and be able to select program A and the chart shows stats for A
Next go to pull down and select B to see B's stats and so on. All whic
will show up on one chart. I would also like to be able to have
selection to show all A, B and C in one image on the chart as
summary. I am not strong at VB but understand code. I have created
summary and each individual chart as needed but would like it to rollu
into one chart.
Any ideas?? :eek
------------...How to mail disable users
I want to reinstall my exchange 2000 server, but it is telling me I have to
mail disable users first. How do I do this???
thanks in advance
On Wed, 19 Jan 2005 13:34:24 +0800, "AlanM" <firstname.lastname@example.org> wrote:
>I want to reinstall my exchange 2000 server, but it is telling me I have to
>mail disable users first. How do I do this???
>thanks in advance
How is that you're planning to, and even needing to re-install
"Mark Arnold [MVP]" <email@example.com> wrote in message
&g...Chart visable for one user and no one else
This is quite odd. One user is able to view a chart,
however, when anyone else opens the document, the chart
doesn't exist. The chart is in a separate sheet labeled,
We are using Excel XP with DocsOpen. Anyone know
anything about this kind of behavior?
Thanks in advance,
...Telnet <mailboxserver> 25 works from servers on same subnet, fails to one server
Interesting. I setup MOM server and I need to configure to send e-mail thru
my mailbox Exchange server.
However, when I go to new Win2003 MOM server, I do telnet
<mymailboExchServer> 25 and connection is
Connecting To <mailbox>...Could not open connection to the host, on port 25:
Then I go to another server, *same subnet* and I do telnet < > 25 and it
goes thru just fine.
Do you have an idea what could be causing such SMTP 'blocking' from the MOM
server ? If servers on the subnet can connect just fine, I can't imagine how
this can be a fire...Time formats in Excel 2003
Being in the UK, I obviously want to use the English(UK) date format, so
Christmas Day is 25/12/05 rather than 12/25/05. However, this defaults
the time format to hh/mm/ss (why, I do not know, since I can assure
American readers we're not normally that precise), so I have to reset it
English(US) to get hh/mm, which resets the default date format to
mm/dd/yy, so I have to change it back the next time I want to format a
cell as a date.
Any way round this? It's only a minor problem but it's irritating me.
If you set up your own custom format with hh/mm, it w...how to copy a row of cells automatically from one worksheet to another by changing the value of1cell
I have 8 cells on the same row in one worksheet that I would like to be
automatically copied to a predefined area in one of 3 other worksheets
in my file depending on the number (1, 2 or 3) entered in one cell
adjacent to these 8 cells.
Is this possible and, if so, how could it be done? Thanks very much for
any help you can offer me with this.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
You could use the worksheet change event: this will copy the eight cells
from the s...