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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
access report performance
Hi i have an issue with an MDB and an ADP that links to a SQl DB. I have migrated an access application so that the data is now stored in a MS SQL DB, over all the application runs much better but i have a set of reports that are in a separate MDB that run slower than the once connedted to an...- mrdagz
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
-
Format$ Is not a Recongnized built in functon name
Hi, I have a mdb file that talks to a SQL DB that contains a set of reports, this run slow I am assuming this is because it runs though an ODBC link. So I tried to create a ADP that connects directly to the SQL DB this works much faster but behind some of the reports I have VBA code and it...- mrdagz
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
report formating and formulas
Hi, I am trying to change the width of a column with a formula, but it's not working. i have added code to the width formula under size and position but does not have any effct. i tried the following booleanvat testWidth; testWidth = True; if testWidth = true then 5.000 else 0 this...- mrdagz
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Controling Report layout in VBA
Hi, i trying to develop a set of crystal reports that i can display and export though Ms Access using VBA, i got the basic working fine but know i needed to control elements of the reports like column width or even make some column invisible and controlling images loaded in to the report. I...- mrdagz
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 3 Integrate
