I delete an email it remains in folder with line through it
How do I move deleted email from in box to deleted subfile without keeping a
copy in the inbox with strikethru in it?? I have to email accounts on the
computer one is pop3 the other is ms exchange? Not good with computers
Are you sure its pop3 and exchange? it sounds like you set up an IMAP
account - deleted items are marked with a strikethrough until you purge the
folder from the edit menu. You can also use a view that hides items marked
We can be more specific if we knew the version of Outlook you use.
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? htt...combo box selection to change subform
I have a form, which has a combo box in it...
I also have a subform which lists the assets we have..
I would like the subform to only show assets which match the selected combo
box selection on click..
How can I do this?
An example using list boxes to drill data down is at:
Arvin Meyer, MCP, MVP
"Jeffa" <Jeffa@discussions.microsoft.com> wrote in message
> Hey Guys,
> ...Range Selection
I was tryin gto programatically select a range basis the current
position and a fixed reference
I'm using the following code snippet
Dim CurrentCell As String
CurrentCell = ActiveCell.Address
It gives an error 400 and exits
any ideas as to what am I doing wrong?
Range("b1:" & CurrentCell).Select
Excel will "see" CurrentCell as a
string of characters, not as a variable.
Followup to newsgroup only please.
&...Deleted Distro group remains in the Global Address book
Windows 2003 Server / Exchange 2003
I removed a distribution group from Active Directory with the name of
"Info". I then created a user with the name "Info".
Te mailbox works fine, however, the "Info" distribution group shows in
the Global Address Book and the user "Info" does not.
Thanks for any and all help.
firstname.lastname@example.org <email@example.com> typed:
> Windows 2003 Server / Exchange 2003
> I removed a distribution group from Active Directory with the ...Import excel but selected column for selected table
I want to import excel to access but I want selected column to appear in
For example i want to be able to specify column 1,2,3 to load in table 1 and
column 4,5,8 to appear in table 2..
May i know the way please?
Message posted via AccessMonster.com
May I know the way please?
Trever B wrote:
>Import to a temp table
>Run 2 append queries appending the data to the files you want
>> I want to import excel to access but I want selected column to ...how do you "select locked cells" w/o "select unlocked cells"?
I am using Excel 2003.
I am attempting to protect only certain cells within an Excel worksheet. I
first click on FORMAT, CELLS, and "deselect" the "LOCKED" check box. I then
highlight the cells I wish to protect, repeat that step, only this time make
sure the LOCKED check box is checked.
I then go to to TOOLS, PROTECTION, PROTECT SHEET, and attempt to select the
option, and JUST the option for "Select locked cells", however, everytime I
select this option, a checkmark appears next to "Select unlocked cells" as
well. One seems to trigger the othe...Justify across selection
I found the "center across selection" formatting function but I really need
to "justify across selection." Any ideas?
On Mar 23, 1:49=A0pm, bfloyd <bfl...@discussions.microsoft.com> wrote:
> I found the "center across selection" formatting function but I really ne=
> to "justify across selection." =A0Any ideas? =A0
Merge the cells
...Deleting rows below my data
I have some worksheets that have used 380 rows but the
scroll bar on some of the sheets go down to appx 1900
rows, so when I send it to my web you can scroll down a
long blank page after my data. Can I remove the blank
Select everything to the right and below your data, while select do
Save the workbook.
"Troy" <firstname.lastname@example.org> wrote in message
> I have some worksheets that have used 380 rows but the
> scroll bar on some of the sheets go down to app...Deleting All Cells with Number formulas Ex. =2+3 not = A1+B2
Deleting All Cells with formulas with Numbers Ex. =2+3 not = A1+B2
I am trying to create a copy of workbook with only formulas, but some cells
exist with =2+3 which I do Not wanted. How can I delete all of this in a
this should do it
For Each c In Selection
If c.HasFormula And _
IsNumeric(Mid(c.Formula, 2, 1)) Then c.Clear
"Samshun" <Samshun@discussions.microsoft.com> wrote in message
>...Running a parameter query off more than one multi-select list box
I have finally been able to create a form with a multi-select list box and a
command button where a click of the command button opens a query with the
selections in the multi-select list box as its criteria. So far so good...
now I am wanting to use more than one multi-select list box as the criteria
for the query.
The code I used to successfully run a query off a multi-select list box is as
follows (with Command6 being the name of my command button, TESTQ being the
name of my parameter query, MyTable being the name of the table my list box
gets its values from, MyTableID the name of the fi...selection box
I am working with a spreadsheet a predecessor made. It has what appears to
be a drop down box in one spreadsheet which places the value selected in
another sheet. The cell where the data shows up does not have a formula
associated with it. The drop down box does not look like the standard
validation drop down box. It shows the last selection and has a large down
arrow that is always displayed. I checked the sheet for macro's and did not
find any. I would think one of the other posts may cover this but I am not
sure what "category" to search for since it is not acting...Passing Date from a form to SQL Select
I'm having problem passing dates from a from in to my query so I can
load a recorset in a another form. I"m getting runtime error 2001.
GCriteria = "[JobName] Like """ &
Forms![frmSearchByJobandDate]![txtSearchString] & "*" & _
""" AND [JobDate] >= """ &
Forms![frmSearchByJobandDate]![CboBeginningDate] & "*" & _
""" AND [JobDate] <= """ &
Forms![frmSearchByJobandDate]![CboEndingDate] & "*" & """"
...how to disable images for selected websites
FF and Opera have a function that allows to block images on specific
websites, ie images load normally everywhere else but on website xyz they are
Does something like this exist in IE 8?
...HTML Table Selection
Can any one tell me how to select a single column of a
table in HTML page. If u select a column now,
from the next row onwards all the cells will be selected.
I want only the particular column. How to do that?
...Outlook Express News enable group selection when putting in order
When required to "combine and download messages" in OutLook Express, only one
file can be moved at a time. I am suggesting that multiple message part
selection via the shift/control key be enabled in the same manner that it is
in all other file manager applications. I.E. When someone posts a message
with many parts and the message parts numbers range from 01 to 199, I must
move 99 messages which are all in sequence. I currently must do this one at
a time...very time consuming and hard on the hand!!!
This post is a suggestion for Microsoft, and Microsoft res...Selecting text for editing
I inadvertently enabled a command that prevents me from going into a text box
and placing the cursor in a specific location so I can insert or delete text.
When I place the cursor in a text box a portion of the text is
selected/highlighted; if I click somewhere else in the text box another
portion is selected/highlighted. What did I do and how do I fix it?
Is the publication a template? If you create a text box manually do you still
have this problem?
"Camborita" <Camborita@discussions.microsoft.com> wrote in message
news:14A78B...Unable to delete rows/columns
Worksheets open with over 60,000 rows and many columns. Selecting cells and
using the delete command does not work. Assume there is there is no links
from worksheets to any other document because "Links" command is not
what does 'does not work' mean. Do you get an error?
"charles Callahan" <email@example.com> schrieb im Newsbeitrag
> Worksheets open with over 60,000 rows and many columns. Selecting
>...Select Previously Selected worksheet (and/or select previously selected workbook)
Is anyone aware of VBA code that would allow me to auto-select the
previously active worksheet (within a particular workbook....or within
another open workbook)?
In essence, I am trying to build a routine that will allow me to
automatically do a vlookup between two data lists in two sheets with a
single step, rather than go through the process of specifying the
Thanks for any suggestions.
...Wrong case selected
An engineer receives an e-mail from a customer and decides to open a
So far so good.
He then goes back to the e-mail (yes CRM is missing a create case
from e-mail button!) to link it to the case he had just raised.
Unfortunately he clicks on the wrong one.
He therefore tries to re-select the right one but this is not
It seems once the case is selected it becomes read only.
Does anyone know how to get around this problem?
You can create a new case from CRM toolbar within Outlook, and as far
as I know there is no way to remove a regarding field once it ha...Add/Delete/Change Comments in a Range
I have a report to do, with the following fields:
A B C
1 Group Channel Sales
2 He Hypermarket 300
3 He Multishop 700
4 CA Export 150
Until now everything is ok but I need to give support for this data in
this report. So I need to insert comments in the sales range in order
to inform the customers in each channel.
For this I have another support report:
C D E
1 Group Chan...delete objects declared in a DLL
This is my problem:
-I've a WIN32 Application.
-My Application allocates(using the operator "new") objects of classes
declared in a DLL.
-When I try to delete these objects the compiler returns an error of this
type"debug assertion failed....file dbgheap.c"
Does someone know where is the problem?
Thanks to all can help me.
It does not matter whether objects are declared in a DLL or in a EXE. You
will have the same issue if the object you created was declared/created in
an EXE. Show the code where you create/declare the object/class.
Ajay Kalra [VC++ MVP]
aj...Selection Change problem with CTreeView
I have a class named CNetTreeView, which is derived from CTreeView. The
message map contains the following entry:
which calls OnSelchanged whenever the tree selection changed. However, a
call to GetTreeCtrl() within my OnSelchanged() will fail, and I found that
this happens because while OnSelchanged() is executing, the value of my
CNetTreeView object's m_hWnd is NULL. By setting breakpoints I was able to
verify that immediately before OnSelchanged() begins, and immediately after
it ends, m_hWnd is a valid handle to the tree...Deleting files not just crossing them out?
I there a way that when I delete an email that it is actually delete
out of my inbox and not just crossed out
g.garrette's Profile: http://www.officehelp.in/member.php?userid=491
View this thread: http://www.officehelp.in/showthread.php?t=124872
Posted from - http://www.officehelp.i
g.garrette <g.garrette.2glpie@NoSpamPleaze.com> wrote:
> I there a way that when I delete an email that it is actually deleted
> out of my inbox and not just crossed out?
You are obviously using an IMAP accou...exchg 2000 trans logs not deleting/backup errors
I have come across an Exchange 2000 server which is not deleting the
transaction logs, 35GB of them to this point. The priv.edb is 13GB and
priv.stm is another 11GB. In Exchange Sys Mgr on the server the option to
Remove Log Files is checked and set to 3 days. Additionally, their McAfee
antiviurs was set to scan the Exchange dir. structure. I changed the
antivirus settings to cxclude Exchange. Their backup is failing with the
errors listed below. Due to the fact, the backup is failing, I am wondering
if the archive flags on the transaction log are preventing their deletion. I
am ...Query SELECT in SELECT?
Hi I would appriciate if somebody can help me with the following query:
I would like to build a query which would return all my delivery lines +
lookup a valid FX rate from tbExchangeRates for a entered curreny
(dlCurrencyID) and date (dlDate)
erID, erCurrencyID, erValidFrom, erFXRate
1, 1, 01-JAN-2010, 31
2, 1, 01-FEB-2010, 32
3, 1, 01-MAR-2010, 33
4, 2, 01-MAR-2010, 50
Query should return: