Windows Secrets
Windows Secrets Lounge
Simple Code needed (Access 2000 Pro)
Accessing email from Access (Access 2000 Pro)
Make Table Query (A2k)
Error message (2000)
VBA Code Help (2000)
Adding Field populated with part of other Field (2002)
hyperlinks (Access 2000)
Question on complex query (2000)
Fetching previous record values in a report (2003)
Reading values from table into VBA (2000)
STI Database definition (access 97 sr2)
Number Format in Combo Box Dropdown (Access 2000/2003)
Replicated database Security
Add new record (97-->)
Table Feature Problem (2000)
Field missing in combo box wizard
Tag property of control on a form (AccessXP)
Change property in a table (Access 2000)
suppress message in Preview mode (2000 all updates)
suppress message box (2002)
Classification by speed (AXP)
Auto Numbering New Records with Existing Records (2002)
Update a set of products (Access 2000)
Using Access Form to Open Word Doc and merge.... (Access 2003)
Merged Document and Sorting (Access 2000 v9.0.6926)
Report Help (2000)
Getting variables inserted into SQL statement (Access 2000)
Combining Text fields (2000)
Duplicate Record Wizard with subforms (2002)
Conditionally hiding controls in subforms (2003)
Access and E-mails (Access 2000)
Find Record based on Query Value (2002)
Number field zero (2003)
run time error 2046 (97 sr 2)
Insert Into problems (2002 SP3)
Data Access Page (.htm file) always alerts user??! (Access 2003 (Win XP))
Combo Box-Not able to make selections (2000)
Set combo box value as global variable (Access 2002)
Row Headings for Combo Box (2000)
query/hyperlinks (97)
Linking to table on web (2000)
Calculating hours (2002)
2000 (report automation)
OpenArgs problem (2000)
Path to Office applications (A97, A2k)
Access 2003 fails to see msde installed (Access 2003 SP1)
Filter largest no. on groups! (Access 2000 >)
Syntax error (Access 2000)
append query (2002)
Parents & Children (Access 97)
Cannot copy/export query contents (2K)
copy the option to another table (Access 2000)
Printing From Dialog Form Problem? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Report Formatted for Property? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Send Object failing (97 sr2)
Force User to Save a Record (Access 2000 SP3)
Find/Replace Text? (Access 2000)
Most used items (Access 2000)
hyperlink to text field conversion (access 2003)
Form Formatting (Access 2K)
Setting VBA Project Password (Windows Office)
Edit a form (Access 2000)
Hide all tables (Access 2000)
Adding to Value List (2000 all updates)
Open database and find module (Access 2000)
Hide linked tables ? (Access 2000)
Not In in Row source (Access 2000)
Need Proper Code? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Queries using form info to define ranges (Access 2000)
Sub Forms (2000)
VBE in Access 97 (Access 97)
Automatically completion of fields (2000)
MS Access error (Windows XP Home - Office 2003 Student-Teacher)
Automatic completion of fields (2000)
Autonumber Starting At ...... (A2K)
Constant (Access 2000)
Condtional Formatting (Access 2000)
Creating Grid Output (2002)
Export memo field (2003)
Listview icon (2002/SP2)
Need to initialize the another combo box (2000)
delete all modules (Access 2000)
Crystal Reports Formula (9.0)
Putting security on back end database (Access 2000)
Variable not defined Form.Name (Access 2000)
Run query on open (2002)
User Defined Type Not Defined (DAO) (MS Access XP PRO 2002)
combine data from 3 tables (2002)
copy data to table (Access 2002)
Print table fields and info (Access97)
Maximun number of 'or' criteria in query (2003)
Sum 2 IIF Txt Boxes (2003 SP1)
Access Runtime Security (2003)
SetFocus Problems
Relationship Design (2002)
Tabular Report (2003)
SendObject failing (2000 SR1)
dlookup between equal subforms (access2002)
Conditionally Preventing Record Creation in a Form (2003)
CSV creation (2003)
Mandatory Field (A2K)
Error 3075 missing operator (Access 2000)
Problems saving files (Access 2003 11.6355.6360)
Comparison Report (A2K Sp3)
Linked SQL Tables (Access 2000)
count function (2003)
Access Query (2003)
Access via PDA (2000)
Conditional formatting (Access 2003)
code to run at a specific time (Access 2000)
decimals (2000)
Parameter Query within form dropdown (Access 2002/2003)
Set Caption for Field using Code (97)
Close all open reports (Access 2000)
Animation (2003)
change field value with command button (2003)
CommonDialog API (XP)
focus (2000)
Formatting dates (2003)
Room Assignment Database (2003)
Acrobat 7 (access 2k)
Auto Numbering (Access 2000)
Select entire field or Go to start of field? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
ODBC re Simply Accounting (Office 2003 Simply 2005
IsNull (Access 2000)
using only month and year for field (2000)
Microsoft Access has encountered a problem? (Microsoft Access 2002 (10.430
RTE 438 Object doesn
Restrict result in report (Access 2000)
Open database (Access 2000)
Deleting error tables (2002)
Calculate MEAN & MEDIAN (Access 2002 SP3)
Modify Field Attributes within SQL code (A97/A2k)
hyperlinks (2003)
Combining records (Access 2000)
max and min (Access 2000 VBA)
Data Access Pages (2000)
Access Runtime and Hyperlinks (2003)
Does it start with a number? (Access 97-->)
can't find the database file [path to file] (2000)
This recordset is not updateable? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Labels (2000)
Query (Access 2000)
meeting agenda (XP-2)
make new table (Access 2000)
Error in my code to check data on existing table (Access 2002 SP3)
Email or Exporting (2003)
Union and Duplicates (2002)
Exclude first row from list box rowsource (XP)
Add Table description in VB (2000)
error message (2002)
Hidden Objects (Access 2000)
Co-exist A97 and A 2002 (97 & 2002)
External table NOT in Expected Format (Paradox) (2000)
form data not updating (refresh won't) (Access 2k, Win 2K Pro)
Query has grown too complicated (Access 2000)
DSum ? - Simple I bet! (Access 2k, Win 2K Pro)
Not In List problem (A2K SP3)
groupings logic needed (A2k3, SP1)
Find Record in Subform (XP)
Archiving old records (2000)
Opned Form is blank? (2000)
2000 (Opening Form from VB)
error handling (2000)
Check Files (Access 2000)
Importing multiple tables at one time (2002)
Storing formulas in tables (2002)
Criteria in Design View (Access 2003)
Listview sorting dates (2002/SP2)
Double Click to get hyperlink? (2003)
Using Tabs Form - how to On Click (XP)
Putting data from prompt into a report (2003)
Credit Card Payments? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Update various subforms (97-->)
TransferText - 2003 (Windows XP )
Excel can't see query (Access 2000/Excel XP)
Random numbers (Access 2000)
Missing Menu (2003)
Select a query windows (2003)
Opening a Web Site from Access (2003)
Accessing fields from a subform (2003)
month (2003)
Access Notification Strategies (Access 2k, Win 2K Pro)
Queries Across Tables w/ no Relationship (Access 2000)
No Data in Subreports (Office 2000 / 2003)
Progamming (MS Access 2000)
Queries with criteria including null values (Access 2000)
autonumber (access2000)
Placing a variable value in place of object name (Access 2000)
a good place to finInformation on Graph properties (Access 2000)
Concatenating (Access 2003)
Calculate a total (Acess 2003)
adding fields in code (97-XP)
Running Sum on Form... (2003)
'Can't Open More databases' (2002)
Reference Order (Access2000/2003)
Upgrade from 2002 to 2003 (2002 SP-2)
send only certain records to print (2003)
Reports: Comparing Data (Access 2003)
Default Select-Value Query value (Access 2002)
Go to records as user types (Office 2002)
Subreport? (2003)
Force New Page (A2k)
Exporting Tables (Access 2000 - 2003)
No data for report (2000 (SP3))
Update form based on other forms' list (03)
Data for Pie Chart (Access 2003)
Linked Tables - SQL (Access 2K, SQL7)
Sorting in Reports (Access 2003)
Help After Hard Drive Crash (Office 2003)
Adding multiple records all at once (2000)
Mandatory Fields (Access2000)
Open a form from command button and populate it (2000)
CREATING OWN AUTO NUMBER (2000)
Update Date field from a macro (2000)
Sub totals in query (Access 2002 -Sp-2)
Subform with User-Entered Lookup Criteria (Access 2002)
Switchboard (2000)
Querying Multiple Subforms (XP)
Simple Form (2000)
Dynamically Update data for graph (Access 2000)
Date of Last Entry (Access 2000)
Months and Years as Headers in a Crosstab Query
Determine day of week from date (Acces 97 - SR1)
Importing odbc data (Access 2000)
Display a sentence when another value checked! (Access 2000 >)
Delete record (2003)
Query Issue with colours (2000)
counting (2000)
qryPastDue (2000)
date functions available in Access (Access 2003)
Strange Query Behavior (2002/SP3)
Total a subform - with Function (2002)
concatenation (Access 2000)
Working with data stored in DataFlex (any)
Import Visual FoxPro file using macro (Access 2000)
Access Closes Automatically on Save, Intermittentl (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Eliminate Security Message? (a2003 (11.6355.6408 SP1))
Finding Access Path (2000+)
Backup MSDE (2000)
Font change (Access 2002)
Export > csv; Numbers rounded to 2dp (2002 SP3)
ODBC connections (2000/XP)
Current date button (Access 2K)
Can't delete entry (2000/SR1)
Access VBA (2000)
Spin control! (Access 2000 >)
Format txtbx on report (2002 SP-3)
Access Custom Outlook Fields from Access (XP/Office 2003 SP1)
Event Order with Navigation Button Insert New (2002 10.4302.4219 SP-2)
Opening Custom Help File (Access 2003)
Help needed for creating complex form (2003)
If Then Else problem... (Access 2000)
Medians in Crosstabs (Access (any version))
Errors with form to enter report criteria (2003)
variable recordsource for subform? (Access XP and others)
subform load/open event in tab control (WinXP, Ofc2K)
Best way to handle form timer (A2002)
Create a query from listbox selections (Access 2002)
Criteria Choice (2) (2003)
creating function with arguments (A2003)
Color Coding Dates (Access 2003)
Linking to SQL database (all)
Changing Month format (MS Access 2000)
Query; User Criteria (Access 2000)
Determining a match in two tables (Access 2000)
Create Chart in Excel From Access (Access 2000)
run command button from code (xp/2k)
Can't reference data in hidden form (Access XP SP2)
Setting Database Edit/Find Options on Load (2002)
Don't show output to dialog (A2002)
Excel Comments (Access 2002)
Action in progress (A2002)
append query key violations (access 2000)
Access Data Project (A2002)
Parameter Error (2002)
Override Date Format? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Can Grow property on controls in forms (XP / SP3)
Automatically placing a date into a field (2000)
Help with SQL string (A2002)
Auto Symbols/Characters (2000)
MultiSelect ListBox puzzlement (Access 2k, Win 2K Pro)
Control-; does not enter current date (2003)
autonumber (Access 2000)
Listbox Rowsource problem (Access 2000)
Syntax error (Access 2000)
ListBox (Access 2K)
Database Replication (A2K)
Compare 2 tables (Access 2000)
Too few parameters ? (Access 2000)
Word (Access 2000)
Invalid data on form close (2000/sp3)
make table (Access 2000)
Build Criteria Code (2003)
Form loaded? (A2002)
Subform link fields behavior (2003)
Length of Path and File Name? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Lock Datasheet Columns (A2K)
No Warnings but Errors (XP)
Dropdown not showing in datasheet view (2000)
Last Updated for new customer (Access 2000)
User DB (2000xp )
test for 'Nothing' ? (2000/sp3)
Store Word Document Path in Subform? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Iterate through a multiselect ListView (2002/SP2)
vertical line (Access 2000)
End Of Month query as a function (2k/XP)
ActiveX component can
Update Query Running in Background (A2002)
Relationships (All)
Update to Access 2003?? (2003)
Eliminating Error Message (2002)
ListView problem setting forecolor (2002/SP2)
Access keeps erroring out on one table (MS 2002 SR-1)
protect special function (Access 2000)
Set Yes/No field by code (Access 2000)
VBA Help (2000)
Shortcut menus (Access2000)
Directions from Address (2002 (SP3))
Outputto in Access 2003 (2003)
Custom AutoNumber (Access 2003)
Form Rename Problem (2000 SP-3)
Making 3 records out of 1 (Access 2000)
Pushing Data (Access 2000)
Best Way to Open Hyperlink Fields? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
importing from Excel to Access (OfficeXP Pro)
Searching on a postcode field of a form (Access 2003)
Removing a new record (Access 2K)
Periodic macros (XP)
Report Footer (Access 2003 SP1)
Want to setup job database (2000 (9.0.6926 SP-3))
Copy or transfer table (2002)
Need Help with Code (2000)
Group Suming (2003)
ZIP code query not working (Access 2003)
Record navigation during acFormAdd (2000/sp3)
Inserting pics in Word doc (2002 SP3)
Date format in Union Query (2003 all SPs)
field truncating in report (2000)
Printing forms with subforms (Access 2003)
Export Multiple Tables (Access 2002 & 2003)
Clearing combo box text (Access 2003)
Report Formulas with Grouping (2000)
Setting Cursor to Start of Memo Field (2000 and 2003)
Linked Tables, how to see the file name? (Access 2K, Win 2k)
Simple filter question (2000)
Debug error message (access 2000)
Saving Calculate Fields in a Form (Access 2k, Win 2K Pro)
Limit # Database Users (2002)
Access .IDB Files (Access 2002)
email rpt only when populated (2003)
'Save' Recordset As New Table (2003 SP1)
Access - Creating a new record for multiple table (Access 2000)
Delete all records in to table (2000)
force fields (2000)
filter report by groups
opening form (2003)
Conversion to Access 2000 (97 to 2000)
Forcing Values in a Field (2000)
Condition Formatting Incorrect (2002)
ADO 2.5 Help - Font for Examples (2003 SP1)
Access equivalent toGetOpenFileName? (2000/sp3)
Window position (Access2000+)
Use SQL instead of VBA loop (AXP)
Access querying Outlook (2003)
Set report's OnOpen Event via Fom? (2003)
txtbox: how to create new line via VB? (2003)
SQL for query (Access 2000)
Open Drive door (Access 2000/2003)
Just need code checked (97,2000,2002)
Missing date function (Access 2K)
Query Criteria (2003)
Tab Control - simulate via buttons (2003)
Embedded OLE object update sluggish (2000/sp3)
Query: Get Value from table (2003)
'file located outside your intranet' (XP)
Backup/Restore Button on Form (2003)
Error Message:Network Connection Lost (2000)
Replace Function in Query/VBA? (Access 2k, Win 2K Pro)
DCount: Criteria based on a cbo value (xp)
no data returned in query (2003)
Access 2000 Runtime (2003 updates)
Resize embedded OLE object to fit screen? (2000/sp3)
Can't save report (XP/sr2)
Formatting True/False fields (Access 2000)
Problems securing database (2002)
Making a combo box visible based on user input (XP)
Determine Security Group of CurrentUser with ADO (Access 2000)
Force Operator To Enter A Value? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Count records in a Table using VB (Access 2003)
odbc connection fail (Access 2000)
Importing Data (MS Access 2000 )
Change the default format on form fields (Access 2k, Win 2K Pro)
Stay on Current Record (Access 2003 SP1)
Workgroup Admin file not found (2002)
Test Value of Previous Record In Sub Form? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Some form questions (2000)
Creating combo box options based on (Access 2003)
Setting papersize through VBA (Access 2003)
Only allowing file attachments (2002)
Permissions for different objects (2002)
Forum Software (Any)
Print Mix-up (v2000)
Form too complex? (2002 (SP3))
2003/2002 transition (2003)
Wizard fails to build look-up combo box (Access 2k, Win 2K Pro)
Reference Libraries for 2002 (2003)
Help Closing Down System? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Complex Data Entry Problem (XP)
multi-select list box (access 2K w/ windows 2K)
Filter on selection. (2000)
Securing run-time 2002 (2002)
Security and Displays (Access 2K)
setting default value (2000)
passing data from mdb to anoter (2000 sr 1)
Microsoft Office Access can't send this format... (Access 2003 & Outlook 2
Modifying a PivotChart title (2000)
Stop form opening based on query (2000)
Report criteria based on formulas (2002 SP-2)
Auto Control Number (2002/SP2)
A little stuck on a design implementation (Access2
Record Selection (2000)
Help With Sorting and Grouping? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Inventory Database table schema design (2002/SP3)
Grand Total in Report Footer (2002 SP-2)
Requery - update combo boxes (Access 2003)
Protecting and Splitting (2002)
Datasheet view combobox problem (2000)
Hiding Combo's first column => invalid value error (97)
Linking To Tables in MySQL (2000+)
Format List Box (2002 SP-3)
Update query (2000)
Number Format (2002)
Enable/Disable Control on Open Form (2003)
Prevent duplicate record via form entry (Access 2000)
Limit ckbx selection (2002 SP-3)
Help With Error Trap? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Add (All) Item to combobox (2003)
Code Help (2002 SP-3)
Mailing Labels (2K)
MISSING DATA IN COMBOBOX (ACCESS 2000_SR1)
Help With SQL Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)
Open Linked table manager on error? (2003)
Checkbox converted to Text in Query (2003)
free form polygon in Access? (2000/sp3)
Slow preformance over netwrok (A2K SR-1)
Search Form (Access 2000)
Parameter (Access 2000)
Random txtbx (2002 SP-3)
ckbx entry (2002 SP-3)
Combo Box (Access 2000)
Prevent copy/paste from datasheet subform (Office
Nesting Tab Controls (2000/2003)
Proper Function (2000)
referring to a field name (2000)
Email Hyperlink (2002 SP-2)
'Merge It . . .' Normal behavior? (2003)
Importing Fox Pro (2002 (SP3))
Query Help (2000)
Saving Access file (2000)
Calculate Age (2000 all updates)
Date exceptions (2002)
Acting on a Match (A2K)
Over-ride query criteria (2002 SP-2)
Convert date/time from linked Excel workbook (A2K SR-1)
Using ASP and Access together (Access 2003)
Query by Form Parameters (2000)
Add glossary entry > resort (2003)
Report Section Grow/Shrink (2002 SP-2)
Queries management (2003)
Using Null in Listbox choice (A2k3, SP1)
Constants used throughout an application (2000)
Query Form (2000)
Concantenate Fields in Report OpenArgs (2003)
Query problem (2000)
Adp's report does not allow Sum()? (Acc2000)
object display (2003)
Subform Naming Almost (A2K)
How to centre forms on screen (Access 2003)
security /shortcuts (2000)
Form/Report drop down (Access 2003)
Form View Error Handling (2003)
Autonumbers (Access 2000)
Help on merge, cannot see what's wrong (2000)
Using sql code as source parameter in a recorset o (2000)
Creating a report with pictures (2000)
Sorting (XP-2)
Access security, or not....... (2000)
front end on c drive (Access 2000)
Name Fields and MailMerge (2000)
Orientation of A Continuous Form (Access 2002 SP3)
Advice about normalization and data entry (xp)
option groups (Access 2000)
Security Warning in Access 2003 (MS Access 2003)
ADO (2003)
Working Days (Again) (Access 2002)
Cross Linking (2003 All SPs)
System Req. for Access (XP Home/SP2)
Modifying database fields (Access 2003)
listbox (2002 SP-2)