Windows Secrets
Windows Secrets Lounge
customized 'autonumber' field (2000)
date problem (2000)
Drive the status of a checkbox from date field (2000 (any))
Mysterious Deleting (2000)
Linking tables after data entry (97 SR2)
Database v Mouse (Access 97)
ComboBox (log changes) (2002 SP-2)
Little report problem (XP)
CommandDialog control (XP)
error message (xp)
Report with Subreport (2000 latest)
Query From Form Info (2002)
Selected records in many Subform (XP/2K)
Command Button (show as 'clicked') (2002 SP-2)
Default field values in form based on one field (2000)
Panic Attack (2000)
FIND commands (97)
Setting the Filter Property on a Form (Access 2k)
Cant open access (97)
Forcing Page Breaks (2000/XP)
Invalid use of Null (Msg) (2002 SP-2)
Max of Expressions (WinXP/Office 2003)
How to refer to a subfrom? (Access 2000)
working days (Access 2000)
Combine Two Records Into One? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Web link in code (2002 SP-2)
ASP Query not updatable (2000)
make table: invalid argument (2000/ sr1)
combo box question (XP,2000)
Quey to count Yes's and No's (97 or 2003)
Value of Previous Record (Access 2000)
Weird Corruption (2000)
Error Handling lost (2002)
Query Question (Access 2000)
Looking for a '-9' in a string (A2k2)
Repeating previous record's data programmatically (XP, 2000)
Can't open/find Excel file after export (97)
Requery in a subform (2000)
Searching Memo Fields (2000)
combobox All records (97)
Dates to Character (Access 2000 - )
Filter problems (Access XP)
SendObject email (2002)
record navigation in subforms (XP, 2000)
No of fields in a table (Access 2000/SP2)
Writing an expression (A2K)
Input Box - 'Cancel' (A2k2)
VBA Help screens (Win2k Pro Office 2k SR-1a)
skip records in source for lookup list (2000)
Escalating Counseling (2000/SR1)
Getting rid of Property Box (2000/SR1)
type mismatch (2002)
Search button (Acc 2K)
Transforming a record (Access 2000)
Novell's Groupwise Email (Access97)
Field size (97)
Icons (97)
Curious VBA quirk? (2003)
Imported Hyperlinks (2003)
Using a hyperlink to open database (Access 2002)
Tab order/move focus (97)
Not Query (XP/2K)
SQL Issue (2000)
Public sub (97)
Datasheet view Qs (97)
Updating Error (2k)
Access 97 (Sync laptop to network)
Drill into Data (Access 2000)
Access XP MDE (Access 2000/XP)
combo box list (2k)
adp (2002)
copy report (XP)
Visual Basic Ver.6 (MS Visual Basic 6)
'Insert into' sql string (A2k2)
Parameters on Reports (Access 2000)
Unbound Text Fields (2000)
Going to last record in subform (Access 2000)
Open Excel workbook from Access Form (2000/XP)
Navigation buttones (Access 2000)
Calculation in textboxes (2000)
remove filter (97)
System MDW is locked by admin (Access 97 SR2)
Form Calculated Field and Record Update to a Table (Access 2000)
USys_SwapTable (Access 97)
Database needs repair (Access 2000/SP2)
Combo box > 65000 entries (Access2000/SP2)
Date & Time Picker Ctl (2000 & XP)
Writing the value of calculated control to (2000)
Excel to Access (2k)
MS Query (Access 2002 SP-2 / Excel 2002 SP2)
Crash on changing a query (XP)
Small capitals (XP)
Rolling Calendar (2000/SR1)
Disable helpfunction (2002)
Report problem (97)
CompactCode (v2000)
Greeting message (97)
Query Confusion (2000)
Report probs (97)
User's Manual (9.0.2720)
Import from XML - multiple layers (Access XP)
access form auto fill (access 2000)
default number in brackets (Access 2000)
Importing Excel worksheets into Access tables (MS Access 2000)
Multiday Append (2000)
Query Trouble (Access 2000 )
Keypress Password (A2k)
Search/Filter a dbgrid (Access 2000 / VB6)
Probably simple but it ain't working (Access2K, Win2KPro)
Accessing records or run Delete Query (Access 2000)
Error Trapping error 2603 (Access 2k)
Can't Open/Edit a Report 'printed to File' (Access 2000)
Flickering Textboxes (A2K)
Read only settings (97)
Post to Second Number (Access 2000)
Formula (Access 2000 and XP)
Strange Filter Issue (2K)
Subform updating (XP,2000)
TreeView properties in VBE (Access 03)
Compile on Demand: Yes or No? (A2002 (SP-2))
Display field results horizontally in Report (Access 2000)
set tabstop programmatically (A2003)
Gray Backgrounds on Reports (Access XP)
Design Mod to Form by VBA Code ? (Access 2003)
Time Conversion (2000)
Move to SQL (2003)
Reports with Subreports problem (Access 2000)
Running reports from differnt places (Access 2000)
Import Text File Error (Access 2000)
Database Locking problem (Access 2000)
A Dilemma (2000)
Error Message - Cannot update field (97 - 2000)
Comparing Date Fields (2000 - SR2)
Code Error DAO.database (2000)
Query Help (2000)
Exporting to XML (Access 2000)
Selective Text Box Disabling (Access 2000)
Can't update record in form (XP)
Linking Access to a SCO Unix Server (2003)
Need Proper Macro Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Populating fields (Access 2000 SP3)
Addition in a report (97)
Type mismatch (Access 2000)
Field Lookup in Table (XP 2000)
Transform a string in a date? (2003)
removing zeros in a table (Access 2000)
Modify a database (XP)
Things to know before upgrading to Access 2003 (2000 SP3)
Counting records in subreports (2000)
Refresh (Access 2K)
Opening Report with different RecordSources (2002)
consecutive number problem (Access 2000 SP3)
Monitoring the progress of a 'save to floppy' (2000)
Using Excel Chart in Access (Access 2002)
Null Values (A2K SP3)
Format Check box (2002)
Write Conflict (XP 2000)
Check Box (Office 2003)
Reporting (Access 2000)
Headers & Footers (Access 2002)
Access opens an invisibile instance of Word (A2k, Word2k)
Changing a Record (XP2002)
Maximising and restoring (A2000)
Creating a table with sums as a query result (Access2K, Win2KPro)
sendobject command (97 sr2)
best way to join access and sql server (2000)
How to identify import errors (XP 2000)
Read Only (XP)
Name AutoCorrect (XP SP2)
Link Manager (2000)
Combining Subtotals in Report (Access 2002 SP2)
AddNew commands (VB 6.0/Access 2000)
Access Forms (2003)
changing path location (2002)
MailMerge from Access (2000)
Query Works Fine, accept when used by a report (2000)
Error Handling (Access 2000)
OPen excel file by VBA (Access 2000)
Default to databse folder (Access 2000 SR-1)
coordinate form and list box (Access 2000)
make the active screen invisible? (Access 2000)
Reports / subReports (A2K)
Modelling Problem (2000)
on error resume next (Acess 2000)
Event timing and 2585 errors (2000sp3)
Subform records updating immediately (A2002 (SP-2))
Count returns bad values (Access 2K, Win 2K Pro)
Access Subreports (2002 10.4302.4219 SP-2)
CurrentDb ? (97 and 2k)
Formatting data in a SQL view
Create two databases from one (XP)
Consecutive imports from multiple databases (Access 2000)
updating identical tables (Access 2000)
Displaying First Letter (A2K)
Design question & cascading combo boxes (XP,2000)
Invoice with If statement (2002, sp2)
Requery (2000)
as/400 ODBC Connection (Access 2002)
Sorting and Grouping (A2K)
Functions don't work in Windows 2000 (Access 2000)
blank pages in report (Access 2000)
Format event in reports (Access 2000)
Open Datasheet Form to Selected Record? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Selected From Combo Box Dropdown or Typed In? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Transforming Crosstab Type of Table into Simple TB (Access 2000)
Query Sort (Access XP, Sp-2)
relationships in FE BE Schema (2K/XP)
DB shutdown (2002)
Query Differences (2000)
Invalid Null (Access 2000)
Labels Access & Epson Esc/P2 (XP, Win XP)
Make Table (97)
Select All (97)
Time Formate (Access 2003)
increment date automatically (Access 2002)
Cursor Return (XP SP2)
Closing a form through code (XP,2000)
Another leading zero question (XP,2000)
2 IFs for same event (a2002)
Using relation or criteria in multiple table query (All)
Calculated field/control (a2002)
asterisks in inputbox? (XP,2000)
queries to code (A2002)
Validation error in append qry (a2002)
Variable Definition (Access 2003)
how to call a function (Access 2000)
Lost Event Associations (Access 2003)
refresh? (Xp,2000)
query question (A2002)
finding a record (XP, 2000)
Text label behavior (XP,2000)
Open a form with password (Access 2000)
requery issue (XP, 2000)
What happened to 'Dynasets'? (Access 2002)
Query question - how to ask? (XO, 2000)
Same Day Last Year (2000 SR1)
Ole Server (Office 2003)
Stopping a parameter query (XP, 2000)
What does it mean - can't find form? (XP,2000)
Combo to List (2000)
Timing Out (Access 2000)
Get Computer Name (VB 6 / Access 2000)
wrong IsNull command (Access 2000)
Security Problem (Access 2k)
Blank Pages (Office 2003)
Sum Function (2000)
SUMMARIZING / ROLLUP DATA (A2K S21)
Auto Update Charts (Access 2K)
dynamic report (2000)
popup form widens inexplicably (2000)
Combo box doesnt save (Access 2000)
Print a Single Label (A2K)
PDF report to email (Access 97)
tab click event (2000)
db compare (2002 SP-2)
MS HTML Help (A2K SR1)
Long Integer as property (Access 2000)
Customised Passwords (2000)
Copy table structure only with RunSQL (Access 2000)
Autonumber field in report (Access 2000)
SQL Select Satements (Access 2003)
Cascade delete command (Access 2000)
Slider Control (Access 2003)
passive shutdown phenomenon (Access 2000 SP3)
Crosstab or not to crosstab (A2K)
Importing long numbers from Excel (2000)
Outlook data from Access (Access 2002 Sp2)
Access / Word 2003 Error (2003)
Syntax error in Lookup (Access 2000)
Setting textbox of open form (Access 2000)
Access application to web application (Office 2000)
Force Fields (2000)
Linking to external server (XP)
Access Help Isn
Populate control in another form (Access 2000)
Blank Criteria (A2K SP3)
Access 97 Error (Access 97)
'Frozen' Objects in Query Design Grid (2002 (10.4712.4219) SP-2)
Transfer Text (97)
Query Join (2000)
Import Text Wizard - Field Names (2003)
Relationship Window (Access 97)
Variable Append Query (2003)
Table data to conditional grid data (2000 professional)
File comparison (Access 2000)
Runtime XP - activex controls (2002 )
Union Queries (XP / 2000)
Access error code 3043: (Access 2000)
Comparing Databses (MS Access 2000)
How to suppress the message (Access 2000)
form in presentation (XP)
Access and Outlook (Office 2000)
form / subform calculation (Access 97 SR1)
Lookupfield with VBA ? (Access 2000)
Dirty (XP/2K)
Workgroup issue (revisited) (WINXP-ACC97)
Labelling (Access 2000)
Top Entries (2000)
Engineering Challenge in Access (Access 2k/Visio 2002 std/win 2k)
Copy field in a table (Access 2000)
Importing Excel (XP/SP2)
Database Format Choice (XP SR2)
embedding Pictures (Access 2000)
Make Text Proper Case (Access 2000)
Open multiple instances of Db (Access 2K)
Excel Automation issue (A97/XL2002)
iif (2000)
Append and/or Update (VBA/Access/XP)
Importing excel files (97)
Importing XML (XP/SP2)
Print report to Acrobat PDF (AccessXP)
refresh? (XP,2000)
What is wrong with this INSERT statement? (VB6/Access 2K)
super search (Access 2k)
How to Update Primary Record? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Parameter queries (XP, 2000)
MsgBox (Access 2003)
InStr() (2000/SP-3)
Closing & opening forms (XP, 2000)
Kodak Viewer (2000)
Ebedding Images (2000)
SQL Troubleshooting (VB6/Access 2K)
overflow (Access 2000)
make modules and tables invisibl vy code (Access 2000)
Emailing from Access (2003)
Autonumber PK (2000)
Image Haze (V2000)
Mailing Labels (2000, XP)
Switchboard Image (2000 SR-1)
Novell GroupWise Email (Access97)
Form Subform behavior (XP)
Deleting linked records (XP, 2000)
DoCmd.RunSQL (2000)
Tracing Documents (2000)
Lost DLL (2000)
Splash Screen (2000)
Creating Relationships (2000)
Linking (2000)
97 (Form/report)
remote location (2000)
Hidden forms (Access 97)
Form with Several Tabs (A2K)
Opening db locally and Online (Access 2000)
star post problem
Index Not Found Synchronization Error (2000 SP3)
Crosstab Query - Grouping (Access XP)
AddItem method or data member not found (Access2K)
Convert a 97 database to 95? (Office 2000)
yet another combo box issue (2002 in 2000 format)
Space filling fields (97)
Emails from Acess (97)
Saving a Reocrd (Access 2000)
SUM on a subform (XP)
Email list (2000/XP)
Deduplicating a table (Access 2000)
equation (2000)
Alter Table SQL Statement (2000)
No Design view allowed (Access 2000)
User Audit Report (2002/SP2)
when closing database getting a replica (2000)
problem ordering report (2000)
Exit After Decompile? (Access 2000)
Add records to a MS Access web database (2K)
Remove Filter causes Access to lose Record (2003)
sizing form (A2002)
Deleting text (97)
Calling Function (Access 2000)
Add/Delete button (XP or 2003)
SendForm sends the contents of the entire table (Access 2000)
Crosstab Queries (2000)
Too few parameters (Access 2k, win 2k)
Dcount (2000)
Setting Modal and PopUp Properties to True (Access 2000)
Complex Query Problems (2002)
Security on access (access 200 and up)
Reports (97)
Date Fields (97)
Report Differences (Access 2002)
Report fields in given order (2000)
Strip empty space (Office XP)
Accessing Value for Query (Access 2000)
Command buttons... (XP)
Automate Access report to PDF (Access 2000)
Automation question... (97 SR-2)
Passing Values (2K SP-3)
Option Values in Qeries (2000)
How to Increment Date Field? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
How to Return Jet Version Number? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Export Queries to Excel (2002)
Create a new record in another table (2000)
Going Paperless (2000/SR1)
TransferText (Access 2002)
DNS or not DNS (A97, NT4.0/XP)
Problem with BeforeUpdate (2000)
Count In Query (2000)
Movable forms with no title bar (2000)
showing sets (2000)
Background (97)
Autonumber less than previously used value (XP SP2)
SQL Server and transaction log (2000)
Label Challenge (2000 SP3)
Replicate Tab Order pop-up (2002)
Turning off MDI? (2000)
Propagating Changes (97)
Caller ID acquisition (Access XP)
Prepopulating a continuous form (A2002)
Form / Subform (A2K)
Enabling and disabling buttons by user level (XP/SP2)
Combo box Question (XP)
GroupFooter (2002)
Sub-report (2000)
Tab colors & Format (XP)
parameter query for two fields (Xp, 2000)
bloating (2000)
2 modules, 1 OnLoad property (A2002)
ComboBox Recordsource Based on Variable (XP, sp-2)
Appending a Text Database Using SQL (Office '97)
Importing Text values (Access 2000)
Warning message (Access 2000)
ActiveX control (2002)
Default Value (Access 2000)
Fields (97)
Runtime Application (97)
Query for the * (Access 2000)
Accounts Payable 1099-Misc Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Upsizing to SQL2000 (2003)
hyperlink object (97)
Import a .txt from the Internet (Office98/Access97)
Reports problem with zip codes (A2k)
blank records (2000)
Creating a new record (2000)
IIF Statement (2000)
Change pointer to hand without hyperlink (Access 2000)
Please help with this concept: A document database (n/a)
Shutdown on inactiviy (Access 2K SP1)
Pivot-table refresh (WXP, O2000)
QuickBooks ODBC (v2000)
ComboBox Default Value (2002)
Report From A Crosstab Query (A2K)
passing parameters (2002)
Table Documentation (MS Access 2000)
There is no object in this control (Access 2k)
Prevent Edits (A2K SP3)
Searching for records (2000)
Is Acces a realtional database (all versions)
Background of Group Footer controls (Access2002)
Reports (2002)
Linked images in a continuous subform on report (XP/SP2)
Printing a datasheet that is a subform (XP/SP2)
Figuring Current School Year (Access 2000)
Report field Contents (Windows NT Office)
Access 2000 and Access 2002 on the same PC (2000/20002)
MAX function (2000)
Sharing Violation (Access 2000)
Counting weekdays (2000)
Can the Date type understand midnight? (2000)
Creating a transparent subform (2000)
Right click menu's in Access (Access 97 SR2/VB6)
Banding of salaries (2000)
VB help fails (2000 SR1)
Autocompact (Access 2000)
Connect multiple access databases (access2000)
memory error (Access 2000)
3rd Week of the Month (Access 97)
Adding to Report (XP)
Access 2K Delete Bug Resurrected (Access XP SP2 on Win2k)
Query, Select only one instance (Access 2000)
Calculation from tables (2000)
Print a Conditional Second Page? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Finding Number of Columns in a recordset (Access 2K, Win2KPro)
Adding the record Number (Access 2000)
Dynamically Calculating Report Control (2002)
Lookups (97, 2000)
Autonumber fields (XP)
Opening Reports with a Where condition (All Versio
1 To 1 User Interface (Access 2000)
Compile error (Access 2000)
AccessXP, multiuser - Performance loss (Access XP)
function CompactOnClose (Access 2000)
Make table or delete all data ? (Access 2000)
reports (access2000)
Relationsip Window (Access 97)
Search (2002)
Report criteria form (2002)
Getting the procedure name that an error occurs in (XP/SP-2)
Filter on Multiple Lookup Combo Box (XP)
Automation Error (Access97)
Statusbar (Access 2000)
Locking and lost autonumbers (2000)
Problem with a converted macro 'SendObject' (Access 2000)
Creating Monthly Database (Access 2000)
Error Report (Access 2000)
SQL Tools (2002)
Prevent Changes (2000 SR-1)
Images in Access (XP)
Referencing Forms (97 - 2000)
Embedded Reports (Access 2000)
Finding a Brought Forward figure (2000)
Showing one column in a Chart (2000)
Record refresh (2002)