Windows Secrets
Windows Secrets Lounge
Access and Apache (Access 2003/SP3)
Multiple Criteria (A2K/XP)
Counting records and top values (2000(SP3))
Keydown (2000)
vacation leave accrual DB (Access2003/sp2)
PDF (97 2)
3rd Qtr (A2K)
Relationship 'OOP' (A2K, SR3)
Date function with concatenation (Access 2000)
Decimal places in concatenation (Access 2000)
Change Column Name (2k)
Using Access to create Blogs (Access 2003)
Tiny Snapshot Reports (2003/SP2)
Msg Box Format (2003)
Transposing Exchange Rates (2003)
Query to return first record for each Person (XP)
Update a field monthly (2003)
Odd mouse behaviour (2000(SP3))
Trouble with report addition (2000(SR3))
Mail merge data source (2003)
Fill in fields on subform (2003)
Access Doesn't Recognize Printer (2003 SP2)
(Preventing) corruption due to no disk space (97+)
DCount (2000)
Copy/Paste not working properly (2003)
Office Automation (2000, 2002, 2003)
Time Format ? (Y2K)
Opening form (2003)
Record Search (2k & XP)
Zeros don't show in date (2003)
Invalid Argument Error (2000)
The * wildcard (2003)
Report Add-In's (2003)
Insert date when printing form (2000 SP-3)
ADODB.Recordset Recordcount (2000)
Keeping Form Maximised in the Background (2003)
Cannot Open Table Using VBA (2003)
Conversion Issues (Access 2000 to 2003)
Access 2003 XP SP2 'sandbox' (Access 2003)
Dates different in SQL and Access (2003/sql2000)
Form/Subform (access 2003 sp2)
Case Select (xp/2003)
Opening picture files (2000)
Access Data Page as Front End for SQL Server (Access 2003)
Set Find parameters for searching (2003)
Import Text Wizard (97 and 2002)
Average Aggregate Operation not working (Access 2000)
Sorting an array (Access 2002 (SP2))
Access Audit Tables (Access 2003)
Automate a macro that has msgboxes (2003)
Converting from 97 to 2003 (version 2003)
Changing the RowSource of a list pressing Returnk? (2k)
subform links (2003)
Blank Records (WIN XP/Access 2003)
Error message when running database (2003)
JunctionTable (2003)
Paste query results into Word (Access 2003)
Using Same Date in Multiple Queries (Access 2000)
Can't link to BE (2003)
Nonbreaking space in report? (2002 SP-3)
Choosing a file (2003)
Procedure Statement in Access SQL (2000)
Semi-date fields (2003/SP2)
Expression in Access (Access 2002)
Multiusers connecting
Subreport (2003)
Output TO: (A2K)
Easy Question - I think (2003)
Image control - lack of JPG file type (2003 SP2)
Managing a Report Text Box Size (Access 2003 SP2)
Update Table (Access 2003/SP 1)
Query (2002 SP3)
Sorting a report (2003)
Sub forms (2000)
General Questions (MS 2003)
password (MS 2003)
Unlock database (MS 2003)
Query for date range (2003)
need to empty a date memory variable (2002)
Query (2003)
FIlter a form (2003)
Command Subscript Out of Range?? (2003)
Access decommissioned (2003)
Recordset variables (2000)
Design help (2003)
Print Report Control Source Code (Access 2003)
Convert Text Desc. to Date (2003 SP1)
TextBox Doesn't Retain its Default Value (2003)
Textbox Name (Access 2003)
survey db (Access 2003 )
Contains (03)
Viewing Data on a Form (2003)
Assign a value to an Object (2000)
Input Mask disappearing chr (2003 (11.6566.8036) SP2)
database backend on Web (Access 2003)
Database acting up (2003)
Tabs (2003)
OLE Server error msg (2002)
rank beginner (2000)
Ooooops !! (A2k)
Business Quarters (2000)
strwhere problem (Access 2003 )
Snapshot (2003)
Pie chart slice colour (XP>)
Cursor position in Input Mask (XP)
formatting mixed-case textbox (2000/SP-3)
Logical Data type and Literals (2002)
Property Types (XP)
Edits during data entry (2000)
Total in report (2003)
Link to Activity in Same Table (A2K, SP3)
Hide Report Page Footer (Access 2003 SP1)
search (2000)
Update Records (Access 2003)
IDENTITY on SQL ODBC Table (Access 2000 and SQL SERVER 2005)
Date mailmerge in Word (Office 2003)
Creating a Form to Update a Table (2003)
Compact and Repair Code? (2002/2003)
DateDiff calc (2003 (SP2))
enter new data by the search result (2000)
IData entry on a datasheet form (Access 2000/ Windows XP)
Report Criteria (2k2)
correct coding (2000)
On Current (Access 2000)
Loop Through Subform (A2k)
Criteria to exclude numbers (2003 Sp2)
Forms and Subforms (2003)
Defining Events to Fire (2003)
Error From Macro Executing VBA Code (Access 2003 SP2 (11.6566.8036))
Zero in calculated field (A2K SP-3)
trim (2000)
Subform headings and showing topo 10 records (2003)
Records Deletion (2003)
e mail automation (2000)
Import Error - Unparsable record (Access 2003)
Choice from Qry (2003)
Emailing Report Page (2002)
performance falls after 2003 (2003 with 2000 an 97)
Liscount limit (2003)
Re-Occurring Visits (ADK)
Security wizzard (Win XP Access 2003)
Error 3022 (2003)
syntax error (97 2)
Form Viewing (2003)
Wacky Autonumber? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Access Watch Newsletter (n/a)
Like memo field (2K3)
2003 (Date formatting)
Data validation (2003 (SP2))
Time refresh (2003 (SP2))
Export based on criteria (Access XP)
Mail Merge (Access 2003 SP2)
Sort by date (dd/mm/yyyy) (AccessXP)
Capture the ID of an Appended Record (Access 2003/SP3)
combine fields (2003)
Query for Tables (Office 2000)
DTPicker Value Defaults to 12:00:00 (2003/SP2)
Print record showing on form (2003)
Want to send email from access 2003 (2003)
Updating Listbox on keypress (A2K)
AGONIZING Slow Queries (2K, SP3)
Tab Control (2000)
Tab Control (2000)
Dlookup filter string (2k)
Printing Reports (Access 2003)
convert number to hours (Access 2003)
Insert in VB doesnt... (A2k)
Using multiple printers (Win XP Access 2003)
DLookup? (A2K)
Find rogue character (SQL)
Syntax Error (2003)
Excel automation from Access (Access and Excel 2003 sp 2)
Close Main Form (A2K)
datasheet combo box refresh (2000/SP-3)
Removal of confirmation message (2003)
Referring to parameter values (2000)
Keeping sections together (2000)
Finding word icons (2000)
relationship error (XP)
test for table exist (XP)
adding fields in code (DAO)
Can I do this in one query (Access any version)
VBA Code Manager (Access 2003)
Form question (2003)
e mail code (2000)
Too many labels (Access 2003/SP 1)
Combo boxes & columns (A 2002 SP 3 (A97))
BoundColumn (A2K)
Duplicate Primary Keys? (2002/SP3)
Delete query not working (2003)
Join key of table ' ' not in recordset (Access 200
Can't update fields (Access 2003)
Calculation using OR (Access 2003)
Emailing Page (2003)
Maximum number of records in a table (2003)
Datepart (Access XP)
Text Box Content on Subform Disappears (2003)
Continued from thread 595987 MID command not worki (2003)
Strange error trying to do mail merge (Access 2003
Field Validation (Access 2003/SP3)
dcount (97 2)
Quering a word from different fields (2003)
When does a form filter become active (2003)
View code from Word (2000)
Exporting Access Tables (XP)
Removing duplicates from tables (2000)
Merging 3 tables to create one (2000)
conditional formating in a report (2003)
Assign Value Error Message (A2K)
Help With IF Statement (A2k (9.0.6926 SP-3))
High-Low-Close Chart (Access 2000)
Speeding up Unbound Form Behaviour (Access 2002/20
Extracting data (97/SR2)
How To Speed Up Dlookup (A2k (9.0.6926 SP-3))
recurring parameter prompt (Access 2000 - all upda
Compact on close (2003 sp2)
User Logon (2000)
List Box Scrolling (2003 SP2)
find record in subform (Access 2000 - all updates)
Importing worksheet from Excel spreadsheet (2003)
import from excel (97 02)
Selecting Date from Calendar Control (Access 2002, SP3)
SQL Make Table (Access 97)
Application window (2003)
List box help, or a better suggestion (2003/SP1)
Open a PDF file to a Bookmark (2003)
Math problem (Access 2002 XP)
VBA/SQL Queries (2002)
time default (2000)
Barcode datatype (XP)
Transfer Spreadsheet - again (XP)
Automation - Opening an existing word doc in VBA (office 2K pro, Win 2K pr
conditional queries (2002)
Concatenating Phone/Fax Numbers (Access 2003/SP 1)
SP2 Failure (Office 2003 Pro)
mdw file (XP)
Printing Multiple Labels per Sheet (A2K)
Text Box Properties (A2K)
update query (XP)
Linked tables will not open (Access 2000)
Data base design (Access 2003 Windows XP)
Totals off of a subform (A2003 SP2)
Converting upper to lower case characters (2003)
Linking Forms to Queries (2003)
VBA Hanging (2000)
beginner Access user (Acces 2003)
ck box to update from a table (2003)
Recommendation (2003)
Mid problem in Access 2003 (Access 2002/2003)
DAO does not get correct value of AllowZeroLength (Access 2003)
Filter (Access all Versions)
Text/Nvarchar(MAX) datatypes (Access XP)
Stuck - Need Help (Access 2002)
aftermath of forcing listbox selection (A2k3 SP2)
Not receiving Daily Digest (2003) (593344) was moved to the Lounge Matters board
Percentages (2003)
Default values in form based on Combo Box (2003)
SendKeys (A2K)
Create name of append field (2000)
Can't get query to filter2006 (2002)
Snapshot Report Problem (2003)
Auto close a database (Access 2003)
Error on opening a report from a form (Access 2k, Win2K Pro)
Updating dates (2000)
Compile Error
Importing from Excel (2003 SR3)
Auto deletion of data in tables (2003)
Synchronizing question (XP)
Tab controls on a Data Access Page (XP)
Edit hyperlinks in text box (XP)
OutputTo (2002)
Code to pull existing info into new record (Access 2003)
Forms don't Open and then db closes (2000)
Creating new field when importing data in table (2000)
Navigational buttons - Again! (A2K)
can't set subReport recordsource from main report (97/2000)
Data Mismatch Error (2002)
No drop areas for pivot table (XP)
Check Between Dates (A2k)
cc email (2003)
Activate Office Clipboard (A2003)
Message When Delete Records (Access 2003)
Filtered Records (A2K)
Date as constant (Access 2000)
Centering switchboard form (Access 2003)
Security models using MS Access 2002 (2002)
Greater Than versus Less Than (Access 2002, SP3)
Getting checks from text (Access03)
Printing upside down (2K, XP)
Creating letters from Query results (Access 2003)
Automatic Comment on Macro (2003 SP1)
form/subform issue (2002)
MS Access to MS Outlook Calendar (2000)
Summary report (Access 2000)
LIst Box - Multi-Selection (2002)
Opening Form
tableDefs (2002)
Folder Independent Tables (2003)
Extracting correct data from text file (2000)
Not equal returned from IIf for query criteria (2002)
Error 3052 (File sharing lock count exceeded) (Access 2003)
Database Design - change (97/SR2)
Separating name (2002)
Keys in tables (XP)
Stumped on a query (2002)
Code Difference Question (A2K SP3)
Table in design mode to Excel (2003)
SendObject (2003)
Field length (Access 2000)
Delete (almost) duplicate records (Access 2003)
Access/Office Automation (Office 2K, Win 2K Pro)
Search and display result in same form (2003)
Memory Loss - Mine! (A2K)
Setting record-locking problem. (Access 2000)
Report Display (2003 SP1)
#Error (Any)
Web pages (2000)
Edit a record in a recordset (2000)
Search Form (2000)
Use of := in VBA (win XP SR2)
Error: can't change the working directory (Acc97)
Field in text file not importing correctly (2003)
Making a comand button sunken (Access 2000/Windows XPpro)
Setting record display order (2000)
Recordset Not Updateable (Access 2K, Win2K Pro)
Due date in access (2003)
Moving a form record selector (2003)
Hide button (2000)
Select entire field on Set Focus (97)
Replace 'codes' with specific text (Office 2003)
Converting Access report to pdf (Access 2002, SP3)
Character Limitations (A2K)
When the query is not filled in (Access 2000)
Aggregate functions in reports (2K SP3)
Problem with lookup in form (Access 2002)
SubForm Requery (A2K)
Forecolor (97 2)
IIF statement (2003)
MDW issue (2002)
database size (2003)
Automating Excel (Access 2003)
Locked Database (Access 2003)
Search text for specific entry (2002)
Cancel a procedure (2003 sp2)
Hide control (2003)
enable menus (2000)
Record is deleted (97 sr2)
Switch Between List Boxes (Access 2000)
Date Problem (Access 2000)
Monitor Outlook Mailbox (A2002)
Paging Helen Feddema and Helen Bradley (Access 2003 / SP2)
Reading binary data from SQL Server (Access 2k, Win 2K Pro, SQL Server 200
sql string problems (2000)
Form filter question (2K)
Jpg Logo showing as Icon?? (Access 2003)
the Dreaded DLookUp (XP)
Counting yes values (Access XP)
Startup Properties and the AutoExec Macro (2003)
Help With A Logical Search Button (Access 2003)
Access and Excell (2003)
Unknown Function (2003)
Open File - Security Warning (access 97 sr2 win xp pro sp2)
Import data (2000)
How To Loop Through BE? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Determine if a field is anAutonumber/Identity (2000+)
Tabbed Form Index (A2K)
Restrict Printing Snapshot Report (2003)
Counting records on subform (access 97 sr2)
Replace Number with Text (Office 2003)
Print If... (2003)
Lag Time (Office 2003)
Keep a form on top (Access 2000/Windows XP pro)
Publish It With Microsoft Word (Access 2000)
Access Help Files (Access 2000/Windows XP Pro)
First record query (Access 2000)
Printing word documents (Access2003)
Print to PDF and Then E-mail (2000)
On Load Event (2003 sp2)
Listing Queries from another database (2003)
Prevent autorunning (2000/2003 SP2)
Delete Dups (2003)
ChangingDateFields to Text (2000)
autonumber (2002)
File name extension (Access 2000)
Repair DB (2002 sp3)
Can not open or link to database on web server (Access 2003)
Add Record (A2K)
Adding a new reference number to a form (Access 2003)
Closing a record on a subform (Access 2003 )
Move to next record with arrow key (2003 sp2)
Comparison Operators with Dates in Queries (2000 (9.0.6926 SP-3))
Updating Current Record (Access 2002)
Same Line Updating (A2K)
Which Label did I click? (Access 2003)
Whick Combo Box Did I Click? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Quarter (Access 2k)
Percentages (2003)
Run query at start, passing user id and password (A2003 SP-2)
Remove a Form Title Bar (2003)
Outlook Automation (Access 2003)
No Data (2003)
Expression Builder . . . IF THEN ELSE? (2003)
Hyperlink to folder (Access 2000)
Relationships (Access 2003)
Page Breaks (Access 2003)
Time Calculation (Access 2003)
Show only the Form when access load (2003)
Union Query (2003)
Front-end/Back-end combination strange behaviour (2003)
OnClose event in reports (Access 2000)
Comparison2 (2003)
File Name Capture (2000 9.0 SP-3)
Caption Bar (2003 sp2)
Top Values per Group (2003)
Navigation Buttons (Access 2000/Windows XP Pro)
How to rearrange controls in a form (Access 2000)
FindRecord Control Button (Office 2000)
Modifying objects in a shared database (Access 2003)
IIf in control source (2003)
Converted Macro Giving Fits (Access 2003/SP 1)
On Format In Report (A2k)
Command Button and macros executing report (2003)
Union Query (2003)
Permanently hiding a label via VBA (2003)
update table (Access 2000)
Listbox datasource based on another (Access 2003/SP2)
MultiUser Envitoment (2003)
Application.Title property (A2002 SP3)
Creating fields in a query (2000)
ControlTip Text (Office 2000)
Error with VBE Password (XP)
Creating a 'spreadsheet' report (A2k)
Strip Characters (A2k)
Key Control (Office 2000)
Access 2003 Delete Query (2003 )
counting records on a report (Access 2003 )
Access DB opening as Read Only (2000 (9.0.6926 SP-3))
Query Doesn't Return Selected Month (2003)
Restricting Field Access (2003)
Pass argument to Matlab via automation (Access 2002 sp 2)
Conditional Action (2003 11.6566.6568)
Securing a database (2003)
On Click Of Field (2000)
Combo Box Row Source (2003 SP2)
Date Question (2003)
Change Date (Access 2003)
Change date automatically (2002, SR 3)
Printer wierdness (XP/2000)
Queries based on OpenArg (2K)
DCount() Function Criteria (2003)
Document Reports (2003 (11.6566.6568( SP2)
Combine two table fileds (2003)
Another Access Reference (Most Versions)
How do I bypass Outlook & use an IP addr for SMTP (2003)
dates in query (2003 SP2)
Access closes (Access 2003 (SP2))
Combining fields on a form (2002)
Reinstalls on open (2003)
Warn User Message (2003)
Windows installer keeps running (2003 sp2)
Update Inventory [In Stock] Amount (Access 2003/SP
QBE view size (Access All Versions)
Wild Cards (2000)
Cross Tab Formatting (97)
Reports Freeze (2003 Pro SP2)
Handling #Name in VB (2000 (9.0.6926 SP3))
Empty Tables (2000)
Passing calendar values (2002)
Combo/list box problems (2003 SP2)
Missing Record Warning Message (2003)
Strip Teaser (V2002)
Cant open mdb (Access 2002)
Adding multiple record using 2 list boxes (xp)
Max of Date query (XP/2000)
Phantom Access Instance (Access2000)
Help with update expression (Access XP)
Remove autoformat b/g on form (Access XP)
concatenating field name (2000)
Recordset Not Updateable (Access 2000)
Close record (2003 SP2)
Merge Data To Word Doc (A2k)
Comparing tables (Access 2000)
How to access the URL address (Access 2003)
Append text string to a text file. (Access 2002, SP 3)
Calculate with a sub-form (2003 SP2)
Restriction Query (Access 2000 SR 1)
Linking subreports (A2002 SP3)
Conflict managing a dupl. primary key in replica (Access XP)
Current Date (2003)
Automatic Date When Checkbox is Checked (Access 2000 SR1)
GetString Method (2003)
Running a function in another database (Access 2003)
combining 2 databases (Access 2003)
navigation problems (Access 2000)
End of Field (A2K)
Hide Controls (2003)
Displaying images from path definition (Access 2002 SP3)
determine filter of a form (access 2000)