Identifying Dublicate names and addresses in Exel data base and r.
How does one Identify dublicate Names in an Exel Data base and remove them
>How does one Identify dublicate Names in an Exel Data
base and remove them
...External Data Import From Access
Happy New Year to all!
I'm trying to import data from an Access Database. The data source in Access
is a query which in itself is made up from several other queries, one of
which is a parameters query requesting 2 values: reporting to and from
dates. When I try to import the data I get "Too many parameters: Expected 2"
error. I'd really appreciate if someone could tell me a way round this
either in Access or Excel, or direct me to documentation that'll help.
Thanks in advance.
...How do I pinwheel pictures?
I want to put 4 pictures in a circle with one picture under another, kind of
in an over, under pattern. I can get three done but the last photo is always
either over two pictures or under. Is there a way to set a pattern for 4
Copy your final photo, paste, align the two photos, horizontal and vertically.
Crop the top photo to the center. This half you will make it appear correct.
Mary Sauer MSFT MVP
"Ilex52" <Ilex52@discussions.microsoft.com> wrote in message
news:FB986C3B...Get "My Pictures" directory
How can I get (programaticaly) "My Pictures" directory ?
You can use GetFolderPath with CSIDL_MYPICTURES as the CSIDL value.
You should use:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/shellcc/platform/shell/reference/functions/shgetspecialfolderlocation.aspWith folder type 0x0027.Tom"Yoavo" <firstname.lastname@example.org> wrote in messagenews:OOFaC8LWGHA.4620@TK2MSFTNGP04.phx.gbl...> Hi,> How can I get (programaticaly) "My Pictures" directory ?>> Yoav.>>>
static TCHA...import external data problem
I'm stumped. I have a file I update on a weekly basis by
adding a sheet and importing external data into the newly
created sheet. The source data is a .xls file. The data is
contiguous and the file is roughly 100kb. The target file,
holds 13 of the source files and also has a couple extra
sheets for summary info. The file size with all of this is
approx 2 Megs.
Now I'm trying to make a similar tool for a new
application. Each source file is 2.5 Megs (.xls) and the
destination file is roughly 30 Megs. The data in the
source file(s) is not contiguous. There is a partial row
an...Dumping a mailbox's contents?
I have a mailbox where all the non-deliverable e-mail goes that I haven't
logged onto in, roughly, forever.
Now, I need to free up some space for the information store so I was
planning on dumping its contents but my pop3 sessions are timing out and if
I log in via OWA, ie just sits there loading. There are about 300,000
messages in the mailbox. Is there a way of dumping the its content from,
let's say, ESM?
> I have a mailbox where all the non-deliverable e-mail goes that I haven't
> logged onto in, roughly, forever.
> Now, I ...Picture Form Help
Does anyone know how to change a picture within a form based on a cell
reference in number?
IE if cell a3=4, image1 will have a different image activated than if cell
a3 returms a 7.
Any Help is appreciated.
Me.Image1.picture = img.Picture
where img refers to some other image control containing your picture
associated with the index in a3
This of course assumes you have already assigned pictures to a number of
image controls. these could be on a sheet or hidden in the userform (or even
a different userform).
Alternatively of course you could load from f...Accessing/Changing Keywords externally via Office 2004 mdimporter
Operating System: Mac OS X 10.5 (Leopard)
Is there a way to access and/or change the Keywords metadata for Excel and Word (Office 2004) without opening the application? I had a programmer write a program that accesses and changes the keywords metadata (without opening the application) for Microsoft Office 2008 files, iWork files, RTF files, PDF files, and a couple of others. It works great (and it only adds 1 second to modified data - so essentially there's no change - the 1 second is so that Chronosync will see the change.)
Anyway, my programmer is now una...How can I identify a template?
I am seeking to make a proposal for a company newsletter that is using a
template. I am unable to find a similar -- not necessairily identical --
template in either Word or Publisher. Is there a way to identify the source
of a template
> I am seeking to make a proposal for a company newsletter that is using a
> template. I am unable to find a similar -- not necessairily identical --
> template in either Word or Publisher. Is there a way to identify the source
> of a template
Not really. It could be an older or newer version of Publisher, it could
be from Office O...Identify Cells
How can I place an identifier in a cell to identify members of each group,
so when the spreadsheet is printed, the reader can see what cells are
members of each group. For example, if A1 and B7 are members of group 1, I
would like to place the number 1 in the upper left corner of each cell, in
this case A1 and B7.
This would be similar to the upper right corner marking when a cell contains
AFAIK not possible. Suggest color-coding.
>How can I place an identifier in a cell to identify
m...OWA can't see external mail
Hi guys, I have installed an Exchange 2003 server and most everything seems
to be working fine. One user wants OWA to her Exchange account and I have
set that up. The user has access via OWA and can see her mail but she cannot
see new external mail as it comes in. Each Outlook client has the Exchange
service and the POP3/Internet mail service (mail.domain.org) setup. Outlook
is configured to pull the POP3 mail into the Exchange account. So when the
user is checking her mail via OWA and new Internet mail comes in, it's not
delivered to her Exchange box unless her computer back i...Picture protection
when we protect a sheet with a password, why a picture
that we insert in sheet is not protected.
Two possibilities occur to me:
1) When you protected the sheet, there was a check in the 'Edit objects'
checkbox in the Protect Sheet dialog.
2) The picture itself is unlocked. In XL2007, right-click on the picture >>
Size and properties >> Properties tab >> make sure Locked is checked. In
XL2003, right-click on the picture >> Format picture >> Protection tab >>
make sure Locked is checked.
Hope this helps,
"Sur...Do rules created in Outlook apply to external emails received?
We are posting a few jobs for our company. What I did was created 2 new
accounts and email addresses and gave permissions to the Director who now
can open their Inbox within her Outlook. I created a new rule for each
mailbox that states email "Sent only to me" to apply this rule "Have server
reply using a specific message". Basically the message is the auto response
email stating thank you and we have recieve your resume. I've tested from my
internal account and get the auto response with the message and our company
logo just like I set it up. However I do not ge...Identifying CD Drive
1. How can I Identify which all CD drives I have in the system.
2. How to know, if CD is inserted or removed from the CD drive.
You can identify the CD Drive by using the combination of following
DWORD nBufferLength, // size of buffer
LPTSTR lpBuffer // drive strings buffer
LPCTSTR lpRootPathName // root directory
please check these functions in MSDN.
"harvinder singh" <email@example.com> wrote in message
> 1. How can I Identify which all...Exchange 2007 OWA external url
One question in Exchange 2007 OWA configuration: How do you setup the
external url in order for your users to access the email server using
the internet? My company is set up with an intenal network (10.0.0.0)
and ISP that service internet access. The internal url for owa
(https://servername/owa) is working, but the external url is not. Port
25, 80, 443, 110 is open and map to the email server.
Any document out there that can direct me to configured the external
address scheme of OWA EXCH 2K7?
set-owavirtualdirectory "owa (default web site)" -externalurl...Need help getting specific records with SQL
I sure hope I can explain this clearly! :-)
I have two tables: Table 1 (tblJobs) and Table 2 (tblJobTickets). For each
job in tblJobs there could be one or more listings in the tblJobTickets. What
happens here is that when we get a new job it gets listed in the tblJobs.
Once the job goes into production we issue it one or more job tickets and
they get listed in the tblJobTickets. What I want to do is to pull all jobs
from tblJobs that fit certain criteria (all jobs that aren't completed or all
jobs entered in the last week, etc.) and display some of the info about that
job from tbl...Picture Behind Text
I am trying to place a photo overtop of a text box but it is covering up the
text. i want the text to show though the photo. how do i do this?
Rob K wrote:
> I am trying to place a photo overtop of a text box but it is covering
> up the text. i want the text to show though the photo. how do i do
Which version of Publisher?
Place the text box on top of the picture. If you see
an unwanted white background behind the text...
select the text box and type...Ctrl+T...to make it
MS Picture It! -
Digital ...Assign a signature by external or internal reciepents.
I would like to have one signature that includes my name, title, phone
number, legal ease, ad nauseam. And then I would like to have a second
signature that would just have my name.
I would like it automatically set based on if the email is being sent within
our company or if it is going to an outside email address. I’m not sure how
this would work?? Maybe based on the domain name.
We have so many back and forth emails that are internal it would be nice to
be able to read through the email without seeing all the signatures over and
Any help with this will be greatly ap...Identifying Date Overlaps
I am working on a spreadsheet that will be used to calculate starting
salaries for employees using defined criteria. The last problem to
completing this sheet is how to identify overlapping dates. The basic problem
is as follows:
In the spreadsheet, their are 10 fields for entering past employment dates
(each field has a start date and an end date). What I need to figure out, is
how to get the spreadsheet to automatically fill-in a chart that contains a
calendar of all the dates - that is, to place the start and end date in the
appropriate date field, and fill-in each date in-between....IHTMLDocument + Block Pictures
My aim is to block all pictures from IHTMLDocument. I get a
IHTMLDocument on OnDocumentComplete Event,When I have a IHTMLDocument,
I want to block or remove all images (img)from it and save the
document to a file,
Can anyone help me to achieve this functionality ?
Any help appreciated!
...how do I link tab name to content of a cellt?
I would like to be able to set up a template where the name of the tab is the
contents of a specific cell (e.g.) if I enter 2007 in A1 I want the tab name
to become 2007 but if I change A1 to be 2010 the tab name should change too.
You are better off doing it the other way around, which won't require a
macro. Is that possible?
"MadMurr" <MadMurr@discussions.microsoft.com> wrote in message
We migrated our Exchange server from 5.5 to Exchange 2003.
We are now running in Mixed Mode. I am attempting to
configure OWA but while configuring the certificate from
an External Authority (see kb 823024), the option to
display Administrative Groups from ESM is greyed out. Is
this because we are still running in Mixed Mode? If so,
will we have to move to Native Mode before the OWA server
can be configured?
Yes, mixed mode may be the reason those options are greyed out, but that
shouldn't stop you from adding the certificate. You can still drill down to
Servers | Your Server |...data validation of range, email specific row
Hi I'm trying to validate the data in cells C5:D5
if boths cells are yes, I would like it to send the row with both yes
values and then set E5 to yes
c d e
tested? success? emailed?
I don't know how to validate a range, I only figured out how to do one
If Range("C5").Value = "Yes" Then
How do I tell it to send the email after
How do get it to send just the heading row and the row with c5:d5
value = yes as a html table?
How do I set...Remove specific word from cell
How can I pull "Black" from this description? I have 300 items and
colors needed to be removed. Thank you fro the help.
<firstname.lastname@example.org> wrote in message
> Sculpture,Zeus,Black,Ceramic 18x10x34"h
> How can I pull "Black" from this description? I have 300 items and
> colors needed to be removed. Thank you fro t...Identify last item in a list
I have a list of timestamps in column A (one per minute for a day,
total 1440 entries), and an associated list of TRUE/FALSE values in
12:00 AM FALSE
12:01 AM FALSE
12:02 AM TRUE
11:56 PM TRUE
11:57 PM TRUE
11:58 PM FALSE
11:59 PM FALSE
I need a formula that will return the timestamp associated with the
*last* TRUE value in the list. In the example above, the formula
would return 11:57 PM.
If there are no TRUE values anywhere in the list, then the formula
should return some error text, i.e., "No TRUE values found."
The spreadsheet has...