Windows Secrets
Windows Secrets Lounge
Query Returning Too Many Records? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
NOW minus 3 months (2003 SP2)
UNC for split db object reference (Access 2K, Win 2KPro, SQL Server 2K)
Query (Access 2000)
Crosstab reports (Access 2003 SP2)
Coloring background of text and comboboxes (Access 2003/2002)
Max string length 256 char via ODBC... any fixes? (Access 2003 in WinXP SP
Create a PDF from a DOC (Access 2K, Word 2K)
How to Convert Text Field To Numerics Only? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Alpha Designator (2002-SP3)
Validate Sequential Numbers (Access XP)
Cannot Create Table (Access 2003)
Filter Not Showing Dups (2003)
Crashes (2003/SP2)
Blocking Rows in Form View (2003)
Report-Specific order (XP)
Delete a record (Access 2000)
Rounding (Access 2003)
Access 2002 vs 2003 (Win XP Access 2003)
Fill in the control in a form (Access 2000)
locking a subform (Access 2000 SP3)
XML Woes (2003)
How to Determine if Current Object is a Form? (a2k (9.0.6926) SP-3 Jet 4.0
Subform Totals (Access 2003 SP2)
access 2003 (2003)
using excel macro to load database (excel 2003)
Compatability issues Access 2002 and 2003 (Win XP Access 2003)
Rearranging a Query Result Set (2003)
Blank Field (2003)
On click error keeps re-occuring (2000)
where condition (Access 2000)
Combo boxes problem (Access 2003 SP2)
Parameter query with > (2003)
Report from multiple queries (2000-SR1)
Missing toolbars in Access Runtime (Access 2003 wi
Run time error 3061 (Win XP Access 2003)
Mail merging checkbox into word (2000)
Leading Zeros (Access 2003)
Testing for all uppercase (Access 2003)
Return 0 when dates do not exist (XP 2002)
MouseHook as Public Function (2K)
Query (2002)
Query Amounts That Have Values In 3rd & 4th Decima (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Access for local and remote users (2002/SP3)
Don't Allow Duplicates (2003)
ODBC connections to SQL Server Express (Access 2K and up - SQL 2005)
how to - query. (2000)
URGENT! message when database starts up (2000)
Resume after error (2000/XP)
Resume after error (2000/XP)
all controls invisible ? (Access 2000)
Select Case (Access 2000)
Invalid use of Null (Access 2000)
REferential Integrity (2003)
Calculated field on a Query (Access 2003)
Putting query prompt on Report (2003)
List box row source (2k3)
Pulling data from a Training Database (2002)
Sorting Unavailable All DB's (2002)
Categories and Sub Categories (2003)
Linking to Linked tables (2003)
if Clause (Access 2000)
Invisible property (Access 2000)
global function (Access 2000)
Type-declaration char (WinXP Access 2003)
Crosstab Report shows last line totals repeated (Access 2003 SP2)
Alphabetizing (2000-SR1)
append date/time to filename (2003)
Kodak Imaging controls missing in Windows XP (2000 SP3)
navigating through controls (Access 2000)
Reproducing the User Updating Data in a Text Box
Yes/No control (Access 2000)
Syncronising records on sub forms (2000/XP)
Can't edit field (2002 SP3)
Update query (Access 2000)
Count the number of occurences (Access 2003)
strange behaviour (Access 2000)
Getting ODBC Table Link Into Memory (2000)
Disabling a Text Box Change Event (2003)
Chart from Union Query (2003 SP1)
Access to PDF bookmarks (2000/XP)
What have I done wrong (Access 2003 winxp sp2)
Bookmark from a list (2002)
Populate a New form (2k)
Too Much Empty Space in Form View (2003)
Continous form (Access 2000)
DLookUp (Access 2000)
Non-Delete Delete (A2003)
Do While Loop (Win XP Access 2003)
Open form on the last entry (Access 2000)
Screen Flicker (A3K)
Concatenation (2003 SP-2)
How to Isolate Incomplete Phone Numbers? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Unable to enter data in a subform (Access 2003)
Creating combo box (Access 2003)
Variable not defined (Access 2000)
Combo boxes (Access 2k)
Modelling (2000)
File System Object - folder in use (2000/XP)
Deleted records reappearing? (2003)
2000 (Greyout out button on form)
Compile error (2003)
Referring to a label caption in a query (Access 97 sr2)
Removal of background colour (2000)
Calculating average across Text Boxes in a Form (2003)
Condition problem (2K)
Missing Wizards (Access 2003 SP2)
Field Order in Mail Merge (Acces2003/Word2003)
Need KeyDown Help? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Table creation date as value for form control (xp/2k)
Access from Excel (Office 2003)
Sorted Crosstab (2003 SP1)
Web DB (2000 SR-1)
Report in Access 2002 (MS Access 2002)
Cross-update Two Mdb's (2003)
Find and Replace (2003)
IIF Statement with multiple criteria (Access 97)
Chart results double (2003 SP1)
Form Field Can Grow (2003)
Upgrade (2k to 2003)
auto update of a field (Access 2000)
Save form data (2003)
Crosstab in reverse (2003)
Errors and DoCmd (2000/2003)
Masking all digits except last 4 in SSN (Acce2000)
Importing a text file (Access 2003)
Limiting subreport (Access03)
Access Runtime Installation (Packaging Wizard SP1)
Problems with redesigning a report (2000(SP3))
records in a row (2003)
system messages (2000)
Report view (Access 2000)
Encrypting a SSN (2000)
SendObject using Email (Access 2002)
Convert null date to today's date (XP)
Subform results (2003)
Object Dependencies (Access 2003)
control criteria (2000)
Need Correct Report Total Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Use MDE to store module (XP)
Frequency of choice (Access 2000)
Parse Access field to do lookup (Access 2003)
Type down feature? (2002 SP3)
Need Correct DCount Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Reference conundrum (A2002, A2003)
Combo Box (Access2002)
Print single record (access 2003)
Currentuser() feature (access 97 sr2)
2000 (forced fields)
Show/Hide Calendar control (2003 SP-2)
Checking for Open Files (Access 2000)
Employee Database (2000)
Message locating the source of the error. (Access 2000)
Counting Unique Dates (Access 2K3)
Updating a Field (Access 2000)
Circluar Reference (Access 2000)
Datasheet headings (Access 97/2002)
Query criteria (2000)
Prevent Change (2003)
Populating Fields (A2K SR3)
Disable Add or Remove Buttons on toolbar (Access 2
Default form view (2K)
Need Correct Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
combo box row source (2002)
Modification date in record (Access 2003)
Delete Query (2003)
Right align a text field on export (Access97,SR2)
importing from access to excel (Access 2000)
Access Reports (97/2000/2002/2003)
Export Table to Excel (Access 2000)
Application Name (MSAccess 03)
Exporting Access Records to Excel (2003)
Run time error 3075 (A2k)
Word Automation (2002)
Multipick (Access 2000)
Access Query (Access2000)
How to know if an application is running? (2003)
open report for selected products (Access 2000)
Isolate non unique records (XP)
reports (2000)
Relationships (2003)
Option Group choice to display text (2003)
RunApp - Directory Loc (2002 - SR1)
Writing Conversion Tool in Access App (Access 2000)
sub reps and cross tabs (2000)
cross tab query (2000)
Make an Access DB an EXE (Access 2002)
Forms issue (Access2000)
Combo box (Access03)
Query Counting (2000)
Sort records in subform alpabetically on exit (Acc
Chart Problem (2002)
The value you entered isn't valid for this field
Parameters (2000 SR1)
Finding missing field (Access03)
Force Record Update (2002)
Combo box - use to populate text box (Win XP Access 2003)
ODE RunCommands not working (Access 2000 ODE)
Organizational Chart (Access 2000)
Date Entry (2002)
DateDiff Function (XP, 2003)
recordsource for form (2000 (SP3))
Structure only arument (Access 2000)
Get rid of duplication of charts (access97 sr2 xppro)
Viewing complete form (2000)
form/Subforms linking (Access 2003 SP2)
CreateDatabase method (A2003)
Checkup (Access 2000)
SubForm Synchronization Variation (A2K)
Counting incidents associated with a pupil (2000)
warning messages when opening (2003)
Clearing all checkboxes in a table (2003)
Keys in tables (Access 2003 SP2)
Query criteria (records since 8am yesterday) (A2k)
Macro Output File Name (2003)
pdf (Access 2000/ windows xp)
Date/Weekday Question (Access 2K3)
Attempting to sort a combobox (2000)
Parameter Question (2003)
DLookup and dates (97)
Delete all record in mdb (2000 sp 1)
Queries/Reports based on user (Access 2000 SR1)
Print Subdatasheet Report/Form (2003 SP2)
Criteria from Calculated Fields (Access 2K3)
Greater than previous Entries (2003/SP1)
Snap Files (A2K SP3)
Forms not showing (XP)
Can't add WorkoutDate input mask? (Access 2003)
DLookp (Access 2000)
Hiding Tables (2002 - SP3)
Update Query for multiple tables? (97+)
Sorting and Grouping (A2K SP3)
Determine the status of Echo (A2K/9.0.4402 SR-1)
Form with cbo box calls report (2003)
dumb question (2003)
Sub Report Control (A2K)
Table dependencies (2002)
User Group (Access2000/Access 2003)
Number of Rows (Access2000/Access 2003)
Unique Records (2000 SR-1)
Auto Populate Field and Reports (2002 SP3)
Report Subtotals (XP)
Outlook Message (2002)
Trouble with code (log changes), form load order (A2k, 2k3)
Look Up Help (A2K Sp3)
View Passed Parameter (2003)
Concantenating fields in a Lookup field (Access 2003)
Email and Formatted Text (2002)
Best practice question (Access03)
Phone Database (Access 2000)
Clipboard/Slow closing (Access 2003/SP 1)
Subreport matching date constrictions of main form (Access03)
Group by query (A2K/9.0.4402 SR-1)
Record number on subform (2K)
Grouping problem (Access03)
Access 2003 convert screen (2003)
Snapshot viewer (2003)
'am' or 'pm' time stamps (VB\VBA)
Move next (Access 2000)
ShellExecute passing parameters (2000/XP)
Text Layout (2002)
Query sort problem (Access 2003)
Option group (2002/2003)
Record Validation vs. Field Validation
Append function (Access 2000)
Hiding the Access Window (2003)
Sort Date Field (2003)
VBA Mail Merge conversion to 2003 (2003)
Hide Label (2003)
Combo box in Form (2003)
Formula for page breaks (Access)
Word format (2000)
Query/Report shortcut anyone?? (Access)
Labor Rate Updates (2003)
Query Design View Size (Access 2003)
setting value of a report label (2002)
Current Field Focus (Access 2003)
Repeating Report Field (A2K)
Column Breaks in Reports (Access 2000)
Tab control pages (Access03)
Help with Duplicate Record? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Query: Single instance of multiple cases (MS Access 2000 SR-1)
Print Multiple Labels in Varying Amounts (2002 XP)
Troubleshoot reports (2003)
Copying values wont work (2002 SP3)
Report using SQL (A2K)
Sendobject - Error 2046 (A97 SR2)
Append error (Access 2000)
Email message from Access (Access 2000)
Connecting to MSDE (2003)
Sendobject (A2k)
Relationship ? (A2k)
Calculations in Headers and Footers (2003)
Grouping and Sorting (A2K SP3)
count of multiple fields (2003)
Paths for Secured Database Shortcuts (Access XP)
Stripping off Trailing Commas (Access 2003)
Force form to load standard size (not maximized) (A2k)
Not Equal To *Wildard* (2000 SP1)
printing only a subform (2002 SP3)
Form automaticlly Filled (Access 97)
Filter by Form Button (A2K)
DSUM (2002)
Date formatting on mail merge? (2000)
Troubleshoot Reports (2003)
Labels (Access 2000)
Change textbox height in report (2002 SP3)
large records pivot table (Access 2003)
Export column to text file (and modify file) (A2k)
Backend on Internet (Access XP - SP3)
Query: first occurrence (Access 2000)
Adapt Form (2000)
Charting in report (97/sr2)
Unattended Queries/Agents (Access 2002/XP)
Filtering by log in password (Access 97)
SQL troubleshooting (Access03)
Access Query Issue (Access 2002)
SQL Count argument problem (Access 2K3)
ODBC Connections (MS Access 97 )
IDE behaviour (Access 2002 SP3)
Database replaces itself (2k / 2003 )
Clearing Memory for Open tables (2002)
Help with Bold Print? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Synchronising Two Forms Using a Class Event (2003)
References (2k / 2003 )
SubQuery Issues (Access 2K3)
Query by Form (A2K)
Searching for a post (log off FE users) (2000)
Query help (Acess 2000)
database engine could not lock (xp)
Counting queries (Access 2000)
DCount (Access 2000)
Getting ADO Ext 2.8 for DDL and Security? (2003 SP2)
Help with DLookup? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Locking the sub form (Access 2000)
Previous Record Content (Access 2000)
Access comparison query (2003)
Applying Input Mask after the fact (Access 2003)
Record Source (2000)
Missing string query (2000)
Calculation of OptionGroup (Access 2000)
Reports Groupings (Access 2002)
Combo Box Wizardry (Access 97)
iif...where (2003)
Find and Replace in VBA (access 2000)
Combining fields (Access03)
Corrupted BE (Access2000)
Help with a formula to update data. (Access XP)
Question about macro running query! (Access XP)
Form Dilemma (A2k SP3)
creating scheduler form (a2k3, win xp sp 2)
Explaination of Number Field Sizes (Access 2003)
Compacting an Access 2002 DB (XP / SP3)
Run-Time error 2455 report.hasdata (A2K/9.0.4402 S
SubTotals In A Continuous Form (Access 2002)
adding Data to Access automatically (Access 2000)
Queries involving date calculation (Access 2003)
export report to .html, which include photographs (2000)
Subform (2000)
No Records (WIN XP/Access 97)
DefaultValue (Access03)
Name sort in a table (Access XP)
Synchronise/Clear Combo Find with records (Access 2000)
Hide Record Menu (Access 97)
new record code doesn't refresh (2003sp1)
Object Required (Access 2003)
Run Time Error 2001 (2000)
Rounding: value not accepted, sum shows wrong (97)
Combo Box (2000)
SendObject (Access03)
OCX & Memory Management (XP, 2003)
Can't Open Database (2000)
Preview then don't allow print (Access 2003 SP2)
exporting subreports (2000 SP3)
Any easy way to compare two databases? (Access 2000)
Sub form issue? (Access 2003)
Conditional Formatting (A2k)
Database created in Win98/Off 2000 crashes in XP
Pivot Chart ... show all possible values (Access 2003)
Making 2 option sets work as one (Access 2003 winxp sp2)
Opening another database (Access2000)
Show all in a combo box (2003)
Search by name (Access 2000)
Sorting based on the last date (Access 2000)
Follow up flag in Outlook (Access 2003/SP3)
Access User Level Security (Access 2003)
Create parameter for shell to command line (Access 2003)
Invalid Bookmark ADO (Office XP)
Form Load Time (again) (2002)
Count Error (2003)
Prevent Excel Import if Column Name Not Found (2002)
Update Query (97)
Easy date entry (A2002)
Make and Append tables (Access03)
Sharing Databases (2003)
Recordset closing on Form_Unload (2003)
Attaching an imbedded Word document to Outlook (Access 2003)
Trim Spaces (A2k)
Where condition (Access 2000)
Calendar (Access03)
Query making me barmy (Office XP)
export table to txt (2000 SP3)
Need a form to come up so I can enter data (Access 2000)
Refer to column number in query (A XP)
Prev/Next Page (2000)
Work out age in YRS and Mnths (Access 2000>)
Pop Up for Datasheet View (Access 2000 >)
Data Access Pages (Access 2003)
Excel.Application Controlling an Addin (Access 2002/SP3)
Graphical display in continuous forms (XP)
Exporting Report as Excel Spreadsheet (2003)
reports with subtotals by week (97)
Analyze (2003)
Non-Null Field Combination (2003)
Stats Report (2003)
Access 97 to Access 2000 upgrade problem (Access 2000)
Help with Parameter Query? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
sentence case (2000/XP)
Select Invoices and Record if Printed (2003 allSPs/SBS 2003)
delete query (Access 2000)
Criteria from multiple records (Access 2000)
Grouping (2003)
Relationships & Joins (2003)
Top_N_Value Query-Report (2000/2002)
FindFirst Me.Bookmark = rst.Bookmark (Win XP Excel 2003)
Need Help With SQL Referencing (2000)
Linking 2 fields and autopopulating (2000)
opening access on a networks (2002/SR3)
How to run a macro when a query is closed (Access 2003)
Compile Error: Object Required (Access 2K3)
Report parameter prompt (2000 (SP3))
Error 2108 Must save field before SetFocus? (a2k (9.0.6926) SP-3 Jet 4.0 S
Keep Details data together (Access 97)
Combo Box search Order (Access 2000)
Form/Macro (2003)
Field Exists (2K)
Query Relationships (A2K)
SendObject Length Limitation (A2003)
2 comb boxes (2000)
E-Mail Form (A2K SP3)
Another anomaly? (Access2003)
Lockout (97 & 2003)
version anomalies (Access2000+)
Memo fields & start up forms (XP (2002))
OnEnter (Access 2000/ Windows XP)
Automating Importing Data from Excel (2002/SP2)
wrapping ASP code into Stored Procs (ASP classic, SQL Server 2000)
Can't open one of the Access Forms (2000)
dropdown (97 sr2)
Front End Doesn't Seem to Talk With the Back End (Access 2000)
Set Security now I cant get in (Access 2002)
command button (Access 2000)
Finding special characters (Access 2000)
Thousand Separator (2000)
Combo box - show contents on focus (2000)
Acting like a template (2002)
Look up using key words (Win XP Access 2003)
Combo Boxes Dependent on last selection (2000)
mailing labels (2000-SR1)
Report sorting (Access 2000)
Form Prompt for Report (2000)
Cross Tab Query (Access 2000)
access replication problems (xp)
print one record to winfax (2000)
Control from one form to update a second form (XP)
Return 'This form' or 'This table' (2003)
Vertical Combo Box (2000)
Add New Record to Subform from Parent Form (2000)
Form is coming up translucent (Access 2003)
Can't get Access database to open (Access 2000)
Query Design view context menus (XP)
Make field required half way through data entry (Access XP)
Carry unbound txtBox value to a report (Access XP)
Text to show No Data on subform (Access 2003)
Query Filter Help (2002)
Subtract fields in queries (access)
Creating Forms (2000)
Drop Down Box in Report (XP)
If Statement (Access 2000)
Row Number (97)
Find Record Issue (WIN XP/Access 97)
Help With Case Statement? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Manipulating data (2000)
Backing up Currently Open MDB (2003)
Sum Calulating function (xp/2k)
Inventory Database (A2k)
Back End Links (97 & 2000 & 2003)
Calculating Dates (2000)
Order Total (Access 2003/SP 1)
Opening a Form with a Macro (Access 2000)
Am I Using MDB or MDE? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Calculating Averages (2000)
Jockeying subreports in report print preview (2003)
Hiding tables and Queries (Access)
Trouble with SQL (Access 2003)
Access and Simply Accounting (any)
SQL Server Express (2003)
Order of the output results in a query (2003)
DIR command (Access 2000)
Display multiple colums from combo box (2003)