Windows Secrets
Windows Secrets Lounge
OLE Object field no longer works (Access2000)
Crosstabs as recordsoucre for Reports (Access 2k)
Functionality issue with 2003 (Access 2003)
Put a small Access database on the intranet (2002/xp)
Changing input mask (2000)
How To Remove Dashes From Phone Number? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Uppercase (AccessXP 4.30)
parsing a string with up to 2 commas (a2003)
If...Then 2 conditions (a2003)
Formatting text boxes (2000)
determine main form's name (a2003)
Automation giving mail undeliverable errors (Access 2k Win 2k Outlook 2k)
Where is my application? (A97+)
Creating Graph on Access form programmatically (Office/Access 2000 SP1A)
OpenForm where condition (a2k)
Output using VBA not consistent (2000 SR1)
Export data to Excel (2000)
Date calculation returns invalid date? (2002)
calculating results on a subdatasheet (2000)
Access97 to 2000 conversion (2000 - 9.0.4402 SR-1)
Search by part of last name (Access 2000)
Form with 2 subforms (Access XP)
Setting A Label's Caption (A2K)
Form Field's Tag (Office/Access 2000)
Input Mask Fail After Deleteing Data in Control (2002 10.4302.4219 SP-2)
Update table field based on event (Access XP)
2003 problem? (XP, 2003)
Dynamic text field sizing in a Report (2000 SP8)
DCount problems (A2k)
Default value in dropdown (2000)
Importing (2003)
Sorting within a report (Ac97/WinNT4)
Query design (Access 97)
Error in Code (2000)
Reports: Select and print multiple records (XP)
One PC won't use file DSN (2000/2002)
Find Character in String (2000)
synching forms (a2003)
Time Format - Fractions of Seconds (2002 SP3)
SQL Server for Dummies (2000)
Problem with linked forms (2000)
Printing The Backside Of Report (Access 2K)
Continuous Form Design (2002 SP-2)
numbers wont apprear in preview (2000 sr-1)
Officelinks missing (2000 9.0.6926 SP-3)
Access limitations (2000)
yes / No radio buttons (2000)
RESOLVED:Transferring of details from table (2000)
Run Time Error 91 (A2K)
Current And Previous Record (Access 2000)
Sorting memo field (2000)
SQL statement in VB code - need help (xp)
SendObject Problem - Help! (MSAccess 2000 (SR1))
Hyperlinks and Export (Access 2002)
Lock a record in a table (97/2000)
How to Select Data for Report (Access 2002)
Another .adp issue (Access2K/SQL)
sorting problem (xp)
Many-to-many relationships (XP, 2000)
Combining Databases (XP PRO)
PDF reports macro (2000)
Column sorting on subforms (A97 SR2)
Network Recovery (2002 10.4302.4219 SP-2)
Calculate values from fields in the previous row (Access 2000)
Missing field calculations on Joined tables (Access 2002)
Max Font Size (2000/SR1)
Modifying searchdb (Access 2000)
querydef problem (Access 2000)
Need template help (2000)
How To Fix Bad Dates With Code On Link? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Set Focus to End of Text in Form Control (2002 10.4302.4219 SP-2)
Input Box (Access 2000)
Multi word search on two tables (Access 2000)
Append query (Access XP)
DIY Quicken (2003)
create a query form (Access 2000)
Totaling Yes/No Data Types (Office 97)
Remove/Delete User Account (2000K SR-1)
Report Selection Form (97 sr2b)
Sending Email to Multiple Recipients (Access 2000
Sorting/Alphabetize (2000)
Date/Time Field Problem (Access 2000)
When is data in table underlying form updated? (2000sp3)
Date Formatting (Access 2000)
Delete All Records in Table (Access 2002)
Limiting No. of Char in Text Box (Access 2002)
Textbox Backcolor (Access97 SR-2)
Importing from Excel (Ex 2002)
Missing Search Function (Access 2002)
Allow Design Changes (Access 2000)
Getting text data from a form (Access 2002)
Query expression (Access 97)
single form/multiple reports (2000)
Library database design (2000)
subreport to force page (2k)
Updated Query; Field Not Available for Report (XP)
Export Design Changes Only (Access 2000)
Trapping 'Operation Cancelled' during Append Query (2000)
Cursor position (2000)
Another SQL question (2k)
Import from Word Table (Access 2000, WXP)
Variable Report Sources (A2K)
Progress Bar (Access 2002)
Inventory Control (Access 2002)
Query quandry (Access 2000)
Totaling Yes/No Data Type (Access 97 SR-2)
Sums for inventory (XP)
Increment a text field on a form (Access 2000)
Invalid Argument (Access 2000)
Click on macro for date (2000)
Creating Report From Make-Table Query (XP SP-2)
Number formatting (code) (2002 SP-2)
Having access 97 & 2000 on one PC (MSAccess)
Month/year date (XP)
Automated Mailmerge from Access (Access 2000)
Not a valid bookmark. (Access 2000)
Jet Engine Issue (Access 2000)
Overview Record Locking (XP/2K)
Code help stLinkCriteria (2002 SP-2)
subform usage (XP)
SOLVED - semi-autonumber query field (97/all)
Resolved: RecSelCbo box on a form (Access 2000)
Date format (2000)
Calculating a rolling yearly sum (Access 97)
Query for a range of dates (2000)
Subtotalling a subtotal (2000)
Select RecordSelector (97 - 2002)
Print From Form (2000)
SQL server (MS Office 2002)
Deletions from a subform/Inactivity detection code (Access 2000/2002)
=dcount (Xp, 2000)
using a string as a saved file name (Access 2000)
Some boxes missing when printing a form (2000)
Record conflict (2000)
SQL for Daily Quota (any)
Export to Excel - to a specific field range (Accesss 2k)
some switchboard items... (2003)
linking PK in subforms (2000)
MZ-Tools (All versions)
Email multiple reports together (2K)
Print Preview (2000)
using wilcards to delete a table (Access 2000)
setfocus problem (Win2K SP3/Access97)
Combine sources for report (XP)
'Tab' to next Tab Control Page (2000/XP)
Efficient events on forms (2000/XP)
Format controls with focus vba (2000/XP)
Interest Question
Decimal Places (2000 SR-1)
Mail merge no longer merging (Access SP3)
Calculate future business week date (Accesss 2k)
Unable to create MDE database (Win2000 SP8)
multiple answers in data entry form (A2K)
conditional Set frm (A2003)
Opening an Excel File from Access (2000)
Create table with date in name (Access 2000)
hide/unhide form (a2003)
Query property question (XP, 2000)
Switchboard Manipulation (Access 97 SR-2)
Validating a field (XP/2000)
Command Button Wizard (Access 2002)
BOF EOF (2000)
get data from form to subform/Masochist (2000)
query calculation (2000/XP)
Importing data (2000)
DAO problem (2000 SR-1)
Is there a Query 'Dynaset' anymore (Access 2002)
Find and Replace (Access 97)
Lookup fields: Why the bad rap? (XP)
Use A Variable To Reference A Subform.? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Form won't accept input (2002)
Criteria -- best practices (All versions)
Form Controls (97sr2b)
fields in crosstab query (A2000 SR-1)
Create a word file (2000)
mailto command (2000)
Cascading subform combobox : can't get source OK (97)
Importing tables keeping relationships (97)
Printing on a premade hardcopy form (Access 2000)
Record count not correct on subform (XP, 2000)
Access97 conversion to Access2002 (Access2002)
Calculating averages (2000)
Access runtime (Acc97 on xp)
Developer Utilities? (XP, 2000)
Open Args setting (Acc97 on xp)
Left() function error(2000/xp)
IIF() possibly causing database to crash (Access 2002)
Query design (Access 97)
Deleting a Table in VBA (Access 2000)
Query - or report? (XP, 2000)
Report Filtering (2000/SR1)
Date Range In A Report (Access 2000)
Open file (Office 2000)
Linked Tables (97)
ControlCaptions in Design View (XP/2K)
access (2000 sr1) (359260) was removed
access - disable delete table prompt msg window (2000 sr1)
Summing across tables (2k)
access vba problems (2000)
Report title using a field value from a table (Xp, 2000)
Help file (XP, 2000)
help with another missing function (Access 2K/SQL 2000)
Calculating number of days between dates (Access 2000)
Access 97 Locks Intermittently on XP Pro (Access 97)
Format Year With Leading Zero? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
SubDataSheet (2003)
Access Switchboard Manager (Access 2002)
Last 5 records (Access 2K)
ODBC (Version XP)
extract email attachment, append to mdb (2003)
Select from a form to a query, but then it jams (2000)
subform option group (2003)
Changing control propert is saving blank record (A2k)
DSum zero value (A2K Sp-3)
Linked spread sheet open exclusively (Access 2000)
access - bugs (2002/2003)
'non-functioning' combo box (2002 / SP2)
Linking tables over network (Access 2000)
KeyDown Event Conflict? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Display Column Name and Field Value in ASP (Access2K, Win2KPro)
Invisible Field Names (2000-SP3)
Browse For File (Access 2000)
Electronically Share Stacked Bar Graph (Form) (Access 2000)
Date payment falls into (2000)
Auto save? (Access 2000)
Page breaks in subreports (A97 SR2)
Query Text (Access 2000)
Recordset error with subform (Access 97)
VBA Error Handler Add-in (2000)
Hassles with outlook security (A97)
why check boxes are not unchecked (2003)
Email using SendObect (2000 (SR1))
Jet4.0 service Packs (A2K SP8)
Datasheet form subform workaround (97)
Is there a way to turn off auto highlighting (Access 2000)
vba code (a2k)
Command button color (2003)
CurrentProject Compile error (Access 2002, SP-2)
Code for 'DonorID' (XP)
Automate Access from Word (Access 97)
How To Control Up/Down Arrow Key? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Autmatically saving a merged in Word (Access2K)
Post Code Combinations (Any)
copy and paste (Access 2000)
Previous Date (2000)
Can't Open Any More Databases - Error 3048 (XP/W2K)
Resetting Autonumber Seed (Access 2K)
How To Count Specific Records In SubForms? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
changing the SQL view font (2002 SP2)
Embedding Word and Excel in an Access db (Access 2002)
Runtime Error 2803 (WinXP/Access 2003)
Trouble registering ACTIVEX component (Access 2000)
SendObject won't send (2000)
'Insert Into' SQL Error (Access 2003)
Append duplicate record based on quantity field (A2k )
name of VBProject (2002 SP2)
Writing Query to exclude records (2002/SP2)
Sort by Date (2000 (9.0.2720))
Unmatched Query (Access 2002 SP2)
Subform linking fields headache (2000sp3)
emailing without Outlook (2003)
FAQ Database (Access XP)
Dynamically count down number of characters left (2000)
Subform not working (Access03)
Proper Validation Structure? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Problem Entering Lines On An Invoice (Access 2000)
Access Word Merge (Access 2000)
Cross Tab Totals (2003)
Can I Use Dmax/Dlookup To Do This? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
advantages of 2002 file format (XP SP2)
Sub Form wizard (XP 2000)
Combo Box Search (XP)
Sorting text field of mostly numbers in a form (Access 2000)
Emailing through Access using Mozilla (2000/SP-3)
Like expression in query (2000 & XP)
Autofill Word Document from Access (2000)
Adding a new AutoNumber field (2000)
read only - 'access denied' (windows xp)
Multiple selections in combo box (Access 2000)
Autonumber seems to have rest itself (2000)
Type Mismatch with ZIPS in Access tables (Access 2000)
Alternate Landscape and Portrait in a Report (Access 2002/SP2)
select record in query to display on form (Access2002)
Numbering Lines on a Report (2000)
Rounding negative numbers (A2K SP-2)
Autonumber (Access 2003)
Query on 3 fields (Access 2000)
Access Wizards (Office 2000)
Slow Network? (Access 2002)
Separating/joining labels and text boxes (XP/2000)
Looking For Proper Query Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Excel vs Access (2000+)
DDE Parameter Problem (Access 2000 / Word 2000)
Form fields won't update (XP)
Problem With Combobox From Query (Access 2000)
disk full error (Access 2002)
Blank field in criteria (2000, 2002)
Reverse Words in a Field (2002 SP-2)
Extract Word from a Field (2002 SP-2)
Report to look like Excel (2000)
Output to My Documents (2003)
Multiple calculated fields in a query (2000 SP3)
Proper VBA Syntax (2000)
Parameter Value in a date? (2003)
Access Query Combine Fields (AccessXP)
Access VB 'Bookmark' (2000)
Keeping Selected Year (Access 2000)
Need to get Path of current loaded database (Access 2000)
Editing data in a Crosstab format (A97)
Table Design (2000)
Database Window (XP)
TransferSpreadsheet (Access XP)
remove duplicates from query results (xp)
Auto Tab To Next Field When Current Field Is Fille (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Conditional Formatting and a VBA questions (A2K)
Tree view (2003)
Shift Key Control (2003)
Networked Database (Access 97)
Identifying/Grouping Based on Sum (Access 2002)
Access Report (Access 2002)
MS Outlook forms using Access (Os=2002, Outlook 2002, Access 20002)
Import Help (Access 2000 SR1)
Working with large amount of data... (97 SR2)
Disabling?? hyperlinks... (2000 SR-3)
Clearing a record (Access 2000)
Calculated Queries - advice (2000)
correct SQL (Access 2000 all updates)
Replication? (Office XP - Access 2002)
Create Link (Access 2002)
Cascading Combo Boexs On Datasheet? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
How To Reference Control.Column in Sub Form? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Accessing a table cell from VBA (2000)
Linking to FileMaker (Access 2000)
report in a form (2000)
Title bar caption (2000)
Referential Integrity (2000)
SQL (all)
Date Queries (2002)
Error on Conversion (Access 2000 SR 1)
Recordset Coding Reference (A2k SR1)
Access installer (XP developer)
How to clear the conditions (Access 2000)
Referencing Control with Focus (A2K SR1)
upsizing querys and iif (Access 2000 sp3)
Get Data from SQL Server (VBA/Excel/2000 SR1) (354670) was moved to the VB / VBA board
Combo box row source (Access 2000)
How To Put Code In A Sub? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Selecting a file (XP)
Calculated Control in a Continuous Subform (Access 2k/XP)
Automating Subform actions (2000)
Update record change (Acc 2K)
Hiding Control On Form (2000)
Incrementing Expression Field in Query (Access 2002 SP-2)
Combo Box Source (2000 - SR2)
Looking For DAO Denormalize Code? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Importing data (XP)
Automation and Batch Processing (Access 2000 + SP3)
Join Queries (2000)
Access 2000 and Sourcesafe addin (Access 2000)
Key Violations in Append Query (Office 2000, Win X
Remove Access controls (2000)
Ctrl+Shift+F2 Discovery (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Indexes on Yes/No fields (2000)
Criteria in Domain Aggregate Functions (Access 97)
Totals Query (2000)
creating a query with a check box form (2000/02/03)
How would I handle different years in a database? (Access 2000)
PDF995 (Access 2002)
Worth converting to tabs? (A2K)
Using a variable for a field name (A2K)
Apples & Oranges (A2K)
Update function (Access 2000)
Table Design for Sports League (2000)
Requery all controls and subforms (Access 2000)
Converting Values (Access 2k)
Archiving Previous Years Data (Access 2000)
Searching A Word Document (A2K SR1)
isn't enough memory to perform this operation (access 2000)
Compare query (2000)
finding duplicate field dates (xp)
Running cumulative totals (2000)
Country table (97/XP)
Different Access versions on same drive (2000/2002/2003)
Compact & Repair (Access 2003)
Forbid design view (Access 2000)
create toolbar (Access 2000)
Multi User Diary (Office 2003)
Update Tables (2000)
report (2k)
Security for ALL Databases (XP, SP2)
No Ref Integrity (2000)
adding numbers (Office XP)
Query from form (2002 SP-2)
Can't delete replication choices (Access 2K)
Won't accept dates correctly (XP, 2000)
replacing values - best method (Access 2000)
Need tutorial on publishing to Web (Access 2003)
Icons on Title Bar of Forms (Access 2000)
Access Security - user prompts (2000 SR-3)
Move from Subform to Mainform using tab (XP/W2K)
PreviousControl (2002)
Variable Tax Rate (XP)
Currentdb vs dbEngine(0)(0) (XP/W2k)
Select text on enter field/control (XP)
Query Problem with Date (Access 2000)
Report Page Count (Access 2K)
SQL query question - once again! (Access2K, Win2KPro)
prohibit adding new records with older dates (Access2000/WinXP Pro)
access report (access xp)
Importing text files (Access2000/WinXP Pro)
Creating Relationship vs. Query Joins (2000 and 2002)
Report Tips/Hints (2000/2002)
Query records that fall within a date range (2000 SR-1)
Access 2000 / SQL 2000 (Access 2000)
Too Few Parameters, for an SQL String?? (Access 2K)
Searching for Records (Access 2002)
Mail via Lotus Notes (Access 2000/xp)
db creation assistance (A2K)
update condition (Access 2000)
Formula for expression builder (2000)
a little help? (1.0)
refreshing a form (Access 2000)
DoCmd.OpenReport stDocName, acPreview Question (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Scanning using Kodak Image Controls - SetScanCapab (2002)
Use a form as multiple subforms? (2000/sp3)
Query MAX (2000)
Table field lookup question (2000/sp3)
Need Correct OpenRecordset Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Time after Time (A2K)
copying previous records (Access XP)
hiding db window (Access 2000)
Access Window Minimizes (WINXP - ACC 97)
Outer Loop Not Working (Access 2000)
Access97 on XP (Access97)
Loop thru records to check for error (Access 2000)
Summing several Count fields (Access 2003 SR-1)
Me.strClearedBy = Null (not working?) (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Restoring focus (2002 on 2000/SR1)
Clean text to only in set [A..Z0..9] (2000/sp3)
Synchronize ComboBox & Subform (2000)
AllowEdits in subforms on tabcontrols (2000)
Disconnect Access Users (Access 2000)
It's Dirty Time! (A2K)
Report Page Number (97 sr2b)
Click on a tab in a tabcontrol (2000)
Access Menus (2000)
MaxLocksFile registry (XP/2002)
Show 'x of y' in report. (Access 2002 SR-1)
Form feeds on Odd page numbers (Access 2000 SR-1)
Workgroup info file resets to default system.mdw (Access XP)
Recordset won't open with Order By clause (2000)
ACCESS 2002 Sort (Access 2002)
Compare Database Versions (Access XP)
Clear Field Data in Query (2000 - SR2)
Error 3072 (Access 2000 SP3)
Conditional Field Formatting (2000)
Keyboard scroll listbox (2000)
Easy Date Formatting Question (xp)
Is control source a formula? (Access 2000)
File Revision Number (2000)
Report(2 Pages View) (A2k)
ADO recordset problem (Access 2000 9.0.2720)
Need SQL or DAO Code? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Looking for Dlookup Syntax, Again? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Daily Count (2000)
Converting databases (Access 2003)
Strange Behaviour (Access 2002)
Transfer control to another database (2000)
Populate Combo Boxes from Other Combo Boxes (Access 2002 SP-2)
Parameterized queries used in SQL statements (Access 2002)
Accessing a sub forms fields from the Main Form (Access 2000)
View combobox data in textbox? (2k/sp3)
SQL DELET operation (Access2K, Win2KPro)
Option boxes on Form (2002)
Align Text (2003)
Report: How to start new page with each main sort (2003)
Regional Date Settings (2000/XP)
Removing a button from record selector (Access 2000)
Can I Increment/Decrement a Form Text Field? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Bar Code Add In (97 sr2b)
Subforms (working) & Subreports (not) (Access 2002 (10.4302.4219)
Email Report (XP)
Web Page Form (Access 2K)
Jet 4 Service Pack 8 message (2003 )
Field tabbing problem (Access2K, Win2KPro)
Using Menu's/Toolbars to control a report (A2K SR1)
checking for corruption (Access 2002)
Have one form wait for another form to complete (2000)
Query Help (Access 2002)
Looking fro On Key Down (Ctrl
Write Conflicts - Data Changed by Another USer (Access 2002, SQL Server 2000)
Design help (2002)
Report on 2 querys (Access 2000)
Page Header Printing in a Report (2000)
Subform totals (2000/2003)
Changing the Record Source property (Access 2000/XP)
linking fields in sub-form (2000)
SubDataSheet Name (XP/W2K)