Microsoft Access VBA Modules [Archive]

Attachments vs. Linking in 2007 and 2010
random assignment
3008 error by using memo format
Message from Access 2007 on sub function
Sorting on Calculated Field in Reports
acquisition image from scanner machine then automation save imagespecepic folder
JOBBOSS - User-defined Reports
Access 2003 versus Access 2007 Excel Import
Re: Replace, but ignore certain characters
Pull a random number more often
Inserting attachment, as opposed to attaching with VBA Module
Sending email to a distribution list specified in Outlook
How to change Pivot Table external data source (MS Access Database)by VBA
relate tables - please help
How to pass a form event parameter to a function without using [Event Procedure]?
Import mutiple name text files into Access 2003
Import Text File Into Access
Shortcuts for VBA procedures in Modules of MS Access
Access VBA for Page Setup in Excel
Create a Table with Multiple Values Listbox
Why Does My Button Code Copy To "General" Object Window From "[My Button Name]" Objec
Up For Reviewing Complex-ish Button Automation Code? Here Ya Go...
SQL for report
Why Does Macros Dialog Pop-Up When I Try To Run Code In VB Editor?
Can't pass Recordset?
Trying to tableize emails from user folders in outlook
Compile application
Security in MS Access forms application
Run-time error 3061. Too Few Parameters. Expected 2.
SQL statement needed
Access 2003 db window
Very strange problem when hovering a parameter in debug mode
How To Run Sub In Exported From Access To Excel Table?
Allen Brown's audit log code "insert" problem
Add an "ALL" option to a Combo Box
ms access 07 list box select to vba sql query
VBScript to run MS Access form as admin
Copy data from one databse tabel to other database table
Updatable ... not
Adding a Hyperlink to a local file in a forum
unbound OLE PDF Object in Access Report doesn't update
Compile Error "Variable Not Defined" - Access 2007 - Word 2007
using mulltiple criteria in strfilter
Run-time Error '424' Object Required
VBA Corrupt
run-time error '-2147417851 (80010105)'; Method 'PasteSpecial' ofobejct 'Shapes' failed
System resource exceeded
Filter by date range for any one of three dates.
Including blank fields in results when filtering a report
How to list the names of forms and reports of an .mdb database by VBA
Improting multiple OLE Obejcts problem
Microsoft exam suggestion ?
Inserting values into individual Excel cells
Run-Time Error '440' Method 'Run' of object '_Application' failed
Add Voting button to Email sent through Access Vba
Algorithm for computing Excel PercentRank
Acc2010 - Filtering Report based on Subform Filter
How to only allow user to select only one record
How to Requery Sub form from another sub form
FindFirst quit working
VBA Documentor code
Excel hangs. Why?
csv Import into Access db
inventory software
Recidivism
Set Default Date to European Format without changing Regional settingof the PC
How to Return Only the Numbers in a Text Field (Plus the Decimal)
How to deactivate a command button if record in a query
TransferText Question
attempt reconnect on connection failure
Re: Centering Report on screen
Re: modulesdaovba site question?
mp4
MS Access
Output To flush data?
Re: Column Name in Excel Export
Query: Hide columns with VB/VBA
Re: Union Query as Rowsource for list box on form
How to format specific records in Datasheet view
Object Name does not follow Microsoft Access object-naming rules
Using access table to set search criteria in Google, Bing or Yahoo
Distribute Shares from single record to multiple records
Distribute shares from single record to multiple records
Delete files on web server by FTP
Module that caculates the difference between times
Set warnings set to no, but won't work when file goes to excel
How to dynamically set the lower and upper limits of the axes scaleson a MS Access xy-chart
Noob Question
Convert "OutputTo" to vba code
2007 Access error 2455 on Filesearch
Insert Into?
Creation controls in Report
Strange Problem with Scripting.FileSystemObject
Re: Populating a Selection List
Re: Populating a Selection List
How to get a date field to appear as a date field and not a textfield
Re: disable double click to change window size
Re: disable double click to change window size
Change control in dialog form
Access runtime ribbon - export to word option missing.
Insert Into -- expected end of statement error
Assistance with Output
Set Variable to lookup field
Sendkeys "{ESC}"
OLE, INK and Reports
Allen Browne's Calendar97.mdb
If this correct use of Select
show number of records updated
"%" character
Re: Checking for Null & Select Case
Form Name as Variable
Calendar control conversion issue
run query message
Public variable
"item not found in this collection"
VBA Reference Libraries-Access 2003 vs 2007
create a form that collects parameters
populate a text box with multiple records based on combo box selec
Like operator case sensitive
Running a continuous VBA loop while allowing the user to click but
SQL statement with LIKE need to show Numeric paceholders
access form not listed in access class object
Create Table with Date Appended
Code Event Criteria
Error messages as if "Option Explicit" were declared, but it isn't
Re: Filter Records after FindRecord
Access 2000 to 2003, get error 438
What is the meaning of the "$" in say the left$ function
Get Displayed Text of a ComboBox
Complex query problem
Help with vba autorunning macro?
How to delete embedded Word object?
Re: Modules
Setting a subform to a member of a collection
Re: Auto FE Updater
Copy Photo To Clipboard
Can I Share a MDE (which only has VBA Code) with other apps?
How to Export VBA Code to a text file
how do i bypass an access module password
HELP! VBA Code Stopping on Open
random number generation
acDialog - Form Invisible?
VBA To Access Multi-Value Lookup Field
Unable to Reference a Subforms Properties/Controls
Query by Form-TJ
Security option missing-TJ
Empty subforms-TJ
Re: Subreport On No Data event
Change form property at runtime
Re: Syntax Error: Japanese Character in VBA Editor
Re: Split Database Distribution Errors
more on VBA function name change
When I double-click on a hyperlink in Access it opens in HTML
Record (row) count by Table in Database
Requery without visibility change
Windows 7 problem
Automating Excel report Using Data from MS Access
Determine the drive letter of BE database...
does anyone have a simple central warehouse inventory database
A Great Big Thank You!
Need Tab Control Advice
Windows 7 automatic clicks
Format- problems
RE: Need Tab Control Advice
RE: Determine the drive letter of BE database...
portrait and landscape in one report?
RE: Saving Report to PDF without using DLL OCX
Invalid use of the .(dot) or ! operator or parentheses
Complimentary migration kit for MS Office 2010 web apps
Alter Label in Report Section Header When Section Continues to Additional Page
Saving Report to PDF without using DLL OCX
Congratulations! Its a bouncing baby pass-through query!
Re: Integrating Access with Map Point
Re: Test if the same form isLoaded.
Display Report Header/Footer
Re: Disable button on custom ribbon
Why does code Loop
hiding tables....
Undo not working?!?
Combo box refresh with limit to list = no
Append Records without Duplicates
PDF Form Field Values
making check boxes into an array
Re: Module for searching multiple .doc files on multiple terms?
GoToRecord for a subform
Browsing for file name
Utilizing Recordset field in vb Requery Command Verbiage
Message box
Re:
VBA function changing its name
VBA function changing name
Append 2 tables with variable names
Can I use a variable for a table name in an SQL statement using VB
Access 2003 & VBA Debug->Compile
saving a report to a text file without decimals
Re: Continuous form problem
The database cannot be opened...
field properties in queries - "description" <property not found> even though description entered
How to approach this process?
Making Form Read only based on Windows User - Code correction requ
Re: Get an array from a function
Access 2007 DB and VPN issues
VBA - Dmax Criteria or work around
VBA push to Excel issue
bulk copy to Excel
Can I use a variable for a table name in a SQL statement using VBA
Variables in SQL-TJJ
combo box in inputbox
combo in input
Overflow Error
Re: Append page of standard text to each page of a report
Access 2003: Loop Through Records
Sort Columns
Auto Check/Uncheck boxes based on checking 1 of 30 boxes
Using a variable to refer to a control in VBA
Compile Error
How do I see existing users and add/remove them?
Deleting/Creating a relationship between two tables -----> Help Pl
View "AllowByPassKey" property
Re: Date range
flexibility in searching by adding “search by” combo box
RE: Date range
Double click Image to view full .JPG File
OutputTo PDF error 2501 The OutputTo action was cancelled
Query criteria set by unbound form textboxes
publish to pdf
make table in back end, then link
Merging Reg Files
Re: Copy record code
access to pdf to powerpoint
Problem with DBengine.SetOption dbMaxLocksPerFile
Can I validate data in a combo box vs another table?
Re: Median and Quartiles - Speeding Up The Calculations
Create Trusted Location Via Code
Multiple Delimiters in Array
IIF Statement
Refresh Not Refreshing
Delete Field in Backend Database
Count records added in current week
Exit Do problem
How to display only date as year (yyyy) in txtbox?
Installing Snapshot Viewer via Office 2007 Setup
Loop Question
How to display only year as date in txtbox
Re: MS-Access 2007 Minimize/Maximize Ribbon
Filecopy
designing form for inserting records into separate table
Filecopy
design problem
browse for folder code
Multivalue Field in Access 2007...
autodial
VBA code required.
Scanning Through "Memo" Field Is Very Slow
FIND/EDIT Commands in VBA CODING
Accessing information from Mapquest
Re: Issue with DoCmd.Transferspreadsheet acExport
RE: Issue with DoCmd.Transferspreadsheet acExport
Using Acces To Paste Visio Drawing Into Power Point Issue
searching and finding records from separate tables
check date if it falls within a month
Adding PowerPoint slide to Access Form
Two VB Codes for changing conditions
cannot update. DB or object is read-only 3027
Keep subreport with no records?
Delete/import a table from csv; wait for no users?
Accessing the content of an excel sheet
Re: Setting path through VBA
expired date
Create Table of Contents
Creating a botton to update data from a Form to Table
VBA combo code filter in 2000, 2003 not working in 2007 or 2010 be
Multiple criteria selected using checkboxes determine query result
E-mail query to recipients in table - performance and security
Getting value from previous record
Pass multiple selected values from list box to table
Sequentially Increment a Text Field Based on Select Criteria
Print an external file
Treeview rebuild
creating a simple view
Obtain Sub-Folder Names with VBA?
Code for Access Help
dlook finding NULL
Pull form in view mode from drop down menu
Re: Set focus problem
Enable Conditional Formatting Access 2007
Populating a list box with images
5 minute time increments
RE: Count records in a query
Access12 getobject fails
Re: Error Handling
Re: Restore not working
pivoting query
brackets in a sql statement
Re: Using VBA to automate a reporting process
Closing Form causes a requery?
Elapsed time with only 1 column
Can Access 2007 discern which folder it lives in?
How to do it
Access can't find form "frmWarning" in macro or code
RE: Splitting Database
RE: Splitting Database
Re: Splitting Database
Waiting for subform to load...
Programmatically running SQL Query
Search only on current field to unchecked
Find First
Unable To Read Certain fields in Linked Excel Sheet to Access
reading win 7 event logs
Programmatically determining recordset names in database
Re: Stamp date for every record change
Trailing "-" for Neg Number
Populate XL cells with values from a user defined type
Limiting data in a report
if statement = if number is between
Re: Stamp date for every record change
Re: Unable to automate excel chart from access
Retrieving Outlook Message Text
Storing a Per User Per Session Variable
Change unbound text box in Report using VBA language from form
Problem with vba code to export query result in excel
Credit Card Processing
Coding Problem
Tutorials on Access Programming
Import Specs Changed "Magically" in Midst of Loading Sequence
Link Tables and Select Link
Change column to Required = no and Drop all table relationships
Multiple User Access
Creating a string from a query in vba
budget figure in actual field if blank
Error Exporting Access Query Results to Excel
Global variable not working
Data Defnition Query
Send PDF document via Send Command
2010 2007 compapibility
Access 2007 help file
Adding a back page to every report page?
checking if an item exists in a custom collection
checking if an item exists in a custom collection
checking if an item exists in a custom collection
checking if an item exists in a custom collection
checking if an item exists in a custom collection
Re: Access 2010 x64 Development
Running parameter queries from VBA, suppressing parameter prompts
Re: Shortcut menu for a control?
PLEASE HELP: Columns not sorting properly when I import from text
mainform/subform another user is editing...
How to modify the Expression1 or 2 of an existing FormatCondition?
Type - End Type
Recordset in Access 2007
Multiple User Access
Automated Access Reports E-mailed with Outlook in Remote Desktop E
Re: VBA question confused
Function w/ Dlookup
Unload Me
Assigning Text Box Value to Variable?
Re: Duplicates phone numbers and extensions
Array basics!
Strange Julian Date Phenomenon
mySql insert statement using date
Report Printing
Automating a Find and Replace.
Can VBA amend data in tables
Date Comparison
access 2007
Microsoft Access Help Function Sample
Msg - could not update; currently locked by another session
Removing OrderBy from Tables and Queries in VBA
Editing more than 1 table at a time with SQL.
Multiple User Access
PLEASE HELP: automate process to import tables from notepad to acc
Error with Dlookup
Which form event triggers a procedure ....
Conflict in Reference Function
Print a PDF
Help explain to me
Re: OpenCurrentDatabase with runtime environment
Re: Linked Table Manager
Listbox and combo problem
Getting Compile error
access 2007 vba report checkbox
RE: Linked Table Manager
VBA Error
Logos stored in database
Turn off Help
Re: create a report using vba to select the names for the report
Re: DCount
Re: Query a non-MS/non-Active Directory LDAP Server
Re: MakeSchedule function
Program Database to send Notifications to Outlook Inbox
Check for similar phone types.
Re: Query a non-MS/non-Active Directory LDAP Server
RE: MakeSchedule function
Lookup record in a different databse then current
Check for installed printer???
Access 2007-Create Custom Menu
Rename database Object from another Database
sum weekly data into monthly
openreport errors
View a control's name
Help with custom search form - should I use rec
Command button on a continuous form
Run query before closing database
Crosstab with subquery as source to another query
Re: dlookup function
Compile Error - Don't know WHY?
exporting multiple tables
Can a form with drop down menus search in other forms?
decimal issue
Re: neatcode.mdb
List Box on main form
Re: $B$F$9$H(B
Re: neatcode.mdb
Conditional Formating and SetFocus Question
Access 2007 development in Access 2010
Customized display order for fields
Assign control source in code
fisprogramrunning
A New Law Could Change the Way You Build Database Applications
Set field focus in a subroutine
Re: find date last used, deativate if older than 12 months
Timer not being dispalyed and not able to use form??
ADO Connection Opens as Read Only
Re: Programming Question
Re: Programming Question
VBA Code Help
Programming in .ASP
Run delete query instead of report...
I want use accounting software in INDIA so pls help me for use
Converting old code
Opening client form with apostrophe in name
Execute SQL Stored Proc from Access
Multiple User Access
Flex Grid Control
Open form in another database
Compile Error: Type Mismatch
Browse for Folder
FileSystemObject - Compile Error Invalid use of property
Link fields if primary is found
access app as a service
Search box of the Record Selector
HELP really needed to change combo box to list box for multi selec
CompactDatabase vs CompactRepair
RE: Function to return path to current mdb
Listbox Order by not sequntial
RE: Function to return path to current mdb
Re: Function to return path to current mdb
Switch board error - hyperlink
Assistance with vbYesNo
Northwind Sales Dialog box- change combo to list box
Compact & Repair Code - File Permissions question
Changing combo to list box for multi select values
Re: Launching Excel fro within Access 2007
SubForms
ideas on how to make a test suite
Dcount operation
Invalid Operation on a querydef
AfterUpdate event procedure
DateDiff
RE: Opening report in a different mdb
Please Help: compare values in two columns present in seperate tab
Check Box on form
VB Event proc puts spacing between 1 and s in 1stQueryList.
RE: set excel cell value
RE: set excel cell value
sorting problem
remove filtering problem
Randomly select a record in a table
RE: set excel cell value
Convert Excel code to work in Access
how can I activate a hyperlink address from the vbOKOnly button
Days and Nights
Obtain a list of all files in one sub-directory with VBA?
Re: RecordsetWrapper
RE: Split Function Wrong Number of Arguments
PivotTable: Type Mismatch
RE: RecordsetWrapper
How to Keep Combos requeried when viewing and editing records.
Adding filter to query
Under the gun, HELP!!!
Problem filtering and opening a report
Saving Excel from Access
Re: Convert data type text into number
My (final) 2 cents on continuous form design
Problems with MS Access reading dates as US, not British formats.
Can't get this code to work properly to print
Import table into database Access 2007
Problem with deleting record
How can you generate an Excel file from a query that has parameter
RE: Check a field and show a popup
How do I create a clear filters button in a form?
Queries
Problem rounding down Access 2000
Percentrank
User defined type not defined?
Formating Percent with VB
Opening another Access DB from a Form Button
email automaticly
Retreive Variable Value from Module
VBA Project Deleted
Command Button - to pull all
Re: Text or Sub-report on even pages of a report
I can not sort hyperlink field in the query
exporting xml from access 2000 query
Commit/Save Record
Custom Date Partition Function
Need to get the Up/Down Arrow Keys Working
Connect PHP to Access database error
Make Table v. Append to Table: Need Some Expert Design Inputs
VBA Editor skips lines and moves to other part of code
Adding timeframes to database
Creating conditional clause in a module
The memory could not be "read" error
RE: message to wait
Re: message to wait
RE: Code disappeared
Access 2003: Need module to add dates to report.
Object to use for sending URL / retrieving XML
VB Code for form filter with different Data types
running query every day is slower
Dowload file from URL with VBA
Compact and Repair database
How to Change Value of Active Control
Accessing a database access file without a driver
Error 3144 syntax error in UPDATE statement
VBA Opening Access Table from Excel - Permission Error
Application-Defined or Object-Defined error 287
Navagation Pane frozen
Can an Access accounting database be linked to a bank account?
Re: Audit Trail Code
RE: Audit Trail Code
Edit/Manipulate PDF
RE: Audit Trail Code
Linking in Access to a specific Outlook email
VBA and Javascript
Re: vba,xfer
Oper Arges
How do I paste a graphic from Access datasheet to Excel using VBA
PRODUCT KEY OF MS OFFICE-2007
Linked databases
Linking to specific Outlook item
Re: Unmatched Problem
RE: Ask help to speed data processing
Appending to Sharepoint List From Access
Hide a Folder
"#Delete" in memo field
Developer Extensions for Access 2003...
DoCmd.SendObject TemplateFile
Adding report with another
migration from Access 97
email attachment pop up network problem???
Custom Ribbon and Reports
Etat Access : mise en page non enregistrée
Fill-in PDF Form using Access Data
your 2 cents on this form design
Recreate VLookup in MS Access 2003 Form Using DLookup.....
Jet engine and multiple processors
control reference change bet. 2002 & 2003?
Import using schema.ini file
How to view Outlook 2007 from Access 2007 form?
EMailing a report in Access 2003
Using Dlookup in VBA
HELP NEEDED WITH REPORT
Search a data (EmployeeName) from all the tables in the database m
Blank Report
Leave workgroup on Exit
Message Box to Display a count of Records
Creating Memo from data
RE: Passing a value from one event to another
Can you collect data into access 2007 using barcode scan guns?
RE: Extracting first letter of last name in name field
Deleting sheet from a template
RE: Extracting first letter of last name in name field
Re: Extracting first letter of last name in name field
calling objects method
display criteria as a field in returned data
Re: Cannot Kill Excel File
#Delete Mark in Bound Memo filed
How to create the manual in Access database
Arvin Meyer's database
Which is easier to use for this project?
Unable to Programically Total Values
Where should the backend be installed
Problem with FindNext in Recordset object
Problem with divided by zero
cloning records
Environ(x) doesn't work for 1 user
Closing Excell from Access
Open another database...
enable a combo box in one form based on input in another form
Get records with a negative value anywhere in the table.
Querry run time display
DSN Less Connection
Help with a batch file please
Add Events
VB code stopped working?
Multiple ComboBoxes but one must be Checked
Collapsing All groups in the Navigation Pane
Retrieve an External File, pdf, txt, jpeg... etc
Issue Refreshing/Requery Subform/combo box
Using expression builder object
Using OUTPUT TO in VBA, then how to modify the XLS from Access?
How to display thumbnails using Access 2007 VBA on Windows XP
How to create an email in a client's default mail client
Application Installation Dilemma
Array to String
Re: Looking for example VBA code for MS Access DB sync
Paramater box pop up even if customer selected in combo box
#Delete appear in field
Re: add record
RE: add task form access to outlook
Re: Looking for example VBA code for MS Access DB sync
combo box method or data member not found??
VB Code to copy linked table to local
Mail Merge from Access with datasource being a password protected
WHERE statement in VBA
RE: Cannot run module in macro
Setting excel to landscape and setting print area from access
Re: conditional formatting syntax
Outlook Outbox not responding
Locking Tables - MS Access '07
Re: Email from subform
Re: Transfer Spreadsheet Method
Revision conversion to a number suggestions ?
ERROR# DSUM
Access To Word Mailmerge - One step only Office 2007
open two different Access reports
Re: change property on subform
Re: Transfer Spreadsheet Method
Close Database
RE: Transfer Spreadsheet Method
Like '*' or Is Null
referencing the same class objects in two forms
Bypass hyperlink prompt in VBA?
error message 2465
Month problem
Error: 2003 vs 2007 Object or class does not support the set of e
Unable to update/add records in connected SQL Server tables
Create Multiple Index
Query excel temproary file from Access
Re: .createfield and OLE Object
Control de Print Dialog Control
vba to crop a picture
PLEASE HELP: Display results in footer section of a split form
Re: Parsing imported csv data
Refer to a form instance
Open Word Document With Modify Password
Send Email "Operation Failed"
Removing character
anther date question
Check dates
RE: Not In List
If field value has changed allow an audit - if not allow form to c
Combining records by date
Attachment image as image picture
Error 52: Bad File Name (Chinese characters)
If in side of If Problem
Autofill field based on values from another table
Form repeatedly becoming corrupt
building a string in a public function
How to clean up MSysObjects
HELP: Display search results in footer section in a split form
CDOSys.dll and Basic Authentication
passing boolean variable value into SQL string
Front End being locked
use global variable and email a form
Format text box as bulleted list
Have values in Not In List sorted after new addition
#name error text box
Set focus to MS-Access
Access 2003 and/or 2007 copy in objects from another mdb
Rollback doesn't work!
No Data on Form Open
#error in text box
Email the files in the Attachment Field from Access 2007
Autofill new record
Hidden toolbar unable to get to show
beginner VBA to create 2 columns
Lapsed Time when 1 date is null
Encoding string to UTF-8
DoCmd.TransferDatabase run-time error 2501
Reference PivotChart view properties?
Re: Run-Time Error 438 Outlook
transferring data in rows of one table to columns of another table
DLookup
ListCount
Programmatically listing Relationships of ADP file
Reading SQL Server Extended Properties
One to many help
saving as text to remove corruption of forms
Can't hide Property Sheets
Input Mask
Re: where in recordset
Embedded Macros
Re: where in recordset
Re: Query the last 5 dates
Re: Query the last 5 dates
Automating CompactRepair--"db in use" error
Pass the results of a query to a variable
Append and Loop Code
left and right functions not found on specific computer
SendObject behavior different after today's Windows XP updates
Deleting Import Error Tables
How to Split Related Records in Two if Greater than 15
Highlight Records That Are In Use By Another User
Copying and pasting rows from one wksht to another based on cell v
Code to delete rows excluding Header if not = to
How to combine several excel files into one access table?
Tables Refuse to 'Hide'
Disable MS Office Button & Navigation Pane
How to determine if an object is still open
Custom Ribbon Using SQLServer Backend
Evaluate execution time
Re: Clarification: the copy should be the bound column not the displayed
Assigne Macros to a Single Command Button
Database Expanding out of Norm
Import Historical Stock Data from Yahoo-Finance
Filling drop list
Use of DSum, DCount, DLookup, etc in form after splitting
Determine if an object variable is set
Mutliple Databases Open for Some Users
Table to Array
Run Time Error 3027
UTF-8 Encoding
assignin time values to a variable
RE: DLookup function
How can I run a ".cmd" command string from within MS Access?
Re: What's wrong with using GOTO ?????
RE: What's wrong with using GOTO ?????
4 day work week
Re: What's wrong with using GOTO ?????
Supress Access Error in Field Validation Routine using BeforeUpdate
PLEASE HELP: Develop a custom screener in access
Disallow null/allow null depending on the selection of another fie
Error - Record(s) can't be read, no read permissions on
cancel parameter without error?
SQL pass thru query from code always propting for DSN
2000 Runtime
Using VBA to set up a query in acViewPivotChart
Re: Question about an SQL statement
Re: Question about an SQL statement
copy file via Access VBA
export file to excel in microsoft access
Re: Extracting text from XML fields
Calling a non-microsoft application
Help with my function vba code
VBA to programmatically manipulate acFormPivotChart
Re: Function key F11
Help with this Event Procedure
Link to feed query