Modules & VBA [Archive] - Page 60

Trouble
Bypassing Events
Query String Result
Subreport Filters - AGAIN!
Make MSGBOX appear over all other apps
Great Function - if it worked....!
Not In List - I can't get it right
Closing a specific file via VBA-code
Calculations in VB
stLinkCriteria to match fields to form and subform on that form
SQL in VB
Closing rogue Excel process
Open pdf-document from Access form
how to detect first n last record? Thank you
Filtering via vba
Property Not Found of DecimalPlaces
Recordset or Aggegrate Functions?
Opening a file
Module Creation
helps for MSCOMM
Basic question - For - Next loop
Can I query a DAO recordset
Saving new data automatically
Retain memo format - Require WYSIWYG
Blobs and Images
function calculating ticket prices
Retrieve Windows Network Password
Is some wrong in code...
Recreate VLookup in Access?
not working, cant trace
returning file info from folder
create help file
MailMerge and FormFields command - no documentation ANYWHERE
ODBC Call Fail
Export Variable Query Definition to Excel
Sending E-mail
SQL Return Code
Search and open a pdf file
convert string to object/method. see example
Control properties of a chart in MS ACCESS with VBA
Using VBA to replace word in a .cmd file
ListBox & subform Record Select
Query Calisthenics
Detect Text Box Overflow
Passing parameters
Quick silly question - what is 'bas'?
Counting lines of text
Command button to open Drawer
making data items invisible in combobox
Automatic compact and repair with DB closed?
Spec file losing data and spec fie location?
Print without dialogue box
Searching w/ Option Buttons
Error Opening a Query With Criteria Through Code
Max() vs DMax()
Need help with nested loop in VB
Autolinking to a SQL Server via a web connection
record set to change field
record set to change field
Writing SQL in VBA
Writing SQL in VBA
Extracting data from one field in a table to another--Help!!!
Deleting Records in a Subform
Deleting Records in a Subform
'Sorting' a string
using a control button to copy data from one form to another
spreadsheettype information
Error message - Chinese environment
Replace, recordsets and Null values
Need help: #Name? error with defaultvalue
Use boolean to filter records
Do loop problems
calling up methods from one form to another
Control Fields Assistance
Referring to Variable in Code
transferspreadsheet problem
Run query without prompts
Sql Statement in vba
Combo Box
Programatically creating a new field in a linked table
Sql Statement in vba
Trying to calculate sick days
Copy Files from an FTP folder using VBA
RecordSet and SQL Help
update table from continuous form
Appending an Access Table to an excel sheet
FileDialog(msoFileDialogFilePicker)
Determining if record is new or current
How to hide the query by visual basic
Dynamic naming of objects and variables
Manipulate a text file prior to import
Clueless about calling function
Combo box chooses first line
Querying Form's Textfield Value
Setting a boolean field using code
Default Values = Previous entry
Help with adding a report in Body of Email
Access 97 email with Lotus Notes?
Export Access Report to Excel (Acces 97)?
Weird code error
New to Access, Not sure how to do this
obtain a list of all tables in a database
ADODB recordset not opening!!!!!
Run SQL runt time error
Run SQL runt time error
RunSQL
RunSQL
Exporting specific fields to excel
Problem with sending mail via outlook
backup db on exit using vba
Adding mutliple records....
Simple VBA Question - How Do I Prevent A Text Box Control From Changing Focus
merge to word
Filtering reports dynamically
SQL Server Money Data Type
Creating a string
Resize/Rename photo in Access?
Code from Form to Report
Can DLookup refer to the previous record?
Can DLookup refer to the previous record?
write data from report to CSV file
Syntax for allow edits and addittions
Exporting recordset to Excel & Powerpoint
ExportXML Help
Locking Question
Sync Form to Listbox
ANSI codes
Importing in to Access 97 using vb script with jet engine
Return ADODB recordset value?
Pull Down Box and Locked Text Box Code
Text conversion to date
Hope you can help fix this
Email excel attachment
Delete Query Problem
FormatPercent Mismatch problem
Problem with search-function (.SelStart - Run-time error 2185)
Inventory coding help
ItemData combo box problem (Access 2000)
Populating option group by recognising first 3 digits
aquire image with scanner
Help with ActiveCell.Offset.Activate
ACCESS 97 VB Tutorial
VBA for Excel Code
sending email from citrix
desabling word from access
Combo box
Can Anyone Tell Me Where Im Going wrong.
Median subtotals
DAO Description Values
Kick Drawer
How to update/cancel changes and Lock individual records?
Run external program and get output
Saved Query Modification
Saved Query Modification
Exclude hidden files from filesearch
Checking Records
"The expression you entered has a function name that XXX can't find"
Convert Date to Hijri (ArabicCalendar)
Combo Filter on sub form fails at last selection
Modifying code to send attachments Access 97
MS Access Form & VBA Problem
Log changes using Insert Into
Step Into doesn't work
From text box to Wordpad..
Limiting user's choices in ActiveX calendar
Controls Collection
create a new database and export a table in it
References - Access 2000 and 2003
Restrict Pivot Chart Usage
Copy Recordset
Not getting out of loop
Coding over multiple lines
Encryption in VBA
Passing Dates and Integers in vb
Recover deleted records?
Range in Excel from Access
Variable type not in list
how to save Data value for each field entry on a bounded form
Requery Dlookup field on subform
Assign value to textbox
Runtime Error (3075), not sure how to fix it
Help with not null & DoCmd.OpenReport
Help with not null & DoCmd.OpenReport
SQL Update statement
Hijri Date Problem Again?
Transaction Automicity does not work.
ADOX field creation - change to not required
ADOX - change 'Required' property of new field
Excel file doesn't open-error
Disable subform from the main form
Function to concatenate values into a string based upon criteria
Input Box Error
Challenge...Locking only a particular record!
Problem Adding ActiveX
SQL Update Date / Time info
what is the code?
some simple questions (I hope)
Docmd.findrecord acSearchAll, doesn't.
vb arghhh i dont understand it!
vb arghhh i dont understand it!
vb arghhh i dont understand it!
Null insert statement
Simple Code question, but cannot figure it out.
Simple question: Requery form
Easy Question, but not sure how to do it.
from table to a template
Easy question, but having a hard time to figure it out
invalid procedure???
I think I need a VBA code
New Switchboard - Code now not working
If Then statement, having trouble since two forms are involved
I am stuck at step
am I asking the right questions?
Please Help -- "Same as Billing Address" Checkbox --- is this possible!?!?!?
Do I need a temporary recordset?
MakeTable qry - Checkbox Format
Audit Trail and Find and Replace issue
Error in my code and not sure what it is.
RunningSum
Working with OUTLOOK
Reading audio CD table of contents
Access won't let me save
Detect when record has finished loading
Excel autofilter selection criteria referencing the contnet of a cell on another work
Obtaining Table Descriptions
Form page fade out
How can I suppress "paste errors" message?
If between two dates not working
Help With Vba Pleaseeeee
How do I activate the Maximize button in code?
File Searching in MS Access
Code for putting current date into a field.
Exact phrase
Changing field values (in code)
Popup Form Open/Update Issue
Custom Page Number Label
Check Username and Password Login Form
Lookup value in table
Storing a Proceedure Name in a Variable to be used later
Exporting a Memo Field with a Custom Result Column giving a Data Type Mismatch
Assigning event at runtime
Automatic mail after query update
MSComm question
Cmbo box is resisting my efforts
exporting from access
Single Level to Multilevel BOM Conversion
Auto Mail Merge with TOC PROBLEM?
Extracting data from query
Can't Figure out the problem in my code when Opening a form
Delete Query in VBA based on Combobox gives error, but runs in SQL query