Windows Secrets
Windows Secrets Lounge
TEXT BOX (ACCESS 97)
PDF Software (97 sr2b) (350046) was moved to the Software Finds and Wants board
Reports Breaks (A2K SP-3)
workgroup security (2000)
strange relationship (2002)
little code help (Access 2000)
alternative to IIF ? (2002/2000)
synch two linked tables different structure (97sp2)
Using AutoLookup (2000)
No err triggered unless breakpoint (Access XP on 2k machine)
Interactive / Sort on List Box (A2K SR1)
Time span query (Access 2000)
Document Database (Access 2002)
Comparing updated data (2000)
Seek Method (DAO) (Access 2002)
Corrupted database (Access 2000)
Disallow Deletes (Access 97)
Creating a Calendar (2000)
Need to eliminate duplicates (Access2000)
Append Query (97sr2b)
Rec Filter (Access 2000)
'Can Grow' property (Access 2000)
Historical Reporting (Access 2000)
Report Summary Formula (XP)
Adding Values to a listbox (Access 2000)
SQL parameters VBA (2000/2002)
Convert Access 2000 VBA to Access 2003 (2000/2003)
Advice required on Database (2000)
Planning help requested (Access XP)
If...then (Access 2000)
Limit enterie without combo or list box (access2000)
Constant in a query ? (Access 2000)
AllowEdits (Access 2000/XP)
Split Database - Disk/Network Error (2000/2003)
Error Accessing File (Access 2000)
Autocompletion suburb/city (XP)
Summing a string (2000)
Export table (Access 2000)
Query in conflict with a table (Access 2000)
Input Masks (2K)
importing table data from one mdb to another (XP, 2000)
Distributing controls evenly on a form (XP, 2000)
Preserve leading spaces (2000sp3)
Snapshots (Access 2000)
Send Data to Word (XP/SP2)
Setting a Variable (Access 2002)
SQL syntax problem (2000 (all updates))
Access97 sendto OE problem (97) (348471) was moved to the Outlook Express board
Missing Menu (WIN2000-AC97)
Cmd button to run delete query (XP)
Report Question (2000)
Call a function from Before Del Confirm event? (2000)
ActiveForm in function called by On Current (Access 2000)
Delete Record (2000)
Images (2003)
Jet 4 SP8 (Access 2003)
Packaging Wizard (Access 2003)
remove navigation arrows (Access 2000)
Concurrent Users (Access 9.0.2720)
Filtering of TabStrip Controls (XP/SP1)
blank records in the form (Access 2000)
Block unsafe expressions (Access 2003)
Insert a Linked graphic file into table 'package' (Access 2003)
Sorting in reports (Access 2000)
Button with 2 functions (Access 97)
Report with 2 subreports (2000/SR1)
Keeping workspace settings (2000)
Learning SQL (2000)
Investment Banking (2000)
IIF in Forms and Report (Access 2000)
Suppressing blank fields (Access 2000)
Open form to new record (Windows 2000)
Go to the blank record (Access 2000)
TPS (TPSsetup32) (347973) was moved to the Software Finds and Wants board
VB code for deleting. (2000)
Add index to SQL 7 (2000)
Strange Error Message (97 - 2002)
Calculated Field (Office 2003)
emailing a table (Access 2000)
Group/detail fields on same line (2000)
Text Export (Office XP)
Excel Pivot Tables from Access source (W2k Office 2k)
Reports (2002 (10.2616.2625))
Find Dialog Box settings (2002)
Treeview/Hierarchy (Access 2002)
query calculation and parameter popups (A2003)
Finding User's My Documents (A2000)
Quotes within strings (A2000)
Outlook contacts (Access 2000)
What recordsets support .Index and .Seek? (2000 SP3)
Maximize? Whats best? (2000)
Compact & repair problem (XP)
Matching SubForm Records via ComboBox (A2K)
Incrementing Job Card Serial Numbers (Access 2002)
Multiple labels from each record (Access 97, Win 2000)
fill from previous record (A2003)
Object Variable or With Block Variable not set (Access 2k)
HyperLinks (Access2000)
Incrementing in Reports (2000)
Crash while running code (XP Sp2, Jet4 Sp8)
Tracking sales (Access 97)
Placing the decimal place (Access 2000)
Subform to Multiple tables (XP/2)
Creating a 'self-join' (2000)
Importing with Input Masks (2000)
DAO to Edit Table (2000)
Hiding a button on a form (Access 2000)
Export table to Excel (Acc 2K)
Creating child table entries from a string search (2k)
Documenter-getting error message (2000)
Duplicate record with different key fields (Access 2000)
Code to not allow editing (9.0/2000)
Operation must use an updateable query? (2000)
Report Parameters (2000)
Export Tables (2000)
DB linked tables through VPN (A2002)
Recordset oddness (2000SP3)
Stopping cr/lf in text box (Access 2000 SR1)
Conversion A97 to A2000 (Access97)
expression in control source (2000)
Removing Characters from field(s) (2000)
Calculations in a Report (Access 2000)
Updating text box or label from table (XP, 2000)
Can't add record... (XP)
calculating a form to save in a table (9.0/2000)
Convert 2002 to 2000 (A 2002 & A 2000)
Email Multiple Addresses (2000 - SR2)
Print Report Behavior (Access 2002)
Can't set form filter to empty string (2000)
Multi-User database (2000)
security ? (Access 2000)
Importing FoxPro File (Access 97)
Changing Field Type with VBA (Access 2002)
email address validation (access 2000)
Run-time error '3265' (Access 2000 ( 9.0.6926 SP-3 ).)
Calling Access code/UDF from Excel (Office 2k)
Embedding JPGs (97/2000)
close all reports ? (Access 2000)
syntax for recordset of subform (A2003)
Left() error (2000)
Run-time error on search box (XP)
'Global' Event (2000)
Using <> in input mask (Access 2000)
Set checkbox to 'undetermined' (2000)
Subreport problems (Access 2000)
Update field from Combo or List box (Access 2000)
Batch Code & Swap (Office XP)
If then statement (2002)
Changing Backcolor In a Field (Access 2000)
SQL to export a file? (Access 2000)
Embed Tab control within another tab control? (2000 sp3)
Password Input mask (2000)
ActiveX Control Missing (XPDev)
calculating volume (a2002)
Embedded Excel or Export Question (Access 2K)
VB Font Formatting (Access 97)
Referencing Current Event (97)
Proper Construction of Modules? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
save query by form (Access 2000)
Where condition written on report (Access 2000)
Access Beginner book (Access 2002 (10.2627.2625))
ADOX Column processing (Office 2000)
Database Inactivity (97 and up)
Preview or printer for report (A 2002)
subtracting fields (2003)
code problem: Stumped (Access 2000)
Sharing (Access 2000/Windows XP)
modify default 'save' behaviour? (A2002)
Count Query (2000)
Tracking unused data combinations... (All)
ODBC - Tables not available (Access 2000)
Share database (97 / 2002)
Automatically create/refresh table links (All)
Join types (2000)
Keep Access form On top of all others (97,2k,2002)
Dynamic Caption (Access 2000)
Sorting: Dates and Nulls (A 2002)
Export Custom Fields to Access (XP/SP1)
Exporting Tables (2000)
SQL -- UNKNOWN (Transact-SQL)
Week of the Year (2000)
'Cannot add or modify record....' (XP)
List Box (2000)
Filtering (Access 2000)
acCmdPrint (2003,set to 2k compat.)
Sorted directory listing (97 / 2002)
Email (Access 2000/XP)
Report Totals (IIf) (2002 SP-2)
Call Procedure (Access 2002)
Import table from Excel (A2k)
For Loop for Managing Recordsets (2000)
Check if on list (office xp)
Junction Tables and Data Entry Forms (XP Pro)
Access ADP security (MSA 2000/SQL 7.5)
Rename Filename (Access 2002)
editing existing records (Access 97 SR2)
Make Table Query (XP)
Not in list question (a2003)
Set Focus on search box (XP)
Password for Report (2000)
Positive to Negative and Vice Versa (2002/SP-2)
expression builder (9.0/2000)
stLinkCriteria exp (2002 SP-2)
Access as a backend (2003)
Database Design (2000)
Complicated function (Access 2000)
Importing dates (Access 2002)
Week Caculations (All)
Numeric to Alpha (A2K)
File open dialoge (Access2000)
Handling lots of money (2000)
ODBC Connection (Access 2000)
Formula in Report (Access 2000)
Can I Requery Datasheet Form From VB? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
HIPPA Compliant Table (2000)
Data from another table (2000)
Alarm? (2002)
Nested IIF function (Access 2000)
Equivalent of GetAddress? (AccessXP)
Store Actual Print Report Date (2K SP3)
Select Report Preview (2002 SP-2)
Calculated Fields In Report (Access 2000)
Creating a sum calculation for a particular month (Access XP)
Access 2003 Format (2003 )
Sizing dialog boxes (2000 SR1)
Set 0 to all controls of a form (Access 2000)
Concatenate Zip+4 (2002 SP-2)
After update handling (Access 2000)
Function Keys for Own Purposes (A2K)
how to declare only once (Access 2000)
Fixing code (Access 2000)
Printer in Memory (Access 2002)
Implementing levels of security (XP)
Disappearing data (2002)
Modifying an existing query using VBA (Access 2000 SR1)
PassThrough Query Max Length? (2K)
MSACCESS.EXE getting stuck in task manager (2002 (10.2616.2625))
Simple database help needed. (Access 2000)
More subform navigating (2000 (all updates))
Combo box not showing data (Access XP)
Tournament scheduling programs (Any)
email from Access (2000)
Merge Fields Changed (xp)
DLookUp in Form/Query (2002, SP-2)
Query Expression for Weighted Average (Access 2000)
Query description (Access 2000)
Modelling (2000)
Combo Boxes (Access 2002)
Automated Update Query (2003)
sub report recordsource (Access 2000)
Back end data table question (Access 2K)
Auto Numbers (97 sr2)
Calcs and format question (XP)
XP Runtime Problem (ODE XP)
Tab Control (Access2003 using 2000 format)
Binding variable query to field ? Possible ? (2003)
add-ins (9.0/2000)
Quick Access Query (Access 2000)
Remove part of record (2000 latest)
Access Error (2000)
Combobox requery (97)
Combo box find (Access 97/2002)
Email in memo fields (2k/XP)
Passing a string to the shell function (2002)
Proper method for saving date picked in DTPicker (XP/SP-2)
Append Query w/Duplicate records (2002, SP-2)
Woody's Access Watch (OXP SR2)
SQL Server Stored procedures (2000)
two copies opening (97)
Email Addresses - text data type to hyperlink (Access 2000)
Delete except one (Access 2000)
On Format (XP/2K)
slowing down and hangin up (2000)
Append Query (2000 SR-1)
A PDF Driver Alternative (a2k (9.0.6926) SP-3 Jet 4.0 SP-7) (342301) was moved to the Software Finds and Wants board
Integrity (2000)
Basic Form Design (2000)
Counting (Access 2000)
Programmatically Generate Charts (Access2K, Win2KPro)
Subform (2003)
Form w/ 2 Subforms (2000)
Creating a form from a query make in SQL View (2002 SP2)
Control Names (XP)
Invalid NZ function (Excel/Access/VBA 2k)
Merge into Word (XP 2002)
query ciriteria from form (a2003)
deleteondition all with where (Access 2000)
How do I add a numerical field that is larger than (Access)
MSChrt20 Reference (Access 2002 sp1)
running balances (Access 2000 SP3)
validation rule (Access 2000)
syntax error (Access 2000)
Special field (XP)
record-locking with SQL SERVER back-end (Access 2002, SQL Server 2000)
Convert to alternate DSN (2000)
Automaton error with Word (Access 2k Word 2k Win 2k)
I have created a monster! (Access2K, Win2KPro)
imitating Excel's fill function (A2003)
Calculated Dates (97)
Output to Filtered Snapshot Report (Access XP)
Move Empty fields in a report (2002 XP)
Requery method fails on subform (2002 SP2)
duplication finding formula (9.0/2001)
DLookup with Null value (A2003)
Null Criteria (97)
filtering unbound control (a2003)
Duplicates Test Query With Null Field (Access 2000)
Display current and prior record (Access 2000)
Report Calculations (A2K SP3)
Designed on Windows XP, colors look diff on win2k (XP/ SP-1)
formulas from linked db (9.0/2001)
Combo Box (2000)
Access Relationships Window (2000)
Second instnce of Access (Office 2k and windows 2K)
Reports-CaseOf (XP)
Running Excel from Access (Access 2002 SP-2)
Hung Access - any ideas (2002 sp2)
Formula for Adding names on a report (XP)
DLookup in a Form textbox (2k)
Need Help With String Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
LAserjet 1010 & Labels (Acc2002)
Changing User Passwords (Access 2K)
Procedure too large (A2k)
Updating Field from a textbox on a form (Access 2000)
Report subtotals every 20 lines (2000)
Grouping in a report (Access 2000)
Query with contradicting data (Access 2000)
No of fields on a report (2002/2003)
delete all the record in the field (Access 2000)
add to Module (2000 (all updates))
Syntax to Convert Numeric Dollar Amount Into Text (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Syntax error (Access 2000)
Snaked Column Report (97)
Cant Find Project or Library (XP under Win 2000)
Focus (I think) (Office XP)
Continued on report (Access 2000)
How many times selected weekday appears in month (XP/SP-2)
Dim dbs As Database (Access 2000)
Truncation (WIN 2000 Acc 97)
Recordset navigation (2000 latest)
Grow/Shrink boxes in Telephone Book (Access 2000)
Blinking control in report? (Access 2000)
No Access Help (Access97, Win98)
Duplicate Record (with unique field) (2002 SP-2)
Sorting by Number (A2K)
recordset error (a2003)
Need Correct Make Table Query Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)
Executing Form Code From Another Form (1)
Filter subform on tab control? (2000 SP3)
Report Insert Line Every X Records (XP)
Approach to Access (2000)
VERY Stubborn Error (Access2K, Win2KPro)
Access Classes (Access 2000 and up)
Mid Function (2000 on Windows 2000)
Adding Records with a Combo box (Access All versio
Preview (2002 SP2)
How can I check table properties in code? (Access 2K)
Report show only items greater than 0 (Access 2000)
AND criteria with one-to-many relationships (Access 2000)
Auto Date Entry (Access 2002)
subform linking (Access 2002)
denying access using API call (Access 2000)
Query Sum on Report (Access 2000)
Access Upgrade (OXP (2002))
help with database design (Access 2000)
Importing an EXCEL spreadsheet (Access 2000)
HELP ..Calculation Error ?? (Access 2000 SR1)
Text datatype with forwardonly (VB6/VBA)
linking w/ excel (9.0/2001)
Date Fields (XP)
Workgroup security (Access 2000)
Checkbox Keyboard Entry (Access 2000)
If/And Statement (9.0/2001)
Combo Boxes-Automation (2000)
Picking 50 random numbers (A2k)
Updating SnapShot Reports (2000)
NZ() function on report (XP)
Save option value as defaul value (Access 2000)
sum1 page (2k)
Importing Excel into Access (2000)
How Do I Delete the Query Warnings? (Access 2000)
Problems with no records when using query (Access 2000)
Upgrade Security Problems (2003)
F2 Equivalent-for Keyboard Data Insertion (2000)
Repeating Sections (2000 SR-1)
repeat calculation (9.0/2001)
Link to FoxPro (2K, SP3)
Querry Calculations (9.0/2001)
Permissions (Access 2000)
Custom Help Files (Access 2K)
Corrupt replica at hub (2000)
Sample Apps (2000)
DB Read Only (3027) midway through VB sub (A97 sr2)
Dealing with Name data (Access 2002)
SubTotal/total on Form/subfom (2000)
MDE file won't open (OXP SR-2)
error 'rememembered' by code after repair (2002)
Get size of table (2000)
Delete object in remote db (Access 2000)
Summing on a report (2000)
Access Square Root (2000)
Multi-table Delete Query (A2K)
Front end/back end (Access 2000)
Ordering Xtab Column headings (XP)
Replication Losing Records when Synching (Access 2000)
Calling SQL Stored Procedures (Access 2000)
slow table update (2002)
splitting database into front end / backend (2002)
Search for ampersand (2002)
Insert .jpg in OLE field (Access 2003)
DateDiff question (Access2K, Win2KPro)
Checking dates (XP)
Date record entered (OXP-SR2)
Case Null (2000 SP3)
Go to Records (2000)
Command Button (form has content) (2002 SP-2)
CrossTab report covering >1 year (Access 2000)
Can't drag fields onto report (xp)
Asterisk-More Detials (2000)
Asterisk on my Record Selector! (Access 2000)
Asterisk (2000)
Export ro Excel (2000)
ComboBox (saved value) (2002 SP-2)
Multi-criteria Report (2003)
ADO, DAO, I don't know (2002)
Reports - Paradox (Access 2002)
Adding related records using another form (2000 SP3)
Questionnaire - Design Question (Access 2000)
Upsizing to SQL 2000 backend (Access2000)
Access Database with VBA - Help!!!!!!!!!! (Access 2000)
SQL (SQL 2000)
Access Formula (2000 and XP)
Publishing MS Access 2000 to MS Word (Access 2000)
Access & Quick Books (Access 2000)
NUM LOCK/CAPS LOCK (WINDOWS 95/ACCESS 97)
Percentage in a report (97)
Write Conflict (Access XP)
Insert Into Values SQL Syntax Error (2000 SP3)
Continous Forms (97)
Date format (97)
export only footer to excel (2000)
SQL? (2000)
Appending records (XP)
'You can only run one instance of List Box Wizard' (200/SR-1)
Inbetween dates (2k)
Simple passwords (xp)
Shutdown problem (2002)
Startup (97)
Converting 97 to 2002 (Access 2002)
Error 3188 (2K)
Union Query question (2000 (SR1a))
Integer in code (Access 2000)
Access into XL (Office 2k)
INSERT INTO, eliminating confirmation prompt (2002, SP2)
Fill in all records (2002)
form 'doubling' records & duplicate record error (2002)
Form/Table (97)
Accidental overwriting data (97)
Visible/not on report (XP)
Access 2k, Terminal services and Outlook (Access 2000)
Wheelmouse and the VBA editor (Access 2k)
summarising financial data (a97sr2)
MSGraph (Access 2002)
Reports (1.12)
export to rtf (WIN 2000 Acc 97)
Access dlookup (XP 2002)
Wierd characters in union query results (2000)
Import Access 2002 tables into Access 97 (2003 or 97)
Function doesnt work first time (Access 2000)
Count 'check box' in Query (2000)
Action query parameters (2000)
Autopopulate Subform based on parent (2000/2002)
Strange Delete Behavior (Access2K, Win2KPro)
Index anomaly (Access 2000)
Access database - I'm stuck (2000)
Query (97)
Query problems (2002)
Passing Args (97)
Change SendObject format (SNP to PDF) (2002 SP-2)
Vertical print disappears (2002 SP2)
Navigate through subform records (2000 (all updates))
How do I access on internet (access 2000)
calculated fields (2k)
show slide show in form? (access 2000)
tab control content indicator? (2002)
enabling command buttons on a form (2000)
Datestamp continuous form (2002 SP-2)
Force a subreport page break (Access 2002/Win XP)
Link to Word (Access 97, W98)
Address a subform (2000, XP)
Mystery (2000)
Field List in a Query (2000)
Need Proper Query Syntax? (a97)
Publish with Word (Access/Word 2000)
'Blank' Field Not Blank (Access 2000)
Query total on group (2002 SP-2)
Updateable query (Access 2000/SP2)
Prevent viewing of records (2k)
Error -1517 (WINXP/ACC 97)
Restrict records in subform (2000)