Windows Secrets
Windows Secrets Lounge
Column format and Page Break (Access 2002 )
CrossTab Query - Make table with results (2000)
E-mail Report (2000)
Problem with lookup Box (Accesss 2000)
Resizing report (Access 2002)
Creating a survey DB (2002)
AXP doesn't show 'Edit in new window' option (XP)
text changes in mid stream (2k)
Best event for a msgbox prompt (2000)
Compare Month and Year in QueryDef (Access 2000)
Value list in Access 2000 (Access 2000)
Open Form mid-code then return (Access 2000)
Getting Data From A control Table (Access 2000.)
What Happened To Snapshot Viewer? (Access 2000/97)
Remove a field by code (2000)
Report field null (Access 2000)
Adding a Quick Key to a Macro (Access 2000)
Focus (Access 2000)
What does this error mean? (2000)
Opening Multiple Reports (2002)
library for String functions (xp)
Unlocking Records (Access 2K)
Command line compacting (2000 SR1)
finding earliest record (97)
Open and application using a button on a form (97 sr2)
Change Function of Close (x) (Access 2000)
Search Active Directory?? (AccessXP)
Matching the button colour (A2000)
Transactions and Reports (Access97 on win95b)
Creating csv (2002)
ComboBox (Access 2002)
Replication (A97-SR2)
Automation code - so far and no further (2000 SR1a)
Filter-by-Form in a subform (Access 2000)
Access to Excel is rounding numbers (XP)
VBA for Access (A2002)
Using wildcards in a 'WHERE' condition for ApplyFi (Access 97)
Multiple Checkboxes- click one to select all (Access 2002)
RunApp Macro (A97)
Check boxes (Access 97)
Sorting names (Access 2K SR1a)
Filtering a report (2000)
Formula needed (2000)
Securing Database (A2000)
Whats wrong with my search query? (Access 2000/2002)
Search Query (Access 2000)
Lookup table within Drop Down Menu (Access 2000)
Cross Ref Tool Wanted (Access 2000)
Total From Multiple Subforms (Access 2002)
old replicated access database (2000)
What is this #??? (VBA Access 2002)
Displaying Zeros in Reports (Access 2000)
Date Spans (Access 2K)
MRU List (2002)
subform controls (2002/sp2)
Converting a text field to a numeric field (2000)
Convert fixed number to text (Access XP)
error msg access 2000 vba)
Wierd Error message (2000)
Frequent crashes (Access 2002)
Estimating Database (2000 or 2002)
INsert SQL Statement (AccessXP)
Find Duplicates Wizard (2002)
Getting MP3 and WAV details (Access XP)
Set Focus back on Access Application (A2k)
overly ambitious query (Access 2000 Win 2000 SR-1)
Insert rows (2002)
IIF function variation (2002/SP2)
Count (Access 2000)
Populating one form from another (Access 2000)
Query (2000)
WORD PUBLISH-TEXT CUT OFF (XP)
Totaling Fields in Report slightly different (A2K)
Totaling a field for a report (Office 2000)
Command button won't work (XP)
Creating Indexes in DAO Code (2000)
Delete duplicate records (2000)
Design Advice (Access 97)
report txtbox control source (2002/SP2)
Printing current Record (2002/SP2)
Extract text from a cell (ACCESS 2000) (ACCESS 2000)
Counting Holidays (All 97/2K)
Option Buttons (2000)
DoCmd.TransferText (2000)
Counting (Access 2000)
Error Message (Access 2000)
Pivot Table (Access 2000)
saving fields from a subform (access 2000 vba)
Put a shortcut on a Command Button? (2000)
Splitting a table with VBA (or Plan B) ((2000-2002))
Formula Problem (2000)
.xls, .txt, etc. (97)
DLookup Funny Business (Access 2000)
Update Form (2002)
Change entire column from True to False (2000)
Checking in Excel to update Access (2000)
Null statements (2000)
Pause in Calculations (2000)
Continous Form Issue (Access 2000)
Database on the web - when does it make sense? (Access All Versions)
Lost wizards (2000 Sr3)
reports-make label invisible (2002/SP2)
Compacting a database (97 SR-2)
Get Around Mde (Access 2000)
PrtDevMode Property to change printer for a form (2000)
Required field (Access 2000)
Converting A2k back to A97 (A97 SR-2)
Report textbox background color (2000/SR1)
TextStream (XP/2K)
Having tasks fires at certain times during the day (Access 2000)
Links between primary and foreign keys (2000)
Populating report from Excel (Access 2000/Excel 2000)
Calendar functions - any brilliant ideas? (Access 97/SR ?)
Query question (2000)
Validation in a table (Access 2k)
Auto fill in (2000)
Add Grand total from 3 reports into 1 final (Acces 2000)
Name that file already! (Access 97 SP2)
Adding New Records Dup Primary ID (2000)
Form control property (XP and 2000)
mouse wheel (2002/SP2)
Startup options (XP and 2000)
ctrl - click (access97 / 2000)
Replication using JRO (2000 and XP SP1)
Memo Fields (Access 2K)
Null problem (XP/2K)
Another Automation Question (2000 (SR3))
Listbox Help (Access 2000)
Updating infor from one table on to another (Access 2000)
Current record (2000)
Access crashes (2000/SP-3)
Calling Function in Access Module from Excel (Access 2000/Excel 2000)
Union Select (10.4)
Reversing Crosstab Table (Access 2000)
Customized toolbar (Access2000)
Need Invoice number assigned before printing (2000)
CustomerID not found (2000)
Find Files and paths and add insert into a table (2000)
Removing spaces from text entries (Access 2000)
Setting up percentages in a Query (Access 2k, Win2K)
Upgrading to XP from Developer 2000 (Access 2k)
snapshot viewer (Access)
Replica List (97 & Xp)
Deleting External Files w/ Command Button (Access 2000)
Updating Tables (2000)
What Week is it? (A2000)
Filling in blank fields (Access 2000)
Print Preview Report (Access 2000)
Multi-Select List Box (Access 2002)
Passing a Value from a Form to a Query (2000)
If statement (Access 2000)
Access 97 to 2002 conversion: report problems (2002 SR-2)
gettting a count value (access 2000 vb6)
Network usercodes (Access97)
Query off results of suform getting populated (Access 2000 )
populate a combobox from a query -yet again (2K)
Getting a date diff (Access 2000 )
Access to Outlook Automation (2000 (SP3))
Post Upgrade to SQL Server (Access 2k2)
Programatically Adding record to recordset (AXP (2002) SP-1)
Exporting Multiple Sheets from Excel (Access 2000)
Total up 3 grand totals in a report (Access 2000)
Front End DB Size (Access 2000)
Display datasheet transposed (2ksp3)
AutoKeys nasty (AccXP)
Top 10 Report (Access 2000)
Preventing lines from printing in a report (Access 2000 SP3)
Really Don't Know How! (Access 2000)
Enter repeat data in separate records (dates) (2000)
Date Parameters (XPDev)
Generating forms in Visual Basic (AccessXP SP1)
Report by Date Problem (Access 97)
Form format (A2k)
Usoing RightFax from Access (2000)
Reports with No Data (2000)
Auto reminder (2000 SP1 / 2002)
Firsy day of month AND today (Access 2000)
Compact (Access 2000)
Application Security using Access Project (adp) (Access XP)
Auto Populate? (Access 2000)
Access (2000)
Update Table (A2k)
Audit trails (2000)
Sort Data In Query and OPening a Form (2002 sp2)
Conversion (Access 2002)
emailing thru Outlook Express (Access 2002)
what's wrong with this? (Acees 97)
sorting report/hiding grouping (2000)
Produce Blank lines in Report (Access 2k_SR-1)
Date Comparisons (2002 SP-2)
Have Access print to specific printer (2000)
Reports - Replacing NCR Forms (2000)
date diff (2000)
Wildcards in an expression (2000)
date default value (Access 2000)
Breaking up a flat database (2000)
Km to Miles Visa Versa (A2k)
Hyperlinks (A2000)
Perfect gender (2000)
Calling form code from a module (AccessXP SP2)
Conundrum Involving Exists Predicate in a Query (2000)
finding the right event (A2002)
Non Modal dialog box that halts code (Access97 on win95b)
Code error (XP)
Report Margins are RE-SET (2000)
Append AutoNumber (XPDev)
Browsing w/ Common Dialog Window (Access 2000)
Goto Control (A2k)
Requery in P2P (XPDev)
Hiding forms for good (Access XP)
Problems importing Word content into memo field? (97SR2)
Expression/Function (Access 2000)
Closing a record without saving (2000)
Pulling middle numbers for Auto Animal ID (A2k)
Data Type Problem (Access 2000)
Convert Form to Excel? (Access 2000)
List Box Behaviour (Access 2000)
Prevent unwanted exit (2000)
Alt+F11? (2000)
Form Freeze (2000)
report table structure (2000)
Form Resizing (A97)
Query to compare two fields (2000)
Inserting Excel Data Into Access (Access/Excel 2000)
Not On List (Access 2002)
VB ACCESS using 'select max(id) from table (windows NT)
Referential Integrity Issue (2000)
Report (Access 2002)
Setting a value to NULL (Access2000)
Creating a RTF Object and sending automatically (Access 2000)
ADO code needed (Any)
Passwords (AccessXP)
Printing Automated Word File (Access 2000)
IIF() (2000)
subforms (access xp)
One to Many Rel. + AND statement in query (2000)
P2P app (XPDev)
output to email (Access 2000)
Report design (Access 2k)
Compacting Databases (Access 97)
Combo Empty (A2k)
Query Question (2000)
Can't move focus error (A2000)
Sorting records in Ms Access (2000)
Need a report using counts from 2 or more Queries (2000)
Transfering Records (2000)
Checking Data and Removing SubReports On The Fly (Access 2000)
Days and hours difference b/w two date/time fields (access 2000)
Fixed number of rows in report (2002)
Relating Tables With Non-Identical Data (Access 2000 (SR-1))
multiple choices from a list box to use in a query (Access 2000)
Button Color (2000)
Select a combobox in VBA (Access 2002/SP2)
How To Print a Second Page Conditionally? (a2k (9.0.3821) SR-1 Jet 4.0)
Access 97 (SR-2) and Windows XP-Compile error
copying a value (Access 2000)
List Box doesn't fill (2000)
Syntax of Update Statement (VB6)
Return Months instead of M (a2k (9.0.3821) SR-1 Jet 4.0)
Query Doesn't Return All Results (Access )
Combo box searches (Access 2000)
Inserting System time in a field (Access 97)
working with percent fields (2000)
TOC for report (XP/2K)
Database Design concept help (A2k)
Error Message with Invoice code (2000)
Access - Data Access Pages (2002)
Best Way to update Date Billed (2000)
Changing a field data type (2000)
Use Current Logged ID in Form (Access 2000 SR_1)
Documentor EZ (Access XP)
Print Report Multiple Times (2000 SR-3)
Solutions.mdb (Win2k/Office2k)
#Name? Nulls (A2k)
Importing Data (97)
Access and WANs/VNC (2000/2002)
Save Record & Open Form (2000)
Can't open recordset (Access2K)
Julian Date Question (2000 SR1)
Send Object / Express ClickYes (2000 SR1)
Access 97 & Windows XP (97)
Calendar (A2k)
Access/SQL/IIS (Access XP/SQL2K/IIS)
VBA statement for Filtering a Form (Access 2000)
SCO Unix ODBC (Access 97)
Relationships (97)
delete relationships (Access 2000)
Access 2002 and Access 2000 running on the same PC (Office XP)
Reports (Access 97)
Runtime error 3221 (Access 2000)
Filtering with Math (2000)
Error Message in Subform (97 SR2)
Can't enter data into form (2000)
SQL trigger affecting a form (Access 97 SR2/SQL server 2000)
Defaults-VBA (A2k)
Open another database (2000)
Error due to Corruption (Access97 win95b)
linking photos and gif files (Access 2002)
Mail proccess stuffing up (2000)
Mail merge (2000)
Missing Links in Help Reference (Access2000 / VBA)
Refreshing a form linked to a query (2000)
Setting rates from a table vs code (2000)
Using 'yes/no' with forumulas (2000)
Launching DB from a shortcut (Access 2000 )
Error with 'open.args' code (2000)
looking for editor to modify memo field (2000)
Returning a Count in a Report (2000)
Various formatting for text in a text control (Access 2002)
Close forms (A2k)
Resetting an AutoNumber Field to Zero (Access 2000)
Cannot Export Reports to Word or Excel (2000 SP1a)
Count function in Access (Access 2000/XP)
INSERT INTO SQL syntax (Access 2000 Win 2000 SR-1)
Access 2000 - SR-1 Professional (5.0.2195, SP2)
Records that 2 tables do NOT have in common (Access 97)
P2P (2000)
cboID.Dropdown Won
Wild Card Replacement (2000 SR1)
Access Data Page Events (2000/SP-3)
Access to Excel - Force Version (Access 2000 SR-1; Excel 2000 SR-1)
SubForm Search (v2000)
Progress Bars (Access 2000)
Linked tables in a query (Access 2000 SR-1)
excel Inport/export (97)
Report design (Acc 2000)
Relationship in remote db (Access 2000)
Displaying a Page Header item on last page (Access 2002)
Compatibility with 2000 (Access 97)
Dbengine not recognized (Access 97)
Setting a value to Null in an Update Statement (Access 2000)
Append query to change year in date format (2000)
Relationship not shown on the screen (Access 2000)
Opening help file from a Button (2000)
Deleting all but one record (Access 2000)
Report-Page Header (Access 2000)
Backing up a Database (2000)
E-Mailing OLE Objects (Access 2000)
Rounding up (2000)
No current record on form linked to query (2000)
Week Ending Date (AC97 SR-1)
Compacting mdb- original file disappears (Access 2002)
Access 97 Error On Click (97)
Can't import Paradox files (Access 2000)
Security on other computers (2000)
total (Access 2000)
Averages in a Form (2000)
If blank... (Access 2000)
Filename in footer (Access 2000)
Access data pages (2002)
Append query not working (Access 2000)
Truncate Function (Access 2000)
RecordsetClone Property (XP)
Access 'talking to' Lotus Notes (Access 2k Win 2k Notes version 5)
DoCmd.Save (Access 97)
Auto Email with Notes (Access 2000 SR-1)
Protecting a database (Office 2000 / Windows 98)
Upsize to SQL Server (Access 97/2002)
continuous form (Access 2000)
Page numbers on-the-fly using Parameter (Access 200 SR_1)
Compile multiple records (Access 2000)
phone number input filter (2002 SP2)
How to write unformatted string to a file (Accss 2000/XP)
Treeview - sorting (A2K SR1)
Finding empty fields (Access 200)
Database Conversion (Access 97 > Access 2000)
Report Freezes with certain Filter applied (A97 SR2)
Nested IIF Statement (A97)
There isn't enough free memory . . . (2k)
Checking if a form is active/open (97)
Data from FormA to FormB, or just open FormB (Win 2k Access 2k)
Tools > References (Access 2000)
Unique Field Values (2002 SP-2)
MS Graph (2000)
Using given parameters on form (2000)
check version (Access 2000)
Add New records (version 2002)
Import fixed-width Txt Files to Access (Office 2000)
Default table or form data (2002 SP2)
Displaying Row Descriptions on Wide Forms (Access 2K SR1)
Which post was it (Access 2002)
Wildcard usage (2000)
Master/Child Link (Access 2000)
showing actual data rather then ID key (2000)
Using VBScript in a report (Access 2000/SR-1)
Relationships (XP)
age calculations (access xp)
Too few parameters (Access 2000)
Update with subquery (Access 2000)
Code does not function (Access 2000)
Refresh/Requery list box on subform change (Access XP)
Syntax error (Access 2000)
A simple Calling function (instead of query) (Access 2000)
How to build an array (Access 2000)
Stopping GoTo Next Record (Access 2000)
Results from a Union Query (Access 2000)
First Date (Access XP)
Interface with phone system (Any)
Access and Winmenu program (Access 97)
Scheduler/database (Access97)
Passing a Value to a Function with a Button (Access 2000 Win 2000 SR-1)
Set Warnings ?? (Access 2000)
Enable/Disable Controls based on Security Group (Access XP)
Queries (A2k)
Select a field with a parameter (Access 2k)
Make a report out of a form (Access 2000)
If No Data , Then? (2000)
How to tell if app is running (AXP)
Simplify code? (Access 2000)
Running list (VB 6)
Exporting from Access (2000)
How to print charts on forms (Access 2000)
Error Opening Access Data Base (Access 97)
Prompt before saving (Access2000)
Subreport positionsing (Access 2000)
making a field name a field (A2k2, SP-2, DAO)
Resize report from Legal to Letter size (Access 2000 - SR3)
Check if another application is running (Access97)
Exporting reports to Word (Access 2000)
automatically close a linked form (2000)
Expression Builder and Queries (Access2002)
MS Access as a Relational DB (97/2000)
Activex Controls on tab page (A 2K)
Pass a date range to a Query (97 SR2)
Using the GroupOn Property (2000)
Export Problem (Access XP)
Concatenate fields in a query (Access 2000 Win 2000 SR-1)
Auto Sign-on (Access 97/2000)
Export record from subform (A97)
Continuous Form (Colour) (Axp)
Top 5 by Group in Query (A97)
JPG Error (A2k)
Field in table set to a query value (Access 2000)
Order by Subform Value (Access 2002)
Revisiting that old Xtab query (Access 2000)
Number Alignment problem in Report (AccessXP)
Report Design (A2k)
Word to Access (XP)
Reference Form Name In Global Var In Query? (a2k (9.0.3821) SR-1 Jet 4.0)
Mail Merge with Word based on Current Record (Access 2000)
Distinct & Count statement in Access (Access 2000)
Enforcing time-out in editing form (Access 2000)
? RE: unique identifier (2002)
Reports in correct order (2000)
Date year is 1899? (Access 2000)
Parameter in Recordset (Access 2000)
Using SQL Count (Access 2000)
Type mismatch error (Access 2000)
Connect to network database using IP (Access2000)
No Default Fonts Available (AccessXP Sp2)
Multi User Error Message (97)
Indexes (2000)
resize a graph for screen resolution (XP)
First Weekday of the Week (2000)
Migrating an Access DB to the Web (Access 2000)
Exact Number of Char? (2000)
Security (2000)
Display data from linked spreadsheet in Form (2000 (9.0.3821 SR-1))
XP & exclusive use (Access2000)
Query Question (Access 2000)
Interval Grouping (Access 2000)
VB Forms in Access (VB / Access 97)
help I cannot see the views posted (Access2000)
Scaling/Sizing a report (Access)
Pagination with subreports (Acc 97 SR2)
VBA for Access (A2k)
SQL to delete specific records (2k)
Print Record (Access 2000 SR-1)
count function a report (2000)
Convert from 97 to 2000 (2000)
A2000 minimizes after accessing hyperlink to file (Access 2000)
Bound OLE Objects (2000 +)
Totals in reports (Access 97)
finding if 3 out of 9 records match (A2k2,SP2,DAO)
Quick AutoUpdate Code (ACCESS 2K SR-1)
Importing different excel sheet data into Access (Access 2000)
Searching for Text in a String (Access 2000)
Is there anyway of searching for records on a page (Access2000)
Sendkeys to another Access App (2000)
Auto entry of data (access 2000)
Users logged in (Access 2000/2002)
Decimal Place in text field (Access 2000)
Update Textbox based on Query (Access 2000)
ActiveX problem/new user (Access 2000)
Getting Parameter Value on Insert. Not sure Why (Access 2000)
Reference a Control on a subform? (2k1a)
Making a report a table (2000)
refreshing records (2000)
TransferDatabase function (AccessXP)
Sort a report based on Expression in Group Footer? (A97 SR2)
formula/function (2000)
Database Security (Access 2000)
Change field format in table with existing data (2000)
Mail Merge (XP)
Office XP Pro? (a2k (9.0.3821) SR-1 Jet 4.0)
Comparing String (Access 2000)
Changing Amount in Text to a Value (Access 2000)
Checking which value is selected in a radio group (Access 2000)
Pictures in table (Access 2000 SR-1)
Sales Forecasting (2002 - XP)