Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...How can I know which SP has been put on the exchange2K
Where can I see this msg?
Open exchange manager, organization, right pane.
"Geoffrey" <email@example.com> wrote in message
> Where can I see this msg?
check for the answer on the 10th(9th from ur posting)thread on this
site,that is named"finding on version of sp installed"
I don't know if you guys have ever try to show the total tax sale on the z
report, but when i make the modified on the z report it came out that the
total tax is 0. It didn't show me anything, i don't know if the script is
wrong or the script is not working for RMS V1.3?? Has anyone ever tried
<ROW> "Taxable Sales|" Report.SalesPlusTax </ROW>
...The Links from e-mails don't work
If I copy the links and insert it into IE 8 it reads it. Trying to link over
from an e-mail directly is not working. If I copy the link and go to IE 8.0
the link (URL address) works. It was working before.
You mean if you click on the link in a message it does nothing, not even an error message?
Are you certain IE has all its defaults?
Open the Default Programs applet, which you can access either from
the Start menu or via the Control Panel, then click the first item:
"Set your default programs."
After a few seconds, a list of programs comes up. Click on...crosstab qry as report source breaks Access2007
We have 3 reports whose record sources are crosstab queries. All have work
fine on the pc's running Access2003. But, the one pc running Access2007
doesn't like the crosstab queries as the report source. We don't get an
error - only the dreaded 'Access has encountered a problem and has closed...'
It totally shuts down the access application. I stepped through the little
bit of onOpen code while opening the reports and all works fine. I open the
crosstab query and it opens just fine. To test the theory that it is a
crosstab source problem, I tried to recreate one of the...How can I print just the flip side of a booklet?
How can I print just the flip side of a booklet? I printed the first side
just fine and then my computer went funny and I had to shut down and start
back up again. I have 25 copies of the first side that need to be printed on
the back side.
Pub 2000 user here:
There may be a better way but I think you will have to print a page at a
time i.e., File, Print Page 2 of 2; then 3 of 3 and so on.
"pqc18" <firstname.lastname@example.org> wrote in message
> How can I print just the flip side ...Report CRM 3.0
I would need to find out the detailed procedure (step by step) to customize
Could anybody inform about any links or documents concerning this issue?
I'm not sure if it's detailed enough, but the technical training manual has
a section on creating and customizing reports. You can find it here:
Jeffry van de Vuurst
"Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message
news:CEF80683-EC26-456C-82C...seperate accounts to seperate folders?
Hi I just had a quick question...
I am currently using Outlook 2003, and I have 2 pop3 email accounts se
up in my outlook.....one of them is my personal company email and th
other is the general comapny email address (which i am responsible fo
checking). What i am trying to find out how to do is, is it possibl
to have the general company email messages go directly to a seperat
folder besides the inbox? I still want my personal company email t
come to the Inbox folder, but i want the general company email to go t
a folder called "SCS." Any help would be greatly appreciated! Thank...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...linking worksheets #3
I know ho to link cells to oher cells. But is there a convenient way to link
ranges or worksheets to others.
just link the first cell
and copy this formula for your range. The reference will adapt
j van c wrote:
> I know ho to link cells to oher cells. But is there a convenient way
> to link ranges or worksheets to others.
...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...How Can I Control When Messages are Downloaded from Server
I have the box "Check for messages every ___ minutes" unchecked
Yet seemingly randomly, messages get downloaded a couple of times a day
without my clicking "Sync." This is problematic due to the way I share the
Is there another setting I need to keep this spontaneous downloading from
"Gripper" <Gripper@discussions.microsoft.com> wrote in message
> I have the box "Check for messages every ___ minutes" unchecked
> (too...Catch all outgoing email on Exchange and send copy to specified account
I have been asked to find out if there is anyway to configure our mail
server to catch all outgoing email from certain email accounts on our
Exchange 2003 Enterprise server and forward a copy of this email to a
specified account, also on the Exchange server.
If anyone could point me in the right direction I'd be grateful.
On 25 Oct 2006 04:10:54 -0700, email@example.com wrote:
>I have been asked to find out if there is anyway to configure our mail
>server to catch all outgoing email from certain email accounts on our
>Exchange 2003 Enterpr..."x" button enables deletion.... can we put a focus trigger there?
on three forms, I put focus triggers on the "delete" button because I need
to validate some additional data before allowing the user to delete.
However, if the user clicks on the corner "x" button to close the form and
gets the dialogue box saying they have changes, do they want to "Save",
"Delete" or "Cancel", they can delete the record anyways. Is there any way
to put a focus trigger on the button of the dialogue box, or on the "x"
Thanks in advance.
I assume you are working with Dexterity.
To work with an add...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>...Setting up my work outlook account at home
I do not know how to set-up my outlook at home to check
and receive email at home.
This is really a question for your Mail Administrator.
This depends on what ISP is used for work or if you
use the Exchange Server. Then there may be a domain
Nikki Peterson [MVP - Outlook]
"Liz" <firstname.lastname@example.org> wrote in message
I do not know how to set-up my outlook at home to check
and receive email at home.
...Link and Embed in 2003
Using the Insert>Picture>From File comand we can use either the 'insert' or
'link to file' command to insert a picture. During our development we prefer
to link pictures then when completed save the .ppt with all pictures embedded.
1. When pictures are in slides during design is it possible to tell if the
picture is linked or embedded?
2. Is there a way to embed any/all linked pictures when the slide
presentation is completed without going to each slide and reinserting the
picture as 'insert'
In article <07E6153F-5D...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...stock variance report
Is there any way to edit that stock variance report at HQ? There are no $$
values and this is quite important at HQ.
How do others work with this?
Create a custom report using the Quantity Discrepancy List as a template,
add the SnapShotCost, SnapShotLastCost and/or SnapShotReplacementCost column
from the ItemDynamic table times the qty difference.
"Ivan Brebner" <email@example.com> wrote in message
Is there any way to edit that stock variance report at HQ? There are no ...Can't upgrade companies to SP4
R [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or
number of supplied values does not match table definition.I had a base
installation of GP 9.0, no patches. Decided to download SP4 and install.
Install of the MSI went fine and upgrading the master databases worked, but
going company by company, I get the following error:
The following SQL statement produced an error:
CREATE Procedure SVC_POP_Make_PO( @PromisedDate datetime, @OrderedBy
char(15), @BatchNum char(15), @ItemNumber char(30), @VendorItemNumber
char(30), @LocationCode char(10), @Uo...Can't receive EMail #5
Keep getting this pop up along with 'server did not
connect within 60 seconfs, do I want to wait
A time-out occurred while communicating with the server.
Account: 'Richard', Server: 'pop.east.cox.net', Protocol:
POP3, Port: 110, Secure(SSL): No, Error Number: 0x800CCC19
Please reply using firstname.lastname@example.org
please read this information from Microsoft
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
Bravestar@Datenschutzminis...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...trying to link maps and pie charts
I was trying to link sales data stored in an excel table with a specific
country in MapPoint. This software allows you to do this very easily. You can
even picture the data in piecharts (% sales for each competitor).
However there is very little flexibility with the look of the result: you
cannot choose the color of the slices of the pie, you may not display data on
the graph, and the maps do not look very professional.
I know it is possible to link automatically a table with a shape in visio.
Can this shape be a given country/region on a map? Can the callouts have th...Can I do this query in one step?
Suppose I have a talble like this, each record has a unique ID. All"A"s or "B", "C"s should have only x or y or z property attached. Iwant to find A, B or C which has more than one properties.1 A x ...2 A x ...3 A x ...4 A y ...5 B x6 B y7 C z....resutls would look like:A xA y....I think I can do this in two steps or with a subquery. Then I thoughtof self-join but didn't figure out how to use it in this case.Thanks a lot! SELECT DISTINCT and do not include the record ID perhaps? Or is the record ID vital?"muster" <email@example.com> wrote in me...