Windows Secrets
Windows Secrets Lounge
2465 Audit Errors after SP3 (Access 2002 SP3)
Global Variables (All)
2004 Advisor Technical Conference (Access97-XP)
Multiple Locations (2000/SR1)
EOF not working right (Access 2000 SP2)
Saving Forms (2000)
Form Code (2000)
Productivity tools (2003)
2Q: Report-Source accesible via Form howto? (2003)
'Before Update' and 'After Update' commands (2000)
VB Coding problem......again (2k)
Combine months and years in Query (XP)
Dates that do not coincide with a calendar year (Access 2000)
Problem Opening Word from Access (Access 2000)
Dup Values in Query Result (2000)
Access Query problem (Access 2000)
Carrying text feilds across forms (2k)
Referencing constant values throughout a project (2000)
Error 3049 (XP)
DB Backup/Update (2k)
Include network login id in Path (2002)
3 Q:List not clickable+Uncheck-all func+para query
Queries automatically changed by Access (XP, 2000)
Apply filter-criteria to forms using buttons? (Ac
Upsizing Wizard (XP/2K)
Setting Outlook Appointments in Microsoft Access (Access 2000/Outlook 2002)
Date Search on a Form (2000)
Form Names with Spaces (Access 200)
Report with a subform (2000)
database won't reconize Date() function (2000)
return to main form from subform (Access 2000 SP2)
Update Query (v2000)
Electronic Signature (2000/SR1)
Referencing query fields in a report text box (2000)
Number of Fields allowed in report (2000/2003)
Topics with scores (Office 97)
Unique Values Query Text Truncation (2003 (11.5614.5703))
Change Report Source on the Fly (XP SP2)
Access Books? (2k)
Running Sum (2000)
Importing Text files > 1KB (Access2000)
Reset data type to autonumber (2k)
Replacing one character with another (97)
Format with Parenthesis (Access 2000)
exclusive access (2k)
Combo box list items not unique (2000)
Fully Qualifying a Field in a Table (Access 2000)
Count records in form (A97)
Strange Error Message (A2000)
MSDE 2000 (Access 2003)
Date conversion (2002)
Truncated imported field (2000)
Print 1st, 2nd, 3rd, 4th, etc on Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8
Check for data duplication with Forms (2000)
Data Entry Validation (2000 - can be higher)
system tray (2002 (10.2616.2625))
Form Manipulation (2000)
Print Barcodes (2000)
Unique ID (VB 6.0)
Scheduling in Access (Access 2000)
Email report by section (Access 2000 >)
Import to Table (A2000)
Report Writer (XP/2K)
Database Design Issue (2003)
Macro Help Needed (2000)
Query help needed (2000)
Opening the Wrong .MDB (2000/sp3 or sp4)
Looking up a table field in a report (2000)
Underline Amount Field On Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Automate Emailing of reports (Access 2000 >)
Reserve Error (Access 2000)
Renaming Database (A2K)
corrupt database flag (XP)
crosstab query and report (Access 2000 all updates)
Wrong info on reports (2000)
Adding Print dialog box to Menu (XP/SP2)
Report (2002/xp)
SubForms view (A2K SR1)
Filter Button (Access 2003)
Permissions Problem (Access 2002/SQL Server 2000)
Recalculate a formula (2000)
Changing from upper case to mixed case (Access 2000 SP3)
Report formatting (2003)
DLookup on subform (Access 2000 SP2)
click to a record (2000)
Sort Not Working? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Cursor in 1st field on input form (ACC97SR2)
Mail Server (Access XP)
Data has Changed (2000/XP)
Automatically add records in related table (2003)
Error message can't assign value to object (Access03)
Date reporting (Access03)
How to stop cursor selecting text (AccessXP)
copy db to another location (Acc 2K)
Cmd Button - Print Report from Form w/Para.Value.. (Access 2000)
Variable Report Title (Access 2002)
Passing information to a report (All)
Referencing a query field in VBA (2000)
Continous forms on format ? (2000)
count function (2000)
independent subforms (A2k)
Change form type? (2003)
public variable in textbox? (2002)
Blink Text (2002/xp)
Record Selection in Single Query (Access 2002)
Query Ignoring Criteria (2002 SP-2)
Combo Lookup Question (2000)
Update Query (2k)
Which control has focus (2000)
Linked Excel Files (2k)
Conditional formatting (2000/XP)
Advice : Best Approach Access and Web (Office XP)
Formatting Message (Access 2000)
Import text file (2000)
Combo Box sort (Access 97)
Loop through query fields with DAO. (2000)
Importing a file (2003)
Backup Backend data file (Access 2000)
Deleting all records (Access 2002)
Changing Data Source Property (Access 2002)
Checkbox as Selection Criteria (2000)
Backing up Linked Databases (2k)
Copy database structure (A2k)
Previous to Last Records (XP)
Problem Creating Crosstab Query (Access 2000)
Shared Info (2003)
Accessing File Error Message (2000)
DCount() function can't find fields (2002 SP3)
Blank Combo Boxes (2000)
How to Find Image Objects? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Change Records on Form (2003 and XP)
Erratic Behaviour (Access 2002/SP3)
combo box record limit (a2k)
MS Access and Windows ME (Access 2003)
Searching (XP)
Bulk emails (XP)
Cumulative Calculations in a Report (2000)
Macro Security Settings Missing (Access 2003)
Add continued text to repeated report section (2000)
catalog dvd, cd, vhs (2000)
Matching records on sub form (2000)
Listing Numbers (Access 2000)
Inserting a date from a variable (2000 (9.0.4402 SR-1))
Auto Populate a field (Access 97)
Hyperlinks (2000)
Reports Print event (Any version)
Referencing a subreport control (A2K)
Hide a control (Access 2K)
Updating DB Files (2k)
delete subform record (Access 2000 all updates)
referencing variables in a loop (Access 2000)
Word in access form (Access 2000 or greater)
Limit 'File Open' types (2000)
compact open database (2K)
sorting subform records (a2k)
Forms collection issue (Access 2002 SP1)
Automating a query (XP, 2000)
report (2k)
Field name not recognised (2000sp3)
Text Query (2000)
Retrieving Relationships through ODBC. (2000 (9.0.3821 SR-1))
Phantom Record (2000)
Sending Emails from Access (Access 2000)
Archiving .pdf images (2002 SP-2)
Conscious mismatch (2000 SP3)
Grouping in Report (2000 SP3)
Using BuildCriteria (Access 2003)
Faxing a Form in Access (Win95, A2K) (Win95, A2K)
How to Save Image as jpg? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Turning Page Header on and off (A2K)
Database on Server (Access 2003)
Detecting a closed Access form (A2K)
Creating a simple Pivot Table (2002)
References Collection via VBA (97 and XP)
Combo Box on Form (Access 2002)
Access 2000 and Access 2003-- Fully compatible? (2003)
Query Prompt & Parameters (XP-SP1)
Importing Excel Sheets (2k)
Missing Record (2000)
User Problems (2000)
IIF statement (A2k)
classfactory error (XP/2K)
combo box (Access XP)
Make Rows in Reports (Access 2000)
Problem Saving Code (Access 2002 SP3)
Totalling (2000/SR1)
Page Set Up keeps going to defult (2000)
crosstab query by date (XP)
Updating Linked Table Source Using VBA (97)
Employee Anniversaries--Separate into months (Access 2000)
Delete records (97 SR2)
Version Problem? (XP-2003/na)
Join Access to SQL Server tables (A2000+)
Change number to a date (Access 2003)
Specifying Worksheet in TransferSpreadsheet Macro (Access XP)
Finalising a DB (2k)
copying previous record field plus one (97)
Hiding Tables (2k)
Multiple Query Criteria (Access 2003)
Deleting Table Links (Access 2000)
Archive Code incorrect? (2000)
Null values in Invoice form (Access 2000 all updates)
SendKeys (A2K)
VB Error 2803 (Access 2003)
fuzzy text search (XP/2K)
Can I access an internal print line counter in VBA (Access 2003)
showing the record number (XP,2000)
Positioning of cursor in field (2000)
copy field to next record in input form (ACC97SR2)
Compile Error (2000)
User form for specifying months (2000)
Filling a named range in Excel with Access data (2000)
access97 export to excel97 (a97)
Advice sought: update from text file (A97)
query question (XP, 2000)
Odd Can Grow Property (Access 2000, WXP Home)
Beginner: changing values (2002)
Automate Data based on middle number (2000)
Hyperlink in Access (2000)
Link to text file (A97)
Right function (Access 2000)
linking to secured Access DBs (2000)
Form / Subform Date Comparisons (A2K)
Comparison Query (WINXP - ACC 97)
Beginner Security (2k)
Pivot Table Gridlines (2002)
Sorting records in date order (2000)
Summing field values from joined tables in a query (2000)
Date Returns Wrong Date? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Requery error Message (2000)
Documenter (2000)
Permissions (2000)
table's fields outlook (a97)
Err Accessing File. NW Conn'n May Have Been Lost (2000)
Jet 4.0 update (Access 2003)
SQL or MySQL (SQL or MySQL)
Jet Database Engine (MS Access 97)
Double and single quotes in SQL string (A2K)
File/Folder paths (2000 (9.0.4402 SR-1))
Delete Fields in tables (Access XP)
Adding only 1 record to a form (2000)
newbie - email from access 97 (office 97)
Flat Sign (2000 (9.0.3821 SR-1))
Switchboard (2000)
Form (Office 2000)
Linked table to access displays #Num! (2003)
database won't open until restart (XP)
Import Text, Add Record Number (Access 97)
License? (Access 2003)
Renaming external files from within Access (2000 (9.0.4402 SR-1))
Critical Failure, Rescue needed (2002)
Wild Cards (2000)
Linking Forms (97)
Database advice needed. (2000)
Fooling Page Numbers (2000)
Showing Month Names instead of numbers in a report (2000)
Reading the forms (A2K)
Tabbed sub forms (2000)
Calculations with criteria (2000)
Pivot Table A97 (Access 97 SP3)
Access - Disabling 'Write Conflict' Dialog Box (Access 2000 SP2)
Totals In A Form Footer (Access 2002)
Combo box clears (2000)
Access DataBase size on Disk (2000 (9.0.4402 SR-1))
Missing query records (A2K SP3)
Sharing a database (Access 2000)
Printing single labels (2000)
Can't enter data into combo on new record (2000)
Display Database Window Programatically (XP-2003/na)
Sum IIf (2002 SP-2)
Changing Relationships Programmatically (2002)
Query Calculations (Access 2002)
Add Records To A Table (Access 2002)
Enter large number (MS 97)
Access Runtime conflict with Access 2000?? (Access 2000)
Ambiguous Outer Join Problem (Access 2K)
Link to Active Directory (XP)
Error using Find (97)
Time with correct values but wrong format (Access 2000)
sorting and grouping (2000)
Query returning list of e-mail addresses (XP-2003/na)
limiting return from query on a report (Access03)
Runtime error '2001' (2002)
Relationships (Access 2000)
Replication (Acess2000)
Trouble accessing site (don't matter)
add records to both sides of MtoM (A2K)
Autonumbers changing (2003 (2000 fileformat))
txtBox on a Report (97/2000/2002)
Close form (A2K SP3)
Hide table (Access 2000)
Run command button (Access 2000)
From Access to Outlook (2000 and XP)
ComboBox to 'search for any or all' (Access97)
using ADO to relink tables (Access 2002)
Drill into Data (2002)
Short cut keys in Query Design Grid (Access 2000)
Runtime Error 2105 (Access 97 SR2)
Cross Reference to records (XP)
Excel to Access error (2003)
OutputTo Query help (xp)
Autonumber Duplicating? (Access 2002)
Dynamic Color Changes (Access 2000)
parameter query fakeout (Access 2000 SP2)
query to separate (Access 2000)
Editing forms in Code (Access 2002/SP2)
Refresh data in subform (Access)
Form Sort Syntax (A2K SP3)
read only (access 2k)
query criteria from formfield (97nl)
Append Query Gives Error Message (2000)
OLE Objects in Reports (again) (Access 97)
Print text on a report if a checkbox is checked
IIF statement (A2000)
Compact Backend in Code (XP)
Text Box Limit (Access 2002)
Lock A Table (Access 2002)
Spell out dollar amount (Access 2002)
Running Average (MS Access 2002)
Conditional Formatting and Locked/Disabled Fields (Access 2002 SP-2)
Disable Shift/Enter to open Access (Access 2000 with SQL)
Duplications (XP)
Convoluted parameters (2002 SP-2)
Displaying checkbox information in a reportt (2000)
displaying OLE objects in a report (Access 97)
Inputting Data Basics (XP-SP2)
copy record by code (97nl)
datasheet forms (Access03)
Trap Compile Errors (2000/2003)
Zero Values on New Copied Record? (Access2002)
Cascade Combo (2002 SP-2)
Running SQL statements from VBA (A2K)
finding the WRKGADM.exe (97)
Dynamic CrossTab Report Calculation (A2K SR1)
97 to XP Migration (97 and XP)
Open a form (2000)
Sending Attachments via Outlook (XP/11.5614.5606)
need to convert my query to a txt file (Office 2000)
Continuous Hourglass (A2K)
IIf with AND (2002 SP-2)
security on dbases (2000/2002)
Adding new records (2000)
Radio Buttons as Filters (Access 2000 SR-1)
One Form prints to network printer (ACCESS 2000 SR-1)
3 databases in one. (2000)
Access Toolbox Not Working (Access 2002 sp-2)
sent mail (97nl)
Need help with a Query (Access 97)
vba understanding (97nl)
Calculating out to 10 decimal places (Access 2000)
Expression has no value error (2002/2003)
Field Size Limit (2002 (10.4302.4219) SP-2)
Select ALL items in list box (Access 2000 all updates)
2 questions about Pivot Chart (2003)
Iff Statement (Access 2003)
List of Users Logged on (2000 & XP)
Subform Problem (2000)
Assigning a new ID number in a Query (Access 2002)
How To Print a Line Feed Imbedded In Memo Field? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Failed ADO Connection (2003)
Confirmation about transferspreadsheet. (Access 97 SR2)
Crosstab Query (2000)
Combo Box Question (Office XP)
Max value (Access 2000)
Referencing subform object (2002)
saving frm name in global variable (A2000)
Formatting Medium Time (Access 2000)
Importing Excel Wkshts with Dynamic Ranges (Access XP)
Alternate records/Colour Change (97/2000)
DoCmd.OpenForm in add mode (A2000)
Confirm Action Queries (Access 97)
Calendar Control to Set Forms Dates (2000)
Import Text, Automatically Divide by 100 (97)
Null Value in a query (Access XP)
Linking To dBase Files (Access2000 sp3)
Plotting points on a form (A2k3)
Record Locking (Access 2000)
Sunday Dates (Access 97)
Startup Form Displayed in Add Mode (Access 2000)
Len(combobox) <> 0 but should (A2k3)
Access Corruption (2000)
Use Query Prompt Value in Report (Access 2002, SP2)
Combo box filters (2000)
Condition for tab control's form events doesn't wo (2000)
SQL (2000)
Training Template (XP-SP2)
Need Recordset Advice (2000)
Control+Break (AccessXP)
See if a directory exists (Access XP)
Access 2003 crashes (2003 all updates)
No Data msg for Subreport (Access 2000)
Date Query (Access 97)
SQL Server Security and Access front-end (SQL Server 2000, Access XP)
Select Query Problem (A2K SP-3)
dropdown field not working (97 NL)
project locked (2000)
form based query chk boxes (A2000)
Validation rule (2000 SR-1)
Annual deletion / creation of tables... (2003)
Calculated fields as criteria (2000sp3)
Floating Fields (2002)
Field order in a datasheet (Access 2000)
Access Objects not visable (2000)
Date format pulled inconsistently by user (2000)
Error accessing file. Network connection... (Access 2000)
Displaying counted information (2000)
Breakdown to Show Regular vs. Overtime Hours (Access 2000)
VB Code (2000)
Access RunTime (XP)
Next Active Control (Access 2000)
Adding Code Criteria (2000)
dynamically assign Distinct (a2000)
probelm with ACCESS 2000 (win 98 s.e. )
Macros on a Form in Access (Access 2002)
Finding & Deleting Record in Subform (Access 2002)
multi-user environment (Access 2000)
DAO Troubles with 2002 (2000 to 2002)
PivotChart View (2003)
Passing Variable to SQL (XP)
Create text file from table content (A2K Sr-1)
Group 'Other' items not in the 'Top 5' (XP)
comparing the structure of 2 tables (Access 2000)
IIF syntax (A2000)
Query Assistance (XP)
report & query help (XP)
Crosstab Query - Multiple Totals (A2K SR1)
Date calculation in Not In statement (2000/XP)
Selection Queries (A2K SP-3)
Open Access db (MS Access 97)
Can't Get Word To Open (Access 2000)
Run code in db1 from db2
Linking tables in SQL (Access 2000 (9.0.6926 SP-3))
setfocus without selection (97 NL)
other focus on new record (97 NL)
error end of statement (Access 2000)
Clipper (2002 (10.2616.2625))
DAO error (A2K)
Create New Record (Access 2000)
Link to another DB (2K)
Recordset not updateable (2000)
Opening Form (2003)
combo box/macro combination on form (xp)
Yes/No Options (2003)
Using functions in query criteria (XP)
DLookUp (Access 2000)
File Open but not Visible (2003/(11.5614.5606))
Autonumber of sorts (2003)
Deny users the Filter option (Access 2002 /SP3)
Report Names (2000)
how to cut off dates (Access 2000)
Default Values in Text Fields (2000)
importing Groupes (2000 sr-1)
Database Opening (2000)
network corruption (A2k WinXP)
Subform Help (2002 SP-2)
DataEntry (Access03)
Checking Recordset Recordcount (2000)
complicated price structure (2000 SP3)
Add a record on the Fly... (2000)
Code for multiple controls (2003/XP)
Execute macro via command line (Access 2002)
Union Query Sort (2002)
Disable Click for Switchboard Labels? (97 SR2)
Variable Length in Form's Text Box (Access 2002)
Security (2000)
Question On Union Query? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Restore button (2000)
Button for Filter on Form (2002, sp2)
Preview report - keeping focus (2000)
blnEditMail (2002 SP-2)
Query (ACC2002)
Spurios parameter prompt (Access 2000)
Query Criteria (XP)
Subform in form view, not datasheet (Access 2000)
Report Export to Text File (Any Version)
Table values (currency/number) (2002 SP-2)
code - concatanating various elements to make ID (Access 97)
Import data from other .mdb (97 or 2000)
KeyPreview - Shift, Alt, and Ctrl (97)
crosstab query (and report) (2000)
report page layout won't stick (2000)
unbound control synched to active page on tab (a2k)
Is there a way to lock the data in Access? (Access 2000)
Mainly a Rant (2002)
If then Statement in a field (2000)
Group Membership (Access 2002)
Have a report call a combo list box for the report (2000)
button on click (2000)
2 Identical Tables - 1 for a History (Access 2002)
relationship tangle (a2k)
subform not synching (a2k)
Printing phone numbers in Access 2002 (2002)
Min Popup (2002 SP-2)
Record positioning (2000/XP)
Accumulation of Amounts (XP)
Listbox to Textbox (VBA/Access/2002-3)
How to Count RowSources in a ComoBox? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Search box failing (XP/2000)
Information lost in forms and reports (Access 2000)
Query returning 0 (2002)