Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
dynamically alter position of subreports on main report
my main report has 10 sub reports - each reporting differeing data for a specific account. Occasionally, some of the subreports have no data. Is there a way to cause the NO DATA report to hide (I know the HasData and NoData) while causing a report WITH data to be displayed in the hidden (no...- af390
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
MS Query won't open MS Access database for import to Excel
I am trying to import MS Access data into a very complicated multi sheet Excel spreadsheet. The data is back end protected by a workgroup secrity login protocal that MS Query is not able to process. Any suggestions on how to program MS Query to accept the login protocal. This is the security...- af390
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Recordset/SQL problem - not returning correct record or returns an err
I have the following simple code to create a recordset (rst) that I then need to re-query based on entries from a user. Set rst = db.OpenRecordset(SELECT * FROM tablename) when this line executes I get 1 record. When I execute Set rst = db.OpenRecordset(SELECT DISTINCT * FROM tablename) I get...- af390
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
how to force page on non-sorted/grouped report
I have to build a report that has text boxes as "headings" followed by tabulated data and a "can grow" memo of undetermined size. I need to force page breaks so that a one title is not left at the bottom of a page and the data is at the top of the next. The data tabulation is not orgranized in...- af390
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
