Windows Secrets
Windows Secrets Lounge
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)
Access is filling in numbers in table (A2002 (SP-2))
Browsing for file (2002)
Add Colums to MS Access table (English/Access/2000)
Access to Excel (2k)
Hyperlink error (Access 2000)
Force Proper Case in datasheet (Access 2000)
AutoExec Macro (A2k)
Select Case statement (2002)
UDB Linked Tables (MS Access 97)
Cross Tab Query (A2k)
Joins (A2002)
Invalid operation in code (Access 2000)
Counting Query (Access 2000)
on event? (XP, 2000)
Using Worksheet Functions in Access (Access 2000,
Report from linked Excel file (2002)
Query to Total by Year (2002)
Import any available forms (Access 2000)
OpenForm action (2000 SR-1)
NotInList Event Doesn't Save NewData on Form Close (2000)
Varying server locations problem (Access 2K Win 2K)
Query Specifics (2000)
Subform Loading (Access 2K)
Access2000 Command Buttons (9.0.4402 SR-1)
Calculating Days (Access 97)
Query count (2000)
Preview Reports (Access XP)
Compare two fields (2000)
Report Question (2000)
Date (Access A2002 and A97)
Run-time Error '2105' (2000)
Mail Merge from Access (Access 2000/Word 2002)
GetWorkDays - HELP (2000)
Access ADE file (XP)
Calculating hours (2000)
Adding a report (a2002)
Security (Access 2000)
Select and Deselect Records (Access 2k3)
Modified Date (All versions)
Record 'indicator' on SubForm? (XP pro)
Display Date With Leading Zeros? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Need Proper Query Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Query won't work (Access 2002)
Forms -inserting values (Access 2000)
Reset AutoNumber (2000 sr1)
Populating a form via combo box (2000)
Query Age (Office XP )
calculator active x (access 2000)
Access 2000 (Forms & Reports Field)
Kill database (Access 2000)
Cross DB query (2002 & 97)
pull down combo (A2000 SR-1)
Form based on multiple tables (XP)
Add one to previous record (2000)
Add New Record (Access 97)
Insert Into *** Select ** from (Access XP)
Email sections of a access report (Access XP)
chi square (xp)
Form Re-Writes (A2K)
Workgroup problem (WIN 2000 Acc 97)
Split satabase slow (Access 2000)
Can't select default datasheet font (Access XP)
Swollen dB (2000 on windows xp, sp1)
Calculating a date (Access 2000)
Trim won't compile (95 to 2000)
Visible = False for value in subform (2002/XP)
Count the number of files in a directory (Access XP)
variable not defined (Access 2000)
Printing Forms (a2002)
Running Query from Form (Access XP)
fractions (access2000)
VBA Coding (A2K)
Check for the existence of a query ? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Show a Webpage on a form (2002)
Linked Table Manager (v2000)
Suppressing Update/Append Query Prompts (2000)
Missing References (Access XP)
Add rec. Form (2002)
Looking For Correct Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
PC Name/Network Name (Access 2000)
ADP hooked up to MySQL (A2k2)
New (Blank) Record at Top of list? (Access 2000)
Copying data (Office 2000 on WXpHE)
Change DB format programatically (Access97 / 2000 and later)
Copy / Past FE (Access 97)
Microsoft Script (Win 2k Office 2k)
time calculations (A2002)
FileSearch Object, Execute method (Office 2k win 2k)
Mathematical formulae (2002 (10.2616.2625))
Data Validation (Access 2000)
Up date not working (A2002)
Monster slow form (XP sp 1 on Windows XP)
Open a rpt & sub rpt using alternate query (2002 SP2)
Automatically Entering Info In Unrelated Table (Access XP)
Auto update combo boxes (2002)
Convert numbers to words (Office XP-SP2)
query on multiple tables (XP)
Delete Permissions (Access 2002, SQL Server 2000)
Linking Tables (Access 2002)
Linking to Excel (2000/SR1)
Understanding a form (XP)
Duplicating a Record Problem (Access 2000 (9.0.6926 SP3))
Exclusive Access to linked databases (Access 2000)
Listbox with event (Access 2002)
Compact/Repair Problem (Access97 on win95b)
Linked file and server access (2000 - SR-1)
Hyperlink question (Access 2000)
Join Query ? (A2K SR3)
Relationships (Access 2000)
Open Form to Specific Record (Access 97)
A quick tip - implementing ZOOM on a form (Access 2K, Win2KPro)
Rid me of Access error msgs (2002)
Inserting .tif files (Access 2000)
Unable to assign a value to a form object (Access 97 SR2)
Parent/Child SubForms, etc. (2000/2002)
Obtaining greatest Y for each X (Access 2000)
Merge data from two fields (Office XP)
Formula for Age (Office XP )
Paste a Word doc into a form control (Access97)
SLOW!! (XP/XP vs 2K/2K)
Best Way To Manage Open Forms? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
IFF statement (Access 2000)
export problem- invalid use of null (2000/sp4)
DoCmd.OpenForm (popup form) (2000/SP3)
Grouping Objects On Form (2000)
Allocating records proportionately (Access 97)
Update problem (2000 SR-1)
Pasted data from an Access Crosstab Query to Excel (Access2000 (9.0.4402 (312719) was moved to the Excel board
MDB File Version (Jet)
Error codes (Access XP)
Query problem (Access xp)
DateDiff (Access 97)
Access Dates (Access 2000)
double subforms (Access 2000 SP-3)
Date Range for Reports (Access 2002)
combo box order (Access XP)
Dates into Month's (2000 - SR2)
Absolute value (2000)
Form & Subform 'Undo' (Access 2000)
List Boxes (2000)
Recordsets - book recommendations? (2000 XP)
Test for New/Existing Record? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Bound object frame (2000)
Dates, vb and odbc (XP sp1)
Access Error - Unknown (XP / 2002)
Print one record (WXP Access 2000)
Access Query's and Reports (Access 2000)
Conditional Formatting in Report (Access 97)
Converting Access 97 to 2003 (Access 97/2003)
Jet engine update (Access 2003)
opening multiple copies (2002)
E-Mail Form (Access 97)
Don't display Cotton Pickin ToolBar (2k)
TopValues (2000)
Access to Excel (Readonly) (Access 2002)
Defaults (A2002)
Controlling Sub Reports (Access XP)
Add file link (A2002)
CanGrow property limited for report text controls? (97SR2)
For each.... (Access 2000)
Paste append minus figure (Access 97 SR1)
List Box Control Syntax (WXP Access 2000)
Missing/broken cx.ocx file (Access 2002 on WinXP SP1)
Page numbers (2000)
Enabling/Disabling Fields (Access 2000 SP3)
Access Snapviewer (2002)
Need Correct Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Reports To Word (2000 SR-1)
RecordSet not working? (Access 97)
packaging access db (2002)
Image List Control (A2k)
If IsOpen avent (Access 2000)
Simplify function (Access 2000)
Setting a form's size (2000)
Hyperlink (Access 2000)
OnClick Select All & Copy (XP &/or 2003)
Tab Order (XP)
Formatting a Report (Access XP)
Sending Form via E-Mail (Access 97)
crosstab query error message (A2K)
Combo Box -Bound columns (2002)
Define Ages (Access 2)
Stored Procedure Names (Access 2000 (9.0.2720))
Adding data to field (2002)
On Current with Combo box (Access 2000)
Report printed notifier (2002)
Importing Large Word File (Access XP)
MS Access Switchboard (SR-1)
Summarizing Yes/No data (MS Access 2000)
Setting Report Filter property using Macros (XP)
Currency Fields (WXP Access 2000)
Automation Error (AccXP SP2)
Function With acDialog (A2k)
Min, Close Buttons don't show (XP)
making a table from a crosstab query (Access 2000)
Danger Exporting to Library Database (A2K (SP-2))
Add an entry to a combo box (Access 2002 (XP) SP-1)
Query (2000)
Saving current record (Access 2000)
Graph With Data Table (Access 2000)
Last page (Access 2K)
Need to make a Weekly Report (2000)
Export query to csv file (Access 2000)
transfer text problem (Access 2000)
Calendar (A2k)
Pivot Charts work on some computers but not others (2002/3)
References & Tab Order (WXP Access 2002)
report/ subreport parameter issue (A2k)
Expression/Function Syntax Quick Reference Sheet? (Access 2002 SP1)
Mouse Right Click (A2k)
Combine (2) Case Selects (Access 97)
Table Design Help For Study Contacts Database (Access 2003)
Zoom a field (Access XP (2002 sp-1))
System Test Date (Access XP)
Runcommand acCmdMakeMDEFile (Access 2000)
Generating a Calendar (Access 2000)
Auto fill (2002)
SQL Backend (2k)
Allowing users to decide what columns show (XP/SP2)
Listbox Move Up or Down (Access 97)
Import info to multi-table database (XP pro)
Sample Total (2000)
Grouping & showing totals on each in a query (XP/SP2)
Print Screen? (A2k)
SetFocus question (Access XP)
AccessXP Query Question (AccessXp)
id numbers (AccessXP)
Access Size (Access 2002)
Currently Locked Error (Access 2000)
print Word doc within Access report (97 SR2)
Drawing a line (Access97)
AccessXp Database Object (AccessXP)
No Data on a Form (Access 2000)
Reference to a Field (2000)
MDE Error (A2K)
datepart (97 sr 2)
Union Query (Access 97)
force mixed case in textbox (2002)
input mask problems (2002)
DoCmd.OpenForm problem (2002)
Hyperlink Function (WXP Access 2002)
Sort order ina form (xp)
text value contain # sign (2002 SP1)
Finding existing databases (Access 2000)
Datasheet Subforms (2000)
Currency Field (A2k)
Return value if file is not present (A2002)
Merging databases (Xp sp1)
Create fields in table (Access 2000)
Image Display (WXP Access 2002)
Calculated Field (2002)
Recordsets (Access 97 SR2)
Eureka! I have found it! (Access (All))
First of month entry in Form (Access XP)
Help needed parsing string... (97 SR-2)
Query to return only one value (2000/2002)
Query Returns Null (A2k)
Seems like a day for combo's !! (A2k)
query last record (Access 2k)
User level security on multiple computers (2000/2002)
Security - Multi User (Access 2000)
forms not recognized (2002)
Sort order/Filtering in a list box (XP)
Combobox dropdown (All versions)
Excel file type not available for import (xp)
Search function (Woodys)
Default Values for Report Parameters (Access 2002 (XP))
Bound Object Frame (Acess 2003)
Two Questions (Access 2000)
Keyword Search (A2K)
Best Way To Use Access via Web Pages (2000/2002/2003)
Export table to text file (Access 2000)
positive & negative values (Access 2000)
Prospective users do not have Access installed (Access 2000)
Statistical Data Calcs on Form (Access2000)
Clearing a Field (OfficeXP)
No right-Click Menus (WXP Access 2002)
Missing Operator (A2k)
Expected End of Statement (2000)
Dragging report onto Word document (XP & 2000)
Get File Name Routine (WXP Access 2002)
Have 'Continue' in Group Header (Access97)
List of Databases (Access 2000)
Assign Value to a Report Control (97)
Error (Access 2000)
How to force N digits in a field (2000/2002)
Sorting (2000/SR1)
Hide Control (Access 2000)
Permissions or untrusted site (Access XP)
Create lookup field in remote table (Access 2000)
Combo Query With All? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
acFormat (Access 2000)
Export Query with Short Date (XP)
SQL Statment (2000)
Query from Mulit-Selection List Box (2000)
Windows in taskbar (ACCESS 2002 10.43 SP2)
Converting Text to Number (A2K )
Return value from subform (A2k2)
Move to the next record (Access 2000)
Exporting Graphs to Powerpoint/Excel (XP)
compact on close (XP)
Code Advice (A2k)
Last record (Access 2000)
Page numbers (Access 2000)
Calculations (A2002)
Outlook contacts - view from Access (OfficeXP)
database location property (2000)
Form total problem (Access 2K)
Draw Enries (2000)
Multiple Criteria (MS Access XP)
Parsing (Access 2002)
Automatically change Startup properties (Access 2000)
Working with text and numbers in a union query (2000(SP3))
Display memory being used (AXP)
Spell Check on controls (AXP)
Difference between dates-exclude weekends (2000)
boundcolumn (Access 2000)
Passing variables from a form to a subform (2000)
Get rid of Middle Initial (WIN 2000 Acc 97)
Show New Autonumber (2002)
Date Input Masks (Access 2002)
Access/Outlook and SR2 (Access 2000, Outlook 2000)
Write conflict (XP, sp2)
Access Project Security (Access 2000 / MSDE)
Tab Control (Access 2002, XP Home)
SQL Where clause (2000 SP3)
Tracking students (XP & 2000)
Rounding Problem (Access 2000)
Fields in Table (2000)
Date picker control (AXP)
Return Sunday date of week selected (AXP)
Display query criteria in report (Access2002)
Calling another routine (AXP)
Update Combo Box list with new entries (MSAccess2002)
SQL server loading (Access XP/SQL Svr 2000 SP-3)
Table Structure (2000)
XP Developer (XP+A2K)
Update links (2002)
Office and Windows Compatibilities (Access (All))
compile error (A2002)
Strange error message (Access 2000)
incorperating a combo in a query (A2000)
Trouble With Listboxes (Access 2000)
Cannot open any more databases (A2k)
changing table names (97 sr2)
ASP? (Access 2000)
Setting Print Menu Options (Access 2000)
Formating sum function (2002)
Making a Flat File (Access2000)
Drop Down Selection Changes (Access 2000)
return name of active page of tab control (2000)
Referencing 2 query name instances
Combo in Query (A2000)
Macro Security warnings (Access 2003)
Set Permissions (Access 2000)
Opening Report with new recordsource (Access 2000)
clear a control in a form (access 2000)
Viewing a Form on the FULL SCREEN (Access 2002)
ODBC (NT 4 server)
Invalid cancel event (Access 2000)
Records Refresh in VBA (2000)
Start Record Rpt on Odd Page (Access 2002 SP-1)
updating table information (A2002)
strategy advice part 2 (A2002)
strategy advice part 1 (A2002)
strategy advice part 3 (A2002)
Creating Excel Workbooks (2K) (2000/SP3)
Report Field (2000/SP-3)
Formatting (Access 2000)
Simplifying processes (A2002)
Creating a Query Form (Acess 2000 SR-1)
Make the user select from combo box (Access 2000)
Counting in Reprt (2000)
VBA/DAO problems (2000 SR-1)
Tags (2000)
Updating database from 2000 to 2003 (2000/2003)
Import from Outlook (Access 2000)
Table Def Question (XP)
Error Message (A2002)
Query to Form (A2k)
Sum Formula (Access 2000)
Design issue (XP)
Populating field (Access 2000)
Publish it with Word (Access 97)
Sales report details (Access 2000)
Design Ideas? (2000)
Referential Integrity (2000)
Using query results in VBA (Access XP)
Defining a query parameter (2000)
counting field in a list box (Access 2000)
Search Key (Access 2000)
database conversion hell (AccessXP)
Alternate option for Autonumber (2000/XP)
Query leaves out info (2000)
Move cursor (AXP)
Cant locate backend (W2K)
Force new Sheet in report (Access 2000)
File Locking (Access 2000)
Hours & Minutes (Office 97)
Create Windows Folder (v2000)
post 300492 (Access 2002/ Windows 2000 svcpk3)
Asterisk in queries (2000)
Adding Records (2000)
Password hide (2002)
Update or CancelUpdate without AddNew or Edit (A2K
run-time error 3349 (A2000 SR-1)
Text Formating (2000)
DSum snafu (AXP)
Clearing fields (Access 2000)
Function (Access 2000)
CrossTab Query as a Report Data Source (97)
Compile to executable (2002)
Boolean Text (A2k)
Tough query (WIN 2000 Acc 97)
Selecting Initials (XP/2002)
Wildcard Usage (AXP / VBA)
EMAIL Follow Up (XP)
Creating Email from text box (XP)
Persistent Connection? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Form-level validation (XP sp1)
Calculating the sum and average of fields (2002, SP2)
autofill using unbound text (A97)
SLOW!! (Access XP, Winsows xp SP1)
Common File Dialog (A2K)
Map A Network Drive (Access 97)
Highlight Label on frame (Access 2000)
Switchboards (Mic office 2000/Access)
Update Table after Updating Another Table (2000)
dlookup (2000)
supress err.descirption message (Access 2000)
denoting tables (2000)
ODBC Connection Issue (Access 2002)
Append or Update Query (2000)
ODBC call failed error (AXP)
Conditional Formating (97/2K/2K2)
GoTo Control Macro (2000)
Slow Closing Form (2000)
enabled property (2000)
Best Font (A2k)
linking an Excel file (Access 2002)
opening db to form (access 97)
Blank page problem (Acc2992 W98 SR2)
Requery a list on form from a subform (2000)
Duplicate Records in Query (Access 2002, XP Home)
Suming a filtered text box. (access 97)
Maximum number of records in a table... (97 SR-2)
Looking for the best way to do this.... (AXP)
ISAM SEEK Problem (2000)
DT Picker Problems (AXP/A2K)
Custom MenuBar (2000 SP-3)
text file from Access (Access 2000)
Combo Box Parameter? (Access XP)
Julian Date (2000)
Two tables (97)
OnChange event (Access 2000)
Finally, cost of Visual Studio Tools (Office 2003)
Subform (A2k)
Tab Control (2002)
Frames (2000)
Subreport Problem (2000 SR-1)
query help (access 97)
Using RecordCount in a Module (Access2K, Win2KPro)
Check box entries into text field (2000 SP3)
Count Records (XP)
running sum in a query (access 2000)
show list of the databases (Access 2000)
Moving item around on form (AXP)
financial ledgers (Access 2000)
Read Only (A2000)
Update using an Aggregate function (Access XP)
disable a control on a subform (AccessXP)
Update subform (Access 2000)
User level securiti will not work (MS Access 2002)
function to create zipped database (Access 2000)
Form Modification Indicator (A2K)
How To Move Code To A Query? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)