Microsoft Access VBA Modules [Archive] - Page 2

Re: Problem in Access 2003 with Queries written in VBA
Re: Progamatically limit the number of certain records
Code hang
How to save data in lookup field from a combobox
"Object variable or With block not set."
creating data for values between 2 numbers
Using VBA to switch to a particular Access database
Assign from a list of names randomly
Re: Trouble with cmd button
SQL Server
Modules Corrupted
RE: Error handling
Combo box multiple values persistence
Re: Help with search code
Best practices for programming record update
Save SaveAs menu item
Events as the DB closes
Re: Delete Record Button with Confirmation Message
Re: Runtime Error 3265 in my TableExists function
Re: Runtime Error 3265 in my TableExists function
Generating Multiple Choice Tests
data type mis match error
rename tab in excel workbook
Error 2467 in Access 2007
RE: Runtime Error 3265 in my TableExists function
When to migrate to SQL server
zz error 2147352567 when trying to delete a record
Automatically generate a "create table" statement
Access Expression builder
RE: Progamatically limit the number of certain records
Split text in one field into multiple records
Re: ActiveX Error 429
Search Form Result to excel - Item not found - Where to start
Acces 2007 performance
Filter number range causing runtime rror in search form
Open/close Navigation Pane programatically
Old Question
Re: Form-Timer; run multiple macros.
Inserting value of an unbound Textbox
Unlink and Relink
Writing to Excel header w/A2000 VBA
Getting values from Excel worksheet
Search Criteria - Yes/No - Allen Browne Form Example
Issue creating sql authentication odbc system dsn
How do you create a free runing program in Access?
list box
"me." doesn't work
run a forms control events
Restricting Access database users from seeing Switchboard Reports
iif expression and time format
Image Orientation
IMAGE ORIENTATION
Alternative for MS Excel VLOOKUP function in MS Access 2003
Tool bars
Subforms
Re: Holiday day tracking
Re: Holiday day tracking
Constants
Subforms does not load on all computers via script.
Recognize which form is calling the code
bold font for lotus notes email
INSERT a Table (32 items) into another Table - Re subform
Re: Crosstab
Why I can't send email from Access?
Control to browse folders and files
How To Convert Access 2003 Application To Access 2007 Version
new messenger
Re: Open a report in a different mdb
OpenRecordset notation question
VBA query trouble
Dynamic Forms
Help to create and Insert New Target Date record in Subform
Locked VBA causes Access to crash with ACCDE files
appending unbound combo query data to new record
TransferText XL To Access
Compile Error ??
Compile Error ??
calculating value in a query
Looping through a Large recordset.
VBA for emailing to all involved poeple
Calling a form in variable
Re: Event Procedure
Unprotect a Word Template
Re: Rowsource of combo box on subform
Retrieving Active Directory User Name into Access 2003 table
Invoice number
DSN-less Connections
CODE 2 ADD RECORD
Link to Outlook folder
Connecting to a Distant SQLServer Using ODBC
Help with Transactions
Code to set query parameter through command button?
Form Code HELP ??
How to login "Oracle ODBC Driver Connect" in the programmatically
Split database into smaller db based on values
Create Excel Pivot tables from MS Access
How do I make my 2003 access file to be compactable with access 20
Another recordset problem!
how to reference a uniqueidentifier
Correct Currency Data Type and Validation Coding
CODE HELP!
Using MDE file to connect to SQLServer via ODBC
Can Access 2000 be installed on Windows 7
Docmd.SendObject To: Cc: Bcc: Fields
Can you help me make this string shorter?
Using For...Next with Controls
Access 2007 link table login
Trying to open the current db in Access 2010 through Access Basic
Manipulating the Access 2007 User Interface
Number of users
Mail Merge using Access then save as PDF
RE: I know I'm missing something
Count the Number of Files in a Folder
DoCmd.TransferDatabase acExport to SQL server 2005
kindly, before I crash this computer against the wall..
Check if query exists
Application Deployment Question
Re: Internet Explorer Object, Navigation, Hiding
rotate a label?
Looking for a better way to Parse out data from alphanumeric field
How to make a subform "read only"
VBA Code to Save Excel Sheet to XML
Launch mde from another mde: fine tuning
Possible to create user-level security in Access 2007 format w/VBA
=RowNum([Form]) - equivalent in a report?
Number of Files in a Folder
display the result
Recordset code problem
Hide page on tab control
Re: File search Dir() problem with large directories
Continuous forms problem
declaring a variable as "Index" turned out into "index"
Bind object to OLE Bound Frame
Re: Can i condense this code ? or for clarity should it be different ?
Loop Append Query
Going Nuts with Selecting the Value of List Box using an unbound TextBox
Password Protect Word from within Access 2003
Get the filename
Launch file from OLE Field
#Name? error
RE: Code help please
Re: Code help please
Determine Module Type
How to Automate Word mail merge from AC2007?
error "3061" Too few parameters
Access 2007 Runtime Cannot Open Database After A Table Is Created In It
USing Access 20007 code in Access 2003 db
mscal.ocx
Multiple Criteria in Listbox
2007 Code in 2003
Compile Errors
VBA code importe txt file
Change to MultiSelect by code
Linking forms
Tab Control Security
RE: Database window
auto fill data
Form_Timer Event
automate file name with report date
Re: procedure declaration does not match
acCmdWindowHide
Database hang
ADODB Testing for Password
Opened Exclusively?
Create task in Outlook folder
Dlookup minimum value
testing for password in ADODB connection.
Re: Populating a subform and saving to the underlying tables
Copy Shortcut
Opinions needed on most efficient method for a form
Re: Treeview
Add Folder to vb IDE
RE: RecordsetClone
Open another database from the current database
Need to create invoice with many variables
Clear Global Variable
Creating a select query using sql in VBA
Upload Word Document using VBA
non functioning code
Access 2007 freezes with properties page open.
Listview Control
Rebuilding Treeview
code 'summing' - access query creating an excel-sheet
Setting recordsource property in VBA Access 2007
Insert Matching Records to different table
File Dialog Box Problem
Syntax Error in a SQL string
compact database from command prompt
Cleanup Code on Form ??
Date issue in Access 2007 SQL
Format Excel Sheet after DoCmd.TransferSpreadsheet
Excel Import Specification
Pass Control as Argument
RE: Searching for posts by author
Re: VBA Date Looping
RE: Hide aform
RE: Hide aform
Splash screen problem
Touch pad scrolling
Syntax Error in Query Expression
My string does not want to execute
Custom Properties for ADP
call a mapbasic program
VBA to open website and pass details
RE: VBA code to password protect and entry field?
Prevent Users from Moving to Hidden Navigation Pane
Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet
Can you supply ACCDB's password in OpenDatabase method?
Seeking Advice
RunCommand acCmdToggleOffline runtime error 2501
Append Query
Problem getting dates to enter a date field correctly
Open File Dialog - Multiple file selection limited to 7 files?
General Questions About differences between working with a MDB and ADP
Re: Popup a message when query finished
Re: Adding a record to a table
Format Date Display in Access ADP
Unable to Edit/Add records on Form in a New ADP
Outlook search from Access
Office 2003 Download
OpenDatabase with ODBC
RE: I need a message if number of duplicate records exceeds number all
Re: I need a message if number of duplicate records exceeds number allowed
Combine multiple args into 1
RE: Input mask error message
Re: How to return the primary key from a combo box
workbook stays hidden
Re: Access changes last name of TATH to THAT!!??
Password Protect form
Email a Receipt
Input mask
Re: Using the Immediate window to run a sub
Re: Access crashes because of this code
Re: Can you disable Access menu bar functions?
How to determine if an entry is a character or number
Microsoft Office Access has encountered a problem
Problem with Union Query for a ComboBox
Create new record but do not allow update of old records
Help with Function
RE: Refresh the original form
Ho wto trigger an event after entering a number in a text box
Change the name of the file attachment using sendobject
How to programmatically determine Good Friday
Open an excel spreadsheet and run a macro from Access VB
Bulk Email From Access
Limiting number of duplicate records
ADO Not Opening Recordset
Do until ... loop not working
Re: For each loop
Re: Error Problem
Re: Error Problem
Passing form name
Qualifier Must Be Collection
Another Combo box problem
Letter merge using backend data
Re: Seeking Ken Sheridan
Combo box displayed value
Disable Startup Programmatically
Passing Array to sub as parameter
Assign the records shown in a subform to a recordset
Loop through recordset and create excel spreadsheets
Re: SQL statement in VBA
ADO RecordSet Save generates "Access Denied" error (80070005)
Ensure A Form Receives Focus
Is it worth the effort??
Linked Tables Performance
Loop through Table while Renaming Files
Date literals in SQL and VBA
RE: Grand parent, parent and child relation
RE: Need a query to return a value if out of range
Date not appearing properly in recordset
RE Emails
Writing to word 2007
Update and insert a Date into a field in sql - correctly
Re: using recordset findfirst
system date returns null
Keeping Footers with Detail
VBA to check Version and Supress safety warning Dailog of Access
want to get field value from say the 10th record of a query - how?
Re: Running a select from the immediate window
linking a view in Sql Server to Access 2007
Site Suggestion/Improvement
extremely slow performance
Error message when trying to use my access add-in with VS2008
Ribbon Invalidate error 91
Get The Call Stack or Current Module
extremely slow over network
Date woes using VBA
Re: How to return the name of the current function/sub
Multi_Column Check Before Update
Re: How to return the name of the current function/sub
Re: Tabular Form
basMedian obtaining quarterly results
return primary key for record after append query
How do I get the current User's path to Desktop
Two questions
Addnew throwing error 3027
Re: Referring to a control on another form
Re: Error problems
Switch Function TOO Complex
CommandEnabled Error Message
Re: Determining if s a parameter has been passed to a function
Properties Window Is Blank
Re: Determining if s a parameter has been passed to a function
Use Macro (or VBA/Module) To Determine If Runtime Environment Is B
SQL Statement gives too few parameters - anything obvious?
RE: Error problems
RE: INSERT Syntax error
Module for Calculating hours
SendObject: Send report at 08:00 in the morning automattically
Re: Error problems
Relink to BackEnd when necessary
Call Report from SSRS
Cancel / Comfirm update
Export Data to MS Word Table and Format
Data Access Page Un-editable
Question about Run-to cursor--I want to "start at cursor"
Re: Access 2007 Continuous form vba code
Do loop until no more folder is found
Code to clear all CheckNBoxes when a Form loads
TransferSpreadsheet and NamedRange; not working!
Dates are not displayed in ComboBox
Update Query question
VB editor appears and then disappear
How do I assign a name to a PDF report via VBA
Creating and populating a table
The microsoft jet databae engine could not find the object "Databa
Dlookup and simple calculation
Auto Create a unique number from user data, for input into table.
Manipulate data
User Account Control
run time error '-2147023170 (800706be)
Preventing Screen Saver Activation
Re: converting the digits to indian currency format digit
Question understanding a line of code
Re: Access 2007 VBA Programmers Reference Code
how to add html to access or create html page in access?
Re: Enumerating controls
Re: Creating collection woes
Re: Access 2007 VBA Programmers Reference Code
Re: Finding a property
Re: Writing Access functions
Moveable Form
Recortset syntax error
Creating Formatted Report and Emailing
Help VBA code
Created Formatted Reports in Access 2007 and emailing (not attachm
Quotes Problem
Sending Report Info in Body Text of formatted Email
Re: Writing Access functions
Change text FieldSize property in DAO
RE: Checking for Existing Field in Table
Newbie programming question
Re: Writing Access functions
Delete index using DAO
RE: Writing Access functions
Line-Break VBA to pass to a Query
Parameter Form
Leban's Report To PDF - Security Patch Issue
Passing Variable Values from Current db to External Database
Blank Report Message
Report to Filter on Next Date Per File
Re: Finding a property
When you import a Microsoft access field into Microsoft word, the
Re: Finding a property
Running command line command without the DOS window
duplicate values stoping ALL appends
Formatting excel from MS Access
Add where clause to querydef?
WHERE CONDITION IN REPORT
Creating and looping through a record set.
How set up repeating record in Access 2007 (monthly, quarterly, et
applyfilter to an unbound subform from a module function
Last modified Date for an Access file
ACCESS TITLE BAR
Object doesn't support property or method
Send Object - Allow Edit No
MS Access 2007 ends unexpectetly - Calls VB6 DLL
Free Workshop on .NET and Programming Solutions by Dr. Venkat
Working in Access 2003 but not Access 2007
Distributing Reports to List of Email Recipients (not attachments)
Re: Checking for Existing Field in Table
Help with listing files using Allen Browne's (modified) code
Cannot use Node.Fullpath in a "CALL"
Save New Record that is not dirty
Re: I need help with SQL please
RE: I need help with SQL please
Re: Checking for Existing Field in Table
Re: I need help with SQL please
RE: Checking for Existing Field in Table
Append Messages
Creating a table with all the "object dependancies"
If Then Else?
Bookmark Issue
Re: Query VB code Madness-Someone knows how to do this..Really...
Date/Time added to Text File
Re: Appending problem after splitting field
CDO Error
Write to a list box
Outlook could not recognize one or more names?
Finding the values of an Object's Properties
Treeview Nodes and calling functions
Counting same rows in a table
Re: Problem writing to 2nd table w/ 1st table's key
MS Access Table missing
How to tell Excel to insert cells and shift down from Access
Re: Problem writing to 2nd table w/ 1st table's key
Unique Order Numbers
Create appointment to custom (shared) outlook calendar
Is there anyway to get/mimic a split form in a subform?
VBA to perform commands on remote servers
Sending email from access with attachment via Outlook Express6
Hi!
Event order for Calculated Control
Excel object model references
DAO select
Re: Printing separate reports
Send Email with Access 2007
VBA code to perform calculations
Enter Data from a Form into a Table
Select Unique Record Identifier
Select Unique Record Identifier
Delete a Query, or Empty it and Reload With New SQL?
Hide Tab in Ribbon
Access bug?
Linking Files and Select Unique Record Identifier
Drowning in Loops
Re: controling excel from vba access and using sub procedures
Trapping specific errors
Execute Procedure on a remote Access Db file
NORMINV statistical function
Is this possible?
converting the digits to indian currency format digit
Email Report - Date format in subject of email
AfterUpdate VB If statement
Results of SQL select assign to variable
How to Apply Current Recordsource?
DoCmd.RunSQL "UPDATE tblDatabase
How do I do this in VBA?
How can I check whether the data is in the table or not with VBA?
What is the code for allowing zero lengths in strings for text box
How can I filter by Dates on a Form?
Setting Primary Key on a Linked SQL Table
Data type issue when importing from excel to access
Ribbon Failure
Use VBA to design Excel report
Ribbon error following previous versions of my application
Build Dynamic Query from Form
RE: Docmd.transferdatabase code
Re: Docmd.transferdatabase code
Form TMP
Debugging brings up empty Macro Dialog box
compact database in VBA access 2007
Text Import Specification Missing
Trying to Print "Client Receipt" form per client visit
docmd.SetWarnings ac 97 status
TextBox
Programming issue with this Macro
VBA to Open MS Excel and get Tab names
Calculate Finace Periods from the given Date
ADO Find method
Setting the Startup Options for an Access 2007 database using VBA
Link from SQL server
delete all in a csv file
Write to a CSV file
Progress Meter
VBA - query reading newly added field as null
data type mismatch
IPAddress
Sending email from Access 2000 using Outlook express 6
SQL for list manipulation (a mess)
Coverting linked tables into local tables
run time error -2147352567
SQL Quotes help
building a query with variables
Controlling Excel from Access VB
Database in a state that prevents it from being opened or locked
UPDATE ACCESS TABLE
TransferSpreadsheet question
Moving Files Around
how to thread DLOOKUP result into "<tab>" "getLabel" in Ribbon XML
Exporting Query - Want count of records
Re: Trouble with syntax
Run-time error '424'
RE: Help with merging PDF Files
No right click action in runtime
vba where Error 3131
RE: Help with merging PDF Files
Blinking font
VBA Problems ... (since windows update?)
TransferSpreadsheet construction
RE: Variables as identifiers in forms
Re: Variables as identifiers in forms
Simple VBA crashes Access 2007, why?
Re: Variables as identifiers in forms
Format Excel from Access
Copy data from one SubForm to another
Re: Discontinuation of VBA Licensing Program
Re: Discontinuation of VBA Licensing Program
Spell Check Tool
Chartspace Conundrum
VBA Code Unable To Create Text File on C:\ Drive In Acc2007
Recording a command button name
Duplicate entry message
Problem with programming for 3 labels per page
How to update formfield on subform?
Problem with running an action query on a view
Package & Deployment Wizard
User Account Control Dialog
Re: UPDATE date value
ADO Syntax error when trying to insert a new record
RE: UPDATE date value
Attachments to Email with SendObject
Send email to exchange versus SMTP
print to pdf-number of pages
Excel won't close properly
Re: Upsize to SQL ODBC error on rs!update
Re: PictureMgr: Create Table in backend
deleting a external file from access 2007
Missing Drop Down command in Visual basic
DCount works/DLookup doesn't work - same criteria
Help with InStr function
Exporting from MS Access to a protected spreadsheet
Display Excel/Access windows
Trying to code "Age of Account"
vbscript to send e-mail to exchange 2007
Sharing Database
RE: 'Too Many Fields Defined'
Null Value
RE: Fill an array variable with a list of the field names in a table
SendObject Not going to PDF Automatically
PLEASE IGNORE - DUPLICATE POST
Trying to learn custom event handling for class modules.
Comparing Memo fields
Expecting date output to be 012110, but getting 01/21/2010
log function
Problem printing tab pages
Limiting a drop down list to a value in another field
Multi-select listbox
Programming Help Please
Trianing Database
What does this mean: Option Compare Database
ADO Bug?
Look up table help needed
Where are my posts?
Changing the Connect string for QueryDef passthrough queries
DAO QueryDef refresh
Re: Changing an expr field to a string
Re: Changing an expr field to a string
Re: Changing an expr field to a string
Unique reports
Outline codes
DateDiff excluding weekends - one case not working
“=” Versus “<>” when working with Nulls in VBA Code
Make field invisible/inactive depending on combo box in Datasheet
iif expected end of statement
Automatically resize subform height based on number of returned re
How to identify an open excel file?
"improper procedure call" when average log function results
Stop Treeview startlabeldit
DATE SELECTION ISSUE
Find a File
Assignment of a VBA expression
RE: problem exporting reports to word
DataObject in Access?
Form Navigation
Setting every text object in a detail line to bold.
VB6 Programming Question
Getting custom commandbar to show on Add-ins tab
Hyperlink value crashes Access
Center text in a MSgBox
Running SQL from VBA in Macro
Modified Trasnpose - Help
Some questions re SendObject
Option Explicit - Bug? Feature? User Failure?
save OLE Object to a file
Need help
Print reports
Conditional Formatting via Code
Issues with posting questions in the forum
Run query to feed combo box
email attachmnet (OLE object)
Getting a "Reserved Error 3099"
problem with scaning
Make Table in Back End using VBA code is not creating the table
Same database can not opened in the other computer.
Append Query every day at certain time automatically
Conditional Formatting vs Code
column to row
MVPs out in force
ListView object model
Update 2 tables via Check Box in Form
Help fixing my NotInList code for a combo box
Can not open my database
Raptor to test algorithms to code in vba
Using Date fields in SQL
Jump to random records
Repost: Bringing Sharepoint list data back online
Printing a single form which has tabs
Count # of records in a table..
Passing parameter from Query to vba
Problem Dispaying Print Button On Custom Ribbon In Access
VB to see if file is present and linked table question.
After Update Event Procedure will not work
OLE
VB 2005 - How to check and modity the file attributes
Ignore "Invalid Argument" error message
Re: Invalid Argument Different for FE/BE
How to Pass structure parameter to SAP RFC
Convert date string (ie: 1/3/2010) to seriel
Closing form without saving changes
Put Button on form to move BE
Split() order into array
How to add command bar button when DB opens in Access 2007 runtime
Processing hanging
Re: Looping through records and creating ID field
Re: Looping through records and creating ID field
Reducing flicker when requering/refreshing
Form BeforeUpdate Ignoring Cancel
Run a Command on all Records
SQL date and milliseconds
Setting a textbox's default value with a variable
RE: Error Exporting Memo Fileds to Excle
How to make a record appear as the top record on the screen?
Disable-based on Adding New Record vs. Editing Existing fields
Question about backend dbs
DAO: query of multiple tables can not find
Delete query in another database
Supress Error Message Box
Help with error trapping and raising
Running SQL SELECT statements in Access runtime
OLE vs Attachment field
Help Needed with a Tricky Validation Issue
Export Query to Excel in VB
Previous Business Day
How To Execute JavaScript in VBA Code?
Sum Trouble
Code to populate combo box
Previous Business Day
How we can set a reminder on ACCESS 2007 ? (same the outlook)
Collect Data via Email
Temp Tables in Access 2007, Transferdatabase warnings
is Clickyes running if not runit
access 2007 dynamic creating child and master link fields on subfo
Opening A Database
Call public procedure by variable
RE: Repost (Simplified, I hope): INSERT INTO
Notify me of replies
Setting variable in API code
Followup on Copy Objects from Another A2007 db using vba
Compare the "varchar" values
Re: Update multivalue field in table from form with SQL
How to compare "varchar" values?
Disable save button in qat access 2007
Disable save button in QAT
read from a txt fil to a listbox
Count if Null and If = Yes
Documentation of Relation Attributes
Error: Duplicate Output Destination
Binding Fields to Control Source
Table Properties
refer to an access tables properties
MDE menu/command bar issue
Using the Google Calendar .net API from an Access application
Active Database
Autonumber deleted IDs resued after Compact?
Loading a customized ribbon not associated with a form
Locks using TransferDatabase
Form Navigation
Inconsistency of CurrentDb
Report to pdf problem
Outline codes
problem with open my program, mde file
Prevent odbc connection to the backend mdb
Why is Cancel Ignored?
Can't Update Database
A list of allowable DAO user-defined properties
How to remove attachment in macro or vba code
A general rule for using methods that create objects
Allforms Collection in another db (A2007)
How do I count the nulls in a field on a table not related to my f
Global variables question
Re: Unstable database
runtime A2000 and application built in A2003
saving a array to disk
VS2005 : - Run program with DB on multi-user Windows 7
Help with memo.
Question from Access 2007 VBA by Hennig et al
A fundamental difference between object variables and other variab
Re: Write a line in a text file with quotes in it
Re: Write a line in a text file with quotes in it
Nesting methods in Access VBA
How do I do this UPDATE in a single query?
Dialog form opens wrong
Working with date fields in a form
Printing a report question
Collecting data in MS Outlook
parse data from text field
Subform Not Displaying Datasheet View
trying to add data from a form to a table
INSERT INTO in a One-toMany relationship
Help, how do I import a CSV file when Negatives are in Parenthesis
hyperlinks
Acts like there's a "Break" in code when there isn't
Terminating select processes
Move object
can you schedule meetings in Outlook 2007 using MS Access 2007?
Numbers did not reset Jan. 1
default value
Type mismatch on DataBaseTransfer routine
VBA code to disable/enble Outlook Sent folder
Help - ListView Event Handlers are not Firing
HELP!!! 2003 runtime app won't run on machine with full 2002 vers
If statement to export query if record count is not null
Programmatically Change Double Data Type To Long Integer
Switching from Corel Paradox to Access 2010
SQL JOIN for Unmatched records & JOIN fields from another table
Loop problem?
Num Lock turned off when using SendKeys
Importing emails into access.
Access to remote SQL server
ATTN MVPS - Sending Emails From Access
FindFirst with numeric field
Formula in Table
FileCopy command using FileDialog Box
DLookup
Working in the background
How to write a new entry in a combo box to its underlying table
using a array in access
Create a tmp table from recordset
Switchboard Size
Use a listbox to print different reports.
Cannot Convert Access 2002 DB To Access 2007
MSHFlexGrid
Can DoCmd.TransferDatabase be used to move table to BE
Auto-numbering a list
Uncheck Items in ListBox.
Problem with Yes/No DataType. Also, Split a DB. How?
Prefill Coding Error
Stack Trace in VBA?
Docmd.TransferDatabase where relationships exist
Send Email without operator intervention
how to create project .adp in Access 2007 or 2010 using SQLServer
ODBC Connection & auto-login
Insert Into error
Best way to deal with record-locking conflicts
Error 3001 recordset find sql
Renaming a file using an input form
Combo Box with NotInList procedure not working
Password Characters such as "*"