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...Can I get menus in 2007
Is there any way to get a menu bar w/ word 2007?
I like 2007 but the choices in the tabs are not sufficient and I have to
fight to get the function I need.
Add what you want to the Quick Access Toolbar.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"John Coltrane" <email@example.com> wrote in message
> Is there any way to get a menu bar w/...Get $500 to your PAYPAL Account by just one CLICK)
i have hidden the form of getting $500 to your PAYPAL ACCOUNT....CLICK
on the IMAGE which is on the RIGHT SIDE of the website http://tricks-4u.4-all.org/
...Changing a text field to a date field
Hi I know this is a problem for lots of people but I still cant find an
answer. I have imported a text file into excel with a number field that
displays credit card expiry dates as a 4 digit number. example 0408 so month
+ year. I have converted the number field to a text field so it doesnt drop
off the first zero and now I need to convert it to a date field. Any nice
easy simple ideas. Any help would be much appreaciated. Or direction to a
question the same.
format as date
--------------------------------------------...my brain not comprehending the yes/no field
I have a db that enters orders. The "product" (insurance plan) has one price
but 20 different "attributes" in any combo of one choice to many (plan types
like medical, dental etc...) and with one "price" (premium). The plan types
must show up on one line in a report with one price (they are not deliminated
per plan type). The easiest way for personnel to enter all the plan types
would be yes/no check boxes on the input form. My problem is I can't figure
out how to make those "yes"es equal the plan name in the report!
I know, it's proba...why do i get #### in my formula cell?
I don't really know much about Excel, and my formula (it's just simple
arithmetic formulas) returns with ##### displayed on the cell, with a tooltip
showing the cell's correct value when I hover over it.
airn, make the column wider and see if that helps
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"airn" <firstname.lastname@example.org> wrote in message
news:C6F4DD7C-3D7D-475C-894D-0F7745735666@microso...How do I get focus back on an Excel file?
When automating Excel, if there is a picture (graphic) on the worksheet, when
the file is opened, the picture has the focus and mouse-clicks anywhere on
the Excel window are lost. Is there a way to get the focus back so that
other cells can be editted?
Insert this line of code into the macro:
You could also rework the code to avoid selecting the shape in the first
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"Stumpiana" <Stumpiana...Installed Exchange 2003 Server on new Hardwar... How to get rid of old Exchange 2000 Server?
Our single domain company (Win 2000 DC's) was running a single Exchange 2000
server. I bought a new server, installed Windows 2003 Server on it, joined
it to the domian (non-DC) and then installed Exchange 2003 Server on that
and joined it to the site. I then pointed our MX records towards the new
box. As soon as I verified connectivity, I began moving user's mailboxes
over 1 by 1. Everyone is now running smoothly on the new server. I have
not as of yet removed the old server (still on, running, no mialboxes).
The problem is, that as soon as I turn off the old Exchange 2000 s...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...Getting to grips with MOOL
I've bought, downloaded and installed MOOL, only to find it's not quite what
I thought (I know some others have been disappointed by the reality vs
representation), but more importantly that there's really no guidance on
using it. I'm quite surprised how difficult I'm finding it as I've never
struggled with any non-specialist applications before, but perhaps I'm just
ageing badly! Anyway, can anyone give me a simple guide to getting going?
What I would like: Basically I'd like something rather like Exchange. I
(now) understand that MOOL won't do ...get network login name
I have the following code to get the network login name:
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
Function fOSUserName() As String
' Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String
strUserName = String$(254, 0)
lngLen = 255
lngX = apiGetUserName(strUserName, lngLen)
If lngX <> 0 Then
fOSUserName = Left$(strUserName, lngLen - 1)
fOSUserName = vbNullString
E...Can't get newsgroup messages posted by self
I have a weird issue with Windows Live Mail concerting synchronizing messages
from newsgroups. If I post a message to the Microsoft private newsgroups
(privatenews.microsoft.com), I don't see the post but I can see new posts by
other users. If I use Outlook Express on Windows XP, I see my posts. I don't
have problems with WLM synchronizing my hotmail e-mail.
Any idea how I can troubleshoot this issue?
"Teo Lachev" <TeoLachev@discussions.microsoft.com> wrote in message
> I have a weird issu...Help, how do I get an exe file with outlook 2002.
is there a way to turn off the GD stupid F#@$ing level
one interecept "feature" in outlook?
I am so angry with this stupid program@!
I need to download an exe file and cannot with this
Maybe if you washed your mouth out with soap, someone would be willing to
help you. This is a technical forum -- not a place for ranting fools.
"Sean" <email@example.com> wrote in message
> is there a way to turn off the GD stupid F#@$ing level
> one interecept "feature" in outlook?
> I am so angr...attachment getting stripped off
I have Outlook 2000 and every time I origionate an email
from my home computer with an attachment it gets stripped
off before it gets to the addressee. I can foward emails
with attachments and they stick. Any tips
are you using RTF format? if so, switch to plain text and see if it helps.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, Visual Quick Start Guide - OneNote 2003
Outlook Tips: http://www.outlook-tips.net/
http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/expertzone
Search for answe...How do I insert a radio button into a spreadsheet?
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=37768
This should help you.
...How to Clear the AutoDetect Cache for the To: field
When sending a message in Outlook, one begins to type the destination
address in the To: field. Generally speaking if one has sent email to this
address in the past then Outlook will auto detect and provide a suggested
list of reciepients (know what I'm talking about???). Anyway, I know this
feature can be disabled so one is never provided with a list of possible
receipients but does anyone know how to clear this cache????
Remove individual addresses from the autocompletion cache by highlighting
the entry when presented in the suggested names list (use your arrow key ...How to force the user to fill in values for yes/no fields ?
I'm using MS Access 2003.
I have a table with a number of yes/no fields.
When a new record is started,
I want the user
to explicitly specify a value for each of these fields,
e.g. by choosing one of two radio buttons associated with the field.
Now, it was no problem for me to arrange an option group with two suitable
radio buttons for each of these fields.
The user can then choose explicitly between yes and no.
However, all fields seem to have implicit values immediately after a new
record has been started.
Therefore, the new record can be stored in the db without the user making...Trying to get a type of video file format to open and run on my we
I created a video using Windows Movie maker and saved as .wmp file. I saved
it to my computer and then inserted on my web page under Front Page 2003.
Nothing! I then converted the file to avi format - still nothing! I then
tried mpeg4 still nothing. The manual is next to useless on this subject.
Anyone tell me what I need to do so that when a user opens up the page the
video plays automatically.
Save as a .wmv and insert a suitable player into the page.
For IE only,
Insert->Web Component->Advanced Controls->ActiveX Control
Choose Window...Outlook2003 inserting a Hyperlink
Why can't I insert a hyperlink in a message to a file
using Outlook 2003, composing in HTML, or Rich Text
format, using Word 2003 as the editor? When I select
Insert (from toolbar) Hyperlink is grayed out. Is there a
setting someplace to allow this?
...Dynamically inserting popup menu into MDI app when there's a CView
I have an MFC MDI app. It has the standard IDR_MAINFRAME main menu,
and one type of CView defined with its own IDR_AITYPE menu.
Now I have to detect whether a custom DLL is loaded, and if so an
extra popup menu is added to the main menu, defined & controlled from
I can modify the IDR_MAINFRAME menu from the mainframe's OnCreate
handler. I call the DLL, which loads the custom menu resource & does
an InsertMenu into the window's menu. This works well.
But I can't figure out how (or where) to insert the popup menu into
the main menu when a CView is active & re...Getting cells to automatically delete spaces
I have got a very large spreadsheet where the information is presente
Notice the two spaces after the forward slash. There's about 10'00
cells in the column with varying numbers but all in the above format.
I need to get the two spaces deled so that it will appear as:
Is there a way i can get excel to proccess this for me.
Any help will be much appreciated.
Thanks in advance.
Message posted from http://www.ExcelForum.com
Select the required area or a whole sheet, and do a simple Replace (Edit
menu), asking Excel to replace s...Why am I still getting SPAM?
I am getting unsolicited pop up advertisements when I start Money 2003
Standard Ed. Somehow the "turn off sponsorship & shopping..." box keeps
getting unchecked! HOW? WHY?
I PAID for this software. I wouldn't mind so much if it was free, but
advertisements MUST come with free content of some sort. This is enough
to make me change to another software package. '
Based on a finding reported in another thread, you might try turning off
Money Express, then exiting/restarting Money, then changing this setting,
then exiting/restarting Money, then turning MoneyExpre...Help with SQL- SupplierList cost into Item cost field
Hi, re-posted! See below.
Hi, thanks for that- it worked perfectly. There is just one snag however and
I didn't think of it until I was testing. Many of the suppliers use specific
currencies so the information I need copied from the Supplier tab is actually
the Local Cost. When I view the SupplierList table, Local Cost doesn't
appear as a column. Is it just a calculation based on exchange rates for
information or does it actually exist somewhere within the database? Your
help once again would be much appreciated.
> Hi Tara - backup your...my formats get pushed out when I insert columns
I am having trouble when inserting columns in a large data field.
Whenever I insert a column at some point in the data field, th
formulas within the data field adjust, or 'stretch', to accomodate th
added column, however my conditional formatting gets pushed along t
the right and doesn't adapt itself in the same way the formulas do.
This means whenever I insert a column, the formulas remain correct bu
I have to reset the conditional formatting for the entire data field.
I would be extremely grateful for any advice on this situation.
Message pos...ONDIRTY MOVE TO NEXT FIELD
I have a combo box, when I hit Y (yes) I would like to save a keystroke and
have the cursor move to the next field. How would I do that? I tried
ONDIRTY but it gave me an error and couldn't move.
Thanks in advance,
Try the AfterUpdate event of the combo box.
<MS ACCESS MVP>
"Bonnie" <Bonnie@discussions.microsoft.com> wrote in message
> I have a combo box, when I hit Y (yes) I would like to save a keystroke
> have the cursor move to the...