Windows Secrets
Windows Secrets Lounge
'Growing' a vertical line
Simultaneous Users
Converting 97 to 2000
Linked ODBC Properties
Compacting by Macro
Export Access Report to Word
What's behind all those references?
Exporting Hyperlinks from Excel Cells to Access
Access 97 calculated field
2000 Security
Version Manager
Report using parameter info in heading of report
ODBC Read/Write
Delete Query
find an order
Formatting a Date
Problems with Queries and Reports
Absolute beginner
Printing selected records from a form
Record in Form & Report
Dates are driving me nuts, prunes aren't anybetter
Access 2000 report - Can I Search?
printing access report
Input Mask with phone #
Access 97 SQL Server 7.0 Error
Read Only Files
Email Snapshot Report
Automatic Year fill in
Access 2000
Compacting from a form
need help with "Dim"
API SaveAs help
Public Object Variables Behavior in Access 2000
Getting to grips with MSDE
Defining a custom Menu with VBA
Access97 Reports
Welcome form
distributing a database
Parameter Query, Dialog Box Problems
Combine 2 queries?
Import Hyperlinks
Changing default for command button
Combining Data from two records
Date problem??
Subform troubles
To clone or not to clone ...
Parsing a Word File
function keys
Show query-report relationships?
New Record on Multi-Table Form
Selecting values by format?
Dialog Box
Variable Name Syntax
Variables in SQL statements....
standalone reports
Infuriatingly simple name and address list
configutarion problem
if else statement
adding a new record
Import Specifications - saved where?
Static Textbox and New Records
How to display new records?
Macro from Word
Blanks in crosstab
locking db
Access Expressions
Access Forms
Access error on close
Report Question
Combo Box Problem
DMAX Issue
Convert 17.00 to seventeen dollars
Access 2000 & SQL Server Update Patch
Counts in Reports
OLE Server
Pictures in a database
Refreshing Data Tables
Using combo box as query parameter
Access Security Damaged by Office Repair Utility?
VBA to check referential integrity?
Start of Week
Access Edit Toolbar?
Relationships - I'm very challenged to do this...
Unable to Import
Purge Qeury
Can't populate partial replicat
Determine if DSN Exists
OS registry information
Protect database
Error on Deleting records
Copy file and then hyperlink
Sub Total / Total
Day of Week Restriction
Print Preview Access 97
Check Box Controls
Memo field in Access97
Updating format of dates
Trouble updating a table
Hide/Close Database Window
SQL vs Query
Status Line
Table link errors
Referencing list boxes in Graph 2000 Charts
Concatenating strings
VB Build in 2000
Sorting tables with lookup fields
Sending data to Excel
Help again..
Can't change a form if database is in use
Last Update Date
Connect Access to ODBC
Record counter
Error Handling within a loop...
Navigation buttons on a subform
Extracting dates for a subform
Bound vs Unbound forms
Determing display resolution from acess
multi-column combo -list box
GetObject 97 SR-2
Browser Control
Updating record in table where key has changed.
97 - Query Returns Duplicates
Report Control Criteria
Importing dBase tables
Missing help file
split a number
Query problem
JRO CompactDatabase Method
Mailto: Hyperlink formatting
Duplicate Records
Excel does this easily but not Access!
Calculating Age in Access 2000
Record counter
trim function problem in 97 sr2?
Graphic image on labels
Printing an Envelope
Open Report
Open Report Action
Web access to Acess DB
List Boxes Data Values
Access 2002 -??
Trap for ODBC conn errors
Cacluating age
can i send a toolbar via code?
report/parameter query
Subform based on a subform
Access 2000 automatically create new record
Access 2000 Field's Caption Property
Reordering lists
A97: On Format Help
Default search button to ANY part of ALL fields.
ACCESS 97 Security Link to NT Logon ?
HELP-Access on the web.
Report graph/chart format problem
Access Question
How to find a record by typing the first letters
How To Set Access Options Programically
Parameters: Print when no data
Quick Report from Dynaset
File size for exported tables?
Access 2000 subform
Searching Fields
Access via Intranet
Linking tables in a query
Access 2000 from 97
Naughty Words
Parameter Entry
Appending data into memo field
update query questions
Outlook 2000 to Access 97
Code Help
linking to excel
Getting the NT login ID in an Access form
Name with accent
Unbound combo box
Reports - Multi-column with a wide header?
Combo box display
Search Engine Functionality
Changing value in a field with an Update Query
Export Query to ASP and make it work?
HELP - How do I use Feet and Inches in my table
dao permissions
Tip - Manage your data types
Record navigation in a report
Query Gives Wrong Answer
Wrong Path error 3044
Access Database Security
Making My Database Accessible
parseing info
IE Activex control
Blank Fields in Report
Slow Combo Box
Counting issue in Access
Default values when creating a new record
Disapearing fields
Help with events
Drill down with 2 Combo's
Access 97 Corruption (?) On Network
Select Text
Call the Zoom box
Export Wizard
Report with dynamic titles
Changing form background colours
generic code
MS Query and Access
Pivot Table - OLE error
Combo Box on Form
Hiding Toolbars
Opening forms automatically...
printing a form and an attached subform
Disabled check box on form
Access Runtime Problems
Combo Box selection problem
Obtain Form's RecordSource w/o Opening Form
Access DB web integration
No Data for a SubReport
Access Newbie Question
Table Equation
#Error or #Name in calculated control
sql concatenation
Report on grouped data
File sharing
Page Margins
A97: Picture DB Size
Using If...Then...Else statement for setting tab
ACC97: Run a query without messages
Set combo box and printing
Making input data Uppercase...
Syntax Error
Exporting to Snapshot Format
Access for multi-users 2
ACC97: Using a calendercontrol
Counting checked checkboxes on a form
Appending a new record to Access table from Excel
Find Record help.
Access2000 VBA Recordset Name
Combo box content vs view
how to build an array?
Text vs Numeric Field
SUM of items in a table
primary key corruption - null value
How to transfer a customized toolbar
HTML control
Crosstab query won't run in Windows 2000
Rounding a calculated expression in a query.
Removiong Objects
[question] Thwarting the import wizard
Access 2000 Password
Temporary Tables & Arrays
Running Time Quandry
Relationship Map
Relate/link fields
Conditional Page Breaks
MapPoint 2001 - Automation
Subscript and superscript
Crystal Reports
Custom Counter in Access 2000
syntax error in update statement
Code ?
Data Checking + Typo Location
Password Problems
Printing Only Even or Odd Pages of a Report
updtate and delete a query
Help with sharing
Multiple table queries
DATE Entry
select 97 or 2000
Windows 2000 and dlookup
Removing All Spaces from a query result
Show/hide textbox control on report
Add-ins dimmed
Querying Access db from Excel
Report help
Open Form
Combo box query
Printing Access Forms
Date edit & formatting
Understanding Naming Conventions
Remove users from database.
Option group to show/hide and clear fields
#name error message on report
Are Relationships Necessary?
Controlling Quality of Data Entered
paste contents of the clipboard in a field
Importing into Access
enterable criteria
Include fields in Report Text box
Menu or Toolbars unavailable
Tracking changes
Report Graphs
app title in msgbox A2K
Access 2000, combo boxes and if statements
Different Kind of Aging Report
Query ?
Modify date in an existing field.
Single form/multiple users
Link an Access97 Chart to Office App
Insert Into/Append Qry
Getting a parameter for a query?
Time Trials
VB/VBA Communication Control
query field - table name
parameter query
Help w/ a Report
SYSTEM.MDW and Database Documenter
datsheet view
Removing carriage returns?
.LDB Bummer
Common Dialog control
Locking a Form and SubForm
Access DB and PDA's
Purposely locking a record
Returning a query's SQL statement from a function.
Conditional Page Breaks
Memo Fields Truncating
Export Database as Time/Date
How Many
VB ?
Update a Table
Unrecognized Database Format
ODBC Driver
Report showing sums from unrelated tables
Is this user in this group?
Open a form with no records in the subform
Report Formatting
Incorrect calculation!
Total Problem
Syncronizing Memo Fields
Poor Programming Practices
Select field with Combo box
Deleteing duplicate records..
Time & Date Issue
Command buttons on a subform
NewData in combo box
Access Reports and networks
Acess for multi-users.
QuattroPro database converted to Access
Rows and colors
Using KeyDown Event
word tables into access database
Exiting Access
RecordSet example
SQL Statement and quotes
Functions not available - Access 2000
Inserting data into a table
SQL statement syntax
Numbering Schemes
Elapsed Between Timestamps
Re: Getting the count for all modules or all macro
Who entered what???
Invisible Queries!?
Passing object variables
Select Folder
Mass Appending
Colour of the Tab Control in a form
Number of rows?
Maintaining records from 1 table in another table
add parsed numbers
Query value '*' from cbo value 'Null'
Postal bar code
How do you quickly add test data??
Access 2000 compacting
Data Access Page fails to connect
Sizing a form in Access
Date Validation Problem
Naming fields in Access
Import Word fields into Access
Delete A Record
Multiple EOF markers in a file
How do I sort an Array in VBA
ODBC Linked/Imported Tables
Query Criteria Tip
Setting listbox items order
Query Question
Database References
Form Lookup
Macro converted to function won't work the same
Forms, Reports
Numbering Records
Parse ?
Large Function
Module call syntax
97 - Populating Field Based on Another Field
using a date as criteria for DLookup
Runtime Compile Error
Access 2000 Conversion Error
Help with numbers
export .txt files
Lookups & Referential Integrity
Some Wizards Won't
Object presence in DB
Changing form linkages midstream
Switching out subforms
School Attendance app
When CurDir() won't work.
Parameters in Queries
Parameter Queries
error handling
Input mask wizard
Creating a special query
Validation for a Parameter Query
Why can't zero-length strings be inserted using IN
Report prints blank
System Robustness
Access97--> 2K tranlation
Time sheet input
Listbox of Report names
Trouble with SendKeys
Function as a Combo Box Source
days and dates
Cannot successfully change the ColumnCount or Colu
ActiveX Progress Control
Change in entry
Long file names and explorer
Disabling Shift key at startup
"Database placed in a state by a user..."
Mickey$oft - Access97 --> Access 2k conversion err
Hide Field on Subform
Like statement
Error "No Current Record"
Command Line Options
Should I use transactions in forms?
Report-line wrapping
Modules PrettyPrint
Error Using Switchboard
Relationships for subforms
Screen Flicker
Subform Will Not Update Itself When Control Source
rounding dollars during calculations
Access 97 Run Time
ListBox on Subform
Going to new record in form *and* subform
Summation to Access2000
copying backend
Re-Creating MDW file and Security Info
Analyze It with MS Excel
Can't enter new records
Update one field record in table from form
ActiveX Error
Subform record count syntax error
SlowShowingFolderContents using File/Open Database
Ac2000 invalid page faults
Back conversion Access97 to version 7
Query criteria and wildcards
Display info about data not in the database
msohelp.exe application error
Query Hierarchies
NOT ing a criteria
Access, Excel Pivots and ODBC Errors
Multiple field FindNext
dbs.execute "delete...
Adding fields "on the fly"
Exclusive access
SQL parameter Qry in Module
OBDC links with Run Time
Combo and Option Group
Using Common Dialog
Solutions Database
Upsizing to SQL Server
Calculated Fields in Forms
Using Crosstab queries in Reports (Access 97)
Second attempt
Messages after Merge
Scheduling Program
Table is Open - Not!
Snapview not so Snappy
Access and .asc files
Automated Incrementing Field
Using a command button to open a merged file
Subsetting a combo box's contents
Security Issue