INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Microsoft: Access Modules (VBA Coding) FAQ Index

FAQ Index

Access - Select Dialogs

FAQ Title Author Date Rating/#
Calculate Time Elapsed Between Two Times   faq705-2292 SgtJarrow 10 Oct 02 7.8 / 12
Error Accessing File. Network Connection May Have Been Lost   faq705-2529 remco5897 1 Oct 02 6.5 / 11
How do select a file using the a dialog box.   faq705-2484 m6 20 Sep 02 6.0 / 18
 

Access Environment

FAQ Title Author Date Rating/#
CommandBar button FaceIds  faq705-6091 bradles 4 Nov 05 9.7 / 3
Exit Access Application   faq705-7296 rohalyla 22 Dec 09 --
Hide The Access Window  faq705-2562 SgtJarrow 27 Sep 06 9.2 / 48
How to distribute an Access application which uses linked tables   faq705-4387 DannyLondon 4 Nov 03 6.7 / 6
Init StartUp and create your own copyright   faq705-2586 hermanlaksko 9 Sep 03 7.7 / 7
List CommandBar And ToolBar Icons  faq705-5152 markphsd 21 May 04 5.0 / 3
 

Compacting Databases

FAQ Title Author Date Rating/#
Auto Compact your Database when FileSize = x   faq705-2852 BillPower 28 Mar 03 8.7 / 26
Compact and Repair automatically at the start of each day  faq705-4998 BobStubbs 31 Mar 04 7.5 / 4
How do I compact my Access 97 database from code?   faq705-1955 oharab 14 Jun 02 7.7 / 15
 

DAO to ADO conversion

FAQ Title Author Date Rating/#
Basic guidelines and tips for DAO to ADO conversion  faq705-6082 pgmrmob 30 Nov 05 --
 

E-mail Attached Files

FAQ Title Author Date Rating/#
Create Outlook contacts with MS Access   faq705-551 adstam 14 Mar 01 5.2 / 19
E-mail via Outlook with multiple recipients/attachments   faq705-1634 mdthornton 14 Mar 02 7.6 / 14
How do I replace some text in as string with some other text string?   faq705-711 overClok6 7 May 01 9.4 / 5
Referencing SubForms and their Controls   faq705-964 Databaseguy 3 Aug 01 4.6 / 13
VBA code E-Mail method (better than SendObject)  faq705-537 DougP 8 Apr 04 7.6 / 20
 

Error Resolution

FAQ Title Author Date Rating/#
DoCmd.OutputTo causes run-time error 2024 or 2302   faq705-6303 PaulBricker 19 May 06 4.0 / 1
Emailing Errors Automatically   faq705-3994 Turbo 6 Aug 03 5.5 / 2
Function Isn't Available in Expressions in Query Expression   faq705-2959 Magellan 31 Dec 02 3.0 / 5
Generic Error Handler and Error Log Table  faq705-6245 Zion7 1 May 06 1.0 / 2
How can I access and damaged or corrupt data base?   faq705-3865 kjenkinz 9 Jul 03 8.0 / 1
How do I resolve Error 429 - ActiveX control cannot create object?  faq705-2882 RobCPA 27 Sep 05 9.6 / 37
How to debug your code   faq705-7148 dhookom 9 Mar 09 6.3 / 4
Illogical "Query too complex" & "Bad DLL calling convention" errors   faq705-5288 BoulderRidge 7 Jul 04 --
Runtime Layered Handling for Critical Procedures   faq705-6006 scking 29 Jul 05 --
Update on Error 429- ActiveX Component Can't Create Object   faq705-2958 Magellan 31 Dec 02 --
 

Executing Files

FAQ Title Author Date Rating/#
How do I set the working directory of a program I want to execute from VBA?   faq705-2299 dds82 7 Aug 02 6.3 / 4
 

File System

FAQ Title Author Date Rating/#
Delete a folder and all subfolders and files  faq705-6951 zollo9999 24 Jun 08 --
 

FTP in Access

FAQ Title Author Date Rating/#
How do I FTP files in MS Access part 2   faq705-6533 AlexCuse 2 Feb 07 7.0 / 3
How do I FTP files to a remote server in MS Access  faq705-5904 1DMF 12 Feb 14 10.0 / 9
 

Functions

FAQ Title Author Date Rating/#
A Quick Function for Allowing the user to change their password   faq705-5560 Chance1234 2 Dec 04 --
Access 2000-compatible functions for Access 97   faq705-4342 RickSpr 23 Oct 03 2.0 / 1
Adding or Deleting Leading Zeros   faq705-7065 JoanneM 3 Sep 08 --
Calculate milliseconds   faq705-6714 rfoye 16 Aug 07 --
DLookup Function Examples  faq705-4978 BobStubbs 30 Mar 04 7.3 / 21
How Can I Parse Name Components from a Full Name Field?  faq705-6468 AlexCuse 22 Nov 06 9.5 / 2
How do I simulate Excel's Ceiling/Floor Functions in VBA?   faq705-5031 ByteMyzer 12 Apr 04 10.0 / 1
How do I simulate the VB Replace Function in VBA?   faq705-1824 bustell 22 Apr 02 9.3 / 4
How do I simulate the VB Split function in VBA?   faq705-1823 bustell 22 Apr 02 8.7 / 3
How to Refresh All open Forms when necessary  faq705-6289 Zion7 10 Jun 06 1.5 / 2
How to Strip unwanted chars from a string   faq705-3933 kayek 24 Jul 03 7.3 / 3
Is the an IsNull function that works like Trans-Act SQL funtion IsNull?   faq705-2435 bustell 12 Sep 02 4.5 / 2
IsNothing Function for Access 97   faq705-5122 ByteMyzer 11 May 04 2.0 / 1
Luhn's Algorithm - a VBA Implementation  faq705-6704 AlexCuse 6 Aug 07 --
Online Resources & Help for Date/Time Functions in Access  faq705-3277 tlbroadbent 8 Mar 03 6.0 / 4
Proper Case function to handle surnames   faq705-5749 BobStubbs 13 Mar 05 8.3 / 3
Proper Case function to handle surnames - Another Take   faq705-6324 CompuSolve 16 Jun 06 7.5 / 2
The Round() function rounds 2.45 to 2.4 and is correct. Why?  faq705-3734 davemcdonaldireland 24 Sep 03 6.3 / 10
VBA Function to do Find/Replace in records   faq705-2384 HFloyd 28 Aug 02 4.2 / 6
What's an easy way to get feedback and/or error messages to tables for future reference?  faq705-6129 AlanJordan 8 Dec 05 --
Writeing to the RegBase and control your windows   faq705-2397 hermanlaksko 2 Sep 02 9.0 / 3
 

How To

FAQ Title Author Date Rating/#
Automate mailmerge - without a template   faq705-3827 redapples 27 Aug 03 8.7 / 7
Automate Word Mail Merge From Access  faq705-3237 JoyInOK 13 May 05 6.6 / 26
Build a Table of Holidays  faq705-6003 scking 8 Aug 05 2.5 / 2
Calculating a future Workday Date   faq705-3213 MichaelRed 20 Feb 03 8.6 / 7
Change the Default Printer   faq705-5479 AccessGuruCarl 19 Oct 04 8.8 / 9
Code in CopyingDatabase (db 1) copies all tables from source database (db 2) to destination database (db 3).   faq705-3859 AmiDenise 8 Jul 03 10.0 / 1
Create a new database using VBA code   faq705-2714 randysmid 6 Nov 02 5.6 / 5
DB corrupt, get rid of error  faq705-4683 MakeItSo 14 Jun 07 10.0 / 1
Find a table, query, field...   faq705-6506 hwkranger 9 Jan 07 --
Get PC name from Windows 2000   faq705-3399 randysmid 1 Apr 03 8.0 / 4
Get user name from Windows 2000   faq705-2814 randysmid 27 Nov 02 8.1 / 15
How can I delay code execution, with an optional message to the user?   faq705-5433 RickSpr 20 Sep 04 --
How do I check to see if drive (A:, D:, etc) is ready before moving along?   faq705-4840 cghoga 11 Feb 04 --
How do I create a multi-line msg box in Access 2000 / 2002   faq705-3696 jmeadows7 6 Jun 03 10.0 / 1
How do I import data from a remote ODBC table into a local MS Access table?   faq705-6372 nashman 6 Aug 06 2.0 / 1
How to perform a Google search based on data in Access  faq705-7073 jrbarnett 7 May 10 --
How to programmatically determine if your database is in MDE format   faq705-3569 jrbarnett 12 May 03 --
How To Query On Non-Existent Records   faq705-3589 JoyInOK 15 May 03 5.0 / 1
How to Use Automation to Add Meeting Request to Microsoft Outlook   faq705-3667 hengsin 29 May 03 --
Implement Multiuser Custom Counters in Jet 4.0 and ADO   faq705-4634 Harshu 27 Dec 03 --
Link a Table through VBA   faq705-6505 hwkranger 9 Jan 07 --
List all fonts   faq705-6925 hermanlaksko 27 Apr 08 --
Open a recordset with a Join on two FixedLength text files   faq705-6634 JerryKlmns 26 Apr 07 --
Read text from a web-site   faq705-4579 PeteJohnston 15 Dec 03 9.0 / 2
Read text from a web-site (2)   faq705-7299 RyanWoodward 12 Jan 10 --
Search query objects for specific field element   faq705-4830 randysmid 9 Feb 04 --
Sequentially Increment a Text Field   faq705-6727 tviman 31 Aug 07 --
Various Day Calculation Functions  faq705-4531 SgtJarrow 21 Sep 06 5.1 / 10
View login ID's of users currently using the DB   faq705-4894 sucoyant 27 Feb 04 9.5 / 4
 

Import CSV data using VBA

FAQ Title Author Date Rating/#
Could you show me some sample code to get me started on importing a CSV file into Access?   faq705-3566 beetee 9 May 03 5.7 / 6
 

Invoking SQL from VBA

FAQ Title Author Date Rating/#
Functions to convert SQL into VBA strings and back   faq705-6112 ferndoc 19 Nov 05 1.0 / 1
 

Misc

FAQ Title Author Date Rating/#
A Table manipulation Class  faq705-5873 redapples 16 May 05 8.5 / 2
Alternative to F9 to requery combo boxes   faq705-6471 markphsd 20 Nov 06 --
Code Modules, Object Modules, and Scoping   faq705-5319 CajunCenturion 22 Jul 04 7.5 / 21
Extract information from macros  faq705-5796 RoyVidar 10 Jun 05 10.0 / 1
Using Collaboration Data Objects (CDO)   faq705-4571 SBendBuckeye 12 Dec 03 --
 

Multi User Databases

FAQ Title Author Date Rating/#
Ensuring that everyone has the current Front end and doesnt change the filename   faq705-5062 shaiss 20 Apr 04 8.0 / 2
How do I display a list of the last few records a user has visited?   faq705-2285 JoyInOK 6 Aug 02 6.8 / 5
How do I make sure all users are using the most up to date version of the front end?   faq705-2010 oharab 3 Jul 02 8.2 / 19
How to make sure all of the users are using the most current version of the front end? - alternate method   faq705-3579 fdalmoro 13 May 03 10.0 / 1
How to make sure that everyone has the current version of the frontend and allow them to update.   faq705-5629 famehrie 19 Jan 05 9.0 / 1
 

OLE DB Providers

FAQ Title Author Date Rating/#
Connections with ADODB  faq705-4924 JunglesMcBeef 10 Mar 04 3.4 / 7
 

Opening Files

FAQ Title Author Date Rating/#
How do I open a Word/Excel/Picture/Any Other File from Access?  faq705-1971 oharab 8 Aug 10 8.3 / 34
Selecting a Folder (not a file)   faq705-2335 BigTeeJay 16 Aug 02 10.0 / 1
 

Outlook Email Wrapper Class

FAQ Title Author Date Rating/#
How do I Email via Microsoft Outlook and save sent .msg Email file to a specific location.  faq705-7667 1DMF 31 Jul 13 --
 

PDF files

FAQ Title Author Date Rating/#
Output a report in PDF format   faq705-1635 mdthornton 14 Mar 02 6.9 / 28
 

Play .WAV files in Access

FAQ Title Author Date Rating/#
How do I play a wav file in Access  faq705-251 DougP 12 Oct 00 9.3 / 8
 

Progress Bar/Status Label

FAQ Title Author Date Rating/#
Why won't my progress bar/status label show during a long process?   faq705-2166 TrojanRabbit 12 Jul 02 8.0 / 8
 

Query Questions

FAQ Title Author Date Rating/#
How do I use VB or VBA variables as query parameters?   faq705-2205 grtammi 19 Jul 02 6.8 / 18
 

Referencing Controls

FAQ Title Author Date Rating/#
How do I reference a control (or form/report) using a variable?   faq705-2283 TrojanRabbit 5 Aug 02 5.9 / 10
How do I reference a control within a tab control   faq705-1234 jgoodman00 2 Nov 01 7.7 / 7
 

Replacing CDO 1.2.1 with OOM

FAQ Title Author Date Rating/#
How do I replace CDO 1.2.1 with Outlook Object Model (migrating from Office 2003 to Office 2007/2010 )  faq705-7446 1DMF 9 Aug 12 10.0 / 1
 

Using Images

FAQ Title Author Date Rating/#
How do I display images within access, storing only the path?   faq705-1294 jgoodman00 23 Nov 01 7.3 / 11
 

Vba questions

FAQ Title Author Date Rating/#
How do I execute a SQL Server Stored Procedure from Access?   faq705-2531 jmeadows7 1 Oct 02 8.4 / 5
 

Word Template Emailer

FAQ Title Author Date Rating/#
How do I use Word as an email template and merge to Outlook   faq705-6950 1DMF 12 Jun 08 10.0 / 1
 

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close