|
query dates
Hi,
I am building reports that are based off of queries with the date limiters
of :
>=[Enter Start Date] And <=[Enter End Date]
I found on the boards where if you place the following in an unbound text
box then you will see the date range on the report:
="Between " & [Enter Start Date] & " and " & [Enter End Date]
This works, but it prompts you to enter the dates for the...
|
4 |
03.09.2006 03:21:16 |
|
|
Saving Report pages as individual files
I have a report with 330 pages...each page for a different employee. Is
there a way to have Access automatically save each page as a separate *.snp
report? I would want each page saved using the employee name field. thanks!...
|
2 |
03.09.2006 01:42:27 |
|
|
Print small text
Hello,
I am using Access 2002 and I have one user who prints a report thru her
printer the problem is the report prints out very small at portairt level.
Now when I print the exact report thru my printer I get the report in
landscape view and the way I want the report to look like. Only in Access
she has this problem, she can print out an Excel worksheet using the same
printer with ...
|
1 |
03.09.2006 18:18:28 |
|
|
Cant get a report working from a form
Hi,
I have a report that gets the data from a query. The query uses an
inner join between two tables. The report works fine. The report
contains information about several people. I now want to filter the
data. I used a form with a combo box (based on a table). It contains a
list of people. When a selection is made in the combo box and a button
is clicked, I would like to show the information...
|
5 |
03.09.2006 13:13:56 |
|
|
Need Rpt w/ & w/o Detail Visible
Hi everyone! Using A02 on XP. Have a great report with details and would
like to have 2 buttons, one to open it with Details.Visible=No and one to
open it with Details.Visible=Yes.
Here is what I have now:
Private Sub Command7_Click()
On Error GoTo Err_Command7_Click
Dim stDocName As String
stDocName = "FeesGeneratedFromToByAdmRpt"
DoCmd.OpenReport stDocName, acPrevi...
|
4 |
03.09.2006 05:07:01 |
|
|
Cant get a report working from a form
Hi,
I have a report that gets the data from a query. The query uses an
inner join between two tables. The report works fine. The report
contains information about several people. I now want to filter the
data. I used a form with a combo box (based on a table). It contains a
list of people. When a selection is made in the combo box and a button
is clicked, I would like to show the information...
|
1 |
03.09.2006 03:43:15 |
|
|
Results that go across instead of down, is it possible?
Ok, here's what I have...
Groups, let's say 1-18 (which it actually is), that are actually in a table
but I will just put these as static numbers across the top of each grouping
(1 2 3 4 5 etc.).
Now I want to output a table of different questions that have been asked in
a survey down as a normal report would do, but across from each question, I
would like to list the count of e...
|
2 |
03.09.2006 01:36:14 |
|
|
I need documentation on existing reports and queries of existing d
I need to understand how a current db reports were created (behind the scenes
queries and data sources)
--
Roberta R...
|
2 |
03.09.2006 01:21:09 |
|
|
Tracking Use of Reports
Hi I have a switchboard with buttons on it for various forms for inputting
data and also a form which opens up a reportslist form with some variables
which can be used for the reporting (at present just a date range). The
reports are listed in a listbox using data from one of the system tables.
What I am wanting to do is each time someone accesses a particular report to
output to a table (...
|
7 |
02.09.2006 23:50:58 |
|
|
printing report showing a range of time
I want to print a report from a database that lists work done by time.
I would like to print a report that would show a summary for things that
happened between 9 AM and 10 AM (090000 & 100000) and so on. I am stuck.
If there are any suggestions or help I would really appreciate it.
...
|
2 |
02.09.2006 19:25:56 |
|
|
how to print more then one report
i have a Access2003 report that isnt bound to any tbl ot qry. Is is an
Invoice. A single sheet of A4 paper. When user clicks on print cmd button i
want an option for how many copies are printed.
Any ideas what function/cmd i use for this?...
|
5 |
02.09.2006 15:21:01 |
|
|
No report header using CreateReport?
I programmatically created a report by using CreateReport()
But when I tried to add a label control to the report header, errors
occured.
Dim rpt As Access.Report
Dim lbl As Access.Label
Set rpt = CreateReport
Set lbl = CreateReportControl(rpt.Name, acLabel, acHeader)
Run-time error '2148':
the number you used to refer to the form or report section is invalid.
When I changed acHea...
|
3 |
02.09.2006 05:24:01 |
|
|
I am Unable to update Office- it thinks my PC is a Mac- how do I f
I needed to print double sided reports and so used the Lebans snp to pdf
routine recommended on this site, but Now
I am Unable to update Office- it thinks my PC is a Mac- how do I fix it ?...
|
1 |
02.09.2006 02:33:01 |
|
|
Report footer totals print on 2nd page
I'm trying to create a timecard that has totals for various groups (reg hrs,
vac hrs, etc) at the bottom of the page. It works fine if I leave the report
as a single column. But I've made two columes - one for each of two weeks.
Now the summary, which is in the report footer, prints on the next page. If
I try to put the summary in the page footer, I get the #error message. Can
anyon...
|
7 |
02.09.2006 00:00:01 |
|
|
Number of hours in MS Access report
Hi
I have a report with the following fields: Employee number, Client ID,
Meeting Date, Meeting Start Time and Meeting End Time. I counted the
number of hours using the function Minutes:
DateDiff("n",[MeetStartTime],[MeetEndTime]). It works fine but with a
slight problem. When an employee meets two Clients on the same day at
the same time , it records two as separate hours and this creates
...
|
1 |
01.09.2006 22:29:57 |
|
|
TRIM in a CONCATENATED FIELD
How can I modify the following so that "-/+" is trimmed out?
Thanks for your help in advance!
Packet/Pouch Length: Trim([Length] & " " & [LengthUOM] & " -/+ " &
[Length-TOL])
--
www.Marzetti.com...
|
6 |
01.09.2006 21:49:33 |
|
|
Previewing a report on the Front End
This is a very basic Access database. No complexity here, but I have created
two simple reports. I need a shortcut button for each on the main page so
they can be previewed. On the back end, you can open each report and hit
escape to exit out of them and this works fine. When I created shortcut
buttons on the main page, I am having issues.
After creating the buttons, I go into front...
|
2 |
01.09.2006 19:54:01 |
|
|
duplicate data in a report
I have one table of several fields, name, address, telephone. Some people
have more than one telephone. I have a report that lists name, address,
telephone. I want the report to list the name, address and first telephone
accross one line, and any additional telephone numbers under the first
telephone number. But I do not want to the name and address to repeat on
each line, only the t...
|
2 |
01.09.2006 19:36:50 |
|
|
LinkCriteria on a report
Im attempting to open a report based on user input. Which report to open is
based on a combo box and that worked fine until I added a start and end date
at which point, no matter what date range I enter, it is returning nothing.
Here is my code, what am I doing wrong?
Dim stLinkCriteria As String
Dim stDocName As String
If [Combo7] = "Recalls" Then stDocName = "RecallReport"
...
|
3 |
01.09.2006 16:42:02 |
|
|
Loop in Report Detail Section
Hi,
I'm struggling trying to get this to work. I am building report
(Access 2003) to generate invoices for storage spaces. There are 2
tables (customers, storage_spaces) that it pulls from; each customer
can have multiple storage spaces that are paid once a year.
In the detail section of the report, I need to have a line generated
for each storage space for each year that it may be ove...
|
11 |
01.09.2006 16:32:12 |
|
|
Invoice number
Hello,
I need to have a field on a report that represents a invoice number. I
would like the user to have a pop up on open to enter a starting number and
have it increment one one each page after. I do not need the invoice number
to be stored in the database. ...
|
2 |
01.09.2006 16:27:59 |
|
|
Can This Be Done
I've Created a database in MS Access 2000 with menus that allow users to
make custom searches, reports etc. I would like to be able to have
self-contained exe file to run these menus...
|
2 |
01.09.2006 10:41:33 |
|
|
Sub-reports
Hello,
I have one question related to the sub-reports. When I open the
sub-report and I go to preview, it looks as I want it to look like, but
when I go back into the main report and I go on the preview, it does
not look the same any more. Do you know what could be the problem?
Thank you in advance!
...
|
1 |
01.09.2006 10:11:37 |
|
|
Sub-reports
Hello,
I have one question related to the sub-reports. When I open the
sub-report and I go to preview, it looks as I want it to look like, but
when I go back into the main report and I go on the preview, it does
not look the same any more. Do you know what could be the problem?
Thank you in advance!
...
|
1 |
01.09.2006 10:11:34 |
|
|
OfficeLinks and Ole Automation/exporting reports to word
Hi,
is there a method to export Access reports to a RTF file just bei
calling functions by ole automation.
The DoCmd.TransferText does only work for tables and queries (except I
did something wrong) and using the CommandBars doesn't work because
there is still user interaction required.
Thanks + Regards,
Martin
...
|
1 |
01.09.2006 09:51:56 |