Windows Secrets
Windows Secrets Lounge
Import/export records (A2K) (A2k SR-1)
Conver 97 to XP (Access XP)
Adding to comments (A2000)
Access 2000 Tables/Forms interacting w/ Front Page (2000 )
attach a file, csv file email (access 97)
Run time error (2000)
Splitting a Tie! (A97)
drop down list on parameter of function (A97)
Asynchronous operations (2000)
Key press cancelling (Access 97/SR2)
Locking (Access 2K)
InStr Function (A2K SR1)
Create readable owner names (A2K SR1)
Need CR & LF in Report Text Box? (A2k (9.0.3821) SR-1 )
First Business Day of Month (97 sr2)
Check for object before delete (A2K SR1)
Limiting the number of entires to a table (A2k Sr1)
update table (Access 2000)
Switchboard Freezes (Access97 SR1)
Table Comparison messes up order (97 sr2)
Access/WORD Mail Merge - Help ! (2000)
zero records affected (access 97)
Macro Execute (2000)
Switchboards in Access (2000)
Spreadsheet functionality (Access 97 SR2)
Access and the Internet (Access 2000)
Save forms format but change field list (Access 2000)
Groupwise (97 sr2)
Chart wizard? (AXP 10.2627.2625)
Error Problem (A97 SR01 under W98)
sum pages (2k)
database relationships (Access 2000)
Getting started (Access 97)
Access 2K (2000)
Flatten DB for Word Merge (Access 2000 Sr-1)
This Recordset is not updateable (A2KSR1)
Append tables (Access 2000)
ADP - Yea or Nay? (Access2000)
Organizing Excel to Access (Access 97)
Check box input in table (Access 2000)
Update older DLLs with Package & Deployment setup (2000)
Finding All Query Uses (Access 97)
No data in group (No data for Group in report)
Access 2000 & 2002 (2k & XP)
SQL server help (AXP / WIN2K / SQL 2000)
Parsing (97)
On NotinList (Access 2000)
Table Entries (Access 2000)
Graph / Runtime Access 97 (runtime 97)
Label format changes (2000)
Date periods (Access 97/Windows 98)
Deleting or Hiding lookup records (2002/SR-1)
Wildcard as text (Access 2000)
Cascading Combo Box Demo Question? (A2k (9.0.3821) SR-1 )
Programmatically set references (Acc 97 sr2 on 95b)
Exclude from Compile (Acc 97 sr2 on 95b)
Button (Access 2000)
Problems Passing Open Arguments? (A2k (9.0.3821) SR-1 )
Looking for an Address Book (2002)
taking out a character (Access2000 SR1a)
More on corruption (2000 sr uncertain)
i wan to avoid DAO (Access 2000)
Booking system (2000)
Grab Date/Time From SQL Server (2000)
Cascading Combo Box Demo Error? (A2k (9.0.3821) SR-1 and A97)
vbMsgBoxHelpButton (2000 sr1)
Make Progress Bar run with update query (Acc 97 sr2 on 95b)
Detecting duplicate records (Access 2000)
Unformatting Text (2k)
Format numbers (Access97)
Database backup (97)
Link to SQL-Server table with ADOX (Ac2000 SR1)
Date() doesn't work on some systems (2000)
FORM SIZE (A2K SR1)
array (Access 2000)
ApplyFilter Access 2000 (1)
Access (97)
Linked Table properties (2000 SR1)
ActiveX date picker problem (2K)
Date calculation (2000 SR1)
Combo Box & Navigation Buttons (Access 97)
Icon (97)
Security Problem (v2)
Access 2000 to Access 97 (Access 2000/Access 97)
Run Time Environment (97 SR-2 on Win NT 4.0)
Move cursor (Access 2000)
Ez Way to modify pricing (Access 2002, SR 1)
If...then (2000-2002)
Saving an Object from MS Project to MS Access (A2K SR1)
Valadation on a Form (Access 2000)
Using Calender Control (Access 2000)
Two database files from Microsoft (2002)
calling a procedure in a different form (97)
How to do Update Queries (access 2000 -2002)
Dynamic headings on crosstab-based report? (2000/SR-1a)
Update odd # to A and even # to B (2000)
Password Protect a Field (2000)
random autonumbers all positives (2002/SR-1)
Emailing from Access 97 (Access 97)
Cant see screen (Access 1997)
Auto Access to Word (Office 2k sp1)
Hidden Forms (Access 2000)
security using command line (A97)
QUERIES WITHIN A FORM (Access 2000)
Report Code (Access 97)
Relationship plotting ('97 SR1, Win95b)
Replication conflicts (2000)
Form in Design view (Access 2000)
input box (Access 2000)
Looking for an address book (2002)
Update Query On Memo Field (97)
Update Query With 4 Values (97)
Form closure (2000)
PageUp and PageDown (2000 SR1)
forbid opening a form (Access 2000)
sort order problem ('97)
Multi Column Subreport (Access 2000 /2002)
how can i use an array (Access 2000)
generic code (Access 2000)
Error2501 (A2000)
Over Write or Disable (A2000)
Paste into Find Dialog Box (office pro 97 access)
Crosstab values shift with TransferSpreadsheet (A2K)
LookUp list not alphabetized (2000)
Trouble with a Subform (2002)
Creating a Calendar Report (2002)
Compile Error: (A2k Sr1)
Saving records sooner (Access 2k)
where statement (Access 2000)
Removing duplicate data from report (2002)
switch autofill (97)
Access is running too quickly...! (2000 SR1)
Option buttons stay gray if in an option group (A2K)
Return a Random Selection (Access 97)
Report, Record Sources (Access 2000)
Validation Rule violation with no validation rule? (Access 97SR2)
Access 97 in XP (SR1)
Outer Join Problem (2000)
Error handling (Access 97 / SR2)
Document management with Access (XP/ 2000)
VBA - Passing form controls values to saved query (Access 97)
crosstab query vs. subqueries (2000)
Report text box reference (2000 sr1)
How To Move Form Code to a Module? (A2k (9.0.3821) SR-1)
IIF statement in a Report (97)
Open a form based on a value from another form (2000)
Saving a record problem (Acc97 v2)
SQL syntax help, I think (Access 97/no sr)
Users who are logged on. (AXP / Win XP)
Send query info to Excel template (AXP / Win XP)
Conflict in 'Allow Zero length' (access97/sr2/vba)
PROBLEM WITH OPTION GROUPING (Access 2000)
Macro with Outlook (2000)
Enter Key Fires Hyperlink Field? (A2k (9.0.3821) SR-1)
error message 9738 (office 2000)
Use Msgbox in macro? (Access 97)
FORMS (2000)
> No of People (A2000)
ADODB Connection String (1)
Parameter query (97)
SetFocus Not Working for Me? (A2k (9.0.3821) SR-1)
Password (Access 97 SR-1)
Record Number (A2000)
Access 2000 Update Query (9.0.2720)
Assign value to a Text Box (Access 2000)
ADO problem - 'Mutliple-Step OLE DB'... (ADO 2.5, 2.6)
Duplicate in 3 fields (A2000)
Manipulate Outlook Express (2000)
Images in a table that are 'specified' in a DB (2000)
No MatchEntry property in Access combo boxes? (97/SR-2)
IIF function with text field (Access 2000)
ldb file = 0 kb? (WIN2000-ACC97)
Access Security (Access 2000)
Include nulls (Access 2000 SR2)
Snapshot & Hotmail (Access 97/SR2)
delete records in a field (Access 2000)
Calculated Expression (Access 2000)
Subform (97)
Code ? (97)
Doesn
Crystal Reports (Version 7)
referring to sub-form (2000)
Preventing CLosure (Access 2000 SR1)
Multiple Join Criteria (A97)
ADO Help Files (2000 SR-1)
How to loop through a control (Access 2000)
Need code to run when backend is closed. (2002/SR-1)
Opentable question (access 2k)
Queries (AXP / WIN2K)
'Opened Exclusively...' (Access 2000 on NT)
Contents of field doesn't show on form (A2K)
Finding values (Access2K)
Code Question (97)
MSGBOX (AXP/Win2K)
Multiuser Security (A2000)
Gantt style chart (AXP/Win2K)
CROSSTAB PARAMETER QUERY FAILS (2000)
how to convert query into sql (Access 2000)
Compact not completing process (Access 2000)
Naming Tables - error 3131 (access97/SR2)
Phantom tables in the Relationships window (Access 2000)
To break or not to break (large tables) (Accesss 2000)
No warning upon record delete (Ac97 SR2)
Timers (AXP / WIN2K)
Get Username (Access 97)
Creating a multiselect list box (97SR2)
How to Count Records? (A2k (9.0.3821) SR-1)
Open a specific Access Form (Access 2000/SR1a)
Duplicate mailing labels (Access 2000)
Information at a glance (2000)
keeping form up-to-date (2000)
Change pg hdr for 1st pg printing grp ftr (2000sr1a)
CursorType (Access 2000)
Runtime Install (Acc2000 Sr1a)
Combo Box Problem--Help ASAP! (Access 2000)
non related table holds criteria (Access97)
Grab user name from Windows (AXP / Win2K)
Window - size to fit form (A97)
Auto Add Form Name? (2000 (SR1))
Math (AXP/Win 2K)
Capture NT Login (Acc 2000)
1, 2, or 3 tables? (AXP 10.2627.2625)
The Mystery of the Disappearing Subform (Office 2000 Sr1a)
Outlook Mail using Access (AXP / WIN2K)
IIF Function (Access 2K (SR-1))
Wildcard in VB code (AXP/Win 2K)
F1 Key (Acc2000)
Duplicate Record with No Duplicate Key? (A2k (9.0.3821) SR-1)
Can Shrink to remove report white space (Access97 SR-2)
list box in report detail (97)
Delete Query Error (2000)
link access with Quickbooks 2001 pro (2002)
Slow Loading Form (Access 2000 SR1)
Control Text Box? (2000 (SR1))
Access Macro (2000)
Help with AutoIncrement (Access 97 )
Trim (97)
MsgBox vbOKCancel Decisions (Access 97)
Query with No Values (Acc97)
what arguments? (2k) (127805) was moved to the Project board
Need to Create EDI Recordset (2000 SR1a / XP)
Office XP user not able to write to 97 database (Office 97 & XP users)
Switchboard (Office 97)
Prob: Making data entry form for survey (Access '97)
Closing Application upon non use (2000)
convert (2000 sr-1)
Adding to Running Comments (2000 (SR1))
Relinking SQL Tables (Access 2000)
Totaling (2000 Sr1)
Locking Table (Access 2000)
ODBC (A2000)
Save A2k Project as A97? (A2k (9.0.3821) SR-1)
Report Footer or Page Footer? (2000 SR-1)
Dates Issue (Access 2000)
Dumb query question (2000sr1a)
Background Fade (2000/SR-1)
Select value from record (Access 97 SR-2)
Utility to summarize data values (Access97/Word97/SR2/VBA)
Append records that have auto numbered key (97)
Error message (2000)
Count Query Help - Again (2000)
LIst Box Form Update (2002)
Access Macro (2000)
Replication (2000)
Count Query Help (Access 2000)
sql in record source (Access 2000)
Design to prevent duplicates? (AXP 10.2627.2625)
eliminating 'File Window Help' Menubar (2000)
between [] and [] (Access 2000)
City and Zip (Access 2000)
References in ACCESS97 vs ACCESS 2000 (2000 - vs - 97 )
Holiday Table (Access 2000)
mailmerge probs (97)
Open form to the record that was viewed last (2002/SR-1)
Text and Graphic on a Control Button (97 SR2)
How to get rid of warning message on record delete (Access 2000)
Application Exit COntrol (2000 SR1a)
Auto enter date in a field (Access 97 Sr2)
multiple user security (Access 2000)
Multiple relationships/Table entries (Access 2000)
Problems using results from lookup fields (Access2000 V 9.0.2719)
Keep group of controls together on report (2000sr1a)
numbers rounding problem
search shows original form (97/sr1)
Search option with wizard (2002)
Run Procedures from a table of procedures? (Office 2000 Sr1a)
Browsing records in ADO (Access 2K) (Access 2K (SR 1))
Specific Months in a Report (Access 97/SR2)
Access XP will NOT convert back to 97 (XP)
DateDiff (Access 2002)
List box (97)
Can't use db because of error message (Access 2000)
Access Can
Links within a database (97)
Formatted memo field (Access 97/SR2)
Who's online? (2000)
Cascading deletes (A97 SR2)
Set table field format programmatically (Access 97)
Using Variables in Module? (A2k (9.0.3821) SR-1)
Using a Union Query to combine Tables (OFFICE 97)
Decimal places to no disappear (2000)
date stamping changes to records ('97)
Access & Outlook 2000 (2000/sr 2)
search (2k)
Access 97 Scroll Mouse Disabling Problem Solved!!! (Access 97)
Advanced listbox (2000)
Startup Settings (A97)
Design Grid (A2000)
Opening secured Access 2K app in Access XP (Access 2000 & XP)
Number formatting (97 SR1)
Picture Size (Access 97 SR1 W98)
Shift Bypass Key (Access 2000)
Access 97 with Office 2k (97 vs 2000)
Select case (97)
Subform Visibility (AXP/Win2k)
Tab order not correct (Access 2002, SR 1)
Scroll Mouse Problem Fixed?? (access 97)
Checking Table Existence (2000)
Select case statement (97)
copying code issues (access 97)
Sending E-mail Through Outlook (AXP/Win2K)
Validating Input (Access 97 /SR2)
groupwise email (97sr2)
Can i stop further codes? (Access 2000)
combo box list change (Access 97)
Export Access Data to Quicken (Access 2000, Quicken 2000)
Delete record automatically if a field is blank (2002/SR-1)
Subform (Access 97)
strange combo box (Access 2000)
Converted 97 Access db to XP (Access XP)
find unmatched query (Access 2000)
Using Variables in Strings (A2k (9.0.3821) SR-1)
Combo box problem (Access 97/SR2)
Use of Form name in a string (Access 2000)
Setting Focus on SubForm (Access 97)
Data format (2002)
duplicate records (2000)
Importing Delimited Text Files (2000)
How To Include ID Pictures In A Report (Access 2.0)
How to Reference Parent Form in Query? (A2k (9.0.3821) SR-1)
Update Default Value of Combo Box (A2K SR1)
bound vs. unbound forms (Access2000)
Photo Directory (Access 97 SR2)
vba code control defaults (access 97)
What is Back-End Data File (Access2002)
global form events (access 97)
Form / Field Backcolor (AXP/Win2K)
Time conversion seconds to MM/SS (Access97)
Where-Used Documentor (97/2k)
Hide a text box in a report (access 97)
Import Tables (97)
iif (access 97)
Need ideas for creating a running sum table (Access97/2000)
Adding invoicing features? (Office 2000)
Date Query? (XP)
opening word using code (Acc 97 sr2 on 95b)
Destination DB Property (2000 (9.0.3821 SR1))
Lookup function (Access 2000)
Email address in Access 97 (97)
Forbid opening a second combo box if first isnt op (Access 2000)
DIR - List files and directories (2000)
Switch Board (2000)
Subform (2000)
Access hangs (XP)
Default value (97)
Getting Type Mismatch RT 13? (A2k (9.0.3821) SR-1)
Conditional Characters (97)
Formating Reports (Access 2000)
Bound Subform (Access 97)
Form with new record only (XP)
Appending to Linked Table (Access 97)
Creating edit payments pop-up form (2002/SR-1)
open report with combo box (Access 2000)
Search Queries (97sr2)
Excel Process Not terminated from ACCESS OLE Aut (2000)
import a data file from a backed up Access databas (Office 2000 9.0.3821 S
Elapsed time calc using dates (A2K / Win 2K)
Hid a table (2k or 97 )
Count (97)
Variable getting Cleared? (A2k (9.0.3821) SR-1)
format query for weeks (Access 2000)
Add-ins missing! (AXP 10.2627.2625)
Date/Time string (A2K / Win2K)
Missing Project Name (Access2000)
Cancel event with reports (Access 2000)
fire event when subform's filter is removed (97)
Date Search (Access 97)
Access:send as RTF (Access 97, win 95)
Referencing subforms (97)
Saving variables (Access 97/SR2)
IMPORTING EXCEL SPREADSHEETS (OFFICE 2000)
Enter hours in 1/4 hour increments only (A2000,SR-1)
Reusable Forms? (A2k (9.0.3821) SR-1)
#Error in table after corruption (A97Sr-1)
Linking Oracle tables (Any)
Ho can i do the sub form in th (center)
Using the Microsoft TabStrip Control (2000/SR-1)
Import a form via code (Acc 97 sr2 on 95b)
ODBC Error (Access 2000)
Form Problem (2002(XP))
Multiple Instances of Form w/Timer Event (Access 2002)
How to Detect Alt & Arrow Donw Key? (A2k (9.0.3821) SR-1)
Label Printing (A2k SP1)
Input Box (WIN2000-AC97)
Program skips form (Access97 SR1)
PAGE BREAKS IN A REPORT (2000)
Buttons to bump a number up and/or down (2000)
text query (2000)
Validation (97)
Report Sorting (XP)
Software Tracking Database (2000)
Limits of A2k? (Limits of A2k?)
Hidden?? Linked Table (Access 2000)
Invalid field definition (Access97 SR2)
Access Sportsclub Database (A2K2)
recordcount (access 2000)
Union Query Issues (Access 2000 and 97)
using DAO to link: SourceTableName?
Value of control on a tabcontrol subform (2000/SR-1)
Writing to an Excel Worksheet (Acc 97 sr2 on 95b)
Conditional Check Boxes (97/SR2)
Moving Controls (97/SR2)
margins on report (Access2000)
Access (97)
autonumber for conversion (2000 SR-1)
DB Structure options (A2K SR1)
Processing imported text? (Access 97)
Forms being corrupted (Access 2K, SR-1)
Autoform Tabular (access 97)
join in a query (Access 2000)
Form slow on open (2000/SP-1)
Excel Exporting (Access 97\SR2)
lookup not pulling info (Access 97)
Multi user trouble (97sr2)
Delete record with corrupt memo field (A2K SR1)
Parameters in an SQL query (Access 2000)
select item from combo box by code (Access 97)
Corrupted mdb file (Access 2k2)
Command File-Close (Access 2000)
Display or Not Display (Access 2000 SR-1a)
One Main Form to Load Different Sub Forms? (A2k (9.0.3821) SR-1)
Bitten by Quotation Marks in Strings Bug? (A2k (9.0.3821) SR-1)
How to Copy a Custom Menu Bar? (A2k (9.0.3821) SR-1)
How to use Variables? (A2k (9.0.3821) SR-1)
Append headaches (Access 2000)
Architecture Question (Access 97)
Reference Variable in Sub Form? (A2k (9.0.3821) SR-1)
Combo Box Help (2000)
Current User (97 sr2)
Form Sort (Access 2000)
PAYMENT FORM PROBLEM (Access 2000)
Get...If..ElseIf...Next (Access '97 & W95b (!))
Using FIND in a Form (Access 2000 sr-1)
run-time error '429' (Access 2000)
can i trigger a function in another database? (Access 2000)
chage rowsource of embedded chart (97)
F1 not working (Access 2002, SR 1)
If...then statements to change field content (Access2k)
Sequence numbers (97 SR2 or 2K)
ACCESS 2k (Access 2k)
Memo Field Truncation (A2K SR1)
MAKING SUB COMBO BOXES (Access 2000)
Mail Merge (A97 SR2)
Access Automation (Acc2000)
Generating a web page programmatically (Office 2000 Sr1a)
Report Header Problem (2000)
Trouble with InputBox (Acc 97 sr2 on 95b)
Auto Append Monthly Tables to a Master (Office97 sr2)
Split record into several programatically (A97)
Linking Table Name in From Clause (A2K SR1)
DATE CONVERSION (A2K SR1)
date functions (2000/2002)
Database Name in Title Bar (All)
Viewing Outlook 2000 Calendar in Access Form (2000)
CrossTab Column Order (Access 97)
Automation with excel (2002)
the sign is at the end of the number (access 2000)
Numbering Records returned from a query
Help with Pivot Table Automation (Acc 97 sr2 on 95b)
I know its not access!! bad bad (2k) (122216) was moved to the Other OSes - Palm / Linux board
Query criteria to show records entered in last 2 h (Access 2k)
Printing to a file (Access 2002)
Determine whether Converted or Enabled (A2K)
How do I hide the SSN from unauthorized viewers? (Access 97 SR2)
TransferDB (97)
subform (2k)
Lock Project for Viewing via Code? (A2k (9.0.3821) SR-1)
How can I turn an Excel file into an Access file? (Office 2000)
Pivot Table Link to Excel (97/SR2)
Calling Office Get File Name from VBA (Access 2000)
'Build...' option disabled (MS Access 2000)
Append Query (2000)
Can't lock file (OS 2000, Outlook 98, Acess 97)
OLE Server Message (A2K)
New Database (97)
Find Missing Days (2000 SR1)
Build DOS copy to allow spaces in destination file (A2K)
how to find a record that is a number (Access 2000)
delete all records in a table (Access 2000)
Combo box (97)