How do I increase query field length (>20 characters) ?
I want to exclude 3 or 4 variables from a particular query. Using Not
"xx"or"yy" is fine, but when excluding more than this, query fails. I think
the problem is that the total text characters is quite large (approx 60
characters in total, from four exclusions). Ideas, please ?
60 characters is not the limit. 1024 characters is the limit.
POST the SQL of the query that is not working (View: SQL on the menu) or at
a minimum post what you are attempting as the criteria.
Also "query fails" does not tell us if you get an error (what is it) or the
wrong resul...How to make autostart programs in USB stick memory
Some said, when USB memory stick putting on PC, it can start autostart
programs, like Autorun.inf of CD-R. Does any know how to do it?
> Some said, when USB memory stick putting on PC, it can start
> autostart programs, like Autorun.inf of CD-R. Does any know
> how to do it?
Most systems these days have autorun disabled. ;-)
(for good reason.)
How To Ask Questions The Smart Way
> Some ...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!!
...Calculate the % increase for two columns
I have a pivot table, the data was first display by date, i know i can use
the grouping function to group data into monthly basis. But I want to know
that can I set the formula to calculate the months difference between, say
the sales amount of June & July, and the % of the difference??
If you have a grouped field, you won't be able to add a calculated item
to the pivot table. In the source data, you could add a column to
calculate the month for each record.
Refresh the pivot table, and add the new field
Add another copy of the Data field to the data area
Right-c...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....stm increase 500MB/Day
I have five Exchange Servers 2003, one of this servers is a
bridgehead server to internet messages. This server is a dual PIII 1GB with
2GB RAM and 36GB DISK. It work fine but the .stm file of this server
increase 500MB per day. The flow of messages is about 11000 per day.
I tried to change "Deletion Settings" in file group properties to 0
for all, but this not have relation with the problem and every month I need
to create a new file group and delete the old to free disk space.
Anyone knows any solution?
...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
Not sure if this is the proper arena for this post, but.... Have a usage /
functional question regarding Outlook, suspect this is a common problem with
Here is the scenario:
1. Send an email to someone, do NOT copy the email to myself so it just goes
in my sent mail.
Here are two problems that arise out of this function:
1. If I am awaiting for a response / need a response to that email what is
the BEST way to re-tickle myself if in fact a response to that email is not
At this time I remember manually in some form a flag, task or just plain old
2. Once ...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...not enough memory or disk space to display or print the picture after 1st time
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I know this topic has been covered before, but not in the way I get the problem. I can open a document with a math formula or a graphic the FIRST time and it will correctly display. Any changes to the document or any subsequent openings I then get the error message, "not enough memory or disk space to display or print the picture". <br><br>eMac 1.25 Gz 10.4.6, Word 2004 <br><br>Thanks.
One possible cause: You're *way* behind on Tiger -- it's been at 10.4.11 for
...'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
<firstname.lastname@example.org> 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...HELP! CFtpConnection GetFile cause memory leaking, WHY?
I'm trying to use CFtpConnection GetFile to download files from a
WS_FTP server. I found if I download 1000 files (Size from 17KB to
25KB ), it can cause about 10M memory leaking. When I commented out
the GetFile( ) line, there was no memorry leaking. WHY?
Following is part of my source code:
// Request a connection to Image
//Use default FTP Port
//Use Passive MODE
sess.GetFtpConnection(strISIP,strFtpUser,...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...how to increase text size in reading pane
dennist685 <email@example.com> wrote:
Depoends on your Outlook version, which you decided wasn't important enough
"Brian Tillman" wrote:
> dennist685 <firstname.lastname@example.org> wrote:
> > dennist685
> Depoends on your Outlook version, which you decided wasn't important enough
> to mention.
> Brian Tillman
dennist685 <email@example.com> wrote:
I don't have OL 2007, but in OL 2003, the Readi...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...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...