Microsoft Access VBA Modules [Archive] - Page 37

Delays and Printing
FindFirst, NoMatch problem
Actions Queries in ADO
Requery a subform using a command button
question on adding a Type to a Collection object
Function In SQL Problem
For Next Each??
Null results of a query
Excel pivot table automation
Excel pivot table automation
Loop Can't Find Value
download file from within Access
Filling a Textbox without a Query
Relationship help and other advice
Index and Seek
docmd.openreport where clause syntax
convert columns to rows?
Link Access to MS Outlook email attachments
Is Outlook Running?
Calendar Properties
consolidate a packing list
Concat with a return
Flag duplicate entries
RTF2 reference
Form Subform Problem
Proceeding to the "Next" value in the middle of a loop
Stored Precedure in ADP Proj.
hex2dec conversion using mscomm
filtering a string
Convert access 2000 to web aplication
A simple example of the use of transaction processing
w.INSERT a + Chr$(13) + Chr$(10)
Sum variant fields
Auto-restart
HELP! Bad excel layout import into Access
Tab Control and Recording Time
input
settin references to lib
send *.* files to outlook
date sql
advice for creating a database
Changing database path for linked table from VBA code
Automation - running code in one Access DB from another Access DB
restart autonumber from 1, programmatically
How do I use a custom control such as RTF control?
FileSystemObject No LongName
How do I bold one word inside a text box in a report?
send *.* files to outlook
Code to use a field as a Hyperlink
How to get Recalc to Work
subform instance
Code under report
Circular reference problems with class modules
ODBC access to businessworks
Re: SQL Server with Access question
transfer spreadsheet
pls i want wizard to help me to enable me send mail to another pe.
How to display intrinsic constant as literal instead of numeric
Find string in ControlSource
FIND RECORD IN ACCESS - Please Help
With rec Update problem
How do I insert Message in new Outlook email using command from A.
How to Use Recalc
Add table to query
why create index (non-primary)
Line feed in string
Import Text with existing schema.ini file utility
Call routine on subform
Using Option buttons to Select Days
why ".Bookmark = .LastModified"?
I'm looking for an electronic organiser within office
How to Use Recalc
Using automation from access to outlook to create an appointment item
Dynamic List Box for Printing/Previewing Reports
Open Web page with MS Access macro
Idenitfying the first time a database is run
access 97- error 3011 occurs after migrating from windows 95 to xp
Set AppTitle from VBA
between "global" and "public"
OWC Spreadsheet object in Office 2000 vs Office 2002
Value when Not In List
Password system
User intervention in BeforeUpdate
Like and Search String
Like and SearchString
Open Form To Last Record
Combine / Concatenate multiple tables into one
"Run-time error 430" when open on one computer, fine on other
Error Wend without While
Checking a record for record locking
In Access, I have added a "Yes/No" field to an existing database..
Getting "Error 5 Invalid procedure call or argument" message
Setup of chart in Access using module
delete autonumber field or append without it
access lookup field properties in code
Printing Reports
Output crossing over to other instances of Excel
no duplicate records if
Composite/combined query results
Access 2003 - Security and Warning
Create user in code
recordset form table
>> Open another database
Input buffer worked in Access 2000 but not in Access 2003. Why?
Return an autonumber field after adding a new record.
Where do I get an access template for random generating
import name range form Excel sheet via code??
table has wrong data type
Learning Access programming
Overcoming Length Problems
Repost: Printing file from MS Access
I need a script to lookup information table. In a Data Access Page
I need a script to lookup information table. In a Data Access Page
Use .NET controls in Access 2003?
Automation removing blanks in Word
Help with MSysObjects problem please..
text & date criteria
Send email from data access page(website)
Auditing changes in a table
adding data to a table in a subform
Query Errors
How To Convert Number Field To Time Field For Calculation?
count number of records of a particular type
Import Excel file in Access 2003
array in a message
writing data into excel cell
Programming to get object from database
Create Loop in Access
Too Few Parameters
Adding Data to a Table
Downloading Outlook Attachments
Visible property on Report
Determining Users on Linked backend Database
Conversion from Access 2000 to Access 2002
start VPN-Connection
Visualizing PDFs
Storing Dynamic SQL Results in a Text Box
How can I send an email notification after entering data in a data
Comma-delimited file
Error 438 With Access 2000
I
Search button in Data Access Pages???
Get file path and name
hide a public function, method in another DB
GAME ON THE GO N.Y.C.
transferspreadsheet is concatinationg, not replacing data
problem with connect property on upgrading to windows xp
formatting excel cell + vertical alignment
set input parameter & record source in vba
Relationships
Runtime error on Switch
missing references again/late binding
Word Merge From Access
Unrecognized Database Format
automatic synchronization
"compilation error: variable not defined"
Adding an Attachment to a Sharepoint List item using VBA
Seeing full path of references
Error 7878 The Data Has Changed
How can I GoToRecord in a List box?
cannot update or insert using DAO
Use a command button to navigate a subform
Creating mde files in 2003 don't run in 2002
Switch database in current Access 2003 application window
adding field to table index via VB
Get File Name and Path
Replicafilter problem
Performing calculations with empty records
No duplicate random numbers
Access Project Reports
Printing files using a 3rd Party program
Show Database window
missing reference
.ldb refresh?
ADO/ALTER TABLE problem
Weekday Dates
Printing Files from Within MS Access
Project Locked - Project is unviewable.
Problem w/VBA Code
ADO connection strings to Outlook
Event OnChange AfterUpdate not start when change in VBA
Create Appointment from Access
odbc
Code creating problems in runtime
Logon
In VBA, how can I check if the current form record is a new recor.
a compile error
Database during a limited period of time
Sending an Email in code
Check Transfettext
excel report
Using Visual Basic for MS Access 2003 in reports
when start
Db name
How to test for EOF
Command to open the CODE window
Using Call Shell code
FileSearch finding Shortcut entries
NEWBIE: please interpret help file: making table
Page Numbering in Reports
Time maths beyond 24:00
Move to Absolute Position in DAO
Access 2002 is giving "MSCOMCT2.OCX" error for Access 2000 versio.
Making a table read only
create e-mails
Advice on references to mde's
Why does "<>" not produce a 3021 error as does "=" in recordset
"field" is not an index?????
Help With Filtering Question
using VBA to print out lists of query tables and fields
Controlling a Word Mail Merge (from Access)
Item Not found in collection
Report Format
format function
Disabling Scroll Wheel when Access has Processing Focus
Running Code in a Report
How do I reference the active chartspace of a pivotchart in VBA?
variable
Route User ID to table/form?
MS ACCESS REPLICATION / SYNCHRONIZATION
Microsoft access Problem Please help
Date limit
SendObject and Lotus Notes
Determining if a table exists in a remote mdb
Dim db As DATABASE
Handling single quotes " ' " in data
Delete records from a table based on selecting in a list box
How do I access a local table using VB in a split database
Change field datatype code
Evaluating validationrule
Database Splitter
"date last modified" for table-content in ACCESS?
from access 97 to 2000
How can I store email responses in an access database?
Set Primary Key via VBA
Sub or Function not found quesiton
How to requery subform ... fully
Top 100 and Ties
3061 Error
How import a function in a module?
overiding windows pallet
How to find full path name to linked data
ADP - programming a subform
verify lock status of a record with VBA
Automatic Data Transfer
XSD - how to get it into Access
What constitutes a "large" front end?
Enumerating Option Group Controls
Hyperlink Opening Behaviour
AutoExec Macros
How to suppress query messages
Fast Linking of tables to a back end MDE
Cannot instantiate the client-side OLE DB provider for this page
Reports/Table of Contents
Leading Zero in code
Retrieve ftp file contents
Chart axis properties from VBA
Word Automation Problem
Popup Menù BackColor change
Font color a inputbox
Looping to identify tables
Is there a command to see if dir exists?
Msgbox
Windows 2000/XP/Error 2100
index for rst.seek
GetOpenFilename Equivalent
run excel macro from access
Auto Execute MS Access Macro with Windows Scheduler
Iterate through Field names
Table counts
Normalizing with VBA
One table vs 100+ tables
Opening office documents - minus application object
Snapshot using Redemption, emailing reports
Eval with DoCmd.Openform
Create Access relationships
Creating Access Application Setup Packages
Complex Tally Problem
How can I disable SHIFT+ENTER only for certain users in a MsAccess2002XP database?
Invalid Use of Null
How to Requery subform ... Fully
Adding a record to a table
DMax Problem
foxpro
Disable scroll button
link TIFF to form thru text or combo box
Age from Dob
Query into a stand alone file
How to parse data from one field to another
How to Link tables from an Oracle db to my Access db
Type access
passing parameter to stored procedure
Problem with setFocus
Please help
Re-ordering a Numeric Field
How do I set up sequential numbers instead of auto numbers in acc.
Control Import File Seqence
Findfirst in Access 2003
How to Requery Subform... fully
assigning incremental numbers - or getting new numbers
How to change report sort order at run-time in access 2002
Make a folder in a specfic directory
Data from many tables to one excel sheet
Access97-Insert Object
Reporting on nulls within a Database
computer has error msoe.dll no outlook or email
Auto execution
Write a variable to Win Clipboard?
TEXT data type length?
how do I find my fax option after I lost it?
how to make data entered
ComboBox
how do i 'insert into' a memo field?
Unable to run macro
Licensing question - MDB file accessed by VB app
Define a table as an array
TransferDatabase : Linking tables from Oracle produces error 2507
VBA in On Click Event Mystery
Creating a new record based on another table
MDB Grows and Grows
What is causing this --I&#8217
Fields in a table
Refresh one subform from another subform
Calendar Control Multi selection
TransferDatabase
How can i call the "insert Object" form ???
High processor utilization during save
How do i check to see if a certain cell is selected?
Access runs slowly for a while, then fast
How to requery Unbound subform based on List and Combo Box Filters
How to requery Unbound subform based on List and Combo Box Filters
Clearing date Field
Hopefully there's an easy answer - WHERE statement Question
How do I change a text data to numeric data?
Access wont permit database, recordset type
How can I display OLE object in a subform from main form
How to reinstall deleted maintenance wizard for windows 98
Change tab event
Adding up Percentage calculated series of numbers????
Chart axis
Argggg - Closing Excel
Make event fire after undo
Form opening/saving very slowly
Disable F9 key
Findfirst problem
Mix of DAO(VB3) and ADO(VB6) and Acc2.0 and Access2003 on XP SP2
pass parameter to subform
Replication / Invalid Data Format
MS Access 97 vs. XP/2003
Edit *.txt file programatically
Adding fields with a time format
Using graphics from a table on a form
Copying Table structure with TransferDatabase slow
Self-Sgned Digital Certificates...What Are They Good For?
ACCESS - Calulations - Please help
Inserting an OLE Image
ADP - Prevent SQL Errors
Filling report controls thru code
How do I auto populate fields in a form from information in anoth.
Form position on the screen
Why won't the validation message show?
crosstab queries and reports
Requery Combo Box Between Subforms
How to insert table into MS-WORD from MS-Access
Table Creating New Table Problems
Dynamic Query
Access + Packaging Wizard + Excel
Publishing Access Data Access pages
How to Open Subform in Access 2000... easily
Excel Macro from Access
calling a Access Outputto method from VB6 and passing a filter
Create a hyperlink in Lotus Notes
Using variable names for controls
Getting into Microsoft Word from Wordperfect
Date Query in Access Project
How to Open Sub in Access 2000
Deleting tables
Hlp file setup question
Append duplicates into table
AfterUpdate Event for a table
access 2003 OutputTo function and datasheets
Is there an Add-In for the VBA editor that configures the editor .
Is there an Add-In for the VBA editor that configures the editor .
How to open subform from main form... easily
Windows ME won't open Excel documents. Need right Excel program.
On click event
Scrolling OLE picture
Adding a date and ending up with the last day of the month
Re-Bound recordset to the form without closing it.
"General" Search Across All Tables
Hacker System f5
How to open subform in Access 2000....easily
How do you program add, find, find next, update, and delete comma.
Creating help files
Stop macro based on user-level security
Access VBA books
autofilling fields, when choosing selection from combo box
How to Create a Lookup for Record in a Subform (Not in Datasheet View)
Want to display the last syncronized time and/or date
Comparing two strings for % match
Running funtion during startup
cycle through a table
How do I close a database
Access 11 crash
Create an array from a table
Pushing data from Excel into Access?
Compact database from VBA
Copy/paste within Excel with Access code builder
Reading a form from OCR scanner into Access
skip weekends and holidays
Meaning of: VariableName = 0#
Menu
update of field or control
MSysDb ERROR MESSAGE
Question On Opening a DB
Change data in a table using code.
"start msaccess envforms.mdb /runtime" works only with office 97
Setting default wallpaper to email message generated from SendEven
Name Parsing
Create navigation to last used records
Open Excel & Loop thru wksh
SendObject Not Picking Up HTML Template File
Hacker System f5
Changing backcolor of MessageBox
Hacker System f5
Adding multiple selections in List box to a table
Search for 2 fields get one result
Altering the valus for autocorrect
Empty Recordset
Sample code to send SMS from Access to GSM Mobile phones
Print form to specific printer
Convert date format
Will not read If then statement on vbyes
How to adjust spreadsheets through Access?
I have 16 bits & need 32 bits to download.
stored procedure doesn't run properly in Access
Copy Character to text box
Exporting to Outlook
Hacker System f5
How can I alter the auto correction spelling option
How To Get Textbox on Report to Read All if Listbox Null
Full File Path
automatic shut down
Launching PDF file
How to Have Report TxtBox Read "All" if Nothing Chosen in Listbox
Database replication
Error 2465 after upgrading 2000 to 2002.
my power point show :error 1706. no valid source could be found .
Specifying DLL
Access 2003 Developer Extensions
second IF statement within the 1st
How to print "All" on report if listbox null
How to read a table record by record and process and update another table
The effect of Network rights on Access Apps
Non-error error
Need help in writing code for special project
string functions in SQL to capitalize first letter similar to Prop
Access 2000 VBA Programming Texts
Missing MAPIForms Library needed to make SendObject work
Missing MAPIForms Library needed to make SendObject work
REPOST HELP!! Missing Drivers
Nested Loops and Adding Records
How can I call an access header by using a variable
Hiding an object via code?
Recordsets, Manipulating a Table from a Module
Create Stored procedure Via ADO
Passing an Excel formula to a function
VBA with Access help?
Word problem
MS Word Printing Object problem
Event Procedure
Can't Register OCX
can't assign a value to this object
Removing Index using VBA
Selecting Printer and Drawer
how do i enable the internet connection sharing file?
Link problems
How do I drop an Access table from VB.NET?
Create Customer Appointment Calendar in Access
Print Number of Reocrds in a Table using VBA
using keyPress event to change field value and Fraction eval funct
how do i save aN ACCESS database as MDE
Forms and Subforms and More
How to copy tables in db1 to db2 from code in db3
CDO W/O A Server?
Error for record not found to report to user
Lost primary key
Snapshot failure
Add Appointments to Outlook
Temp tables & dev strategy (Access 2002)
For Without Next Error
C++ for read/write access database
long query
Trying to reach Albert Kalla's website
Continuos form
error referencing subform calculated totals (a timing issue)
ADP - Listbox rowsource from SPROC with Input Parms
Using Stored Procedure with Input Parameters for Listbox RowSource
a bug or an error?(date function)
Control not automatically picking up default value
I need to know which microsoft office has the spell check
I need to know which microsoft office has the spell check
Error with multiple users
To use addnew to add one or more records
Code Doesn't Work
string procedure
Multiselect listbox
Multiselect listbox
Module of Multiple Users
Selecting time frame and calculating off Now()
Not In List event - new value added but access 2002 says no
Re: Passing an Access parameter from shortcut or command line
How to export report into word format
Eliminating differences between in two ways of opening an application
Error trapping for "MS Access can't append all the records in the append query"
Existance of .LDB prevents Rename, File Copy, Repair/Compact
UPC Bar Code
Recursive Function - Just keep last result
Visible Property
Field Format.
Minutes to Hours
Autonumbering within a replicated set
Exporting to a text file Question
Compact another DB within a Code
Adding new record to a multiuser database and not locking databas.
Read MS SQL 2000 table with "dynamic" pass through query
Errors sending email from Access 2003, when dbase window is hidden
syntax help again
Abrir planilha a partir do access
Abrir planilha a partir do access
Excel Addin From Access
How do I set a specific bit in an integer
Security Challenge
VB Code for puting FileName for PDF
Mouse click event
Report formating related question
Prevent mouse scroll to new record
syntax question
how do my animated gif plays in acess 2003?
how to send e-mail
I am trying to open an access based application the system gives .
Hacker System f5
Merry Christmas
How to recover a corrupted DB (Access 2000)
Workflow
How do I set relationships in Access using VBA?
Manipulating custom menubar without MS Office xx Object Library reference
Sending a file by Access using Outlook
Copy form and paste to notepad
How to Inactivate Outlook Security Message when send email from Ac
Trying to create a Recordset , I get "Type Mismatch" - what's wro.
pass-through-queries
Quick Info/Parameter Info disappeared...
Records do not show in a form
SQL in Visual Basic is not working correctly
Re: Design protection
VB code says can't find Form
Design Protection
Export table1 from db1 to db2 from db3
Handling Null in DSum
How to read data from a file record by record process and update a table
password to VBA code in MS Access
Compile error, With use of Dim MinDb As Database
find records using form
Date and time calculaton
how do i synchronize across the internet
Editing a text file
Can I use the network path directly instead of the mapped path on
validation errors
dynamic email message body?
Hide/disable Close button
Advanced Validation / check entry + previos records is less than a
File required ?. C:\windows\system\vmm32.vxd
Stepping through code
Suggestions Please?!?
Changing Data Type ftom hyperlink to text back to hyperlink
User Group
Change the data type property of a field in a table
User Groups
I want to put a file name in a text field, then open that file by
I want to put a file name in a text field, then open that file by
External calls from Excel
Programming
Displaying emails on/from Access Forms
Re: DSum
Re: Vba DAO Recordset Parameter Query
printing multiple reports
Re: FAO Ken Snell - RefreshAll
Re: Speciel question
Re: Selection of a Printer
How do I display external files to a dropdown list?
Add 7 records
Bill of Material Processor
Number of connections to Access database
Conditional SQL syntax
Conditional SQL syntax????
Calculating Multiple Checkboxes with If Statements
Help with module
Access 2003 & Rich Text Fields
**VBA Code Help Please!!!**
Opening a database when closing another
Email error
Sorting a form
Module of Multiple Users
Hacker System f5
Fill a Listbox or DropDownMenu with data from a recordset
Opening Files
Hacker System f
Hyperlink base
Exporting TXT fixed file export
Future of the Jet Engine
VBA coding for User count
How to turn Code Into Function
Releasing Excel Instance - Automation from Access
Creating a Library MDB - Secure
Convert to MySQL
Selecting a printer
Hacker System f5
Me.Recordset -> DoCmd.RunSQL "UPDATE ...............
How to get DLookup working correctly to check if a record already exists in the database
Creating a Table via SQL statements
Building SQL
Class Library
[Winsock] Send Big Attach
Problem w/referencing a Sub-Form via VBA
Directory listing
Link to a dbIII file
How to close snap shot file by VB Code
Docmd.runSQL problem
How do I create a Gantt chart?
Event for Closing Access
Handling the darn Apostrophe
Using access to close excel
VBA code for button
Days360 function in Microsoft Access?
Referencing a textbox in a subform
Access 2003
Custom Report Design
Dynamically sorting a report
.ldb file not being deleted
RunTime Error # 6 OVERFLOW
Run External DB from Currentdb
Access 97
Change positive numbers (debits) to negative numbers (credits)
Excel Automation from Access
Can't believe it - Back Again Already! - How to set variables to 'Type' in SQL Statement?
Compile Access application into a DLL
Application Developed in Access97
type mismatch with OpenRecordset
Passing a string to Outlook
returning current information - going round in circles
Conversion Frustration
why is my OpenDatabase( "Filepath") command not working in access.
Getting Syntax right for SQL String
Sort an array
VB help
How to make an Access DB timeout and close
Printing a table by using a form
Tracking objects, etc.
Check to see if OK or CANCEL selected using wlib_AutoDial
Can anyone help a VBA wanna-be?
Control MSgraph
Filter a sub form from main form
How to get command button to light only if data is null in subs
Ignore Null Values in function
Date/time formatting
Opening a report cause subsequent VB process to run real slow.
string manipulation
normalizing addresses
Caclulating Count of unique values
Execute Desktop Icon
Access 2K with WinFax
Disable PageUp and PageDown Keys
Wait for table to populate before proceeding
How do I search for an item using "begins with" and a parameter [.
Mouse Cursor Location
day of week function
Suppress Warnings
Null Date
On Open Event Procedure Help For a Report
Automatically linking/unlinking tables
Using visual source safe on access 2003
SendObject Only Working Once
what downloads do i need to start my own bussiness in retail
Errors in Passthrough query
Update a Table Field from Form
How do I create a function to redirect a table link from one data.
Runtime error 13 Type mismatch - something to do with date??
How to select a Printer
Inconsistent Results when I use AddNew on a Table
Error handler runs all the time?
Error handler runs all the time?
SQL Deleted From Access 2003 Query
Refresh existing link problem.
Searching a table
How can I retreive computer information from Active Directory
Problem pasting multiple records into a form using VBA
Built-In Objects (SendObject) vs. Libraries (CDO)
Cannot access public functions after establishing reference to ext
getting the names of files in a combo box
How to open Access minimized from DOS .bat file
Pass Through Query Question
Public function
Updating Large Recordsets
Del Dups
back up
popup
ServerFilter Form
Del / Mark Duplicates??
Sendobject and attachment rename
link two workbooks
Changing Field Size
Re: Accessing Reports on server mdb
converting a integer to a long
How to return to runtime version of Access from Excel
Check if Excel is running
How to detect a running SQL Server from Access?
Automamtion Error Calling Outlook from Access (-2147024770 (800700
Variable Declaration
Determining whether an object exists in an mdb
AutoNumber Fields - how to set them to start at zero
Multi Col. Combo Box Question
Get Database Path Accessed
Problem with Dlookup function
Error 3113 field not updatable
email an attachment
Error handling in when mdb A calls mdb B
SQL Table Updates in VBA
How to prevent Access from Closing
How to Run Batch File from Access
Using a single mdw for several databases
Creating Copy database, changing name, and deleting programmatical
Sending email with default emailprogram
Emailing a record in a form
Linked Table Question
Using an Array
select statement into if statement in an event code (syntax error
Limit Records in table
MDE file and references
Building SQL statements
comments
open onenote with new page
Creating a chart in VBA
Name Text format
Document readonly
DateAdd function in form
Code to open a form and insert data
**Link Works-StopWatch Form Problem**
Lock Out Key
Access 97 r/t 429 Setting new tabledef