Microsoft Access VBA Modules

Help with code
Basic Function Not Defined
List Box with Record Count
get sheet names
How to get a query to understand a field is a number
Access Crashes When Trying To Compile
SQL Query and Parameters
Primary Key Value
Blocking User Access To App
Outlook Attachments via Recordset
Static and Global Variables
Directory & File names with spaces - brackets usage
the solution you mentioned you were going to put up herein this thread<df3dc6b4-eeb8-4c7b-a15c-83d3656982dc@z17g2000hsg.googlegroups.com>
Another question about your suggestion for creating aQBF<df3dc6b4-eeb8-4c7b-a15c-83d3656982dc@z17g2000hsg.googlegroups.com>
Sum of a field from Crosstab Query
Listing tables from different DB
Code to print to PDF & cycle until EOF
Appending individual dates using a date range
Auto distribute / user login
Call own HELP Function
server object error
data into vba
Excel Export
Convert compressed AVI to WMV
OpenRecordset fails Error 3061 too few params expected 12
Me.recordsetclone.findfirst
Using a variable in Access 2000
Applyfilter issue
Always Round Down
Re: Method or data member not found
Math calculations
ticker tape like continuous display
polling hardware serial numbers?
Need help processing text file.
polling hardware serial numbers (techical answers only please)
Photo Metadata
Need code to delete linked WSS lists and relink
Project is unviewable
Print PDF Reports Filename & Specify A Path
Automatically cycle through a list of Parameters
Importing spreadsheets in Access 2000
Killer Query of max and min ranges
Call ConvertReportToPDF
Re: treeview difficulties
import from excel with data validation
RE: treeview difficulties
Setting VBA Options Via Code
Excel records scramble after import to Access 2000
uplad file with access
Re: treeview difficulties
Maximum Date Created
graph in Access
automatic time out
Send Email when new record is added
Need to convert multiple columns into 1 colum in MS Access table
The Database is Read only When it is not (self lockout)
List box Set Focus off?
Auto numbering for primary key
Updating an Access database using PDF forms
VBA Shell and Saving
Question about db deployment
If IsNull DLookup Else Use this Field
Subform Navigation
Function to Count the number of times a button is clicked
Modify Linked SQL table in Acess via VBA code
ConvertReportToPDF - Someone Help Please!!!
set warnings is disabling my code
Re: Generate a Call Log numer
Debugger not stopping at breakpoint
Multiple access reports into one pdf file
ISAM Error
IE automation question
listing all table names
Change Table Property Description with VBA
MDIMain and Form Containting user control
Windows 2003 Fax Service: FaxComEx.FaxDocument.ConnectedSubmit :Access Denied when not an Admin
Building SQL Statement from Listbox
RE: Exporting Report to Excel
RE: Exporting Report to Excel
Code Not Working For Deleting All Linked Tables
Re: determine whether a pdf file is being viewed using vba
impoting Access Data to Excel
Coding for TransferSpreadsheet
Counting Excel file records from Access 2000
Using variables with RunSQL method
SQL retValue(.....,....,....)
Linked Files
Type Mismatch Error using Stephen Lebans' modCalendar Control
Configure print setting forqueries and reports using VBA in access
missing operand?
returning more than one variable on Call retValue()
Re: Calculated Field Questions
Access Book
RE: Calculated Field Questions
Open in Design View
Automated File Creation
Creating a recordset
Add an Index to all fields
Microsoft Graph Chart issue in Access2007
Macro blocks distributed DB
Get Field Values from Multiple records on a Form
Median in Report
Calculation help Please!!!
Changing a DLL reference programmatically?
File Dialog
Problem securing my DB *7142008
Capture text being entered in another application
Question For Danny Seager
Database Issue
Working with Excel objects from Access
Access VBA Not Saving Excel
Please Help Me to find Good Access 2002 book
Windows 2003 Fax Service: FaxComEx.FaxDocument.ConnectedSubmit :Access Denied when not an Admin on Service Server
Listbox value as criteria in Query
Please help me for this matter (One Date and More records)
Calculating Date/Time Fields
Converting and summarizing GB to MB to KB
Why getting "You dont have exclusive access to the db at this time
ConvertReportToPDF not Distinguishing Between Schools
Programming Asst. Needed - Check Box
VBA - Sending Multiple Attachments to Outlook message
Find the definition of code in Access 2003
Need a code where file only opens if user is f.e "john"*7152008
Send data to excel and format the spreadsheet automatically
Populating field based on comparison of two lists
Fill combo with Excel sheet names
Help with If Statement
duplicate records
Auto-restart Access app
Problems with Date
Pivot table in Access 2007 - is it the OWC, and is licensing the same?
Page Numbering in Access Reports
Dropping a table from a report
Checking the current date against a range of dates
sharing database
Copy from Access reprot(chart) to word
AddNew and UpdateBatch in ADO
value based on another control
QueryDef Headache
Check box creates a new record when clicked??? Huh???
Crystal reports
run-time error 3075 - help
Import Directory Files Names to Table
Can't seem to add null field using .addnew
RE: SQL "Where" issue
Sum in Subform Not Showing Up in Main Form
Accessing accdb files from Excel 2003
Selecting which record Combo box will display
Listing hidden tables
Requery info on one form when second form changed
YES/NO values - HELP!
language issue with DoCmd.TransferDatabase
ODBC Connection
Production Days
Listing DSN`s in the system
Monthly Auto backup or Zip
Monthly Backup System for Ms Access
Problem with DSum
Have date from form as query criteria
Math calculation in query
retrieving data from last entry AfterInsert
forms don't show up in in VBE
Hide/Reveal ribbons with VBA
Review/thoughts and tips of my Algorithm/ Code?
search code
access 2007 ribbon - disable button on click
Best way to create dynamic shipping labels?
If statement with wildcard
Sending email from Access
pull data from Access into Excel VBA function, return answer to Excel
Remove characters from end of string
Time issue
DoCmd.Transferspreadsheet - Data definition
combobox selection field fill
Writing to position x, y in a text file
Selecting the entire field after setting focus to it
A really quick question
microsoft word microsoft access
DAO Workspace in Access 2007
Formating a string to fit the page
Re: VBA References
Automatically Attach an Excel File to an Email
DoCmd.CopyObject method using variables
Export Access Table and format it in Excel
Access Reports - Word Wrapping in a Text Box
VBA Function that outputs a criterion for a query
Record sound
Open table to specific record
Attachments. Way to disable the default action?
Backup in Ms Access
System Tray
sqlStmt problem
Help! "Out of Memory" errors with Appointments created from Acces
Re: copy structure only
Master Table for Import only
Format Date
Re: Append query
RunTime error 459 on current with database 2007 & 2002 conversion
Button1=previous record. Push Button on record zero=CRASH
Greyed out button if record =0
time issue again
network disconnect solution
Loop Through Files
order by calculated text box
"." changes to "#" in Access VBA DoCmd.TransferText call
Selecting specific record
Loop: Import data while giving each row a running number(1,2,3 ...
No Duplicates (overwrite)
Passing parameters to a report...
compact on close
VBA Question
Number of Pages in a Report Section
Adding a new field to table
access runtime deployment
updating table after sort
Multiple criteria from a form
Delete a word document from Access
Storing and retrieving a .xsl file from Access
Needs help with expression
go to last record meeting criteria
Can I Suppress Write Conflict Message?
Non Standard File Extension In Access 2007
How do I populate current date based on another fields output?
problem with Pictures database !
calculate time to complete application
How to open a file in its default application using VBA.
Re: After Update on combo confusing me
Do..While loop error handling
How do I disable the Access Application Close button in 2007.
THIS IS MAKING ME CRAZY!
Run VBA Code From a Textbox
Question on this code
Address Email
Classes and Collections
Access 2007 - Recordset not updateable after splitting
IF statement with array
Re: Create TBL SQL error
Rounded textbox/label, circle control?
Is it possible to use multiple recordset objects in a query?
set text box value to result of query
How can I get sendObject to open Outlook instead of Outlook Expres
Re: Is there a way to tell if a certain Access application or instance is open?
multiple printers
Open specific outlook contact item from Access
Rich Text from MS Access 2007 to MS Word 2007
Re: import excel spreadsheet convert to text then trim
Refreshing PivotChart through ListBox
Minimize button action
Reflect Control Source Change via VBA
Error 3131
Coded SQL into Query View?
Error 2220 and SharePoint Lists
Refreshing PivotChart
Set rst = db.OpenRecordset(sSQL)
Date Validation - First 7 days of the month
if then msgbox
Managed Add-In Walk Through Problem
Report Does Not Exist
Run-time error '1004'
run time error 3061
OpenForm action canceled - Error 2501 on English Windows plus Chin
refresk linked tables from code in 2007
Writing info to TWO tables at the same time.
FTP files in directory
Running process in the Background
Modifications are slow
Checking Linked Tables
VBA Question
Need to get Database Window visible again...
Getting Excel function results to Access
Bound Control
Percentage calculation problem
Percentage calculation problem
My form pages change size
Problem handling VBA events using VB.Net
Importing Excel Files to Aceess 2003 table with Descriptive header
RE: Filtering form
Immediate Window will not Open
Convert CombineChildRecord code from DAO to ADO?
Cannot iterate through the items in custom class collection (NewEnum())
Access-Outlook Integration Sub Group
Apply Sequence Number in Append Query
Re: DLookup
Excel workbook with advanced adds
Sending meeting request from Access (2003 version)
Object invalid or no longer set error involving database object. H
Runtime error 2448
Copy / Past - From a form to a subform
424 Error - Input box to Report
access a control few layers down...
Creating Records in New Table Using a Loop
Re: I have a real simple one
RE: Making an ASCII file
How do I change the default Connection Timeout in Access 2007
Sendobject; invalid email address error
Calculating with several fields
Resume Next versus GoTo
Re: Is Outlook Running?
Subform datasheet not working
Creating a look up field
Add 1 to Text File
Online Hosting
ACREDITE FUNCIONA!!!!!
Date + Time Problem
RE: Event when Backend is activated/ldb
Hide Cursor
Syntax for DCount Code
Date Modified/Time Stamp
RE: Event when Backend is activated/ldb
Inserting a hyperlink in the body of a meeting request
On Close
runtime error 3125 invalid name
Hiding The Hourglass
Delete Table in Another Database
Holy Cow!!!!
Use current date to save archival import source file Access 2007
Access 2007 data types supporting multiple values
Need Ideas
Paragraph Format from Word in Memo Field
Merge many Word docs into one (for printing as a batch)
Create new record from code in Access 2000
Scrollbar width
Close one mdb open another
Store Data Temporarily
display query result on subform
Check box
Creating a Cost Report
link to word no longer working
VBA : how to concatene a list of mails from a form
Calculate the average number of days (Access data base)
Field only shows if data exists (Report)
Select a special printer by VBA code
Db Link via code (Klatuu Help)
VBA : How 2 ... "la suite"
Access Calcuulate avg number of days
ODBC information from Excel
Debug/Step mode in macro/VBA
If no e-mail address present
Comandos SQL no MS Access
Create new record
Difficulties programming a command button
Auto assign Member to tasks
Can I use Java in Access
Make field Required
Which references should I check?
"like" and "not like" comparison
how can I make a runtime version of an access database that uses o
Re: HELP! does access has limit in back out data?
>> List of servers
DoCmd line to save an .xls as .csv
Return a formula to use in query
Re: Redundancy Preventative
Opening/Linking to (user-level) secured db from unsecured db in VB
automating access to excel to finished product
User of application choose what type of labels they have then gen
Object Library Not Support
how do I register dXSBar.dll using package Solution Wizard?
DLookup code for auto-populating a control on a form
subform prob
Accessing SQL code in a query
Suppress CREATE TABLE
Blank Form
Update Query?
RE: VBA converts exclamation to dollar in TransferSpreadsheet Export
Switching to mySQL
1004 error only after 1st run
Login into URL
On Error
Nobbie question about Me.
Show ASP Web Page to Others
Duplicate Warning Box
Remove Preceeding Characters in table
Insert data into a table
Start up dialog
Database security
Re: Export table in to multipe text files
dynamic crosstab report with groupfooter totals
Re: VBA converts exclamation to dollar in TransferSpreadsheet Export
Formula within a table
create a variable in vba with sql code
Recordset.AddNew in subform causes Autonumber to Skip
Copy selected files
Loop through files on FTP location
Spell check of form and subform
make .mde file from a remote db
Replace data in all tables
Record to Report to Word
How many useful days has a month?
Converting a Signed Overpunch value to a number
Open 2007 Access DB from inside Access DB?
Allen Browne Calendar Error
New to Access, have a table question
Issues with using .AddNew directly on a Form's Recordset
Make field required
Help with updateing Hyperlinks
Programming/Development in Office '07
Exit Sub before End If
DLookUp Default Value
Why does DoCmd.OpenForm cause bouncing
Insert Text
Am I using the Replace function properly
>> local SQLExpresss list
Looping Constantly
Creating a User Object
(SIGH!) Problem with Outlook Contact.EntryID is back!
VBA Add-In to Automatically Insert Text into New Subs/Functions
SQL statement doesn't work in VBA.
ODBC Problem
Input a spreadsheet name
Function to count date occurrences
FTPGetFile strange problem
Multiple Combo Box Selection
Email Report as PDF
Join expression not supported - works in MA scces but not via ADO
Record sequence problem on Import
Email and Fax a Report
Help with code to "blank" reports
Update with Do Until rsTable.EOF allways leave one record "behind"
Re: Make Range
Search a linked table
Conditional forms
Re: Undefined function in expression
How do I create a new query in VBA and save it to an Access Db?
TEXT FORMAT IN BODY OF EMAIL USING SENDOBJECT
Log-in Screen with Password Database
Export using strSQL
Re: runsql to propogate value in report textbox?
Re: Running same query for each diff value in a table field (loop arecordset?)
How to apply interest to balance in accounts
Image from previous record is being displayed
Where are the Access object bitmaps stored?
Open specific recordset via external link?
SetFocus after MsgBox vbOKOnly - Then Exit Sub
Executing a string
Automatic Procedure - Email
Rate Customers by Invoiced this Year Field
SQL in vba failing for 'lock violation'
onload Change columns shown
Access 2007 Certificate
Autokeys Not Fuctuioning
Change a MenuBar at Runtime
Using a subform twice on the same form
import multiple text files using VBA - For Next or do until...
password program
Open Outlook Calendar from Access
Rounding of time
time issues
Linked Tables - How to Close External Database?
Report Detail Event - How can I tell (from within VBA) that I'm onthe last record.
What is the best web based front end for SQL Server?
Diary Notes Date/Time
close Print Preview causes form to open in full window
linking 2 tables causes read only issue
Trying Ken's API file dialog for first time
Re: Undefined function in expression
resizing images in code
RE: Problem with OutputTo Snapshot
RE: Problem with OutputTo Snapshot
Select count(*) does not work from code
"OpenDataSource method" error
Do Transactions guard against corruption?
Number datatype format to 'Standard'
Toggle system objects
Re: Recordset is not filtering Report- version 2
Information sort on ODBC
Access 2003 to 2007 issue - double-click behaves differently
Own a small business you want people to know about? Got a service youcan offer? or got something to sell?
bookmark - runtime error "3420"
_fdopen()
Where used
From FoxPro/VFP to Access
Combo Box Value List
Corrupted class code
Run query from external program
Comparing a field in one table against multiple fields in another
RE: Date/Time Picker
Can I export a type from class library with late binding?
Saveas method for word document fails
Looping Through Recordset - Problem updating records
Local Data, Global Users
DOCUMENTS.
Tab Form with multiple forms
Distinct event properties from format, data and others (vba)
Finding name of last query run in VBA code
Runtime e-mail still displays "Send on Behalf" Message
How do I eliminate double error messages
Form Fields Active or not
How to purchase Access 97
Storing Data In Access for Use in Excel/Graphing
combo box display - Width vs. ListWidth
How to have code run only for those with permissions
Date Formatting
Event Procedure Update txtbox
List Report is Different Database
Report with blank
Equipment Rental Database Access 2003
Question in form
LIKE in SQL and substring
IMPORTING TO 2 DIFFERENT ACCESS TABLES
QueryDef is a user-defined type?
Send an e-mail from my contacts form
Insert a break/debug point to suspend app execution
open explorer with filter from access
followHyperlink
Open a file mdb with a password
Control printing at a page break
Change Path Name for Outlook Linked Table
ToggleButton issue
.zip files
Re: How to make Subdirectory using OutputTo for Snapshot files fromrecordset
Need help automating a manual process
dbSeeChanges with SQL linked tables
Event when Access table is accessed through ODBC ?
Object Invalid or no longer set (3420) error refreshing links
Design View Close Event
Report Sort Order
Re: MS-Access Error Reference
DBEngine.CompactDatabase vs Compact on Close
Re: Cannot update DAO Recordset
ahtCommonFileOpenSave
Return Value From Recordset - Using Variable as Field Name
Referencing a field programmatically
query prompts in run-time Access 2007
followhyperlink - hyperlink harmful message - RE 490: Cannot open.
RE: Cannot update DAO Recordset
Send objects Asian scripts error????
Open explorer and filter file selection
Read a field value without making its record current?
Variable value from query
Kens API and diff applications
Time Isue again
Getting Default Value
Conditional Statement Syntax
How specify "currrent field" for DoCmd.FindRecord ?
Reporting on multiple tables
Combination of Invoices from Paid Amount
Re: vba TO IMPORT FOXPRO dbfs or just replace table in 2003
Error 3061: Too few parameters. Expected 1
Did not receive email via CDO.message
Mulitple Me!'s
Automatically open a form
Expected Array error during complie
Upload to web or package application
Load Images into SQL2005 backend
Type Mismatch Error: New to access programming
Wall Street Office
Access, VBA, Date Modified
How can I extract the address from and implrted hyperlink
Xcopy not working
Generate ASP Code to Display Records on Localhost/Web
cascading combo box
Parse a string
How to Solve Update or Cancel Update Without Addnew or Edit Error
Time Problem
Assign different sized arrays
Print a PDF File in VBA Code
Array Help
RE: Add Sequential numbers
Single Front End with multiple Back Ends
Trouble with 'Not In'
I NEED HELP WITH SUMMARY OF TWO (2) TABLE COMBINING INFORMATION
Exclusive use- ? coding issue?
OLE Object
Conditional when has focus
Re: Lotus Notes Email from Table
How to optimize a query called in code VBA
Copy Paste - Subform
Compact and Repair Alternative
Using Environment Variables
Hide columns in the datasheet part of a split form
tags ?
Update query giving runtime error 3417 action query cannot be used
Run Excel Module
Having a hardtime with time
Starting a database from a Windows Script
Createfield - nominiating position
Enterprise 2007 Access problem
vendo piso madrid
Help need - How to tell if a file exist.
Help needed - appending a record to a table then updating
Top of form alignment
Networking Access
Stopping a Timer
Help with Time Calculation
Key Press
FMS Memo control
strSQL using Like "*"
sql strings
Calendar/Appointment/Time-line View Control
Need Help with SQL statement - "Insert Into"
detect password protected mdb's
Go to Control / Set Focus
Lookup form to select records
Re: Count Instances of a word in a string of text
Re: Count Instances of a word in a string of text
Error 2115 with cancel and undo?
Can I do a lookup??
Outlook.Message object return type error "Type Unknown" Error. Bas
Database creation date
How do I display week numbers when the week runs Saturday to Frida
Access 2007 Dictionary/Index
Normalization
Copy an Excel Template to the Desktop
Switchboard & functions
Save Output to System Name - "A Different Harddrive"
Stop a Record form Inserting
cyber cafe management
Really need help with existing code?
ODBC Timeout in RunSQL
DoCmd.Transferspreadsheet - need help in determining Excel range
if find record
Dynamic Connection
Rename table columns in Access 2000
Ac2003 form Filter problem cannot find filter to remove it for goo
Mail Merge Command Button
Reset autonumber
VBA ? re: Saving Database File
Auto Email Feature
How to create Word .doc, then save as attachment?
Escape cancels DAO excute command - Prohibit?
Using Access Built-in Security with a Front End/Back End
Runtime Error
Format table rows
Print Generated Array
Add new records
Need to Normalize (
Need to Normalize (Repost)
SubForms - Before Update Problem
Database Bloat
Application Error Messages with variables in the Description
Checking a queue
File names in a folder
Form Timer Event
Why do I receive no value error message, when parameters do have v
Help needed - Importing a table from on DB to another
Search a memo field
Less than Equal to?
Pausing a Function while it loads a form.
Prevent Record Insert
Need Help - How to do a "make table query" by code
Field calculation in a subform
Multiple Range TransferSpreadsheet
Printing query from form
Write Conflict dialog box
Transferspreadsheet Range
Accessing a form object
Button to cancel procedure?
Using Runtime version or /runtime command switch) as Security Meas
link exe file in acces
Re: Cleaning data - extracting Post Codes
records beyond some limit
Listbox Sideways
Access 2007 crashes at Word .Find
Connect Linked Tables
Go to 1st item in Listbox
Run an Excel Macro from Access and return a variable
Validation Rules
Dialogbox VBA
Duplicate logon to Access and SQL Server
Access versus SQLServer
Rename table and export
Columns: Down and Across Problems
Detecting a user disconnect
Form Parameters in queries - and Web applications
RUN TIME Error on Code that has ALWAYS worked before
add data from one table into other table
Help with Existing VBA code
combine tables
Points Dimensions on a 3D Clustered Column Chart
Re: Cleaning data - extracting Post Codes
OPENING QUERY Causes error "System Resource Exceeded"
VBA Performance in Access vs Excel
Copy table form BE database to BE database
Loan Function
Very Difficult Email report as PDF, record looping automation code
Access 2003, Determining which control has been clicked
Run-time error '1004'
rsClone bookmark & beforeupdate error?
Re: Debugging Excel from Access
RE: Mail merge using access
Increase field by 10
Re: Null is my enemy....
Field Update
RE: Reports & Object Dependencies
Create Code to have a table field formatted
RE: Debugging
Re: Conditionally Close a Form
RE: Create multi criteria query
Table into Word
Re: Randomly Assignment
Automatically check a box on a form using code
Refresh control on form
Re: I need help with some code
Declaring a variable
Array Compartments
synchronization of Access 2003/SQL 2005
Printing an Access report using late binding
Re: Import or Export
Progress bar help please
Re: Cleaning data - extracting Post Codes
Command Line for Backup
Delete all Records
>> Open ODBC.ini
Re: iPhone
subform problem
Manipulating .NotInList Event/Add Data to Combobox
Combining multiple access tables into one
Excel instance will not close
Detect a form's window mode
Desktop shortcut
If statement with select query
Need Help | Rolling out new App. | Trouble with some computers.
Re: Application.CurrentProject.AllReports
RE: how to update table in sql 2005 from access opened form
Importing
Problem with Access in Active Directory
How do I reference properties of sub-sub form from main form...
Run 424 Error ON Visual Basic 6.0
time format question
Send E-mail
Email Format Font
Date Picker Modification
Re: How do I programmatically import a class module?
Re: Date coming is 12/31/1899
Problem using Dcount
Reference Field
Display error in distribution file but not development file?!?!?
Loop without Do
Built-in string functions not availble
table Issue
Pass a variable through process
Help with Loop
Add Ins Problem
Referencing values from another table
Change ODBC within MSAccess to point to a different instance
complex code
Print 2 reports as one print document possible?
Re: Need Help - Insert Into Statement not working but no error cod
If Statement - whole number
Have Adobe Acrobat 8 Standard - Need Access To Open Docs and ReSav
Syntax Error on UPDATE statment
Help with "dll" files.
Checking for Data
Re: Reference Calculated Footer field
Problem with Chartspace in Access
Controlling the Access Window size
"WHERE" clauses in DoCmd.OpenForm no longer working
Problem filtering two fields to get an amount sum
edit or insert ole object in application package
Displaying Excel Chart Legends and their VALUES/DATA using Access VBA