Excel 7 Easter egg
MS PowerPoint v4.0 for Windows
TCP/IP networks
Microsoft Access for Windows 2.0
Microsoft Visual Basic for Windows 3.0
Visual Basic Setup Wizard
Crystal Reports
Tip In Excel 7, (Excel for Windows 95) select row 95, tab until you get to column C, go to help about, while holding the ctrl and shift keys press the tech support button, and enjoy the 3-D credits!
Q How do you have one or more slides in a different orientation from the rest of the presentation slides?
A The orientation of slides in PowerPoint cannot be different from one another within the same presentation. To work around this, you could use slide branching to go to another presentation and back. For more information on branching, search help under "Branch".
Tip If you are working on a TCP/IP network and experience problems with communication to other machines such as host systems, use the PING utility to initially troubleshoot if there is a communications problem.
Type Ping 123.45.67.89 (use the TCP address of the machine you connect to).
If you get a response timed out message then you probably have network related problems in the network between your machine and the other machine. If this is the case, then contact your technical support section and tell them you tried pinging the other machine but the request failed.
Q Why do the records I delete from an attached dBASE table continue to reappear?
A When you delete a record in a dBASE database, the record is actually only marked for deletion. It is not permanently removed until the database is packed in dBASE.
In dBASE, records that are marked for deletion still appear in any output form (such as a table in Datasheet view or a report in Print Preview), unless SET DELETED is ON. Because of this, Microsoft Access continues to display records in an attached dBASE table, even if the records are marked for deletion.
To prevent confusion, Microsoft Access provides functionality identical to the dBASE SET DELETED command. To take advantage of this functionality, use the following four steps:
1. Open the MSACCESS.INI file using NOTEPAD.EXE
2. Find the section called [dBASE ISAM]
3. Change the Deleted=Off setting to:
Deleted=On
4. Save the MSACCESS.INI file and restart Microsoft Access.
When you view the dBASE data, records marked for deletion no longer appear. To permanently remove records marked for deletion, you must open the dBASE table in dBASE and run the PACK command.
Q What is the quickest way to search my database for a particular record?
A Use the opentable method for Access and the ISAMs databases and use the Index property. Note, that there is a sample similar to this on page 75 in the Professional Features Book 2.
Sample: Dim db as DataBase
Dim tbl as Table
Set db = opendatabase("biblio.MDB")
Set tbl = db.opentable("Publishers")
tbl.Index = "Name"
tbl.Seek ">=", "M"
If tbl.NoMatch then
Msgbox "No records found"
Else
List1.Additem tbl("Name")
End If
tbl.Close
db.Close
If you connect to a database through ODBC, the quickest way to search the database is to first attach the table or tables you wish to search to an access database, and then follow the instructions above.
Q I am having trouble with the Setup Wizard & Setup Kit that comes with Microsoft Visual Basic version 3.0 for Windows. At various times, it reports trouble copying files as well as other errors.
Is there a known problem with the Setup Wizard?
A Yes, there are a number of known problems with the Setup Wizard and the Setup Kit files that it uses. There are updates available for these Setup Wizard and Setup Kit files: SETUPWIZ.EXE, SETUP.EXE, and the SETUP1 project files. To obtain the updated files, download SETUPK.EXE, a self-extracting file, from the Microsoft Software Library (MSL) on the following services:
On CompuServe, GO MSL and search for SETUPK.EXE. Display results and download. On the Internet, using anonymous FTP, ftp ftp.microsoft.com, change to the \softlib\mslfiles directory, get SETUPK.EXE Crystal Reports for Visual dBASE.
Q How do I add a new label definition to Crystal Reports?
A You need to modify the LABELS.TXT file, located in the \visualdb\crystal directory. The settings in this file are not in centimetres or inches, so to calculate the settings you need to divide the actual label size (in centimetres) by 0.0352.
Thus if a label has a width of 9.91cm and a height of 3.4cm, the resulting calculation would be 9.91 / 0.0352 = 381.534 etc.
You will need to set the top, left, bottom and right margins, the label width and height and the horizontal and vertical gaps between the labels.
The Label Type and Part_Num are used for identification purposes only.
Once this has been done the label will come up as a predefined option when you create or modify a label in Crystal.