Microsoft Access / VBA Answers - Page 112

Scroll in subform only down, UP NOT possible (with mousewheel)
Call Logging
Import Wizard Puzzle....
Corrupted(?) Menus in Access 2000
wrong order of images in printing reports
Object invaliad or no longer set error after onverting from Access 97 to 2000
Exporting to excel csv and how to set the cell to wrap text
images in reports doesn't refresh
Help needed: Wrong strTbl in fRefreshLinks
Complicated problem
Reading forms and reports information in .adp
prohibit double booking in room hire database
text to column
How can I get all table names from MS Access
Printing documents from an Access form?
Brick Codes
Calling vb from other application
#include
very tricky sql statement
Delete query problem
Bound form, SQL server, opening in wrong mode
thin drivers for ms-access ?
Why to be careful declaring variable As New ...
changing field names
How to query for multiple criteria?
Attach a recordset to a subForm?
Slowwww printing on inkjet using DoCmd.Printout
looking for online zipcode program and database
Access 2000 VBA help file
report and print a5 landscape
Running Button Method from Another Form
Need To Create A Master Record
If...Then...Else
Disc catalog to Access table
Error from Office 2000 to Office XP
Access 2k ActiveX treeview control
How to replace a .mde file when many users are connected to the file
Security--permissions not working properly
Dlookup function gives "You canceled the previous operation" errmsg
Scaning Documents Thru Access
Script for Access FTP
Cannot link table from SQL Server 2000
Updating multiple tables with one form
Using a Recordset to Send Emails in Outlook
Calculating fields in query
Cannot link tables from SQL Server 2000
Code to convert a Number to a spelled out number
Office Delovoper
Building a report
Searching in VB
List plus "Unknown" in Combo Box
Access fails when clicking on a subform
Highest Record?
Filters and sorts in datasheet view
Open Access Maximized
Fremdschlüsselbeziehungen anzeigen lassen?
Parameterized Query
Building a report
Easy one
Acc2K FE, SQL Svr 2K BE, Slow form display?
OT - NewsGroup Personality - Gilbert And Sullivan
nz function with where clause
Save Contents of Unbound Field
Getting into secured old databases
sorting difference query-report
progressive number
Nested IIF function
default keypress
Question on multiple forms and referencing data
Error: User-Defined Type Not Defined
Err.msg: You canceld the previous operation ????
Reading excel file and writing to access table
Sample database
Access 97 to XP Access Conversion Error
Can we use Office Document scaning utility into Access as ocx ?
Access <- > SQL Server
Locking records
How to make/package a mde/mdb file so it can be run on a PC without MS-ACCESS installed...TIA
Setting the recordsource of a report
Help needed to store quiz solutions from db to VB
Adding Data to a N:N relationship
Reservation system in Access?
Can we display a report without print preview? General queston
after update handling
adp connection
Rdb to MDB
Error Accessing File - Network Connection May Have Been Lost
sorting mixed data types in field
Another update problem?
Continuous forms, highlighting specific record
ODBC and Access Database Online
Requery every subform?
Screen resolution problem
ODBC
how to declare only once
help with query (Month as text ) up to given month
Print multiple copies
32x32 form icon while taskswitching
Access 97 to XP error Japanese Characters
Zip Function
Sharing Access 2000 Files Between Computers
Saving a record in a suborm with code
Forms and Subforms - Many Calculations
Access 2000 - the right choice?
Access 2003 linked table manager not displaying tables
/runtime + compact on close + references = crash?
Senior Microsoft .NET Programmer/Analyst needed
at wit's end about corrupted records in Access 2k table!
Selecting Data to get a value
Sending date to query problem
Inserting a record & adjusting form?
3 page "Detail Section" - is it possible?
Execute/Insert into method works sometimes??
Referring to subform
Displaying information in Access - general question
OLE IMages in Access DB
problema di sviluppo
How do I declare a variable that allows data to be added to it without losing its existing value?
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