Microsoft Access / VBA Answers - Page 112

vexing decimal problems
How to attach an SQL statement to an unbound control????
Need Asssitance with On Delete Code
Can't Open Anymore Databases
MDE
"Catch all"
Dates
ADO not registered anymore
Access-Datensatz an vorhandene Excel-Tabelle anfügen VBA Function (Office 97)
relating queries to tables
Linking to Act
Replication ID /CustomerID problem
How do I create an Icon in a form to Print a report
MouseHook and Tab Controls
Readable lables in a Pie Chart...how can I?
Network Update Data,Information needed
form fields and problems with recording data into the table from the forms
Forecast Report
how to retrieve 'quick launch toolbar' folderpath help!
Calculating subsequent field values in table
append property
Need autonumbering help (novice level)
Access to MySQL
Access 2002 Database Design Help
Display updated Totals
Query Help
Error 3020 Update or CancelUpdate without AddNew or Edit (Form Error)
Beyond my scope =-(
Can't change admin. password because tools menu missing
queries doesn't return new records
Anyway to change the "style" of an existing form??
Count distinct occurences
Re-use report by using a query to filter
Jumping to row in Subform
Are drop-down menu itmes stored in table?
Sympathy for Starwars :)
Method to Display Future Popup Messages
Prevent Deletion of Keywords in a Combo Box Table
query with criteria on two fileds in one table
Updating records in related tables...
mde
MS ACCESS Reports
How to create own tab delimited file
Create Read-only file in MSACCESS
Word files import to access database ...?
how to refresh the "other" data base window
Microsoft Progressbare V.6 how to use it ?
Link To Selected Fields
Running Access 97 on Windows ME
invalid arguement when updating memo field -- size limit?
Access VB6 Integration
Please help
Date Conversion From Text
Determining Field Type and Loops
BackColor On TextBox
acting on null recordset
Help with Function to redisplay a cost price...
Publish to web, Local option only enabled?
? about closing this popup form
value substutition
One last question about using GetObject...
Force Textboxes to new page in Reports --- Help
Forcast Report
Average Payment in Days
Adding a column to an existing table with data
Access 2000 and Calendars
VBA Event Procedures in Form Module Lost Association to the Control on Form
Wanted - report writer to access ms-access databases
Creating a Timesheet
Average Payment in Days
requery problem
Windows 2000 Server Listed as a User in an Access XP Dabase
Access 2002 deployment
LIstBox vs Combo Box for looking things up
Forcing zeroes as beginning of Key Number (ie SSN or Zip) and SSN appearing as 2323E+08
Table Relation Question
Adding Records using DAO and variables derived from queries.
time based message box question
Is there a way to speed up execution of this code?
Concept Question
Code to duplicate records
Help with pictures
Calculate in Text Box speed
user input to query
Writing to a file with VBScript/ASP sometimes gets truncated - why??
Advise please
Outlook Express <-> Access97
Help with dlookup required
Access Forms flow--> Visio
How to distribute app with Jet binaries?
should this ng become moderated?
Median in a Query
Upsizing question
Print quality varies with Access version
Building an expressions where parts are unknown at design time
References
How to access a control through code?
datepart to get mmddyy from date/time formatted mm/dd/yyyy problems
Problems With Access 97 Falling Over
MSDE 2000
download data from access ????
How can access desktop access database from my unitech pt930(s)
Text criteria weirdness
Web Enabled Access 2000 Database
OnNextRecord
HOW DO I ADD a vertical row of values in Access 2000??
More getobject help, please
Security Issues In a Multiuser Environment
query to combine two tables
Mapi Fails on MapiSession.Outbox.Messages.Add
I Am Really Crazy
Acess 97 toolbar help wanted
Bibliographic formatted references
Forms Format
Strange "Mystery Record" Behavior
sql server pass through query
Supress Automatically opening modules
Building ODBC Connect strings that work
How to use SQL queries in a report????
ADO recordfind help
Can't compile anything????
=Format$ field doesn't work after copying database to new computer
Subtract one year accurately?
Groupwise Email from MS Access 2000
Calling a function, basic question
How to know if instance is already running
Access 97 less available records
How to put a menu bar DIRECTLY on a form.
How to print tab in the middle of string in a report?
Backwards Conversion
Storing Only One Value?
Future of MS Access......
401K Account Fees
Link Code Modules instead of Import Access 2000
Check for a Date then do something....
Payroll Hx Table and Reports
"The field is too small to accept ..." error for a bound control on a form
Update Query - Finding and Updating Maximum Order Number
Sympathy for Starwars :(
please help me -microsoft access help reqired
function(s) to split an e-mail address into user and host
getobject
access 97: duplicates in query
Editable mde ...
Form letter question
Form Controls Colors
Import table
Interland MS-SQL Hosting - somewhat OT
Is there an Access 2002 developer kit?
design question
Access to SQL Server
Append Query - Increment Order Number
Bandwidth Required For ODBC Access
Start and End dates of gaps in date range
Need help! Trying to auto fill in a form
RECORDSET NOT UPDATABLE
Make Table Query in secured DB
multiple ifs converted to case statement in vb function
dates - vacancies and bookings
ASP connecting to linked table in ACCESS (cannot find the input table or query)
ASP connecting to linked table in ACCESS (cannot find the input table or query)
0 or blank Data Entry field on a form when tabing or clicking to enter
How to resize form from code?
Access 97 upgrade question
OT (a Little) Book Publishing Deals
Names of the variables as SUB arguments
Query Date parameters promting order question
Clearing a binary marked field
Different text styles in the same text box
using Find property in a form to locate records in a table
Tablecreate Query
Outlook Redemption
Last 5 items loaded
conversion -MS Access 2000
Use project without revealing tables, queries, ...
Add controls to option group
Parsing Subdirectories
Import to table
Urgent: No database objects visible in .mde
Create PDF from Runtime/Distributed Application
Help Displaying Tables in DataSheet Format
Access 2003 Default File Format
Can this form be made in ACCESS?
how can i make unbound box limit to one line
Re-using Old Autonumber Values
make source invisible
link helpfile in a button in the menu
importing and saving an image
On Not In List
Connect to Security DataBase (MS Access 2000)
Getting NZ equivalent in an .adp View
documenting access apps
Can't read data from a table after saving record from a form
mssql server to access script
Send file as attachment to Outlook Express
Select distict and order by in a combo box
requery after date picker
Combo Box Query On One-To-Many Form.
Problems with IIF
Using alias in expression
Encrypt source
Date Update!
Null Values to zero
If-then statement in query
Growing database
Hyperlinks to Powerpoint and Word - how much control does VBA give you?
Using VBA function for Forms
Losing it with Report/Sub Report from Union Query
Outlook calendar in Access
Access and Cash Register Operations
Displaying only a startup form
F11 does not cause the form to break
Problem with images
Trace which Key button was pressed?
Task to convert A97 to A2000
Table w/ Autonumber AND Cascade update
Having A Query open a Form
Engineer Avail
Finding field names through database
Duplicate value in field or relationship
How to fill a two-column list?
VB, PC to UNIX, mySQL, PHP Freelance Programmer Wanted
Prerequisit to learn Access
US and UK dates confused
SOLUTION: run time error 3146 ODBC call failed
Form with Tab Control
A date problem?
Set variable from value in a table
blinking control in report ?
Subform refresh??
Filtering Dilema!
combo box to find records
About to install Access 2003 - already have 97 and 2000 installed.
Combo Box Query: Listing a subset - Revisited
How to post to a remote form?
simple way to link an image to a table entry
Create cXML-File from Access97
Reasons for upgrading to Access 2003??? Backwards compatibility with 2002?
Update Query
relate two access databases
Timer Component
HELP! - Missing Access 2000 components
DateAdd Glitch?
SQL select
Multiple clients (seperate db) one master (sees all db's)
? about displaying total from subform on main form
openrecordset without using "set variable = "
Grouping in a report
How do I refer to a subform (VBA)?
Microsoft Access can't send this e-mail message
Save from combox bound info to table
Delete current record
Null in subquery returns no records
Multi - Select List box Question
How to Prevent ControlTipText Pervasiveness
Relink just not right....can someone help me please
Charts in Access
Access internet linkups
Oracle Person Needs help with MS Access Queries
On form open, expression has invalid reference
Pictures in image control don't refresh
Missing data when exporting to excel
formatting a Text box for hyperlink
Alternate backcolor in report
MS Access - Crystal Reports
Security on back-end Access 2002 database.
Stand Alone Access Applications
PostgreSQL back-end. Ref. integrity violation in transaction.
Out of Memory
Calendar Control on form
start-up projects
Image Handling Problems...
Switchboard - Hide the Database Objects
Entering a Date/Time parameter?
The memory could not be "written".
Adjusting the X-Axis of a Bar Graph
Form created as datasheet; displays as single form
ADO: Can I insert a stored procedure in a transaction
opening recordsets
ADO: new ID after insert
Query Help - Returning the Difference between Two Values
Help out with a difficult query?
Change default reference from access11 to access 10?
References
Why does Access get confused with the result set?
Acrobat 6.0: Print PDF by VB Application.
Auto populate field based on recordset and coding
Getting last entry of field for default value in form
Weird Access 97 MDE behavior
Msado15.dll
Query for Report to allow choice between 2 date fields for date range
How to connect access remotely
Parsing an XML file
sql optimisation
Output To Formats Missing
Writing from unbound comboboxes to tables
Subform will only show 6 records
Before Update Event for Text Box Contents
Creating duplicate data
Need help on importing an Excel Sheet into Access 2000
Subforms - 4
Hours and numbers
datetime field overflow (year 1899)
Showing same ref number in 2 Tables
Modifying Objects in Access XP
Combobox help needed...
Stumped, Desperate: Word 97 with Acc 97 on WinXP...
Recordsets .. why the error message?
TransferSpreadsheet fails in simple reproducible example
Create List of Report Recordsource Items
Auto fill in without one to many relationship.
Merge Records From Multiple Sources
Frontend on Windows PC/backend on a Mac?
how do I use word doc in access
Linking from Access 2000 to Access 97
Time portion displayed when field has the focus
Charts in access - serious troubles
Compile error: Can't find catalog - But the reference isn't missing!
Relationship between tables
Capturing e-mail messages from Novell Groupwise in Access database
multi-select list box
ERROR Message in report
Moving between forms and other bits
Repost: Really no one knows about this? (Pivot table)
Video library database
Line Method in Access Report
Linking table SQL help needed
Help with union of 2 tables
Custom Navigation Button Woes
Cascading Combo Boxes to Control a Subform
Automate faxing in VB VBA from MS Access
Hints to speed up 1 form
Report Section Height Issues
Access and LEADTOOLS
Access2000 can't find Utility.mda file
Tab stop ??
Can you format a field as MM:SS in MSAccess? If so How?
.AddNew does not work if a relationship is declared.
Usage of db1.mdb file ??
Code to validate StartDate and EndDate
Prevent a Specific Value in a Text Field
Mulitple Main Forms Created by Sub Form Entries
Access 97: Print report without type CTRL + P
Split database
why is visual foxpro 8 much more expensive than access 2003?
Converting currency
Date Overlap Challenge
Display record number of record count in a subform
Problem with decimal number smaller than 1
Updating Form Data to Table on Event Procedure
Using multiple tables as data sources in forms
Duplicating data to different tables
Export Access table into another DBMSpreserving Unicode characters?
Need a familly tree schema
Requery of combobox doesn't show properly
Updating Forms
Sub query problem Access 97
THANK YOU!
Scrolling in a Combo Box
not able to make changes in table
Phone Input Masks - Area Code
Efficiency of SQL UPDATE vs Recordset .edit/.update
Dealing with Name data
Make Table Query Question
"Object No Longer Exists" error on one machine, but not another?
Outlook from Acces (XP)
Pivot table in data access page on Win 98: fields OK but no detailed data
Front-end bloat
Passing field valuse to stored procedure
To save from a temporary table??
SQL "in" statement anomaly
Text Box Control unbound doesnt Sum
Select names begining w/same ltr in query
Why is the Switchboard Manager grayed out????
Question about Joins in Access
Search form to display results in results form: can't invoke sql
CAlling a web service from access
Seasoned Reports suddenly quit working
Design Check: Creating a Yes or No Drop down box
Access will not close
Auto email with Access 97 and Outlook
Sharing a MDB file on a Windows 2000 Server network
Problem with a date query
Scan for each matched record
Help!! Time Calculations.
Any foreign character mapping charts available?
Count records on a subform recordsource before/after populating?
EXPORTING Q&A DATA
Size of report file
Print problems
Combo Box -- Sub Menu
how to send an e-mail to all record of a table?
Calculating Dates
No close (x) buttom for the access
Different version of Access for frontend and backend.
Import changes
Changing Formatting of All Controls in Current Record
Access Help Pls....Can pay some
Export lossless
Print acSelection (i.e. single record) from subform
I'm goofed up in On Error
Can't Move Between Records on a Form with the Navigation Buttons
Can Grow in Report Still Not Showing All Data
Sub Menus in Access
ListView ColumnClick Event
Good DB design question
How to make a datasheet work like a spreadsheet?
Weird Compile Error
Sum Unbound Control on Continuous Form Footer?
RTF output not identical to Snapshot output?
Slow query
Report Filter in VBA
Calculating Elapsed Minutes
Relations not visible
Is it really necessary?
Checkbox like hotmail or any other web-based email
Access 2000
Reports
Handeling months in access
Is this a bug?
sorting question
Computer User Weekly?
Access 2002 printing in upper corner of paper
help with images and reports
How to see a picture in reports and Forms
For Steve Jorgensen
Problem using query to supply Default Value for textfield
database objects
Using Switch() with numbers
How to import VB source text files into Access?
Access 2003: Forms!MainForm!Subform!Control problem
Collecting information from Access Applications for Word
Calendar-type reports in access
Tweaking the Control Text Tip
FirstName/AltFirstName in code
Lost tool bar on form
<<NEED INFO>> Access XP Documenter question???
How to delete empty "Microsoft Access Class Object"
Assigning a Variable OpenArgs
Popup
Action after closing a table
Virtual Keyboard
Hiding the database window
Lost tool bar on form
Lost tool bar on form
Use New for multiple rept. instances conflicts w/ ControlSource on open
Lost my tool bar on form design
Rapid Chart displays like a movie.
ComboBox Selecting Specific Records Filter
Detecting When A Subform Has No Records
compact an mdb
testing an Access application
Access97 hangup when reading corrupt file on DVD
validate fields
Date/Time Calculations in MS Access 2002 using a MySQL backend
using multiple click boxes to store entries
errore 3343
Subtotal From Subform To Mainform
[Error]: External Database Driver 11265
Newbee TransferText question
Access Simulated Functionality Limited
Conditional Concatenation in Reports
Base for Parameters Array - OT
reading external data that hase 2 formats
Object Variable question
HiTech United Weekly Newsletter
VBA functional equivalent of "IN" or "AMONG"?
How to use Function to pass query parameter?
Query based Report with One-to-Many Table Relationship
expression problems
Help wanted: what source code to use with form field rules
Setting a new COLOR_APPWORKSPACE in Access 2003
VALUE SAVED BY COMBO BOX
Access IRC Help Channel?
have to use Access XP with wireless network
ListCount bug with column heads
How to Derive Dual use of Combo Box
Web enabled databases
Assistance with Open Recordset Or
Access 97 upgrade to Access 2002
multiple stLinkCriteria?
Import/Normalize strategy - More issues - New thread
Plargiarism Database
Mailmerge no longer works with Word 2003
Integrating MS Access with SAP
Saving An On-Screen Report To A Snapshot File
Mulitpile Pics in a report
Forms question
Form Tab stops
access97 parsing out enter and tab spaces in fields.
Inserting text into MS Access with ASP.NET
Access 97 license error
Creating PDF's and Bookmarks
Database encyrption?
major problems with Package Deployment Wizard.
Moving Fields/Data from one Table to another
Launching an add-in from code in a multi user enviroment
Default Value in Drop Down Combo Box
Office 2003 Backwards Compatibility Issues
STDEV()
Form/Subform problems (OpenArgs)
Calculating age
Access97 running on Windows XP: unable to create table / query
Converter Workgroup p/ Ac2000
XML Import Error
Multiple change text
Preparing data for exporting
Date() function in Access
Time diff between records
Automatically Creating and Sending a Outlook Appointment
Access Shutting Down On An Error When a Query Is Run
imgPicture/StringLink
Easy sequential record numbers in Access queries
Access in a workgroup?
Calculated field question????
Report Creation Problems
Using a subroutine to populate a field in Access - how to tie to field?
Select Max to Get Value for Field
Subform/Main Form Calculation Problem
me.refresh issue (reprise)
How to print section headers when no details.
A2K2: Image control cannot read .GIF file
Date Calculations
Binding text boxes to fields in a query
zoom a report 250%
Goto Helpfile
Color coding in 1x1 BMP in OLE field
helpfile(help&manual)
Riunning A Macro from VBA
SQL - SELECT DISTINCT
Refreshing Main Form Field
How to create non-unique index with DDL?
Compile error: Method or Data Member Not Found
Access User Utility
Form / Subform Problems loading Data
Report running sum-Help with DSum
Q823718 Security Update for MDAC: TransferDatabase command changed?
QUERY BASED ON TEXT BOX
Using a command button to edit a memo field
How to Migrate Access Users/Groups/Permissions to SQL Server
binding fields
Change line height at print time
subform data from 2 other forms
Performance issue: combo vs pop-up form
Access 2002: #Error Sum
Quit, Close and AccessXP
Import/Normalize approach - column-DML, or loop
Viewing Reports
MS Access odbc issues
conditional delete