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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MSysModules2 missing in new databases
I have an Access97 application where I create databases in code using the CreateDatabase method. I then create and populate tables in these databases. The databases are are then written to CD and distributed to users in different states. They are not actually opened with a user interface at any...- brownbear
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Style Question
Access 97 and Access 2000 Report objects have an event called On No Data (check the property sheet for a report). A simple way to handle reports with no data is to create a macro which, for instance, does the following: 1. Displays a message saying: "No data exists for this report."...- brownbear
- Post #2
- Forum: Microsoft: Access Other topics
-
Query Analyzer syntax checker prevents valid statements from executing
One way around your problem is to use the EXECUTE command to wrap the statements: EXECUTE('select * into step1_out from step1_in where [condition]') EXECUTE('select keyfield, count(*) into step2_out from step1_out') The statements wrapped by EXECUTE are not checked by the syntax checker but...- brownbear
- Post #4
- Forum: Microsoft SQL Server: Programming
-
How to get the table names of a SQL Server 2000 database
There are system stored procedures which give you info but it is easier to use get info directly from the system tables for some things. It is worthwhile getting one of the relationship diagrams of the system tables in SQL Server and learning a bit about them. One of the ones I reference quite...- brownbear
- Post #3
- Forum: Microsoft SQL Server: Programming
