|
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! 
|
 
Saturday, October 31, 2009 – Permalink – Hiding Duplicates in Query ResultsOnce is enoughIt's easy to hide duplicate entries when you run a query, even though Access doesn't go out of its way to call attention to this ability.
Access displays unique records based on each field returned by the query. See all Topics access <Doug Klippert@ 3:12 AM
Comments:
Post a Comment
Sunday, October 25, 2009 – Permalink – Export Formatted SheetsAccess to ExcelAccess provides an easy way to export data to Excel through the Office Links feature. To use this feature, simply select a relevant database object and choose Tools>Office Links> Analyze It With Excel. The worksheet Excel creates includes some minor formatting applied to the field headings that appear in row 1. Some formatting in your original Access database affects the worksheet cell formatting as well. For example, if you're exporting from a datasheet, gridline and font attributes are carried over to Excel. If you use the Office Links feature to export data behind a form, text box shading and font properties are applied. The final result in Excel may not exactly match your Access data; however, you'll probably find that less work is required to get your Excel version of the data into an easily readable state. In Office 2007-10 it's External Data>Excel  See all Topics access Labels: Tips <Doug Klippert@ 3:08 AM
Comments:
Post a Comment
Tuesday, October 20, 2009 – Permalink – Display Data OnceReport TrickSometimes, you may have data that needlessly clutters a report. For instance, suppose your report is listing the fields strCompany, strFirstName, and strLastName. If there are multiple names listed for each company, and the report is sorted by company name, repeating the company information is unnecessary. You may want to set a group header based on the company name, but there's an easier way to hide the redundant data.
 If the data in the modified control is the same as the data from the previous record, the control is hidden. See all Topics access <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Wednesday, October 14, 2009 – Permalink – Access to E-mailWhat's the Outlook?Garry Robinson from GR-FX Pty Limited of Australia and Scott McManus from Skandus, have a tutorial about: Processing E-Mail Orders using Outlook and Access. They have include sample database downloads and the code needed to make the engine work. "Using Microsoft Access and Outlook together can reduce manual processing of Ordering emails very substantially. I know this because sometimes it would take up to 15 minutes to undertake all the little steps of saving customer details into tables and newsletter lists. Also without software, it was very difficult to explain to other staff members what to do when an e-mail arrived. Now we can process the orders in a couple of minutes when Outlook email arrives in the correct folder." See all Topics access <Doug Klippert@ 3:04 AM
Comments:
Post a Comment
Thursday, October 08, 2009 – Permalink – Copy PasteExcel tablesOne way to create a new table in an Access database from information included in an Excel spreadsheet is to select the pertinent data on the spreadsheet, including the field names. Copy the selection (Edit>Copy, or CTRL+C) Switch back to Access . With Tables objects being shown in the database window, choose Edit>Paste, or use the CTRL+V shortcut. Access will ask if the first row contains the field names and then will paste the information as a new database table. See all Topics access Labels: Tables <Doug Klippert@ 3:47 AM
Comments:
Post a Comment
|
