Access 2000 reports not printing in Access 2003

[Guest]

We have been using a database for the last 18 months written in Access 2000.
We are in the process of upgrading to Access 2003 and the reports, that still
generate under Access 2000, come out blank when generated in Access 2003. In
addition the query that the reports are based on work fine in Access 2000,
but return no data in Access 2003. Any help would be welcome.

 

[Allen Browne]

More information, please.

Is this a network printer?

Post the SQL of the query that does not work? (Sql View on View menu when
you are in query design).

Does this query contains a reference to a text box on a subform? Or are
there VBA functions in the query?

Access 2003 uses the Access 2000 format by default, so there's something odd
here.

 

[Guest]

1. Yes it is a network printer, but it is the same printer we use with the
Access 2000 terminal and it prints fine.

2. SELECT TOP 1 tbl_DiciplineIncidents.Date, tbl_personal.[Last Name],
tbl_personal.[First Name], tbl_personal.[Job Title],
tbl_DiciplineIncidents.Supervisor, tbl_personal.[Job Code],
tbl_personal.SSnumber, tbl_DiciplineIncidents.Narrative,
tbl_DiciplineIncidents.Sequence, tbl_personal_1.[Full Name],
tbl_DiciplineIncidents.seq_DisciplineLevel,
tbl_DiciplineIncidents.seq_DisciplineCategory,
tbl_DisciplineLevels.DiscLevel, tbl_DiciplineCategories.DisciplineCategory,
tbl_personal.[Employee ID #]
FROM tbl_DisciplineLevels INNER JOIN (tbl_DiciplineCategories INNER JOIN
(tbl_personal AS tbl_personal_1 INNER JOIN (tbl_personal INNER JOIN
tbl_DiciplineIncidents ON tbl_personal.Sequence =
tbl_DiciplineIncidents.seq_Personal) ON tbl_personal_1.Sequence =
tbl_DiciplineIncidents.Supervisor) ON tbl_DiciplineCategories.Sequence =
tbl_DiciplineIncidents.seq_DisciplineCategory) ON
tbl_DisciplineLevels.Sequence = tbl_DiciplineIncidents.seq_DisciplineLevel
WHERE (((tbl_personal.[Job Code])<>"0240" Or (tbl_personal.[Job
Code])="7302") AND
((tbl_DiciplineIncidents.Sequence)=[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence])
AND ((tbl_personal.Sequence)=[Forms]![frmSupervisorMain]![Combo0]))
ORDER BY tbl_personal.[Last Name], tbl_personal.[First Name];

3. Yes the query uses a text box on a subform to filter the query.
[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence]. If I
take this criteria out of the query it works, but it returns all records not
the specific record. The query runs fine in 2000 with this criteria in.

Thanks for the help

 

[Guest]

Of further note is the fact that the text box being referenced in the subform
is an AutoNumber field, but it is set to Long Integer not Replication ID.
Thanks again in advance for the assistance.

1. Yes it is a network printer, but it is the same printer we use with the
Access 2000 terminal and it prints fine.

2. SELECT TOP 1 tbl_DiciplineIncidents.Date, tbl_personal.[Last Name],
tbl_personal.[First Name], tbl_personal.[Job Title],
tbl_DiciplineIncidents.Supervisor, tbl_personal.[Job Code],
tbl_personal.SSnumber, tbl_DiciplineIncidents.Narrative,
tbl_DiciplineIncidents.Sequence, tbl_personal_1.[Full Name],
tbl_DiciplineIncidents.seq_DisciplineLevel,
tbl_DiciplineIncidents.seq_DisciplineCategory,
tbl_DisciplineLevels.DiscLevel, tbl_DiciplineCategories.DisciplineCategory,
tbl_personal.[Employee ID #]
FROM tbl_DisciplineLevels INNER JOIN (tbl_DiciplineCategories INNER JOIN
(tbl_personal AS tbl_personal_1 INNER JOIN (tbl_personal INNER JOIN
tbl_DiciplineIncidents ON tbl_personal.Sequence =
tbl_DiciplineIncidents.seq_Personal) ON tbl_personal_1.Sequence =
tbl_DiciplineIncidents.Supervisor) ON tbl_DiciplineCategories.Sequence =
tbl_DiciplineIncidents.seq_DisciplineCategory) ON
tbl_DisciplineLevels.Sequence = tbl_DiciplineIncidents.seq_DisciplineLevel
WHERE (((tbl_personal.[Job Code])<>"0240" Or (tbl_personal.[Job
Code])="7302") AND
((tbl_DiciplineIncidents.Sequence)=[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence])
AND ((tbl_personal.Sequence)=[Forms]![frmSupervisorMain]![Combo0]))
ORDER BY tbl_personal.[Last Name], tbl_personal.[First Name];

3. Yes the query uses a text box on a subform to filter the query.
[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence]. If I
take this criteria out of the query it works, but it returns all records not
the specific record. The query runs fine in 2000 with this criteria in.

Thanks for the help

More information, please.

Is this a network printer?

Post the SQL of the query that does not work? (Sql View on View menu when
you are in query design).

Does this query contains a reference to a text box on a subform? Or are
there VBA functions in the query?

Access 2003 uses the Access 2000 format by default, so there's something odd
here.

 

[Allen Browne]

In the query, try replacing:
[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence]
with:
[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents].Form![Sequence]

Although the first one should work, other users have reported problems with
it in A2003.

If you want an explanation of what the 2nd one means, see:
http://members.iinet.net.au/~allenbrowne/casu-04.html


Hopefully that solves the problem. If the printer issue is not solved, there
have been at least 3 or 4 threads this year regarding printer problems like
yours. All involved network printers. All were A2003. Most said their other
software (e.g. Word) printed okay. But the problems were related to
incorrectly registered printers.

You can probably confirm whether this relates to you by querying Access
about its understanding of the printers. Open the Immediate Window (Ctrl+G),
and enter:
? Application.Printer.DeviceName
Is it able to tell you the correct printer?

Try:
? Application.Printers.Count
How many printers does it see?

Try:
? Application.Printers(1).DeviceName
and replace the 1 with other numbers as well. Does this line lead to an
understanding of what Access thinks is the situation with your network
printers?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

1. Yes it is a network printer, but it is the same printer we use with
the
Access 2000 terminal and it prints fine.

2. SELECT TOP 1 tbl_DiciplineIncidents.Date, tbl_personal.[Last Name],
tbl_personal.[First Name], tbl_personal.[Job Title],
tbl_DiciplineIncidents.Supervisor, tbl_personal.[Job Code],
tbl_personal.SSnumber, tbl_DiciplineIncidents.Narrative,
tbl_DiciplineIncidents.Sequence, tbl_personal_1.[Full Name],
tbl_DiciplineIncidents.seq_DisciplineLevel,
tbl_DiciplineIncidents.seq_DisciplineCategory,
tbl_DisciplineLevels.DiscLevel,
tbl_DiciplineCategories.DisciplineCategory,
tbl_personal.[Employee ID #]
FROM tbl_DisciplineLevels INNER JOIN (tbl_DiciplineCategories INNER JOIN
(tbl_personal AS tbl_personal_1 INNER JOIN (tbl_personal INNER JOIN
tbl_DiciplineIncidents ON tbl_personal.Sequence =
tbl_DiciplineIncidents.seq_Personal) ON tbl_personal_1.Sequence =
tbl_DiciplineIncidents.Supervisor) ON tbl_DiciplineCategories.Sequence =
tbl_DiciplineIncidents.seq_DisciplineCategory) ON
tbl_DisciplineLevels.Sequence = tbl_DiciplineIncidents.seq_DisciplineLevel
WHERE (((tbl_personal.[Job Code])<>"0240" Or (tbl_personal.[Job
Code])="7302") AND
((tbl_DiciplineIncidents.Sequence)=[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence])
AND ((tbl_personal.Sequence)=[Forms]![frmSupervisorMain]![Combo0]))
ORDER BY tbl_personal.[Last Name], tbl_personal.[First Name];

3. Yes the query uses a text box on a subform to filter the query.
[Forms]![frmDisciplineIncidents]![sfrmDiciplineIncidents]![Sequence]. If
I
take this criteria out of the query it works, but it returns all records
not
the specific record. The query runs fine in 2000 with this criteria in.

Thanks for the help

More information, please.

Is this a network printer?

Post the SQL of the query that does not work? (Sql View on View menu when
you are in query design).

Does this query contains a reference to a text box on a subform? Or are
there VBA functions in the query?

Access 2003 uses the Access 2000 format by default, so there's something
odd
here.


message

 

[c0mputerdiva]

Did you get this issue resolved? I have a similar -- same problem. It
doesn't matter what printer is installed, the first page prints
correctly and all following pages omit the data from the subform.

Thanks for any help you can give.
Tammy Anaya