Windows Secrets
Windows Secrets Lounge
cannot enter VBA code in form
Linking a button to a form
Access 2007 coversion back to Access 2000
NOT TOP X records
Referencing Global Variables
Embarassing Question re Posting!
Totals query - expression to list non group values
Delete Query
Variable Report Caption
Using email addresses in Access 2003 fields to email to
Refresh links code does not run (2003)
Weird label behaviour (2003)
Display week number in each of month
OpenReport code
Code
Update column in table + row by row
Report problem
Access 2003 won't open
Access Forum Face-lift
Queries, Totals, & Strings (Access 2003)
Tab Stop
Query Question
nested IIF in report
I need authentification!
Keyboard shortcut 2002 SP-3
Table opened exclusively by another user
OpenReport code (2002)
Create a view with an If Function (SQL Enterprise Manager)
SINTIAX in sql.... (2000)
SQL Builder (VB6)
SQL Triggers (SQL Enterprise)
Conditional Format days (2007 SR-1)
Linking Fields on a Form (Access 2003)
IIf statements in query (XP)
Form Management (Access 2007)
Open db from a form event (Win XP Office 2003)
Separating Label from Text boxes in a Wizard Form (Access 2007)
Close Email (2003)
Recordset Loops (2002/XP)
adjust joint query string wit &... (2000)
Controls moving up in detail section of report (Access 97)
Query too complex or System Resources Exceeded (A2K)
circumvent 8.3 DBF names? (A2003)
Next record in a sorted or (Rank ordered) list (2003)
Text to Number (2003)
OLE Error 2757 in ade but not adp (2000 with SQL2005)
SendObject and Outlook 2007 (2007)
Find asterisk (2000/XP)
Scientific notation (2002/XP)
Linking SQL Server Tables with ODBC (Access 2003)
Delete Query (XP)
COUNT calculation (2003)
parameter query (2003)
start printing report at specific line on page (2003 all updates)
SELECT disntinct but only not empty records (2000)
Query issues (2003)
Access and 'Hamachi' (any)
crosstab query reports (97 sr2)
Forward references in Access 2007 (pro)
DSum on Change (2003)
Invalid or Unqualified Reference (Access 2003)
Show Table And Make Table Query (MS Access 2003)
Install packages don't work anymore (access 2002)
Receipt form (A2K)
Import all Excel sheets (2003)
Using Access to populate Word doc. (2k) (759291) was moved to the Word board
Records Not Linked (2003 SP3)
SP3 Calculations (Access 2003)
Required field on a form (2002)
zip code database (2002)
Cannot update (Access 2000)
Visible controls (Access 2000)
If is opened (Access 2000)
button to copy data from field to field (2002)
If a table exists (Access 2000)
After update in form (Access 2000)
Cont Function in a report part II (2002)
Count function in a report (2002)
update on the last field (Access 2000)
Execute code (A2K3)
weekly report (2003)
rename field by code (Access 2000)
Adobe PDF (2000)
Right Mouse not work (Access 2007)
MultiUse DoCmd.Report (A2K)
text (2000)
query criteria (2002)
Error: Invalid procedure call or argument (5)? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8 WinXp SP2)
You can't use Apply/Filter action on this window? (A2007 (12.0.6334.5000))
Linked tables are Read-Only?? (2003)
Error 3061 in function (2003 SP3)
Highlight current row (2002)
Not sure if this can be done (2002)
Subform Top Record Always in View (2003)
Text Box Control Syntax Error? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8)
PDF file (Access 2000) (758523) was moved to the Other Software Applications board
FAST find method (2000)
Temporary Disk Space (2003)
Referencing Tabs in an Access Form (Access 2003)
Insert a row in excel from access (Access 2003 SP2) (758339) was moved to the Excel board
Call Mail merge Wizard (2007)
Mail merge & normal.dot (2003 SP3)
report and group headers (2003)
push selected value to a text box (2000 all updates)
BeforeUpdate form ctl event trickery? (2003/SP2)
KeyCodes not working (2000 all updates)
Combining multiple DB into 1 (2003/SP3)
Opening mdb with Access 2007 then Access 2000? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8)
Run Console app (2007)
Access 2007 Opening FE.mdb the first time? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8)
Access 2007 Version? (A2007 (12.0.6334.5000) SP1 Jet 4.0 SP-8)
Write Conflict (2003)
Return to Same Record (2003 SP3)
control to open linked form (2003)
Query Quandry (A2K)
Event when tab is clicked (2003)
Access/Outlook Interface (2002-SP3)
resize photo (access 2003)
Cloning a record (2003)
printing labels (Access2003)
form crashing lookup tables (2003)
Recordset for a call list (A2K3)
Error 3075 & report creation (2003/7)
COUNT records by conditions (2000)
Too few parameters (Access 2003 SP2)
Follow Hyperlink field from Access report (2002/2003/2007)
Setting sub-form's recordsource (2007)
International user base? (2003 sp3)
Can't Figure an Update Query Out (2003)
Crosstab dilemma (2003 SP3)
Trailing decimal in report (2007)
Union on two patient tables (2003)
Update query (Access 2000)
Design question (2003)
DELETE distinct ... (2000)
Currency stored no of dec places (Access 2003 SP2)
Disappearing name from report (2003 (11.8204.8221) sp2)
CommandBar Menu: Submenu Items (A2K, SP3)
Query based on query based on query based on form (2003)
starting spot for db (2003)
runtime error 3251 (97 sr2)
2003 versus 2000 (2003/XP/2000)
Importing SQLite into Access (2002/SP3)
Conditional Formatting a report (Access03)
Help for the next step, and more (Access03)
Access Data in Excel (2003)
Delete object (Win XP Office 2003)
Error 2950 and data mismatch (Access 2003)
Problem combo box (2003)
SUMM recorset fileds and recopy in listview1 (2000)
ODBC call failed to SQL Server (Access 2003 SP2)
Complex Query (2003)
Field Xref (2007)
Import from XL - IImexGrid object error (2003)
Imported data (2003)
Parameter behind command button code (Access 2003)
More Pivot syntax (2003 SP3)
Create row number in query (2000/XP)
ERROR typ mismatch (2000)
Calendar (2003)
sub report height - blank (2002)
date differences between successive records (2003)
Fire event when Resize is finished (A2003)
record count (97 sr2)
Creating normalized DB from denormalized flat file (A2003 SP3)
DAO 'Undefined Function' (2000/XP)
Filter - Or (2003+)
Combo box auto complete (access 2k)
Combo Box Issue (A 2003)
Hyperlink to PDF document on network (2003 SP2)
Only allowing one person (2003 SP3)
DataErr 2279 (A 2003)
delete all queries (Access 2000)
Minimum Date (2003)
tab control (access 2002)
Entering Numbers into Excel from Access (Win XP Office 2003)
Auto import from text file (2003)
Using F6 in Table Design View (Access 2007)
Field list for pivot table in VBA (2003 SP3)
Looking for a Youth Trip Database (2003/SP3)
Parameter Query (2003)
Null default (Access 2007)
Deselect List (MSACCESS 2003)
Toggle button (Access 2000)
Array (MSACCESS 2003)
Toggle button (Access 2000)
Update value (2003)
DLL usage in Access (A2003)
Blank fields in a query (2007)
Age in years & age in days (2003)
Opening form to Specific Record (2007)
Save Report Changes (Access 2007)
Image (2000)
Enable Subform based on main form combo box (2003)
Using data from a form to print report (2002)
Form Problem (2003)
access report (access 2003)
Password on all DBs (2007)
Acess and LiveMesh (2007)
report field ordering (2002)
Web services (2002)
Delete querydef fields (2002)
Multi select list box on a form (2003)
Counting and totals in a query (2002)
Exported Report Formating (Access 2003)
where condition in VB (Access 2000 +)
Wrong results (ms access 2007)
Form scrolling question (2003)
Dealing with a missing value (Access 2003 xp sp3)
Found Word Font colour (MSACCESS 2003) (754024) was moved to the Word board
Bar Graph Color Anomaly (2003)
Nesting IIF statements (Access 03 SP2)
Password Switchboard (2000)
Using on page in report (2003)
Blank form (2007)
Enumerate Queries (Access 2007)
Like statement (MSACC2993)
making a combobox up to date (ms access 2007)
Foxpro file import into Access (Access 2003 SP2)
On Mouse Move (2002)
Set answers to query parameter prompt at form open (A2k)
Lost fonts (2002-SP3)
importing txt - the search key was not found'error (2003)
Transposing data (2007)
Sub Form (2003)
Dynamic font sizing (2007)
Filtering form based on PROC fails in 2003 (Access 2003 and XP)
Checkbox to Flag as deleted (2003)
Docmd.OpenQueries - where to output result and how (Access2003)
Configure Pivot charts using access vba (2003)
Calendar Control (2000)
Run code to add leading zeros (Access2003)
Frontend Roll Out Utility (2000)
Text box problem (2002)
Uniqe total in report (2003)
Query question (2003)
Run-time error 2486 (2003)
Extract data in access (Access 2003)
Combo Box troubles (Access 2003)
INSERT INTO syntax (A2K3)
Display Filtered Data From Two Lists (Access 2000)
To what redord point the recordpointer (ms Acces 2007)
order in ascending order (Access 2000)
filter (Access 2000)
save data daily (2007)
Windows Media Player (MSACCESS 2003)
ODBC Call Failed (2003)
Design question (2003)
Query; GROUP (2003+)
Unusual happenings (2003)
INNER JOIN very very slow (2000)
Records unexpected deleted from table (Office 2007 pro)
Relationships Code (2003 SP3)
OR expression (2003)
Additon Problem (2002)
Password Filenames (MSACCESS 2003)
controls with successive numbers (Access 2000)
Select case (Access 2000)
Public constant (Access 2000)
Exporting or Printing an Unbound listbox (2003)
Count() on a report (2002)
Code to open form (2002)
Columns in a report (2007)
Pull date from table for form (Access 2003)
Selected column data (2007)
Open form from code (2002)
number of Thursdays in a year excluding holidays (2000 all updates)
List Box for Query (A2k)
Lookup in two tables (2003)
Automated import of .csv files (2002)
schema ini to import text file.. (2000 and vb 6.0)
Number of items in the inbox of outlook (MS Access 2007)
Open Event Error (Access 2007)
Synch three listbox to scroll together (2003)
Calendar Hide (2000)
Include Or Not (ms access 2007)
a count if function (2007)
Select date prior to Max date on total query (2003)
Iff statement code (2002)
Securing 2007 (2007)
Access VBA select a record on a form (2000, 2003)
calendar Control (2000)
Update query to exchange 2 fields (2000, 2003)
Pass a parameter to a query via code (A2K3)
Records Modified The Previous Month (2003)
table dependency (Office 2003 Access)
Controlling a message is in the outbox of Outlook (ms Access 2007)
Manipulating backorders (ms Access 2007)
dubt on close statement (2000)
Criteria for a report (Access 2000 all updates)
Duplicating record (MSACCESS 2003)
File checking (MSACCESS 2003)
SQL Statement wrong (MSACCESS 2003)
Invisible database window (XP SP3)
attach db and sql express (2000 and vb 6.0)
error with 2 condition where (2000)
copy dbase from the same server sql express (2000 and vb 6.0)
ODBC connection (Access 2003 SQL Server 2005)
return false in SQL (2000)
Age function (T-SQL 2000)
Make Report Text Box Variable Info (2007)
Update OrderID (Access 2003 SP2)
RUNTIME 3709 (Access 2003)
User Level Security (Access 2007)
group headertext (MS access 2007)
Can not access shared doc (access 2002)
Opening a form with all textboxes empty (MS access 2007)
calculated fields (MS Access 2007)
Dressingup a form (ms Access 2007)
Access Reports (2003)
Hot Fix available for Access2007 bloating (Access 2007)
Looping or else (Access2003)
Sub Form Entry from List Box (2007)
fill combo with unique value... (2000)
List - Find As You Type (2003)
Scrolling Windows (2007)
Text Box Length ( Access 2003)
Clipboard Error Pasting into Access (2007)
restore previous value (2007)
Search Form (2007)
Strange results in report (Access 2007)
I solved my problem, but... (Access2003)
Missing Filter Icons in Datasheet headings (Access 2007)
Open with VBA a Password protected db (Win XP Office 2003)
Where's My Switchboard? (2007)
Graphic Title (Access 2007)
Baseline info (2007)
Declaring variables (Ms Access 2007)
Records Count (MSACCESS 2003)
Complex Query (2007)
Broken VBA (Access 2002 SP#)
Use Form to generate a query, then a report (2007)
Report Grouping (2007)
#Name?' (2007)
Call duration (2003)
Variable detail section height (Access 2003 SP3)
Getting an Image into an OLE Field (XP)
E-Mail Merge Coding (AC 2007)
Place a zero on Total query count field (2003)
Code to open a form (2002/sp3)
Unbound Fields (2007)
Error 7777 (MSACCESS 2003)
Using UPDATE to change a blank field (2003)
need zeros instead of blanks in xtab query (2003)
Import tables using VBA (2) (Access2003)
Crosstab Aging (2003)
One order table, multiple address types (Access 2003 SP2)
Trouble with adding records to a table (MS access 2007)
Query iif (2000)
Subdatasheet, or not (2003+)
Restricting Query (Access 2007)
Null Values (Access 2007)
Database automatic backup tool (2000, XP, 2003)
Rename one not all (2003)
Form filter property (2003+)
Import tables using VBA (Access2003)
'Cannot Create Databse Window' Error Message (2000)
Open report/form from selected record (2003+)
Lookup Tables Again (any version)
linking to an odbc tables and queries in access (2
Getting primary key value after insert (2002)
i may be up a creek on this one (SQL Server 2005, ASP.NET)
IIF and Conversion (Access 2003)
Environment variables (Win XP Office 2003)
Calculation from sub-report (2003+)
Using formulas (MS access 2007)
Updating the content of a listbox (MS Access2007)
Report - I can't figure out (MS Access 2007)
Lookup field Table (2003)
ADO or DAO? (2007)
error 2427 in a report (Ms Access 2007)
2007 on my machine...EDGADS !!! (2007)
Password protection (win XP Of 2003)
Form Footer Not Visible (Access 2000)
Snapshot Viewer (2000)
Groups inside the detail section of a report (Access 2007)
Replacing an ID in all tables (2003)
Does a table exist? (Win XP Office 2003)
not like function (2000)
A Bit of Set Theory Doesn't Hurt... (2003)
Assigning a printer to a report (MS Access )
Parameter CreateQueryDef (Win XP Office 2003)
Group Intervals (2003 SP3)
FindNext problem (Win XP Office 2003)
Wrapping code into another SUB? HOW? (Access2003)
command button, label, macro (2007, 2000)
Follow-Up Flag (2003/Access)
Filter form query (2k)
Export report to Excel and format (2000/XP)
VERY big prob with filed conversion (2000)
List Box doesn't display data (2003; SP3)
Page Numbers (2000)
Link Subforms (2003)
File Import (2003)
Forms and User Queries (2000)
Sum of Sum (2003)
LOOP in rset based var (2000)
wath is correct? (2000)
Doing a filter on a SQL linked table (Access 2003 SP3)
Formula based on date & autonumber? (2007)
Startup all fouled up (XP SP3 Access 2003)
Time Input Masks (Any)
Delete all records based value... (6.0)
Report Order (XP SP3 Access 2003)
logical approach to building equip list? (2007)
Report Format (2000)
corect this code? to find in field table (2000)
BeginTrans (Win XP Office 2003)
Temporarily store data per user per session (2007 SP1)
XML (XP)
Extracting Title from Names (Access 2000)
Separate City, St, Zip (2003, SP2)
Contruct of a filter or Query (2000)
Finding Records With Sequential Dates (Access 2002, SP3)
Very odd: japanese characters (2003)
Moving existing controls into a tab control (2007)
TempVars (Access 2007)
How to Indent an HTML Paragraph (Access 2000) (746908) was moved to the Web Design, Coding and Scripting board
tab control (2007)
multiselect property value (2003 SP2)
Comment-Out a Block of Code (Access 2000)
Event management (2007)
Treeview Background Color (Access 2007)
Hide Tables (2000)
why the code write from the line 30 .... (2000 )
Assigning From Field (2003/Access)
What makes sense (ms Access 2007)
Backcolor based on option group value (2007)
calculation based on number of records (2002)
Field text in msgbox (2002)
How to turn off edit mode (Access 2003 xp sp3)
Remove default colon in field labels (2007)
Default Value (ACCESS 2003)
Import an Excel file (2003)
Database Connection (Access 2003 SP3)
Replacement for DoCmd.DomenuItem (MA Access 2007)
Validation rules (2003)
Close button on a form (access 2003)
Fixed Column Widths (2003)
Selecting Displayed Sub Form Records (Access 2007)
DoCmd.DoMenuItem (Access 2003 SP3)
Directory and Files (MSACCESS 2003)
Family Tree (2003)
Display Main Report if Subreport Has Data (2007 SP1)
Concatenate a Field (2000)
Desktop shortcut to open DB in Exclusive Mode (ACCESS 2007)
object Menu entries won't open on double click (ACCESS 2007)
Date Issue (2003)
Composite keys (2007)
Default value of date field (Access 2003)
Data Leakage (Access 2007)
FormatNumber (AccessXP)
Numeric Field Overflow (2002)
/excl switch (Access 2000)
SQL Configure Report Server error (Access 2003 SP3)
Table structure (MSACCESS 2003)
Product Selection (2000)
A calendar besides a textbox for date entry (MS Access 2007)
changing a name in a report (MS Access 2007)
VAT Change (2007 SP1)
Create MDE without it opening (MSACCESS 2003)
Message Box (2000)
Export database tables (2003)
Sending emails to different groups in Access (Access 2000 +)
Is this a bug in MS ACCES 2007 (MS Access 2007)
Protecting the code (ms Access 2007)
Set focus to new record (2003 SP3)
Closing Word (MSACCESS 2003)
Word search (MSACCESS 2003)
How To Use FileSystemObject (Access 2000)
sql install problem (Access 2003 SP3)
word 2007 document properties (acess 2000)
Icons (MSACCESS2003)
sorting and grouping (Access 2000)
Opening mutiple mdb's (2002)
Subreport Prompting Parameters Multiple Times (2007 )
Checkbook Register template (2003)
INSTR not finding chr(194) (Access 97)
Replication error (XP SP3)
SQL Server relationships (Access 2003 SP3)
Permissions (2003)
Adding appointments to Outlook (win XP Of 2003)
Field cannot be updated (MSACCESS2003)
changeing font color with vba (2003)
Northwind database (A2007)
Importing several text files with different specs (2003)
How to Reset ListBox (Access 2000)
Making a subform visible (Access 2002)
SQL Server startup problem (SQL Server 2005 Express)
can't hide control that has focus (2003)
ODBC Call Failed (2003)
Add record action (2002)
Add Records Button (2002)
Memo Field (2003/Access)
Combo Box filter (2003)
Byte and Integer fields in tables (Access 2003 SP3)
Select Certificate dialog box (win XP Of 2007)
Formatting in Queries (A2K)
Checking files exist (MSACCESS2003)
Syntax to insert variable (MSACCESS2003)