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...Problem with empty page
I have a webpage which if it has a querystring attached it'll display some
usefull information. But if no querystring is attached it displays this
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content="text/html; charset=windows-1252"
I've tryed to put some logic into the page so when no querystring is used it
should give some values to a Literal control on the page. That code executes
...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" <email@example.com> 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" <firstname.lastname@example.org> 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?
<email@example.com> wrote in message
> The following code causes ini sett...'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.&...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
<firstname.lastname@example.org> wrote in message
...Excel CSV leaving out empty columns from row 17 onwards
Excel omitting commas in random ways !!
Anyone come across this ?
When I save this file in csv using excel 2003
A,,C,D,,21-Nov-06,27-Nov-...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...How to retrieve thresholds from the database
I use KPI images to display based on some thresholds. Currently most
of the thresholds I am managing with hardcoded constants in the
expressions. I want to store the thresholds in a SQL database and I
want the expression to the KPI image to retrieve the threshold for the
KPI from the database can you please share ideas and code for the
expression to implement this.
...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...Reading empty query returns
When I open a form that has a bound query as the record source, no
data appears (including the control objects of the form) if the
query's select statement does not finds records that match the
criteria I specify. This causes a problem in my VBA code as the
variable I use to check the number of records returned by the query
does not seem to be able to read empty query returns, even if I use
isnull. So I guess I am asking how can I get Access to read an empty
result set in VBA from a SQL select statement that is run???
Here is part of my code for this:
DoCmd.OpenForm stDocName2, , ...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...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...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" <email@example.com> wrote in message
> I have probl...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...Outlook wont start, even as I had previously used it on the same l
Recently had a system crash occasioned by impatience with a Windows update.
After two weeks of tinkering, decided to reformat laptop back to factory
settings. Since HP restore will not work, had to reinstall most sofware
programs including Norton 360 and Office 2007Plus. Thereafter, most of my
files were recovered from the most recent Norton 360 backup. Problem now is
that all units of Office 2007 works perfectly except Outlook. It wont just
start. All suggestions to repair Office installation or Outlook failed.
Anyone with a similar problem and solution out there? Please help.
...How to find the check form to use for GP 9.0
I don't want to use Deluxe as our check vendor. I want to use Harland.
Microsoft MBS sales just gives us Deluxe's phone number, when we request
help with obtaining the correct format for Harland checks.
Harland has two check formats for GP payable checks.
1) Great Plains Accounting 7.0 - 9.0
2) Great Plains Dynamics
Harland isn't sure and can't reference Deluxe.
From what I can tell from Harland's website, you want the Laser
Multi-Purpose checks they show under Microsoft Great Plains. That's the one
with the check in the middle, stub on t...