Windows Secrets
Windows Secrets Lounge
Import file via FTP (2000-->)
Mouse won't scroll (2002 SP3)
Grouping Question (Access 2003)
Sum on a continuous form (2002)
Choice of Production or Test (2003)
Syntax Error (Access 97)
If statement (Access 2000)
Counting values greater than zero (2000)
Save error (MS Access 2000)
Bit fields (Access 2000)
pre made access database (acess00)
Large Contracts in Reports (Access 2002)
Multiple select list box (2003)
Total query (2000)
Conversion Error (Acces97/Access2003)
Date problem (2000)
Problems sending 2 Emails with Docmd.Sendobject (Access 2000)
Finding Highest 5 (Windows 98)
Append Current Form to another Table (Access 2000)
Retrieve the current user name (2000)
Tracking the availability of equipment! (Access 2002)
Find Unmatched Data of Two Tables (MS2000)
Importing information from outlook to Access (2000)
crosstab query (Access 2002)
Queries (2000-xp)
Query, include records with null in multiple field (Access 2000)
Command button New Record/ Audit Report (Access)
Using concatenation to translate values (Access 2k, Win 2k)
Print Barcodes (2000)
Action Failed (2003)
table MSysAccessStorage (Access 2003)
Sorting on 2 Fields (xp)
Backup (2003)
Conditionally Hiding a Subform Text Box (2003)
Data source (Access 2000)
SubForm Totals Revisited (A2K)
Automatically Change Background Color (Access 2000)
Shareware Unlocking Registration Number (2003)
Winzip file (Access 2000)
'Unbound' labels in a report (2000)
Access - references (Win XP Access 2003)
Seperating data in a field (2003)
Automation with Microsoft Access (MS Office Xp)
Continuous Form (A2k)
Import Log File Excluding Header (2K +)
Top value for each disting ID (Access 2003)
incremental value (Access 2000)
Invoice numbering scheme (Win XP Access 2003)
Auto Importing Dbase IV Files ((2000 (9.0.4402 SR-1)))
Paramarray & functions (Access 97 SR2)
Invalid field name/expression (Access 2000)
Tracking Training (Access 2000 or above)
Adding a record adds an unwanted record in a code (Access2000)
Watermark o a report (Access 2002)
Combo Box Help (2002 SP3)
Forms based on Queries (Access2003)
Cycle Thru Files in Directory starting wOldest (97)
Grouping Query (2k)
Filtering a Subform (Access 2000)
Filter On (Access 2000)
Requery (2003)
Access 2002 Pivot Table Won't Display All Detail (2002/SP3)
DLookup (Access)
Null value (Access 2000)
Jump to Switchboard Page (2002, xSP3)
Error routines with queries (Win XP Access 2003)
Invalid Argument (2003)
OpenReport Action was Canceled (Access 2003 SP1)
default name during import (97 sr2)
More than one alternative under format (2002)
Query Results (Access)
no duplicates (Access 2000)
counting data (access 2k)
Exchange Rates (A2K)
Customized Imput Mask (2002)
monthly sales report (2000 SP3)
Customization (2003)
Using results of a query in an expression (Access 2000)
compress error (2000)
Listbox selection (Access XP)
Use of Null - Access 97 vs2002?? (Acccess 2002)
Crystal 9.0 help with max function (Crystal 9.0)
Upgrading User-Level Security (Version 2 -> 2003)
Report Columns (Access 2003)
Creating data via sub-form. (Win XP Access 2003)
Lookup field on report (Access 2000)
Cross Tab Query (Access 2000)
Treeview Imagelist (XP/2000)
ShellExecute (Access 2000)
Total Figures (2003)
Month (2003)
suppress report message (XP)
Changing the Listbox Rowsource on the fly (Access XP)
Problem with hyperlink in Access 97 (97)
Delete record in VBA (Win XP Access 2003)
DatePart('m',[dtDateChanged]) (Access 2003)
Method of programing (2000/2002)
ListBox question (2000/2002)
Recordset Clone (Win XP Access 2003)
Adding checkbox (Access 2000)
Print Preview Correct, output wrong (2002)
Can't assign report RecordSource property via vba (2003)
Adding a WHERE clause to query SQL in VBA (2002)
Validation Query Problem (2000)
Mailing Labels (xp)
View-Only Zoom Box - like MsgBox (Access XP SP3)
Lookup Previous Date (2003)
How to create a table in the back-end (2000 SP3)
diference between ! and dot (All)
Detecting when a form is closed or opened (Access 2000)
Excel Not Closing (2003)
Multiple parameter selection (2000)
Renaming (2003)
Sliding scale of charges (Access 97 SR2)
Word Counter (v2000)
Access record update from related form (Access 2003)
SQL Statement (SQL 8.0)
Exporting to Excel Question (2003)
No data for Form to display (Access 2003)
Show Record Number (A2K)
Field not updating per code (2003)
Why do my linked tables work? (2000/2003)
Form Border Color (2002)
Filter by Form (Access 2003)
Using 'Like' to filter in a query (2002)
DatePicker missing dll (Access XP)
Calendar (2000)
Hide Queries (Access 2002)
Parsing memo field into separat table (2003/SP1)
calender control crash (2002)
Font Weight in reports (Access XP)
Can't Open File (XP SP)
duplicate entries (Access2000)
Decompile doesn't happen? (Access 2003 SP1)
Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )
Missing Web Components? (XP/sr2)
Query Based on Date (2003 SP1)
Removing all but one duplicate! (Access 2000 >)
Seeking Sample Data (Access 2000 >)
#error on text functions (97)
Order Of Query Results not working (Access 2003)
Execute SQL (97-XP)
Display message depending on number of days (Access 2003)
Concatenation and commas (Access 2K)
Change Append To table (2000) - RESOLVED
Convert Text Numbers To Text (2002)
Validating table field against external database (2003 SP1)
Help With Query Totals for Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Query Error when referring to a form (2002)
Finding Friday in a week (2002)
Random Records (2000)
Secure Snapshots (2000)
IIF Statement (2003)
Not displaying whole hyperlink in report field (2000 (in 2003))
Outlook to Access (2003)
code doesn't work with some printers (Access 2000 (all updates))
=Left() (2003)
Associating Forms (2000 (in 2003))
Wrong field data (2003)
Importing Telephone Numbers (XP)
change the property of a field (Access 2000)
Delete field in table (Access 2000)
definitions? (All)
Referring to a subreport (2002)
Borrowing Power (2003 allSPs)
Data Type Error in Query (2002)
Access Connectivity (2000)
ArcView and ACCESS (arcview 8.3 / ACCESS 2000)
Import excel datasheet (Access 2000)
Make a new Query (access)
veiw all data in table format (access)
Make Table Problem (2003)
Hide Fields / records (2003 (2000))
Asterisks in field (2003)
Extract Text (2003)
copy database (Access 2000)
Determine How a Form Was Open (Access 2003)
Special Format (XP)
Assigning Value To Form Field (Access 2003)
Access Macros
List all objects on a form? (XP)
Open two copies of same form (2000)
Subform Problem (Version 2002/Service Pack 1)
Rate table (A2K SR3)
Report Total from a Field in a Group Header? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Need help with a Query (Access 97)
query join (2000)
Update Query Error (2000)
Security (Access 2 - 2000)
Udate table using update query in code (Access 2k win 2k)
Data not sorting correctly (2000)
Launch access from shortcut in win2000 and xp (2002-sp2)
Refresh linked tables (2000/03)
Unbound form to input new record (2000)
ListIndex (Access 2002 SP3)
Exclude Weekends (Access XP)
If IsNull (Access 2000)
Window:Hide/Unhide Missing (2k SR-3)
Syntex (Access 97 sr2)
Line Numbers on Report (2000)
Problem with Sort Order in Subform (Access 2000)
Project not viewable (2002)
Jet Sandbox problems (2003 SP1)
Code for this? (2000)
Setting Validation rule for about 20 controls (Access 2002/2003)
Access to SQL (2000)
Subform.visible (but isnt?) (2000)
Form caption (change with record?) (2000)
Hide column in subform (Datasheet view) (2000)
Duplicate ID's (2002)
Forms And Queries (Access 2003)
'Can Grow' format (report) (2000)
VB Code (Access 2000)
A Big Thank You re:Make Tables/TransferSpreadsheet (2002)
Select and Update queries / Macro Question (2000)
Read Only (Access 2003)
Error Message (2003)
DLookup doesn't work in Subform (2000)
Simple Access Report question (2000)
Access Search (2003)
Could not find installable ISAM (Access 2003)
2000 or 2003 (2003)
Using SendObject in intranet page (Access 2000)
delete property in remote db (Access 2000)
Date Correction (2002)
Open a Second Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Query (Microsoft Office Access 2003)
Write conflict problem (2000 SP3)
rename table in remote db (Access 2000)
find duplicates (Access 2000)
Separating Info (2002)
Copy a record to a table in a different database' (Access 2K)
Import to Table Format Question (2000)
Calling a Module from a Macro (Access 2003)
Upgrade from Access 2000 to Access 2003 problem (Access 2003)
Continuous Forms (Access 2003)
global function (Access 2000)
Public constant (Access 2000)
PopUp form (Access 2000)
OnCurrent event (Access 2000)
Treble Filter (Access 2000)
Filter listbox from textbox (stubborn) (2000)
Access compatabilities (2002)
How to store similar or repeated data (All)
Form Record Matching (2K2)
Rounding up not wanted (2002)
Split Database (Access 2003)
Change Date Format (2003 (2000 format))
Unexpected permissions error (Access XP/SR2)
Finds no match (Access 2000 VBA)
Temp Unlink (2003)
Parameter prompt (Access 2000)
Update query prompt (Access 2000)
Advanced filter (of sorts) (2000)
Converting DAO Function to ADO (2000+)
Printer Problem (A2K SP-3)
Decimal Places in a Report (2002 SP3)
Display Fractions on Forms and Reports (Access 200
If IsNull then N/A (Access 2000)
Delete records (WIN XP/Access 2003)
Access 2000 2003 (2000)
msg function (2003)
query criteria (2002)
Displaying a field in a query (Access 2003)
Max # of Fields in a Query (2003/SP1)
'Date Updated' field (MS Office 2000)
Major Task (2003)
Corrupt Access 2 Database? (Version 2 vs 2003)
Filling combo box (2000)
concatenation: unwanted comma
Auto-Number a text box (Access 2003)
MenuBars (97 sr2)
Having Icons in Treeview AX ctrl (2003)
Report doesn't show all the data underlying it (2003)
Query by form problem (Office XP sp3, Win XP SP2 )
UPDATE Query - UPDATE fields through INPUT Prompt (2000)
Displaying English Tax years (Access 2000 / Windows 98)
Expression Builder (Access 2000)
Using the Dlookup function in a subform text box (2003)
Update Hyperlinks to new location! (Access XP)
Format property (Access 2000)
Access location table (2003)
Builing a beautiful User Interface (2003)
Hiding email addresses (Any)
Form Help (Access 2K)
Multi-User / Runtime Requirements (2003)
Foorbid new record (Access 2000)
Prevent Save of empty Invice (2000 all updates)
Summation within group footers (Office 2000 / Windows 98)
BeforeUpdate Event (Access 2000)
Reports Paging (97)
Printing (Access 2000)
Excel Worksheet Hidden (2000)
fineOther user error message (2002)
Query Cal - Add 1 month to Date Value (2000)
Defualt to zero (2002)
SetFocus not working (A97 SR2)
How do I keep resource schedule from overlapping? (2000)
Missing Records In Report (XP)
Update tables with identical structure (Access 2000)
After Update (Access 2000)
Object required (Access 2000)
Data Access Page (hyperlink ServerFilter property) (2K3, Win XP)
Normalize Stree Name? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Locked data entry form (Access 97)
Printing subforms (2000)
chart Wizard (2000)
Next Record (Access 200 VBA)
Move Query (2002)
A2003 Error messages (2003)
Text fields (XP SP2, 2003)
Problem with Merge (2000)
Letters to Numbers (2003)
Sticky Mail Labels (Access 2002)
Update inventory (2003)
DoCmd.SendObject Text formatting (Access XP, Windows XP SP2)
Advise BEFORE I build (2002)
#Name? in Tab Control (2000)
Hyperlinks in forms (Access 2000)
Changing Back color (2002)
Annoying hourglass (Access 2003)
Formating (Access 2002, Microsoft Office XP)
Working with Excel (A2K)
Filter hides the subform details . . . (2003 SP1)
Automatic 'unchecking'??? (2003 SP1)
Calling a procedure from a subform (Access 2K)
Forms Opens halfway down page (2000)
Startup (Access 2K)
Exit sub ? (Access 2000)
OLB registration (A2002)
Programming to the VBE (XP 2003) (482644) was moved to the VB / VBA board
Log changes (more specific) (2002)
Filter events (Access 2002)
Max function (Access 2003)
Business Cards print one to a page (2002)
Printing a Booklet (2002/SP2)
Field in parent to determine subform (2000)
MsgBox and with Table that tracks changes (2000)
References missing (2003)
Add and delete records via button from listbox (2002 -SP2)
Export to txt (97 --->)
Tabs etc (XP 2003)
Object library references (2003 SP1 (11.6355.6360))
repeat record data (2000 and above )
report - page 2 - duplex (A2k3, SP1)
OLE Pictures in Access (Access2003)
Updating Link Child Fields (2002 SP3)
Suggestion for Best Approach (2002)
Application Title/Icon (Access XP)
automation (Access 2000)
Negative *-1 = Positive not always helps (Access 2003)
Hex to Decimal conversion (2002/SR1)
When to use .Value vs .DefaultValue (Access2K)
Query x4 (2003)
How to Wrap with Proper Chr(34)? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Play a wav file with a command button (2000)
Jumping Date Picker (2000)
Report built in 2000 not working in 2002 (2000)
Lookup values (Access 2000)
Union queries and distinct records (Access ay version)
Append Query (2K2)
Query by time of change (12 hrs ago...) (2000)
Why can't I....(union query...) (2002)
Password access (2002)
'No Current Record' message (Access2000+)
Timing Issue (All)
Textbox Value (Access 200 VBA)
Nulls/Empty String in Query (A2k3, SP1)
VBA help on if match exists (2000)
Avoiding Excessive Query Results (Access 2000)
Retrieve data from table using VBA (2003)
Criteria Choice 2 (2003)
Filtering in Union Query (Access 2000)
all of a sudden I cant create replicas (2002 SP3)
Reports (MS Access 2000)
Data Type when importing from Excel (Access 2003)
How to Trim correctly (A2K)
User Applies Filter - Recordcount? (Access XP)
Combining Data in Two Fields into One New Field (2002)
PtoP network and Access DB (Win XP Access 2003)
VBA Code Help (2003)
Twosome Query becomes treesome (Access2003)
Tabbing to Yes/No field (2002)
Run-time error
Qry Form Change (2002)
Global Variable syntax (ACCESS2003)
link foxpro table to access (Office 2000)
Print Form/Hide Menu (A2K SP3)
Resetting Autonumbers! (Access 2000)
Simple Dlookup (2002-Sp2)
Can't Import Excel File (2002)
starting a database (access 2000)
Emailing a Selected record from Form View (Access 2000)
List box control error (VBA) (Access 2000)
Default Value Property (2000)
Is Not Null (Access 2000)
Listbox RowSource (A2000/A2003)
BackColor/Text (2003)
Subform Requery / Refresh (2000)
Query from a subreport (2002 - SP2)
Removing Duplicate Records (2000)
Undefined function 'Format' error (Access2003)
Creating a Report with VBA (Access 2003)
Replacing Data with Import (2000)
requery textbox in subform (2000)
Building Calculation (2000)
Import Excel File (2002)
Filter By Form Button (2000)
Log Changes not working (Access 2000)
Select Distinct Combo (2002-SP2)
Using docmd in another database (2000)
access 2000 upgrade to Access 2003 problem (Access 2003)
On the Road no CD (Access 2000)
Dates in Query (Office 2000)
Dates (2000)
Select options (Choose items to print)
Run-time error 3075 (Access 2000)
Stumped on creating a tough query (Access 2003, Win XP)
Add record to table from command button (2000)
DateDif (2000)
Add field to backend table (2002)
2585 Error (97)
Multiple data sets in a graph. (Access 2000)
Sort Union Query Decending? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Efficiency in calling a value (2000 SR3)
Counting in a report (2000)
Inserting Data to the Buffer (A2K SR1)
Focus Setting on Tab Control Content (2003)
Cross tabs (2000)
Nullify KeyDown (A2K)
Subreport error when getting info from XTab query (Access 2000)
Form Problem (2002)
Force a form to show null values (Access 2000)
Print guidance (2002)
Using more than one table/query in a form (Access XP)
Value Transfer (Access 97)
Now() (Win XP Access 2003)
Help on building an expression in a query (2000)
Displaying Dates & Times (A2K)
Crosstab Query with Parameter (2000)
Which access template (2003)
Transparent sending of e-mail (Access 2000)
Access and Excel - Ref Last Column in Excel (A2k SR1)
Detecting incorrect format for text box entry (Access 2000)
Pass Thru Query (Access XP / SQL 2000)
File sharing problem (Access97)
filter query based on calendar control (2002)
A way around Recordset Not Updatable (2000)
Change to report background colour (Access 2002 -Sp-2)
Manipulating Excel (A2K SR1)
Text Menu from Command Button (2000)
After Update Error (2002)
Print only first page on report (2000)
Subreport Page Headers (2003)
Msgbox on multiple lines (2000)
Sub Queries using VBA (2000 (9.0.4402 SR-1))
DLookup (Access 2000)
Subform Mystery (2003)
Turn confirm Action Queries on then off in macro (Access 97)
html form, using vba to work with access (acess/html/vba)
Yes/No Field on Report (2000)
Dates to day of week (2002)
Exporting Issue (2000)
Switchboard limitation (2000)
Dont know what to call it (Access 2003)
Permissions (Access 2000)
Update question (Access 2000)
Show a picture in a form or report with same quali (Access 2002)
Queries (2002-2003)
Print results of query (2000)
Split Table Design File Size (Access 2003/XP)
DAO.Recordset (WinXP Access 2003)
SQL Copy/Paste (Access 2000)
Running Count in Query (2000)
averaging (2003)
Run-time error when moving off a text box (2003)
Overflow Error (2002)
Two Combo Boxes (2000)
OpenArg again..... (2000)
Multiplying by 0 (Access 2000)
Access Report VBA error (Access 2000 Pro)
Error appears when choosing ODBC Datasources (2003 SP1)
Using .htm page to open report in Access (Access 2003)
Filtering Reports (Access Pro 2000)
Lost object (2002 SP-3)
Access Reports (Access 2000 Pro)
Find unmatched records (Access 2000)
ADO Adding Recs (A2003 (as A2K))
Help Need (2003)
Crosstab Query Total ROW? (Access 2000)
Form goes to new record (2002)
Suppress Page 1 Page Header (2003)
Setting Up Time Stamp (2002)
Move left (Access 2000)
Delete selected customers (Access 2000)
sub-reports (2000)
Problem with Append Query (validation rule violati (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Deleting a Custom Shortcut Menu (Access 2002)
Sending email via OUTLOOK (2003)