Modules & VBA [Archive] - Page 91

Date stamping records
Difference between Access written code, and writing it yourself?
Archive or Delete old Records with some complication :)
Export Lookup Values and not their IDs to Excel
Change label report layout based on record
Project Management Tool?
Reference Manuals
Create multiple records from one user input?
establishing table relationships.
Compile Error help needed please
Is _ an issue with VBA?
Access and Excel quandry
Can anyone see a problem with this code to close word without saving
SQL Update syntax
References 2007 vs 2003
Incorrect Number of arguments when declaring sub
Access VBA End(xldown) error
Yes/No Combo box
Visio 07 VBA/layers question - post here, or?
Takeaway project
Clearing Excel files with no records
Hey my module stopped working
Adding an email attachment
Parsing and Replacing Data in a Memo Field
Bah! I could use help with this! 'Select Case' perhaps?
schedulling MS Access
Use listbox to choos Query to Export??
Logically update two fields in a table
adding a new feild in a module
calling a VBA procedure whose name is contained in a variable
Import multiple workbooks into 1 access table
quick syntax question
Listbox with a "yes/no" checkbox column?
Button to initiate hyperlink in field
Openform Action Cancelled RT Error '2501'
Too few parameters. expected 1 Error
object variable or with block not set
autoexec compacting issue
form, subform and events ....
Can't quite get the SQL correct
Send E-mail from Query Results
Type mismatch error
when popup form is closed...
DoCmd.TransferSpreadsheet - ACCESS doesn't see my query
Batch instead of individual items
Building Excel Pivot Tables in Access
Allow Zero length in Table
Export query; 1 record to a workbook and certain fields to worksheets
RunTime error: 3075 - Dlookup Issue
Query Criteria from Form textbox not working. Ideas?
MS Access: Editing cell in Listview
how to suppress the title in OutputTo' html table?
event after find record?
Pulling meeting replys to Access using VBA
RunTime Error 2107
Allow user to reorder steps in instruction database
Exporting A Recordsource To Excel
difference between two dates
create text file with 50000 rows
Opening an MSWord template from MSAccess.
Changing values with mouse wheel
Search Form Using Buttons
replace 0 with / in number field
dialog box in report
Plannergrid
Search Form
Code to refresh form details after adding data in different form?
How to use VB to make a custom error msg to replace the default PK violation msg?
Help detecting Idle Time
Upload excel into Access
Run VBA when windows startup/shutdown/log on/log off
write checks from Access in Hebrew
VB to Check Duplicates then update two Linked Tables
Create excel file from Access and enter 'Round' function in a cell
Duplicating an Order (and all its parts)
Audit Trail using VBA
MultiSelect property of one control depend on value of checkbox?
Finding Oldest and Newest Records
one list to another
Will Pay for Code!!!
no data event report
Change Caption on Another Form with VBA
update Rank Order field
Write formula in Excel w/Access VBA
How to set input mask for a field using ADOX
help please
Catagorizing a person within a duration
Using Initialise
reversed references
Can't use record set in sub-subs, Why?
Clear form after update
Calculating the number of records per user
Avoid Acrobat to open
Date function compile error
Validation Rule to Popup Text Box
SQL syntax error in VBA
textbox as criteria for query
Calendar
Small modification to code
Access 2003 - Formating Excel Column
Problems with DSN-less connections
How best to use Setvalue in later calculation
Reverse words
Grab selected item in listbox
How to insert a number with eight or more digits in standard format?
open multiple queries
How to run a code?
Error handling on new record
ADO, VBA, & Hyphens.
Problem with form SQL vba code
lookup specific record number
Else message box won't fire
Recordsource report
Importing specific fields from text file
Moving data.
Drop Changes or Copy to clipboard
Entering Parameter Value
Split database only allowing one user at a time
End process from MS Access
Problem Using Query in VBA
Select Case Statement issue:
Problem designating Excel file type when saving from Access
Access noob - problem using query in VBA to change an object's property
Cannot populate combo box with array
Set variable for nested subform?
Capture User Information
Cannot create dynamic reference to subform control
Calling Access Data into Excel Loop Question
Reproducing RunMacro action in code
Add error message to a table?
Check my code
Syntax help please?
Populate Annual Calendar Report
Determining in which table a value exists.
Can't compare two dates?
Alternative to DLookup?
Trying to do a filter
SubForm Actions within a MainForm
Does VBA have an "OrElse" operator?
Adding and deleting a record
Path to the current Database
Using Access 2007 for maintaining Access 2003 ADP projects
Gizmo's calendar & ACC2000?
Please help with conditional Validation in MS Excel
result query in msgbox
Display a Msgbox in a form based on a Query
Force to open link table
Code to show or hide contents of field
Application.Ontime in MS Access
Running Excel Sub from Access
Passing variable between events within same form
Closed Form not closed
Getting Error
How do i sum up all values in a field given some criteria?
how do i look up the value of cell using access?
Concatenate e-mail addresses from query into string
Inserting into a field called ' Currency' problem
Flickering message box when loading image on current
Help with SQL code in Module
Naming cells in Excel
Using Mail Merge - question on VBA
Output report to file
Export Access form data into Excel template with check boxes
Form coding help Please
transfering data from the sub form into the form in ACCESS run-time 2007
Average of a string?
Taking over the Control Box
VBA CODE HELP on boolean
Purging Redundant Code
Adding Voting Buttons to an email
multi user form
Error message 3847 rewrite code from DAO to ADO
Calling a function from a command button
Problem with Mouse Wheel in a sub form
VBA to check if table, form, report exists in DB
Interpreting Excel cell color
Data type not defined?
ColumnWidth question.
Compile Error Method Not Found
I need an example of a VB script.
How do I append a field?
Tables not able to be locked
Write names of folders to table once added to directory?
DAP exporting to excel as read-only
Using Mailitem to send multiple emails
Lookup record
Auto Create button by VBA
Lookup Table with Sub routines
vba code that generate 3 random letters
Maximizing the DB Window ONLY
How do I delete a record?
How do i delete all the records in a table but retaining the structure?
How to get the RDN name
Oulook displayalerts
Create Table With Multiple Monthly Splits From Single Record Date Range
Access programming
Controlling the display of an image by another field
Access VB, new records created from variables and loops etc
Value not valid for field in Combobox
Early Warning on Date Field
Email attachments in 2003
Report Preview Window Size
Open Report from Form using Dlookup
dial a phone number
Text Box - Password Input Mask
CurDir() in MS Access ???
Applying Borders in Word Report - Object Unknown
Not In List then fill in a form
textbox to texbox on subform
Find all currency values between a specified range
How do we connect mainframe with hummingbird software.
Opening form to slow
Working Days but different condition
Form and queries w/parameters
Get XML data from webservice
email address from access to outlook
Quick Calculation/Formula Help
UNC path vs. IP Address
3 conditions to be met by 2 different fields
tax problem
Error handling: report bombs at VBA function when query returns no records
Bitwise comparison and optional criteria
Object error on a DLookup
Inserting maintable's autonumber to subtable field
Need some help.
Button Always Appends 8 Rows Instead of 1
SQL and VB
Listbox Column Head
VBA code for matching Records in DAP
Command button to send all clients email through outlook
Code Boxes
ADO recordset not working. What's wrong with this code?
Help ME Pls
VBA SQL Query of Multiple Databases
zero length string
Re: Ken's Sample db's
Form Name
How do I click on a button in one database, then create a table in another database?
Using variables not having luck
TransferText - some pointers required please
VBA Vs Batch file for backup...I need some help??
Access 2.0 Viewing Code
Export report with dynamic criteria
Programatically changing code behind a button/label
VB for form corrupt?
This recordset is not updateable???
Email help. Convert to PDF.
loop through records
Multiple Record Update
picking up selections in list box