Microsoft Access / VBA Answers - Page 112

=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
Linking Files to a Database
How do you handle multiple elements in a collection.
How do you handle this combo box problem? Do you have a method?
Use a field from Main form in subform
Access to excel
Refreshing a form
Mail Merge
How to save changes to form property in VBA?
trying to run DoMenuItem - Database - Window - Hide in autoexec macro w/o success...
Query Expression Show Only <0
Read only linked tables
Using switch instead of case to specify order
How to show Record counts on Forms!?
Access and Oracle part II
Adjust main report timing to solve null subreport
how more than 255 characters per field?
Lookup field in table
tools for printer programming in Access 2000!
97->2K conversion causes large size increase
can format memo fields (line breaks, etc.) in Access reports?
webpage development: Datasource update: Any help would be appreciated
File copy problem
protect database source
Is it just me ?
Auto Reminder
Read Only Tables
SQL statements (INSERT...INTO)
Access and Oracle
Lookup in a different database?
Collegamento tabelle oracle
default entries in ms-access
Compiling to A2000 in A2003... problems
#Error Sum Reply
Setup for ms-access program
Digital signatures for macros
DblClickNotInList Finally Fixed
text fields to memo field
When are SQL Server and Windows Server required?
What's wrong with this Tony Toews guy?
DblClickNotInList
Table values mysteriously changed in 2 columns only
DefQuery: How to use key word "AS" to create string for sql property
How to store/use info from barcode scan?
how do i change a field to greater then 255 characters
DblClickNotInList
General Back End Stability question
Alguien tiene algun tutorial, en español, que sirva para accedera una bd de access con pHP???
Using Combo Box To Lookup Record
F4 & F11
integer in code
Refer to multiple columns in Multi Select
Great Difficulties Accessing my Database from an FTP site
adding multiple categories to a table with products...
ODBC--call failed.
No answer for your problem ?
Linking to Contact File in Exchange 2000 Public Store
Switchboard from hell - Access 2000
Tack Changes II
MS Access 2002 - Forms - Fields - Updatable by Admin ONLY????
Access 2002: #Error Sum
need a little help with creating database
Office 97 Developer Edition Tools
Automatic move to next Access tab page
Database size optimization?
Using Macromedia Flash as a front end for Access
query pass through no updatable
new record & scrolling
Combobox bound to not required field tries looking up null value
possibly a strange request for help
Export report with pictures?
How to get properties of option button?
Migrate DB to web
Help (F1) não funciona
creation and update times
Filemaker vs Access for Large Records
ODBC connection strings won't update
Validate Data
Delete Query Question
Req: Help with Imported data containing multiple entries in a single data field.
Automatic move to next Access tab page
Basic Outlook Automation Question
Req: Help with Imported data - multiple entries in a single data field.
Use Subform calculated Field in Main Form
SQL in Access 97
Using a SQL Statement To Generate A Report
How do I make a "conditional Format" on a record in a subform
editing custom menus and short-cut menus
Function not woking first time
Excel Automation
Report from multiple queries
Reading Contacts from Outlook
Track changes
Multiple table
Multiform questionnaire overwrites first record
comp.databases.ms-access
Select all from subform
Which event(s) can I use to catch a change of a field on subform?
databases
Excel Automation
SQL Delete query won't work from query window but does from code...
Searchable product images + prices database?
SQL Delete doesn't work in query window but does in code...
Loop Through Recordset and Kill
access 2003 adding items to a listbox without focus
msa
exit program and log off as xp user
Problem with comma delimted file
mdb+asp not working on server
openform action was cancelled - why?!?
Import a dbf (dbaseIV) file
Adding a password protected field for a scanned signature
Renaming a database after compact
NotInList DblClick ERROR
Error 2450 When Form Is Definitely Open
Unable to install MSDE
Access 2000 Forms with Linked Tables to Microsoft SQL Server
Access 2003 Manuals and Help Files
How to unlink a protected table?
How to refresh an image control
Creating a variable to change the name of an export file
Table(s) layout