Filter Report by Form
I have a report with both text, date and Yes/No fields and I am trying to
filter the report data with a pop-up form. I have fields I want to filter
the data by. I have code that works with 'Text' fields; it is
For intCounter = 1 To 5
If Me("Filter" & intCounter) <> "" Then
strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " & " =
" & Chr(34) & Me("Filter" & intCounter) & Chr(34) & " And "
If i take out ...UK VAT Reporting
UK regulations request that we report the value of EU tax transactions as
though they were UK.
As we currently have 4 rates (Standard, Lower, Zero and None) the EU tax
rate setup at the moment, which allows for only 1 rate does not meet these
By rights the EU should be tracked at Tax ID.
UK VAT laws require you to show the VAT due bit not paid on all goods and
related services you acquire from other EU member stated. As stated, the
government require this to be at the same rate as though purchased in the UK.
Legitimately purchased goods would be classed as having a Zero ta...Logs not clearing after full backup with NTBackup
I've just started a new contract. My new client has Exchange 2003 sp2 on
Server 2003. When I first looked at the Exchange box I realised it hadn't had
an online backup done for sometime. I ran a full backup using NTBackup,
backing up the Information Store, Mailboxes Store and Public Folders Store to
our NAS box. The backup completed with no reported issues. Unfortunately it
didn't clear the logs, E0xxxx.log.
Having spoken further with colleagues I've been advised that the stores were
restored from backup sometime ago and I'm wondering if this is having an
...Report with buttons to open specific form for each record
Is it possible to have a report that is based on a query (which is based on
numerous other queries) to have a button that opens a specific form for each
record on the report?
I would like for the user to be able to select an appropriate button which
corresponds to a form based on the results showing on the report.
...what is the perl table ??? and how i can use this
Is it possible to start a perl program from within the vba code.
Take a look at Shell in VBA's help.
> Is it possible to start a perl program from within the vba code.
You can instantiate a WSH object, and this can run Perl code if you down the
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"luc" <email@example.com> wrote in message
> Is it possibl...excel for tracking golf scores or handicap
Looking for a template for capturing my golf scores with note per hole
...Actual report printout different from layout in Report Writer
I have a report that when I print it out looks different than the layout seen
in Report Writer.
For example, the layout in Report Writer has a logo and a specific company
address, but the printout is missing the logo and the company address is
completely different. The same is observed on other report elements.
If I add a big TEXT box in the middle of the report through Report Writer,
the printout doesnt show it at all.
What can be causing this?
Business Systems Analyst II
Northwestern Medical Faculty Foundation
Chicago, IL USA
Did you grant access in securi...Reports won't run
I have been working on two reports. Now neither will run nor allow me to
open in design mode. Can't imagine what happened? When I pulled in an old
version of the same report - same thing. I opened the underlying query -
Anyone have any ideas?
Sorry - I found one of the subreports was corrupt. When I recreated they all
> I have been working on two reports. Now neither will run nor allow me to
> open in design mode. Can't imagine what happened? When I pulled in an old
> version of the sam...Run SSRS stored procedure report from a CRM 2011 for a current record
we need to run a SSRS report created via stored procedure for the
current record in a custom CRM entity .
we completed creating stored procedure , but pre-filtering is not
working . when we tried to preview in visual studio it is picking up
the lastest record values only .
Could any one give some suggestion to resolve this issue ?
...Reporting Services Sharepoint Add-in
I have recently setup SRSS in integrated mode and everything seems fine. I
am using SQL Server 2005 with WSS 3.0 as part of a project server
installation. Previously I had been using SRSS in native mode. The setup of
SRSS has all completed successfully and I have gone in to Sharepoint Central
administration and done all the Reporting Services configuration.
I now want to set up a site on my server to publish all my reports to.
However, the Report Center template that is constantly referred to is not
available. Where do I go from here?
...Grouping and Sorting a Report On Open Event
I want to use a single report with pre-defined Group and Sort criteria and
then Group/Sort on different Group Levels ( some or all groups). The
following code works but gives me an Enter a Parameter False when running
report. How do I turn off or suspend levels of Grouping rather than = False?
If I remove the ControlSource.False, the reports grouops on three levels and
not one as desired. Any help appreciated.
Private Sub Report_Open(Cancel As Integer)
On Error GoTo Report_Open_Err
DoCmd.ShowToolbar "iTurns Command Bar", acToolbarNo
Select Case Forms!Print...Text or Sub-report on even pages of a report
I would like to print "a standard text message" on even numbered pages of a
report. This is akin to printing "disclaimers" on the back side of two-sided
I can see a way to do this using the "Page Footer" format event. Not having
tried this before, can you offer any advice?
you can put following code in page footer format event:
Me.lblDisc.Visible = (Me.Page \ 2 = Me.Page / 2)
where lblDisc is a label control with text message
Alex Dybenko (MVP)
...GP 10 AA Report Configuration
Ok.. we have AA active in a company, but have deselected all AA reports to
print under Posting > Posting; however, the following report still prints to
screen when processing comptuer cheques 'Analytical Accounting Edit List'
How do I remove this report from printing?
...Urgent help: log issue
windows 2003/exchange 2003 Sp2
Due to log space that is almost full, I use the eseutil /mk to check the
checkpoint and moved some log files that are safe to move. Now, the log
files are not trucated when we do a full backup.
How should I fix this problem?
On Sat, 1 May 2010 06:41:01 -0700, ed <firstname.lastname@example.org>
>windows 2003/exchange 2003 Sp2
>Due to log space that is almost full, I use the eseutil /mk to check the
>checkpoint and moved some log files that are safe to move. Now, the log
...detailed sele report / item Report
I checked all the news group before this posting and could not find my
I am looking for a detailed item sales report with all items showing only
once in a report. Currently when I run my detail item sale report same item
shows up again and again.
I am looking for a detailed item report where one item shows only once in a
report with quantity added togather.
Current Example: Detailed item sales report
item Look Discription Price QTY Total
111 Marlboro Red 2.00 3 6.00
119 Doral FF KNK 1.50...Report #2
I have a manager who would like a monthly report on inbound and outbound
email volume to each user under her. What is the easiest way to achieve this?
See "IMI Mailbox Statistics" - friendly user interface, export to TXT, CSV,
HTML, and Direct Print - http://www.imibo.com/imidev/Exchange/imims.htm
The report columns give to you information such as the mailbox name, the
Windows NT user account name of the last user to log on to the Mailbox, the
sizes of each of the messages in the mailbox, the total number of messages
in the mailbox, the date and time when the user last logged on...Trouble with reports
I'm working with Access 2003, making a bill, and I have a problem when
I want to fill the Detail Section with two lines (one at the left
margin and one at the right margin) which covers the "distance"
between all the Detail Section and ends at the top of the Bottom of
Page (I don't know if I am using the right terms, I'm working with
spanish version of Access).
The Detail Section contains different concepts of the bill (price,
quantity, description...) and it not contains ever the same amount of
this concepts in different bills... I tell you this because I ...Report Builder 04-20-10
Is it possible to have dynamic datasources (like in BIDS) for report models?
We have 200 vendors wanting access to our ReportBuilder, but I don't want to
build discreet ds's for each one. I've googled it but can't find anything
...money2001 category spending report order
Category spending when opened always starts at the bottom of the listing. I
have to scroll all the way back to get to the start.
I cannot find any way to force it to start at the top of the page - which is
in alphabetical order.
I cannot find any options in the help menu, is it possible to fix this?
You can reverse the sort order by clicking on the Date column in the
transaction list- you will notice a little arrow that points up or down
indicating whether the sort order is oldest first or visa-versa. Same for
the Payee column, if you click on Payee the sort order will change to
Could anyone tells me how to active this
HQ Manager-Reports-( CUSTOM ) <---
I am trying to add modified report to my existing reports.
Look in the .../Headquarters/Reports directory
make a copy of one of the files and rename it using this convention:
Custom - My Report Name.qrp
Note the spaces around the hyphen - they have to be there!
Restart HQ Manager and the Custom menu will now be active and you will see a
report listed under it.
..qrp files are just text files - you can customize them by editing them in
notepad. You should always make sure you have a backup copy o...Creating a Date Range in a Query & Report
I've been requested to create a report with a date range. I've created a
query from two tables that have a "Start Date" & a "Completion Date" record.
For example, what expression/operator/criteria would one suggest to
accomplish creating a "Date Range" in a report of the number of a product
that was installed over a period of time using these two records?
So you want to see all the records where the item was completed between two
Just put criteria under the completion date of...
Between [Enter Start Date] and [En...Report chart order
I have 5 picklist attributes that I want to display along the x axis of
a chart in my report. I can't sort by obvious methods (i.e. by data
value of the picklist or by alphabetical order of the names) as these
still produce data that is in the wrong order for my purposes.
I know I could rename everything in the picklist to have a prefix 1, 2,
3 etc, but I'm not really too keen on this. Is it possible to
explicitly define where I want each value on the x axis?
I've modified "SOP Blank Invoice Form" in Dexterity and put in a new
Dictionary and installed on all computers.
I add a lot of text with police.
On test computers it's running with no problem, everything ok.
On production it is printing and data is ok, but my text mixed - or even
What it can be?
I modifed a lot of reports but only with one I have a problem.
I just upgade from 7.5 to 8.0
...Can't add new record when not logged in to Windows XP as an Admin
I am new to Access and have never made an application in my life so
bear with me. Here's my issue: I have a very small Access 2003
database with the backend residing in a folder on a server and the
front end on each user's desktop. The intended users of my application
have been given enough privileges to enter and read data in that
folder (I've even tried giving them Full Control). When I log into
Windows on the network, as an administrator, my .mde application works
perfectly-my form pops right up when I start the app and I can add and
view data as intended. However, when ...