Windows Secrets
Windows Secrets Lounge
format changing in reports (2000)
Shift Key (Access 2002)
Report page breaks (Access 2003)
Missing Subform on Report (Access 2000)
Pretty Print from VBA Editor (2003)
Easier to split tables (2002)
Access Pivot Tables (Win XP IE ver 6)
Access Runtime (Access 97, 2000, 2003)
Select Date - Run Report (Access97)
Switchboards and Startup (2002 SR 3)
Report based on sum of fields in subform (Access 2000)
SQL as row source for list box (Access97)
Relational DB from flat tables (Access 2000)
Move table from an mdb in to ... (2000 sr 1)
Automatically sending emails from Access (2000)
Showing Parameter Dates at Top of Report (2000)
Automatic selection of value from dropdown (2000)
Multiple filtered previews of same report? (Access 2002 SP-2)
Total Missing (Access 2000)
Updating an A95 program (Access 2003)
Report to Excel (2k)
Two Combos (Access 2000)
Report Sort (2000)
MDE File (2k)
Changing to Caps (Access 2000)
Sub Report (2000)
Data from Excel to Access (Access97/PeopleSoft)
Indexed field... (2000 sr 1)
Reports not working (Access 2003/SP1)
ApplyFilter method in a Report (2000)
Dynamic Control Sizing! (Access XP >)
Help on form to drive query criteria! (Access XP)
Date function 1 mth, 3 mths & 15 mth recs (Access 2000)
Subform Sort Order (Access 2000)
Sub form layout (Acess 2000)
Subreport Page Header (Access 2002)
TransferSpreadsheet (Access 2003)
Totaling a sub-form (Access 2000)
Report Question (Access 2003)
1st/last day of week for date when week starts MON (2000)
Easy Report Q (2k)
Cannot import Excel file (2003)
Timeout (97 sr2)
Error while opening table in code (2000)
How to bypass Startup options (XP)
Encryption (Access 2000 >)
File sharing lock count exceeded (Access 2002)
ComboBox default value (2002)
Query to look for duplicate entries (2002)
Not In List Revisited (A2K)
Quite a few jumbled thoughts (Access XP)
Coping with errors in linked spreadsheets (2000SP3)
Word OLE object (2003)
Access Linking .xls (2000)
Retrieving a value using DAO (Access 2000 )
Changing the table for fields in a Query (2003)
quick help (access 2000)
Form problem (2000)
Dcount (97 sr2)
The 'With' construct (A2003)
dbOpenTable - Type mismatch error (Access97)
Apply to all in a query (2002)
Using a Recordset to Populate continuous forms (Access 2003)
Printing extra pages (Access 97)
Lost Records? (Acces XP)
Query returns different answers (Access 97)
Formatting a Date field in an Append Query (2000)
Formatting Underlying Data (2002)
Access compiler (2003)
Form will not got into Design View (2k)
Access2002 back to 97 (Access2002/97)
Type Mismatch Error (2002)
Loop - Loopy (2000)
Opening another Database (Access XP)
Print control on report only if not null (2003)
Re: Type Mismatch (Access XP WinXPPro)
Frequent causes of corruptions (2000-2003)
Continuous Forms (2000)
sort Data fields (Access2002)
Ping (2000)
yet more sql (2000)
Test Scores Database (A2K/WXP)
Table fields do not get populated (Access2002)
Unsafe Expressions (2003)
Caption (2003)
Query Modified Date Constantly Changes (Access XP SP2 on Win XP)
Filtering a Subreport and Report from Openreport (Access XP)
Sort Desc (Access2002)
Keep users out of data db (2002)
Viewing jpeg files in a report (2000)
Scrolling in a Form (XP)
Keep VB Window Closed (A2k)
Suggestion needed (Access 2000)
Query Design (Access 2000)
Duplicate records in a query (Access 2003)
Access to store Internet addresses (Access 2000)
Date Calculations (2000 SR3)
Email report data (Access 2000)
Update query (2003)
No 'Index ' tab in 'Help' anymore (Access 2003)
Calendar Controls (2000 and or XP)
0 instead of blank (2000)
Text Date Column Format Change (Access2002)
opening Query through Code (XP/2K)
min application (2000)
shortcut on desktop through code (Acess 2000)
Excel data into Access (WinXP/MSOffice2002)
Insert/Delete New Record, Renumber Old (Access 200/SR1)
more sql syntax (2000)
Navigation via Hyperlinks (I want the hand Cursor) (2003)
Datasheet Headers/Footers (Access 2003)
SQL syntax (2000)
copy database (Access 2000)
Updating some fields, but not others (2000)
Restore Corrupt Database (2002)
Is Null (Access 2000)
Line #'s on Reports (2000)
Updating fields in a subform (Access 2002)
query totals (Access 2003)
Selecting Columns (2000)
Delete query syntax (WIN XP/Access 97)
Processor speed for Access (XP/2K)
Date Calculation (today - 36161) (Access 2003)
Automatically return Day of week (2000)
Missing References (Access 2003)
Select first item in combo box (Access 2003)
Incorrect count returned in report (2002)
Can you convert a snapshot *.snp file? (Access 2002/SP3)
query by form (2000)
Access to Excel (2000)
IIF statement (2000)
Creating Grid on Report (2000)
object not found (2000)
Run time error (2003)
Current resolution (XP)
Price Changes ((Access XP))
Crosstab Query (Access XP)
Crosstab Query (Access XP)
Strategy Question: Access and EMail (Access 2002/SP3)
Updating linked Excel File (Access 2000)
Option Box - Check all that apply (97)
How to compact a database programatically (2002 SP3)
Help with code (A2K)
Subdatasheet name - A97 & AXP
Swap Tables (Access 2003)
Averaging fields within same Record (A2K)
Another Prevent Edit Problem (A2K SP3)
Updating database on-site (2000)
queries and criteria (2000)
Charts and Reports (2000)
Lockup with form (2002 SP3)
Scrolling with command buttons (2003)
Access String Question (2003)
Excel Import (2000)
Datepart (Access XP)
Prevent Editing (A2K SP3)
Open Query via VBA-SQL code (Access 2000)
Import Objects from a Secured Database (Windows XP Professional/Access XP
Reverse field (2000)
Routine progression? (2003)
Search box problem (2003)
Deleting Attached Tables (XP)
? a Better Access approach to an Excel order sheet (Office 2003)
Table names when Attaching to an ODBC Datasource (XP)
Deletion Warning Messages (A2K)
Subform Total (MS Office XP)
Query Error Message (2000)
Question on Design?? (Access2K/Win2K)
Form Footer Total? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Move.Show data in another field (2000)
Deleteing data quickly from one field (2000)
Emailing from Access (2000)
inherited relationships (97)
2002/SR1 (Combining Names)
Instant Refresh of current record (A2K)
Passing criteria from a Form to Query (Access 2003)
Import Wizard Skip Field Problem (2002) (2002 SR 3 (10.6501.6714))
Charts based on changing criteria (Access 2000)
Sort by month in Crosstab (XP/2K)
Option Groups & Queries (2003)
More Problems w/Helen's Examples (Access 2003)
Report Footer invisible (Access 2000)
design view (2000)
Count a query (Access 2000)
Feddema's New Book -- Problems (Access 2003)
Menu Button (Access 2003/Windows XP)
Simulate clicking a button in VBA code (Access 2003 / SP1)
Tabbing to Specific Field on Tabbed Form (A2K)
User Listing (Access 2000)
Date Format (Access 2000)
Access Macros (2000)
Access 2003 - Can't insert clip art onto form? (2003)
Selecting Which Records to Sum etc. (Access 2003)
Track Users (2000-2003)
Substraction in a query (Access 2000)
Report field (XP)
Queries including a linked table (XP)
Check if data item already exists (2003)
Thunderbird E-Mail automation (Access XP)
Insert / expand thumbnails (97/SP2)
Zeros in criteria (Access 2000)
display last record in subform (2003)
Before Update event (Access 2000)
Digital Signatures (office 2003 sp1)
need advice to save database (Access2000)
conditional footer visibility (2002)
Report shows dates only to 3th december (Access 2000)
test a query before running (Access 2K)
Merging Data (Access97)
Default value won't display in full
Populate a form based on ComboBox value (xp)
SQL Server Select using a Date var (SQL Server 2000, ASP classic)
Autonumbers (2003)
Test to see if Specific form is open (XP)
OLD database access by Access (Access 2000)
Multiple users entering data into MDB (Access MDB)
Access (Freeware Access)
Report with extensive footer requirements (2000 latest)
Calling an Active X Combo Box from a query (Access 2000)
Removing Duplicate Values from ComboBox (Access2000)
Blank screen (Access 2000)
Characters don't display in form (2003)
Database Corruption (Access 2000 sp3)
User friendly parameters (Access 2000)
Show new fields from query on form/report (Acc2000)
Update one mdb from another (2000)
Subdatasheets (2003)
permissions dissappear on compact (access 2000, sp3)
Unbound labels repainting (ACC 2k, XP)
Using Access to Create Folders on Drive (2000 SP4)
Text Numbers as Numbers (2 K)
Change MsgBox (2000)
COMMAND function (97-2003)
Syntax error on appending (Access 2000)
Invalid bookmark (2000 SP-3)
Donations (2003)
Matrix Multiplication (2k)
Populate string from option array (Access 97)
Summary report (Access 2000)
Getting values from inbuilt progress bars (Office XP (Access 2002))
Multiselect listbox (Access 03)
preview vs print for reports (XP/SR3)
Limited Text Amount in Label (2000)
xp_sendmail stored proceedure from VB (Access02 VBA)
reports and dcount (2000)
String Handeling Question (Access VBA)
Save in Access (Access XP)
EOF to stop program loop not working (XP)
for each (Access 2000)
Controls v Icons (2000)
Open Web Browser from Button (2000)
Command line switches (Access 2000 SR1)
Rename Excel worksheet (Acess XP, SP3)
change mouse pointer (2003)
Filter on Report & Subreport (Access 2000)
Creating Column during Query (Access 2000)
Query criteria for expiration date (2002 SP-2)
Embedded Query Subroutine (2k)
IIF statement (2000)
Filemaker to Access (Filmaker Pro 6)
Duplicating Current Record with SubForms (A2K)
File Data (v2000)
Delete a row on opening another form (Access 2000)
Using Mod with Datediff (2000)
Web site as source for image control (2000/2003)
Control Can't be clicked (97)
no decimals (2003)
Changing Date Format (Access 2000)
Report by Fiscal Year (Access 2K)
Conversion Error (Access 97)
Menu Bar Problem (Access 97)
Create a range (97 and XP)
Query Criteria (access 2000)
Nothing Shows when File opened (ms Access 2002)
Print to specific printer (Access 2000)
Embedding an image (2003)
Summary report (Access 2000)
Access and Pervasive.SQL (XP/2003)
Printing Image (ACCESS 2003)
page numberin on reports (Access XP)
Field not Updating Immediately (Access 2002)
How To Test for Form Opened as acDialog? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Close a subform (Access 2002)
Compile Error User Defined Type (Access 2003)
Adding New Child to New Parent (A2K)
Error calling Outlook mail under WinXP SP2 (03)
Access 2003 to Access 97 (2003)
Drop Down List (2003)
Update Form based on subform values (2002 SP3)
Trouble with Editing a Recordset (97 SR-2)
DAO Container Object
Colour-coding all controls (XP)
Calendar opening on Today (2002/SP2)
Crosstab Query Percent of total (2000)
credit card inputmask/format (access97)
SET FOCUS (Access 2002)
Date Range (2002/SP2)
Variation on Combo Box Search & Filter (A2K)
Cycling through check boxes on a form--Re: Post (Access 2003)
Weekly formula (Access 97)
Add to data in a particular field (Access 97)
Index problem??? (Access 97)
Totalling Listbox Values (Access2K/Win2K)
Clicking a control vbutton to save and move to the (Accesse 2002 SP3)
Tab control number of rows (2003 with 2000db)
Calendar (XP)
Access and CSVDE (Access 2003)
Capture vbCancel of input box (2000)
Automatically Detect If a Form Is Being Edited (2000)
Hiding controls (2000)
SQL in Access (Access XP)
Input Mask Character (Access XP)
Every second page is blank (Access 2002 SP3?)
Concatenate two text file (A97)
Operation must use an updateable query. (2000)
Compatibility (Access 97)
String length (Access97)
Conversion from Long to Double (Access XP SP2)
Syntax problem (2000 sr3)
Filling Multiple Fields (Access 2002)
Combo box loses input (2000)
Access front-end with SQL Back-end (Access 2000 & SQL Server 2000)
vba coding (2000)
Access with Palm or PDA (2000/XP)
VB Code too fast - how to slow it down? (Access/Outlook 97)
Macro Security (Access 2002)
Prevent user from exiting a form (2000)
Optimizing a Split DB (2k)
Selecting Text (Office 2003)
Compile error (Access97)
BeforeUpdate (Access 2000 SR-1)
Access Object (XP)
Multi pick copy to list box (access 97 sr2 to 2003)
Asking for a date parameter to use (2002)
Counting a Field if it has a Result (2000)
Access 2000 update (Access 2000)
Query Problem (Access 2K)
ActiveX control with no licence (XP)
Controlling Scroll Wheel (Access 97)
data type problem (2002)
Querying for multiple duplications! (Access 2000 >)
Access security (2002 SP-2)
autono (2k)
Crosstab Query Help (2000)
Schedule report (A2000)
Combo Box (Access 97)
New page for Report Footer (Access 2000)
attempt to assign a null value to variable?? (a2k3
Which Event(s) to use (Access 2002)
Transfer Text (97/sr2)
Table Linking, needed? (2k)
Simple Question (2000)
Design grid unavailable (access 2003-XP)
Linking Excel File to Access (XP)
Update Combo Box (2000)
Delete (2003)
no numbers (2k)
link empty text fields (XP/2K)
Transfer database macro or code (Access 2000 )
Minutes to Hours (2000 SP-3)
Mailing labels (Access 2000)
Combo Lookup In Code? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Outlook from Access (2000)
report based on query with multiple conditions (Acces 97 - SR1)
Sorting problem (Access 97)
Having info appear in 2 tables (Access 2000 sp3)
OWC10.dll error (XP and 2003)
Aligning text to centre in a List box? (Access 97)
Open View-only form by Switchboard (2003)
Access and Symbols (2000 (9.0.2720))
Filter excluding? (Office XP)
Automatically delete 'expired' info? (Office XP)
Auto backup? (Office XP)
Slow-opening Reports (2000)
Count in query (Access 97)
Autorefresh query on screen (97)
Howto set application-wide variables? Read inside
Filter a report for null? (Office XP)
No linked tables in the manager??! (2003)
convert nulls (Acc2k3)
legal landscape width (access 2000-2003)
IIf question? (Access 2000)
Autopopulate form? (Office XP)
Query Problem (2000)
Chinease characters? (Windows XP ProfessionalSP2/Access XP)
History Table (2000)
KeyCode=88 is not a Capital X (A2k3sp1)
Commondialog compile error at chr$(0) (Access 2000)
Combo Box error (97)
label in subreport header (A2k3sp1)
upgrade/separate app question (Access 97/2000/03)
How do I (VBA/Access 2002)
NotInList or something else? (A2k3)
report margins (2000)
Modifying charts (2000 SP-3)
Query help (2000)
Form query (2003)
Date Input Mask (2000)
Extracting a date from text (2000)
Callback functions lstboxes (2000)
Run Macro On Open? (Office XP)
Splitting/restricting a form? (Office XP)
Reports - Saturday through Sunday (2002)
DoCmd.TransferText (2002)
Moving Info? (Office XP)
Combo Box Behavior? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Key Ascii (2k)
Runtime version of Access (97)
Report Formatting (Access 2000)
DBEngine.CompactDatabase (Access 2K SP3)
Missing Details View (XP SR 2)
Single labels in Access Report (2000)
Find a value in a table that matches value on form (XP SR 2)
Scheduled update (2002)
Combo box question (2003/All)
Combo Box (Filter With Combo Box)
Close Access from macro (Office 2003/Windows XP)
Input mask in Access table - the ! (Win XP Access 2003)
DMax (A2K)
Syntax Help (2000)
Filter by form question (2002)
Posting Data To Sage Accounts (2000+)
Combo Box Value (Access 97)
Inserting International Characters (Access 2000)
Subform Wizard (2003)
Access Wksheet Function? (v2000)
Access Rule? (Office XP)
Command Button (Access 2002)
move to home automatically (office 2000)
Turn Box On/Off (2000 SP1)
File Closed (Access 2002(10.3409.3501) SP-1)
query unavailable for mailmerge (Office 2003/Windows XP)
Groupwise Email (XP Professional SP2)
Invisible Controls (2004)
After Update Event? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Suggestions on structure of MOAD? (Access 2000)
Adding to a date (2000)
option group (2000)
Update Listbox Contents (2003)
Unable to enter new data (Access 2000)
No Query Results (Access 2000 >)
Opinion requested (Access03)
Entering date from form into query (2002)
ADO Cross-database query (2000)
compo box (2k)
why too many records? (Access 2003)
SQL.log (2000)
Count unique records (Access 2003)
Daily Schedule for Employees (97 or 2000)
Hyperlink default value (2002 SP-2)
Lock in Landscape on report (Access 2000)
Right click menus in Runtime (Access 97 & 2002)
#Error in Query (2002)
combine (2000)
Fields don't shrink (2002)
Date Calculation (XP)
access+word (2 k )
25-Nov-04 12:34 Accessing Outlooks Calendar (XP)
Missing part of name field (A2003)
problem (2k)
Open Report based on Dlookup (2002)
CrossTab Report (Access 2002)
Report using a Crosstab Query (Access 2002)
CrossTab Report (Access XP)
Record locking (front-end/back-end) (A97 SR-2 & SQL 2000)
msgbox (2000)
Invisible field in subform (Win XP Access 2003)
locking and protection (access 2003)
Dcount (2k)
clipbord unavailable with popupform (access 2003)
Changing Excel formulas into access (2000)
DatePart or Format?? (Access2K/Win2K)
Accessing Outlooks Calendar Items from Access (XP)
Restricting Record Selections (Access 2000)
2 Bound subforms fail similar record actions (Offi
export to excel (2000)
Report Problem (A2K SP3)
Preventing duplicates (2000)
Syntax Help (2003)
Best way to adjust for Leep Year (2002)
Limiting an output spreadsheet (2000)
TableDef.Connect retuns no full path (97)
Count (2000)
Access to Excel (2003)
Parameter Error (2002)
Run Time Error (Access 97)
Reorienting a Report Layout (2000)
no zero (2k)
Parameter query defaults (Access 2000)
Calculations in textbox (2002)
Conflicting conditions (Access 2000)
Query SQL dissappearing (2003)
Numbering sheets (2000/9.0.2720)
Access Email Send To (Access 2000)
Form Events (Access 2003 (2000 format))
Combo Box - List Box (2000)
Delete records in a query (2000)