ASP to Excel Image Alignment Problems
I'm exporting an ASP page to Excel using 'Response.ContentType =
"application/vnd.ms-excel"' and it is working fine for the most part
except the particular page I'm exporting has images, and no matter
what style/alignment/etc. that I provide to the <td> tag that contains
the <img> tag, it always left-aligns the image in the Excel cell.
Has anyone had any success with controlling the alignment of images
when exporting from ASP to Excel using
'Response.ContentType = "application/vnd.ms-excel"'? If so, would you
be willing to share...Can't find LDAP Directory Server for sending my mail
I am using my Outlook a lot. Have many contacts in my outlook system. When I
like to look them up as a list, I get "Cant find LAPD directory server (81).
My address book is not listing all the contacts that I have emailed to.
Hope that you can help.
agrin <firstname.lastname@example.org> wrote:
> I am using my Outlook a lot. Have many contacts in my outlook system.
> When I like to look them up as a list, I get "Cant find LAPD
> directory server (81). My address book is not listing all the
> contacts that I have emailed to. Hope that you can help.
...Lookup table / redundant data problem
Two questions in one:
http://allenbrowne.com/ser-58.html has an example on an improved
lookup table. I'd like to know how in the SQL query "[Enter Bracket]"
is implimented--is this in an Event Procedure, and how exactly (what
syntax) is this done? A more complete example would be appreciated
SELECT Rate FROM Bracket WHERE [Enter Bracket:] BETWEEN
BracketLow and BracketHigh
How can you spot whether redundant data has been entered into a
textbox (or a group of textboxes)? One solution that occurred to me
would be to store each value of a textbox or gro...Problem delivering mail from iis smtp server.
I'm not sure if this is the right group to post this, but I will give
it a shot.
I have a Virtual SMTP server under iis. The default domain I will use
I setup an email client to test the delivery and configuration. I can
connect and send email to remote domains (email@example.com). When I try
and send an email to firstname.lastname@example.org the message seems to be
delivered without error. My assumption is that it actually gets to our
exchange server as this is what I see in the log file.
xxx.xxx.xxx.xxx = the ip of the sending machine (internal network)
yyy.yyy.yyy.yyy = t...how can I find and download a WAB DLL file for Outlook 2000
When trying to use outlook I get a error message "cannot find WAB DLL" I may
have accidently removed it.
What OS are you using? Curious since OL2000 isn't Vista compatible.
"JEJE" <JEJE@discussions.microsoft.com> wrote in message
> When trying to use outlook I get a error message "cannot find WAB DLL" I
> have accidently removed it.
if you are using vista, see http://www.outlook-tips.net/howto/vista_wab.htm
otherwise, we need to know the version of windows.
We have a customer that is interested in Great Plains Payroll, however they
are also looking for the solution to handle payroll tax updates for local
taxes. They are currently in many states with lots of localities. Is anyone
aware of any products that track local taxes that either integrate with Great
Plains or could be customized to integrate?
Informed Systems, Inc.
I am not a payroll person so I very well could be wrong, but I *thought* that
the tax updates that Microsoft released included local tax updates. Does it
"Rick DeLello&...how do I copy several lines of word text into one excel cell?
In a word doc I need to copy several lines of text and paste them into one
excel cell. I can't seem to find any help telling me how to do this (each
line pastes into a different cell)
You can either double click the cell or press F2 key to get into edit mode
for the cell, then the text pasted would all go into the cell.
> In a word doc I need to copy several lines of text and paste them into one
> excel cell. I can't seem to find any help telling me how to do this (each
> line pastes into a different cell)
thank you SO much Simon CC - ...Before update event Access Message?
Hi new to access but keen. I have a cmd button on a form that is initiating a
forced save Me.dirty = False. I think this is firing the before Update event
that I am validating data entry with. Code
If DateDiff("n", StartTime, FinishTime) <= 0 Then
Cancel = True
MsgBox "You cannot end the task before you start!", vbOKOnly, "Review
your start and finish times!"
This seems to be working as the message box appears but then another
meassage from Access apears saying "The setting you entered is invalid...Using Form to update table
I am a little lost.
I have a form which has a subform.
In the header of the form there is a combo box to selete numbers and a text
box to enter a date (not current date)
On the subform I have 2 text boxes which onces the 2nd textbox is populated
another set is to come underneath ready for completion (continues form).
On the main forms footer I have an update button which is to perform a task.
What I am lost with is how can I get the subform to work as a continues form
so once the 2nd text box is completed another set is ready for entering.
How do I then click on the button to fi...adding Associated External Account en masse?
I have 2 seperate Active Directory domains/forests (A (2003), and B (2000)).
The A domain has an Exchange 2003 server in it.
The B domain has 400 user accounts in it and no email server.
I have created a 1-way outgoing Trust going from domain A(trusting)
to domain B(trusted).
I also created user accounts in domain A that mirror all of the
accounts in domain B.
I can successfully add a user account from B to a mailbox in A and assign
the external associated account permission to it.
Does anyone know of a script out there that could automate this process for
We wrote a similar script fo...Install these internet update from the M$ Corporation
Content-Type: multipart/related; boundary="zfmdubnjqot";
Content-Type: multipart/alternative; boundary="raskbxjjzmn"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to protect your c...problem with csv
When I have my regional settings at Canada (French) and I open a CSV file it
See the commas as column separators
So when you open your document it is all in one cell
But if I set myself to English (Canada) it opens like it should at each
comma it’s a new column
Does any know how to fix this please help?
Presumably you want to have the settings at Canada (French)? If you
can't find a way to change the default list separator, then you could
always use Data | Text-to-columns with comma as the separator and parse
your file into columns that way.
Hope this helps.
...Searching (Find) in Merged Cells
How can you search in merged cells for text content? The
Find Method works on single cells but I can't get it to
work on merged cells.
Excel treats merged cells as if they were the cell at the upper left of the
merged area. In VBA:
Dim myCell As Range
Set myCell = Cells.Find("find this", , xlValues, xlPart)
If Not myCell Is Nothing Then
MsgBox "Found in " & myCell.Address
MsgBox "Not Found"
In Excel, simply select all the cells using the select all button to the
upper left of A1, then use Ctrl F.
B...Combining two fields into one in a query for a report
The database I am working on is to keep track of parts that are either in
their storage area (on a shelf) or on an assembly line. I have two fields,
one called Shelf and every part has a shelf assigned to it. The other field
is Line and if a part in on an assembly line, there is a number indicating
that line, if the part is on it's shelf, the word STOCK appears in the line
field. (Has to be this way for the rest of the database to work, so this is
not up for question) Now, I need to creat a report to show where all parts
are. If they are on a line the result needs to show the l...Data Entry Form and Subform problems
I have a form and subform that I am trying to use for data entry. However,
it's not working out as planned.
I have two tables:
[AccountID] (Combined PK)
[AddressID] (Combined PK)
.... more fields
tblAccount holds Account records including the default address to be used in
all transactions, although an account can have more than one address.
tblAddress holds all the addresses for all accounts with a combined primary
key of AccountID and AddressID.
tblAccount.AccountID is an autonumber field.
tblDefaultAddre...A way to manually bulk update investment prices?
Is there a way to manually bulk update investment prices?
Money Plus cannot find an investment I want to track so I was manually
but this becomes tidious.
I was hoping for a way to edit the historial prices manaully as I could
write a script to do this.
Are all the historical prices stored in the .mbf file? Anyone ever
manually manipulated this? If so how?
John Seyerle wrote:
> Is there a way to manually bulk update investment prices?
> Money Plus cannot find an investment I want to track so I was manually
> but this becomes tidious.
> I was hoping for a way to edit t...after XP-SP2 problems with Outlook Web Access
After XP-SP2 Outlook Web Access reacts strange:
If I trie to answer to an email the answer windows (form)
hasn't any text field.
I already added the Web-Site to trusted sites - but
Resetted all the Internet Explorer options and Zone Settings, Cleared the
Temporary Internet Files, etc already? If so state your version of OWA and
ask in an Exchange newsgroup as OWA is part of Exchange not Outlook.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service...Problem with public folders #2
I move mailbox and public folder from an old server (Win2K/Exchnage 2K) to
new server (Win2K/Exchange 2K).
I follow the instructions on the KB 307917, for public folder replication.
Accindentally, I uninstal Exchange 2000 on the old server before to remove
public folders replicas on the new exchange server.
Outlook client can work on the public folders of new server, but I can not
work with public folder (to remove public folders replicas) with Exchange
System Manager (ESM).
I Want to use folder proprierties to remove replica from old server.
I can not see the public folder on the root publi...IMAP reply
I am using Outlook 2003 with IMAP. Whenever I send a reply to an email
that I have read (not bolded) Outlook changes that email to unread (and
makes it bold). I've searched the 'Net but have yet to find anyone else
describing this same problem. Any suggestions?
Thanks in advance!
...Updates at Shutdown
When I shutdown, I continue to receive a choice to install a
Windows Update or Shut down without the update. I choose
Install and the update is installed and the computer shuts down.
But every time now, I get this choice and keep installing the
update. This has been happening repeatedly for a couple of
weeks, it seems.
I cannot get the screen where I can simply shut down.
Thanks for any help
"rogeepete" <email@example.com> wrote in message
> When I shutdown, I continue to receiv...Update() quicker?
Is there a 'quickest' way of updating a table with a single record on a
Update() is currently taking from a fraction of a second to 2 seconds to
write the update to the table.
...recover deleted account in CRM 3.0
I have a user that deleted an entire account. What is the easiest way to
if you have deleted it as opposed to deactivated it - sorry to say - you
will need to reenter the account and its details. Once you delete an
account it will be flagged for deletion by the crm deletion service.
If you deactivated it - just re-activate it.
"Scott" <Scott@discussions.microsoft.com> wrote in message
>I have a user that deleted an entire account. What is the easiest way to
> recover it?
...Before update on form
Just cant work out the tbName must have the character "#" in tbName if
ckb2ndCompany is true!
Dim iAns As Integer
If Me![ckb2ndCompany] = -1 & [tbName]dosent contain the "#" Then
Cancel = True
iAns = MsgBox("Please enter the symbel # first!! " _
& "Click OK to Enter # or Cancel to quit", vbOKCancel)
If iAns = vbOK Then
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3
Open the t...Tabs not visible for one user
I have a worksheet with 12 tabs that is stored on a shared drive, this
is accessed by several users. One user is not able to see the tabs
across the bottom. She is at a different location than all other
users, so we can't physically see this on her PC. All other users can
see the tabs when accessing on the shared drive, and when opening an
emailed copy. We have had her maximize, etc. and still no tabs.
Any suggestions on what I can tell her. I might be missing something
simple. I have tried to recreate the problem on a local copy, but can
Have you checked the obvious...Combine multiple workbooks into one workbook
I would like to combine a number of workbooks inside a folder into one
workbook and maybe have the worksheet name be the name of the file or
something. The core issue is combining them. I have looked and I see how to
reverse it but not this exact thing, please help.