Microsoft Access VBA Modules [Archive] - Page 3

Insert Into error
Best way to deal with record-locking conflicts
Error 3001 recordset find sql
Renaming a file using an input form
Combo Box with NotInList procedure not working
Password Characters such as "*"
Converting C++ Props
Ms Access 2007 and Ms Sharepoint 2007 (Issue with Attachments)
Re: Last Updated
Choose which address to send from
SQL Not Working - "At Most One Record Can Be Returned by this Subq
Create new text file for export
TimeStamp Record
How to Color a Box on a Report when Change in one Field's Data
How to set the value of a VBA variable with a command button
Method or data member not found
Stuck - Median and Quartiles
Delete jpg file based on Access field contents
Change a file name using access 2007 form
Code to display random records in form
Apply timestamp to BE file
Error 3061: Too Fee Parameters
How do evaluate tables and insert record if none exist
error: OLE Server Isn't Registered
Economical Auction Site
Access 2007 and windows 7
intergrate google maps with microsoft access
DoCmd.SearchForRecord
Deriving the full name of a subdirectory from the first fewCharacters
Filter sub from using combo on parent form
Order of Events using the built in form Close Button
Code for creating field when no value exists
Splitting Database
Median and Quartiles
Splitting Database
Order of Events when using the Control Box Close Button
How to edit a macro
Usin VB in Sql Server
Browsing to a folder
Referring to Back End Database - Dynamic possible?
calling sql loader from vba
send emails from access
Msgbox Function - increase font size?
e-mail through access
Lookup a value in a table and display text if a value exists
On error displayes default error code instead of the specifyed one
Q for Mr Allen Browne = Auditting a form = Audit Log
VBA Coding for DoCMD Statements.
send email from access
Disconnecting from server
Assign query results to combo box
Link Excel Tables Programmatically
Do until Loop question
Programmatically LINK Excel Tables
Send email from Access through outlook
Create external database
Feed Combo Box with a Query
Feed a combo box with the results of a query
best practices to share code in multiple databases
Re: Issue with While loop and Access 2007 datasheet
division in access to round-up if division not whole number
sum after max records found
Placing a DB on the Internet
Commit updates to current record without changing records
Email select page of report -- need help
Using Access 2003 to store Emails
VB updates in form field not updated in tables
Error Code 2046 when sending emails.
Is SUB name available in a variable?
Emails - Use Acces 2003 to parse email texts
How To Update Jet Componenet on Win 7 ?
How do I lock window size
Filter a Report with a Form
Code to Dynamically Filter a Report; Not Working
automatically creating table links in access to new tables in sqlserver database
Display graphic stored on remote sql server web site
Unrecognized database format ‘C:\Trading System’
A2007 References
Conversion from PAL to VBA
Access 2003 Timecard form
Re: Access to SQL
Access VBA to manipulate an Excel spreadsheet
Open New Form with Identical Info as Original Form
rst find first - somethings changed can't see the forest for the t
How random is Rnd
Email Report
Conditional formatting not working as expected (A2007)
Conditional formatting not working
msofiledialogfilepicker error
SendObject command doesn't automatically send e-mail
Obtain server IP
make a duplicate table in access and save changes
coding help - please
Set ORDER BY property for a table
Access a secure folder on a server
Opening XFDL form using VBA
exe that opens an app that talks to an MDE -- security question
Help with syntax error
Add a logo to the report header with code
RE: Email attachments
Logon to remote server
Hide Select Unique Record Identifier
very basic MS access 2007 (button click no read issue)
WordPad Automation
RE: Suppress "0" from printing on a report
Re: Suppress "0" from printing on a report
Re: Suppress "0" from printing on a report
Re: Assigning user name
Too few parameters?
attaching a file to a sharepoint record
modifiy field type by vba
Insert row, table to table - where append goes to correct record
Update Field Data Type
Re: Can't Copy Code from one database to another
syntaxis problems
Control Msgbox position
Run time error 2494
modify field type of existing field in table
display user logon name
Fields in recordset
Creating a View in DB2 with DAO
More than one Table
App does not shut down on exiting the db
Help with julian date?
Question about a Modal form
how to write vb code in access 2007
Get procedure (sub/func) name
Now asking for missing semicolon ???????? - Guidance please
Database comparison
populate an unbound control in a report
Deleting records in Access 2007 Runtime
Record source - "No fields available to be added to the current vi
runtime error 3075 - missing operator
Compact Database
Dynamic Report Design
Excel Automation, Cell Border Lines
ODBC Connection Not Connecting
Combo Box help (repost)
I cannot see the syntax error - guidance please.
how can i use the produc key after use to code.
What to do with "Undefined function 'Dir$' in expression"
Generic reference to form's control containing a subform
Access form update/Requery?
Use String variable to access field
Runtime import code problem
Follow Hyperlink to PDF page
RE: Week 53 and Week 1 from a given date
Re: Week 53 and Week 1 from a given date
Access Options
Bringing Sharepoint list data back online after working offline
Trouble with Me.Undo in microsoft split form
Check Name in a Specific Customer Record - after update
Re: Running a BAT file with Access
Re: Running a BAT file with Access
Running a BAT file with Access
XP & Access 2007 compatibility
SendObject problems
How do I set up email notificaion in Access 2003?
will not eval a function name from a table.
Default a Time Field if Date is entered
A good method for searching a table with an entry from a form?
Combo Box Help??
Access Pass-Through To Oracle 10g Stored Procedure - Return Result
Insert from Table A to Table B with criteria
Current/Active Internet Explorer
excluding keys from text box
Retrieving e-mail from Outlook doesn't work on Public Folder
item not found in this collection
Stepping through Code??
Runtime 2007 error End command
Can VBA change Split Form Size?
Can VBA change Split Form Size?
Second Report not printing - whats wrong with the VBA I have??????
Can I resize an object while in form view?
Can I resize an object while in form view?
Proper simple Access VBA SQL syntax
sql stored procedure
Math Function from Field Before Update
Printing Barcode Labels
Multi-valued fields are not allowed in SELECT INTO statements (A20
Datasheet/Data Grid Layout
Randomize statement
Locking File
>> List of database queries
Query Parameters
oiuo
Change Data Type from Memo to Text
XP home service pack 3 Power management
transfertext delimited
Data Access Page
Delete empty rows
how do I query the current Win logon id in a nonsecure Access db
Automatically update an AmendDate field on my form using VBA
Error 3061 - too few parameters
Re: Access 14.0 Object Library Reference problem
Re: Access 14.0 Object Library Reference problem
Save Text file
link file from virtual windows xp to access 2007 on windows 7 plat
Conditional formatting error
Re: Access 14.0 Object Library Reference problem
ADP + MSSQL (ADO) vs. ACCDB + linked MSSQL (DAO).
Multi-value field filter question using strFilter
Fill drop list
Multiple versions of Access
Bookmark Invalid
Data Access Page
start bar
Too few parameters - Expected 1 message?
Runtime errors Ac2007 more of same
Need help with function to change BackColor
Custom colors disappear from palate
Re: How to the determine the current subform using a macro
Hide Access Window, Database Window, etc Showing only User Forms?????
Combo box problem not fixed by hotfix
Changing Linked Table Name
Change printer to print report
lost in error 3075
code to get file attributes
Rename drop list column heads
If Then / Case Else Not Working
Readonly a linked table
Need Help Filtering a Form with VBA
moving company database
Tracking open files
Export data to txt format file
Access 2007 UI QAT
Macro question??
Running Line Twice
question about using strFilter with AND
Need Help dealing with blank fields
what does this symbol mean?
Referencing Subforms
UNC
Data Access Page
how do I create an adp in access 2010
Multiple Instances of Access.. is it safe?
insert memo feild into a memo field truncates at 255 characters -
Dynamic field mapping with excel import
Set primary key on a temp database table
Access VBA DCOUNT problem when two forms are involved
Photographs Distortion in Image Control
Re: Application project in the database is corupt!
Global Keypress Function
How to use VBA to Change Color of a Form
Slow To Open with Linked Tables
Create group out of vba code
access db carry forward balance vs. table design change?
MultiDimensional Array Syntax
Combine two databases into one
Next Record in ListBox
making adjustment for the start bar on the side of the screen
Question about Calling procedures
How to Fix Photograph Distortions
Combining multiple click events
Export fixed width file from Access 2003
how can I choose part of the text in a cell and paste it elsewhere
Problem with advanced filter sort window
Specify 2007 Startup Options in 2003
undo changes vba / sql
Total line in a form
Using excel add-ins in access
Re: MS Access -All the possible routes one can travel through to get from A to E
Listing all Field names of each Table in db
Start Bar on side messes up my resize
office 2007 scroll thru the items in a cbobox in the ribbon
identify join sides of a table
Turn off warnings but still print them to text file
count of records in a table in external database
looping through nodes
Clear Intermediate Window
Find name on the many side
Combo On Not In List - am I asking too much?
Sybase 11 dirvers- alternatives?
Count a string withing a string - VBA
Re: Syntax error on Update
Invalid procedure call?
Invalid procedure call or argument?
The best way to speed up preformance
INSERT INTO Table, values derived in code from separating a name
how do i up load from my pictures to advertising web site
Copy / Pastespecial in 2007
QpenRecordset
Acxess 2003 and 2007
record count of table while looping through all tables
setfocus not working?
Re: Connection from Excel to Access
TextBox on report: Border Style
Re: Connection from Excel to Access
Connection from Excel to Access
Return Focus to Access after Excel Export
cbobox in the ribbon
Error 429 in Runtime
Declaring Public Const
Outlook 2003 Alarm created from Access 2003 in Windows 7
Pass a value to a subform
Combo box columns
Accessing bookmarks in Word from Access
Opening/editing/saving excel file
If,Then, Else
Relpicating an Excel Macro in Access
HELP
Missing Library
Open a table for search
Delete files by file date
Search Using Dropdown
office 2007-dynamic combobox in ribbon
Problem using Microsoft Web Browser control
Access 2007 and Windows 7
Back-to-Back DoCmd.OpenReport fails if Printer Offline
Verify file exists before moving it
Dynamic Goto
Turning off Ribbons in Access 2007
is there a way to get number of "objects" in a Access db?
Paste Linked Table
Re: Automated login to network
DATE VALIDATION - UK DATE FORMAT
Procedure at Access Stutdown
Displaying images
A2007 ADO Recordset Clone
Re: Select from a table in an IF statement
Re: Select from a table in an IF statement
Duplicate Keys
Field Length Issue
Print multiple non-sequential pages?
CreateDatabase / Access 2007
Application - Path & runtime
Concise list of Jet functions
sendKeys enter key to a message box with yes /no fields
How to get a report to default to a default printer...
Append multiple rows using DMax
select and update multiple records at the same time
Using VBA to disable fileds in a form
Excel.EXE will not close... Only when database closes
MenuBar properties
Copy ADO Recordset
Re: excel automation and SendKeys "%{ENTER}", True
Re: excel automation and SendKeys "%{ENTER}", True
Reference Issues
Function to convert GMT to EST?
Keydown Event while in a data Entry Field
Running a .accdr file from the shell command
log off Terminal Services session
Importation fichier Txt dans Access
RE: Excel Automation - Delete sheets using access VBA
Run-time error in packaged version
Re: Keyboard repeat rate
Creating "key" fields when met, unlock the next step..
Need Help with adding and taking away
How to manage SQL Server authentication in Access2007
Julian Date function runs too slow
Cascading Combo Code Not Working
accessing the value of the link child in a subform
Day/Time Format
Disable form design view
Sending Serial Email with PDF attachment
Sending an E-mail From Access through Serial Email
Split Function Creates Error 13 Type Mismatch
Filter only returning 1 record
Thanks guys
Error 94 Invalid use of Null
Append new and changed records
Can't pass string >255 characters to Word document with VBA
passing a control to a sub
Generate a random 6 character output
Delete sent email
Access2007 Context-sensitive menus
Controlling the DatePicker
Retrieve Full Path From Attachment Recordset Multi Value Field
Requery needed twice
Classes and (dis)amiguation
Allen Browne's code to duplicate records
Timelines
JDBC-ODBC Bridge driver & ODBC driver are two different installati
RE: Tracking multiple users of DB
titanium ecm2001 titanium crack torrent rapidshare download freeDmo)HeEQv<
Syntax error using dlookup
Locked out of my database
OpenRecordset problem
Combining two fields
On Error check for Function within Function
PivotExportToExcel disappears in Runtime
Subform table
Access loosing Memory with Printer-Object
Limit Text displayed in Combo box
Update syntax for a remote table access
Access 2007 - Use Report or HTML file as body of Outlook email mes
Access 2007 - Use Report or HTML file as body of Outlook emailmessage
Passing Vars with Seek Function
Multiple Codes in AfterUpdate Event
Obtain report's caption from report's name in code
Trap status bar changes
RE: Image from table on a report
RE: Combining/Joining a range(scale) of data to a table
Creating a new record in only one table of underlying query
Syntax to set Startup Properties from code
RE: Mysterious Toolbar
Hide & Unhide Ribbon in Access 2007
Create a table similar to the table in another mdb with all data
Text driver issue with opened files
Access + Insert Into + confirmation dialog
Repeat Field Value
Compare Front Ends
Unpivot code
Auto recenter form from code
Insert Into Question
User-Defined Type as Optional Argument
Enable Disable Report Alternate Back Color
Run Access Query From Excel With Parameter?
Treeview click event
Open Form Based on Criteria
Re: Can I use Access VBA code to create a macro for Excel and copy it into Excel Mod
Re: Can I use Access VBA code to create a macro for Excel and copy it into Excel Mod
Re: Can I use Access VBA code to create a macro for Excel and copy it into Excel Mod
Database and WANs
path of related tables in VBA
Function to count unique records?
Excel won't go away
Installing DLL
Programmatically set table field order
How Not To Have To Go To Control+G > Tools > Reference > DAO >Etc.
Function to convert data
Eval(CONSTANT)?
Importing csv
Access DB slower on one computer only
Commondialog control filter for *.MDB and *.accdb files
Run-time error '3075':
Differences accdb and accde
Repeat field value
Problem with PRINT REPORT TO PDF
loop thru records to create a union query
Re: One front End - Multiple Backends
Run Saved Import
ADODB from Excel - Running a Query
Adding a sequence number
Filenames with spaces
Finding and displaying images on a report?
Combining records Questions
Calculate number of days in months given a multi-month time period
How to convert a number to a date...
I want to install Microsoft Picture It 2002 and Vista will not tak
set properties of a passed textbox name
Creating Folders
creating new folders
Repeat field value
How to use varibles in SQL query
Silverlight for development is unstable!
Multiselect Listbox and AfterUpdate
Check if a back end is (still) password protected
RE: What does the semi-colon do in vba code?
Repeat Field Value
Finding and displaying images on a report.
Finding and displaying images on a report...
Choosing between two different images and more...
Use a combo box to find an Employee
Recordset problem
Repeat field value in next field
From Excel - Access run saved import then open query design view
syntax to copy text string from another field to clipboard
Re: What does the semi-colon do in vba code?
Erase data
Convert Access 95 to later versions
Preventing Screen Repaint - what confilicts with Echo?
Forms and reports disappeared from my access database
Function in an ORDER BY statement
Update Query
Pass Through Queries (Access 2002)
Get full UserName and UserInitials from MsOffice
Scripting File Library Reference AutoComplete
Cascading Delete Warning
And/Or Statement
DLookup, how to format vba code
Re: Parse space in Access field
Union Query question
Sending Serial Emails through Access
Re: string manipulation - extract various data
excel.exe process doesn't quit
Move to new record
Access 2007 Toolbar Issue
changing TextBox Caption
Comparison of text field values wtih Decimal symbol gives error
how to attach variable to fllowing command
how to get table values into variable
Function or Sub?
Error 2001, Access 2007, Subform Bookmark
Crystal Reports OCX
Calculating Time based on an 8 hour basis
Count no of rows appended
Columns in a form
Application Crashes
Custom Ribbon disappeared when DB split
Recordset with SQL strings
Use a string to define a field
Secure Hyperlink Fails
64 bit
Not Responding when VBA code is Run
FollowHyperlink works in Mozilla but not IE
Disable keyboard
Error 3061
Using predefined signatures when emailing from Access
Item not found in this collection error
Re: Code question
Appending mutiple reports to PDF using VBA.
connecting to Sql Server Express 2008 64 bit
application.hyperlink giving 490 error
Printing separate reports out of one main report
When Combobox is blank, textboxes should be blank
Copy A Module From One Project To Another
How do you get validation rules / text to work on an access page?
Multiuser environment ... poor performance and locks?
Filling Treeview
Undefined Function
Re: Coding to check for duplicate character in a string
2465 error, I think it's a syntax error
Preventing form move
public function always returns zero
Import WordPad RTF file into an RTF Memo field in Access 2007
HOW TO USE VARIABLES IN MACROS
Import WordPad RTF file into an RTF Memo field in Access 2007
Import Excel check field names Please Help
Re: Find missing number in a sequence per record
Import - only data that has changed
Import - Only data that has changed
passing form name as a variable to a vba statement
Slow VBA module in small Access DB
Rename file with no extension
Book on VB for Access '03 - Who can recommend a good book to get s
Count number of open reports using VBA
Change Form Background Color
Re: Find missing number in a sequence per record
VB to acess tables
import completed forms into access
Pulling ALL records in subform into VBA drafted email
Trouble passing string from Access to Word form with VBA
Re: Find missing number in a sequence per record
nested queries
Add Login Name and Date/Time Stamp to Table
Protecting a Report from being modified
Run Excel Module from Access
OleDb / Jet query randomly slow on high end server 2008 systems
Is field primary key or does it have a unique index
Test whether a Word Doc is projected
Track email incoming outgoing - Lotus notes
Linked tables / refreshing links takes long
Re: Help with DAO. Recordset
No records in access 2007 form
TransferTest
>> sql timestamp
TransferText
>> Handling sql errors
Re: Recordset show previous record when no matching record found
Re: Routine not working
RE: Routine not working
TransferSpreadsheet question
RE: Routine not working
procedure is too large
Passing string from Access 2003 to Word 2003 form
Re: How do i insert new record in between Records
refresh listbox using DirListBox
Assigning control sources via code
Need to findout if computer on Daylight Savings Time or not?
Re: Manipulating a folder
Re: How do i insert new record in between Records
RE: Slow processing
Re: Slow processing
RE: Manipulating a folder
RE: How do i insert new record in between Records
stop VB editor main window from coming up
Re: Help with DAO. Recordset
Re: Help with DAO. Recordset
IsNull() or Me.Doc = 0
Serial Date
Use a persisted XML file as datasource
Format based on value
Rejected email adresses that is valid
How to make an automatic backup of the db when the db is opened
Groups/Favorites
Tag Property
Tag Property
Problem with pivot tables
Issue with Linked Table
Find record with Criteria
Excel MIN Function in Access
Set form's properties from a Public Function in a utilities module
Cancel listbox selection
blank lines, text boxes, rich text
Chr() function doing weird thing!
CODE FOR EXCEL print col Rows NOT executing at all
Fixing the & sign
Email HTML
Need to create table of all folders and filenames within master fo
Select All Records
Text converting
DAO
Re: quick one...need vba internal variable name
Use of the "@" symbol?
Automation Error with IE 8 in Access 2007
Automatic record generation
Lost items in the Format / Size menu
ActiveX Control on Form using as windows explorer
Re: tweak this for me...please
Ticker
How to read complete lines in text file
Define text record with fields of defined length
RE: Check record to find non-number data type
Re: Check record to find non-number data type
Error Codes
Make Table query problem
Re: Reference libraries
OnClick Action for Ribbon tabs
After converted the Access 2003 to 2007, the program does not work
Dir() Function
Pass parameter to query from code
Automatic record creation
Create and Excel Workbook and create Toolbars
Columns to Rows
Dir()
Stored Procedure
Runtime 2007 and Linked Table Manager
Access 2007 Web Front end
Access 2003 Data page Question
Odd import error
HELP: Exporting from Access form to Word template and saveas word
Rows to Column
Working on all computers but 1
Triginomic functions in VBA
Bound Object Frames
Help with Rate() built-in function
Multi-select listboxes and All
Reducing balance depreciation?
Calculating GPA from our grade scale
Outlook Express or Window Mail is email client
Calculating totals in access
RE: Default error handling
On current ...
number records in temp table
Access-Excel Automation
method 'add' of object 'workbooks' failed
Access-Excel Automation
raya2020-msn-com tax;id ein,80-0341446 tech stock investor
Re: Default error handling
Runtime 3075
How do I insert a Hyperlink command from code in Access 2007
Re: Acess 2000 - calling oracle user-defined function
To select null in a cross tab as 0
Calendar Control in compiled program
Displaying custom ribbon with Pivot table
Design Help in Access
send email using lotus notes - Tbl data in message body
Can't pass VBComponent to Sub Procedure in VB.Net
Using VBIDE.VBComponent in VB.NET
How to send ASCII messages to port
scroll to last record
Isn't grid order determined by tab index
Programming 'Check for Updates' Functionality
Auto Dialer
SQL - VBA once again
Running two routines at the same time
SQL -- VBA
Convert Percentages in Table
Interfacing access with a PLC
Re: Check to see if object key is in collection
save button on form
46 Opinion Dsiconsolas.com
TransferSpreadSheet Is Not Reliable Within Loop
HYPERLINK QUESTION
Text feild check for pattern or if last 5 are numeric?
How do I know when a class object exists?
A2007 Using Tony's AutoFE User still locking FE db
Acos calculation
Printing Mailing Labels
Write File Adding Extra Tyte
Splitting control source value string in report
change focus to hide form
Splitting control source value string in report
Passing arguments by reference to a Form
Find/Replace
FTP
FTP
Re: Using a function in a different mdb
msg box vb YesNoCancel - Promtet twice on Yes
Test Message
Re: Using a function in a different mdb
Re: Using a function in a different mdb
Data Migration
Timer
Update certain record fields in one table if data exists in anothe
How do I copy and paste a record using RunCommand in Visual Basic
Need help getting query data from subform
RUNTIME ERROR 3000 RESERVED ERROR (-1104)
Re: Import new .txt file only.
Is there a way to force page set-up margins to 0?
Set default folder for File Dialog
New Record in a subform
RE: Need help with this code
Compare Access entry to Outlook address book
pdf format in access 2007
Access 2003 Report & VB Problem
Saving a word document but maintaining the document with its bookm
RE: Memo Help Box
Transfer text?
Re: Working with dates
RE: Adjusting the main form height
RE: Working with dates
Vista 64bit with UAC preventing good copy of MDE file
Re: Adjusting the main form height
Re: Reference class library
Vista and Access 2003
get sum from subform on button(on main for)click
How To Determine Filename Saved Date
Error 3048: Too many databases open
Access Combo Box Refresh
Adding Redemption code to Access Module
Email 180 column table/view dilemna
Need to create a dynamic recordset using generic field names
Re: Outlook Address Book
Access VB Run time error '2136500594 (800f00e)
Syntax error (comma) in query - ?????????????????????????
Office DevCon in Australia
Syntax Error (Missing Operator) UPDATE Query
Adding new records to subforms
Programming Conditional Formatting using Multiple Criteria
Storing images in Access
Bound combobox
Exporting to excel from access using filter
Setting Excel cell formats from Access VBA
Problem inserting time values from Access into SQL Server
How to catch (and save) the *number* of updated records
Access 2007 Form - sqlserver2000
Update combobox based on system date
Trim, LTrim, or RTrim will not remove spaces...
Best Event to Use
Control Page Setup of a Report through Coding
Timers and code...
vba command to email attachments using Access 2007
limit calendar date range
Delete using join statement
RE: label detail method compile error
Runtime error 429... Cannot create Excel Object from Access
Improving treeview load time
Not able to enter Chinese 4 byte characters (GB18030)in MS Access
delete warning
Your Own Solar Panel Review
Create word document from scratch, from Access 2007 data
start up with one form adn switchboard
select multiple records
titanium ecm2001 crack torrent rapidshare download free Mz+auqrj!W
Can Access 2003 and 2007 run on same system
Font
Suppress display when outputting to a Snapshot file
Show Only the Decimal Part of a Number