Windows Secrets
Windows Secrets Lounge
barcodes (10.4)
An approach request (Access XP)
Include Word Document in Report (A2k)
Juicing up a crosstab (Access 97)
Update Query To Fix Time Field? (A2k (9.0.3821) SR-1)
Simulate Drag and Drop (A2k SR1 or 2002)
Kicking People Out of a Database (A2K SR1)
Increase Speed of Opening Form (Access 2000)
Requerying a Subform (A2k-SR1)
mailto:address (Office 97 SR2)
Placing an icon in the system tray (2002 SP1)
New install of OfficeXP (OfficeXP)
Phone connectivity (access 2k sr1)
Combo box to select what is displayed (AccessXP)
Auntomatically inserting info (Access XP)
Working with Dates (A2KSR1)
queries (Access XP)
Memory resources (XP SP2)
Minimise database size with images (XP)
Form Maximize (Office 97 SR2)
Total query (Win ME/Access 97)
Deselect Items in MultiSelect Listbox (Access 2000)
Automatic Filling of fields (Access 2000)
Using Class modules for a fragmented data structur (Access 97 and up)
series of queries (Access97)
Inserting a decimal (Office 97 SR1)
Select lowest date (Win ME/Access 97)
select statement (Access 2002)
Report Sort Order (Win ME/Access 97)
table relationship ? (Access 2002)
Table Limit? (2000 (SR-1))
Virus warning when using SendObject (access xp)
SR2 update (Access 97)
Removing Restore Button on Maximised Form/Report (2000 and XP)
Using Custom Menus to Navigate Forms? (A2k (9.0.3821) SR-1)
Limit combo box selection in continuous form (97) (Access 97)
Allowing limited access to records via a form (Access 97)
Text File Export - formatting (MSAC2000SP-1)
Opening a form from another form (2000)
'Invalid argument' (2000)
Currency type in query (Win ME/Access 97)
Name Tags (10.4)
Saving Records (XP)
Create Msgbox that states nbr of Records appended (Acess 2000)
Don't allow input (2000)
Chart Design (2000)
Help with Iif (Access 97)
Adding spaces (XP & 2000)
Excel Import (2000)
Home filing system/catalog (XP)
Problem Running Module/Procedure From Macro? (A2k (9.0.3821) SR-1)
Function Not Available in expresions in query (9.0.2720) (215484) was removed
Function Not Available in expresions in query (9.0.2720)
Upgrade to 2002 (Win ME/Access 97)
ACCESS List box (97/2000)
Access 97/FileTypes (97/SR 1)
Treeview (A2k)
SendObject won't finish the send (AccessXPSP2/Lotus Notes R5)
Importing text files (97)
Page Setup Changes (Access 2000)
Form/Subform Control Manipulation (2000 SR-1, Win 2000 Prof)
Automatically increment without Autonumber (Access 2000)
Group By (Access2000)
Report Header Question (A2K SR1)
Problem with Variable (AXP (2002) SP-1)
Lookup Columns (XP)
Alternative to Access (XP)
Pivottable view on a datasheet subform (access xp)
put results of calculated field into table (2000)
nested IIF problem (Access 97)
Hourglass (Access 97)
Recipe Database (Access2000)
sequentially labeling a set of records (Access 97)
Comparison Queries (Access XP)
access 2000 (2000)
Upgrade from Excel 97 to 2k, Error 429 (MS Access 97, Excell 97 and 2k)
Building a Listbox using field captions (Access 97 / 2k)
How to number rows in a report or query (Access02)
Tab Control Forms (97 sr2)
Comparing the same data from different sources (Access 2002)
Easiest way to update tables (97 Sr2)
Compact Databse (Access 97)
importing problems (2000)
A funny thing happened while compiling my project. (Access 2002)
'background color' for sub report (Access 2000)
Access 2000 and SP-3 Bug (2000 SP-3)
Formatting reports in Preview mode (97)
Data Access Pages Sercuirty (2002)
Data Access Pages FDiltering (2002)
Odd form behaviour (2000 sr1)
Vertical Text (Access 2002)
Set import dialog box (97)
Modify a query in code (Access 97/XP)
Records (Access 2000)
Access the WWW in Access (Access97/SR2)
Headcount Report (Access 2000)
Hyperlink Word to Access (Access 97/Word97 latest SP)
ControlTip Text on tab control (2K)
VBA Text Control Update (Access 2000 Premium)
Sorting the recordset in a list box (Access 2000)
Image control and pcitures (2000 SR-1)
DAO 3.6 reference question (Access 2K Win 2K)
Access 97 to Access 2000 Conversion (9.0.4402 SR-1)
forbid tampering with the tables (Access 2000)
Access (97)
Printer setting MDE (A97 Win2k)
Referential integrity (2000)
INstalling Access (Access 97 WinNT 4 SP6)
Automatic data entry (2000)
Multiple MultiSelect List boxes (A2K SR1)
Printing Multiple linked PDF Files (A2K)
Upgrade from 2002 to Developer (A2002)
Extracting only the month from a date field (2000)
Running Total (2002)
sorting numbers in a text field (2000)
Import Text File - Create Table (A2000)
ROUND TO NEAREST HALF HOUR (Office 97 SR2)
Can't open database after upgrade (97 to 2Ksr1)
DLookup in Code (Access 2000)
Calender control (Access2000)
Workgroup problems (2000sr1a)
Stripping data from variable length fields (2k)
A2k Runtime and Office XP (A2K, XP)
Access/oracle (2k)
Who Opend the Form?? (A2k (9.0.3821) SR-1)
'You cancelled the previous operation' (Access 2002)
Translation Error - exporting Outlook contacts (Office 2000 SP2)
Synchronizing an Access 2000 .MDB with SQL Server (Access 2000)
MSL to Access Transfer (Access 2000)
Button (Access 2002)
Read query, build another table based on content (2k)
Blank Word Document (A97/2K)
Command button = parameter query (2000/9.0.3821 SR1)
Dynamic Access report? (AC2K SP3)
protection (2k)
References (Access 2000, Win XP Home)
Date/Time Lookup (2002 (XP))
DLookup function (Access 2000)
Viewing and editing graphically (Office 2000 Sr1a)
Keyboard navigation in continuous form (Access 2K SP3)
Cannot change a record (A2k)
Schedule Form (2002 (XP))
Syntax error in code (Access 2000)
Reset autonumber field (Win ME/Office 97)
Textbox value from query (A2K)
How to refer to the subform (Access 2000)
TEST (Access 2000)
AutoAdd Records (A2K)
Word Doc (A2K)
Querying a SQL Server using a date on a Form (AccessXP/SQL Server 2000)
print a report (2k)
Access is not listening!! (Access 97)
Refresh (Office XP)
Compile Error: User Defined type not defined (2000 (9.0 SR-1))
Runtime error 3702 (ACCESS 2000)
User defined default (2000)
My latest Access 2000 crash (Access 2000 9.0.3821 SR-1)
Checking for open files in Excel before export (Access 97 Win2k)
Trapping Notes (v2K)
Create linked table to text file, DAO (A97 )
DOS File Handles (A97 / A2K)
Subtract Dates (2000)
Upgrade to XP (Win ME/Access 97)
send uncommitted value to Excel (2000)
Parameter crosstab and wildcard (Access 2000)
Access97 Charting (Access97)
Access to SQL (SQL Server 2000)
Record count of Excel spreadsheet (A2K)
Decimals in Merge with Word (Office 97)
Send Object Using Outlook (A2k SR1)
Access automation with Word (Access97->XP)
Pivot Tables - Problem Obtaining Data (A2K SR1)
Populate a field (97)
Removing a Member from Object Browser (Access 2002)
Move Text Box (Access 2000)
Filtering on SubForm (2000)
Mail Merge w/Word (97, 2K, XP)
Filtering Using IIF Statement (Access 2000)
Conversion from A2k2 to A2k (A2k2 SP2)
Identical records, different dates (Access 2000)
Combo Boxes and DAP (Access 2K)
DLookUp expression (2000 SR-1)
OutputTo Method Question (Access 97 Win 2k)
SQL Stored procedures (SQL Server 7)
Storing Uppercase format (Access 97)
Access Report (2000)
Date Search (Access97)
Database Window, Hidden when Database is opened (MS Access 2000)
Setting a Dynamic Data Source in Access 2000 (MN Access 2000)
MTD and YTD criteria (2002 sp 2)
Tab Control (97/2000/2002)
Tools-references option not available (2000)
Converting A97 to A2002 (A97)
Record of Record # (Access 2000)
Report layout (Access XPpro)
Access Database Size (Access97 SP2)
Read Custom Database Properties in VB-Script (97 SR-2)
Can't find DLL (97)
Exporting Access report to PDF format (XP)
listbox (Access 97)
Advanced NotInList (Access 97)
End If - Else - Exit Sub etc (A2000)
No Zero in query (Access 97 Win2k)
Delete unneeded records (2000)
Can't set focus to form control (2002)
Select Query and date (Access XP)
Mass Update of Field Values by Form or Datasheet? (Access XP)
If statement with Date (A2K SR1)
Teaching Access queries (all)
Running Sum Error In Query? (A2k (9.0.3821) SR-1)
tThree fields for one date (Access 2000 sr3)
Question from 'novice' regarding subforms (Access 97)
AfterUpdate doesn't work (Access 2000 SR1)
Calculated fields in a report (XP)
Modify text file (97)
the 53rd week? (Access 97 (SP2))
Code Works only for 1 machine (2K; SP-1)
problems transferring to new pc (2002)
Delete empty records from linked spreadsheet (2000)
History search (97)
Toggle Buttons (A2K)
Merge (XP)
MsysQuery (A2000)
Deleting unmatched data from a query (Access 2000)
Syntax error in query expression (Access 2000)
Page Layout not keeping it's value (Access 2000)
Set Taskbar Autohide / Always-On-Top with code (Access 97)
DoCmd.OpenQuery (XPSP1)
NZ function (Access 2000)
Last record disappears (Access 2002)
Remove Leading Zeros (A2K SR1)
First Item In List (A2000)
SQL instead of a query ? (Access 2000)
Reattach Excel Tables (Named Ranges) (Access 97)
Querying form object attributes (2000)
Show multi-activities and determine who paid most. (Access 97 SR2)
Sum in a query (Access 2000)
Query definition not saved (Office XP (aka 10, aka 2002))
Counting Records (2002)
Corrupted Table Record (AXP)
Record is Deleted (97)
is this possible (2000)
Enabled/Locked Properties (97)
Allowing mulitusers to view only their updates (Access 97)
Progress-Status Meter (A2000)
VBA OLE code to get photo from scanner (Access 97)
AutoFill Form (Access 2000)
Link excel with access query (Access 2000)
Oracle ODBC (XP)
Output to XL (2000 SP-3)
MsgBox function (A2K SR1)
View a jpeg file from Access (2K)
Printing current form (Access 2000)
ListCount (A2K)
Running Sum (XPSP1)
Parameter query (XPSP1)
Value=present date (2000)
Updating date (2000)
Changes in Query automatically saved (ACCESS 2000)
DMax (k2)
OpenRecordSet won't work after splitting database (Access97/SR2)
JET Version for Access 2002 (2002 SP2)
Querying unpaid balances (XP)
Parameter query (2000)
Import data from Excel (Access 97)
Using LIKE with a prompted value (XP)
Is this possible. (2000)
Easy Report Problem (2000)
Recursive joins/Hierarchical data (all)
Percentage label in a pivot chart (xp)
query quandry (A2K)
N/A (Access 2K/Win 2K)
Calculating Field in Access (Access 2002)
Modify form in runtime. (XP Developer)
WeekdayName Function (Access 97)
Time frame query (Access 2000 SR1a)
Formatted Fields in Union Query (Access 2000)
Calc Weekly and Monthly Totals in a Form (Access 97)
Access2k vs AccessXP (A2000)
Why does good code go bad? (A2K/SR1 and AXP)
97 to 2000 upgrade - method/data member not found (2000 (9.0 SR-1))
SQL help (Access 97)
Last Day of Month Data Validation on Form (2000,SR1)
Problem Communicating with OLE Server (Access 2002 SP1)
Date Field (2000)
Update Query problem (Access XP)
autokeys-non English (2K)
Using Orderby with forms (Access 97 /2000)
data refresh on linked tables (Access XP)
Monthly report (XP)
switchboard (2000)
Can't open any more databases (A97 SR2)
Create Client Code (A2000)
ISAM error (Access2K SR2)
controls (2000)
Loop through records (Access 2000)
Printing either or series of reports (Access 2002 SP1)
Not A Simple Question (A2000)
Running an append query from a conditional macro (Access 2000)
Simple Question. (A2000)
How to specify the table i want to dlelete (Access 2000)
programming (2000 SR-1)
Undefined Function (Access 2000 and 97)
Disable right click (XP)
Using a form field as a query parameter (XP)
Password for Tables/Queries/Reports (97)
Formatting combo box (2000/SR1)
Is there a 'standard' screen area setting? (2000)
Delete query doesnt work (Access 2000)
Find/Replace Programmatically in a Module (Access 2000 Win 2000 SR-1)
Report Formatting (Access 2000)
Overwriting a field? (Access 97 SR1)
Daily Updating (Access 97)
Easy Query Help (2000)
Week of Month (Access 2000 (9.0.2720))
'Access Lock File' (A2K, SR1)
update before append (Access 2000)
Optimum design (Acc 2k2 (as 2k, DAO))
Report with Images won't export to Snapshot file (Access 97)
Excel Automation (Access 97 sr2)
combo box in form based on criteria query (2k)
Table Security (Access 2000)
referencing an unknown form (Access 97 sr2)
Since when is '12a' a date?? (A97)
Date() vs. Now() (Access97)
summing a field (A97)
DAO/ADO (Win ME/Access 97)
linking fields from different tables (Access XP)
Leap Year (97 sr2)
Combo Wizard (2002)
ListBox count (Access2K)
Max num of fields in a table (97 Sr2)
#deleted in all fields (2000/2002)
Add message box to form (A2K/SR1 and AXP)
Force an entry in a field - how ? (2000/2002)
Printing a certain page in a report (Access 97 SR-2)
Add Data() to file name (XPSP-1)
Open pdf file from Access (97/2000)
Creating links from db A to db B from db C (Access 2000)
FileDateTIme (97)
QuickBooks SDK (All)
A Union query question (Acc 97 sr2 on 95b)
revolving query with different parameters (Access 97 (SR1))
Bravo! to the GifMeister (all)
Trouble with VBA event (Access 2000)
Form Equivalent of TextWidth (97 SR1)
Determining the state of a form (XP)
Hide Properties Form (2000 (9.0.4402 SR-1))
emailing from Access 97 (Access 97 Win 2k)
Query beyond me (A2000)
Retrieve Modified Date? (97)
Access DB corruption (XP)
Working days info (Access 97 Win2k)
Visual Source Safe (2K/XP)
Saving Table Data For Reports (2000)
Filter by Form (97 SR2)
Locked tables (2000)
Working with multiple forms (XP)
Error 5630 (A2K, Word 2000)
Link Excel2K to AccessXP (2002 XP2)
NZ function (Access 97)
Trouble with subform (Access 2000)
Import File Folder? (97)
'Expression is typed incorrectly...' (2002)
Sort Order in Crosstab Query (XP)
Buttons on form (2000)
distributing MDAC Components (MDAC 2.7)
Criteria in a query (Access 2000)
time calculation (97)
Hidden Form (2K/XP)
Remove Trailing Spaces From Text Field? (A2k (9.0.3821) SR-1)
Adding record with VBA (Win ME/Office 97)
Help with grouping on form (97)
Using data grids (XP)
XP (Left$([Avg],InStr(1,[Avg],'.')-1)) & Right$([Avg],Len([Avg])-InStr(1,[Avg],'.'))) with values without the '.')
Responding to a WAW Email (2000/2002)
Can't print after changing printers (Access 2002)
Set Focus in Tab Control Sub Form? (A2k (9.0.3821) SR-1)
Count Records That Equal A Where Clause (97)
close active form (2k)
Importing a UNIX csv file (Access 97 sr2)
Time Elapsed Work Days (Aaccess 2000)
Time Gizmo (A97)
ADO has me trapped in a dark corner (Access 2000 SR1)
Upgrade my PC to Win XP (Win XP/A97/A2000)
Help with recordseet (Acc 97 sr2 on 95b)
Automate Data Entry? (2000)
Validation in field in table (Access97 & XP)
Working in shared db (2000)
Access 2000 Web capabilities (2000)
Exporting images to an rtf file (ACCESS 97)
A Table Containing State Abbreviations and Names (2000)
Switchboard (97)
view a report (2k)
Queries Case Sensitive (2002)
Dcount Criteria Problemo (97)
Count Duplicate Records Once (Access 2000)
Next Date Query (A2k)
Using Multi-Select from a List to Populate table (Access 2000)
MoveSize (A2k)
Conditional Formatting (Access 2000)
Make new field in query (XP-SP1)
Opening forms in Dialogue mode (Access 97 Win2k)
Problem returning Date from Control? (A2k (9.0.3821) SR-1)
Not in List property problem (Access 97 Win 2k)
Set Application Title in Startup in Code (Access 2000/Win95)
Remove restore button from form (Access 2000)
VBA to delete table contents from multiple DB's. (2000)
Access and Visual SourceSafe (XP SP1)
Select Query (Access 2K)
Combo with 160,000 recs. slow on wrong keystrokes (2000)
Query confusion (Acc 2000)
CSV file (A2000)
e-mail (Access 97)
Security question (Access 97 win2k)
Reporting Horizontal and Vertical Data (2K)
Forms & Subforms (Access 2002)
Examine directory & use results in label (97)
Having a combo box (2000)
Proper case (A97 A2000)
Setting Reference Library at Database Startup (A2K SR1)
ANSI SQL 92 (Access XP (2002))
Email from Access? (A2k (9.0.3821) SR-1)
How To Properly Define A Time Filed? (A2k (9.0.3821) SR-1)
Mailmerge Doc to Outlook Email (A2K/Office 2000 )
Resolve all conflicts at once? (2000)
Orphaned button code (A2K SR1)
Problem with queries (Access 2K)
How do text boxes' runnin sums work in reports? (2000)
Creating Multi-Select Functionality, like Wizards (Access 2000)
Bookings that don't clash (97/2K)
External Document Attacment (2000)
How To Execute a Method from a Variable? (A2k (9.0.3821) SR-1)
First record in file updated when new rec added (XP)
Comparing tables (2000)
Access 97 vs 02 (Access 97)
open mdb (2k)
No AfterUpdate Event From Calendar Date Picker? (A2k (9.0.3821) SR-1)
Parameter Query Demands more Parameters (2000)
Scanning to Database (Access 97 )
Help w/ Data Access Pages on the WEB (Access 2000)
How many users max out Access 2000? (2000)
Blank text field (97)
Keyboard Shortcut Code for Alt + D Keys? (A2k (9.0.3821) SR-1)
Splitting up the text in a field (97)
Opening a Word Document (Office 97 SR-2)
AccessSecurity (2000)
Design View (Office 97 SR2)
Parameter Dialog (2000)
Control Tip Text (A2000)
Office Link of Report (XP)
DB3 commands (Win ME/Access 97)
Connecting an ADP to MDB without SQL Server (2002)
Access Security (2000)
SQL LIKE operation and MakeTable (2000 SR-1, Win 2000 Prof)
list box width limit? (XP)
Saving as previous version (2000)
Importing from Clarion??? (2ksr1)
If...Then...Else, Yes/No Procedure (A97SR2)
Dlookup trouble (XP/2K)
File Format Not Recognised - Corrupt Database (Access 97 - SR2B)
Splitting A database - code won't run (Access 97 SR2)
Form Design (A 97)
Copywrite (2000)
SQL : ORDER BY Month() (Access '97 SR1)
Another Combo Box (97/2K)
Import Paradox data to Access (Access 2000)
ACCESS (OFFICE 2000)
Merge query result with email addresses in outlook (Access 97)
Inventory BD (Access 2000)
DCOM error on Current (Access97-SR2)
Strikethrough font (2000 (9.0.2720))
Entering just the year in a text box on a form (2000)
IsNull or Not Inull. (A2000)
Combo Returns True or All (A2K)
Pivot view in Access XP (Access 2002)
VBA for ZoomToFit (Access 2000 (9.0.4402 SR-1))
IIF('Yes/No') (Access 97')
Requery (Win ME/Access 97)
Multiple Orders (97/2K)
Option Frame - objects controlled by one property? (2000)
calender (2k)
Section width greater than the page width (Access XP under W2000)
Design Question (Acc 2k2 (as 2k) SP2 DAO)
Forms (2000)
Printing a file inside Access (Access 2000 SP6)
Standalone applications FAQ (97/00/XP)
Importing data from internet in Access database (Access 97)
Formatting text output (97)
Would this be possible. (A2000 )
Getting the application's path at network (MS Access 97)
Warehouse database help wanted (2000)
File open dialogue box. (2000)
Checkboxes in continuous forms (XP/2002)
dblclk .pdf? (2000)
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)