Microsoft Access VBA Modules [Archive] - Page 9

how to format text in a memo field
use lbox recordset property w/ ado memory recordset?
RUN MANY QUERIES FROM VBA
Insert Form Field in a Module
Assign a Module to a Form Button
Sending Outlook 2003 Message from Access 2003
Print based on control
OrderBy toggle issue.
Run macro in an external access db from current access db
Loop through ADO recordset, update records, and count updated reco
Print contects of a listbox
SendObject through secondary Authorized Email Address
Form-Subform keep in sync with out Child/Master linked
Re: Date problem with function
How to do vertical concatenation
logic question
get-wmiobject <-> cluster /cluster:SERVER res
Printing multi Reports
Change the Database password
MULTIPLE QUERIES
Save current fields error on a chart
Is it possible to automate repetive coding
RE: Report Caption Property
Re: Report Caption Property
how to read/write/update/delete record in tables using vba
If statement logic
Long strings
Status meter not moving until sub ends
Parsing a memo field
unknow link specifications
Get information about lines in VBA
Conditional Format and performance
Internet Explorer Object - Automation Error
Data Access Page-disabling "Move to Detail" option in Pivot Table
Emails
Error 2950 RunCode
Add new record from a form to a table, then record new ID
pulling information from access
Relink to BE with a Database Password
Re: Allen Browne Audit trail problems
Display a message box with a count of filtered records.
Open application in last known state
Prevent interruption of status bar meter
RE: If object exists in the mdb
RE: If object exists in mdb
RE: If object exists in mdb
RE: Iterate all open Dbs in all instances of MSA 2003
Copy Linked Table to Local Table
DMax on Text Field
Data corruption problem Access03
Multiple checkbox to input multiple text into a single field...HEL
Report On Format event executing twice
Page margins when sending to pdf
Chart design question
Importing huge text files
Importing huge text files
Treeview event on double-click in VBA
Word Forms Tables
Merging RTF to Word from Access
allow user to set startup options
Re: Query not firing...sometimes
User Access Menu
DAO qdfs does not delete my queries
Ouput changing column properties using a module
Searching for a string
Display certain characters
Textbox Formatting
Removing duplicate characters in text field and arranging characte
Removing duplicate characters from a word and rearranging it
Strange form behavior with AllowAdditions
Formatting in Access
Re: Iterate all open Dbs in all instances of MSA 2003
Access
Using ":" in coding
Most Recent Date
Built in properties not found
how to open an mdb file has a database password form another mdb
Confusing Type Mismatch
NOT IN LIST EVENT
Re: Opening a file with a command button
Runtime error message
Testing for Open Navigation Pane
RE: Opening a file with a command button
RE: Opening a file with a command button
Macro Timer
Appending parameter from parameter query to exported filename
Loop Inside a Loop
VBA Excel File SaveAs
Query duration time
Variable adding ""
On print doesn't open report sheet
Re: Backup box won't hide
OS Question - Vista returns WinNT
rs.close vs. set rs = nothing
create module to insert random numbers
Access 2002 hasproperty won't compile in 2007 replcemnt function?
MDE ?
syntax error in INSERT statement - but only in one case?
Retrieving data from text box and sort descending in a list
Compile Error: Else without IF
SQL 2005 and Access 2003
DAO's currentdb object
Dim rs as recordset or object? How to check if an rs is open?
Newbie: Advice for checking errors
Get Output Folder for Application PDF printer
import csv files to access db
Runtime Error 2587 can't complete the Output operation (RTF files)
How can I make an Interface that implements Code like IDisposable
Find string in a string
Re: What events fire when returning from a modal pop-up form?
Re: What events fire when returning from a modal pop-up form?
Saving file to Sharepoint Document library via VBA code
what the difference between recordset and recordsetclone
VBA no longer works when linked to SQL server tables
Turn off auto spell check for selected txt boxs with in a form
Do you use On Error, Err_, Exit_ ??
Linking to Outlook Contacts (Office 2007)
Insert a HyperLink in to Word using VBA
RE: SQL Query Duplicate Rows
Adding other email address to the DoCmd.SendOject
code works in 2000, won't work in 2007
Start an Outlook e-mail from Access
Advice Needed for Planning
Use Access 2003 Custom Menubar in 2997?
Re: SLQ in VBA
Error problem
Invalid pointer error -2147467261
Creating a path and opening a PDF File
mass renaming of Access objects
Conditional VBA
file dialog for new file?
Question about late bindings in excel
Check for file on server during login. If it doesn't exist, shut d
Importing data problems from Excel
Confirmation of Email Sent
Record locking - Integrating Access with Sharepoint List
Update query not working
DSum
2 comboboxes on a form
Access
Access 2003 - Combine data from 4 query then update to 1 table
The function you entered can't be used in this expression
textbox read in as a string?
Re: SPlit Function Question
RE: SPlit Function Question
Re: vba code behnd button to parse table
Mouse Wheel Scrolling wont work
Sum Field in Query
Data transfer from screen outside
Access 2003 - Creating a Word Doc
compact&repair password protected .MDB
close all access application
Problem editing a relationship
Trying to send a fax
Percentages Help
Pivot Table
Imbed MS Project Plan
Case statement
How can I get Yahoo Geocodes into Access?
Office Clipboard
Problem with Import Wizard in Access 2007 Runtime
Is is possible to use EXISTS with .findnext?
Re: Change Report Footer control's controlsource in VBA
Need Help Finding Right VBA DLL Version
Spell Check
Convert 2003 to 2007- with VBA
Disable Close Button or in other application or capture its proces
Button on Form to refresh hyperlink data in table - error 1004 & 3
Make Table Query - Properties?
Runtime Error 5 when running vb code in ACCESS2000
One big database or several smal?
Build ACH file for bank transfer
References in an MDE
VBA Conversion of Excel 2.1 to Current Version of Excel, SaveAs
Using the DatePart function in an Access 2003 HAVING clause
Email from a table
Query Calculation Help
Is it ok to open/close several times an ADO connection?
Underscore/bold in InputBox
SQL statement in VBA
Query or VBA?
Re: Quick VBA question
.FileSearch issue
Re: Running the same code AfterUpdate on multiple fields
Calendar control today method not working until form reload (?)
New Access 2007 ADE and Runtime (Free!)
age calculation
Access/Word 2007 Mail Merge Question
Access/Word 2007 Mail Merge Question
Error 3078
Trapping 'Disk or Network Error' Error
Chart Object in Access 2007
Questions about writing data to text box in a report...
runtime error '91': Object variable or with block variable not set
Syntax question
Get data from Excell - identify grouped rows
idMso values for ribbon tabs
Reference and 3075 error
Report signatures
Add/Edit Tabbed Form
Parameter range in DoCmd.OpenReport
ExportXML
Indent label
Filter in Form Help
Pivot Table totals from vba
I manipulate a record that I've put into a listbox (vba)
Preventing Users from closing Access Accidently
RE: Access and CR - Invalid Reference Error??????
VBA code to import table via query
MapPoint/Access API
Numbering records on a continuous form
Linking Access DB with Excel Spreadsheet
Finding a table in a table collection...
Combo box value
Word Automation Error
HELP!!!!! need help in programing a button.
Calculate Inventory Reorder Quantity Automatically via Usage
Late binding Access from Excel
RE: Snapshot Report
After update issue
Half Hour Interval Impacts
Adding information in a table automaticly with just a few entries.
Ways to keep database size small
How to Turn a Record Of Data Into Something Else
Check for file currently open
Refering to a Form & Subform in a combo box command in sub form
SQL statement in an external database...
Emails from Access (Followup Post)
Close button
Field contents as variable
Adding an automation object
Copy recordset to a new row
deleting a relationship
Changing ODBC Connection between development and production
vb problem
Automation Error
Problems with Snapshot Viewer ActiveX Control
Decimnal Places Rounded in Code, but not in the Form
Control to use for sorting by column in continuous form
Increase MaxLocksPerFile registry
Cycle records - Mouse Wheel
FileSystemObject
Export All Tables to Another Access Database
Export All Tables to Another Access Database
classes scope
Update Field in table
Filepath in code via form
copy from recordset ( ms word)
Two Conflicting Events
Wrong Format
Can't find file DAO350.dll
MDE encrypter 2048 Table IDs limitation
Access Developer doesn't appear
How To Name Columns With Code
runing code without waiting for the result
Re: Problem with variant
Re: Problem with variant
Selecting printer via code.
Printing Access Report Via Module Fails to Trigger 'On Activate' E
Insert Access Dbase Field into a specific cell
Application.Run
Application.Run
Application.Run "projectname .procedurename"
Application.Run "projectname .procedurename "
Syntax Error
How to use excel vba to specify the path of a link table in access
WHERE Statement for OpenRecordset
DCount slows down Access application.
get hader name and page number
open each access report & copy to one word file
Using SendKeys for Enter
OpenRecordset ... Too few parameters
Can I run formulas from a text field?
extract items from list in single field, revisited
Send a string to an ethernet attached printer
reading Access database programmatically
Application.Filesearch in a Runtime program
Using Access to fill out PDF forms?
sql where start/end date
Re: Insertion of Field Value into String
Using SendObject to send a filtered form
complex data validation
Re: Unique Record Identifier
Returning Null with Dlookup
Null field friendly error message
convert Binary Stream to BLOB?
Function not known!
What is a good book to learn advanced programming
Lock / Unlock VBA project
frustrated with program
Inserting Excel VBA into an Excel File while Exporting
Sending HTML message from MS Access using MAPI
Populate Datasheet Combo Box with Field List
populating listboxes
Bold words in document
Double substitution
Passing strings with blank spaces into WinExec function call
Record update
Question to Auto Fill Parts of New Records
parsing URL
Import/Export and DB bloating
Code to "Save As" and Open Database in Access 2007
Index number not working properly with variable
I need to start a vb.net 2008 program via Task Scheduler
Automate Excel from Access 2007
List all procedures within a module
Upload File with Access 2000
Access Shift By Pass
Re: Possible Combination with same Total
What has focus?
Problem with Runtime Error 2448
2003/2007 Access Conversion
How does DIB.exe work in Access VBA?
Document is locked for editing by user.
import individual worksheets from excel book
how does macros works
Get EBay data
command line coding
Missing records because of Turkish letters in ORACLE db connected
Bitten by the apostrophe/SQL bug
DateDiff Working Days only not including holidays code problem
DateDiff Working Days only not including holidays code problem
Access form not showing and can't delete access form
How can I check if an Access database is open?
help with vba altering access data
Special character for Rx?
Politics
Rounding Discrepancy
RE: Function not running inside a Sub when a date field is blank
Stephen Lebans - PositionFormRelativeToControl
How do I assign a control to a variable AS Control
Send Instantiated Report
open hyperlink
how to builit Query by BVA
shell question
Aautomating msProject from Access
result
Re: How Do I create a Macro that Creates Linked External tables?
Howto Get back to form view in runtime?
OpenRecordset - Error 3061
Linking Access to DDE
Adding References to Access
Array compile error "Expected: As"
Alter multiple columns types
Selecting and copying to a dynamic ending range
Text Box data <-> Text file data
Pivot Chart view of Query using VBA
Null not adding in expression
Unlink imported file.
Control Source for text box on report to display the field name
Step into VBA code Problem
INSERT INTO from both a table and memory variable
Circle on report
VB problem in Access 2007
Hyperlink in e-mail directing to a specific record
Open .NET Application from MS Access 2000
Linked Table Manager
Debug Mode Fails
DoCmd.DeleteObject acReport
Re: Print 1 report for each record
Not in list error
Error 3071 when trying to do query
Multiple Access and ODBC connections
Error 3709 in Connection Statement - Help!
changeing the connection on a Linked Table
how to call Oracle Stored Procedure from MS ACCESS 2007 VB
List Run-Time Errors
Refresh lookup field after running Database Linked Table Manager
Deselect MS Access properties programmatically
Filter by option group
start time end time
Public Variable
RE: MS Outlook VBA Editor
Using tables to create code
Changing Function
Advanced Functionality through VBA
Create Linked Table to Another Network
Using SendObject from Access 07 - need help with OL 07 warning
If Statement
Filter with listbox
adding sequential numbers to a group of records
Custom Help in Access 2007 gone missing.
Re: Referencing report in Current db vs Library
Rows To Columns -Transpose or Pivot or?
Several Drop Lists Dependant on Mulitple Criteria
sqlserver 2000 database access is slow
Dynamically changing a subform's recordset using txt box
More Func
Oblect Variable Not Set
VBA not executing
error 7777
Re: Pausing Code
Unable to call a vbscript within a vbscript
Re: Referencing report in Current db vs Library
traversing a large recordset
Access
Calculating Percentiles
Distributing MSINet
Problems opening workspaces to add tables/fields to secured access
Create an export file using user generated title and export data t
Data type for nulls in UNION query
Creating & using Hyperlinks
Criteria Range for generating Recordset (syntax help)
Re: Referencing report in Current db vs Library
Delete Query
MSAccess to MSWord merge
deniyng user to mess up pc
Format response to msgbox as password type
Current Record Number
Re: Is this query/function possible?
RE: Is this query/function possible?
Inserting/deleting data in table in multiuser environment
Custom Ribbons in Access 2007
Modifying custom menu in Access 2007
Access Closes itself?
Another listbox problem
Need To Loop Thru Records And Update
How do I check to see if an Access Database is locked using VBA?
Create a StartupForm property
Listbox.listindex
Look at previous record in a report and use it to format current r
Re: multiple values from a temp table
Visual Basic use of Null in if statements
Access VBA SQL problem
Unbound Form Audit Trail (Allen Browne)
Allen Brownes Audit Trail
Filtering a Report for Printing
Listbox "List" property
Howto move a query into a temp table that would be named by user
Reference Order
If multi-valued fields is discorage, what should I use instead?
How to get Field to vanish with code
HTML report and dynamically add records from a query
Suppress error message, close on run time error
Loop using append query
Query Question
Programming function keys
Data manipulation
Automatic Report Exporting
Importing users Outlook calendar appointments to Access 2007
VBA Project Locked
Add From Outlook
Programatically change a Number field to a Text field
Create append/delete query into a table that has multi-valued fiel
how to add toolbar programmatically in word using foxpro
RefreshDatabaseWindow Not Working
One to One Relationship
idMso available in runtime
Other Dbase options
On Click error in Acess 2007
SQL Query
'Id' is not an index in this table
save or export Macro as text
Existence of a record
Best way to handle
Parsing Text file and import into Access Table.
What Do You Use Instead of DoCmd.OpenQuery or DoCmd.RunSQL
Determining the Data Type of a Field
Display record in a combo box
What Character?
Re-link VERY slow when other users connected to BE
DLookup too soon after record insert?
Unable to hide/show controls by clicking on datasheet of split for
Basic help needed - Newbie to Access VBA
sum unique records with multiple fields
Add New Record
Time Out Limit in Access 2003
MsgBox - Display variable in MsgBox
Find a value in a different column
How do I geocode in Access 2003?
Not stopping at text box
Counting Null fields in VBA
Capture Screen Image via Code w/out User Interaction
2001 "you cancelled the previous operation"
Reading Dynamic Values from XML Document in Infopath Form
currency and changer
Can't See an Instanced report. Really need Help
URLDownloadToFile
rror: columns in union query do not match
Access Run-time and Macs
Reading word properties in access 2003
Freestyle Script common?
Webbased refresh
Script & Proportional font
Weird behaviour when coding constants
echo false isn't working
Record Source Theory
Refresh a form
Copy Record - Is field autonumber
Query Problem
Query in VB/Passing it to a form/query
Row in Database locked
Reference a field dynamically
A openrecordset question
DAO coding question opening a record set.
reference vba 2003 vs 2007
Add a new record
ODBC Connection Question
Re: Killing the running Access application
Combine 2 queries
Creating a table in code
Re: I've no hair left...
Re: Textbox character limit length
Combo Box Problem
Re: Textbox character limit length
Block linking/importing from a DB
Create Recordset in VBA
VBA e-mailing
Re: Set cursor position back to textbox
Re: Set cursor position back to textbox
Creating Excel Macros From Access
Access 2003 programming problem
Need help emailing a report - via code.
Subform to Subform Filtering (Access 2003)
ADODB.Recordset save command creates local file!?
Function "DIR"
Set a reference of a library used in a main program
Set references of a library from a sub in that library
carry over
Taskbar display
Windows in Taskbar in runtime version
network userID to auto populate field when record is created/revis
Creating an MDE through Code
Custom shortcut disabled
Assign Query Result to variable
Refreshing table links
Office 12 Access Database Engine conflicts with DAO 3.6 library
Unhide Columns dialog box
Form OnDelete event
DB Normalisation
Automating excel from MAccess 2007
calendar date, strings and SQL
search function using combo list
check box error
excel from access
Access Newbie
Delete records in form
Report
Trusted Location process in Access 2007
Input mask for Military Time
Insert worksheet into workbook using VBA-TJ
Runtime error 1004 after 1st run
deleting files using kill statement
Email first report in HTML and second in Excell
Working with Excel in Access
How to use validation rule for allowing only first day of the month
reading the active directory using VBA?
Event coding for a pivot table
Database Compacting Function
Forms Change size and location
Incorrect values returned
How to control a webcam in Access
Dmax Function
Transferring list items between combo/list boxes
Access 2003 VBA Code
using lib files?
Yes - I want duplicate records
EXTEND mode??
vba help
using a hyperlink in outlook to open a specific record in ms acces
OpenForm ignores query
using msg box to advance to new record
Calculate an amount for a group of records based on number of reco
fields from form to report
Writing queries in VBA
sort a subform by query
Sort a subform by query
How to convert Upper case to Proper Case
Exporting to Excel and importing back (Access2007) - Determing Ran
DEVELOPER PACKAGE SOLUTION
Detect if a particular *.Exe is installed (Snapshot Viewer)
Access 2002 Lock File Location
Change Formats using VBA
make QAT inaccesible
RE: Start Date and End Date Filter Code Miscommunication
File Browse - Full Path
Generate Table with Calendar dates to 2020
export table contents to .txt
Re: Start Date and End Date Filter Code Miscommunication
How to add fields and text boxes and assign control source to the.
Sort and Flag records
open an access form with a specific record using a hyperlink.
Software Copy Protection
Strange sluggish behavior in A 2000
strange sluggish behavior in A 2000 DB
Re: Code to change report caption
DCount & DSum
Using code to edit modules
Converting text string to a number in Access Queries
Automating PowerPoint - how to change text in a label object?
Getting Started in Access 2007 screen
FollowHyperlink generates error 490
Merge databases into one
NotInList Event
Deleting records
Lookup
Import specific spreadsheet columns
LEFT JOIN - Syntax error in FROM clause
Access / Word Workaround
Help with Insert Into
How to Get Photos to Work Again
Some help on converting some code from Allen Browne search2000
>> Access 2007 Ribbon
RE: Calculate Dates based on Frequency
Creating a shortcut that opens a multi-level security in a runtime
Issue with Movenext statement
Identify Parameter Source
Error 55 File Already Open
Emailing From Outlook - Assign From Field
Problem with For...Next loop
Access 2003 Memo Fields
Using custom Task form
Building a SQL string
Passing a variable to a url
'Catastrophic failure' message (Error -2147418113)
Option Group Frame height
using sub reports
RE: Select Where Two Condiotions as met
Duplicate Records That Contain Composite PK
RE: Select Where Two Condiotions as met
Re: Select Where Two Condiotions as met
importing ambiguous dates
Transfer Text
Flexgrid context menu
Add Complex Worksheet programatticaly
passing a function a form input variable
WorkingDays Function (need hrs, not days)
return caption for a control
CreateRelation to Other Tables file, throws 3409 error
Greater than statement
Question You are subscribed to this thread subforms GotFocus ev
Access_Excel_SaveFile
Code not cycling!!
Help using 'OnClick' event in ListBox Selection
input box with many selections
Re: Multiple Selection in ListBox & Insert using SQL
RE: "Type Mismatch" error when trying to pass DAO.Tabledef to object f
RE: strange behavior after adding value to lookup list
Transfer Spreadsheet; Import Only UsedRange
Subdatasheets
Re: "Type Mismatch" error when trying to pass DAO.Tabledef to object function
Event Handling
Too many fields defined
My dcount is not working
How do I add Filter on Linked Table?
Refresh a subtotal please leaving record
VBA code in report
Error in Word from Access
Convert Cm to Feet and Inches
Sendobject works only once
Use a Variable to set a Variable
How to write a module that will copy, move and rename files?
Re: MS Access on Sharepoint - random I/O errors
User name stamp
Stop code on error
Excel instance remains open
Continuous form coding
Select record from recordset via vba.
VBA Subroutines / Functions optional input parameters
Sorting mixed alphanumeric data
need a code to add records....
Function Not Responding
erratic format result
Delete old link from desktop
Outlook signatures
How do i get a Module to run on the last day of each month.
AutoSizeText
passing values from a form to a send object function
Ref a Function
Albert Kallal Merge Code - No menus when word opens
Error on Exit procedure
Answer "Yes" when delete a record
docmd.copyobject
DlookUp Help
Set order by table property with VBA
getting right string in table
Loop thru all fields in all tables to replace bogus data
Make It A Module
Access to Excel
Mass Upate of Two Joined Tables with Variables
Type mismatch error when setting DAO property - references anddisambiguation okay
Input box
Re: one more Lebans Question....stop Adobe from oepning?
Error 438 on .requery line in code
Ensuring front end update
Export & Import data
Re: Lebans Rpt to pdf file question
error 3048 monitor resources in vba
filtering in VBA
If the total stock is reach 1 means it generate alarm or msg
ODBC Connection String mystery
Function Modules vs Sub Modules
Guideline for creating reusable modules ?
Re: opening table cause access to crash
Report Will No Print In Color
Progamming Check box condition
Set Cursor at end of memo in text box
Sort a column by code
Slow VBA-Generated SQL Involving Totals Query
Beginners SQL in VBA help
DoCOM Close question
Setting a Variable on the Fly which is Unknown at Design-time
A&A - In Any Place - VBA Solutions in MS Access and MS Excel
Web Based or Access Front End
VBA vs Query based database
Re: Conver Report to pdf programatically...?
Exporting to Excel (Macro)
opening mde using vbs
Want to view saved word documents while in access
Generate *.SNP file and then display in .SNP ActiveX Control
Check if current record is being edited by another user
best method for back-up
rs.eof/rs.bof not returning a value
Filter For Throws Error when user enters 'in'
Select and delete a record
Transpose
Close excel file wothout prompt (vbscript)
Help with Syntax Too Few Parameters
can I create an electronic signature for an access record?
Calling Procedure from OnAction
Modules
Run-time error
database back up
Write Conflict Revisited
Extract String from memo field
Color Chooser for Graph Chart
Schedule coverage %
excluding certain field value from recordset output
Changing BackColor
fIsAppRunning causes code to go into Break mode
Access 2000 Database
Password to modify
Form name as a variable in a module
Different ways of declaring listview or treeview control
Returning everything to the left of a truncated field in access fromthe last full stop.
Transpose with recordset
Change field Names with first record
Syntax Help
Access Query MAX function return value
create MDA?
Compiler Error Can't find object or library
RE: Problemas con los Menus de Access 2007 (Ribbon)
Running a stored procedure from an Access project
fIsAppRunning - Need Outlook class name
Random Numbers
Random Numbers
Count on keystroke
Check Who Has Accessed a Web Site
issues with looping using Outlook for sending emails via Access
Why doesn't this work in A2007?