|
Timesheet problem
Okay, I need to write a statement that will return one of two results. In my
jobsite table I have a item OT BIllable. If this item is checked then I want
the total to be the actual number of hours billed. If the answer is no then
I want 40 hours.
I've written the following
=IIf(Jobsites![OT Billable]="Yes",[BillableHours Grand Total
Sum],IIf(Jobsites![OT Billable]="No","40"))
B...
|
3 |
22.08.2006 19:39:02 |
|
|
Filtering Report via form selections
I have a form with various filter criterea for one of my reports, including
several list box controls on the form. I have created text boxes that
summarize the selections together, and now I just need to learn how to
transfer that criterea to the filter property of the report. Is there someone
that can provide me with a bit of guidance regarding this issue?...
|
2 |
22.08.2006 19:08:41 |
|
|
Chart
I am trying to add a chart to a report from a query. I go through the chart
wizard and get to the point where I am to drag & drop, but there is nothing
to drag and drop. Is there something I'm doing wrong?
--
Ronnie...
|
1 |
22.08.2006 19:00:01 |
|
|
Access have portrait and landscape fields in a report
Can you have both portrait and landscape fields in the same report. If so,
how?...
|
2 |
22.08.2006 18:15:38 |
|
|
Annoying flicker when opening report
Reports are being opened in Preview mode.
There is code in the open event.
I use docmd.maximize at the end of the open event
Report partially opens in magnified font then flickers then opens to fill
the screen in a small font.
I tried turning echo off at the beginning of open then on after the
docmd.maximize - no difference. I tried putting the docmd.maximize at the top
of the open event...
|
1 |
22.08.2006 17:04:01 |
|
|
need to use a selection from combo box in code
I have this code and a form so far
my_answer = InputBox(" Is " + rst1.Fields("Contactname") + " the
correct contact for " + studioname + tapetype) ' Calculate the cc
If (my_answer Like "y*") Then
Exit Do
Else
DoCmd.OpenForm "enter contact", acNormal, ,
, acFormEdit, acDialog
...
|
2 |
22.08.2006 16:25:06 |
|
|
List Box Formatting
Ok, real easy one, I hope.
I have a list box and I want to set the alignment formatting to center the
text on output, but I dont have that option. Can it be done?
Thanks....
|
5 |
22.08.2006 16:05:34 |
|
|
protecting database
Hi,
Are there any password protection or ( use previlaged scheme) in Access
database?
thanks,
dhaval
...
|
3 |
22.08.2006 15:29:13 |
|
|
Print 1 record of Report
Good day!! I've been having a few problems with this and I'm hoping someone
can help moi. I would like to print the current record that is on the form.
P Key - Id_Personal
Push Button - frm_cmd_Print_Record
Reprt - rptTEST
Here is my code:
If Me.Dirty Then 'Save any changes.
Me.Dirty = False
End If
If Me.NewRecord Then 'Make sure there is a record to print.
MsgBox "Select the r...
|
9 |
22.08.2006 15:19:41 |
|
|
Not IsLoaded
I need to find the "Not IsLoaded" command so that i can open a report with a
form. Access help tells you it is in the Northwind Sample database, which I
think I can get, but we have a tight beaurocracy here in public education and
it would take a number of steps to find. As I remember, the command is only
a few simple steps, but I cannot recall them at the moment.
tia,
ian...
|
2 |
22.08.2006 14:06:48 |
|
|
Charts on reports
I wish to have a chart on a report but cannot get it to work properly. I am
basing the chart on a query which selects only the records i need out of a
table. For some reason the chart seems to still get its data from the table
and not the query, even though i put the query in the reports control
scource. It seems to then group all the data and makes multiple charts for
each MainID in the...
|
4 |
22.08.2006 13:14:34 |
|
|
Paramaters per Interop
Hi,
I want to show an access report per C#-Interop. I use the following code and
it works fine:
Access = Microsoft.Office.Interop.Access;
oAccess.DoCmd.OpenReport(reportName, Access.AcView.acViewPreview, "", "",
Access.AcWindowMode.acWindowNormal, System.Reflection.Missing.Value);
My problem is now, that the report prompts some paramater inputs (wanted
caption,....). How can I fil...
|
1 |
22.08.2006 13:02:29 |
|
|
SubReport Totals in Main Report footer
I have a main report with a subreport on it. In the subreport I have a total
field in the footer(txtSubSubtotal). My main report has a text field that
refers to that subreport total (txtMainSubTotal). I have another field in
the main report (txtTotalDiff) that refers to a total on the main report and
then subtracts the total from the subreport. This amount is in the details
section o...
|
2 |
22.08.2006 04:06:03 |
|
|
One Parameter to open 2 Reports
I have two reports Chem1 and Chem2 that ask for a parameter value upon
opening. How do I write a Macro that says when opening Chem1 using lets say
parameter value of 44 to also open Chem2 using the same value.
--
TanyO...
|
2 |
22.08.2006 03:26:43 |
|
|
Getting information From Form to report
Hey all,
i have designed an invoice as a form but inorder for me to print out a
professional invoice i want it to print from a report. I want to take
information from the form to the report so i can produce a professional
invoice. How would i go about doing this? I have tried using the
expression builder and taking fields from the form but i end up with
errors such as '#name?' in teh field...
|
4 |
22.08.2006 02:39:14 |
|
|
Report: Pulldown Wizard Shows Up As a Number
Hi.
I'm a total Access novice. I find that creating tables and using the
pulldown wizard to create pulldown menus connected to other tables is
extremely convenient since we have 20 or 30 product names - one of
which must be entered into each new record.
The problem is that once I finish entering data, when I create and
print a report, the fields that the pulldown wizard populated display
...
|
2 |
22.08.2006 02:23:41 |
|
|
use combo box to filter data in a form
Hi! I need to create a report to show deliveries by a company name. I
started this process by using a form displaying all deliveries and added a
combo box in the header to filter all deliveries made to a specific company.
I'm having trouble linking the selected company name to the records displayed
in the form to filter out just those deliveries made to the selected company.
I la...
|
13 |
22.08.2006 02:23:29 |
|
|
Custom toolbar icon prints form instead of report
I have a report with a custom toolbar.
When I open the report and press the printer icon, it prints the report to
my printer.
However, when my user opens the report and presses the printer icon, it
prints an image of another open form, a menu that is hidden behind the report.
What causes this and how can I fix it to work with all users?
Thanks. ...
|
1 |
22.08.2006 00:20:55 |
|
|
3-Up Sort Order
Hi There,
I have a report that prints slips 3-up on a page. The report is very long
and the slips get cut so each page is cut into 3 slips. I'd like to sort
the report so when I cut them they stack in the correct order.
More details:
Let's say I have 9 records to print. Rather than printing records 1, 2, 3
on page one. I'd like to print records 1, 4, 7 on page one. Then print 2,...
|
4 |
22.08.2006 00:02:50 |
|
|
Viewing HTML in a report
I have a table that stores standard, basic HTML (for boilerplate usage)
and need to display it on a report as formatted text, not HTML tags. I
tried using the "Microsoft Web Browser" control and setting the
innertext property, but that errored out. It appears to work fine in a
form, but not a report. I used to use RTF text, but now want/need to
use HTML instead.
Is there a control (or w...
|
2 |
21.08.2006 23:13:12 |
|
|
User Cannot create report in own DB
I have a user that cannot create a report in a database that he creates on
his own desktop. I have gone as far as giving him power user rights on his
machine to try to fix it.
Any clues?
...
|
2 |
21.08.2006 23:08:57 |
|
|
Run Report based on user specified dates
I have a database that has many reports the user can choose to run. Some of
the reports are designed to be sorted by date (i.e., date received, by
quarter, by year, etc.). The users have requested that they get to choose
the date range (specifically by quarter or the year) so that only those
records show in the report. How do I go about doing this? Ideally, when the
user chooses the ...
|
2 |
21.08.2006 22:55:33 |
|
|
Sum including all records
Hi,
I am having a problem with summing of calculated fields. My report is to
sum the costs for each Purchase Order (PO) listed on the form in the PO
footer of the report. Now the data that I am pulling this from will have
multipleinstances of the PO in the details but I just want the sum of the
Quantity of the PO (POqty) * Price on the PO. I am performing this summing
on the PO Foote...
|
2 |
21.08.2006 20:56:02 |
|
|
Adding a subtitle to a report based on its query source
I have popup form from the switchboard that allows that user to choose
a query filter to base their report on. I want to add a subtitle field
whose caption updates to the report filter on format.
However, after the report opens then the filter of the report is like
this:
(((([Timber Sales Tracking Table].PreInventoryAnswer)="Yes") AND
(([Timber Sales Tracking Table].InventoryAnswer)="No"...
|
3 |
21.08.2006 20:49:01 |
|
|
Query returns column headings only
How do I keep a query from just returning the column headings. I have a
query that is returning just the column headings if one of the fields has a
null value.
--
I''m a novice with an advance way of thinking....
|
10 |
21.08.2006 19:32:46 |