Microsoft Access / VBA Answers - Page 110

Option groups and reports
<<HELP>> Companies that provide software support
Stock control
Sending Email and the lovely SendKeys command.
Num Lock
Type mismatch
How to allow user to select records and modify field
Validation Rule
Help with VBA
MS Access Web Page with pictures?
OpenForm
XML Nested List from Cascading Relations 2
use data from form on query?(noob)
Main table and 32 Sub tables
again: datatypes Access 2003
Frequency Distribution question
Reverting To Old Value if Validation Fails
Access 2000 file format on Access2002
? User level security glitch
Access MDE distribution question
XML Nested List from Cascading Relations
Sharing Access
Remote access to a ms-access db
Backing Up Ones SQL-Server Data as Jet
MouseWheel off without DLL?
Where do I put my code?
Query Parameter drop down box???
Access hangs
Outlook 2000 into Access 2000 Can't see HTML message Bodies
Unique index and null values
access/outlook automation incoming emails
Referential Integrity that isn't
Is it possible to programmatically close a MsgBox?
Data type STRING?
Print selected records from combo
Application Title
Opening A Secure Database
Splitting Access 2000
Controlling a Find Query
Storing a persistent value
default set to 'max+1'
How do I print a report with data JUST taken from a form?
Access 97 Cpu useage
Access 97 Cpu useage
Access 97 Cpu useage
Opening MS Word File from Access Form
Workgroup Security Failing across a LAN - any ideas out there?
Lookups - What's Best...In a Table or on a Form?
Calculating week numbers from dates in other fields
Question: Parameter value query?
DLookup in a datasheet form
sorting arbitrarily
Who could solve this bug (in my balanced line)
Using Proc to return RecordSet to Subform
dragging existing controls onto a new 'tab control'
Help
Open/Save-Dialog
Using a VB function to update records
Access Runtime Error - Tahomabd.ttf
Need to buy access 2002 , 2000
HELP! Query Ambiguous Outer Joins
OLE and photographs
Compact on close not happening
Writing to exchange contactitem fails
"Access Cookbook, Second Edition" Released by O'Reilly
Table update
Unique ID system -- multiple data sources
OT ish. UK Ltd Company Status. Anybody done it?
Join & Minus Tables in Access
Creating unlimited records
record count
Multiple link criteria and new records
What is the latest version of access
Scanning data into Access 2000
Strawman: Is MS Access a "database"?
File conversion
Sum trouble
League Table design
Use MS Access databse under chinese windows
Exporting/Importing a single record from one DB to Another
Launching Microsoft Access via javascript - Will not stay open
Queries and Like
Value from ActiveX Calender
Need to Average Grand Total of 14 fields
Combo change to Text Field on a Form
Docmd.OpenReport CRASHES Access '97
Can you update a field in a Select query automatically?
automating oracle ODBC driver connect login
Printed Serial Numbers
VB to Access
Format text within embedded fields
scroll down automatically in subform
after installing office 2003
What is this Jet Engine error while creating partial replica?????
Creating Pivot tables
Better multitasking when running queries?
SUBFORM goto a Selected Record
Access database works for some users
Form - Subform
Access query Help..
Calculated Field Not Requerying
No Of User Connected..
Reconnecting Front and Backends
Print from date selection
Docmd.Runcommand accmdsaverecord vs Me.Dirty = False
Form question - how to distinguish existing records
Sorting RecordsetClone?
Showing datasheet
Maximizing forms
Problem with segmenting an ACT database (records will not export)
access form display question?
Just Venting and a Question
Excel Pivot Table from MSAccess 2002 - 2003
Append query from two tables with different fieldnames -- easy linking?
String function in query not working
Update or CancelUpdate without AddNew or Edit Error
Problem inserting record into Access database
MS Access Project Explorer showing New Icon and Crashing with Errors
Pick a record at random
Multi-List boxes and navigation
Read-Only
Update Query or VBA?
Determining if an Access Project is open
Locations of .dll files
Append query, "invalid password"
Prevent tabbing across multiple records
User Input in an Access Report?
Complex "IIf" Statement erro
Reports - Mystery Data Origin
how to speed up access?
How to bullet-proof mde?
connecting to password protected backend.mdb in VBA
Use the input from a query
webbrowser control
Wildcard help
How to change the contents of a combo box based on another
Access 97 linked to SQL 2000 large fields problems
Either open in exclusive mode or do not open at all:
n-rows or one
Carrying over a name to a subform
Forcing Zero in Social Security Number Field and Putting Cursor at Left for Data Entry
Prevent characters
Update Query
form - populate several fields before display, and on repetitive use
ReConnecting Front and Backend
MS Access Connection Window in ADP
Query parameter with a combo box
dynamic sql via code
Upgraded to Office 2K - SP3, now Access wants Password!
Using Combo box and text box to Query table
Check Print Queue
display last update in a form box/field ?
date sort in Access 97
Password protected backend problem
Combo Box Question
DDE functions having no result and no errors
Data in Reports - Where is it coming from?
Old Programmer
Old Programmer
File Locking Problem
Code returns unexpected Null for Listbox Column
A97 Import from CSV via ASP page
how to declare more than one variable
(Access97) Does not list Excel as an EXPORT Option
joining two action buttons
Need Calendar Function
SQL - join hassle?
Help Please!!
Visibility of controls in a Sub-Report
Access Front End Stored Procedure Advice
Addressing Multiple Proc Parameters
DDE & Access 2003
Relationship finder for reports
Change query from textbox on form
Try #2 - Inheritance work-around in VBA
Assistance with Posting Multiple Payment Activity
tapiRequestMakeCall - How to customize behavior?
Creating a query with current day but a standard time
MS Access Date/Time Data type mismatch
Problem with INSERT INTO statement (Access and VB .NET)
Problem witth Combo Box To View from Linked Server Database
Finding out of sequence numbers
OnAction executing twice
Calculating against Nulls in Access Query
Empty/Blank form appearing!?
Help needed printing groups of linked documents
API Dialog for SelPrint
Form Input handling of Many-to-Many Relationship in Access
Access 2003 Questions
unique data in a table.
Visible property on a mask (MS Access)
Datasheet Subform - Change the width of a column
MDB file
Want my subform info to autopopulate...
Names of OLE objects
VBA for beginners
Can access go to a website and read the contents of each page?
Beginner's help using count/Dcount function
Locating Source Locations For Linked Tables In Access?
How to get Macro contents with VBA
Goto Last Record and Open Form at same time ?
CheckBox in qry with GroupBy
ControlTipText on subform?
use existing connection or create new
<<HELP>> Problem with recalling a record and displaying it on the form!
command buttons
How to invoke system command from VBA?
VBA beginner: how to run VBA code independently of Access
Report capturing data from 'red flagged' field
Complexity in Posting Payments Using an Update Query
<< HELP>> Enter Parameter Value in query
Calling form's methods using a string
Tool Tips disappear
Warning. Min/Max use on fields with criteria
Carriage return in memo fields and queries
getting multiple fields onto a single line
My Code has Problems: Opening specific records in a form based on closed form ?
Display suggested completion for text box input. How?
How I can check file existence including subfolders
Barcode Integration
Set Default Max Records in VBA
HostName Function with Access2K front end
Problem with Access runtime and the swedish language
Copying between subforms, help please.
Access recognising screen Res
Sub or function not defined
ODBC for Access back end in WAN environment
Query criteria problem
Access VBA: References
What to do with an empty query in a report?
opening specific records in forms ?
Sum/Count on Aggregate Query
Error 2486, Access Data Project
"Cant open any more databases" error
transparent XP icon
acces 97: export multiple queries into one workbook
MS access - Unique table for several cash & bank accounts
Lookup/Update Query
Lebans' calendar
Format Function
Error -2147221231 A2002 developer
Weed out words...
Connection to SQL Server
Stuck on images
Windows Login Name
security with one user name
Passing arrays to functions
Multiple Users Running Same Query
PW logout
"Save as HTML" feature in Access 95 or 97??
1 button reports faxing
Changing print orientation in a subform
Need to upgrade - 2002 or 2003?
URGENT!! Problem sending data to field
MySQL
Finding Windows Install Key
Max fields
Integrating Microsoft Phone Dialer ver. 5.2 with Access 2003
stopping warning messages
How do I send Instant Messages through VBA?
Parsing out Firstname from Given Names
Either open in exclusive mode or do not open at all:
Help! Why won't this just print ONE record by TransID?
efficiency of query
Customising Buttons
Loops for Parent/Child relationships
Exporting Reports to RTF format causes unexpected truncation
Omitting Records in Union Query?
Maximum Length of Query String is 512 Characters?
Column Property of a Combo Box
Access Query Date Range
Group Level on DAP bug? limitation?
Using standard Publish It with Word facility
Access 97 changes Paper Size in Page Setup in Reports
can you do this in access? strings mentioned
SQL Question
Why does HyperlinkPart return inconsistent values?
3 part adp project
forms
Finacial years
Is there a function for the following calculations
Problems accessing a MySQL database via an Access linked table
Compacting a backend Acess 2002
Union qry format
how to "disconnect" database connection in Word mail merge?
Q: Help with recursive tables needed
Using Graphs on PC with Access 97 and Access 2000
Card Reader Information
How to ensure SendObject open Outlook and Not Outlook Express?
A2K db crashes after A2K3/ADE installed
Create Access 97 MDE from Access 2003
No data for subform after Proc executes
What's wrong with my email code?
DYMO Labelwriter
Command or Action 'Setwarnings' isn't available right now?
Filtering Queries that use a fucntion to return a value (Null Values in a Date Datatype)
Error with VB/Access StringFromGUID
Setting focus on reports ?
Sub-Report to hide un-checked lines...
Force new Column in Report??
Is Access 2003 slower than 97???
RunTime Error 2455 in Access 2000
access 97: option group and runtime error message 13
Running Access 2003
Save As button greyed out in main menu(disabled)
Recommendations for a Web Integration Package for Access
Only first digit returned to VC++
Require MS Access Version 2
ADP to SQL Server over DSL connection?
combobox trouble
help in two forms
Faking inheritance in VBA to remove code duplication
entering the same data in several fields
Auto size forms to screen res.
Number of characters in a record 2000?
Importing data from excel via command button on a form.
Previous Date
slow to open forms
Autonumber Problem
safety warnings upon starting up
How to ensure outlook is use during automation from Access? Not OE?
adding a field to an recordset
Querydef problem in mdb>adp conversion (A2K)
I lost my DSN...
My input form just went blank
Repeat Post: Need to lock a group of combo boxes
Tables from Excel database
Outlook Distribution List
query prompts
Error when trying to update SQL Server from MS Access
VB code for copy
Filtering out words?
Data disappears from database
Error not showing up
Member of Workgroup, but ID and Password Prompt to do not Appear
Combo Box/SubForm Index
Trouble with Check Boxes in records...
Bugs in Clearing Form
Pass null-value to function (How to..)
Access: Protect data in tables from copy and export...
external image files on a report
Please Help: Production list DB
Placing a black line through deceased items
Need help with opening excel worksheets and text files
combo boxes flakey
ACCESS: Make a Search Form
Reference Book
Slow down after design changes
How to reference individual cells in Excel via VBA
ACC2000: Import with TransferText
Silmultaneous instances of MS Access 2K
Why does Access freeze when linked to Oracle table with Timestamp column?
hiding fields in forms
Required Property
Number of items in combobox
Setting Subreport SourceObject Property
back-end being opened in exclusive mode... how?
Help with VB Code to open a popup window on the "After Update" event
Access Report when exported to MS word Problems
access 97 importing specific excel worksheets
Query Help
Problems with simple login form
testing
Record Specific Email Activation
Security/Permissions questions ACC 2000
append query or other to perform a task?
DLookup() problems Please Help!
DSN Nightmare
Automation error on reading a recordset
bdp ms access connection string ?
Why doesn't Like work??
Asking for assistance
Default Design values
Sending email from Access
splitting a memo field into 2
Date() in a form module
Access:exporting memo field to RTF
Move to Last record on a subform
filter in copying data from other database
ADP: How to handle work tables?
Access: Option group converts to integer
Active Records in a multi-user setting
Strange problem when quitting program after library reference updates?
Access2K connecting to SQL Server 2K
Vbe6ext.olb File Please
MD5 crypt in MS Access
Help needed.
Emailing Data...
Please help me. Multiple problems/challenges
Room Booking Database
Open Word from Access
Strange Access effect on CPU
Maxing out a filter string?
Access 2003: "Activation"???
SQL Window Font: How To Change?
Access having 2 VBA connections to current db
Multiple Values in Single Field
Subform - was working; edited design; not working
Form Timers
To create tables with VBA - To name the new table from a mask'txt box
Getting the first letter of a field
Combobox - option ALL
Subform screen problem
Correlated sub query crashing report/not allowed sorting
** Room Booking Database **
Union Nulls. Why is 4/14/2004 less than 4/2/2004?
sum() in report footer destroys detail order
Dual language interface
Can I add records form a table and related records another table to a third table?
referencing charachter sets
Network access - table locks up
Converting Number to Text
Prompted Twice For Filter Criteria
Text Import Wizard Interface Problem
Execute SQL Script
Locked out from MS Access database
Determining whether object exists
Repeat post: Windows Installer and Access 97
CMD window will not close after Batch file executes
Linked tables troubleshooting
multiple viewers in an access database
adding fields to forms in access
Hide calculated fields in continuous forms A2K
excel automation question
Error import or attach external DATA (sort error)
Turn a String Into An Array of Characters
Load Subforms Dynamically?
Help...Filter Subform Wirth Main Form Button
Minimize access window problem
Locate Current Addresses
Question on click event!
Excel Formattings
hi.. question
get 10% random records out of 2000 records
SQL-DMO tutorial or sample code?
series of pictures on a report
Trying to link a form with a subform
Work group file recovery
Multi-table form
delete all suffix automatically
File Name Increment.....0001.tif, 0002.tif
How to distribute an Access 2003 application?
Can't make an MDE in Access 2003
A questionf format
Challenge-Printing to an FTP file printer
Data entered through Web not recognized - help
Access/SQL Server 2K Connection String
Access ADO Report List
Dynamic Report Field Data
Need help with Input mask
Solution (Was: Calling Stored Procedure with Paramaters from ADP / Visual Basic)
Variable table name in SQL
Access development questions
How to subtract in Access
Carrying payroll data into new records
Error 429 With rectangle class
migration problems 2000 -XP
Unable to Export Access XP Data to Excel
business to business, off the shelf, ms-access applications
access MS-Access database in C# Windows Application
Can I pass a filter to an update query via vba
2nd post - SendObject problem, email body won't populate
Auto email a report
null date/time value
Wildcards with Like in Microsoft Access
My code wont work Why?
Index question
Sequential Number
running a script from a page I was redirected to
SendObject and filenames
Renaming a field based on content
vba Sql question
Sending email
Access to Exchange Server 5.5 Public folders
Color-BackColor
showing only relevant information due to active textbox
Trapping Access Messages
Access 2000 and Chinese font(s)
3rd party Utility to import Outlook Contacts, no matter what version of Access or Outlook is installed?
Magnetic Reader/Writers
Can't Update an Updatable Recordset
Dynamic Form Field Query
what do you do about code? mde or not
Moving from mySQL to Access
Sorting a query on part of a date.
MSysTables problem
leading zeroes
outlook
mdb2exe
ms access - assigning pk via sql query
Generating event-code in MS-access
Duplicate Query Expression Question
Are columnar forms possible?
Create and Pass custom date to form, query and report
Summing a specific groups
Prohibiting Changes to a Database Design
Selective emailing
Access to excel
multipik boxes updating tables
Updating field, Form to Table
adding Unique ref number to each row in a query??
access vba function get form caption
Emailing from within MS Access
highest and lowest date
adding a record into a sub-form
AccessXP/Access2003
CDMA AWARDS 2003!
How do I zip an Access database?
How do I zip an Access database?
Tab Forms
Form Tabs-Stop User
Access 2000 Developer and SQL Server 7.0
repeatedly creating object - bad?
Input limit in queries...
Dealing with corruption errors
options for printing report
Getting value of last auto-number
Record manipulation
last updated time
No current record err msg ....
How can I mask data in a query?
2003 Access won't open ANY database
Automatic Querying a number of levels
validation rule for alphabets only
Access 2003 Developer Extension
Single selection in List Box
Add a Fields to a Table w/ Existing Data
Updating form fields when table changes
Populate a continuous form using ADO
value to a perl script (vb access)
Host mdb file question
Hotel database
Calling a Function
Help with statisitics
Auto-calculate a form based on another field's contents
Saving and Downloading a single record
Assigning values via loop
Assigning values by looping
what is faster sql or movenext?
Can't copy record
Using same query criteria input for multiple seperate query fields
Can't connect To MS Access DB with ASP
3rd and 4th combo boxes don't pull the correct data
Disappearing Menus
Problem with Date field
How I got it to Work!
Form link problem
Linking Auto Route 2004 to my access database
User-Defined Functions in SELECT Statements
Selecting field contents when TAB in it