Windows Secrets
Windows Secrets Lounge
nz function (Win ME/Access 97)
Mix & Match (A2000 SR1)
Outlook E-mail Security Update (Access 2000)
Make table query works but Select does not (2000)
Using Access to create reports on a SQL database (Access 2002)
Selectively Locking Fields on a Continuous Form (Access 2000)
Converting: Invalid Field Type (Access 2002)
Subform problem (97/2K)
ole object (access 97)
Converting Access97 to Access XP (Access 2002 (10.2616.2625))
Simple notinlist and requery of cbo (acc97-sr2)
2-column report (Win ME/Access 97)
Understanding OpenRecordset (Acc 97 sr2 on 95b)
Access .MDE file will not open after NT Domain chg (Access 2000)
Access problems
copying data to and from several tbls/dbs (2000)
empty db taking surprising amount of memory (2000)
Show more than 1 record in a text box (97/2K)
Clng Function (Access 2000)
use a series of listboxes as filter (Access97)
SpeechRecognition (Access XP)
Some queries/reports don't update (2000/9.0.3821 SR1)
VBA equivalent for the Convert to 97 format (XP SP2)
Memo field in report (Acc97-SR2)
Memo field in report (Acc97-SR2)
MsgBox? (A97)
Hide unwanted report section (2000)
Open a database from my application (Access 97)
Two Texts Into One (A2000)
Too few parameters (Access 2000)
Creating a macro to edit records (97 Sr2)
Using Access as TimeCard (2000)
Using a combo box to specify a critieria in query (Access 2000)
4 memo fields into 1 (A2k2 (as 2k) SP2)
Text box value from a query (97/2K)
Image transparency on forms (2k (9.0.4402 SR-1))
Read permissions (access 2002)
Control Split Across Two Pages (Access 2000)
Biometrics(fingerprint) for MsAccess (Access97)
Copying tables (A97 SR2)
hid a menu (2k)
Multi Table Search (Access 97/SR 1)
Capture Signature with ActiveX control (Access 97)
Disable shortcut toolbar in subform (A2K - SR1)
Combo Boxes (97)
Form Focus (AXP)
Automation with MS Word (AXP / WORD XP)
Ten Commandments (all)
Update rows through deleting (Access 2000)
Dlookup (97)
Link with highlighted field (Win ME/Access 97)
Append Conflict (97) (SR-1)
Query Design Slow (WIN 2000 Acc 97)
Open Startup Form at Last Saved Record (Access 2000 and Win XP Pro)
Characterisics of linked tables (Win ME/Access 97)
How to move to the first record of a subform? (2002)
Making Checkbox Size Larger (Access 2000 and Win XP Pro)
Sorting Lookup Combobox Lists (Access 2000 and Win XP Pro)
Limit number of indexes (A97 SR2)
Changing a Yes/No field in a table (Access 97)
Web Enabled Access DB (Access 2000)
Moving objects (97)
items&group (2k)
Populate a table (Access 97)
Choose Date/Time in Form Without Typing It (Access 2000 and Win XP Pro)
Update table from report data (Access 2K SR2)
Date Field Hot Keys? (A2k (9.0.3821) SR-1)
Automation (2000/SR-1)
Access Splash Screen (Access 2k)
Email info from Record (Access 2000)
List box entries written to email (97)
Setting InputParameters for a report (Access 2002)
Query constraints (Access 97 SR2)
Set connection object to CurrentDB (Access 2002)
reports crashing since win2k conversion (access 2000)
CLSID for Access 2000 and XP (2000 and XP)
Mouse Pointer (97/2k)
Conversion to 97 (2000)
Value list for combo box set in code (AXP)
Design Grid (A2k)
Automatic Backup (V2K SR1)
Runtime becomes default choice (Access XP)
DAP Security (Access 2000 SR1)
Change field value after printing (Access 2000)
Import problems (97)
Time delay with ADP/SQL functions (A2002/SQL7)
Concatenation Fault (Access 97)
Problems with custom date formats (Access 2000/9.0.3821 SR-1)
Report Header (Access 97)
VBA code for row difference (A2K2)
Restricted user access to report/query-definition (A97)
This record has been edited by another user (lie) (Ac2000/SQLServer 2000)
Combo Box (Access 97)
Reference a rpt OnNoData Event's Cancel Argument (2002/SR1)
Runtime breaks other databases (All)
On Open in Form (Access 97)
Printing table structure (Access 97)
Combo Boxes, Applyfilter (97)
User Response Search (97)
Add data to a table from a form.... (A2k SR1)
Can I use Tabs in Text Box? (A2k (9.0.3821) SR-1)
Summing in a report (Access XP)
Dynamically add textboxes to form (2000)
Export to Text file and add text to file (Access 97)
DSum & Sum (Access 97 SR2)
validation rule (Access)
Macro (Access 97)
Limiting Lists (Access 97)
Making a record navigation bar invisibe (XP)
combo boxes (Access 2000 SR1)
Combobox in report (Acces)
How to Search (Access 2002)
1) Adding a number to a string (2000)
Show the report header of a sub report (Access 2000)
SQL Statement for Select All (XP)
Student: Access Combo Box (Access 2000)
Problems with combobox and datatype (2002/SR1)
Lookup field (97)
Form Name that Opened Report? (A2k (9.0.3821) SR-1)
Transfer a Variable from One form to another? (Access 2002)
Grouping Reports by Year (Access 2K)
Selecting Queries from Combobox (Access 2000 SR1 and Win XP Pro)
Field cannot be updated (2000)
Exclusive or Shared Mode? (A2k (9.0.3821) SR-1)
Toggle Button (A2000)
Delete tables of error in fields (A2K SR1)
Problem with autonumber key field (A2K SR1)
not allow (2k)
RunCommand and Visual SourceSafe (Access XP)
To Auto or Not? (XP)
Code execution when form opened as dialog (200sr1a)
oPEN mdb (2K)
form close (Access 2002)
Replication ofm Forms, Reports & Marcos (Access 2K-SR-1)
Converting Reports to Forms (97)
Form and Subform Design Help Needed (Access 2000 SP1 and Windows XP Pro)
Conditional Formatting (2000)
Sounds on Access Forms (Access 2000)
Can't use functions in queries (A97 Win2K)
Setting Length of a Textbox (XP)
Selected Subreport item, referenced in a Query (97)
How to Reference Form in Report? (A2k (9.0.3821) SR-1)
Expressions in queries (2000 on NT4.0)
Password - Number of attempts (97/2k)
Suppress Print message (Access xp)
Can
Access 2k, ADO, SQL Strings (Access 2000)
Code Breaks on Unrecognized Control (97/2000)
Change colour of Tab control heading? (A2K SR1)
TextBox on Form (97/2k)
Changing look of a disabled field (XP)
Date Clash (A2000)
VB Reference to Query (2000)
Opening Multiple Reports Causes Crash (Access 2k sr1)
Can you hide tables from the DB window (Access97 & XP)
Want to be a Beta tester for Office 11? (All Access)
Losing Connection to Server (A2000 WinXP)
Name the output object using the Senditem command (AXP)
Access's default background (A2K SR1)
Password (97/2000)
Type Definition Error (AXP)
Force Open Linked Table (Access 2000)
Access Report (Header orphaned from Detail) (Access 97)
Turning a folder's content into data. (2000)
Database format (Access 2000)
OpenForm (2000)
Joining two queries (2000)
Subform/sub report formatting (Access 2000)
Error 429 and CurrentDB (Access 97)
Packaging an Access DB (Access 2002)
Updating Caption Property (Access 2002)
Age calculation (AC2000)
Count the no. of a given db opened by a user (97 sr2 / xp)
File Importing (Access 2000)
Import code (Access 97)
taskbar (97 sr 2)
admin's lost some administrator priveledges (2000)
hide the screen? (Access 2000)
Message box: 'Are you sure you want to delete?' (Access 2000)
Network Down Notification (Access 2002)
Redundant code (Access 97 & VBA 6)
Compact & Repair (Access xp)
SQL Qury (Access XP)
Acc97/XL97 Automation (97 SR-2)
Count distinct in a report? (Access 2002)
adodb.connection can not execute (1)
Export Multiple Queries (Access 97 SR-2)
Access on the Server (Access 2002)
Reformat Time Field for Access? (A2k (9.0.3821) SR-1)
Driving a query in a specifc month (Access 2000)
IIF Functions (Access 97)
Security - Who is logged in? (Access 97)
Diary Application (A2000 SR1)
New page after grouping in report (2000)
Autonumber problem (Access 2000)
Exclusive Use (Access 2000)
Exclusively Locked Tables (Access 97)
Splash SCreen (Access 2000)
Disable F1 Help in menu? (A2K SR1)
Problem: Chart range will not always be up-to-date (Access 97)
Record Locking (Access 97)
DB Too Large? (Access 2002)
Project Breaks Excel Automation (A97/Excel XP/Project 2000)
Server Busy (MS Access 2002)
Development Platforms / Missing References (Access 2k)
Report loses page setup (2000 Sr 1)
AutoNumber (Win ME/Access 97)
Cannot access Menu's hotkeys (A2K SR1)
Web Publishing Wizard (access 97)
close forms (2k or 97 )
Using a control's value in an SQL statement (Access 97 / SR-2)
Access Emailmerge to Eudora (Access 2002)
Warnings in queries (Win ME/Access 97)
zero balance not detected (Win ME/Office 97)
Date in query (Access 2000)
Table-to-form references (Access 97&2000)
Form focus (a2K)
Access (2000 SR1)
Can we just copy MSJET40.DLL over? (A2K - SR1)
Custom toolbar for Reports (Access 2K)
Access's System tables? (A2K-SR1)
Import spec ? (Access97)
Archiving records (Win ME/Access 97)
Combo Box Confusion (Access97)
Data lookup (Access 97 or 2000)
Version check code (97 and 2000)
Setting Table Description in VBA (2000/2002 SR2)
Calculating a date (Access97)
Move subform to a record (2000)
Want to show the number of users in a form (accessXP)
security (Access 97 or 2000)
Email form details as text (A97 )
Access Can't find Module when opened by shortcut (Access 97 SR2)
Automated E-Mails with Lotus Notes (Access 2002)
Hosed-up autoexec (Access 2000 SR-1)
Calling Successive Reports (Access 97)
No Visual Basic Error Trapping (Access XP)
Access Usage As Knowledgebase? (XP)
Key Strokes and Functions (Access 2k sr1)
Printing only Invoices with a Balance (Access 2000)
multiple query report (2000)
Does this make sense (A2k SR1)
Using output parameters from Sybase/SQL Server SPs (97 sr2)
Password Protected Form (Access 2002)
Sort names in report if expression joins first/las (XP)
Oh no, not 'time' calcs again! (2000)
Publishing a report as a Word document (A2K)
E-mail with attachment (A2K)
Fields data type (Access97)
Using XP database in 2000 (2002/2000)
Page Member value-custom pagesize setup (XP)
Record Not Locking (97 SR-2)
Array as case statement? (97)
# sign added to end of value (97)
Empty text fields padded with spaces (AXP SP1)
Format Problems Exporting to Excel (Access 97 SR-2)
Text functions (AC 2K / NT4.0)
Complex Query (2000/SR-1)
Using Access from within Word (XP)
Autonumber not working (A2K SR-1)
ctrl+ semicolon error message (Access97)
Merge and clean duplicates (Access 2000)
Chart for a group (Access 2000)
Multiple choice test (ACCESS 2000/SR1)
Correlation Coefficient (w2k)
Grouping Error (Access 97)
building client code (Access 2000)
Use form (Change caption)
Security (97 and 2000)
Using a variable to refer to a procedure (Access XP)
Command button on a form (Access 97)
Look up a field in a sub-form (Win ME/Access 97)
Fonts In Reports (XP)
Query Parameters Set By What? (2000)
AutoKeys macro (A2k)
Export Specifications (AC 2K)
Compact database (Access 2000/2002)
Aligning Text to Bottom in Report Datafield (2002)
Importing .DAT files into Access (XP)
Conditional formatting (Access XP & IE)
Form Title Bar (Access 2000)
'####' AS TEXT (Access 2000)
Status bar text (AC 2K)
Date Range (A2k)
Pivoting Data - Best method? (2000/SQL Server 2000)
Write Conflict error messge (Win ME/Access 97)
Look up a record in a query based on a form (Win ME/Access 97)
Redundant Code (A2k SR1)
Auto Update Dates (Office XP)
Limit on TransferSpreadsheet (Access 2000)
Joining fields in creating report-export to word (2002)
.Caption (A2K)
Converting Approach file to Access (2000)
Concatenated find (Win ME/Access 97)
Lookup tables in subforms (2000)
combo box (xp)
Sort Order (Win ME/Access 97)
Switchboard Limit? (Access 2000)
Subforms (2000)
Dropdown & the Mouse Wheel (A2K)
Capacity of Access 97 (Win ME/Access 97)
Changing Data in BeforeUpdate Event (2000/SR-1)
Summing Time Fields (WXpHe+A2K)
Building an array (Access97/2000)
Test Dates (2000)
treeview control--subnode click event poss? (Access 2000 SR 1)
Access 2000 New Entries Misplaced (Access 2000)
Front End/Back End Conversions (97/2000 on NT4.0)
Grouping time in a query (97 SR-1)
Validation using events (Acc2k2 SP2 (as 2k, DAO))
after add new record ...how do I move cursor (Access 97)
Create Mail Item Problem (AXP)
Crosstab SQL (A2k SR1)
Cannot access menu using Alt shortcut (A2K SR1)
invalid use of null (AC 2K)
Update Query (A2K/WinXP Pro)
borders on every line 'inside' a multiline textbox (2k)
OnUpdate for a table (2002)
Update Format for Phone Numbers (2000)
Hyperlink in Report (Version 2k SR1)
Shell command (AXP)
Manipulate Text Function (Access97)
Blanks in Report Detail & Underlines (Access 2002 SR1)
Office Developer (XP)
2 Fields into 1 (2000/SR1)
VBA Requery command (Access 2000 in Office/Windows XP )
Find & Replace (Access 97 SR-2)
Zoom Picture (A2k)
Access SQL (Access XP)
Delete files (AXP)
Date/Time Picker (AccessXP)
Auto Import from Oracle (Access 2k)
Printing null data (A2K SR1)
Printer Setup Margins? (A2k (9.0.3821) SR-1)
Reference well nested ctl as query criteria (XP)
Date (2000)
Exporting to dbf (Access 2000)
Importing Data from a Web Site into Access (2000 SP (Any))
Access 2000/2002 Compatability (2000/2002)
setting printing reports to landscape (2000)
References dialog box (Access 97, Win ME)
Query Parameters (Access97)
OpenRecordset (AC 2K)
Value 1-1000 (Access2000)
How to avoid the error message (Access 2000)
Columns (97)
Updates?? (Access 2000)
Can you index the range of data on a page? (2000)
automatic entry of data (Access 2000 SR1)
Measuring Three Date (2000 SR-2)
Criteria do not function (Access 2000)
Dynamic creation of form with sub forms (2000)
various forms questions (97)
Importing Tables (Access 2k)
Query Help? (A2k (9.0.3821) SR-1)
Variable not accepted (Access 2000)
Subreports with Columns (XP Sp2)
Update Query (Access 97)
Assignment Report (97sr2)
Fanthom Forms! (2000)
convert access2k db to access97 (access 2k)
Importing Word Document (2000)
Printing Null data records (A2K)
filtering one of two identical column values (2000)
Pictures??? (2000)
Tab Orders (A2k SR1a)
Reports: Passing 'Order By' (Access 97, Win 95/98)
Left Join Query result....#Error (MS Access 97)
Locked record (Access 97)
Correct Indenting (A2k)
enumerating unique records (AC 2K)
Unload variables (AXP)
Queries acting up? (A2K SR1)
Third query or another solution? (Access 2000)
List Box that updates with query (Access 2k)
Hiding Field Values (2000 SR1)
Access a control's data on a tabular form (Access 2002/SP2)
Report Help (Access 2K)
Use Current Record for Query (Access 2000 SR2)
SaveRecord not available (Access 2000, sr1a)
Inventory Database (Office 2000)
User changeable Queries (2002 - XP)
count values in report (Access XP)
Reset AllowByPassKey property back to True (A2K/A2K2)
Set combo box default value to null (Access97)
Code Stops Working (A2K sr1)
A2K to A2K2: ODBC call failed (A2K2)
SYNTAX Help (Again) (A2K SR1)
Save Record/Close form (A2K SR1)
Calculate dates with parameter (A2K_SR1)
Turn off typos (2002)
Else if bungled (Access 2000)
Call command (A2000 SR1)
Switchboard (Access 97)
ODBC details cached? (XP SP2)
AllowBypassKey (2002 (XP))
Switchboard Modification (A97)
SQL in Access (Access 2002)
Web Served Db (2000)
Access Bloat (Access 2000)
Can't find Subform! (AXP)
Choosing Data to Display in Report (97)
Updating combo box values using VBA loop (Access 97 SR-2)
System table - relationships (a2k)
Linking tables from other databases (MS Access 97)
Missing menu (97)
Open a Word File after Export (Access 2000)
Recreate links to image files (Access 2000 SR1)
Filter in Form (Access 2000)
Printer icon face id value (97)
Form based on Parameter qry (Access 2000)
Right Function (2000 SR1)
Formatting in a field (Access 2000 SR1a)
Adding ID Field (Access 2000)
Bewildered By SendObjectFAX (2000)
How do I Delete then Copy Object? (A2k (9.0.3821) SR-1)
Edit data in subform (AXP)
Forms/Subforms (Access 2002)
Recordcount while using Do Loop (AXP)
Access 2000 Labels (2000)
criteria in combo box row source (97/2)
Mail Merge (Access 2000)
optimizing DAO db connection (Access 97/2k)
Corrupted mdw (access 2000)
Range (2.0)
700,000 + Autonumber (Access 97)
Linked server problem - Access 97 - please help (Access 97)
Parameters query subform using date greater than (Access 97)
Visual Basic help (Access 2000)
Profile (Access 97)
Design View (A2000 SR1)
Delete Query (97 & 2000)
Access Runtime Environment (Access)
Filter for Upper/Lower case only (Access 97 SR-2)
Error with Constant (Access 2000)
Error message on Open (A2K sr1)
Concatenation problem (Access 2000)
Access Circle Error (97)
Hopefully a really simple Combo Box question (97)
Coping database with a control button (Access 2000)
Reverse Counter (A2000 SR1)
Making a number negative (2000/SR1)
how to strip +four from US Zip Codes (2000)
Cross Tab Query (WIN 2000 Acc 97)
trouble with linked, embedded chart (Access 97/2k)
A2002 and Wrkgadm.exe (2002/SR2)
Dates (A2000 SR1)
Printing Zip Code on Envelopes (Access & Word 2000 sr-1)
Server Creep (v2K)
How do I Display Last Record Used? (A2k (9.0.3821) SR-1)
Database fails to open (2k)
Access on the web (2002)
Trapping Duplicate Entries (A2K)
Queries & Wildcards (Access 2002)
Queries & Relationships (Access 2002)
Going nuts!! (97/2k)
bar code label and Access (Access 2000)
How do I Test for Existing Date? (A2k (9.0.3821) SR-1)
graph 8 in access 2k report (2000)
Divert printer output to an RTF (2000 9.0 SR-1)
97 Graph Control in Access 2k
Training (2000)
'Group-by expressions exceeded' (Access 2000)
Image & Field content (A2000 SR1)
Turn an Access form into an .exe application. (2000)
Record + general security (2000/SR-1)
Security File Growing (Access 2000)
Go to the firts record (Access 2000)
Combo Box Problem (adding to list) (Access 2000)
Shutdown App on 2nd Machine (Access 2000)
Combo Boxes (Access 97)
Error viewing Report (Ac2002)
Apply Filter (2.0)
Blank Data Cells (Access '97)
FindFirst (Access 2000)
US/UK date input (Access XP)
Save changes (2000)
Output with parameter (2000)
Convert Datetime to text (Access 2000)
Creating Access Database (Access 2000)
Check availability (97/2000)
Referencing objects inside record (AXP / WIN XP)
Currency rounding up (Access XP)
Cross-tab data in a report (2000)
Access database security file (.mdw) (Access 97)
Change Code & SQL (A2000 SR1)
Is anyone there? (Access 2000)
Day Count (A2000 SR1)
Dratted report footer! (97)
Graph 10 (2002)
reuse of function (Access 2000)
how to change a subform's table (access 2000 9.0.2720)
Primary Key question (Access XP)
Form and Subforms (Access XP)
Multiple databases (2002 SP-1)
Invalid Procedure Call (Access 97)
Combo Box Value as Criteria in a Query (2000)
Charts in a report (NT4.0 running office 2000)
Rich Textbox in Access (Access 2002)
Problems with functions (2000)