Using Code instead of Criteria
In my query builder, I'm getting the message:
"The string returned by the builder is too long. The result will be
I think I understand why, as I am using a form to specify a large
number of options for the report.
Can I use VB to specify these criteria instead of the query builder?
Examples in query builder:
If [Forms]![boxSeatsMailings]![PW] Criteria =1 and (PFDirect>0 or
PFBulk>0 or PIDirect>0) then select record.
If [Forms]![boxSeatsMailings]![PW] Criteria =2 and (PFDirect>0 or
PFBulk>0 or PIDirect>0) then select record.
As ind...Confirm cannot be sent
Often, wheb I open a message in Outlook, I've a message box telling me that
somebody asked a confirmation when I've read the message. If I answer "YES",
the message goes in the outbox, with a little green picture (like a v or a
check in a box). The problem is that this message is never sent. Sometimes
I've an error while sending, sometimes the message in the taskbar on the
bottom of the outlook program say that it has sent everything (send mail
finished), and it's still there.
Where is the problem ?
Outlook 2000 SR-(220.127.116.1121), windows 98 SE
...Color Coding cell based on date (over a large range)
I have a "calendar" that I want cells color coded based on a date entered in
a reference cell. I've tried it a couple of ways using conditional
formatting (which I assume is the correct way to do it), but can't figure out
exactly how to accomplish it.
I.e., given the following type of spreadsheet entry...
A B C D E F G H I J K
2 1 2 3 4 5 6 7 8 9 ...
3 _ _ _ _ _ _ _ _ _
(C3 would be Jan 1, D3 would be Jan 2, etc)
If a reference cell has Jan 1 in it, then C3 would be highlighte...Getting rid of confirmation boxes
Is there a way to get rid of confirmation boxes popping up in Excel?
I use Excel 2000 on WinNT4 and I need to keep a spreadsheet open 24/7 doing
calculations. The problem is the sheet runs 50+ external database queries to
an sql server set to refresh every minute and occasionally a "Not enough
memory to complete query" error or similiar pops up with an "OK" button to
The entire spreadsheet stops running any queries while this "OK" button
waits for someone to click it! Its very annoying. Especially when I check it
after a week and its had a mes...The word "confirmation" causes a bug in e-mail
Our company has noticed that if one types the word "confirmation" in the
subject line then tabs to the message, Outlook will start to initiate a
series for "enter" commands (it appears) and then one has to end the Outlook
Task in order for it to cease.
Has this happened in other companies?
If it ain''''t broke...I''''m still working on it.
DonMark <DonMark@discussions.microsoft.com> wrote:
> Our company has noticed that if one types the word "confirmation" in
> the subject line then tabs to the message, Out...Confirmation Pop-up
I've created a macro that will erase everything in a pre-selected area.
What I would like to add to it is a Pop-up asking for confirmation
incase the button was pressed by accident.
Can this be done? How?
Message posted from http://www.ExcelForum.com/
try somethin like
answer = Msgbox (Continue?,VbOKCancel)
If answer = vbCancel then
'your code here
> I've created a macro that will erase everything in a pre-selected
> area. What I would like to add to it is a Pop-up asking for
> confir...Restored Emails only display html code
After a data loss the users .pst files were restored, and now any of the
restored emails open but show the complete html code for the email body.
Outlook 2003 will not pick this up and display it correctly using the Word
editor. All new emails received after the restore are displaying properly.
Opening, reading, forwarding the email just shows the complete text starting
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2...Diagnostic-Code: smtp; 4.4.1 Did not receive the expected protocol response.
We are able to send and receive emails to any domain except one domain. When
someone from this particular domain replys to one of our emails or trys to
send us an new email message their Exchange server returns the following
Reporting-MTA: dns; mail.movgal.com
Diagnostic-Code: smtp; 4.4.1 Did not receive the expected protocol response.
***The body of that message contains****
This is a delivery status notification, automatically generated by MTA
mail.movgal.com on Sun, 05 De...Extraneous formatting codes in Index
Strange problem. I'm indexing a 500 page book. There are a couple hundred
index entries. Maybe a half dozen of the entries come through in bold.
There is no visible reason for this. The original entries in the text do not
have a bold code anywhere near them. Suggestions?
Jim Speiser wrote:
> Strange problem. I'm indexing a 500 page book. There are a couple hundred
> index entries. Maybe a half dozen of the entries come through in bold.
> There is no visible reason for this. The original entries in the text do not
> have a bold ...Meeting Confirmations
I would like to be able to send a meeting confirmation by simply double
clicking on the calendar date box. All receipients are in the contacts
section but do not use the share function of Outlook. I need some type
of macro to do this, if it can be done.
...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...Safe Pay Confirmation Number
Is there anyway to remove the prompt for a confirmation number that
Safe Pay displays after you hit the Upload button? I want it to save
the last upload date and the results of the ME123504 table without
having to enter that number. Thanks,
...How to make a slide for a pricelist demo of the products
How I can make a demo slide for price list demonstration and to display in
a plasma TV screen. Please anybody have an idea le me know. I want to
display in repeated view of the pricelist . Please help
Your question is very broad. What exactly do you need to know how to do?
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx
"pol" <email@example.com...Cash Receipts Smartlist with blank Credit Card ID
I added the Credit Card ID and Credit Card Name to the Cash Receipts
Smartlist. For the credit card payment type the field is blank but if you
open the payment the Credit Card name is there. How do I get this on the
I tested this issue and found the same thing. Furthermore, some of the
payment transactions that display a credit card ID are actually not credit
card payments. To make matters even more interesting, I could not find a
Payment Method column.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com...Products on Quote Letter, Products on Sales Confirmation
I need the ability to create a quote letter that shows the line item products
that are being quoted. Furthermore, I need to be able to create a sales
confirmation that confirms the line items being ordered. Near as I can tell,
CRM has no functionality around actually enabling quotes or sales orders.
Out of the box template mail merge documents would be really nice. Heck ..
even having some for download on Office Online would be an improvement.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggest...Dr. Watson Error Event ID 4097
I receive an excel has generated an error and will be
closing dialog box when opening a particular file. The
event viewer has a Dr. watson error with event ID 4097.
The message is "The application, , generated an
application error The error occurred on 10/28/2003 @
13:25:15.656 The exception generated was c0000005 at
address 308D03A5 (memmove)".
...Error code: 0x80244017
we have a win 2003 sp1 machine and we got this code
[Error number: 0x80244017]
when we try to update windows from windowsupdate.microsoft.com web site.
Any one of you could give me an help?
Obviously you will get that error code . Why is SP2 not installed ? Install SP2 and
solve the issue at hand
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not...Access Forms TextBox and Email Confirmation
I have an interesting question. Does anyone have an idea as to how we could
have a textbox on a form (that collects an e-mail address) that after the
email address has been entered, cause the user to have to re-type the email
address to confirm that it was entered correctly? But the catch is to
disallow the user from doing a cut-and-paste _ for that field only _? I
don't want to make the whole form disable cut and paste.
I'm OK with the obvious things (i.e. on the AfterUpdate event, save the
value into a variable, clear the field, then ask for confirmation). But I
Is it possible to inactivate Item codes so they don't get used by staff?
Do you mean Item Numbers Merle? If so, you can make the Item Type =
Discontinued. This will prevent future purchases of the item but you
can still enter adjustments and still sell the item unless you uncheck
the 'Allow Sale or Discontinued Items' in SOP Setup.
MCP-GP, MCT, MVP
East Coast Dynamics
get your GPtip42today at www.gp2themax.blogspot.com
Thanks That was the information I was looking for.
"Frank Hamelly, MCP-GP, MCT, MVP&qu...VBA Code to select and format range
I want to select a range of cells and format the range of cells based on a
The last couple lines in my code are:
ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)"
Where the active cell reference is a moving target depending on the amount
of data in the worksheet. How do I now say - select this cell, plus other
cells in this range of cells and format them with a border, and a color? I
can't get the syntax right. I I record the macro, it only gives me this:
I have a problem with outlook. When they send a message to me that demands
the shipment of a reading confirmation, even if I accept, the reading
confirmation does not come received from the sender. Someone knows from what
depends and in which way I can resolve the problem?
Thanks for the eventual answers.
Niki <firstname.lastname@example.org> typed:
> Good day,
> I have a problem with outlook. When they send a message to me that
> demands the shipment of a reading confirmation, even if I accept, the
> read...Segment ID for sites
Could you plz explain in a plain way , why it is mandatory to specify the
Segment ID for sites in the Inventory control before creating a new site?
I just can not get it!
Depending upon how SOP is set up, you could use Inventory or Sales to drive
the accounts. If you're using Inventory, then the system can use the segment
assigned to each site to override the segment value for Sales, COGS, and
Regardless of your intentions, you still have to select something. You can
just select the main account segment if you're not going to use Inventory to
I'm having problem removing my mail server from the DSBL database.
How do I configure the server to automatically confirm a message?
This is the error I receive from http://dsbl.org/removal2:
DSBL: Send Removal Confirmation
Confirmation email refused. Please fix your server to accept removal request
mail. DO NOT email us asking us to email to another address or to help you
fix your server; we will not do either.
Connected to 18.104.22.168 but connection died. (#4.4.2)Can anyone help
me with this?
It seems that the SMTP server listening on 22.214.171.124 is not...Code: Paste Graph with no Edit-->links
Workbook 1, Sheet1 contains a graph (say over cells
A10 to h20 for example) along with source data beside it
(say in cells j10 to m15 as example). The following code
is in a button:
The problem is that since it is .paste the graph contains
links to the original workbook/sheet. But in fact i want
the graph & the data to exist here without links to the
original workbook/sheet. What is the code i should change
in the button ?
Note that i tried PasteSpecial with Paste:=xlvalues but
the graphs go for a toss.
Any hel...Code not working
I need to capture the Last Row number as soon as the WB opens; And as the
sheet2 Column A cells are filled-in have the variable Lrow furnish an
value, representing the last non-blank row in Col A of Sheet2. The below is
not working; Can yo suggest a better way?
Dim Lrow As Long
Private Sub Workbook_Open()
Lrow = Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Row
Press Alt + F11 to open the VB editor. In the Projects pane at the upper
left side of the screen, double click on ThisWorkbook and paste the code
into the code wind...