Windows Secrets
Windows Secrets Lounge
Date input mask (Access 2003 SP2)
clear option group check boxes (2002)
Access Security (2003)
Help With DAO Code to Normalize? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
VBA (2000)
Quotes and Strings (Access 2002)
DLOOKUP fault (2003 sp1 )
Error Code (A2K)
Detecting the last day of the month (2003)
User Profiles & Unsafe Expressions (Access 2003/SP
Table Amount; Sum (03)
Connecting with SQL Express 2005 (2003 sp2)
Security setting (Access2003)
Save as MDE in Access 2003 (2003)
Percent Formatting Report Text Boxes (2003)
Duplicate One Subform field onto new record (2003SP2)
Maximize problem (2000/SP-3)
List Pages in a Form (Access 2003/SP3)
Access File Format (ACCESS 2003)
Sandbox Stuff (A2K)
Queries (2003)
2000 Desktop Shortcut defaulting to 97 (2000)
Count on a Report (03)
Use Accessfield contents to create task in Project (2003)
Quotes in Strings (Access 2003)
Duplicate specific fields (2003)
Printing 2 records per page (A2K SR3)
Move data from one field into another (2003)
Printing report headers (Access 2003/SP2)
Replacing double-quote with empty string (Access 2003)
2 things (2k)
Problem with Edited Record locking (2003)
Relationships change after save? (2002)
list box code failure (2000 all updates)
Cmd Button (2000)
Updating Source of List Box (XP)
Auto fill Orders from a 'Kit' name (Access 2003/SP
Count (2003)
Compact and repair a DB (Win XP Access 2003)
Searching a List Box (2002)
SQL Database List (2k3)
Connect to different SQL instance using VB (Access
SQL Projects V ODBC (Access 2000)
Filter (2000)
Find Record in main form (A2K)
Blank Form (2003)
Inactivate a Database (2003)
Access password (Access 2003)
Access to Excel worksheet (Access 2003)
Error number (2000)
4 digit auto number (2003)
Make a table exclusive (2003)
Trigger Form Controls (2003)
Text Box Requery (2003)
Report: Field spanning more than 1 page (2003)
Access Audit Help (Access 2002)
Help With String Function? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Variable for Table Name in SQL Query (Access 2003 SP1/SP2)
Months query (Access 2000) (619577) was moved to the Excel board
Determining a report open mode (Access 2002 SP2)
proper SQL syntax (Access 2000 all updates)
Months query (Access 2000)
Using combo box to find a record (2000)
Months totals (Access 2000)
Logon (2000)
Transfer data from SQL 2005 to ACCESS 2003 (2003SP2)
Update subform from Unbound form (Access 2003 SP2)
Object Variable or With block variable not set (A2k)
Delete query (Access 2000)
Expression Builder (03)
Printing a CheckBox in Report (2003)
Too Complex To Be Evaluated (2003)
Download solutions.mdb? (a97)
TextBox Visible (03)
Can't Print of View Report Design (Access 2003)
Error in the IIF Clause (Access 2000)
Analysing Crosstab Data (2003)
Help With Import? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Unknown Error (A2K)
query issues (Access03)
Import from Excel into Access (2003/SP2)
Count function (2003)
Dlookup Assistance (Access 2003)
Page Break issue (Access 2003)
Open databases (97 sr2)
Filter Listbox (Access 2000)
How To Access ID?
Writing SQL with Mail merge (All)
Bar Charts: Bar Height (2003 - SP2)
Set focus to subform (2000 all updates)
Employee Awards Tracking (Access 2003)
Access 97 and 2003 (Access 97)
acFormadd (Access 2003)
Formatting Dates (2003)
Cross Tab (2000)
Query Help (2003)
Most Current Versions of Access? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Duplicates in array (Access 2000)
Report issues (2K)
LastUpdated (Access 2000)
Find first (Access 2000)
cannot open mdf file (Access 2003)
Min (2000)
Indexes (Access 2003)
Open Spreadsheet in Access to read data (2003/SP2)
Macro Security (Access 2003)
Error on only 1 PC? (2003 SP2)
SQL Server Linked Server to Access mdb (2000 XP)
Delete Certain Fields in Certain Tables? (a2002(10.4302.4219) SP-2)
error 3001 - open recordset (vba/Access 2003)
validata data in subform (2000 all updates)
Import Text from Excel with line breaks (2003)
Forms (03)
query lock (Access 2003 sp2)
Nz (2000)
Access Help (2000)
DB Size (03)
Reference a query record (2003)
Link to FoxPro With DSN Less Connection (2002/SP3)
showing value from recordset (2000 all updates)
Import from inside a text file (2k3)
Format - date is alphabetical (2003)
Combo Boxes (2003)
Referencing Fields (A2K)
One Report different Query at Run time (2k, XP, 03)
Preview and Print Report (Access 2003 (2000))
Stopping Code Execution Until a Form Closes (2003)
Help With Populate Combo Box? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Calc time across days not recorded (Access 03 SP2)
Combine columns (2000)
convert 4 digit year to 2 (2003)
Comparing Tables (MS Access 2003)
Reset autonumber (Access 2000)
File Locked (2000)
MultiSelect Listbox Twist (A2003 SP2)
Unable to access database (Access03)
Missing Subject Line (IE 7)
Accumulated Factors (A2003)
String Formatting (Access 2003)
Help With Update Query? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Multi-Select Listbox -> Multiple Word Documents (XP, 2003)
Another Report Grouping Question (xp)
year for the query (Access 2000)
Change Font For Word Document? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Subreport (Access 2000)
Page numbers (Access 2002, SP3)
Crosstab All records problem (2003 SP1)
Crosstab - No record - Error (Access 2003)
Send e-mail to all (2003)
Access - Word Automation (Duplicates and Removals) (XP 2003 (11.0))
F11 key don't work (2003 sp-1)
Create a cmd button to open a hyperlink in lstbox (2003)
Importing code module (Access 2003 SP2)
Is Word Available On This Conputer? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Printing One Off Labels (2002 SP3)
Photo montage (access 2003)
DeSelecting (A2K)
combobox items (2003 )
subform (XP)
Toolbar (Access 2000)
Programming xml (2003)
Project Work Records (2003)
Archive data (Access 2000)
Tab Order Problem (2003 (11.6566.8036) SP2)
Excel form into access (2000)
Same person, 2 time periods (2003)
Conditional formatting
Subreport (Access 2000)
Select & Copy text in text box not working (2003)
FE & BE not allowing multiple users (2k)
No obvious join (2003)
Nested Sets (2003)
Lines lost in report when saved as RTF (Access 2003)
Two Basic Questions - multiple choices (2003)
Open a month (Access 2000)
Building a table (Access 2000)
What type of JOIN?? (2003)
Select Name on 1 form, use that name on another (2
Query help (A2k)
Summary view (access 2000)
Report Headache (2K)
Detecting Partial Changes (2003SP2)
Using Criteria to select an Address (2002)
Fixing a code error (Access 03)
IIF clause (Access 2000)
Calling Modules (2003)
Form/Subform References - Again (A2K)
Duplicate data (2003)
Self join with count (XP/2000)
Replication error -again (xp)
Change Report paper size - VBA (Access 2003 SP2)
Command Button (2000)
VB code only works from 1 directory (xp)
Apostrophy (2000)
Unable to add records to SQL Server table (Access2k)
Repositioning a tab control (Access 2003 SP2)
Hyperlink to wrong place (2003)
DLookUp from SubForm (A2K)
right$ (Access 2003 )
Auto Number (2000)
Copy won't work (2003 SP2)
Copy/paste one field into another (2003)
SQL SERVER FETCH (Access + SQL 2005)
Query won't run (2003 SP2)
Display sortable/dbl-clickable data (2000/2003)
automated emailing (2000-SR1)
Weekly Manning Schedule (2003/SP2)
Export to Excel - Header (Access 2002)
Email from Access (2000(SP3))
Parameter Query (2003)
SQL Server Link (2003)
Changing references via VBA in an MDE (Access 2002 SP2)
Titles (Access 2003 SP1 Office XP)
Update without Edit error (Access 2003 SP2)
Splitting & Security (2003)
Record Deleted (2000)
Delete Record from unbound lstbox with a cmd(2003)
move subform records to new main form record (2000
Loging Out (Access 2000/2003)
create macro group (Access2000/2003)
Access/SQL Server Deployment issue (Access 2003)
Default month -1 (text box) (2003 SP2)
Compact error 3799 (2003)
Filter Continuous Form (2000)
ISERROR on #NUM! (2003 sp2)
Filter records by month (2002)
Printing on letterhead (2000 (w/SP3))
Date Time Format (2003)
cdate type mismatch error (Access 2000)
emty fields (access 2003)
refreshing form data (access 2003)
aggregate function to textbox (access 2003)
Using an Unbound Option Group for Report Selection (Access2000)
Conditional Formatting in a Report Based on a Date
restart Autonumberin (XP / 2003)
Reminder (A2K)
Me.field value duplicated (2003)
convert pdf ? (Access 2000)
Export to XML (Access 2003)
find backend (xp)
Pass value from one form to another (2003)
Calendar control (2003)
hiding dialog boxes (2000(SP3))
Criteria for Dates (Office 2000)
Limit managers to only their staff (Access03)
Outlook automation from access (2003)
Updating an unbound object in a subform (2003)
Query Sort Text Field By Lower/Upper Case? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Access data retreival (2003)
Print a Filtered Datasheet (Access 2003)
Email Attachment problem (2000(SP3))
Allow null in unique index (A2003)
Sum (Access 2003)
Transerering Data (Access 2003)
Date conversion (Access 2003)
Filter by date (Access 2000)
Report.subReport Label doesn't shrink (A2k3 SP2)
Date query showing wrong dates in output (2003)
Excluding null values from query result (2003)
Access 2007 (Win XP)
if then (xp)
Refreshing list box in a subform (2003)
Opening a file and saving in Native application (Access 2003)
Help Denormalizing a Table (Access 2003 SP2)
PDF Open and Save to Word (A2003 SP2) (612658) was moved to the VB / VBA board
Syntax error (2002)
Multiple Fonts (2000)
Trapping Keystrokes (A2k)
Suppress Hyperlink Security Message (2003)
password recover (microsoft office 2003)
Renaming Files using FileSystemObject (2003)
Opendatabase (97 2)
Popup Message (Access 2003/SP 2)
send object macro (2000)
Adding extra 'lines' at end of Access report (Access 2003)
Bizaare Reports thing (2003 SP1 )
Before Update problem (2000 all updates)
Restrict spaces in text field (2003)
loging a user (xp)
Dynamic Crosstab Report (2000)
Filter report with OR (2000)
finding a file (xp)
Searching for '?' (2003 SR2)
Refresh data on sub-form(s) (2003 SP2)
Calculating Percentage based on sum functions (2003)
Does XP have a system.mdw file? (Windows XP)
Touchscreen (2003)
Datetime field in SQL Server (XP/03)
LastUpdated (Access 2000)
Email Remittance Advices (2003 allSPs)
Numbered Labels (2003 allSPs)
Relationships (2000)
Report Fields Collapsing Row when No Value (2003)
Combo Box Update (2003 SR2)
Append Query (2003 SP2)
Series Problem (2003)
Finding path of Replication master (2k)
'Can't find form' (2000/03 (SP2))
query with trimmed names (Access 2000)
Using MsgBox Function to Display Progress (Access 2003 SP2)
Decimal Place Removal (Access 2002)
Using a mouse to scroll through Form (2002 SP3)
Ensuring users only have access to a Form (Access 2002 SP3)
'Between' in Query (2003 (SP2))
Query drops null values (2002)
Increasing no. of field names (2003)
Variable Type (Access 2003)
Fixture list (2003)
Help with query based form (2000)
detail section (Access 2000)
Refresh Problem (Access 2003SP2)
Command button (Access 2000)
A2003 SP2 (Report - No Data Question)
updating subform value based on form value (2003)
Web Retrieved Access Database Hyperlinks (2003)
Help Populating Unbound Text Boxe Controls? (a2k (9.0.6926) SP-3 Jet 4.0 S
go to next page (2003)
Simple Query help - grouping & counting (97)
Database Window (2003 (11.6566.8036) SP2) (610777) was moved to the Web Design, Coding and Scripting board
Database Window (2003 (11.6566.8036) SP2)
IF, AND in VB (2003)
Report prints blank (2000(SP3))
Selecting text (weird behavior) (2003)
Search string in SQL contains brackets (Access 2003)
Help with Identifying import errors (2003)
Error message when importing file (2003)
Can Grow Feature (2003)
control as a constant (Access 2000)
Show all fields from Lookup (2002/2003)
copy table (Access 2000)
make the rest invisible (Access 2000)
Query for the first and last record (Access 2000)
Getting Active Subdatasheet (Access 2003)
Expression doesn't work (2003)
Error copying reports (Access 2003)
Working with Data from an External Database (A2K)
Putting fields onto one line in a report (2003)
Extra step
IF/THEN statement for query results? (Access 2003)
Removal of duplicate data in reports (2003)
Which format (2003 SP2)
Undoing record (Access 2003)
Single Address (2000)
DMax (Access 2000)
Import Text (2k3)
Continous Compile (2003)
Import error (2003)
Filtered random selections (2003)
Function depending on query (Acces 2000)
Linked TXT Table (2003/ All Sps)
Select Query using tables from different databases (Access 2003)
Object Invalid or no long set! (Access2000)
Survey Report (A2K)
Sorting (2003)
Single Record Calculation (A2K)
Managing negative values trailing - (Access 2003)
Controlling Windows (Access 2003)
Creating a Chart Using SetData Method (2003)
HELP: records disappearing (2003)
Nested Iif s (2003)
Import from AS400 file (2003 SP2)
Help with Membership Formula (Access 2003 SP2)
SELECT Statement (Access 2003)
Create an XLS from a List (2k)
Synchronizing a SubReport (Access 2002/SP3)
Survey (A2K)
SubForm Field Formatting (A2K)
Access Copy Paste to Excel (XP)
Focus on Form After opening Excel (2003)
Import Data From Word (A2003 SP2)
DMax (A2K)
Update field contents (2002)
Error handle renaming a field (Access 2000 >)
Align the object in DAPage (Access 2000)
SQL Help? (2000)
Print an 'unbound' label (Access 2003/SP 1)
Normalising Data (2003)
Tidying Up Access SQL (2003)
#Error Message (A2K)
Open .xls file from Access (2000 SP-3)
prevent group header and details from splitting (Access03)
Seeking best approach to auto reminder... (Access 2000)
Autonumber field in table (AccessXP)
Database access (Access03)
' in a name (Access03)
VBA modules (2003/SP2)
Make table from last record (Access 2000)
alert user of data (2003)
Link to backend by FTP (MSAccess 2002)
Referencing fields in forms and sub-forms (Access 2003)
addition of where clause (Access 2000)
Delete (2000)
Text box value (2003 SP2)
Not versus <> (Access 2003)
Sub Data Sheets (2003 (11.6566.8036) SP2)
Backend Security (2003 (11.6566.8036) SP2)
Set field property in a new record (Access 2000)
Tables in External Databases (A2k)
Move data from one table to another (different DB) (Access 2003)
Find Box won't go away. (2003 SP2)
My Splitter Isn't Splittin' (Office 2000 and 2003)
Unbound/Bound Form Delima (A2K)
Export to xml document (Access 2003)
Extraction from date (2003 (SP2))
transfer choices from one select box to another. (2003)
Containers (A2K)
Filling a ComboBox from a Recordset (A2K)
Connect to SQL Server (Access 03) (Access 2003)
Crosstab (A2k)
Append table (2003 on XP)
Access - Data Access Pages (Access 2003)
String Compares (2003)
counting records on a report (Access 2003 )
Image Size (2003)
Modifying Data (Access 2000)
No Printer Access (Access 2003)
Updating a field based on the value of another (2003)
Group by Last in Query Grid (2003)
Unknown Date() / Now() Function (Access 2000)
Combo box (Access 2000)
Link all tables (Access 2000)
Export query as .txt error (Access XP)
Focus (2000)
Scroll Bar Visibility (2003 SP2)
No objects in view (2003)
Missing menu (Access 2003)
Updating an unbound list after deleting data (2003)
Uppercase/lowercase formats (Win XP Access 2003)
Can't create a one-to-many relationship (Access 2002 SP3)
Crosstab query - Fiscal Year (2003)
SendObject, TemplateFile (A2K)
Access 2003 file bloats with links to Excel (Access 2003 SP2)
Code efficiency (2000(SP3))
Help Parsing a Field? a2k (9.0.6926) SP-3 Jet 4.0
Access Form to Word or .PDF (Access 2003 Pro)
Cancelling Linked Records (A2K)
field doesn't update from cascading combo box (2003)
Update text field with Autonumber (Access 2003, SP-2)
Last updated field (2002 SP-3)
ftp from Access ('access 2003)
Path to linked tables (Access 2003)
Crosstab Based on List Box Selections (Access 2002)
Delete/remove Access created data source (A2k3 SP2)
repeating data (access 2003)
Database Structure Question (2003)
Type mismatch in Acc 2003 (2003)
texte or number, am i Just dumber (2003)
Can't view reports (2003 SP2)
Email & Letters (A2K/XP)
Using code in a query (Win 2K, Access 2K)
References - Word & Excel (Access XP)
ControlTip Text Help (Access 2003)
does not recognize valid field name (A2003 SP2)
Making an ID from a person first 4 letters (2003)
Refresh calculated field (2K)
Open OLE in Original Application (Access 2003)
Too Few Parameters (A2k/xp)
Subform Entries (2000)
Retrieving Previous Value (2003)
Close database from another database (Access 2000)
Multiple login problem (A2002 SP3)
Replicated Backend Doesn't Allow Update (2003)
Time Series (2003)
Limiting rows returned (Access2002 SP3)
extract number from field (2003)
Report / Data suggestion (2003/SP 2)
Error creating an MDE File (Access 2002 SP2)
Combo Box (2000)
Access project (Office xp Access 2003)
Ampersand & in Action query (Access 2000)
Open report with criteria (Access 2000)
Dynamic SQL (2003 (SP2))
Function (2003)
Disabling Events (Access 2000)
Make Table Query Dups (Access 2003)
Matching part of a field in a query (2003)
subform (2003)
Multiple items in a list or combo box (2003)
Removing a filter (Access 2000)
test for open table (97 2)
Quotation Marks (Access 2000)
Statement doesn't work (Access 2003)
Opening Mdb Using GetObject Function (2003)
Iif Statement Formatting (2003)
Collecting within a Query (2003 SP2)
Access 2000 (Pages to print)
change propert by code (Access 2000)
pages to print (Access 2000)
Filter on Null (2002)
Cascading combos and subform datasheet (2003)
List box on Form (2003)
Confusing error message (2002)
Set caption (Access 2000)
Can't get Chart (2003 SP2)
Update query not working (2003)
lost records (2003)
Relationships and Check Boxes (2002)
String for case select (xp/2003)
changes to areport then crash (2003 sp2)
Access and Apache (Access 2003/SP3)