controlling the appearance of data
Thu, 21 Aug 2008 10:03:02 -0700
I have a main report with 3 sub reports in it. Each sub report is based on a
query. If there is no data on a particular person in one of the 3 subreport
queries, the subreport contents do not show up on the main report - and vice
versa. This is what I want.
My question is how can I get the space where the s ...
|
access report:zip code 5, 9
Thu, 21 Aug 2008 09:19:01 -0700
I have a combined value text box for City, St Zip. It doesn't display the -
in those with 9 digits. They are saved in the table WITH the dash. How can I
get the dash to display, or is the combined text value box the problem? ...
|
Concurrent calls
Thu, 21 Aug 2008 07:32:53 -0700 (PDT)
Hello All,
Forgive me if I don?t provide much information as this is my first
ever post, here goes.
I have and Access Database that records information regarding incoming
and outgoing calls for our company, I would like to be able to se how
many calls are happening at any one time and see the highest number ...
|
Printing Report from a Filtered Form
Thu, 21 Aug 2008 08:13:03 -0600
I have run into a number of problems with Filters that I
cannot seem to get around and would appreciate any help,
direction, hints etc ...:
a: Is there any way that a command button or other control.
can be applied to the "Filter by Form" form that would give
the command to apply the filter? Yes, there is ...
|
Records Merging despite Forced Page
Thu, 21 Aug 2008 04:51:01 -0700
How do I stop two Employee records that share the same sir name from merging
onto the same page despite the forced page break? ...
|
How do I hide this Run time error message?
Thu, 21 Aug 2008 10:45:10 +0100
I have a report which I run to return data over a specified time span. If
there is no data I have an message box that appears in the OnNodata Event.
However I also get a message that says "Runtime error 2585 This process
can't be carried out while processing a report or form event"
What do I need to do to sto ...
|
Adding regular and overtime hours and multiplying by rate
Wed, 20 Aug 2008 22:37:01 -0700
I have a database tracking employee labour. I'm trying to print a report
that shows dollar amounts as well as the hours for a particular department.
Data entered:
ST - standard time
OT - time and a half
DT - double time
wage
employee
department
task
project
I need to calculate (ST+OT*1.5+DT*2)*wage. ...
|
|
|
Seeing report filter in report open procedure
Wed, 20 Aug 2008 19:54:01 -0700
I want to use a different record source depending on whether my report was
filtered or not. If I request the report from the Student form, I want to use
qryBill for a single ID. If it's from the report form, I want to use
qryBilling, which selects based on criteria on the report form. I don't want
to have tw ...
|
Overflow ??
Thu, 21 Aug 2008 01:22:06 GMT
I have a query that divides profit by sales and returns a decimal between .
3013 and -.2301 for 19 records.
When I put the criteria, <=0.15 in the field, I get "Overflow". When I click
on it, I get "Overflow" again. then the query shows 1 record with "#Name?" in
all fields.
Any suggestions?
Thanks,
Bill ...
|
Cmd Button on Form for Filtered Report
Wed, 20 Aug 2008 14:48:02 -0700
I am using Access 2000. I am building a warehouse database that needs to
produce a warehouse receipt. I have a form for the customer data which
includes a subform for the product data. I have a cmd button that "should"
create a report that is based on a query of both tables. I need the report
to only be ...
|
