Microsoft Access VBA Modules [Archive] - Page 4

Transferspreadsheet anomoly (A2007)
Re: FileSystemObject --Type mismatch
Syntax error (missing operator) in query expression 'NEXTVAL
Closing a message box
Re: Prevent User from using the system after re-installing
Easy way to save access reports data?
open a password protected database with vba code using ecxel as fr
Problem constructing an SQL sentence by code
IIf statement with Between
RE: SQL server Insert
unbound form returns values to table
trouble to get number of months given two dates
Operation is not supported for this type of object.
is there an "end" character at the end of a .body command in VBA?
Append Passthrough Query Results to Local Table
Iterate/loop through a form to copy value from one control to anot
Stored form setting in Lotus Notes email processing
move data from a two dimentional array to a table
what is the difference between a 2dimentional array and a recordse
Is there a Stuff() Function or equivalent in MS Access
Opening a Word document from Access
Closing Lebans' clsMonthCal
reports: olebound
IsNumeric question
Error Relinking Tables with Attachment Fields
Save Password with Linked Tables
Update field based on criteria from another record (row)
Re: Prevent User from using the system after re-installing
Need to display a MsgBox if text box is blank before closing a for
Event for Form on a tab control: Force User to Click Save button
"too few parameters expected" when filtering OpenRecordset
Leading with 0's in a table.
Search for sepcific words and delete rows between them
Adding data to table that retreives data from another table
2 Comboboxes produce range of values in third combobox
How to do a Near Match Function
Cannot open module, Access hangs
Repeated call to InternetExplorer.Application seems to hang the PC
Validate textbox's with Form BeforeUdate
Is there a way to put a relative path to an icon?
Transferspreadsheet - file open vs closed
Delete a Table via Macro
How To Use Form To Sort Report (Three Levels)
RE: Is there a way to get an INPUT BOX to show Password style formatti
Is there a way to get an INPUT BOX to show Password style formatti
database file path
Deleting tables
Can you suggest a code version of limiting toolbars instead of....
identifying clicked node
Cartuchos R4i Ezflash y M3i Zero 22848
Finding numbers not in sequence
Function not working
security warnings
Re: Sql Server and Un-Bound Forms
OLEDate format
@nebictygal - RE:how can I send automatic emails from acess 2007?
Re: Recordset help
Collection(0) Out of Range
Dynamic Currency separator
How can I Print multiple Reports all Linked to a field?
Lock All Records Except New Record
Output to Word
Combo box with large table as source
Automated Printing of a Report
Adding code to an exported excel document
Alter/Change Text Column Field Size
Boolean property - "Yes/No"
Help with code
Make changes to Table Not Open
Detecting cursor type
Run-time error '3734'.
Search folder for string and open file is match found
Adding Child Nodes to Treeview
How do you hide Columns in a SubForm - based on values in the datasheet
Find and replace in whole database
2287 error on SendObject
VBA to clear controls
How to load current database query results into Recordset(2)?
Need Help with programming an 'auto scheduler'
test first character to see if it is lower case using vba
Update Form Problem
Pulling Sequence Number Depending on Other Fields
Error "could not find installable ISAM"
Get ODBC Windows User Name/password
Trying to connect Access 07 to SQLserver express 2008
ADO Access For Value List Error
"You can't go to the specified record." Error Code 2105
vba loop statement
disable rounding up & down in access 2007?
Have I stumped the MVPs?
How to Link Outlook items to Access OLE field
RE: Month Number in VBA
Constant Increments
VBA Training
Argument not optional
Re: Month Number in VBA
Timesheet entering blocks of time with a value
Filter Text Syntax
Excel events implemented in Access
Re: Month Number in VBA
Subtotal problem/conflict
Using "OpenRecordset" on Linked Table Issue
List Box Search
Text Box Lookup from Combo Box
Removing the Help Combo box
Basic Relationship Question
Alter Back-End Table from Front-End
Security Question...
Dumb Newbie question
>> ADO Updateable recordset
Using search range in InStr
Using if statement to determine which form to open
Saving Macros
Sending email from ms access to outlook causes backlog in outbox.
Output UTF-8 encoding through VBA
Access Security issue - Part 2
Need help in formulating a function
Sum Function Error
Visual Source Safe Integration
append SQL no records
query programming noobie question
Proper Event - Leaving Record?
Relink Tables From Multiple Sources?
Crosstab leaves Blank fields
Font change on mouseover
CalcWorkDays for Canada (English)
Errors reported by SQL to Access
combo box
automatically change the text in a text box?
performance of DAO vs 2007
I have exported to Excel but the file is copied twice?
Exiting Access
Run a VBA Sub using Windows Scheduler?
Open table exclusive
Look Up Missing Data on Web
show Data from Access in MSproject
Need help in a complex iif statement
Field Count in a recordset?
How do I allow the user to open and view an Excel file
dynamic subreport
dynamic query using parameter function
FindFirst Method
How to know when a Connection or Recordset is open
Copy table to different database
Append Query VBA help
Mercy! MERCY! I BEG YOU, MERCY! Time expression problem
Runtime Error 3021: 'No Current Record'
Dates
RE: VBA Help
Can someone tell me what is wrong with this path?
Transferspreadsheet import conflict
Need to push the results of a query into an Excel template...
Read text of form/report module code via VBA
ERROR 3061 - Too few parameters
Adding a new record to a subform
Unlocking fields based on value of another field
Default value calculated from other records
How to update sub when record deleted from another sub
Repost: Trusted publisher / Digital Signature
Conditional Formatting vs. Code for Highlighting/backcolor questio
Can't use "Diamond" in VBA, can't program a replace...
>> Find SR
Case Change By Itself in VBA Code - Help
Set Statement
Set Decimal Places
DoCmd Access 2007
Help with creative thinking needed
Controlling fonts in an email message
Move to next record on subform
Re: Need help to figure this out
RE: Need help to figure this out
Need help to figure this out
Add method of the CommandBars collection
Reading Post Office Web Page
RE: IIf syntax help....
run a batch file saved on server with VBA code or macro
"%" character in string
SendUsingAccount - Office 2007
>> Windows in Taskbar
Using VBA, How Can I Replace A Character In A Field?
I need help using the Eval() function
Append loop working but causing duplicates - I'm lost
email reply does not work
Streamline Many to 4
Capture a table name
sendobject with False not automatically sending email
Any better way to do the query
Transposing data from vertical format to tabular
Event Procedures stopped working
Comparing memo fields, and displaying differences
Run-time error '-2147217887 (80040e21)': Multiple-step operationgenerated errors. Check each status value.
How to check if a query exists and if it finds to delete
Opening And Closing A Notepad (.txt) File
Bitmap Paint Help
Run-time error '94' and No current record
rotating table records in a form
I've inherited some Access Security issues and wondered why...
Access 2007 - Error 3059: Operation canceled by user
Re: Loop issues
Re: Loop issues
How to Check if a form is open to update comboboxes
DLookup with 3 criteria - one of them boolean
Pass Form Field to Public Function
Email Report question
Function and Immediate window
Yes No message box
SubTotal in Excel
Using a VBA Variable function from Access table data in Access que
Re: remotepath
These newsgroups!
stuck in a loop
vbProperCase not working
Create Addin for VBE Extensibility functions
Compare Dates
Allow Only One User to View a Given Record at A Time
Importing Excel multi tabs into Access
Link to Outlook Calendar from Access
Concatenate Function
Pie Chart Colors
Subform linked to combo box
code in VB for sending emails to the field values in a table
send email
handover template
Server error 262 create data base permission denied in database ma
validate current user to table of approved users
sub form & sub-subform drill down question
recordset for a subform
Validation text caption
Clear Form's textboxes and checkboxes???
How do you set a recordset's bookmark?
Access 2007 Date() #Name
So disconnected means recordset can only be connected in same rout
Beetle? Can you help me out?
access reports: dynamically chaning link destination
Class module
Is there a way to programmatically print only a single page of a R
Combine/Merge Several Forms into one Form
VBA Export with date/time stamp
2007 not saving changes?!
How to obtain the location of a specified control in a form in Acc
Error: The remote server machine does not exist or is unavailable
Copy files to CD or DVD
Automatically fetch data from table
Re: Form control properties don't reflect changes to source table field properties
Re: Form control properties don't reflect changes to source table field properties
Retrieve value after insert
Read fields caption and description in VBA
Can a “Linked Table” path be updated with VBA?
Filter Subform from Main form
Filter Subform from Main form
RE: Insert the data from the same field in the previous record CTRL+'
Pass query snapshot to report?
Importing Excel file into Access Table.
Userform Listbox column heads???
Continuous form + strQuery = UPDATE
Using Already Open Workbook
New to reports coding - vba help
Using VBA to Set Colors in an Access Chart
Tab Key on Primary form with Subform
Re: VBA used in Reports
display auto_logo in emailed report
Using Like operator in VBA
login and logout
Find "Last Friday" function works almost 100%
Access Project SQL Import csv
Eliminate prompt in requery of subdatasheet in vba
How to Get Table/Field Filter in Access 2007?
Creating a querydef of a stored proc on Sql Server
Data data from a Data Table
Need to turn off rounding in Access 2007
str query = Update
vba code give different results on different computers on same net
Listbox Rowsouce
Version of the Access
Is there no way to mark individual records on a continuous form?
Select Minimum Amount
Access Send Email Question
Insert text in word doc from Secured database
find and replace
Access Run Time version crashes on Macro errors etc.
symbols
Combining Email Addresses
delete duplicates
Access 2007 - OrdinalPosition
Not enough space on tempory disk 3183
Lotus Notes
Re: How to send string on com port
use .bat file to rub ms access vba macro
Reading E-Mail Messages
Re: Insert Into with Where Clause
Print long paper
RE: Insert Into with Where Clause
How do you know if a user had viewed a record? VBA? Access Trigg
Blank line at top of txt file
RE: Insert Into with Where Clause
ComboBox or TreeView and Filtering List
Access 2007 Ribbon Question
Simple Security Requirement
Looping and Duplicating Records Access 2007
Programmatically Modify Pivot Table Fields?
PPSx-ul meu nu reda muzica pe site
Variable in SQL Where Statement in “Pass Through” Query
Need Help With Sales Purchase Ledger Database
Re: help
Re: help
Download file from net and save as txt-file
Invalid Product Key due to hard drive replacement
Re: Error trying to use form control value in query criteria
RE: Excel from Access problem
Can I have two recordsets open at once? Code works through one tim
Setting date to beginning or end of next month
Office Button
How to grab the NT Logon and use it for tracking changes to record
PLEASE HELP!!: Type Mismatch error
Error Handling
Link subform to combo box on form
Populate subform new records with dates
N-th record in a table/Query
Suspendig code after form opens
Test Connection to SQL Server
Opening Access from a windows service
Progamatically hide objects
enumerating tables collection or fields in ADOX blows up Access
populate word template from access
Crosstab?
Inputbox values control
Title bar
Run-time error 76
RE: Microsoft Access List Box and Record Not in Synch
Error Message while trying to edit specific field.
RTF /paperh Setting
Access 2007
registering incoming and outgoing correspondences mails
Importing Excel Into Table - Need Null
Shell Puzzler - “Documents and Settings” folder issue?
Dates don’t work within WHERE clauses
Relinking Tables Programmatically
Control a Query Datasheet with Code
Book that explains class module
Passing a Variable to a called program in a Shell Command
Data source name
reference application object of mdb opened with OpenDatabase
PivotTable Views
Open MS Word in Access 2007
Switchboard Question
TransferSpreadsheet with Formula Issue
Password-related Code
Access and Groupwise
Re: Calling Click Event from another Event
Opening form using 2 criteria
RE: Calling Click Event from another Event
RE: Calling Click Event from another Event
Using VBA to find date modified of a table
row source for Combo Box LIKE result form textbox
Assigning a VBA result in a Report to a field in a Table
duplicates in two fields...
Not to override a field
Autonumber question
Cannot find object '1'
Split function
Catching warning messages sent by Oracle
Enforcing item uniqueness
Record Locking for Editing.
Omega Constellation My Choice 1960.11.51
Tag Heuer Carrera Automatic wv211c.ba0787
query issue
RE: Need help with this code
Re: Need help with this code
Scroll bar in a subform
Table Type Recordset Hangs
Disable Paste Errors dialog box
DateSerial-Calculating a date 35 days from today
Switchboard button event procedure
Re: Create records based on ordered number of items
Template for Planned Preventive Maintenance Program? Anyone?
Re: Create records based on ordered number of items
Create records based on ordered number of items
Special Control Needed
Dcount past time
Focus in a list box
Report website problems here
Find & Replace Records
Can OutputTo Overlay an existing file?
Re: Sorting A recordset - searching for duplicates
Help please - determine the number of records appended
Calling a function
What's wrong with the syntaz of this statement?
What's wrong with the syntax of this?
Pleading for Help
Open OLE Object
Error 3001 in Access 2007 adding Attachment to linked Sharepoint t
Concentating contents from multiple records into one stored string
Microsoft Access ListBox display problem
Send an Query output with a Email using "sendObject" function
Help with code
Can VBA Plug in ODBC password?
GetOpenFile dialog pops up behind Access screen
RE: make text field to certain length and format
Email Report Error
files properties information
Circles, Textboxes, and Lines! On, My!
Build a String of Like fields
Test for picture
Only the user who created the record can change data in a field
Stop a macro from calling itself
RE: make text field to certain length and format
acDialog form won't accept mouse input?
If Statement with MsgBox
Print Selected ID
2 steps " search" text control
Delete all the records from all the Table
use recordset as source for form
Initiate VBA routine from Command-line?
Selection of last day of the month
MS Access Data & PDF Files
Access vs. Runtime (errors)
Loop concatenation problem
RE: Reference code in other DB?
Halt code without resetting
PaperSize
Shared Modules?
Application.ConvertAccessProject
Find Method not working properly
Re: Hide Query in while running
Emailing a Report Error
SLQ to Access - - LOST
Calculate the 3rd Friday of the month
"Input" statement
Warning Message
how to concatenate a number to a variable name?
RE: Structure/Relationship Question
send an object as an attachment
Multiple Form Instances & Me
Re: Structure/Relationship Question
Input Mask to store Fuel card Information
Variable in Range
Custom Toolbar Commands Disappear
How to deal with a photo when no photo is in folder
Converting multiple reports to PDF
Re: Invalid Use Of Null
Need help please - printing barcode labels by code
clearing text box
Check and map Network drive
Disable/Hide Minimum/Maximum/Close Items On the Access Runtime Application Window
Sort Fields in Datasheet view
SetFocus -- Selecting a Control on a Nested Subform
Access crashes when calling DLL function.
Can an access form write to a dbf file?
Re: Filtering a Form on Opening
Re: Filtering a Form on Opening
Re: Rename a Module
RE: Rename a Module
Access and Outlook Templates
Calculate Times
Hide a form in Access 2000
Question Regarding Access Usage and Licensing
Syntax
Send Report by email
Search Code
Get usable area of access window?
Autofill inside if/then statement
Combining Data from multiple excel pages
Refresh Imported Table with VBA
TwipsPerPixel Constant Question
NEEED EXPERTS HELP ASAP ***Keeps Crashing***
Export to csv with headers
Is ACCDB faster than MDB using JDBC Bridge Connection for Java?
Programmatic Detail Height
Finding a record with composite key
Select Case in VBA?
Send Report using email
Smoothed Average runs slow
Sequential Numbering with Alphanumeric
Explicitly naming Excel objects.
Help with opening a form to a specific record
Sample VBA Code Stubs
Re: Open Calender in outlook 2007 from access
Temp DBs
Format Text using VBA
Report Margins
MenuBar - hide it immediately
Filter data types
PDF Preview in Access 2003
Get number of pages in a pdf-document
Recordset - looping thru to append to another table
RE: Format Excel from Access
Deployment User Info -- where stored?
Populating a table from another table based on a field entered
Creating a Unique Key on Import
How can I run FTP using VBA in Access 2007
F8 Won't step thru code
Backend performance 2000 vs 2007
F8 key won't step thru code
Link a front end to a sharepoint backend
Formatting Currency
How to write this SQL in VBA....
MS Access, change icon if VB Script
Possible to run SQL Server 2005 function from VBA?
ORDER BY
Format for currency
Prevent unwanted report printing via VBA
Vehicle Dispatch program
How Making intranet page (web) for access data base
troubles with do while loop
Append table form current Subform - tick row exported
populate word template from access table
DTPicker
Access password security model
Delete record and Error 3075
Creating a pop up box in Access on got focus
Late Binding
Repost (completed) Application.Filesearch with wildcards
Undefined function 'Round' in expression
Access VBA to open Excel workbook, save as a dbf (I think)
Close all Instances of Excel
Close all Instances of Excel
syntax error in UPDATE statement
Find min from recordset
Calendar control
OWC11.DLL components no longer working
Application.Filesearch with wildcards
getting certain fields from a particular record
Code for DSN-Less connection not working?
Error 3029 When Trying to Create Workspace
cmd MS Access 2003 macro security disable
Re: Path direction
Date error
Compile Error: Variable Not Defined
Excel sort not working in Access VBA
filter applied in open form but subform does not show
Need to improve / shorten startup of DB
Has User got Excel
How to make a strickthrough button
Synchronised Combo Boxes - Code Doesn't Work
Automate resetting reference to object library
Re: Total Values from Filter, not using a Query
Re: Is there a way to de-activate all hot keys in Access
Can I set a field to have a dropdown menu based off other tables
Would like to error sooner
Access 2007 Web Services - Add-In or VBA Class?
Reports and Filters
Canceling and deleting a record via code – help please.
TransferSpreadsheet to .xlsx format
Re: Truncating SQL Server "Text" field
SetFocus
RE: SQL HELP
Import Specs A2007
trying to assign a variable to the field part of recordset!field
What is the code to allow the user to continue working while code
Sorting Text Fields as numbers
Focus and before_update
Force another application to be active window
ASAP! WILL THIS SCRIPT WORK to pick up unfriendly in search engin
SplitFormDatasheet property
Writing VBA Code to control the background color of a form field
Running Code
Disk or Network Error
Run time error "table opened exclusively"
Controls in/outside a tab control on a form
Visible property not available in code for a report
RE: Multiple If Then Statements Stored In table
Re: need help with syntax for docmd.transfertext, ontimer event
Search Before adding New
Name of active tab page
Open and Close Excel Workbook
How to have users preview temp table on a form when a 144 columns?
Graph Library Object Browser.
Importing Excelfile without headers gives error.
Re: Multiple If Then Statements Stored In table
Access is slower programming than Excel. No Intellisense
Runtime Error 3075 only on one machine...
RE: Learning VBA etc.
RE: Learning VBA etc.
copy table structure and queries to new database VBA
Access 2003 i.e Jet4 internal structure
restrict design access
RE: Learning VBA etc.
Broken reference?
Change Field Property
Help!Error 3265, loading fr cbo box to combo box and then to txt b
email PDF Attchments
Can't Modify the manifest file?!
connection object for linked table
Getting Totals with Recordsets
>> getting info from sql server
Combine records in a table
Access 2007 at Odds with Vista
Data Access Page | Why use this feature?
Write file to specific network address.
Setting field properties
Copy first record only, of a forms subform to a new forms feild
recordset issue
Incorrect count in filtered recordset
create package
How do I refer to the current field
Re: Accessing DOM from VBA
"Indexed or Primary Key cannot contain a Null value" / Autonumbers
Export to existing excel file
RE: Accessing DOM from VBA
number of days in month
Return to current record after Requery
Wrong Data Type
DLookup
Email
Assigning current value to default for date ComboBox not working?
Registry Changes with XP vs Vista OS ?
Nz function question, will it work for my problem???
Delete unmatching records
what is ms word 2007?
Issue with transform query
RE: Finding a value and then finding a value from that
RE: Timer event not working.
getting value from table in a variable
Capturing Windows User Name
How do you create an Option Group in Access 2007 ?
do loop through a table
Directory Inventory
Check boxes and new record button
Check boxes and new record button
Order of execution mystery
Automatically export a query to XML with Access 2003
Error 2455 “Invalid reference to property filesearch”
When trying to create Workspace, get error 3847
Transfer Access 2003 ADP Custom Menu Items
Macro Message
Need help with if then else in VBA
Exporting Hyperlinks to Excel
Could not update; currently locked (updated post)
File:\\\
Create E-Mail with Hyperlink to File
Referencing a subform
ADO -DAO problem?
VBA Select query with date range format issue
problem in (Set objOutlookRecip = .Recipients.Add(TheAddress))
User licenses and product keys for custom Access app
Selecting several tables into different fields
Setting category when creating appointment in Outlook 2007 from Ac
Advice - Forms all recordset driven
Combining Query Results
A Formatted Query Field Causing Problems in ListBox
list box data not displaying correctly
Access 2000 Runtime
ADO -DAO problem
Count distinct number of days
function criteria
Coding Syntax and Methods?
What to do when Code works when Stepping through but doesn't when
Programatically downloading a file from the internet
Printing Problem
OpenRecordset problem (parameter query)
control ms access report grouping at run time
>> Save as PDF or XPS
retrieving cell reference
Slowness
db.execute INSERT INTO very slow
Declare the button
Re: Rename a form in externat DB
Winsock for Access
Numbering subrecords
Cannot get Seek method on linked table to work.
sysntax error, only in some versions
getAttr = vbDirectory failing on a compressed drive?
Open Application to Specific Directory
Change tax, but leave old records alone
Prevent further inserts in subform
Combo Box Problem
Replace function - Is this normal?
Tab Control Event
Find Method
Print dependent on Select Case value
Re-create a Database in VB2008?
numbering subrecords
posting level period
Runtime Error 438 -- in process that has always worked
Option Group
FollowHyperlink JPG Opens In Internet Explorer
VB IDE
sample code to pull stock market info
Chart Datasheet
Multiple choice answer tracking and exam tracking
Access 2007 Runtime app on a 2003 machine
Re: For Each problem in Modue with variable
RE: For Each problem in Modue with variable
hi all
Must I use the Index Number To Select items in a listbox with code
How to determine Index Numbers for Multiple Items Selected in List
New Password
Export the pivot chart view of a query to an image.
Determine Fle Properties
Programmatically lock and put bakcolor as yellow only to the head
Re: Tying check boxes to data
Assigning a unique value to the output of a dataset
Parameter Query - Passing multiple parameters
Web Browser/RSS Help
Module???
between dates
could not update, currently locked
RE: A real ACCDB ?
calculating Holiday dates for multiple countries
User Access Control
THANKS TO EVERYONE WHO HELPED ME OUT!!!!!
Reserved Error (-3701)
Alternate method to dynamic tables
View query written in VBA
Chart Properties in VBA
Display a photo on a report when the photos are in a directory?
how to determine which record is missing...
User input disable msg box
Exclude "#DIV/0!" from Excel Import
mde, mdw, mdb - How are they known to one another?
How to handle union query with a condition
Which is more efficient?
can I solve this by code?
Count the number of selections
RE: Problem with file OWC11.DLL in MS Access
Download in Cache
Macro Email Variable
error trapping
How to add the Home ribbon to an Access 2007 Runtime database
Re: ADO library changed with install of Office on Vista
Close CreateObject()?
Process for protecting a distributed access database/application
How would you select multiple locations with a specified distance
Re: trying to find a cell in excel using 'find' from access
Quotes within quotes + wildcard characters
Reading files from a folder and loading atributes into a database.
AutoCenter with code
Scrolling Info Window
Startup question.
Email via Lotus Notes the results of a query.
Programatic adding of categories in PivotChart view
Adding records to multiple tables
RE: trying to find a cell in excel using 'find' from access
Re: Through VBA code open objects stored in table and run these objects
Invalid identifier following null constant
Required Fields in main form with subform
RE: why does this code work but generate an error
Network Drives
Access 2007 filtering issue
Compare Groups with AND OR
Combo Box to Fill in Form Fields
Can't get Set Focus to Work
Batch
LAST in a Totals Query
I am working with Access 2003 and SharePoint 2007 with linkedtables...
Referencing Boolean Variable using a for loop
Code that works in Excel but not Access
Detail Format Not Firing
Access 2007 conversion subforms don't display linked records
Insert image from clipboard into Access 2003 form