How to use a DLL!?
Hi all, according with your experince:
1. I'm exporting class functions from DLL instead of global function, is
there something i've to check!?
2. I need to run a DLL func in a separate thread, at moment the app create
the thread and exec this func. I actually prefer the DLL to start the thread,
any problems doing so!?
Thanks you all!!
...No results using DateDiff
I am working with DateDiff . I get no error messages but also do not get any
results in my calculated field. I have two dates, START_DATE and END_DATE and
I need to know the number of days between them. START_DATE and END_DATE are
both Date/Time type with a Short Date format.
I am working in the QBE grid to write the query. I select an empty column
and put my DateDiff calculation on the line below Or: in the Criteria area. I
Both approaches ask for parameter values for Time and STOP_DATE. If I d...Transfer Files Using VBA
I'd like to transfer files from several drives on my pc to one cetnral
My routine now is the following
1) Copy the files from drives: A, B, and C; and then
2) Paste the filesto the D drive
3) Delete the files permanently from drives A, B, and C.
As you see this is a tedious routine, which I'd liket o avoid by using
VBA. Can someone start me off with some code on how to accomplish
this. Thanks so much in advance!
You could create a batch file (from the olden days) using XCOPY and desired
bel...How to use excel file created in version earlier than 4.0a in 4.0
Thanks to whomever answered my query but when I opened the email the screen
was blank. My laptop is sick. My question was and still is, how can I use my
Excel files created in a recent version on my laptop in my PC which is loaded
only with Excel 4.0a . Please and thanks.
You can't, the file format changes twice since version 4. You need a newer
Excel version, a compatible spreadsheet program, or simply a viewer if all
you want to do is view / print the file.
HTH. Best wishes Harald
"ajimmo" <firstname.lastname@example.org> skrev i m...Issue when using Outlook 2003 on Exchange 5.5 SP4
I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can anyone
guide me on how to handle this?
What issues have you seen?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"M P" <email@example.com> wrote in message
> I have seen issues on using Outlook 2003 on MS Exchange 5.5 SP4. Can
> anyone guide me on how to handle this?
> M P
It was pretty easy for me to find this in the Microsoft Knowledge Base:
http://support.microsoft...Use of subkeys in SetRegistryKey
The following code causes ini settings to be stored in
HKEY_CURRENT_USER\Software\Company\Product Group\<application name>
\<section name>\<value name>
This is what I want it to do, but there is nothing in the
documentation to say that this should work. Is this unsupported
behaviour that may not work in future windows versions or supported
but undocumented behaviour?
<firstname.lastname@example.org> wrote in message
> The following code causes ini sett...Excel --- Physical dimensions of a chart object
Is there a way to know the physical dimensions of a chart object on a
worksheet? I have data in several worksheets and I would like all my
charts to be of the same size (obviously this means that data with a
smaller range of values will be more spread out than data with a larger
range of values).
This is just an example:
n = ActiveSheet.Shapes("Chart 1").Width
m = ActiveSheet.Shapes("Chart 1").Height
MsgBox (n & " BY " & m...'Recently used file' list.
When I open Excel nine filenames appear on the RHS as 'recently
used files' (this number was set via Tools/Options/General, of
course). In the middle of this list are 3 no-longer-used files.
Though the files themselves have been deleted their names remain in
Is there an easy way to remove those entries from that list,
There is an entry in the help file "Display or hide recently used workbooks
on the File menu" which says uncheck the 'recently used files' checkbox, the
click OK. Then, basically, start again.
"DB.&...Using Outlook with a VPN
Yesterday i set up a VPN so as to allow our employees to
work from home, today one of the employees highlighted a
problem with it though. When connected through the vpn,
they are unable to access their Outlook
emailand insted have to disconnect and then access through
a normal dial-up. Any thoughts?
Try this. When you get the VPN login screen, choose
Properties. On the Options tab, check the box next to
Include Windows logon Domain. That helped me.
>Yesterday i set up a VPN so as to allow our employees
>work f...Frustrated Beyond Measure
I loved Money 2005, recommended it to friends and got 2 great years of use
out of it. Then, it forced me to upgrade to continue online services. I
didn't mind since it was only $40 and I got two good years out of it.
However, Money Plus Deluxe has been a nuisance. I have never gotten
portfolio manager to work. I spent 2 weeks sending emails with support where
the guy eventually said "if this doesn't work, I can't help you." Great...
shoudl I go buy Quicken?
This weekend, I decided to try to completely uninstall Money and try a
reinstall to get Portfolio Manag...Exchange no longer available
Courtesy of Katrina, my brother-in-law's job and Exchange server are no
more. He knows he has personal folders and contacts on his laptop,
but Outlook choles on not connecting to Exchange and won't let him see
the local stuff either.
How does one tell Outlook not to try to connect to Exchange and instead
use the local pst file?
It might be easier to create a new profile and then use File Open to access
the personal folder file, you create a new profile in Control Panel || Mail
<email@example.com> wrote in message
...Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo)
I've joined the legions who've encountered this problem with the
OutputTo method in Access:
Run-time error 2306
There are too many rows to output, based on the limitation
specified by the output format or by Microsoft Access
A lot of people seem to have encountered it. The reason is because
OutputTo defaults to an old version of Excel which only allows 16K
A lot of people also suggest using TransferSpreadsheet instead, but
that caused me a lot more problems (putting a single quote in front of
my text data)
Intellisense for the command does not list what your options are for
th...having problems using performanceCouter
i've made a program that shows the CPU idle time using the performance
counter, using Visual C# .
however, from some reason, it works on any computer other than my home PC .
i've searched on the net but couldn't find what causes it.
what i get is an exception that if is not caught, closes the program. here's
a picture of what i get while debugging:
what i think is that maybe some service of windows (that the performance
counter needs) doesn't work well(or is just disabled) .
my computer runs on Windo...different versions in visio ole-object?
i have some problems printing a word document which includes some visio
In word i can see the visio object like i edited it but when printing
the word-document, a completly old version of the visio object is
printed out. The printed object is older that 2 weeks.
I tryed printing the document from other PC without changes.
I tryed copying the ole-object into an other word dokument (copy/paste)
Printing the document from wordpad works great ....
I also opened the visio object (doublecklick in word) and edited the
object, saved the file and exited back to wo...Using Jet to read excel file returns blank for last cell
With VB6 I am opening an Excel file to query the contents using ADO. I am
then using the contents of the worksheet to create a format file that is used
for a bulk insert into SQL Server. We designed the program this way so that
users can use a spreadsheet to import data in any format they want and
process the data based on values set in the spreadsheet. This keeps us from
having to design new tables and format files for new record layouts which
come down pretty often. Everything works fine usually. There is just one
perculiarity that is happening with the Excel file. Sometimes, th...Identifying LOCKED cells
Is there a way to identify locked cells, other than going through the processof
looking at each cell's format? Here's by quandry. I am working a worksheet
which has both locked and unlocked cells. Unfortunately some of the locked
cells should be unlocked so that data can be input.
Thanks for your help
To reply to this message, remove "mand" from my address. Thanks
I've dragged the lock button onto a toolbar. When I click on a cell, I can
glance at that and see if it's depressed (not suicidal!) or not.
Tools|Customize|Commands Tab|Format category.
Look for "Lo...using screen...
I have problem with the query in the cascade combobox when the form name
Is there a way to replace the following using screen.activeform
[Forms]![frmCoFundReview]![Partner] => screen.activeform.[Partner] ?
Not that I know.
You could use a separate query for each form.
Each query would have the correct form name for the combo box.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"SF" <firstname.lastname@example.org> wrote in message
> I have probl...e-mail is locked or down for maintenance, what to do?
I received an error message: Microsoft Office Outlook is locked or down for
maintenance. unable to access mail for two days. How do I unlock or what is
to be done
Is this a work account? If yes, then ask your mail admin.
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 furious head scratching, La Condesa asked:
| I received an error message: Microsoft Office Outlook is locked or
| down for maintenance. unable to ...Sending page by e-mail locks up computer
IE 6, Outlook 2000, Windows 2000 Professional.
Each time I send a web page by e-mail to someone using Outlook, the e-mail
goes through fine to my recipients, but my computer locks up. Eventually, I
manage to close everything down via the task manager (and that too takes a
while to get to), and then I have to reboot to regain access to Outlook.
This, too, first has to be done in the safe mode so that the open mailbox can
be closed up, and then I can get back to my normal operations by logging out
and loggin back in.
Can someone please help witth what settings I should look at either...HELP! Microsoft.Crm.Platform.Proxy is not intended for direct use, please use the public SDK.
Can someone post the following DLL's from CRM 1.2? They should be
installation CD. If you want to e-mail send to robert[at]
Details... I'm attempting the following solution:
Moving External Data into Microsoft CRM: Lead Generation
What I need is either:
1. a working compiled LeadGenerator.exe executable; o...In Word how to use Outlook, Excel
I am using Word 2007. How can I access Outlook contacts or Excel documents
Thank you in advance for your support and suggestions
To access Outlook contacts, Outlook must be your default e-mail application
in Windows. You can then use Insert Address (which you can add to the QAT
(Quick Access Toolbar) .
What is it that you want to access from Excel? If you need to look something
up in Excel and enter it into a document, you will need a macro. You can
however use edit paste special to insert Excel cells copied to the
<>>< ><<...Cannot use default SMTP Virtual Server
I this problem since yesterday Actually I post this
already and get some reply but that doesnt solve it.
Again my problem is:
I have newly setuo exhcange 2003 (SBS 2003) everythng
works fine until I test for open relay (using telnet om
port 25) and found that it was indeed open. So I check KB
and follow intruction to allo only this IP block to relay
mail 192.168.0.0 255.255.255.0 but when I try to telnet
again the server on port 25 I cannot connecto it anymore.
I restarted the service even the server itself but still
I cannot connect to it.
NOTE: I can connect with port...OWA using a new Web Site
I have recently Installed SBS 2000, by default OWA is operational from the default web site. I have created several new sites in IIS and created the necessary virtual directories to gain access to the exchange mail server. However when I try to go in via a web browser I get the folder/file listing view in IE rather than the templates. All of the settings between the default virtual folders and the domain I wish to use are the same and I am stumped. I can still access the template from the server by going to the address http://localhost/Exchange at the server
Any assistance would be apprec...How to use InputBox for passphrase entry?
Ostensibly, I would like to use InputBox (or the equivalent) to enter a
passphrase for an encryption algorithm. The problem: the passphrase is
normally in the clear when typing in the InputBox field.
Is there some way to cause the system to echo "*" or the equivalent for each
character as they are typed?
On Feb 8, 2:22=A0pm, "Joe User" <joeu2004> wrote:
> Ostensibly, I would like to use InputBox (or the equivalent) to enter a
> passphrase for an encryption algorithm. =A0The problem: =A0the passphrase=
> normally in the clear when typin...Can I use solver functions in a protected (locked) worksheet?
I am using the solver function to optimize a blend of products. I want to
lock (protect) some areas of the worksheet, but when doing so the solver
function will not work and the following translated message arrives:
The active document is not a worksheet, is protected or shared.
Hope someone can help me.