Microsoft Access VBA Modules

Recordset automatically updates
transaction processing in MDB?
SendKeys not working
Corrupt records Error 3709 - will splitting the database help?
Work Schedule
RecordFetch Optimisation with ODBC drivers - advice needed
Date & Time A97
How can I stop my CDO e-mails triggering spam rules?
Access equivalent to Excel's CLEAN function
Add records to tdfNew as TableDef
Insert form information into an email
Creating Autonumber Field
Sending and deleting meeting invitation via Outlook
Deploying an Access 2000 application
Customize input box?
Hiding a Form (Completely) A97
Exporting table contents
unwanted info in reports; how do i get rid of it
Error When Trying to Calculate R Squared With Only One Datapoint
DLookup (again) A97
Open another form on the OnLoad
Where are the CONVERT & CAST functions in MDB?
SEPARATING DIFFERENT DATA TYPES STACKED IN THE SAME FIELD
String to find Recordset Field Value
Update and Delete cascade
Can't refresh report in code.
How to get multiple options into a text box
VBA Active-X object references
Cange sytstem language and back
RE: HELP! with email code
SQL question on "Insert into "
Set a reminder for bill payment
RE: HELP! with email code
HELP! with email code
Comparing Two Tables w Code
Problem With Vista Blocking Macros
vitrualhomeoffice
Quotations in SQL Statement
ADODB.Connection run-time error -2147467259 (80004005)
Recordset based on Query
Need help understanding code
Help with VB
Access database with one form, multiple tabs, one table source
Insert Statement
run sql if value not in table?
Option button
Register a library
Detect if connected to the network
Hyperlink problem
Linked Table Attributes
Trap ODBC messages on a SQL Server bound form
search forms and subforms
Dirty??
Viewing PDF-files
Form and what shows on open
DCOUNT IN SUBREPORT QUESTION (TABLE HANDLE ISSUE)
Install a Font
Europe Tests Established Chemicals on Millions of Animals
List Database Users
Manipulating an Excel spreadsheet from an Access module
Hyperlink fields
Change color of my graph
Use a string as criteria to run query
error 2147024770 (8007007e)
Importing CSV File
Using VBA To Write (Print) To Screen (Printer)
Editting fields of a table using VBA
Date() problems
Fixed Page with tab control
Print output file in VBA
right join
Close files from Access
Encryption A97
replace apostrophe
Remove Apostrophe
Unhide Module
PDF File
New record
New records redux
Invalid use of null
If Statement Problem
Obtain the current system IP address
Is Database Window Open in Access 2003
Count # of Records
Write Conflict- Where to intercept?
assigning ado recordset to subform
assign value to field with VBA
From code directly open query
import a range in a column to an access table
Dmax in a Domin
Update SQLquery not updating table
dynamic sql (flexible query)
File DSN in vba
Printing Reports on single records upon request
Change Number to Arabic and back
Problem with SetFocus
Errors in Compiling BeginTransComplete in Access 97
I need to calculate Percentile or Quantile in Access
Module Question
Email problem: run time error 2957
Is there TRANSPOSE function in ACESS database
Finding a record in an ADP
Pivot table problem
Retrieving a single value from a table
subreport recordsource
SMTP Emailing - Ostrosoft With Variable Error
Using DSN-Less Connections
basDeclares
How do I enable/disable events in Access
Date() function
Convert field data to csv text
Modify subform tables dynamically in Access 2003
insertfile command don't work
calling a sqlserver sproc from access
Warning Message on Data access Page
Check if data already exists in database.
Error handling
Planning Schedule
Error while running Graphs
TransferText
Syntax for copying a file from one folder to another
Open to Specific Excel Tab
Dynamic Creation of Option Group
print plain text from access to user-specified non-default printer
rs.open sqlcode in ADO recordset not working
BESPOKE SEARCH
default parameter value
VBA Refrences Hanging up Other users
Copy Method
Default printer name in A97
Security Changes
refreshing folder contents (maybe?)
writing primary key when multiple fields
"The Data has changed" error -2147352567
Access Forms
My Code doesn't work properly
Declaring Variables at Module level and Procedure level
Quarter Dates
DoCmd.SendObject
RE: Event procedure not working
Event procedure not working
Dcount Syntak ?
Use VBA code to read contents of a PDF file
Sending Printer commands
Access 2000 VBA Loop through Hyperlinks in a Word 2000 Document
Exclusive Access Conflict
Inter-database commands
Eval Function & Variable
How to disable save with OLE word object?
Deleting an outlook calendar entry via Access 2007
Viruses error
Can I have some help please?
Displaying data from other databases
Coding a chart from scratch
check to see if execel is open
getting current record count in a table
retrieve windows login id
Best way to update linked tables on forms
Merge Word Document and a Template
user id
Slow performance on network
VB to create .lnk files
Trim existing data in a field
open excel worksheet from code
how do I know the timezone in the computer from vba?
Comparision
Custom report preview toolbar
Access-to-Excel Automation - Saving Excel w/ Custn Filename
Multiselect restrict to one if "none" selected
Best practice data-typing combo/text box contents
Change Field Type
Copying Files ... Replacing ID's
Overflow Error - 0 value
Setting Default Value
Breakpoint - does it change your results?
Importing from bank files with format BAI2
Resetting Sequence Number
movefirst returns last recordset
manage Adobe driver programmatically
HELP Appreciated
Change linked table destination--Access Link to SQL 2005
DLookup error
Send printer commands
Run a dos command in Access?
pic coding problem
Allen Browne Audit Log - EditTo problem
DCount Function
updating information
Print dialog box
Send email from access with non access file attachment
TransferSpreadsheet
WORLDS LARGEST COMMUNITY !! BE THE PART OF IT !
Code to open built-in dialog boxes in Access
Sending Mail via Outlook
Make text appear as button face
Function to copy a button
Speed on query
Custom format using time
record sorting
adhGetAccessObject and adhOpenCurrentDatabase code
Merge insert data from recordset into existing word table
New Access Install - Form no longer works- Help!!!
PLease read and try this is a great service from internet, better than others read this woth only 5 minutes of your life. Sorry for my english
execute .exe file and type a text string on it
Make function in form class module visible to AutoKeys macro
Syntax error in query expression
Update Query
Invoice Number Assignment
Need Help with Coding!urgent
Make a drawing via access using loop
Number of records inserted
Refreshing Table Links to Excel Programmatically
Crystal Reports XI with Access 2002
SQL query
Working with a .exe file
SystemModal and ApplicationModal Message Boxes
Make Table Query
Me
How to Set Decimal Places in Format
Math Quiz Program with Random Numbers
Compact/Repair and Backup BE Database... Help!
How to refresh a project?
Free Phone Calling From UR PC N Much More!!!
create email from access query
acCmd constant values and purpose
transferspreadsheet
How do I make beinning amount b same as ending from month b4
scroll wheel
subform update?
Automated Importing from Excel
MouseWheelOnOff in access 2003
.mda files do not appear in add-in manager "Add" form
State code
Is there a VB Parameter Function?
Putting records filtered on a form into a report.
Parsing text
How to Find Data in Part of Cell
Formula I cant figure out
Error Msg: Cannot Delete Spreadsheet Cells
Problem with modifying Excel worksheet from Access
DSN-less connection to an Informix Database
Returning a value based on another value
SQL statements
Print dialog box with Page Range selection option with VBA?
DSum Function
How to Extract Part Of field Based on Criteria
Unknown Jet Error - Date Function
how to stop a loop and run code
RE: Calling a sub procedure
Calling a sub procedure
Change Cursor Location
Import Specifications
Query timer
How to run a Query at specific hour??
vba cant find procedure from ArcGis
SQL query .execute delete (almost there!)
SELECT string as Recordsource
Totals Row in datasheet view in Access 2007
conversion & 3420 error
VBA Startup Code
How do I change a sequential control number for my database in acc
Code to set a variable to the RecordSource of a report
Duplicate record numbers....
RE: iSeries Navigator
automatically relinking tables from external database
Firing Up Excel from within Access
building a text string with null fields
Query : Call a Function
I need to export to xml 1 record at a time
Collections and Class Hierarchies
Sending HTML thru SendObject
Time Zone change
Code to list names of subreports included in a report
importing fields from 1 DB to another DB
How to programaticly change the display font size for tables
Random numbers and division
Duane Hookum's Recurring DB example
Open a PDF file
Student rating
Copy a table into a new blank db
CreateQueryDef
Extracting first 1 or 2 nymbers
How to go on record
Check status db.Properties
Enter password to enable command buttons
Export to XL code works in Access 2003 but not 2000
Need syntax mod for this command...
Excel Automation - Copying Range of Cells
Sequential Number
Excel VBA
Using recordset from a query
Store AutoID after programmatically adding new record
List files recursively
Calculated Fields
Add a record to an SQL Table
Email Report as an Attachment
VBA Schema Changes
Editing Existing records
Indicator
Find defination of Variables
Entering incremental value into text box
problems downloading activex control with user account access
Error with RecordSet Coding
Updating Query through VBA
Treenodes clear
Outstanding Stock Weighted Average
Enable Sticky Keys
Excel Worksheet Not Being Saved
Filesearch object
Variable References via vba based on Access version
FindFirst Criteria Problem
Use Access 97 Linked Table Manager instead.
do loop with if then Access 2002
Run-time error Method 'Open of Object' _Recordset' failed
Exporting Report to Excel
ADOBD recordset on Informix database - values always divided by 10
Exporting certain columns from a query to Excel
Run-time error
Tab Control
Problem Embedding Image Links
is [] needed?
Passing Looking Up Filters from Form to Report
Message boxes
Code to add index when making linked table
Form vs Subform
Please help...how a field automatically update every year....?
loony looping of Report events
DLL error doing AES encryption
Transfering Data from a subform to a parent form
list of properties for objects in class MSGraph.chart.8
ACC 2000: VBA Import Text Files into Memo field
Suppress Navigation Pane Through Code
How can I find the definition
Toggling a List Box
help witj date
lock multiple records
Hide or dump recently used file list
Can I DoCmd.OpenQuery on a Parameter Query?
Removing characters from a string?
Attachments.Add DisplayName property?
A hairbrained idea
Programmatically importing tables
Recordsets, indexes, and null values
Make Main Menu remain same size every time
Adding a <Tab> button press
Converting Multi-Record to Flat Table
Write a report to Microsoft Office Document Image Writer using VBA
Updatiung Secured Back-end in code from Front-end in Runtime environment (A97)
Sorting Excel Spreadsheet
examine every character with a field
Access 2000 MDE issue
convert string to date
How can a specific field automatically change every year?
optain a list available forms
On Error Goto....
On Error Goto....
Set focus on newly opened MDB/MDE
late binding to Access 2007
Update all fields from 1 table to another table
Open message form before main form
Dynamically loop through all properties of a class module
current record in new table Access 2007
cdo SMTP errors in Vista -- (worked) in XP
everyone,Converting Numbers into Words
Converting Numbers to Words
Create a global search box
Word connectivity
Word connectivity (continued)
Err numbers - new programmer question
Resizing controls when resizing the form window
Graphs Y Axis
Word connectivity (continued) again
How to tell whether FindRecord has found anything
Running function everyday automatically
commandbars and reference problem
Help with Split Function Array
run module problem
Set a SQL Result as Variable
How to refer to a a specific cell in Excel
Another date question, please advise!
OpenRecordset not recognising .FindFirst
Store Word document in access database automatically
Error sending emails from Access through Outlook...
Need help on Automation Object
Run a Winzip self extracting file
FileSystemObject drive error
If Statement
Search Form
Problem with VBA created subform in Access 2007
Bound Object Frame
Parse XML VBA
Attached a DLL
Explorer window - find xls - path etc becomes part of programme
access default database folder for all users
1,000,000 FR.EE VISITORS ON YOUR SITE! -
Access 2000: Microsoft Office Document Imaging Automation - Merge
Can a macro call a Sub?
How do you open MS Outlooks inbox??
How to add a record using DAO in an Access Project
ADO - Opening a recordset
open a calender with vbscript
Printing a selected record in 1 form in another form
Recordset / Query Problem
Combining Data
Oracle dates in ADO
Validation Rules and Validation Expressions
Warning message DB is about to close...
SQL query
SQL query
Run form hidden without a macro
Force Users Out of MDE
Dynamic Function Calls
LDB locked open on a BE
How to link dbase table
Parameter Question
MS Access 2003 -print report to file? mdi/tif
Access Project - Filtering
help with syntax
If not on list
Change the back color on a listbox selected item
Error 3343, 3011
How do I set acformview to datasheet in VB docmd.openform in acce.
Invalid SQL in VBA
SQL Question
Could MS give us a tool to trash disconnected ldb files?
Using a DLL
clearing variables after a section
No negative numbers
Error Handling Technique ?
Modify records and create a calculated field and add those records to a table
Upgrading to Access2007 and Vista
Reference to form object
Retrieve fields with FOR statement
Filter Combo Box, how?
How to see the update in a subform (requery)
Code for formula vs manual entry
Time out the DB gracefully
findfirst question
ODBC Driver for Sybase Database
I want to link Peachtree Accounting micosoft Access
Place a calculated value from a form to a table
2 VBA questions - how display data from dynamically built(sql) que
Copying a field to the next available blank field on another form?
How to move records from linked tables to native table automatically
How to Copy from Excel Into Database with Pkey
Minimize Excel
Best practice when multiple AutoExec's needed
Call the standard Windows File Open/Save dialog box
code entry as a date
Delay code execution
sqloledb date error on bound form
Programmatically refresh links to MS Access tables (DAO)
Range Validator
Opps!
Re: make table with vba adding records times quantity column
Create a table from the chosen variables in list box
DMAX in multi-user environment
I'm Too Stupid, Please Help!!!
RE: Help to update a value in an SQL 2000 table from Access code
Form Wizzards to call word and excel templates
RE: Change a linked table to a local table (External)
Round values up and down
Outlook's Calender as Interface to Access Meeting Table
Access Sql Server application
RE: Closing Excel from Access
Parameter Problem in Code
RE: charts in access
Search Button
selecting CurrentRecord in a subform
Access Source Control
Very first event to fire
RE: hiding the contents of a field or white text, while still having f
Programming or Macro to hit Ok on Warning Message Box
RE: Not enough memory to perform this operation
RE: Maximize Form -- Ultimate
RE: Format Excel from Access
Error in form Load
Date Problem
charts in access
Access Source Control -> 2007
variable field name in sql string
Looping through records
Contacts on Exchange Server
RE: Change a linked table to a local table (External)
Invalid Contact Name when using RTF
Closing Excel from Access
Inserting OLE object through ADO
VBA Copyrecordset to Excel
RE: LogOn- auto LogOff
altering data contingent on another field
Not enough memory to perform this operation
RE: Change a linked table to a local table (External)
RE: How old is this machine? (date question)
Time and date specs in SQL
Direct to serial or parallell port?
Help to update a value in an SQL 2000 table from Access code
RE: Accessing Outlook mails via Access
Select an output tray for an access report using VBA
Require assistance with code
Maximize Form -- Ultimate
How old is this machine? (date question)
hiding the contents of a field or white text, while still having f
Access 2000 - ODBC connection
Accessing Outlook mails via Access
How create a executable progam in access.
Relationships not Imported
How to turn cursor on or off?
Change a linked table to a local table (External)
change return address in vba to outlook
Send an SMS from access
getting emails through an access front end
Random 11 digit alphanumeric number?
how can i protect my database from DELETION
Select record on form and update table
Compare and append
Automate Error Handling Insertion
How to store ID into the table...?
How do i store ID into the table?
How do i store ID into the table?
Cannot find a linked table
Cannot open any more databases (3048)
How do I set up or validate cardinalities, such as (0,5), in MS A.
Re: Compile Error - Expected Function or variable
Reports as PDFs
Closing Excel Reference
Maniplate Emails from Ms Outlook and show it on the Access
Suppress the Write Conflict Dialog Box
ACCESS Routine to Timeout
Volunteer schedule & database
VBA Code to auto perform append/delete queries (no user input)
Trapping for Last record on Cont. Form, I'm getting desperate...
Detecting if another form is open.
how to enter words in a text box and count the number of spaces
Determining if numbers are part of a string
Data List
Open Clip Gallery from vba
Filters in Access Projects
VBA access and Vista
Email a report Error!
How do I use the acCmdReplace command in code
How do I export data to an existing Excel File?
Macros Won't Run
Creating fields in a new table.
SQL Woes
Auto Close FE When No Network Connection
Expression fails when value is "Empty"
Late binding code for creating a command bar object
Copy records from same table if it meets a criteria
Run Code on one subform from another subform
Help Pleaes. Debug problem in MS Access 2003
How to get Windows Login "Display Name" instead of "username" in V
Importing new records to a table
Problems with Automating range of sum for Subtotal method in excel after access export
Display Records on form
Functions, sub's and private sub's...
ADO overwriting locked record problem
Code to loop through records
Recordset.addnew and Linked Oracle table
Printing various pages with a button asigned to a macro
After entering text in a text box how do i count the number of spa
Run Code in parent form from subform
Changing column format in an excisting table From text to Hyperlin
Demo Solution
No Value Given for one or more required parameters
Using "SendObject" with AOL
Send 900 Billion valid Emails in Just 5 Minutes Only!
Runtime error 2185
filtering a sub report
Scanning a document
Computer Job Available!
Update Database
Modify BE tables
Enums. What are they and Why use them
Color Rating Fields
update record
One parameter, multiple reports
backing up a database
Email report error in access 2002
filter recordset by > 1 field in vbcode
Adjust graph background color
Need some help with working on data
SQL Server migration?
Error on ADO RecordSet.Open
Totalling
Problem with my code...for each loop
Keeping currentQuantity up to date
error 3170 could not find installable ISAM
Selecting a column
Issue with DLOOKUP coding
Issue with coding
Need help with this
Access.Lockfile.9 in a multi-user environment.
Getting username from active directory
Upload files through an Access form?
Totalling a field based on results of fields from a query
Broken References question
Can an Access database I develop be used by somone without Access?
Can't delete a record with this slightly modified code: Access 03
Help with Building An Expression
Mailing Labels
Inserting a New Column into a Table using a Macro or VBA
Can't run Batch file
force a sequence of events
Automatic load of 1-2 data fields from one table to several others
Help w/ static variable in a query
Running an Excel macro from Access
Renaming Access table
news
news
Query a sql server directly
SQL Syntax - Parsing code Vs VBA
What would be quicker, Dlookup or using DAO
Outputting addresses Query to google maps in sequential order?
amara20102005@yahoo.com
VBA code to open 1 table with the client id from another table
last record for each date
Running a .JAR file from within VBA
closing a Word Document in Access
User Account Info
ISAM Error 3170
outputTO command error in Access2007
Unbound Txt Boxes
diffrences between versions
Dynamic hyperlinks including field value?
Bakery: relationship hierarchy for recipe
Updating data
Reuse code
VBA to extract user password expiration dates
Simple math not working ...
Need help with vba from MSAccess to open a visio file
Createtabledef problem
access Database Programming Problem
VBA command similar to COBAL Inspect
Passing data from one form to another
Working with attachments
Determining if a File is Open
Determining if a File is Open
Managing attachments - VBA
Hiding "text select" cursor OnEnter Text Box
Shout-out to Daniel
Re: Spammed by Fax?? Read inside
DMax Question
Need help with macro to compress and copy DB to FTP
Limit Report
generate list of database objects
2007 producing a 1004 error
Dim mydb as Database
Public function that will increment a number in a query
Running record for how many times a form is used
Dev_Setup
Public vs. private variables
yjfykjfytyy
can't past webpage
Attempting to create a function that i can use in a query.
Access 2007 Check for linked table availability
Help with ReportToPDF converter code
Data base will not install
text file not created while running a batch file through access
return Charcode from String
Multi-select list boxes in a parameter query
BrowseForFolder questions
VB Loop Help
CreateQueryDef
Export to Excel 2003, 2007
Disable Backend
Executing make-table queries with VBA
export all modules to txt files
ADO connection string for Access 97
Problem with DoCmd.SendObject
Verify variable is not null
Runtime error #2448 Cannot assign value to this control
Using variables in Access 2000
Save a snapshot of report using automatically using control name
Issue on calling Sybase Store procedure in MS Access VBA
How to make a simple database for using in computers lab
Read and change OLE links
weighted average calculation
Simply viewing a file
Include variable in contol reference
Stripping off char from string
Calling a web service from access
change bypass key
What about Access 2007 Runtime
Forms Class Inheritance in Access 2007
Calculate work days
add a linked record from a form
Parsing Text (Instr)
Loading Data on a subform based on Combo Box value
Posssible Corruption?
break word in reports
Test for prior use?
(ODBC) Connection Drop Handling
Intermittant Access Code Compiler Problem
DDL for INSERT/UPDATE with Decimal Formatting
Null in Insert Statement
Dlookup and update not working correctly
Tracking time
Query in Sending Automated Forms
Sorting a table with VBA for WORD
Using Name command in Access 2000
Concatenate & transfer data by command button in VBA
Code assistance
SHELL syntax?
Automate field
Select record using VBA in datasheet view
linking to tab delineated text file
Form Options!
Go To Current Date
Access-muddled SQL runs but won't save.
Opening DB after check with excel
PDF signatures
Connecting combo boxes
finding code examples listed by menu options
VBA Code To Determine Read Only Status
Open Excel, refresh query, and format Excel spreadsheet
Crash course in XML.
Too few parameters. Expected 1.
Trying to open one database from another
Creating Data dictionary table
Totaling field
Setting AllowFormView at runtime
MS Chart in Access
Any technique to incrementally saving as code is developed?
Goal Seek
Close Access, or Timer/Timer Event Help
How do I hide a column in a table using VB code.
Returning Multiple Records (Need Advanced Guru Help)
How to resize a textbox and form
Open Word document if exist, otherwise create one
Continuous forms in Access 2000
Settings Startup Properties for Access Application
Only allowing incremented data
Change connection string in Access project
determining newly created twin tables following import of xml data
utilizing an ActiveX Rich Text box in Access97
Bookmark Blues
Splitting text
Transactions failing in Loop
Where to find a Professional forum
Writing login cookies
Passing excel objects to subroutines as parameters
calculating time periods
Can't find a form's code module?
Detached Event Procedures
Detached Event Procedures
docmd.openform
Help with error message
Public Function DoCmd Runtime Error 2486
about Docmd.Runsql
ROUND won't !