Windows Secrets
Windows Secrets Lounge
subform question (Access2000)
List Box (Access 2000)
Calculations (Access 2K)
crosstab query (access 2K)
scheduled accecss procedures (W2k, Office 2k)
Query Advice (WIN 2000 Acc 97)
Auto-Update Form Based On Different Table (1)
Access/Query (2000)
Filter for combo box (Access2000)
NumLock (97 SR2)
Date Projections (2002 SP-1)
Network (A2000)
Counting [mon]days between two dates (2000)
Linking SQL Server tables (Access 97/2000)
Populate Listbox (A2000)
GoToRecord - Why does it FindNext? (Access97/SR2)
Best way to handle a date field? (Access 2000 SR1)
Date() (Access 97)
Problem with 'permissions' on an Access back end (A2000)
DateAddWorkingDays taking Holidays into account (2000)
Security problems when using Outlook Object (AXP / Outlook 2002)
Combo box in Acceess (re-visited) (2002)
Calendar - populate with records (Access 2000)
Index in a Query?? (Office 2000)
Adding to Tables (Access / '97)
syntax error on conversion (a2000)
Count Business Day (Access 2000)
Bookmark function (AXP)
Name and Save New Module (Access 97)
Editing/Adding Records (1997)
Duplicate Data in Report (A 97)
Split Database (97 /sr2)
Scrolling records (97/sr2)
Tracking chart history (97)
Hiding Menu Bar (1997)
Combo Box code (Access 2000)
Automatic Unique ID Assignment (Access2K)
Microsoft Date Time Picker (Access 2000)
Removing spaces and dashes (Access2K)
Missing FileSearch Object (Access 97SR2)
How To Add 10 Work Days to Posting Date? (a2k (9.0.3821) SR-1 Jet 4.0)
Query Year (MSOffice 97)
turning off a warning (AccessXP)
Carry Forward data to Next Record (ACC97 - SR1)
Combo Box (ACC 2K)
How To Pause Code until Operator Closes Print Prev (a2k (9.0.3821) SR-1 Je
Show query filter in report (97)
URL in a report (2002)
Form default view (AXP)
multiple reports - one subreport (Access97)
XP database to 2000 (Office 2000 SP3)
Startup Form in A97 (Access 97)
Sort order questions (97/SR-2)
Unrecognized Database Format (Access 2000)
Using Autonumber for too long (Access 2k2, VB6)
Searching everything (Access 2000)
97 to 2000 error ( 97 to 2000)
Access hangs on WinXP (Access 97/2002)
Forms--Tabs (1997)
Multiple subforms (Access 2K SR1)
OpenForm Dialog mode (Access 97)
Graying Out Fields (Access 97 SR2)
Current Year (A2000)
Maximum number of users (Access 2000)
multiple copies of a report (AccessXP)
Is form maximized? (A2K)
Grouping Controls (A2k AR1)
Exporting to Excel (w2k)
Mail merge connection (Access 2000)
References - failure to update (Access 2000)
Datatype - SQL Server to Access (Access 97)
Report footer problem (A2k2, SP2)
Union Select (10.4)
IF Then to display label (AccessXP)
report : order section (Access 2000)
ZIP code combo box (XP)
query-by-form problem (a2002)
query-by-form (A2000)
string within a string (A2k2, AP2)
Sub reports (AccessXP)
Error with mde but not mdb (2k)
Quarterly grouping (AccessXP)
Query running too slow (WIN2000 5.0SP3 ACCESS'97 SR2)
disabling query messages (XP)
'today' in form field (Access XP SP-2) (230469) was removed
Switchboard Form (Access 2000/2002)
Search box error (2K)
Form size and position viewer as add-in (2000/2002)
multi-selection list box on a form for a report (2002)
Help unavailable (Access 97)
still need help (Access2000)
Export? (Access 2000)
Report problem (Access 2002)
uncommitted value (Access 97)
Age Date (Access 97)
Minimize App on run (2000)
Search for wildcard character (Access 2002 sp1)
NZ function in a query (AccessXP)
Create table from recordset (2000)
update field from combo box (Access2000)
Select Case (AccessXP)
need a lesson on relationships (2000)
Define a variable using a SQL statement (Access 97)
Need Code to Loop and Copy Objects to New MDB? (A2k (9.0.3821) SR-1 Jet 4.0)
Error #Name? (Access 2000)
Listboxes - deselecting an item (Acc 97 SR-2)
Link Tables - Read Only (Access 97)
'Find' (Ctrl F) No Longer Works! (Access 2002SP-2) & 2000)
Spell Check Form (2002 (XP))
Repositioning with VBA (AccessVB)
Report Record source (A2K (MDE))
searial noumber (2k)
Prior day Now()-1 excluding weekend (2000)
Access 97/2000 Compatability (Access 97 SR-1)
Sharing DB over Internet (W98, Acc97)
Attaching shortcut key to form buttons (XP)
Not duplicating data entry (2000)
Combo box in Access (2002)
Sunday Date return (AXP)
'Access 11' Beta (''A11'')
Archives (All)
Printing a form (Access XP)
Access 97 won't run under Win XP Pro (Access 97 SR-2)
looping through fields (Access 2000 SR-1)
Pivot table Wizard error (2000)
New form using ID# from original form (Access XP)
multiple openreports (2000)
replacing constants in a string (Access 2000)
Word Wrap Control Tips (Access 2000)
I've Lost a Form! (Micro.2000/Access)
MSys(tables) (2000)
Compile Error (windows 2000/access)
Query showing a chosen month ? (Access 2000)
subform - requery (2000)
Can i export string to Excel ? (Access 2000)
Linking Created Form Fields back to Table (Access 2002)
Filtered data into Preformatted report (97 and 2k)
Count unique values in a field (2000)
OpenRecordSet Doesn't Make all Records Visible? (Access 2000 SP2)
Adding entries from table to another using a form (Access 97)
Simple Form Interface, complex code (Access 2000)
Can I break one table into several? (Access 2000)
date field start left side (2000)
Report using critera entered list box (2000)
Lost property in Access 2002 version (Access 2K2)
Importing to a Table from Excel (A2K)
Currently Locked Can Not Update (Access 2000)
Opening a database (2000)
Opening database (Office 2000)
Zipping files from within Access (any)
Text Animate (A2000)
Working with Undo (Access 2000)
Function Angst (XP)
Error 3191 (XP)
Navigation Buttons Label (2000 SR-1)
Access 2.0 lost password (Access 2.0)
Setting for creating a Report (Access 2000)
Expanding a form (AccessXP)
Adding entries from table to another using a form
Union query/macro/report help (Access 2000)
What causes .mdb file to grow? (Access 97)
Preview a Report on a Form (2000)
Report Settings Differ By User??? (2000)
Problem moving Access 97 app to newer versions (97 Sr-2)
Starting new record in subform with VBA (AccessXP)
Application Window (Access 2000)
How Security Works in Access 2K (Access 2K, VB6)
ADODB Recordset - memory like a fish (Access 97 SR2)
How to Print Right Most 2 Characters? (A2k (9.0.3821) SR-1 Jet 4.0)
Unique Number (Office 97 SR2)
Designer Background (A2000)
Combine query results for report (A2002)
Access Design
Problem feeding information to table. (AccessXP)
Locked database file (2002)
Access quary (97)
Suggestions.... (97 SR2)
97 - If Null Then.... (97 SR2)
Query problem with language (97 SR2)
Splitting Fields (2K & 02)
Access 2000 (9.0.2720)
Sending E-Mail from VBA (97/sr2)
Update Table (2000)
Subform Not Open (A2k SR1)
Importing into Access (Dates, sorta) (Access/Excel 2000)
Combo, Parameters, and SQL queries (Access 2002 SP1)
font color in table (2000/XP)
Hiding toolbars (A2k)
Relationships window (97)
SQL syntax (A2000)
Blank Subform (97)
Active X problem (2000)
Change Field type from code ((Access97, SR2))
Creating Menus (XP)
Show listbox value on report (2000)
Auto Size (XP)
capacity (a2000)
Calendar Problem (A2K SR1)
How to Move The Cursor After Entering A Character? (A2k (9.0.3821) SR-1 Jet 4.0)
Conditional sub reports (Access 2000)
Access 2000 (2000)
Yes/No in query (A2000)
problems with Me.RecordsetClone (97)
Memo Zoom (97-2002)
How to Display Age of Date in Query? (Access 97)
Conditional Formatting (Office 97 SR2)
Email Pop-up dialogue box (Access 97 SR2)
Create an on-call list (Access 2000)
Highlighting the active field/record (A97/SR2)
Pass Criteria from Disk File (Access 97 SR-2)
making an access panel (access 2000)
how do i convert data in table format to a form (access 2000)
Headings for Snaking Columns (Access 2000)
Queries & listbox row source (Access 97)
Counting specific records in reports.. (Access 97)
SENDObject works with Eudora but not Netscape Mess (Access 2k)
Report Crashes (Access 2K SR1)
Import from Excel (Access 2000)
Converting a report to Word (2000)
Updating References (XP)
Making a tab invisible (Access 2002 sp1)
Need Record Count? (A2k (9.0.3821) SR-1 Jet 4.0)
Adding info to a Form (Access2000)
Combo (A2000)
Catastrophic Failure (SQL 2000)
HELP!!! Filtering data (Access 97)
Apostrophe Problem (A2K SR1)
Check if a form is already open using macro (2000)
query error (A2002)
Trying to use 'LIKE' (A2k SP2, DAO)
survey (A2002)
Totals (Access XP)
Determining name of parent form (Access 2002 SP1)
Reports - getting multiple copies (AccessXP)
Visible/Invisible text boxes (2K & XP)
Adding records slowing down (Access 97 SR2)
Problem happen after setting Security click event (XP Access)
Control Source (Office XP)
Summing within date parameters (Access 97)
AccessXP. Runtime. How to install SP (AccessXP)
using a totals query to feed detail to a report (2002)
Remove Duplicates (2000)
JET SQL Permissions (XP)
Query vs set focus (All Versions)
Displaying new records in a sub form (Access 2002 SP-1)
Event tracing (Access 97)
I think this is a Top Values question.... (Access 2002)
Database window (A2K)
Missing Data (Access 2000)
parameter in crosstab query (A2002)
Deleting Records (VB ver6)
Having Relationship problems -access relationship! (Access 2000)
Access 2K won't open in XPhome (2000)
Fill in info in form based upon drop down box (Access 2000/Win 98)
Remove empty lines from table (AXP)
Using INSERT INTO with more than one table (2000)
Reading Inputmask and descriptions in VBA (2000/XP)
Append Query (Access 2K)
Mail Shots (2K)
RefreshLinks (Access 2000)
Type mismatch in expression (Access 2000)
Date format and regional settings (A2K SP3)
Runtime for 2000/2002 (2000 SR1/2002)
Query will not work with 2003 data (97-SR2)
One to many - Multiple field keys (Access 2002/SP2)
Procedure declaration (XP)
Shift Tab (XP)
Snapshot Reports (Access 2002)
Control Source problems (AccessXP)
ambiguous joins (msaccess sr-2)
Deleting duplicates (97)
database hangs on print (Access 97)
problem using Access remotely (Access 2000 9.0.3821 sr-1)
Finding the average of a series including nulls (2000)
exporting data to outlook (access 2000)
Find dialog (97)
Storing last modified (97)
Error message oddity (Access 2k)
ADO linked tables (Access 2000)
Have one Multi Select Listbox Drive Another (A2k SR1)
AfterUpdate event (AccessXP)
Crosstab queries in SQL (Access 2000)
Status Field (2000)
Relinking tables (Access 2000)
Access and VisualSourceSafe (XP SP1)
Access Report -making columns (Access 2000)
Function to sum certain data (2000)
Breaking Access Table Link (Access 97)
Option groups feeding criteria to a query (AccessXP)
Looking for an approach to a problem (AccessXP)
Record source default (Access 2000)
Can i make a string constant? (Access 2000)
Treeview and expand event (Access 2002)
Incrementing Date Field (2000 9.0.2720)
hyperlink in access - transfering to word format (Access 2002/Word 2002)
ADO Seek Function & Array Help (2000)
Append query headache (2K and XP)
Emailing a Form (Access 97)
WorkEvents Tracking (1)
database window (AccessXP)
Limit Records (2000)
Nudge is too big in XP (XP SP-1)
VB help wonky (XP SP-1)
Delete query (Access 2000)
Combobox newbie (Access 2000, SP1)
Vanishing Labels (A2k SR1)
Query Question (2.0)
WinFax Automation Code (Access 2000)
Open Form and pass a value as a parameter (Acess 2002)
ComboBox (2000)
Input mask--using Initial and Middle Name (2000 & XP)
Relationships (2000)
How to tell if a database is compacted (2000)
Pauseing a Macro (2000)
OpenRecordSet method, HELP!!! (Access 2k)
List the queries to a file (Access XP)
Saving record in sub forms (access xp)
cursor type in ADO (Access 2000)
Weekday names (XP)
Count report groups (2000 SR1)
docmd.PrintOut (Access97)
How To? Create temp recordsets (Acc 97 sr2 on 95b)
Table/Form design (2000SR1)
Query problem (Access 2002)
SendKeys '%(TDC)' quit working (2000)
Using FileSystemObject to upload Word docs (Access 2000)
Collecting credit card numbers (XP and 2000)
Inventory Receipt To/From Stock (Access 97)
ExportTo File Specification (Access 2002 sp1)
listbox items selected property (2000)
FileSystem Query (Access 2K/Win 2K)
REfresh Recalc etc (2K/XP)
Coding for OLE Objects (Access 2000/97)
Typamatic field (Access 2000, SP1)
How inefficient is this? (FPDB-ADO) (A2000/Jet4/SQLServer2K)
Textbox Margins & Vertical Scrollbars (A2K/AXP)
String Alignment (2000)
ADO or DAO (Access 2000)
How to create a System DSN w/o ODBC Data Admin (Win2K/Access 2000)
Importing Data From an Excel SS using VBA (Access 2000 SR1)
Forcing a blank page in report (Access 97)
Using IIF statement with a crosstab query (2000 SR-1)
Access ADP query query timeout (Access 2K, SQL Server 2000)
query a combo box (97)
Nulls in Crosstab queries (Access 97)
Possible SQL ! (A2000)
ADO Index & Seek method (VB6 / SQL Server 7.0)
Table link (Access 2000)
Northwind Employees (Access 97/2k)
Exporting report data to word (A2k2)
Access for PLC interface (Access 97, RSLinx)
Select form from within another form (Win ME/Access 97)
Make a date string to be stored (A2K2)
Decompile (222192) was removed
Table not updating (XP)
Northwind Customer Orders Question (97, SR2)
Select maximum value from fields in a row (Access 2000)
Input mask - City (2K and XP)
Determine Window State (Access 97 SR-1)
Query (Access XP)
Combo List column not populating when chosen (XP SP2)
Totaling Yes/No Data Type Field (2000)
Date Formula (Access 97 )
Change Field size in a query (2000)
MultiSelect Listbox (A2k)
IsNull statements (Access XP)
Popup menu differences (2000)
Missing Semi Colon (A2000)
mostly distinct rows? (xp)
Turn off Default Message. (A2000)
IE Favorites Management (1) (221619) was moved to the Internet Explorer board
Run a SQL Server DTS from Access (2000)
Who Can Help Me With JetComp? (A2k (9.0.3821) SR-1 Jet 4.0)
Access/Visio VBA (A97 SR2+V2K)
Variable to get Form Name (XP )
Multiple Criteria - Conditional Formatting (Using Access 97 SR2 )
DSum dates (Acces97SR2)
Access freezes when checking References (Access 97)
Recordset Problem (Acc 97 sr2 on 95b)
copy and paste by code ? (Access 2000)
VBA Line Continuation Annoyance (Access 2000 (9.0.4402 SR-1))
MultiSelect Listbox - Refer to Column? (2000)
Adding leading Zeros (Office/Access 2000)
Configuration of Split DB (AccessXP)
Run-Time Error 'Row handles must all be released' (2000)
Form Data Entry (A2k SR1)
Hyperlinks/Email addresses (97)
Access template (2K and XP)
Lookup Table (A2000)
Text Table Query (Access 97)
stop the execution of a function (Access 2000)
Skew (w2k)
eliminate duplicates (2002)
Using subform control values in a mainform (A2000)
Data type error (2K and XP)
Register Control (A2000)
Querying record lock details (Acc 97 sr2 on 95b)
Screenjudder (Access 97 SR2)
Using data on a subrpt in a calculated control (AccessXP)
Open query with criteria (2k)
Importing Leading Zeros From a Text File (Access 97)
Excluding data from reports (Access XP)
Formatted text in column choices (XP SP2)
Access Runtime Packager (XP Developer)
Order By on a Report using a Variable (XP)
Setting cursor to end of text (Access 2000)
Identify original user ID (Access 97)
Splitting DB--concerns (2000 & XP)
Open form by doubleclicking datasheet (2000)
Switchboard (2000 9.0.3821 SR-1)
Tab Control (Access 2K)
Parameter queries (AccessXP)
Duplicates (Access XP)
Select Query Help (2000)
Add new records to a subform (A2K SR-1 Win2KPro)
Keeping group header with details (Access XP)
index structures (XP)
Duplicates (Office XP Pro)
Get CapsLock state (A2K SP3)
Query/Report/Macro OK (WIN 2000 Acc 97)
Add only DAPs (Access 2k)
Indexs on Tables (Access 2000)
Renaming a File (Access 2000)
Problem with Event Procedure (A2K-SR1)
Linking tables with an expression (2000)
Changing Tab Control Colors (Access 97/2k)
Select from a combo box or drop down list (2000)
Autokey problem (Access 2000)
Slow load from LAN (2000)
Am I asking for too much? See attachment (Access 97)
Sample Database (Access 97)
Best Way To Determine Success of JetComp? (A2k (9.0.3821) SR-1)
Setting ControlSource in a subform (Access 97)
Memo fields that won't edit (Access 97)
Summarizing inv records to append to A/R table (Win ME/Access 97)
EZ IIF( Q (v2KSR1)
SQL Slammer Vulnerable programs- A List (MSDE)
Shut down after macro (Win ME/Access 97)
calc days since a date (access xp)
Parameter Query (2000)
linking fields from one db to another? (Access XP)
Concatenating 2 fields (Access 2000)
writing a user defined aggregate function (Access2000)
HTML User Interface (Access 2000)
Building NON Square Forms (Access 2000)
Can you sum total a combo box (2000)
Send message w/ different versions of Outlook (Acc97 SR2)
Calculating/Grouping Day of the Week (Access 97 SR2)
Cross Tab Report Not Showing Zeros? (A2k (9.0.3821) SR-1)
Check for an open form when opening a second form (Access 2k)
CreateContol in remote DB (A97)
Access previous record of query (97)
Zoom Form Design Screen (97)
Changing A Form Tab Control (Access 97)
'The value you entered isn
Conditional Format on Form (Access 2000)
Tabbing Into a Memo Field (97) (Access 97)
Opening a Word document (Access XP)
Function vs sub (office 2000 on windows 2000)
Locked up database (97)
How do I get the startup dialog box back? (Access 97)
Access 2000 Calculation (2K)
Excel from Access (Access/Excel 2000 (9.0.4402 SR-1))
Insert individual dates into table (Access 2000)
Export to txt (A2000)
Access VBA reference (Access 2k)
Append only the missing rows (Access 2000)
Sum Totals (Access 2000/SR-1)
ProperCase in Form (Access 2000)
In Parameter Method (Access 97)
'To Fit' command for textbox on form (Access 2000)
Delete function (Access 2000)
Scrambled Data (2000)
fix code to send email (Access97)
Excluding negative lines in a sum (2000)
Can't Find Project or Library (97)
Grouping & Parameters (97)
Form On Time Event acting strange (A2K SR1)
Sharing Database (Access 97)
Basic If..Then Question (Access 2K)
Can't Load Access (XP)
top values (97)
Sorting (Office 97 SR2)
Error 48 Loading DLL (Access 2000)
Moving text up when the above field is Null (Access XP)
Criteria for Summed Lines (2000)
Selective counting on a report (Access 2000)
Access & Performance compatability (Access 2000)
report (2k)
zip code issues (Access XP)
Subforms? (Access 97)
Syntax for Nested SQL Statement (Access 2000)
email from Access using Outlook (Access 2k win 2k outlook 2k)
Blank Pages in a report (Office 97 SR2)
Report of jpg images (2000)
go to random record on a form (2002)
combo box as a locator (Access XP)
Error message (Access XP)