Microsoft Access VBA Modules

Output to a fixed-width text file
Re: Clock or timer
Re: Adding progress meter in my import procedure
Re: How to Retain Data In Form
Quick Question - acOpenForm
Re: How to Keep Access Open
Re: protect password
type database doesn't exist?
Dirty Event
Re: COPY FILES
Re: How to Keep Access Open
Viewing HTML preview on a form
Re: How to refresh the list of modules
Re: Problem with NotInListEvent (ignore previous posting)
Re: Q: how do I interrupt a loop when click a CANCEL button on a form?
Re: Ceate Email in code message (using MAPI?)
Re: How to wiat (need code)
Re: Difference between trim and trim$
Re: Append Query in VBA
HOW I BECAME WEALTHY
Stop Multiple Instances Of Program
computer name
Re: Converting seconds to time format
Error 430, Class does not support Automation, Windows 2000 sp4.
Solver functionality?
Referencing Form Controls from a Module
email message options
Re: Geometric Mean?
Automating Excel to remove VB Code.
Re: Access crashes after creating Outlook/Word document
Re: Problem Removing References
Invalid use of object with .Find method??
Re: defining ADODB.xxxxxxxxxx Type
barcode integration help please
Trouble removing Class Object from Code Editor in Access
File Location
RE: defining ADODB.xxxxxxxxxx
Recordsets and mail merging
Re: Compact Database
Re: read-only access to a database
Accessing tables via VBA
Re: How to wiat (need code)
Provide VBA Password Programmatically
Questionnaires-Scoring
selecting in listbox with vba
Get 30.06 rates ex prism
IF statement and tables in VBA
RepairDatabase
Re: Exit Database On Timer
Re: Exit Database On Timer
Adding a record to a table
Insering a record using VB
Alternative to Vlookup in Access 2002
Re: Format Spreadsheet When Using SendObject
Where's the Recordset..Edit
reading from a table cell?
SQL
Append Query Message Box
Conditional Formatting
Inserting a record, error message appears.
Re: code module stoped working
How to draw a line every 5 lines
Getting a file name
Re: How to draw a line every 5 lines
Re: Changing value of a function in a module
Re: Converting VB Code from Access 97 to Access 2002 or higher
Re: receive returned value from doCmd.openquery
receive returned value from doCmd.openquery
filecopy function
Re: Mail Merge
Ms Access 97 created Username and Password on the Network
Re: Why does the Recordset not contain anything?
pull down menu in Access-VBA
Can't compile databse - why
Expressions in Queries
ADO .Open problem (posted on general news too)
Open embedded object problem
Add text to the beginning of an existing string
using query in modules
Dlookup doesn't work
Query Problems for Recordset
2002 to 2000 compatibility--help please
Re: Why does the Recordset not contain anything?
Converting Access to SQL Server backend - How do I control linked tbl ODBC Cxns?
Table level validation
Error on Modules
RST After the Query
Re: Why does the Recordset not contain anything?
Finding open Excel workbooks from Access.
Re: path to back end
Weird Data Type Error
Array Dilemma
Re: Code Corruption Problem
Createing a table through code
Change Registry Setting? (MVP)
Overwriting queries in code
Re: Index of a combination of two fields
sharing Modules
SMTP Email
Cycling Through Records in a Table
Using ME keyword to close a form
tracking
Access XP -> 97
Help Files
Please help with this function
Movefile method
Re: html help links not available
How can get Access to work with 2 Word Documents at the same time?
Public Variable Question
Call a msgbox on a specific error
Compile error in a sub when converting to 2002
Date Time Picker
Re: How Do I Run This Random Selection Code
Code Corruption Problem
hWnd Property Help Example gives Run-time error 2475 in Access but not in VB6
Autonumber after huge record deletion
can't find word97 object..
Hiding the Formatting (Form/Report) toolbar
=> Display a bit value as a Text 'Yes' or 'No' on a form
code module stoped working
How To Set Time On Outlook Task
=> Clear Text boxes on Master Form and linked SubForm
Pause code
=> Clear Text boxes on Master Form and linked SubForm
accessing to tables in db2
Public Function Q
Networkday Function
Passing Arguements to a function
How to retrieve data from a password protected website/ftp = HTTPS
look up record on form using set criteria from another form
SubForm - Data Entry
Sum of a Field
Re: => Loading Option value based on Form Query
ftp file automation
automation in sending an email
Converting RTF eventually to Access
Stand alone app
Re: Need HELP with Access97 RunTime
Re: How to loop through all keys of a collection?
VBA Password and Importing
backup
date functions
naming convention
The Daily Warezfaq - Thursday Edition QYPXVNNKC
create a dynamic form
Setting recordsource for combobox
Problems calling HTMLHelp from Access 2000
Printing Reports
Re: Which button was clicked in detail area of endless form
Updating a table with a query
Re: Setting recordsource for combobox
test
concatenating files
Deleting Records FROM VBA
Re: using outputtable to export select fields
Deleted the form - the module's still there. How do I get rid of it?
Qualify DAO referance
Northwind example does not work? (!)
Get data from main form?
Re: module not found, access forms
Check Directory (Urgent)
How create a Word Document from Access?
Private DBEngine Problem
Overflow error in Debug window
Wanna buy a Cigar?....
Query in a Recordset w/Filter
Why doesn't this VB code compile?
Broken Application.CurrentProject.Connection
Put Data to a subsquent new record?
set focus to subform?
How to get rid of a message box that keeps popping up
Re: A table to auto. update
Re: Add column to existing table
Re: Replacing control characters (' and ") in strings for INSERT statements
Re: Replacing control characters (' and ") in strings for INSERT statements
Re: FAST reattach tables
Re: Replacing control characters (' and ") in strings for INSERT statements
Re: Help with VBA
Re: Editing a Word template from Access VBA
Function to Sum Values With Same Characteristics
Field Comparison
Puzzler-ranking
Searching RTF docs for values
Re: Query filter
Change background color
Assigning returned SQL to Variables
Code to refresh Excel PivotChart and PowerPoint
SaveAs with default filename
Problem with an updating query in a VBA of Access 2002
VBA diagramming tool?
split a variable or extract part of it?
ACC2000: Requested type library or wizard is not a VBA project
Re: Problems with arrays
Expert needed: Passing textbox contents to new form
VB and Access
Computer name in vba
Re: Problems with arrays
Access memory leak?
Functions
CurrentProject.Connection
Re: Find Directory
Tool Tip Formating
Need help with QueryDef
Runtime on winn2000 sp4
Access Query Result from Another Program
Recordset as Form's Recordsource
trolling for spam
Sum in Query Values
Re: access/word/vba
Errors
ImageList Control
Open another instance of Access
Compiler error at "ConnectDb"
Using recordset with outputto?
Re: OpenRecordset
recording outside data
Re: Using FileDialog within Access 97 - TIA
Re: Using FileDialog within Access 97 - TIA
Re: Open a form in a specific mda library
Error Accessing File. Network Connection May Have Been Lost
Re: Error Accessing File. Network Connection May Have Been Lost
Re: Copying Info in Form
Suppressing Error Messages
OpenRecordset on Linked Table
Function results not read by others
DNS
Coding in Access
Slow Performance of VBA Code
EOF
Programatically identify Access version
save current record in VBA code
Coding in Access
Table of Contents Report
Opening a standard 'File open' dialog box.
Re: SytemRoot
Loop
NoData Report property
Trim Function
Can I make a sub form pop up/modal
Calculation problem fromSQL
Run time errors
Re: Connecting Access db to a mysql server
Update hyperlink in VB
Re: Commenting Out Code in Bulk
linking database to network login
HELP: Using FileDialog within Access 97 - TIA
Declaring an setting a "public" variable
How to save username and password to login to Orcale database
Tabbing through a Form
Database won't work in Runtime Version
Clipboard
HELP: Problem with exporting Access Report data to Excel
Re: How to verify if a table exists
OutputTo method hangs
Checking for NoData in Report
Re: How to verify if a table exists
Print dialog box in VBA
Re: How to use Save as Common Dialog box in Acces
creating a stand alone application from access
Re: Option Compare Database
Can a database expose a class?
Unrecognized Database Format in VB6.0
how to programatically add a refernce
DISABLING THE REPLACE TAB IN FIND/REPLACE DIALOG
Pulling value from table using VBA (ADO)
Re: running sum in a form
Using the My! keyword???
Trim Function
Re: timeout
Query output with criteria to another Office application
Re: Delete content of the clipboard in VBA
Accessing table and/or form fields from VBA
Urgent help, RIGHT JUSTIFY leading zeros
Open a seperate database
Re: Unusual Compile Error
"Staring" an input box
MS Outlook 10.0 Object Library Question
Re: Missing references when opening database in XP and 2000
How to put Date from Table on reports
Re: How to put Date from Table on reports
Oracle 9.2.0.2.0 ODBC link
Re: SQL Sum function not working in vba
How to insure a loop finishes before closing the procedure/app
Access Shell statement
OT: New reporting tool
ADV: Free games for life
Re: .mdb file just keeps growing
Re: field properties
Re: Delete table from closed database (Urgent help need)
Re: capture keystroke
auto send report
Use a Report to print VBA results
Point of Failure in Procedures
Help with code to generate primary key
Re: fiding specific data
Run -time error '13': type mismatch
Serial ports
How to code for different versions!
copy/paste
Call Stack.
Cursor Always moves back a character after space
Counting Consecutive Hours
fiding specific data
Re: DLookup with multiple search criteria
Re: Adding Record when form source a query
Date()
Adding items to a shortcut menus via VBA
JPG files
Re: DLookup with multiple search criteria
MSFT Access Geneology template problem
how do I detect if a field is an autonumber field?
missing DAO350
Re: db.execute action query created in QBE
Binary to Decimal Conversion
Binary To Decimal Conversion
How to run an external batch file
Coding
Re: exporting multiple tables to single excel sheet
Re: Creating a New Form
Re: db.execute action query created in QBE
Re: db.execute action query created in QBE
Adding calculated field to crosstab query
Repeated data count in form entry???
Re: How to stop Access from changing class names
Re: How to stop Access from changing class names
Re: How to empty out a date memvar???
Re: Missing references won't go
Re: How to stop Access from changing class names
Screen Updating
Re: How to empty out a date memvar???
EARN EXTRA CASH!!
Publish to PDF
yetqwyrt
Try our 2 TB+ FTP servers!
Can't Update Table
Duplicate the Zoom feature
Search Files
Variables and passing between forms.
Re: Can't import through VBA
Question???Querydef
Convert Hex to Number
Slow database on Network - Large Front End
FileSystemObject
add record to subform
Calling functions on a Form Class Object from a Module
Returning database location/path
Restore Form
Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
Detect Version of Access
DOS Command Line Syntax
Re: Printing Report
Search 'current procedure' reverts to module-level search
Recordset contains only one record - should contain more
! DAO Record Locking !
Unknown Function Name when calling VBA function from a query
! Checking for value in Textbox !
How to read a Word Document from Ms Access
Deleting records.
Len(str)
Change field format with VBA
Force MS Graph to retrieve records
windows xp home edition in windows network
Problem w/ references
Table Description
usa ghost!
Untrappable error
Re: Recordset has only one record?
after_Update problem
Error trapping fails in XP
Hyperlink
replace function in Access 2000
Size of string
import multiple files
Re: Find Out Location of Access.exe File
Pause code for 2 seconds...
Sometimie Error Message
Line Method
Re: Open a Database send userid and password
Object not defined Runtime error
Form's BOF?
Exporting Email Addresses from Access to Outlook
ADO: Tweak Field Properties
question on class modules
Re: Source for VBA syntax help
printsize vba
Recordset only returns first record, when Query SQL returns 51 records
VBA PASSWORD HELP
Validating form
Find on a field that contains quote
display query with code
Find on a field that contains quote(2)
Re: Column Width
Re: AllowShiftByPass
Re: display query with code
Re: .wav files
How to Draw Line on Last Record
Type Mismatch
Re: Meaning of [<Non-Basic Code>]
Building MDE Programmatically
Re: If an object exists then...
Compile Error: Can't find project or library
Generate Unique Passwords
VB Code for Copy/Paste
Transpose data
CASE statements using wildcards
Access closes app but process remains open
Modifying the path to linked OLE Objects
Using variable as recordset field name
Updating table in outside database
Controlling keyboard actions
import excel function for use in queries
Re: Count number of Users
Data Validation
How to suppress the delete confirm box and go on?
Re: pass a value to a query
supress the decompile msgbox
When to Dim, Private or Public
Updating table in outside database
Re: Access/Outlook
Re: Setting CurrentUser to %USERNAME%
Checking for Network Connection?
Error Executing the command
Visual Basic error message
Module for Showing Error Message in Query
Access does not close
Calculate rolling 12 mo period
Re: send Eudora or MAPI email from VBA
OutputTo Excel Using Filter or Recordset
Print report for each record in database
Re: Converting Foxpro to Access
Querying a website using URL
Open Access Application
Re: Convert Access Database to Visual Studio
Re: exporting date data type to text files
Fax document within Access
Refreshing Treeview Data
Exporting MSFlexgrid to Excel
Re: VBA, Access, and Letter Case
Open Outlook from Access
Autokeys
Pass-Through Query
Re: #Error only on two machines
Unrecognized Database Format
Finding most recent record
Listbox need help
send email with attach file
Where is Access going?
Cannot expose a class
/wrkgrp Command Line option
Email Word Document in Access
Windows API SendMessage
VBA data connections within a function
So close...please help!
Re: send Eudora or MAPI email from VBA
Delimiter
Re: VBA, Access, and Letter Case
Code for Creating Table
Re: deleting queries
Re: deleting queries
Re: Converting Foxpro to Access
ms access 97 vba collection.item(strKey) gives error 3021
! DAO Equivalent of DMax !
Question re: code text
Code to delete table if it exists
money - try it!
Opening a Secured mdb with Automation
Override system error with own message
How do I make the program to wait?
What Does This Mean Please?
Re: What Does This Mean Please?
Assuring that update by "database.EXECUTE sqlQuery " was done
Re: What Does This Mean Please?
Referencing a query in CurrentDB
Adding ActiveX controls to Access
Code for picking out file names in directory listing
Generate a calendar in Access
Triggering events just before close of database?
Text Box Search for Inside a Database
Access 2000 Recordset issues
Microsoft Windows Common Control 5.0 (SP2) not working in Ms Access 2000
Re: "file already in use"
why does macro menu come up when one runs a module
Linked tables
Re: send an e-mail notification
Module linked to table
Dynamic Crosstab Report in Access 2002
How can I change the appearance of a field if certain conditions are met?
Where is Table 'Hidden' Property?
problems when adding field properties via dao
Export multiple tables to Excel
Path property
Re: deleting queries
drawing functions in VBA?
Re: Validation Rule
Stopping the escape key being pressed.
subForm allowedits problem
Export to queries to Excel
How can I get the username from workgroup information file.
delete/update record
adding data to two tables simultaneously
MS ACCESS Switchboard Runtime Error 3001
Re: Sending Outlook Email In Access 2000
Re: form properties - which ones to use?
"...pending changes exceeds limit."
A file Word within a field
! Recordset Close !
Urgent: how to change Access 2002 database password by using Visual basic 6.0
Visual Basic Out of Memory
Calculations with time values
Backup Button on Desktop
Re: commenting large sections
Set Form = Recordset
Re: Deleting an Open Database Object
Access MDB Version
DAO record size 2K limitation in Access 97
Run Macro
Re: Tab control
Suppress SQL Login Failure dialog?
Recordset Source
Close Database
Re: FIND/REPLACE DIALOG
Read-Only linked tables
Re: Set Form = Recordset
How to change printer via VBA?
MDB File Version - NOT Access Version
Deleting a report's recordsource
Make big bucks easy
Inserting data from Access to an EXCEL spreadsheet
Re: query
update SQL
Use of .LEFT property
Green Eggs Report
Export a report
Re: String comparison, percentage the same?
Where Clause in OpenReport Method
Opening Non Office Files
Windows Logout
Re: Pre-defined formats
How to get full path to linked tables
Pre-defined formats (Repost)
TransferText to mailmerge file doesn't work
Exporting multiple reports through VBA
Creating, naming and browsing for location of save of new excel file
Re: Can VBA Detect Data Integrity Violations?
Re: Pre-defined formats
Code to duplicate tables
VBA Code in a Module not recognized
Need to Pad Zeros
Export to text file with Trailer Record
Re: Append query using DAO
Assistance requested with reproducable GPF in Access 2002
Re: Adding subtotals in a child form together to appear in main form
Re: Detecting networked BE file
RE: Update Statment
Re: Delete Records
Padding zeroes to a decimal field
passing arguments byref in VBA
Re: the use of .Pattern in access
Re: query (Repost)
Calling a function in opening a form
Re: replace function
Re: stringTokenizer in VBA???
How to make a Form/Report open quickly ?
Why Report fails to open ?
how to chopp off two final comma
Declaring a database ?
Data source fail-over
Automatically insert a row in a table
Re: Active X Control Licience
Re: Can VBA Detect Data Integrity Violations?
Error 49 bad DLL-call
Re: Disable mouse wheel in code?
Re: Disable mouse wheel in code?
Re: CallByName from commandbar control
Record sets reading from tables for functions.
Re: Detecting networked BE file
Re: Retained Breakpoints
Re: Check if a table exists using VB
common dialog
update right away
Unbound forms in access project
Unbound forms in access project
Re: Check if a table exists using VB
KeyCode to ASCII code/character
JET 4.0 sp7 breaks old vba code!
Returning a single value to a variable from a recordset
query
inserting an rs into a table
kick users out !
Pass Field Value and Loop (Urgent Help Need)
ERROR: ByRef Argument Type Mismatch
VB String Function$
Page break problem with sub report
access 97 module for dde
Attach a PDF or JPG file to an Email
Limit Continuous Forms Records
calculations
Sending EMail; Outlook Dialog a nuisance
ini File
drvlistbox, dirlistbox, filelistbox
Testing if attached table not present
Error while deplying programmed access file
Re: IFs, ELSEs, END IFS -- proper construction
Access Websites
DAO rs
Check if a table exists using VB
Criteria Data Type Mismatch
Class Module Not Recognized
requery
Edit not allowed for a field in data input form?
string problem in a recordset.FindNext
Shell is leaving a process open in Windows 98
Re: CDO 1.21
Permissions with VBA
Re: Interesting Access problem with network
duplex printing option
Linking to secure DB
access 97 vba tapi - make automatic internet connection
Access XP - DAO or ADO
Email - Using Redemption
dealing with multi-user access to and pop-up alert message
Re: VBA code to print only one report using only the current record
Optional parameters in function
Code for space delimiter for exporting data
Executing an Access module thorugh scripting...
User specific options
variable question
global or public variable
Overview of services status
Type Mismatch On Setting Recordset Object Variable
Error while working on Access
Installing Rich Text box
DAO Recordset Problem
error 2105, can't "go" using Gotorecord, fails on loop 390
Bruce - Can you tell me more?
dlookup function problems
Re: disabling default warnings/messages
Error Message
String <-> Double
Memory Usage Snapshot - Total Mem vs. Available Mem?
Error code to delete five tables if they exist
How to connet same helpfile to all froms and reports
Delete records displayed in a Form
EARN$£$600\week downloading free software
Stored Procedure as Report RecordSource
multi-langueges mess around in code
Page break in sub report
importing word data into an access database
Error Msg
Open Word doc
pass through queries .sql property
Adding References through code problem
dynamically retrieve form/report fields
openformwithinput
Automation question
Create Email with Report as HTML
DLookup after AddNew
.CreateField Formating
Run-time error 3061 - Too few parameters. Expected 1
Auto Send Email
Re: solution
Export a report in HTML automatically
PIN and associated data
dao won't load
Re: ODBC Connection from VB6
How to get server (has mdb) date and time to MSACCESS clients?
Opening database
Re: Compiling code
String manipulation
Variable problem
probleme exportation etat avec sous-etat
refresh
DLookup doesn' always find value of new record
Re: VB code on a form button
Relative path
Re: DLookup doesn' always find value of new record
Re: VB code on a form button
ADO "CurrenProject" object in Access 97
Re: Record set question
update record pragrammatically
Re: Access 2002 Printer Object
Search enabled Form
Re: How to disable Wraning Msg.
String Provider Error Problems...
Error on DAO extract of DB2 version 7 tables
second line for a string
transform data to string (or something like that (-: )
update/edit records
How To Find Out If A Variable Is Assigned?
Re: Label or Text box to set the caption with my translation table
inactivity log off
Re: Filter By Form
Operation not supported error
OrgChart programmatically
Re: VB code on a form button
false Application.Modules.count
Filter problem help me plz!!!
wrong Modules.count ...
Copy of current database
Missing Properties
spell checker turned off in code
DLookup doesn' always find value of new record
How to programatically create/copy a button?
Programming help
Crystal report and Access 2002
Append current record to another database table
Re: File Sharing stopped by new Anand Bhatt music release - Egc5
Field Edit
SQL login
DoMenuItem
Re: "If" Formulas
Method 'CodeDb' of object '_Application' failed
Code for Exporting to Text
Can i view my access2000 web component page to client side?
TURN 6 TO 60,000 DOLLARS
Re: OpenCurrentDatabase Crash
Checking optional arguments for null
Code Error
Irrititating problems with conditional compile
how to pass a password to crystal report 9.0 from vb6.0??!
Can't OpenDatabase using DAO
problmes with vba code
cascading reports based on VB script
Great difficulty solving a would be easy problem
Re: Programatically creating a table
Filtering New Records
Checking links to back-end takes very long
finding file modified /created date in Access 97
Getting the nth item out of a string of delimited items
Code to seperate first and last name
Re: Programatically creating a table
Workspace in Access 2002
Visual Fox Pro Conversion to Access
put data automatically into an input box
deleting entries
sending record via email automatically populate a field
Transferdatabase and Boolean fields
Missing reference DAO2535.tlb
Re: Programmatically convert Access 2000 to Access 97 - Can it be done?
Re: Programmatically convert Access 2000 to Access 97 - Can it be done?
Re: Defining the Format for a Date/Time ADO Data Type
Using Outlook reference library for Access to send Contacts using OLE
Pulling DIR information into Access
error 49 Bad DDL call
Getting Table data by vb
Moving to Another Database
Programmatically Accessing Database Size
Starting Macro at some future date and time
Add record not showing in listbox first time form is used after form load
Make an object (query, table ...) unvisible programmatically