Windows Secrets
Windows Secrets Lounge
Contract Management Ideas (2003)
Union Query with 7 queries (2003)
Long string of numbers (2003)
Non deleting replicas (SP3)
Report group by fortnight (2000)
Where's my table (2002 SP 3)
frmFindVisit (2007)
Unable to open Access database (2002)
Importing an Excel spreadsheet (2002)
ADODB to SQL Server (2000)
Query in Read Only (2007)
Character in Field as Qry Criteria (2003)
Count number of 'Y's (2003)
Calling Outlook - Revisited (A2K, Acc2003)
SQL Table Links (Acc2003 / SQL 2005)
button enabled = false font color (2007)
2 outer joins (2003)
Pivot Tables and Compatibility Mode (2007/SP1)
Export to TXT failure (XP SP3)
Format error on export to Excel (2002)
Union Query - united in wrong order (Access2000-03)
Adding a date/time stamp to a form (2002)
Output to word (Access 2000)
Send Email (2003)
Specific Data fr Access (VBA - Excel 2003)
Delete all databases in a directory (Access 2000)
verify network connection (2003)
Not writing to tables (2003)
Required Fields (2003)
accFormAdd opens blank form (2003)
Check Duplicated Data (2003)
Substitute constant (Access 2000)
How do I get numbers to show with decimal places? (2002)
Import Macro (2003)
Using Acrobat object model (2003 or 2007)
Function to create a zipped file (Access 2000)
Link to an Oracle DB (access 2003)
Find Between Dates (2000)
Cascading Combo Boxes (Office 2003)
Multiple emails (2003)
Test a range (2003)
Mousewheel (2007)
Making indexes (2003)
formatting in table (Office 2007)
Problems with a Query (2000)
sort by calculated field (2003)
Month Only Field (Access 2002 SP1)
Jet Security (2007)
Beyond Iif expressions.. (Access 2003)
Maximize Form (Access 2007)
Form with Subform (Access 2003)
Separating Text (2002)
On no data (2003)
Hide Items in Combo Drop-Down (2003 SP2)
String with No Length (SQL 2K)
Query Group top 5 (2003)
IE BROKEN? (xp-sp2) (688854) was moved to the Internet Explorer board
server down or dtabase not existis (2000)
vb Syntax rst.Field (2003 SP 3)
Combining Selections (A2K)
Too complex query (Access2000-03)
adding items in a table (2003)
Form (Philosophy) (2007)
Update table (Access 2000)
Anchor a new tab control to an existing tab (2000)
REPLACE function on Symbol (Access 03 SP2)
apply format to a control (2003 sp2)
Computing first and end of month (2003)
#Error display in Report (2003 (11.6566.6568) SP2)
Counting Primary Side (2003 SP3)
Military Time to Standard Time (2002)
Select and print reports from form (2003)
Restricting records in a form (2007)
Import table (2003)
Embedding Word Documents (2003/SP2)
Deleting Part of A Field (Access 2003)
Asc Function (2003 SP2)
Access 2003 HTML Help (2003/SP1)
DCount for restricted dates (Access 2000)
Calculated Field (Access 2000)
Different ways of writing code (2003 sp2)
Sorting (2003)
Update problem (Access 2000)
pause printing in order to print on reverse of pag
Startup menu (win XP Of 2003)
copy a file via VB (Access 2003)
Access not loaded (2003)
Edit / Delete Outlook calendar entries (2003)
Format a date (access 2003)
ordering records in a table (2007)
Report form totaling fields within certain dates (2003)
image shifts on report (2003)
renaming a file from Access (access 2003)
set focus to subform control (2000 all updates)
Read only main/sub form (2000)
AND and OR (2K3)
Concatenation Query (A2K)
Export a Table to Excel (2003)
Upgrading problems from 97 to 2003 (2003)
Crosstab query field order (Access 2003 SR2)
Prevent duplicates over 2 criteria (Access 2003)
find record (2003)
Processing Time Stamps (Access 2003)
mutliple page report (2003 )
Record Lock (2007)
Copy user selected files to a specific destination (Access 2003 SP2)
Option Group (2003)
Access Template (2000)
Import from excel (Access 2000)
Change property (Access 2000)
Most recent date from list (2003 SP2)
file name import (2003)
TransferSpreadsheet import Sheet Name (2003 SP3)
Exit sub from Function (2003 SP-3 )
Calling OUtlook (2000 / 2002)
Union Query (A2K SP3)
Help with error message (2003 sp2)
Mess (2003)
Calculated field - pivot table (win XP Of 2007)
count rkds based var (2000)
Printing a mao lmerge (Access 2003 SP2)
? permission problem (Access 97)
2002 to 2007 (2002)
MDB in A2007? (2003/2007)
Insert record (Access 2007)
Interrupt a loop using Toggle Button? (2003)
DoCmd.Close acForm not Working (2003 SP3)
2007 constantly crashing (XP 2003/2007)
Update Obsolete Items (2003 All Updates)
Exiting from Header (A2K)
Most recently updated date (2002)
Off topic: VFP query. (Visual Fox pro)
Play an mp3 reference (2003)
Oriental Text in Query (2003 SR 3)
Jerky Screen! (A2K)
Report and SubReport Query Challenge (2k/2003 SR3)
Time Sheet Dilema (2003 sp2)
commas (Access 2000)
Images on form (2007 and 2003)
97 database error message (97)
If statement (97)
Adding Tab Control (203)
Course Database switch from jpg/gif to PDF (Access 2003/2007)
Update query (Acces 2000)
MDE Resume Next error (2002 (XP))
error in code (Access 2000)
VBA to put a requirement for fields (2003)
Can't find field/form (Access 2003 SP3)
Query based Form does not show all records (2003/S
set all controls invisible (Access 2000)
Error when opening database (2003)
NZ function (Access 2000)
PopUp form (Access 2000)
Select every nth record? (2003)
Disable Mouse Scroll Wheel? (2003 SP2)
Update query (Access 2000)
Windows Server 2003 wont run Access (Access 2003/SP3)
Switched off computer (Access 2000)
devide record based postal code (2000)
Move Window with Keyboard (Access Any Version)
Not in list for combo box (Access@003 SP2)
Permission (Access 2003)
Database Name Translated (A2K)
Skip line in Report (Access 2000-SP3)
deleting data from table, keeping structure (Access 2003)
Can not update Records 3197 error (Access 2003)
Graphing a Control Chart (2003 - SP3)
Open Another Front End (A2K)
Report in 2 columns (Access 2000)
Susbraction in query (Access 2000)
Message prompt when mail merge from Access (Access 2003 sp2) (683354) was moved to the Word board
Turn Off Header when Footer ON (Access2000-03)
How to Close Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Report formatting (2003)
Autonumbers and Compacting (Access2000+)
rename control (Access 2000)
Trim function in Query (2003 SP 3)
delete from combo box (Access 2000)
Importing TXT files to ACCESS (Access 2002)
No Data (Access 2000)
link to the desktops (Access 2000)
Fore colour (Access 2000)
Count query (Access 2000)
Sub-Form Rich Text Control (Access 2007)
Invalid syntax (Access 2000)
Warning messages (2003)
Required field (2003)
Delete Duplicate Entries in Excel (Access/Excel 2000)
page caption on tab control (2003)
Combo Box (2003)
Combo Box Limit (2K3)
Limit access to form (2003)
Query Help (2002)
Reading subform data (Access 2003 winxp sp2)
Warehouse query (Access 2000)
specific report (Access 2003)
Is it bad to use Memo Data Type? (Access 2000 - 2007)
Counting the records (Access 2000)
Is Multi criteria ok to use (Access2000-03)
Help With fld.Properties. Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Help With IF Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Need to use word “*COS*” in like syntax (2003)
Change Linked Tables source (2003 SP3)
LinkMasterFields (A2K)
Set after 3 months (Access 2000)
query per month (Access 2000)
Importing Values from XML Files (2003)
Memory usage (SQL)
Picture not being displayed (Access 2003)
Query use 'like ' syntax showing wrong results (2003)
IIF query (Access 2000)
Updare query (Access 2000)
Count check Box (Access 2000)
Alphabetic Sort Order (Access 2000)
Make Table question (2003)
Export to Excel exceeds 65000 rows (2003)
Field names renamed by Lookup Wizard (Access 2003)
New Year (Access 2003)
A2003 SP-3 Combo Box Issues? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Toolbar function (Access 2000)
DLookup (Access 2000)
deleting duplicates in a table (Access 2003)
Sometimes OnDirty Event won't fire (All)
ole objects assigned to multple records (office 2003)
Replace String in Text (Access 2000/SP2)
Date stamp updated record (2003)
Crosstab query as recordsource for form (Access 20
Open database (Access 2000)
Highlight Current Record (Many Versions)
Conditional formatting (2003)
Starts with A but appears last (Access2000-03)
Query Criteria (2000 SP3)
Output Data to Presentation Method (2000)
1 Form, multi tables (2003)
Combo box (2003)
Change number in table (Access 2000)
Sortin Grouping off (Access2000-03)
Update query (Access 2000)
Creating Appointment item to Different Calendars (2000) (680590) was moved to the Outlook board
Count Records on a Sub Form (2000)
#Error on printed reports (Access 2000 SP3 (Windows 2000 SP4))
Crosstab and Union Query (2003)
Update query (Access 2000)
Another Conditional Format (2k)
Export Query to CSV (Access 2000/SP2)
Validation Rule (A2K)
UNION qry into table (Access2000-03)
Field is blank - how to fill it in? (Access20)
Warehouse query (Access 2000)
clear/delete a table (Access 2003)
Launch e-mail with boilerplate message (2003)
remove table/query aliases (2003)
Survey results help (2000)
too few parameters (Access 2000)
DLookup (Access 2000)
Report Sort (2007)
active screen (Access 2000)
show hidden table (Access 2000)
macro (MS Access 2003)
putting number of records in a textbox (2003)
order desc in selction sql (2000)
Open text file requiring pwd (2003)
Symbol (2003 & 2007)
lookup record and compare (2003 sp2)
Coloured control (Access 2000)
Upsizing Problem (Access 2003 - SQL 2005)
docmd.openquery (97)
Type not defined (2000)
DLookup (Access 2000)
Undoing a Field (2002 (10.6501.6817) sp3)
Quit the process (Access 2000)
Syntax error (Access 2000)
Inserting Pictures (2003)
Value -1 instead of Text (Access2000-03)
Average of Calculated Footer Data(Access2003)
Combo boxes on form (2003)
Filter for [ ] (SQL 2000)
Form Module Corruption (Acces2 2007)
Union Query (Access2000-03)
list boxes (office 2003)
Changing a text field & date field (2003)
Hidden tables (Access 2000)
Emails From Access (Office 2003)
Fired with selection.... (2000)
Can't get focus back (2003)
Compare Tables (2003)
Type conversation error in macro (2003)
Work around connection string needed (A2k3/A2k7)
Create table in code (Access2000-03)
Database patcher (2003/Sp2)
BackEnd Reports (A2K)
No of records to edit (2003)
Database with a current date (Access 2000)
Delete but one (Access 2000)
export tables (Access 2000)
Not a valid passowrd (Access 2000)
Syntax error (Access 2000)
Kill command (Access 20007)
assigning a value (2003)
OLAP or not (SQL 2K /Access 2K3)
Report listing hyperlinks (Access2003)
Error message when opening file (Access 2003)
MDE file (Access 2000)
Count No Data (2003)
Deleting a record (2003)
Synopsis (office 2000)
Another Report Question (2003)
Report Performance (2003)
Input mask question (Access 2003)
Delete query (Access 2000)
Pull value fron another table (Access 2000)
IIF statement syntax (2003)
Crosstab Query (Access 2000)
Report Wizard (A2K)
Which backend are tables linked to? (2000, 2002)
Access viewer? (Access 2000)
Create the table dilemma (Access2000-03)
HIghlighting report sections (Access 2003)
Security (V2000)
Change Field Name in Report (Access 2003)
Protect Form (Access 2003)
Access multi user vs single user (Access20)
Updating a date field (2003)
Define path on NT server (2003 sp2)
Conditional Form Background (VBA Access 2003)
Importing file, but not all of them (2003/SR2)
Some of the records in subform disapper (Access 2003)
Delete query (Access 2000)
Name of database with current date (Access 2000)
Cancel a combo choice (Access 2007)
Top 10's (2003 (11.6566.6568) SP2)
Combo Box Auto Expand (Access 2000)
Permission denied (Access 2000)
exportaltables (Access 2000)
Update error (Access 2000)
Memo problem (2007)
After Update event (Access 2000)
Number to Text (2003)
Import Specifications (2003 sp2)
Modifying the Attachment (2007)
Readmissions within 30 days (2003)
Pivot table (2003)
Updatable field (Access 2000)
export all tables (Access 2000)
Title of the SUB Report is not shown on every page (Access2000-03)
Evenly Divisible By a Number? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
VBA v VB.NET (Access 2003)
Showing jpg images on page using Access 2000 (Access 2000)
forms / reports (office 2003/ XP)
Command button doesn't always work (office 2000)
Form selection (2003)
selection wrong (2000)
Delete query (Access 2000)
email information (2003)
Truncated Text in Subreports (2003 SP2)
Security levels (Access 2007)
Close queries, run Function Macro (Access2000-03)
DCount Criteria from Multiple Tables (2003)
Page Header Unwanted (Access2000-03)
Argument not optional (Access 2000)
Decimals Display in a Report (2003)
DoEvents Sticking in Loop?? (Access 2007)
Indentify Groups of Controls (2003 SP3)
Error with VBA (2003)
form field based on query (2003)
Labels positioning (Access2000-03)
Linked tables (2000)
Combo Boxes (Access 2003)
2 IIFs in one (Access2000-03)
Update query (Access 2000)
Updateable Query (Access 2003 / Excel 2003)
Make Table (Access 2000)
Password (Access 2000)
Excel to Access (2k)
Code Layout (A2K)
Convert from 03 to 2K (03/2K)
Update problem (Access 2000)
find databases (Access 2000)
False coding (Access 2000)
conditional formatting a field (2003)
Columns to Rows (2003)
Remove page header from report footer (Access 2002, SP3)
Help Files For Access 2000? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Highlight current line in 'datasheet' view (A97, A2k, A2k3)
If Not (Access 2000)
global function (Access 2000)
module in the form (Access 2000)
Short code (Access 2000)
Help Wih Parsing a Field in a Query? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
order by in crosstab query (Access 2000)
Combo box on form (2003)
delete criteria (Access 2000)
Open with password (Access 2000)
security Error (2003)
Form in Background (A2K)
Pivot Table from Query (2003)
Fill the data from another table (2003)
Consolidation (2003)
Delete query (Access 2000)
Connecting to Oracle Database (XP SP2)
Two optionboxes (Access 2000)
date format in design table view (97 2)
Problem With Shell Command? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Delete query (Access 2000)
Access error messages (2003)
Inserting a new line, then moving to that line (A97, A2k, A2k3)
QueryDef Destination DB (2003 SP2)
Open pivot table full screen (2003)
Unique Mailing Labels (2002, SP 3)
Cascade combo box (Win XP Access 2003)
Automatic Edit Table B Based On Change In Table A (2000)
drilling down the query (Access 2000)
Change of colour (Access 2000)
Query value to run if blank (2003)
tab control (2003 Office)
<> sign in crosstab (Access2000-03)
Help with Code (2003)
How To Modify Explorer.mdb? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Listbox (Access 2000)
decreased liters in pivot query (Access 2000)
Sending an HTML email in code (XP)
Quarter (Access 2000)
Syntax error (Access 2000)
text Box Center (2003)
table size (Access 2000)
How Do I Populate Combo Box With Folder Names? (a2k (9.0.6926) SP-3 Jet 4.
Change Data Type in Query (Access 2003 / 2007)
suggestion to use correct connection (2000)
Access Forms to SQL BE (Access 2003 - SQL 2005)
Setting default value (Access 2000)
Custom Shortcut menus in access 2007 subforms (2007)
Getting data from an email (XP)
close from from design view (Access 2000)
windows unhide (Access 2000)
Very complicated hierarchical task (Access2000-03)
Keyboard (Access 2000)
Hide Prompt (2003)
hide linked tables (Access 2000)
Closeall after opening (Access 2000)
Accident prevention (2000)
Spanish Access Book? (2k and up)
Find Record in a form (2003)
MDE database (Access 2000)
Max Date is ignored by query (Access2000-03)
Multi List Box (2000)
SubReport Causes Main Report to Print Twice (XP SP2)
Combo Box List Items (2003 (11.6566.6568) sp2)
Tip: Compact and repair problems (Access 2003 SP3)
Simplify code (Access 2000)
Delete table in remote database (Access 2000)
Paste Append (2003)
Order By (2007)
VBA deleted (2003)
Report hiding lines (Access 2003/SP3)
Junction Table for Junction Tables (2007)
Creating a Menu (2003/SP2)
saving records on form (office 03)
AppActivate not working as Desired? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Remote database (Access 2000)
If Not (Access 2000)
Cursor position in a text box (Access 2003)
textbox not filled correct (2000)
Office 2003 and Access 2000 (2003)
len() (2003)
DLookup (A2K)
Parsing / delimited dates (2003 SP2)
Prompt Report (2003)
If witout block (Access2000-03)
Using Access on Internet with Sharepoint Designer (2003)
Incrementing Numbers (2000)
Search Form (2003)
DLookup code producing incorrect results (2000 all
Calculating milage between points (Any)
Red lettering in MsgBox (Access 2003 SP3)
Relinking 2 SQL Server (Access 2000)
Expression in query (A2k3; SP2)
Switch ControlSource (2003)
1 wheel on my mouse (2003)
HTML email using Lotus Notes (2003 SP2)
Deleting queries (2003)
On Got Focus or Enter (2003)
No message box (2003 SP2)
DB Doesn't Show Up On Recently Open Files List (XP SP2)
Update Field on Report Close Event (2K2)
Filling in next number on form (97)
Could not find field ‘Description’ (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Hide the main form (Access 2000)
field on a form based on value of two other cells (2003)
Joining of fields failing on Report level (Access20)
Currency Data Entry (A2K)
Transaction Log File Size (SQL 2000)
Move right (Access 2000)
query trying to find 9 consecutive months of membe (2003)
Sub-set of database (WXpHe Off2003)
e-mail Merge (Access 2007)
visible control (Access 2000)
Search with second control box (Access 2000)
Wrap text in table (2002)
Xtab Report - Changing Control Source in VBA (Access 2007)
filtering a form based on field in the main form (2003)