
|
Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
![]() Tuesday, June 28, 2011 – Permalink – Splash ScreenBrand your appYou can replace the Access splash screen with your own logo. Access displays a quick splash screen when you launch it. You can replace that splash screen with a graphic of your own. Save a bitmap graphic in the same folder as the database. Give the graphic the same name as your database and make sure it has a BMP extension. (MyDatabase.BMP) Now when you launch Access by double-clicking on the database icon or its shortcut, you will see your logo instead of Access's default screen. You can also make the graphic 1x1 pixels, so it won't be seen. MS Knowledge Base: How to Create a Custom Startup "Splash" Screen See all Topics access <Doug Klippert@ 3:41 AM
Comments:
Post a Comment
Thursday, June 09, 2011 – Permalink – Null ParameterShow somethingIf a user doesn't specify a parameter value, you can use a wildcard with the parameter in the format Like [Enter Name] & "*" The problem with this is that the query will return records that partially match the criteria. For instance, if users searching for records based on last name enter a parameter value of "Smith" they'll also get the records for Smithers, Smithfield and Smithson. Another problem is that the parameter query will ignore any records where the field being searched contains a Null value when you try to return the entire recordset with a blank parameter. To fix this, set up a query to limit responses to explicit parameter entries, but still allow users to return all records by leaving the parameter blank. If you're searching for LastName, open the query design grid and add LastName to it. In the Criteria row for the field, enter the parameter prompt [Enter Name] Then, in the next blank column of the design grid, enter the same parameter (everything between and including the square brackets) in the Field text box. Finally, in the Or row, enter the criteria Is Null . If you're using any additional criteria for other fields, make sure to copy that criteria to the Or line as well. See all Topics access <Doug Klippert@ 3:20 AM
Comments:
Post a Comment
|