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...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...Report.SalesPlusTax
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>
...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...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...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
Any help would be greatly appreciated
The best way to get started with macros is to use the Macro
Recorder. Go to the Tools menu, choose Macros, then Record New
Macro. Then, carry out some simple tasks and examine the code
that is produced.
...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <email@example.com> wrote in message
> How can I merge 2 cells without losing data from the other...Statements #2
How are statements sorted? Alphabetically by name or by account number? Does
Any help is appriciated, Deb
Mine are done alphabetically by name.
"Deb" <Deb@discussions.microsoft.com> wrote in message
> How are statements sorted? Alphabetically by name or by account number?
> anybody know?
> Any help is appriciated, Deb
...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email firstname.lastname@example.org ��and
windows2003 + exchange 2003 Server "B" email@example.com user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...How to make a Add key disabled after adding one record unless
I have a form where I am adding records. There are two boxes where one has
to put the lineitemnumber and another box where one has to put the
description. Unless the above two boxes are filled in the Add command box
need to be disabled. Now, the problem is after adding one record the Add
button is enabled and I cannot disable it. I would appreciate any help to
The error message is:
The methos is not supported
The following is the code:
Private Sub cmdadd_Click()
On Error GoTo Err_cmdadd_Click
If (IsNull(Me.LineItemID) = True) Or (IsNull(Me.Description) = True) Then
...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...Macro
Here is one for you experts - I am a novice
I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.
Seems like a simple(!!) job - but far to difficult for me to programme
Can an...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" <firstname.lastname@example.org> wrote in message
Is there any way to edit that stock variance report at HQ? There are no ...Messenger emoticons
I have changed laptops and I did grab the old laptops custom emoticons
folder (all in dt2 and id2 file endings.) But when i copy everything in
the folder and add it to my new laptops custom emoticons folder... they
get added (i.e. show up in the folder) but the images/gifs or names dont
show up on the actual msn... *what gives*?
Do I have to change the dt2 endings to gif or jpeg and go to "create" in
msn for each of them to add them in? (I tried with one and it worked)
Only problem is i have alot, like 203 dt2 files so changing the ending
to .gif and adding each singu...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...How do I print 4 postcards to one page to match my postcard paper
I bought perforated postcard paper that has 4 postcards per sheet. How do I
create that in Publisher? I created it exactly how I want it to look and
then realized it's only printing 2 per page.
Which version of Publisher are you using?
MVP Microsoft [Publisher]
How to ask a question
"Lauren" <Lauren@discussions.microsoft.com> wrote in message
>I bought perforated postcard paper that has 4 postcards per sheet. How do
>...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...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...Checkbook Register
Why would negative amounts be showing up in the checkbook register for checks
that are voided? We had a situation where a check written in April was
voided yesterday 8/17/06. The check is now showing up twice on the checkbook
register - one as a positive and the other as a negative. Two other checks
were voided yesterday and they show up as one item in the register with an
asterick (*) by them. The only KBs I can find say that if Bank Rec wasn't
installed prior to voiding (which it was because the others work fine) and
that if the Check was reconciled prior to voiding (which it ...Report Filter focus
I am experiencing an issue with the report filters in RMS. It is not a
show stopper, but annoying.
When I launch a report in SO Manager on a win XP machine, RMS version
1.3, the report filter is there, but the correct field is not selected
and the filter under Filters is not selected. When this happens and I
want to change the filter, I first need to click on the Filter itself
in the bottom box and then select the correct field out of the Fields
list, then change the Value. Is there anything I can do to fix this?
To use a real report as an example, When I run the Detailed Sales
rep...Outlook Express 6 Spell Check #2
I am using Outlook Express 6 on Windows XP, and I have a
problem with spell check. When you send an email, it
says "spell check has been haulted, do you want to send
anyway" and if I ask it to spell check, it says an error
has occured in spell check. All my spelling options are
correctly set, so I don't know what the problem is.
Kimberly McNabb <firstname.lastname@example.org> wrote:
> I am using Outlook Express 6 on Windows XP, and I have a
> problem with spell check.
Ask in an Outlook Express newsgroup.
I'm new to Outlook.
I hear of an Outlook database in other threads. Is this synonymous with the
..pst or .ost files people mention?
Does it corrupt often and if so are there tools to repair it?
There's a utility called ScanPST.EXE that will scan and attempt to repair
Yes, typically when a user says Outlook database they're referring to their
"Craig Roberts" <email@example.com> wrote in message
> I'm new to Outlook.
> I hear of an Outlook d...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...host unreachable #2
if i send a email with a wrong address or mispelled it, i
don't get a message that the address, destination is wrong
until 4 days later after being deletedj from the outgoi
im using E5,5 sp4
Is that for all domains, even for Yahoo and Hotmail?
> if i send a email with a wrong address or mispelled it, i
> don't get a message that the address, destination is wrong
> until 4 days later after being deletedj from the outgoi
> im using E5,5 sp4