Windows Secrets
Windows Secrets Lounge
A97 datasheet alignment (A97 SR-2)
Auto entry of missing info (97)
Continous Forms (2000/XP)
Forgot Password? (XP)
Adding weekdays (Access 2002 SP3)
version & language probleme (2000 sr-1 and xp)
Records deleted by accident (2000, SR1)
Formatting Report Text Boxes (2000)
Listing group scores-reports (2002)
Proper Way to Setup Numeric Unbound Control For If (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
keeping zeros as first digit (2000)
Data access page (Access 2002)
textbox - form (2002)
Case sensitive password (Access 2000>)
Excel Graph from Access (Access 2000)
New field (Access 2003)
copying number to text field and attach zeroes (Access 2k)
How do I get the year I select to show? (Access 2000)
Query (2002)
Deletion Confirmations (2000 SP-3)
Canceling an event (2002)
How To Execute a Sub In Form From a Subform? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
DAP and drop down list (Access 2002)
How Do I . . . Update cbo based on another cbo (20
Db design question (2003)
Cursor (Win2k/O2k)
Query Totaling Question (2k)
Adding New Records to a Recordset (2000)
capture number of rows to be updated (Using Acc2000, with DAO)
Parameter query (97)
Free replacement program for Access (2002)
Query Total (MS2000)
Error Closing subForm with OLE Charts (Office 2K)
Can't seem to refer to a combo box properly (Access2000)
Translate query into SQL (Access 2K)
How to go to last record in a continuous form (Access 2000)
Tab Control font size (Access 2000)
Sort Order is Wrong (2000)
Access 2002 (All)
Access (2000)
Form/Subform Control Naming - Again (A2K)
Labels to RTF (2002 SR-2)
Report PageHeader CanGrow/Shrink (A2k3sp1)
Tab Control (Access 2002)
Median Calculation (2000)
Form sixing (WXpHe OXp)
Importing Values from an Excel Worksheet (2000)
Opening Word from Access (2003)
Program for room utilization (XP/2K)
User Security FE/BE (Access 2002)
Team members updating Access database (2003)
Count Zero As Zero (2003)
Automatic delete query based on time (Access 2000)
Updating Forms (Access 2002)
Display Name for generated BCC list (2000 SP3)
Hyperlink 'input mask' (2002 SP-2)
How can I tell if a record is locked? (2002 SP3)
Continuing Group Header to second page (Access 2000)
Flash Media (A2K)
Quarter Query (Ms Offics 2000)
Access 97 Crashes XP (97 SR2)
Read HTML File (A2K)
Functions in queries and calculated fields (XP SP-2)
INSERT INTO syntax error (A2000)
Adox Library (Access 2002 10.4302 SP-2)
Update or Cancel Update w/o AddNew or Edit (a2000)
Coding to count number of letters (2000)
Lookup Fields (Access 2002)
Multi-user database (2000)
Run time error 13 (Access 2002)
Invoice Numbering (2002)
Expression doesn't work (Access XP)
Charting a query using an expression (2000)
Access 2000 (2000)
User input idea required (2003)
Options - behaviour entering field (2000/XP)
Replace Text In Table (A2k)
User Security (Access 2000)
Entering Information (Access 2002)
MsgBox/Multi Monitors (2000/XP)
Entering Orders With Multiple Lines (A97)
Security (Access 97/sr2)
Sort Column Headings (Dates) in a Crosstab Query (Access 2000)
Different color text on report items? (A97)
Linking fields and autopopulating (1997)
lost record in part of a relationship (xp)
class not registered error (Access 2000)
Import Data from Excel Problem (2003)
Chart query problems (2000 SP-3)
Refreshing Data (Access 2002)
Page Choice for Snapshot (Access 2000)
Report Filtering (Access XP)
Update or append query? (AXP)
Exporting Access Tables (Access 2000)
A database to create *one* resume? (2000)
SQL Server DTS/FTP (SQL Serv2000)
Text box prints incorrect results of Iif (2003)
Missing ADOX Ref (2002)
Opening a Report based on a Combo selection (2000)
Help with SQL Statement!! (2000)
Macros (Access 2000 (9.0.2720))
Calculating/Displaying Age (Access 2000(9.0.2720))
Parameter Query and Filtering Form (2003)
Datasheet issue (WINXP - ACC 97)
Access 2K text Box (2000)
Entering data using combo boxes (Access XP)
Selecting from the results of a Parameter Query (2003)
Access Settings - User level (2k)
SQL not populateing recordset in code (Access 2000)
Report needs to go on a diet (2000)
Controls Blinking (2003)
Save Hyperlink (2000)
Calculating Message (A2K)
Union Query Returning Too Mant Records? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Cannot Lock File Message (2000)
Password Protect a Report (2000)
Multi-select code help
Performance Slow on Network (2003 11.5614.5703)
Shrink line with embedded photo (2000 SP3)
Fixing No License Message (97)
Syntax error (missing operator) (Access 2k)
Tab Character (Access XP)
favorite way to add new record (a2k)
Primary Key Disappears (2003)
Report has abnormally high stats (2000)
Corrupt database (97)
fields captions (2000)
Access Tab Order (2003)
WebApp (v2000)
acCmdDeleteRecord not working (2003)
access 2000 reset auto number (2000)
Telephone Directory Help (Access 2000 SP3)
Export Limitation (2000)
MISSING Object Libraries (2002/2003)
Access Backup utility not available in VB code (Access 2003)
Television viewing figures (2000)
Subform Navigation buttons (Access 97 SR-2)
next number (Accesss 97)
'Not' Query (Acc2000)
Coding not quite working (2000)
Read only to Edit (Access 2000)
Slow-opening Report (2000)
Running a query automatically in the background (2003)
Openform Command (Acc2003 on xp (2000 mode))
Closing a Form Unoticed (A2K)
Beginning VBA question - Creating Forms (Access 2000)
Test for Ctrl Key While Selecting From Combo? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Coding problem (A2k SP3)
Populating a combo with field names (2000)
math formula in report (access 2000-2003)
VBA and images question (2002)
Suppressing Warning Messages (2000)
Creating & relinking tables with relationships (A97 / A2k)
Finding Autonumber from unbound control (2000)
Parameter query (Access 2000)
Groupheader Report (A2k)
Db size with Images... (2000 SR1)
images in form (2000)
Summing output rows in a crosstab query (2000)
Coding problem again (2000)
using Public variable (XP/2K)
Running DOS comand (A2000 SR1)
Relationship question (Access 2K)
Linking tables after Unlink (A97/A2k)
Opening a Report (A2K)
Analyse Corrupt Database (2000)
Report Problems (2000)
Requerying -> Moving to a Different Record (2000)
Extract Multiple Fields From Combo Box (A2K)
Conditional formatting of a chart in a report (Access2000)
Updating a Table in Code (Access 2K, O2KPro)
Counting Records IF . . . (2003)
Why I hate Access 2003 (2003 SR1)
Password Generator add-on (Access 2K, Win2KPro, Office 2KPro)
Data not always saves (Access 2000)
Date and Time Picker Enabled Property (2002 SP3)
Duplicated Records Update (Access 2000)
Save Record (A2K SP3)
Audit trail (2000)
ref integ (2000)
Adding record to a temprorary recordset in code (Access 2k)
Averaging (2000)
Need Help Closing Form? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Extra Spaces in Report (2000)
Checking for duplicate records during input (Access 2k)
Persons age -RESOLVED
Strange Problem Appending a Table (Access 2000)
Combo Box error message (Access 2000)
copy csv files (2000)
Limits on Export to Excel (Access 2000)
Export to Excel Borders not working (2000)
customized toolbar moving down one level (2000)
Display an unbound value in a bound combo! (Access 2000 >)
Query if appears more tha once (2003)
DOCPROPERTY will not work! (Win2kSP4/Office2KSP3)
Automatic birthday warning prompt! (Access 2000 >)
Ambiguous name error message (2000)
Modify a Search Combo box! (Access 2000 >)
Pivot tables and Charts - Swapping (Access 2003)
Control Visibility Based Upon A Condition (Access
Can Shrink on Report (Access 97, sr2)
Combo Box / Auto Expand (Access 2002)
Calculate Hours (2000)
Parameter query when blank (Access 2000)
Compressing Database (MS Access 97)
Convert/Open Database screen missing (2000)
Error Accessing File??? (2000 SP3) [RESOLVED]
Mail Merge Problem Word 2003/Access 2002 (Office2003SP-1/Access2002)
MS Jet Error 3197 prevents opening DB (Office 2000
Removal of logon screen (2000)
Questionnaire problem (2000)
crating a db (access XP)
Formatting within Pivot Tables (Access 2003)
Importing an Excel range (2000)
(seemingly) strange query behaviour (2000)
Date Aging Query (2002)
MS SQL (1)
How would I filter a subform from a combo box? (Access 2000)
Parse Email String (Access 2K/XP)
User is Admin (2000/SR1)
Report layout (Access 97)
Conditional Formating - Continous forms (XP)
Keycode - Convert (XP)
Hiding subform (Access03)
You canceled previous operation error with report
Access DSN Setup (97)
Null values (Access03)
tabbing between subforms (Access03)
Viewing a Filtered Query (A2K)
Delays in VBA (2003)
Ignore Nulls (Access (All))
Create a Database (Access 2003)
Better performance processing large rowsets? (ADO)
MultiSelect ListBox (97,2000,2002)
Sequencing records in queries (97)
Displaying Fields in the Status Bar (2000)
Null fields in form (2000)
SQL strings with '' (2000)
Report names entered automatically (2000)
Transferring data from Access to Word (2000)
datepart (2000)
Access Forms (Access 2000)
Locking data in Combo boxes (2000)
Change Report Title (2003)
Web & Report Q (v2000)
Combobox not showing all records (Access2000)
Syntax Error in From Clause (2000)
must use an updateable query (2000 )
application.filesearch (2002 SP3)
Access hangs whilst running queries (2000SP3)
Adding blank lines to a report (2003 SP1)
OpenArgs is null (Access 2003/XP)
Subform problem (2000)
EDIT CHECK (97/2)
Almost matching data (2000)
SQL problem (Access 2003/XP)
Data input to a query (WXpHe OrificeXp)
Auto Splash Screen (Access97 >)
Reports - Page width and date problem (Access 97)
Windows in VB editor (Access 2000 and up)
BE MDB Table Maintenance (Access2K)
Undefined Function error message (2000)
Group By Problem (2000)
Update inventory table (Access 2000)
recordset is EOF (2000)
excel function in a query, ie Poisson funct. (xp 2003)
sort in a sub form (XP)
Access 2002 refuses to close (Access 2002/SP3)
Form/Subform Question (Access 2002)
Add a new record from combo box (2000)
join problems (Access 2000)
List Box Selection (2000)
recursive parent/child? (a2k3)
Dual languages (2000)
mde database (access 97/access2002)
displaying subform (Access03)
List Box, Goto Function on data access page (Access 200)
Query: Improve Performance (2002)
searching on a calculated value (a2k)
subform scrollbars (2002)
IMPORTING TEXT FILES (Access 2000)
How can I delete rows from all tables? (Access2003)
Keep focus on current record after code (2000 (all updates))
screen tip (Access 2000)
Sharing access (2k)
Queries and parameters (Access 2002)
Group By usage (2000 sp-3/ 98SE)
Moving between Tabs (A2K)
How do I update a table with a form (Access 2002)
Need help with a query (Access 2003)
Limiting Combo Entries (2000/SR1)
Access .IDB Files (Access 2002)
Combo box requery on subform (Access 97 SR-2)
Rolling Average (Access 2000)
Which Access version? (2000 sp-3/ 98SE)
User-Level Security and Split Databases (2003 (11.5614.5703))
Automatic Saving (2003)
Running Access Database Using Virtual PC for Mac (2003/6.1)
Open a ADOB recorset with a SQL string (2003)
Active X (2003)
Incremental numbers (Access 03)
Access If then VBA question (2k)
Make Table Hyperlink field (Access 97 SR2 XP Pro)
Inserted Chart in a Form (2000)
SubForm ComboBox (A2K)
Arrange data for chart (2000)
automatic field entry (2002)
Combo Wizard Error (Access XP SP3)
not a valid bookmark (a2k)
SQL Comments (Access 2003)
Locals Window (AXP)
Styles in Access (2000)
Restricting data entry access (Access 2000, WXP)
Adding Borders to Excel Export (2000)
Setting Relationships (Access 2002 SP3)
Query Question (2k)
Table over several forms (2000)
Use value from form to construct *like query (XP)
Append Record (2000)
Continuous Form Properties (2000)
Place to find simple start (2002)
Form Printing problem ((2000 (9.0.4402 SR-1)) )
Normalization Rules (Access 2000 >)
Access to Adobe (2000 )
Won't recognize Dirty event (Access2000)
Print Routines (A2K SP3)
Append query/ Auto number (Access 2000)
How to open a custom help file (Access 2K)
SQL: SUM with SELEC DISTINCT (Access 2003 / XP)
recordsetCLone (XP/2K)
Button for Insertion of Special Characters? (2003)
How do I abort a report with no data (Access03)
Lookup field (2000 SP-3)
Opinions please: one table or more? (Office xp)
Recalculation of Existing Fields (A2K)
Shap Shot - Looking for details (2000/2002/2003)
ODBC Invalid character (97 sr XP Pro)
Locking problems and startup code (2000/XP)
Using Filter by Form on multiple forms (2003)
Message Placement (A2K)
Listing Numbers (2000)
Access + Word playing table hockey (2003)
Error code (Access 2002)
Cnnecting to an Access database via VPN/DSL (MS Access 2000/Windows Server
Manipulating date fields in Reports (2000 (9.0.4402 SR-1))
Compress Access (Access 2000)
Prevent SQL Injection attacks (Any/All)
Upgrading from 97 to 2003 (2003)
Add a column definition with VBA (Access 2K)
Does a table exist (Access 2K)
Wrong data showing (2003)
Like 1-9* (WINXP - ACC 97)
Syntax to change Lbl Caption on Rpt from Form
Access to Word in VBA (2000)
update problem (2000)
Print Order (2000)
Import Spreadsheet (2003)
Access 2003 Conversion Toolkit Available (ACC2003)
Pocket PC for Remote Data Acquistion (XP)
Mail Button Problem (2k)
Need Help With Make Table Query? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
SQL Help (Access XP)
Findfirst method (2003)
Query problem - inside (2003)
Line chart (2000 SP-3)
Show all with parameter query (Access 2000 >)
Self Joins (Access 2000 >)
Access or Excel? (2000)
VBA Editor problems (Access 2k Win 2k)
Linked Pivot Chart in a report (2003)
Validation Expression (Access 2000)
Query Criteria (2k)
2000 (count with a date)
error message (Access 2000)
Need Help With Subreport Record Source? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Change Data Type (2000)
Temp File size too low (Access 2002)
Add criteria to a calculated field (Access 2000 >)
Searching records with accents or diacritics (A2K)
Run VBA Code When Exiting Access (2003 (11.5614.5703))
Target: (Access 2000)
Linking tables with many records (Access 2000)
Reports Popup? (2k)
check all controls (Access 2000)
Null Errors (2k)
Remove user toolbars (2000)
Wait for subform to fill (Access 2003 (2000 format
2003 Security Question (2003)
Alphanumeric Sort (XP/2K)
Need to show zero values in a query (Access 97)
OnOpen event in report (Access 2000)
Next Control has focus on return from another form (Access XP)
Need Help With Report Footer Total? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Contact name not showing after 1st Vendor (Access 2002)
Running Sum in Group Header (Access 2000)
Un-linking Paired Controls (2000, XP, 2003)
Return to form fills screen (2002)
Auto Locking Problems (97)
Database Version (XP)
Find Control (2k)
Calcualting Number of Weekdays exckuding holidays
Concatenation error (Access 2000)
Flags/warnings (2003)
Move to A2003 from A2000 (A2003)
Report disrupts modal forms? (2002)
Access on a Pocket PC (All)
updating form controls (2000)
ODBC (A2000)
Access 2003 (Trying to go to a specific record)
What is crashing Access (A97 - SR-2)
Copy Table Data w/Autonumber (Access 2000)
Error 3310 (Access 2002/Win XP)
Delete SQL (Access 2002)
Word template automation from Access (Access 97 & Word 2000)
Create Hyperlinks (Access 2000)
Move database to laptop (Access 2000)
Prevent 2 records (Access 2000)
Formatting (XP)
Importing Excel data (2003)
Delete query (2000)
References missing? (Access XP)
Need Help With Rounding? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Analyze with MS Excel (Office XP)
save file to ftp site (A2000 SR-1)
Closing a form from another form (Access 2000 SR 3)
Closing all Open forms except Main Menu (Access 2000)
Help with totals query (2000/XP)
OutputTo html? (XP)
msinet license (a2k3)
Finding a control (XP, 2000)
Getting the Max record -1 (Access03)
number and currency data type, which one? (2003)
goto record command (2000/xp)
Automation (2k)
Report Breaks (A2K SP-3)
Undo unbound combobox (2000/XP)
For...Each...Next (2000 SR-1)
Forms Order By (Access 2002)
Is this possible? (Access 2K)
Access Runtime ? (2000/XP)
Invalid Argument (Saving Query Problem) (Access 2000)
Date References (2000)
Query to Update Master List (Access 2002)
Code and/or Settings Change Spontaneously (2003)
Report Feild Restriction (2k)
Big Query (Access 2000)
Preventing rows from displaying in a report (2000)
distribution (2k on NT and Windows2k)
Docmd.OpenForm (XP SP2/Win2000/XP)
Appearance on Win XP (Access 2003 (2000 format))
Entering time in fractions (Access 2002/SP3)
How do I sell an app to someone without Access (Access 2K)
Combo Box problem (Access 2K)
Double Spaces (A2K)
Combo box scroll problem (2002)
Property Value is too Large (A2K)
Decimal places when copy to Excel (Acc 2002, XL 2002)
Delete record frmo subform (XP)
HELP!!! Database not compacting! (Access 97)
Really need help (Access 2000)
Key Fields (2k)
Very basic question (Access 2000)
Totalling Group Subtotals in a Report (2000)
How to find whole months only (Access 2k Win 2k)
Inputbox Cancel (Access 2002)
Need Help with dates (Access 97)
line number in a query (A2000 SR-1)
Resetting forgotten breakpoints (Access 2003)
can't convert (Access 2002)
Calculating median time (1997)
Monitoring correspondence (2000)
Join types in relationship window (all)
Invalid use of property, QueryDef problem. (Access 2k Win 2k)
Setting value in subform (2000)
Database Security explained (2002)
Using a variable in calculation's (97)
Fields overprint in a Report (2000/2003)
Importing Modules (Access 2002)
close page (2002/xp)
DAO Record Set (2002)
Corrupt data (Access, all versions)
Need Help With Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Creating Text boxes (2000)
Dlookup (1997)
Link Table (2000)
Data standardisation & exchange: where to start (All)
Output report to HTML and run batch file? (2003)
database Exclusively (2000)
Form resizing (2000)
List reports and their record sources (Access 97)
Filter Form (2000)
Opening in 97 (97)
Email to more than 1 email address (Access 2000)
Space$ (Access 2000)
Replicas (xp)
Restrict values of subform via VB (2003)
expression in update query (Access 2002)
2465 Audit Errors after SP3 (Access 2002 SP3)
Global Variables (All)
2004 Advisor Technical Conference (Access97-XP)