Access FAQ-indeks
Tilbage til Access-siden Oprettet 26-1-1999.
Opdateret d. 4.10.2003 E-Mail: pvk@oehus.dk
Jeg har hentet Access-FAQ overskrifter hjem fra forskellige sites, og ordnet dem efter emne. Ved at gå ind i denne liste, kan du hurtigt finde lige det du mangler.
Et klik på linien, og du er på den rigtige site og FAQ'en er let at finde, hvis den da ikke vises med det samme!!.
Du kommer ind på sites af Trevor Best, Dev Ashish, Allen Browne, Access-developer og ATTAC Consulting Group
Da der er utrolig mange links, kan nogle være "døde". Hvis du finder nogen, så mail!
Tips for Casual Users
Databases
Tables
Query
Forms
Combo Boxes
Reports
General Concepts
Modules
Macros
Api
Access Basic/VBA Programing
Bugs
Security
Relationships
Tips for Casual Users
- What are these objects? (Tables, Queries,...) Ver 1, 2, 7, 8.
- The Query Lost My Records! (Nulls) Ver 1, 2, 7, 8.
- Mail Merge with Word for Windows Ver 2, 7, 8.
- Referring to Controls on a Subform Ver 1, 2, 7, 8.
- Auto Keys for Aligning Controls Ver 1, 2, 7.
- Relationships between Tables (School Grades example) Ver 1, 2, 7, 8.
- Getting a value from a table: DLookup() Ver 1, 2, 7, 8.
- Limiting a Report to a Date Range Ver 1, 2, 7, 8.
- Introduction to Hyperlink fields Ver 8.
- Numbering Entries in a Report or Form Ver 2, 7, 8.
- Ready to move to Access 95 or 97 (2.0)
Databases
- Database doesn't shrink after deleting something
- Prevent Users Opening a Database Exclusively
- Change Main window Title
- Opening another Database
Tables
- General Table Design Suggestions
- Check out and Use the "Look Up" Feature for Fields When Designing Tables in Access 95 and 97
- How To Set a Table's Visible Attribute Via Code
- Setting A Field's Format/Decimal Places Via Code Either During Table Creation or After a Make Table Query
- How to find out if a table exists in a database
- "Too many fields defined" error message
- Referential Integrity between databases
- Hide a table in Database Window
- Have Autonumber field start from a value different from 1"
- How to perform Seek on Linked Tables
- Retrieve linked database namepath
- Create Hyperlink Field from code
- Reconnect linked Access tables from code
- Reconnect linked ODBC tables from code
- Don't let the Synonym "bug" bite
- Relink tables from different datasources
- Sub-classing Entities
- Creating DSNs from code
- Synchronization without Replication
- Creating an AutoNumber field from code
- Lookup Table Manager
- Recover records from a corrupt table
Query
- How to create an Auto Number For Each Row of Your Query's Ouput
- Multi-User Environment Query and Recordset Issues
- Enhancing the Speed of Large Bulk Updates to RecordSets
- Query Too Complex
- The Confirmation Dialog
- Sequence numbers on the fly (counter emulation)
- Non matching records
- Finding Duplicate records
- Highest Of
- Joined end-to-end
- Delete Duplicate Records
- Use a parameter to return all records if Null
- Return database object names
- Open Parameter queries from code
- Have query return highest/lowest value in a field
- Use a variable in a field's criteria
- Have a query return every nth record in a table
- Find Unmatched records between two tables
- Find Duplicate key values
- Solving problems with Dates in SQL
- Create a query that returns Top n records
- Create a query that returns Random records
- Turn off the default Action query confirmations
- Too few parameters, expected n
- Simplify action queries in code
- Handling floating-point, Currency, and Decimal Datatype in SQL
- Finding all X having all required Y
- Fixed column name and crosstabs
- Continuous sequence, maximum length (stroke)
- Quartiles, Percentiles
- Getting a related field from a GroupBy (total) query
- Merging sequences
- Jet-MSDE: DELETE * FROM Table1; Incorrect syntax near '*'
- BOM, with Joe Celko Nested Sets
Forms
- Use Variables in SQL behind forms
- Find out if a form is open
- Cycle through controls with common names
- Enumerate all controls on a form
- Have the form move to the record selected in List/Combo box
- Return Strings from Option Groups
- Use Multi-Select List boxes as query parameters
- Grab what the user has typed in a control (uncommitted value)
- Fill Fields automatically on form based on a control's value
- Detect new record in a form
- Move cursor to the end of text in a textbox
- Carry current value of a control to new records
- Suspend code until a popup form is closed
- Add item to combo box using OnNotinList event
- Disable PgUp/PgDown keys in a form
- Determine name of parent form
- Resolve #Name error in a form/report
- Use ControlTipText to display textbox value
- Make a label flash
- Delete current record"
- #Error when the Subform has no records
- Cannot ApplyFilter on SubForm
- Colors and Continuous forms
- Refer to Controls on a tabbed form
- Duplicate "Record x of y"
- Ask before saving record
- Limit content of combo/list boxes
- Hide a subform if no records present
- Handle/Display images in forms/database
- Refer to Form and Subform properties and controls
- Create a clock on a form
- Determine selected records in datasheet view
- Open a form in an external database
- Set defaults for Find Dialog Box
- Form only allows new records to be entered
- OnMouseOver Effect
- Control Arrays in Access
- Tooltips don't seem to work
- Close all open forms and "For Each" syntax
- Make Numeric and Date fields respond to Plus or Minus keys
- Move and Resize form windows from code
- Adding 'All' to a listbox or combobox
- Displaying photos in a form
- Display a dialog box for a specified duration
- Adding a Search form to a database
- Changing the Background Color of the Current Record in a Continuous Form
- First Control in a Read Only subform retains focus
- Callback function for a Multi Column List box
- Mini Calendar
- Clock From Around The World
- Calendar Month View
- Shaped Forms
- TSI Subforminator!
- Continuous Forms
- Update All Open Forms
- Calendar without ActiveX
- Use the Column Property of a Combo Box
- Properties at Runtime: Forms Ver 2, 7, 8.
- Rolling dates by pressing "+" or "-" Ver 2, 7, 8.
- Carry data over to new record. Ver 2, 7, 8
- Return to the same record next time form is opened Ver 2, 7, 8.
- Reducing OLE Linking Overhead (bitmaps) Paul Murray Ver 2.
- Status Bar Messages: Forms John Metcalfe Ver 2, 7, 8.
- Filter a Form on a Field in a Subform Ver 7, 8.
- Controlling Movement in and out of a Sub-Form
- How to Tell if the User Moves to a New Record
- Speeding up Combo Boxes
- General Issues on Form Load Speed
- Do Your Forms Which Have Filter Options Take "Forever" to Close in Access 97?
- Using the "Tag" property to manipulate a Form's Controls
- Create A Custom Meter/Progress Bar
- How to Fill a List Box with a List of Reports
- Add Just One Delete or Record Button To Control Both A Main Form and SubForm(s)
- How to Create your own Spinner Control
- Use a variable to reference a table/query field or form control
- Waiting for form to Close
- Refrencing Subform Objects
- Record X of Y
- Force Upper Case
- Forecolor propery limited to 16 colours
- Tabbing past end of form
- Proper Case
- Open drop down of a combo box
- Control Name under Mouse Pointer
- Bold On the Fly
Combo Boxes
- Using a Combo Box to Find Records Ver 8 (with SR-2)
- Making combo boxes faster #1
- Making combo boxes faster #2
- Managing Combo Boxes Paul Murray Ver 2, 7, 8.
- Using the NotInList event (combo) Armin Burkholder Ver 2
- NotInList: Adding values to lookup tables Ver 7, 8.
- Combos with Tens of Thousands of Records. Postcodes example. Ver 7, 8.
Reports
- Reports: Page Totals Ver 2, 7, 8.
- Reports: Blank Line every Fifth Record Ver 2, 7, 8.
- Reports: Snaking Column Headers Allen and LeAnne Jergensen Ver 1, 2, 7, 8.
- List Box of Available Reports Ver 2, 7, 8.
- Query Too Complex
- Blank Pages
- Print To File
- Calculated Fields And Totals
- Page Totals
- Highest Of
- Bold On the Fly
- Path in footer selection
- Stop Report if no data
- Close report automatically if no data found
- Printout Multiple copies of a report
- Print only the current record to a report
- Handle reports from a modal form
- Show totals at bottom of report
- Use Multiselect listbox to limit records in report
- Handle Null values in fields
- Send a report via EMail
- Change printers from code
- Boxes with variable dimensions
- Save a report's output as a PDF file
- Open a report in an external database
- Printing First and Last Page Numbers for Report Groups
- Use a recordset as report's datasource
- Bring up Print Dialog from code
- Count the Number of Groups on a Report
- Printing Page Numbers on multi column report
- Displaying timelines on a report
- Lines/Graphics not retained in Word/RTF Export
- Custom Zoom in Reports
- How to Keep a Sub Report Together on One Page
- Resetting the Page Number for Each Report Group at "1"
- How to Eliminate "Abandoned" Group Headings as the bottom of a Report Column or Page
- How to Print Odd or Even Pages only for your Report.
- How to Send Parameters to Reports only Using Code (Not using QBF)
- How Do I Get My Report to Open In Preview In Front of My Dialog Form Rather Than Behind It?
- How Can I Tell If My Report Was Opened In Preview or Printed?
General Concepts
- Split your MDB file into data and application Ver 1, 2, 7, 8.
- Attached tables: reconnect on start up Peter Vukovic Ver 2, 7, 8.
- DAO: Structure of the Jet Engine Ver 2.
- Self Joins: tables that look themselves up (Pedigrees example) Ver 1, 2, 7, 8.
- Custom Properties: Copyright, Version, Counter. Paul Murray Ver 2.
- Database Corruption Ver 2, 7, 8.
- Set AutoNumbers to start from ... Ver 2, 7, 8.
- Open a Database with Access 2, 7 or 8 with a Right Click
- Add a Compact Database Option to your Right Click Menu for Access 95 or 97, or a Compact Shortcut on the Desktop
- Compiling your Access application
- Curl up with a good book
- Printing the relationships Window
- Resetting Counter Fields
- Putting your Access database on the web
- Out of memory
- The Windows File/Open Common dialog
- Custom Toolbar bitmaps
- Opening a database on a read-only device
- Database doesn't shrink after deleting something
- Spell Checker
- Books for getting into Access/VBA programming
- Access on a Mac
- Change Main window Title
- Importing AutoNumbered Data
- Access 95
- Convert Access databases to Executables
- Automatically resize forms to current screen resolution
- Access, Office and Year 2000
- Determine name of sub/function where error occurred
- Prevent Access from closing
- Reset Autonumber field in Table
- Get path and file name of Current database
- Importing Excel spreadsheets from code
- Send Fax/Email from Access
- Run Word 97 MailMerge
- Some Access specifications
- Commonly used naming conventions
- Why CompactCurrentDatabase doesn't work from code
- Learn about the new Access Virus
- Run Dos Batch files from Access
- Cannot open Access 97 database in previous versions
- Automation object doesn't close automatically
- DLookup Usage Samples
- Use LIKE in queries and code
- Inputbox and Password Masks
- How to create Shortcuts on Desktop
- Duplicate VBA code in Perl using OLE
- Generic Name Structures in Access
- Troubleshoot conversion to Access 97 problems
- Use Autonumbers properly
- Connect your database to the web
- Runtime command line argument doesn't work
- Run wizards from code
- Replace the Access splash screen
- Reading a drive's Volume Label
- Show/Hide database window from code
- Email/Export Charts from Access
- Jet 4.0 Replication
- Who's logged in?
- Copy CommandBars and Import/Export Specifications to a new database
- Displaying IP Addresses by using an Input mask
- What was that password again?
- Bits and Bitmasks
- Access 2000: Hiding Replace Tab in Find/Replace Dialog
- Securing AllowBypassKey
- Access 2000 - 2002: Compact the Current Database
Modules
- Pausing Running Code to Gather Input from the User
- Code to Return the Date for the End of the Month, Beginning and End of the Quarter from a specific date
- How to Determine if an Instance of the Application is Already Running on the Computer.
- Add Pizzaz to your Message Boxes in Access 95/97
- How to Hide the Access Window when Running a Form or Report ShortCut from the Windows Desktop
- Save Memory When Writing VBA Code
- Pausing Code until a Shelled Process Finishes (Access 2)
- Pausing Code until a Shelled Process Finishes (Access 7 & 8)
- Show a List of Directories in Access 7 & 8 using the Windows Shell.
- How to Get the Name and Directory Path for the Current Database.
- How to Get the Network User Name and Computer Name in Access 95 & 97.
- How to Get the Network User Name on a Novell Network
- How Can I Check If a Network Drive Is Available?
- How Do I Open My Application's Help File to the Contents or to a Specific Item in the Index/Search Section
- Convert Currency ($500) into words (Five Hundred Dollars)
- Use variables to call functions
- Read Word Document Properties (Author, Last Print Date etc.)
- Return a concatenated list of sub-record values
- Use SendKeys to open another database
- Sample Excel Automation
- Run Excel Macros through Automation
- Concatenate fields in same table
- Check to see if a File or Directory exists
- Filter a recordset
- Disable Shift key
- Domain Aggregate Functions Replacements
- Use Class modules to return Dir and File names
- Check if an object exists in the database
- Use FTP
- Conquer RunCommand Constants
- VB5 Switchboard Utility
- Import Outlook 98 messages
- Send Email using CDO/Outlook 98
- VB5 Compact Database utility (Access 97)
- Maintain a history of changes
- References Wizard
- Class Builder Wizard
- Compile And Save All Modules
- PrivDBEngine and Startup Properties
- Forms Format Wizard
- Bills of Materials
- Using WithEvents to get saved filenames
- Convert an Access 97 database to Access 95 format
- Access 97 Compactor Addin
- Code Comment Builder Wizard
- Class Information Wizard
- TSI Synchronizer
- Creating a reference to a Class in a Library database
- Transferring Records to Excel with Automation
- Specify UserName & Password for new Access instance
- Internet Data Transfer Library
- Determining who has Word Doc file open
- Getting the Decompile and Compact context menu options
- CodeWriter 2.0
- VBA Developer's Handbook - Replacement for functions in Chapter 12
- Scheduler Utility
- Opening a new Word document based on a template through Automation
- Determining the number of dimensions for an array
- Backup Wizard
- Exporting an Excel worksheet as a CSV file
- Spelling number, in many languages (PolyGlot Number Speller)
- Rotate Label ActiveX Control
- TSI Xpression 9.0
- TSI Form/Report to Data Access Page Wizard
- File Search and Properties Object
- Access 2000: Using DAO code in ADPs
- File Change Notification Component
- Implementing a custom Rounding procedure
- LDB Viewer Form
- Search Wizard
- Reading Text Files
- Text Export Class
- Class for sending emails through GroupWise
- File Slice Wizard
- TSI Word to the Wise
- Automating Internet Explorer 5
- Validation with Regular Expressions
- Waiting for form to Close
- Error Numbers & their text
- Refrencing Subform Objects
- Record X of Y
- Running Dos Internal Commands
- Waiting for an external process to finish
- The Confirmation Dialog
- Playing Sound files
- Proper Case
- Domain functions slow (replacements here)
- Getting Network User Name
- Open drop down of a combo box
- Control Name under Mouse Pointer
- Getting Network User Name (32 bit)
- Trapping ODBC Errors
Macros
- Preventing the AutoExec Macro
- Comments in Macros
- Why there's not many questions about macros
Api
- Call Windows File Open/Save Dialog box
- Call Windows Browse for Folder Dialog box
- Get Local Drives and UNC Path of network drives
- Have Access pause until Shelled process has finished
- Retrieve Unique Filenames for mass export
- Search for a file
- Find out if an application is currently running
- Network User Name
- Current Computer Name
- Retrieve Windows/System/Temp Directories
- How to play WAV/MIDI/AVI files
- Use GetSystemMetrics to return System specific information
- Find class names of a running application
- Create/return a unique temp file
- Read a Value from Registry
- How do I quit Windows from Access?
- How to retrieve information about a specific Locale
- Start Registered applications with ShellExecute
- Manipulate Access Window
- Return Long or Short Filenames
- Make it "Sleep"
- Disable Close button on maximized form
- Retrieve executable's filename and path
- Daylight Savings Time & PreciseDateDiff
- Close another Application
- Copy a database
- hWnd of Controls
- Change cursor while editing
- Detect Available Resolutions
- Interrupt running code
- AddressOf
- Drag and Drop from Explorer
- Enumerating System Fonts
- Detect Application Activate/Deactivate
- Put an image in Access window
- Track IntelliMouse's wheel
- Suppress the "Printing" Dialog
- Suppress the "Loading Image" dialog
- Retrieve NT Server's Time
- Retrieve Current User's NT Domain
- Preventing Multiple Instances of a database
- Copy an image to the Clipboard
- Put a custom icon in the form's caption bar
- Displaying a custom Mouse icon
- Subclassing form for SysTray functionality
- Replacement for Sendkeys
- Enabling Full Row Select in a ListView
- Enabling Full Row Select in a Treeview
- Copy variables/control contents to memory
- Rotate Text
- Read/Set Internet Explorer URL from code
- Determining Combobox's Dropped state
- Drawing images on an Access form
- Retrieving a Special Folder's location
- Retrieving Operating System Name
- Changing button captions in GetOpenFileName dialog
- Removing Min/Max/Close buttons from a report's Preview Window
- Enumerating user accounts in a NT Domain
- Changing Access's Priority under NT/Win2000
- Calling Windows Choose Color Dialog
- Calling Windows Choose Font Dialog
- Return the UserID currently logged on a remote machine
- Close the VBE window in Access 2000
- Change the ForeColor and Bold properties of a selected node in Treeview
- Get Version of Office Exes (detecting Office patches)
- Get full name of the user currently logged in to the system
- Perform IP Lookups and resolve addresses
- Bypassing Autoexec
- Find out if the database container window is currently visible
Access Basic/VBA Programing
- Enabling/Disabling controls, based on User Security berlinda b eras Ver 1, 2, 7, 8.
- Multiple return values from a Function (User-defined types) Ver 7, 8.
- Error Handling
in VBA (Access 95 or 97) or Access Basic (Access 1 or 2)
- Calculate Age of a person
- Return a date in the future from a given date.
- Calculate differences in time
- Return Dates in US #mm/dd/yyyy# format
- Calculate # of Working Days
- Various Date manipulation functions
- How to handle midnight in calculations
- Parse one field's data into multiple fields
- Extract characters from a string containing both numbers and
characters
- Parsing character separated string into individual components
- Replace a character with another within one string
- Capitalize first character of every word automatically
- Convert all text to Upper/Lower case
- Increment Numeric portion of a string
- Names with Mixed cases
Bugs
- VBA Traps: Working with Recordsets - Bugs you need to avoid. Ver 7, 8.
- VBA Traps: Working with Variables - Bugs you need to avoid. Ver 7, 8.
- VBA Traps: Logic Errors - Bugs you need to avoid. Ver 7, 8.
- 17 Steps to Better VBA Code
Security
- Preventing the AutoExec Macro
- Changing the owner of a database
Relationships
- Printing the relationships Window
- Deleting relationships
