Microsoft Access VBA Modules

Setting up credit notes
'User-defined type not defined' Error
can't open recordset
Disable Shift Open Feature
programatic field reference
Help with Multiselect List Box
Access the Control Source of txtBox by variable?
Stop Query
data type conversion when automating excel from access
i canot open excel or word file by cliking directly on the file
Days360 routine
How to go to a specific record within continuous forms
HELP with an INSERT INTO statement
Stop macro when time is <xx:xx
Problem getting dependency information from a query using VBA
Syntax Error From Clause
Browse Folder - Independent Mod
SQL Scalar Valued function in VBA for a Access Project (ADP)
Copy query, paste into Excel as data with VBA..
Incorrect values written during an update
Mail Merge Problem
Calling Form from Report
Visibility in a command button
Run query on table exit
Parsing Dates at Import
why this strange calc error in vba
>> dao connect with password
Delete a table at certain time
Problem with Rollback in DAO 3.6
Populate word document
between
Date Difference networkdays not accepted in Access.
Format text
write permission for linked tables
unique record identifier
Deleting records before import
What's wrong with this codes?
Composite Key and Input
Requesting Parameter Value on Update Query
Problem with mail merge
Problem with mail merge
Replacing a character in a string with another character
DoCmd.OpenReport WHERE clause syntax
Table Collection
Action buttons
Disconnect users
mail merge access rights
Code not working.
Code behind objects or in separate VBA modules
ANY SUGGESTIONS....List box problems
Please help with my code
Access
DoCmd.TransferDatabase for Text CSV Files
Find Outllok Contact EntryID
I am getting an error when I try to Exit Access from VB
Update rows Printed column to current date/time upon report print
Current Window=False not work in FollowHyperLink
How to go back to first record in recordset
Interger for constant acFormatXLS
I have an update query that links to a mdb table. I am not sure ho
Send appointment from Access to someone else's Outlook 2003 calend
Allen Browne Function SetFieldDescription passing field description
"Wrong number of arguments ..."
pemberitahuan masalah
from Access, via Word to Outlook as attachment
sql query help
Using a loop to concantenate strProjectManger from multiple record
Printing a report with additional blank pages
Seperate Filename from Location
Creating a search box
What if invalid email address?
Do not send email if no attachment
Determining the next Alpha Sequence letter for recordid
How to Send Email With Attachment From Access Form
help with loop end of file
Where to find access programming tutorials?
References in VBA in Runtime distribution to non-Access machine fa
How to build a drop down list of past entries
Save Each Record from a Query As An Individual Word File
error handler question
Opening a form cause Access to quit unexpectedly
screen resolution
Connection and Create New Table
Access 2003 automation Outlook
Access Transaction Rollback problem
Checking record status
VB6.olb (Visual Basic Objects and Procedures)
Running a count query from VBA.
Setting 1 obj = another obj where each obj names change
compact database in 2007
Problem calling dll function with Visual Basic
Sort then Seek a Recordset (ADO)?
Reports come up 'zoomed down'...
selecting values of a list box from an input text string
Northwind Sample DB
Requery subform data
VBA Access - Outlook
dlookup using a date defiined by another dlookup
Merge data in fields
Loading field desc with data from another table
Updating text objects on the form that opened the current form
VBA table properties
Copying backend database
change the backcolor of a subform details section
Dlookup inside a dsum
Refresh subform records
Reading Data via RS232
combobox of color pallet
Set MyValue
Save Image
Mid range
bound form with unbound fields needing updating to the same record
Dropping ODBC Table
Invoking Spellcheck From Within Access for Just One Textbox
Domain Aggregate Functions
syntax Error or Access Violation
Copy Object Table with Primary Key
Break Point without setting one
Writing to Excel Programmatically
Add Recipient to Existing Meeting Request
Problem with date range for single day
xlAutoOpen failure
Re: Google Conspiracy Revealed!
Re: Google Conspiracy Revealed!
Re: Google Conspiracy Revealed!
Code to delete querydef's
Changing Column Size Through ALTER TABLE SQL Statement
Determine if .ldb file exist
Question on Inputbox function
Open the Database w/o the startup form via VB.NET
Bulk Create Records and Append to Table
working with schemas
Auditing a subform
Get File Name
Exporting data to Excel and formatting using VB
Where
Automatic emails
How do you display the first record in combox from query?
openquery command
loop in error handler printer exception 2
MailMerge OpenDataSource
netted BOMs query
Create search form with multiple fields
help on inner loop 2nd request
Set library reference from VBA code
export to excel from access
Disconnect - Please help!
Deleting created tables
me.dirty?
Error 3061: Too few parameters...
aggregate functions for TEXT data
Email Subject Line
Coding assistance is not showing up
Coding assistance is not showing up
Outlook Mailbox size from Access VBA
Appointment table
How do I read delete and write records in Access modules?
How can I change Table Attribute programmatically
Getting At the Recordset Data
Execute Access Macro from Excel?
Compress Access .mdb from Excel?
Moving database to network
FindFirst Not Working
Error 3075
Load powerpointpresentation on to ms access form
Refresh/Requery/AhowAllRecords
mimize button
Access Runtime Solutions
deleting a table in an other database
Import Exel and Add Time Stamp
Help changing FoxPro to VB Code
Remove Dash
Concatenating & trim contents of 2 textboxes and write in another
File Spec Question
Where I can find structions to use queries in mdb accessed JDBC?
Function for Numbering Table
Access looking to active directory for user login info , need to d
Can I distribute "MSO.DLL" library with my database?
Table locked by a person or process
UPDATE question
Time Calculation thought process
unc not supported
how i can add field to table programatically
code to load picture in OLEobject field?
using Access database on 64 bit server
Event to monitor for using changing record in form
Time Zone Calculation?
Multiselect listbox as criteria
Message Box
code lists
list of codes
Table Update ODBC
Attachments
Need to Export All Code - Not Data
How do you display the values of a recordset in a message?
Adding Info to a Report
Start A timer that runs untill a form is closed.
Add two fields of a table together.
Updating MDE
Button wizard
A tricky one with recently viewed records?
Toolbar action repeats
Creating a logonname automatically
Creating a logonname automatically
Creating a logonname automatically
transfer button from one list box to another
updating a field after counting occurances
Parameterised SQL Select Query and Forms
Delete query maximum values
Group Query results in VBA
"Bold" text field on a report
Create a report using VBA
Export to Excel
Schedule to run a Function not using AutoExec
Runcommand error - command not available
Exporting 100 + Queries to Excel
Biggest worldwide Asian free Video multi language web , Travel, Sports, Racing cars , Massages techniques, Games , Fashions, Jokes , Top models , Free online IT learning , 5000 links, 250 free online TV , 50000 music video, nice landscapes , H
Syntax of quotes?
Refer to the first row of the table
Can't Edit Table Through My Form
RE: Update query with currency
How to Reverence a variable then add value to it
Update query with currency
RE: Multi user database
RE: Object button
Form Losing text object values when using Timer Event
How can i call a MS Access2003 Report from MS SQL 2000 TSQL
Multi user database
Creating button to prompt custom filter window
PLEASE HELP WITH LOG IN FEATURE
Object button
RE: Changing Access Options by Code
RE: Reserved error -1517 in fields
Error Handling vs Error Code 2113
Labelling a new record in subform
Reserved error -1517 in fields
RE: Function Name is Variable
Changing Access Options by Code
Function Name is Variable
Changing Access Options by Code
Complex Ranking Function Needed. PLEASE HELP! THX!
update table field from unbound form control
MS Access 2000 VB HELP!
Students Fees Program
save webdata to text file
delete " from a .csv file
Assemble strings into a message
Status Bar Text
Start Spell Check From Within Access
Calling a result from another sub procedure
Urgent Help is Needed Please
Access Database Search Utility
DoEvents pitfalls
Barcode Input
Undo command
Help needed
Paste into body of Access generated email
Searching a table for Country Names
Runtime error 2467
change file location
MSHFlexgrid mouse wheel
RE: Worksheet exists in Excel
How can I copy 10 worksheets from a single workbook to a single ac
Automate append
OutputTo command
Replication problem
Article ID : 160870
Programmatically turn on and off the OnTimer Event
default value for class module
Input parameter in OnOpen event
Making Variable Names with Variables
does recordset.recordcount work on a command?
Referring to form contents in RowSource
looping through recordset using maybe index for recrods?
help with a VBA
"select case"
Trimming leading spaces from fields
Menus for Outlook 2003
"select case"
Can't open new Access DB accdb from my code
How can I know in which line of code generating runtime error?
String with comma delimited values to array
Optional Function Variables
force logon window
Global Recordset ?
ODBC driver for Access 2007
Cannot open XLSX file from an ASP.NET using OLEDB
Linking Modules
Creating Multiple Recipients
Access Navigation Pane VBA access
Usage of DLAST
Run-time error with ADODB
Do Until Loop Suggestions
Delete record
Copy and Paste Byte by Byte
Urgent VBA help
Access Table to Excel not overwriting existing sheet in Excel.
Loop to export report and email to each person
OutputTo Command, include subreports
MS Access Macro error on TransferText
Obtaining Server File Name
DoCmd OpenForm parameters
How do I get the number of a date.....
Access
"select case"
Using notinlist event to open form pass values
Simple function giging me a syntax error, please help!
Cannot Open Database error
How to stop the dialog box from showing up when running append que
Skipping records in a report using code
List Box Format of Phone Number
ASSIGNING FIELD VALUES VBA
Another time calculation issue, thanks for any help!
How do you reference a control on a parent form from a subform?
Can You lock a checkbox control per record
Add Records in VBA
autosize
display warning message
Copying a column from one table into a subform with a button-click
"enter parameter value" issue
Can't update fields on continuous form...
Parse Date from Text
Problem with an update function
Auto Backup BE
Creating a logonname part 3
Access
Application.Quit / DoCmd.Quit Fails
ADOX.Catalog
Compact via VBA in Access 2007
How to populate a list box based on user input?
Emailing with multiple attachments.
Customized Autonumbering
Can someone point me to SOAP 'how-to'.
Build a string with a tables emelemts (via recordset)
problems with dates in VBA
scedule an access marco to run
Export to set Cells on a Excel Template
Code writes to subsequent record instead of current record
Cross-post: Updating pivot form programmatically
Unique problem with unique fields
Module Question
3075 Error Report when trying to add a search for words in a comm
Open Form and wait for Selection Before Contuning with Code
use list box for query filter
How do you call the same Sub in 2 different forms
mouse wheel scrolling
byRef arrgument mismatch
Email an Excel Attachment from Access
Test for zero records returned from Query????
How do I prevent entry of duplicate student names
Sorting in a query
VB help to make queries
Edit Body Text in Outlook
Corrupted 97 Database
time diffrence
VBA/SQL Help Needed On Union Query
export each Inv number to excel sheet
Update Union Query
Option Group and If Statement
Auto Open Form
Creating an Excel file in vba but saving in a .xls format not .xls
Count
Run query after another closes
date/time changes with mouse movement
Field value "904235-2" updates as subtraction! Errr!!
Median Calculation in Access Reports
Handling speed in Access
Quote marks for Numeric vs. Text??? (data type conversion error)
Access application on close event
After Update Field Populate Another Field
too few paramaters in my INSERT INTO
Formatting an Excel column as a hyperlink
Check for valid date on input box
Creating multiple spreadsheets from form in access.
a form as front-end to a table of execution parameters
Browse a List of Directories
find and replace in a .csv from Access
AXS2000: Create ADO connection to external database
Dlast Won't Update
Function from SQL to VBA Module in Access
Need a msgbox when text box is empty
Launch Acrobat maximized
Populating a combo box
Finding Tables
HELP: How to pass linkcriteria to a continuous form?
access import method
Link table via ODBC with VBA Code
backcolor on one record's field in continuous form
lookup field from linked table
Get posted records
how to rename a form?
How to disable editing menu's and toolbars with vba
Exporting multiple textfiles from 1 table based upon certain field
Adding a "Header" and "Footer" to recordset
Mail Merge from database with user level security
Insert (Append) text into a memo field
Get Run-time error 29068 whith DoCmd.Save acReport
Disabling "Compact on Close" During Testing
Copying an auto number field from one table to a text field in ano
Merge with word
Compile Error
FollowHyperlink Method
Sending reports to email recipients
to view pdf files using OLE
Delete Record Code
unbound subform and record set
If IsOpened
Compacting Access 97 databases using code
Duplicate record problem on using AddNew method for adding data.
Recordsets and updating fields
Visual Basic 2005 and MS Access
Compile error
Treeview Sample database from Doug Hoed's article
Exporting Table Automatically to Another Database
Changing/adding Header within a Datasheet view
Changing/Adding Headers within a Datasheet view
Refer to Variable in strSQL
access open excel file
Opening new form with certain criteria and passing data.
Programatically add new sequenced records
can't use a control selected from More Controls
problem with DetectExcel
problem in access with open excel file
Access to Excel Automation : problem with Category X Axis
Programmatically creating email (hyperlink) - BUG?
Help getting Sample database for Doug Den Hoed's article 'Taming the Treeview Control'
SQL String
Locking & Unlocking Records
SendKeys in Access2003 and Vista
Email from Access
File Not Found error
Schedule macro
Default field type in ODBC passthru query
In Access what code would remove brackets/dashes in fax field
Is my table ready?
Importing a Spreadsheet with VBA
How to create an automatic email for when something is due
Access shows duplicates in linked SQL View
Does Access 2007 support coding multi-threaded processes?
no dups
Programmatically creating email, checking if exists
wha does this code crash access ?
2000 Fails On 2007
email from a form by clicking on a command button...
Can we filter data in 2 steps?
Queris/Macro automatically running in a hourly basis
Relationships and Split Databases
Handling Excel files
Exporting data to multiple textfiles
API Window management
Problems with subform late binding
From a module copy a form & toolbar from another database
Hyperlink and Email
AddNew method problem. pls help.
No longer able to call specific Outlook Profile - prompt interfere
delete operation in Oracle
Need function to determine if OS is Vista
Cannot delete/remove Access Module
Trouble with SendObject Command @ runtime
Need help opening ADO recordset.
Tools/Options
Problem with an exportscheme
export to Excel
Compile all modules
Checking All Recoords
Selecting based on several values
Set from field in email sent from Access
Manipulating Word Range from Excel
Setting Focus on a subform object and using .SelStart
Updating a recordset from form
Application Level Close Event
COmpacting database in 2002 vs. 2000
Can someone decipher this code for me
Printing a report
Tab control question
Access 2000 ADO Recordset from Stored Procedure
Join - Update - Append - Tables
hide a form
Using Parameters.Refresh From Excel with Jet Returns Count = 0
Deleting tables in VBA
Putting Query into SQL
App Fails On 2007
run code on backend from frontend
No current record error 3021
How can I check sequencing in a number column in Access?
Making Access setting through VB / VBA
VB Error 2001 on DCount function (MS Access)
CommandButton Click Event not firing
dcount problem
Do TEMP tables in Stored Procedures not work with ADO Recordsets?
How do i compare...?
Sending email from Access using recipient name from text box??
Adding cc, Subject and body to access generated email
Setting the Value for a field
RefreshAll Command
Copy from listbox to listbox
Way to have the database send an email based on a date automatical
Error msg
Checking for existing contacts in a ADP
Using a SQL Stored Procedure in Access
VBA Error #429: ActiveX component can't create object
for each...
Fill in weeks worth of dates from Mondays date
Access project references
Search Key Not Found In Any Record
Very High processor usage for this code.
App Fails From Missing Reference
Add a Default value to a From text Box
Unable to find Reference to Microsoft Excel 11 Object Library
Query update fails
Error Trapping
Linking Outlook Contacts with Notes Field Included
Resize Images
nesting a function with query select
Missind dates in access
Re: Business
What's wrong with this code for Repeat Records in Report?
How do I manually re-order a field list - It's a Tough one...
MultiUser Issues with Access2002 - Errors 3343, Invalid SQL,214721
Just Testing
Access Form Requery
Edit border line of workbook from Access
How to close SQL Server connection created by CDaoTableDef
IF Statement should detrmne which recrds to make visible but not w
something with "IF"
Killing a non-responsive task
filtering record strings
Setting page margins on print
Number of columns in an array
Using combo box to select check box in frame
Output Query Problem
Access and Frontpage
IIF Statements in update query
Variant vs Object variable type
Converting a union query in a make table query
Access Message Box
Variable File names
Albert D. Kallal windows script for automation of access
can't close Excel
Access Forms Help
replacing primary key error alert
how to open a Outlook calendar appointment of a specific day
Updating a Linked Table
Email From:
Close a report after printing
Why Re-Link causes Corruption
Receiving Error 3215 on TransferText
Sorting listbox contents
Open Excel from access - Compile Error
VBA codes don't work...
Transfer multiple sheets into 1 table
Export query result to Excel fails each week
Setting a value in a field in a subform to 'Reject' from an event
List functions in modules with comments
Question on building a query
Cannot open ADO connection to Access 2007 accdb
using vba to get Novell Netware Info
Fonts in Access Tables
VBA and DLL written in VB 2005
Open Password protected Excel from Access
CDO.Message Dont Send If No Attachment
more help with programming!
Copy from list to list
Open documents
Security Help - Desparate!!!
problem in Access 2000 with forms
Determine if an Office application is installed
record count
count null record in filed with DAO
Sending emails via OutLook with VBA and ConvertReportToPDF (Lebans
using a function w/table field to enter default in another field
Go to a record in a subform
Error 3001 in Data Access Page
COULD YOU EXPLAIN THE SWITCHBOARD AND ITS FUNCTION
Syntax for emailing one worksheet
Update event for a Combo box - not a biggie
On Open event does not fire when doing DoCmd.OpenReport in normal
Link Tables using Alter Table command
Looping function
Dynamically referencing a recordset?
Testing for Open Form
Inet Object for FTP Uploads
vba coding a browser activeX control
Retaining an Access programmer, issues, pitfalls to avoid?
Need to add revised records as new...
Update Recordset with VBA
how do I set up a correspondence record
Using Access to send a .pub document as an email
Subform not working within single form
Method or Data Member Not Found
Error 3073 with TransferText
access Importing
Multiple access databases
add function results to the table field using a form
Updating Field value from Field with same name
Sending Emails through Access
Email address validation
A Spy on MS Access - Please Help
Select Query and Loop or Inert Query?
vba date output
Summation query
Executing an OpenForm with a variable not working
using a database thorough a touch screen monitor
Access Form
Package Wizard
Stepping through Recordset on Timer Interval
Control forms in other ms access programs
Access and Sharepoint 2007
merging csv files
Watch Free Satellite TV On Your PC
intersecting times
Open Excel from Access
VBA event definitions
DCount on a recordset?
Help Dmax
Importing Table from ODBC
Import Field Description
Watch Satellite TV On Your PC
Using field as criteria for Query
invalid outside procedure when creating a rs
access importing files with pathnames
Why Can't code /event procedure see a renamed field?
error trap
instr
Code bombs if I update it to reflect field name changes.
neither beforeupdate nor afterupdate clear and keep focus on textb
Give user ability to copy last record?
Error 3211 delete table with multi-valued lookup field
Multiple Timers
Code for inserting rows from a stored procedure into a Access Table
Auto DateAdd
Dynamically create master report referencing pre-built subreports
Problem with Opening Form for Additional Data
Array of Form controls
ADO or DAO
reveal sequential records for each time the button is pushed
VBA Errors
Is a form open?
registry vs Run time Options
performance issue in form
Create access profile
Showing Query Results from VBA SQL Query
issue with runing Select query with condition using code
Round up or down in .5 increments
too few parameters. Expected 1
Report flowing on two pages....
Time() returns a null
Access 2000 / Outlook 2007
select case with dual criterias
Selective colored text in listbox
Dlookup function criteria w/wo single quotes
IMMEDIATE WINDOW
Syntax error in date in query expression '##'
Wierd behavior while inserting a record...
Subforms in Access 2000
Find a record by numbers and letters
Can't tick library reference for MSCOMCT2.OCX
NEED A LOAN
Why is this query so slow
Toolbar Errors
Back up Tables
Changing Combobox to text box
check box on subform
Controlling Table Values...
fs.FileExists: Inconsistent Answer
Using SQL or query to insert unbound data
Counting Help Pretty Please!
Looking for Active Directory Global Groups a User is member of
DoCmd.RunSQL
Programmatically accessing combo box values
Import Huge Text File
Access 2000 crash in Vista
Create report between two dates.
Is there a function that converts string to number ?
Application.Printers 100% CPU
Programmatically accessing the diagram pane of the Query Design view
Hide-Show Quick Bar
using FindFirst
DoCmd.SetWarnings Problem
Play mp3 with Access
Play mp3 with Access
Play mp3 with Access
filter to textbox (multiple)
Two related questions about programatically copying mdb and mdws
Combo Box Display Missing After Office 2003 Service Pack 3
Loop through Table records
Unknown error
Create Table
Chart Presentation in VBA
Combining Fields From 2 Tables To Sort Data
get current object name
Where I coulf find MSMapi32.ocx?
Looping through records
Automate PDF without prompt to save
Switching MS Access 2007 to use Overlapping or Tabbed Document in
Off03Sp3 WinXP Application.Printers Spoolsv.exe CPU 100%
Exporting from From Issue
qdf Object Variable Error 91 problem
Access 2003
Access 2003 & Vista
search folders/open files
Rounding down to .00 .25 .50 .75
How can I determine if a Table exists.
searching for corrupted data
Open Append text tile .txt
ADO Recordset
Display bound picture in a one-page-per-record form. Newbie questi
Pull a value from a table
Suppress "Enter Parameter Value" Msgbox
Creating table entries with Listbox on Form
A2007 Messes Up Dialog
Excel copyfromrecordset fails with large DAO recordset
can you send two objects in one email using the sendobject
Updating Controls in a loop
Is this a good reason for a front end table
using file command in main toolbar
DblClick is a non-event
Excel Format Freeze Panes with Access VBA
Textbox data in VBA
Use VBA to Delete Forms/Reports on another Database file
Tab control Changes
mixed cases words help required!
Unbound Control - Intermittant failure
Windows Installer message
searching text dao, array?
At runtime - changing the data control source of a textbox in a re
Connection to Linked ODBC Tables
! Clear Text Boxes
Change color in rtf memo control
Adding a record to a subform
list box problems
Export SQL stored procedure to Excel file
Email addresses in code
Dlookup
On Enter event
Dialog Problem
dynamically display label and checkbox
MS GRAPH 12.0 html hel pfile
Problem with my code, any ideas?
how i build a database it can comunicate with a check reader
Mail merge multiple records to word multiple tables
Procedure name as variable
Need procedure to replace a character in a string
Distributing an Access 2007 Database
Open a Tabbed Control to a specific page
invisible subreport header
Hu
Unzipping FIles - Help Please
writing messages on event Viewer
Update query