Microsoft Access VBA Modules [Archive] - Page 10

Access 2007 standalone
password program
Problem with the OnClick event of the datasheet part of a split fo
Custom Function to return array
Macro doesn't exist
Run .sql Script
Field Math
ViewEvent
Using Outlook from Access
API Call
filtering
Access 2003 Asset Tracking Database
Combo to save last used value
Hunting for the check digit scheme
Convert Excel Sheet to Table
Further VBA code to solve this situation
How to send message from OutLook Express 6 from Access
Add record from each entry in table for each user in another table
Access query sum buy column
Find values to right of decimal place
Do loop syntax
Problem w/SQL Statement in VBA Module
Disable Application Close Button in Access 2003
RE: "And" & "Or" function VBA syntax question:
RE: "And" & "Or" function VBA syntax question:
Re: "And" & "Or" function VBA syntax question:
Re: "And" & "Or" function VBA syntax question:
Input Directly to Table
How create report controls at runtime (VBA)
not null
Export to Excel in different tabs
open by macro accdc database Access 2007
Listview in VBA
VBA/Jet Error handling
Deleting Records from recordset
Populating HTML file with data from table
open not as readonly
Tabbed Form Record Lookup
How to suggest entering a Monday Date
Visual Basic question for if then statement
change active window
record loss in table
How to tell if a field has a value
Shift key bypass not working
Copy table structure in Access 2000
list box question
Re: Email current record
Simple list box question
Need report group header code alterantive to this:
How to trim a record when using DB_OPEN_TABLE
Disable Access 2007 close button at upper right corner
Specify SenderEmailAccount in VBA
Access 2003 on Vista x64
Code not OK with Set Temp Var or Set Value but is OK with MsgBox
Timer
using a buttom to add products to an invoice
Multiuser Interface on shared servicer with SQL Backend
Cascading lists continued
Calculating Business days due date
Problem with disappearing index in a table
code to create Box x of xx
disabled ribbon in access 2007 runtime
Splitting a routine into parts
SUBFORM CODE IN VERSION 2003 AND 2007
Problem with common VBA functions when installing a new system
Creating Memory Dump (Advanced Topic)
Shutdown Computer from Access
Excel? Access?
Sending E-mails
Method or data member not found
External file deletion
Cascading lists
insert into syntax
Re: Capital
Re: Language for Tags
Window Control
Re: Capital
Capitalising first letter and lowercase all other in VBA
Custom shortcut Menu with a Popup Control showing data-driven item
Insert Statement Syntax
Recordset
Sendkeys not working in Access 2007
Reset Statusbar Text
Force Access to Reapply Format Conditions
RE: Arrange VBA CODE in Alpha Order
Localizing SQL Server Data
Search with Forms on Access XP
WHY use bookmarks?
RE: How can VBA tell whether the computer is being controlled through
PDF won't open
IF THEN ELSE CODE
Re: VBA for Path of Current MDB
Further advice on the code below
Access programming gone
sql quesry statements
how to select, rename, and save a file using Access VBA ?
query after insert fails
display word .doc in access
No object in MAPI control
Developing Access 2003 application using Access 2007
disable access form auto save temporarly
Hyperlink from Excel to Access
Re: VBA for Path of Current MDB
RE: VBA for Path of Current MDB
addfromoutlook
Error 3020 for VB: Update of CancelUpdate without AddNew or Edit?
Re: Criteria not met, do not want form to go any farther
SUBFORM CODE
Calculate based on two date fields, populate third which writed to
Return Query result to textbox
DCount multiple criteria (date range and text field)
Change recordsource of susequent subforms-TJ
In a report -Using a calculated field in Select Case causes Error
Access to Outlook Via Excel
Word Difficulty
Name AutoCorrect Save Failures
Parse Table Names from Query Def SQL
If Else Statement in VBA
Duplicating records in a form and subform (Allen Browne)
Setting Options in VB
use vba to create new code module in access 2007
Appending results of loop to a table
Drive path vs. Network Path S:\Shared\Folder vs. \\NETWORK\USER\FO
Trouble previewing report from Subform/Form
VBA script to send a filename (drive/path) and launch to play WMP
Sending email from access - Reference Stephen Lebans code
Word Document
Common ID for several tables
.FindFirst Method
mouse scroll and close
Possible to have each procedure called listed?
Condition not equal code..Help!!!
FindFirst Problem
Clear Form Filter
Query question
Access and Web Development
VBA Problem on Treeview
VBA Time
subform afterupdate error
Scheduling Hourly Import/Export
How to Execute shell comands in hidden mode?
Prevent users from using File/Print menu
Re: MS-Access Command Line Parameters
Front End connectivity to the network is always trouble
Tab control Integrity
Re: FTP Access DB to Web Server
Input mask & auto-tab
Rounding
How to change January 2008 to 1/1/2008
Expected End Statement
Microsoft 11.0 vs. 12.0 Object Library
If NotInList-Change Source
Function Using Select Case for Query
RE: Function codes in Expression Builder
Date Range for Report
appointment database
Custom Menus and Runtime Mode
Code to autmate run crystal report from access 2007
Forms Add, Edit or View
3078 error message
Test if other database is open
library not registered error when calling email from access
Displaying Excel Chart Legends and their VALUES/DATA using Access VBA
edit or insert ole object in application package
Problem filtering two fields to get an amount sum
"WHERE" clauses in DoCmd.OpenForm no longer working
Controlling the Access Window size
Problem with Chartspace in Access
Re: Reference Calculated Footer field
Checking for Data
Help with "dll" files.
Syntax Error on UPDATE statment
Have Adobe Acrobat 8 Standard - Need Access To Open Docs and ReSav
If Statement - whole number
Re: Need Help - Insert Into Statement not working but no error cod
Print 2 reports as one print document possible?
complex code
Change ODBC within MSAccess to point to a different instance
Referencing values from another table
Add Ins Problem
Help with Loop
Pass a variable through process
table Issue
Built-in string functions not availble
Loop without Do
Display error in distribution file but not development file?!?!?
Reference Field
Problem using Dcount
Re: Date coming is 12/31/1899
Re: How do I programmatically import a class module?
Date Picker Modification
Email Format Font
Send E-mail
time format question
Run 424 Error ON Visual Basic 6.0
How do I reference properties of sub-sub form from main form...
Problem with Access in Active Directory
Importing
RE: how to update table in sql 2005 from access opened form
Re: Application.CurrentProject.AllReports
Need Help | Rolling out new App. | Trouble with some computers.
If statement with select query
Desktop shortcut
Detect a form's window mode
Excel instance will not close
Combining multiple access tables into one
Manipulating .NotInList Event/Add Data to Combobox
subform problem
Re: iPhone
>> Open ODBC.ini
Delete all Records
Command Line for Backup
Re: Cleaning data - extracting Post Codes
Progress bar help please
Re: Import or Export
Printing an Access report using late binding
synchronization of Access 2003/SQL 2005
Array Compartments
Declaring a variable
Re: I need help with some code
Refresh control on form
Automatically check a box on a form using code
Re: Randomly Assignment
Table into Word
RE: Create multi criteria query
Re: Conditionally Close a Form
RE: Debugging
Create Code to have a table field formatted
RE: Reports & Object Dependencies
Field Update
Re: Null is my enemy....
Increase field by 10
RE: Mail merge using access
Re: Debugging Excel from Access
rsClone bookmark & beforeupdate error?
Run-time error '1004'
Access 2003, Determining which control has been clicked
Very Difficult Email report as PDF, record looping automation code
Loan Function
Copy table form BE database to BE database
VBA Performance in Access vs Excel
OPENING QUERY Causes error "System Resource Exceeded"
Re: Cleaning data - extracting Post Codes
Points Dimensions on a 3D Clustered Column Chart
combine tables
Help with Existing VBA code
add data from one table into other table
RUN TIME Error on Code that has ALWAYS worked before
Form Parameters in queries - and Web applications
Detecting a user disconnect
Columns: Down and Across Problems
Rename table and export
Access versus SQLServer
Duplicate logon to Access and SQL Server
Dialogbox VBA
Validation Rules
Run an Excel Macro from Access and return a variable
Go to 1st item in Listbox
Connect Linked Tables
Access 2007 crashes at Word .Find
Listbox Sideways
records beyond some limit
Re: Cleaning data - extracting Post Codes
link exe file in acces
Using Runtime version or /runtime command switch) as Security Meas
Button to cancel procedure?
Accessing a form object
Transferspreadsheet Range
Write Conflict dialog box
Printing query from form
Multiple Range TransferSpreadsheet
Field calculation in a subform
Need Help - How to do a "make table query" by code
Prevent Record Insert
Pausing a Function while it loads a form.
Less than Equal to?
Search a memo field
Help needed - Importing a table from on DB to another
Why do I receive no value error message, when parameters do have v
Form Timer Event
File names in a folder
Checking a queue
Application Error Messages with variables in the Description
Database Bloat
SubForms - Before Update Problem
Need to Normalize (Repost)
Need to Normalize (
Add new records
Print Generated Array
Format table rows
Runtime Error
Using Access Built-in Security with a Front End/Back End
Escape cancels DAO excute command - Prohibit?
How to create Word .doc, then save as attachment?
Auto Email Feature
VBA ? re: Saving Database File
Reset autonumber
Mail Merge Command Button
Ac2003 form Filter problem cannot find filter to remove it for goo
Rename table columns in Access 2000
Dynamic Connection
if find record
DoCmd.Transferspreadsheet - need help in determining Excel range
ODBC Timeout in RunSQL
Really need help with existing code?
Stop a Record form Inserting
cyber cafe management
Save Output to System Name - "A Different Harddrive"
Switchboard & functions
Copy an Excel Template to the Desktop
Normalization
Access 2007 Dictionary/Index
How do I display week numbers when the week runs Saturday to Frida
Database creation date
Outlook.Message object return type error "Type Unknown" Error. Bas
Can I do a lookup??
Error 2115 with cancel and undo?
Re: Count Instances of a word in a string of text
Re: Count Instances of a word in a string of text
Lookup form to select records
Go to Control / Set Focus
detect password protected mdb's
Need Help with SQL statement - "Insert Into"
Calendar/Appointment/Time-line View Control
sql strings
strSQL using Like "*"
Key Press
FMS Memo control
Help with Time Calculation
Stopping a Timer
Networking Access
Top of form alignment
Help needed - appending a record to a table then updating
Help need - How to tell if a file exist.
vendo piso madrid
Enterprise 2007 Access problem
Createfield - nominiating position
Starting a database from a Windows Script
Having a hardtime with time
Run Excel Module
Update query giving runtime error 3417 action query cannot be used
tags ?
Hide columns in the datasheet part of a split form
Using Environment Variables
Compact and Repair Alternative
Copy Paste - Subform
How to optimize a query called in code VBA
Re: Lotus Notes Email from Table
Conditional when has focus
OLE Object
Exclusive use- ? coding issue?
I NEED HELP WITH SUMMARY OF TWO (2) TABLE COMBINING INFORMATION
Trouble with 'Not In'
Single Front End with multiple Back Ends
RE: Add Sequential numbers
Array Help
Print a PDF File in VBA Code
Assign different sized arrays
Time Problem
How to Solve Update or Cancel Update Without Addnew or Edit Error
Parse a string
cascading combo box
Generate ASP Code to Display Records on Localhost/Web
Xcopy not working
How can I extract the address from and implrted hyperlink
Access, VBA, Date Modified
Wall Street Office
Type Mismatch Error: New to access programming
Load Images into SQL2005 backend
Upload to web or package application
Expected Array error during complie
Automatically open a form
Mulitple Me!'s
Did not receive email via CDO.message
Error 3061: Too few parameters. Expected 1
Re: vba TO IMPORT FOXPRO dbfs or just replace table in 2003
Combination of Invoices from Paid Amount
Reporting on multiple tables
How specify "currrent field" for DoCmd.FindRecord ?
Conditional Statement Syntax
Getting Default Value
Time Isue again
Kens API and diff applications
Variable value from query
Read a field value without making its record current?
Open explorer and filter file selection
Send objects Asian scripts error????
RE: Cannot update DAO Recordset
followhyperlink - hyperlink harmful message - RE 490: Cannot open.
query prompts in run-time Access 2007
Referencing a field programmatically
Return Value From Recordset - Using Variable as Field Name
ahtCommonFileOpenSave
Re: Cannot update DAO Recordset
DBEngine.CompactDatabase vs Compact on Close
Re: MS-Access Error Reference
Report Sort Order
Design View Close Event
Object Invalid or no longer set (3420) error refreshing links
Event when Access table is accessed through ODBC ?
dbSeeChanges with SQL linked tables
Need help automating a manual process
Re: How to make Subdirectory using OutputTo for Snapshot files fromrecordset
.zip files
ToggleButton issue
Change Path Name for Outlook Linked Table
Control printing at a page break
Open a file mdb with a password
followHyperlink
open explorer with filter from access
Insert a break/debug point to suspend app execution
Send an e-mail from my contacts form
QueryDef is a user-defined type?
IMPORTING TO 2 DIFFERENT ACCESS TABLES
LIKE in SQL and substring
Question in form
Equipment Rental Database Access 2003
Report with blank
List Report is Different Database
Event Procedure Update txtbox
Date Formatting
How to have code run only for those with permissions
combo box display - Width vs. ListWidth
Storing Data In Access for Use in Excel/Graphing
How to purchase Access 97
Form Fields Active or not
How do I eliminate double error messages
Runtime e-mail still displays "Send on Behalf" Message
Finding name of last query run in VBA code
Distinct event properties from format, data and others (vba)
Tab Form with multiple forms
DOCUMENTS.
Local Data, Global Users
Looping Through Recordset - Problem updating records
Saveas method for word document fails
Can I export a type from class library with late binding?
RE: Date/Time Picker
Comparing a field in one table against multiple fields in another
Run query from external program
Corrupted class code
Combo Box Value List
From FoxPro/VFP to Access
Where used
_fdopen()
bookmark - runtime error "3420"
Own a small business you want people to know about? Got a service youcan offer? or got something to sell?
Access 2003 to 2007 issue - double-click behaves differently
Information sort on ODBC
Re: Recordset is not filtering Report- version 2
Toggle system objects
Number datatype format to 'Standard'
Do Transactions guard against corruption?
"OpenDataSource method" error
Select count(*) does not work from code
RE: Problem with OutputTo Snapshot
RE: Problem with OutputTo Snapshot
resizing images in code
Re: Undefined function in expression
Trying Ken's API file dialog for first time
linking 2 tables causes read only issue
close Print Preview causes form to open in full window
Diary Notes Date/Time
What is the best web based front end for SQL Server?
Report Detail Event - How can I tell (from within VBA) that I'm onthe last record.
Linked Tables - How to Close External Database?
time issues
Rounding of time
Open Outlook Calendar from Access
password program
import multiple text files using VBA - For Next or do until...
Using a subform twice on the same form
Change a MenuBar at Runtime
Autokeys Not Fuctuioning
Access 2007 Certificate
onload Change columns shown
SQL in vba failing for 'lock violation'
Rate Customers by Invoiced this Year Field
Automatic Procedure - Email
Executing a string
SetFocus after MsgBox vbOKOnly - Then Exit Sub
Open specific recordset via external link?
Where are the Access object bitmaps stored?
Image from previous record is being displayed
How to apply interest to balance in accounts
Re: Running same query for each diff value in a table field (loop arecordset?)
Re: runsql to propogate value in report textbox?
Export using strSQL
Log-in Screen with Password Database
TEXT FORMAT IN BODY OF EMAIL USING SENDOBJECT
How do I create a new query in VBA and save it to an Access Db?
Re: Undefined function in expression
Conditional forms
Search a linked table
Re: Make Range
Update with Do Until rsTable.EOF allways leave one record "behind"
Help with code to "blank" reports
Email and Fax a Report
Record sequence problem on Import
Join expression not supported - works in MA scces but not via ADO
Email Report as PDF
Multiple Combo Box Selection
FTPGetFile strange problem
Function to count date occurrences
Input a spreadsheet name
ODBC Problem
SQL statement doesn't work in VBA.
VBA Add-In to Automatically Insert Text into New Subs/Functions
(SIGH!) Problem with Outlook Contact.EntryID is back!
Creating a User Object
Looping Constantly
>> local SQLExpresss list
Am I using the Replace function properly
Insert Text
Why does DoCmd.OpenForm cause bouncing
DLookUp Default Value
Exit Sub before End If
Programming/Development in Office '07
Help with updateing Hyperlinks
Make field required
Issues with using .AddNew directly on a Form's Recordset
New to Access, have a table question
Allen Browne Calendar Error
Open 2007 Access DB from inside Access DB?
Converting a Signed Overpunch value to a number
How many useful days has a month?
Record to Report to Word
Replace data in all tables
make .mde file from a remote db
Spell check of form and subform
Loop through files on FTP location
Copy selected files
Recordset.AddNew in subform causes Autonumber to Skip
create a variable in vba with sql code
Formula within a table
Re: VBA converts exclamation to dollar in TransferSpreadsheet Export
dynamic crosstab report with groupfooter totals
Re: Export table in to multipe text files
Database security
Start up dialog
Insert data into a table
Remove Preceeding Characters in table
Duplicate Warning Box
Show ASP Web Page to Others
Nobbie question about Me.
On Error
Login into URL
1004 error only after 1st run
Switching to mySQL
RE: VBA converts exclamation to dollar in TransferSpreadsheet Export
Update Query?
Blank Form
Suppress CREATE TABLE
Accessing SQL code in a query
subform prob
DLookup code for auto-populating a control on a form
how do I register dXSBar.dll using package Solution Wizard?
Object Library Not Support
User of application choose what type of labels they have then gen
automating access to excel to finished product
Opening/Linking to (user-level) secured db from unsecured db in VB
Re: Redundancy Preventative
Return a formula to use in query
DoCmd line to save an .xls as .csv
>> List of servers
Re: HELP! does access has limit in back out data?
how can I make a runtime version of an access database that uses o
"like" and "not like" comparison
Which references should I check?
Make field Required
Can I use Java in Access
Auto assign Member to tasks
Difficulties programming a command button
Create new record
Comandos SQL no MS Access
If no e-mail address present
Debug/Step mode in macro/VBA
ODBC information from Excel
Access Calcuulate avg number of days
VBA : How 2 ... "la suite"
Db Link via code (Klatuu Help)
Select a special printer by VBA code
Field only shows if data exists (Report)
Calculate the average number of days (Access data base)
VBA : how to concatene a list of mails from a form
link to word no longer working
Creating a Cost Report
Check box
display query result on subform
Store Data Temporarily
Close one mdb open another
Scrollbar width
Create new record from code in Access 2000
Merge many Word docs into one (for printing as a batch)
Paragraph Format from Word in Memo Field
Need Ideas
Access 2007 data types supporting multiple values
Use current date to save archival import source file Access 2007
Holy Cow!!!!
Delete Table in Another Database
Hiding The Hourglass
runtime error 3125 invalid name
On Close
Inserting a hyperlink in the body of a meeting request
RE: Event when Backend is activated/ldb
Date Modified/Time Stamp
Syntax for DCount Code
Hide Cursor
RE: Event when Backend is activated/ldb
Date + Time Problem
ACREDITE FUNCIONA!!!!!
Online Hosting
Add 1 to Text File
Creating a look up field
Subform datasheet not working
Re: Is Outlook Running?
Resume Next versus GoTo
Calculating with several fields
Sendobject; invalid email address error
How do I change the default Connection Timeout in Access 2007
RE: Making an ASCII file
Re: I have a real simple one
Creating Records in New Table Using a Loop
access a control few layers down...
424 Error - Input box to Report
Copy / Past - From a form to a subform
Runtime error 2448
Object invalid or no longer set error involving database object. H
Sending meeting request from Access (2003 version)
Excel workbook with advanced adds
Re: DLookup
Apply Sequence Number in Append Query
Access-Outlook Integration Sub Group
Cannot iterate through the items in custom class collection (NewEnum())
Convert CombineChildRecord code from DAO to ADO?
Immediate Window will not Open
RE: Filtering form
Importing Excel Files to Aceess 2003 table with Descriptive header
Problem handling VBA events using VB.Net
My form pages change size
Percentage calculation problem
Percentage calculation problem
Bound Control
Getting Excel function results to Access
Need to get Database Window visible again...
VBA Question
Checking Linked Tables
Modifications are slow
Running process in the Background
FTP files in directory
Writing info to TWO tables at the same time.
refresk linked tables from code in 2007
OpenForm action canceled - Error 2501 on English Windows plus Chin
run time error 3061
Run-time error '1004'
Report Does Not Exist
Managed Add-In Walk Through Problem
if then msgbox
Date Validation - First 7 days of the month
Set rst = db.OpenRecordset(sSQL)
Refreshing PivotChart
Error 2220 and SharePoint Lists
Coded SQL into Query View?
Error 3131
Reflect Control Source Change via VBA
Minimize button action
Refreshing PivotChart through ListBox
Re: import excel spreadsheet convert to text then trim
Rich Text from MS Access 2007 to MS Word 2007
Open specific outlook contact item from Access
multiple printers
Re: Is there a way to tell if a certain Access application or instance is open?
How can I get sendObject to open Outlook instead of Outlook Expres
set text box value to result of query
Is it possible to use multiple recordset objects in a query?
Rounded textbox/label, circle control?
Re: Create TBL SQL error
IF statement with array
Access 2007 - Recordset not updateable after splitting
Classes and Collections
Address Email
Question on this code
Run VBA Code From a Textbox
THIS IS MAKING ME CRAZY!
How do I disable the Access Application Close button in 2007.
Do..While loop error handling
Re: After Update on combo confusing me
How to open a file in its default application using VBA.
calculate time to complete application
problem with Pictures database !
How do I populate current date based on another fields output?
Non Standard File Extension In Access 2007
Can I Suppress Write Conflict Message?
go to last record meeting criteria
Needs help with expression
Storing and retrieving a .xsl file from Access
Delete a word document from Access
Multiple criteria from a form
updating table after sort
Adding a new field to table
access runtime deployment
Number of Pages in a Report Section
VBA Question
compact on close
Passing parameters to a report...
No Duplicates (overwrite)
Loop: Import data while giving each row a running number(1,2,3 ...
Selecting specific record
"." changes to "#" in Access VBA DoCmd.TransferText call
order by calculated text box
Loop Through Files
network disconnect solution
time issue again
Greyed out button if record =0
Button1=previous record. Push Button on record zero=CRASH
RunTime error 459 on current with database 2007 & 2002 conversion
Re: Append query
Format Date
Master Table for Import only
Re: copy structure only
Help! "Out of Memory" errors with Appointments created from Acces
sqlStmt problem
System Tray
Backup in Ms Access
Attachments. Way to disable the default action?
Open table to specific record
Record sound
VBA Function that outputs a criterion for a query
Access Reports - Word Wrapping in a Text Box
Export Access Table and format it in Excel
DoCmd.CopyObject method using variables
Automatically Attach an Excel File to an Email
Re: VBA References
Formating a string to fit the page
DAO Workspace in Access 2007
microsoft word microsoft access
A really quick question
Selecting the entire field after setting focus to it
Writing to position x, y in a text file
combobox selection field fill
DoCmd.Transferspreadsheet - Data definition
Time issue
Remove characters from end of string
pull data from Access into Excel VBA function, return answer to Excel
Sending email from Access
If statement with wildcard
Best way to create dynamic shipping labels?
access 2007 ribbon - disable button on click
search code
Review/thoughts and tips of my Algorithm/ Code?
Hide/Reveal ribbons with VBA