|
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, August 27, 2016 – Permalink – List Fields in Access TableBit o' codeWhen viewing a table that has many fields in Design view, you have to scroll up and down to review the field names. This can be tiresome when you're referring to them constantly, and particularly when you're working with several tables. The following code produces a field listing for a given table. This can then be copied to Notepad and printed for easy reference. Enter the code into a module, substituting your table's name where appropriate. Open the Debug/Immediate window, type ListFields, Press Enter to produce the listing. Sub ListFields() Dim dbs As DATABASE Dim dbfield As Field Dim tdf As TableDef Set dbs = CurrentDb Set tdf = dbs.TableDefs!NAMEOFYOURTABLE Debug.Print "" Debug.Print "Name of table: "; tdf.Name Debug.Print "" For Each dbfield In tdf.Fields Debug.Print dbfield.Name Next dbfield End Sub See all Topics access Labels: General, Reference, Shortcuts, Tables, Tips, Troubleshoot, VBA <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Friday, April 29, 2016 – Permalink – Reduce Entry ErrorsDisable AutoExpandWhen you type an entry in a combobox control Access will typically attempt to complete the entry based on the control's lookup list. This is controlled by the AutoExpand property, which is set to Yes (-1) by default. Although such behavior is helpful, it can cause problems if your value list contains several items that are close in spelling, since it's easy for users to accidentally let Access choose the wrong item. You can avoid errors by setting the control's AutoExpand property to No (0) in Design view or using VBA to set the property equal to 0. Once you've made the change users are forced to type the entire entry or select an item using the combobox control's dropdown list. (Works the same in Access 2007+) 
See all Topics access Labels: Entries, General, Reference, Tips, Troubleshoot, Tutorials <Doug Klippert@ 3:54 AM
Comments:
Post a Comment
Monday, January 11, 2016 – Permalink – Linked Table ProblemsLost functionalityHave you found that you cannot update linked Excel tables in Access 2003+? If you have installed Microsoft Office 2003 Service Pack 2 (SP2): MORE INFORMATION Support.Microsft.com: You cannot change data in tables that are linked to an Excel workbook You might try reinstalling and then only installing SP1. Also: PCWorld.com: Patent ruling costs Microsoft $8.9 million "A jury in U.S. federal court found that Microsoft infringed on a Guatemalan inventor's 1994 patent on technology linking the company's Access and Excel programs, and ordered the world's largest software maker to pay $8.9 million in damages. See all Topics access Labels: General, Reference, Tables, Tips, Troubleshoot, Tutorials <Doug Klippert@ 3:44 AM
Comments:
Post a Comment
Friday, May 08, 2015 – Permalink – Avoid AutoComplete ErrorsDon't startWhen you type an entry in a ComboBox control Access will attempt to complete the entry based on the control's lookup list. This is controlled by the AutoExpand property, which is set to "Yes" by default. If your value list contains several items that are close in spelling, it is easy for users to let Access choose the wrong item by accident. You can avoid errors by setting the control's AutoExpand property to "No" in Design view. Once the change has been made, users will be forced to type the entire entry or select an item using the ComboBox control's dropdown list. See all Topics access Labels: Customize, Entries, General, Reference, Tips, Troubleshoot, Tutorials <Doug Klippert@ 3:08 AM
Comments:
Post a Comment
|
