Microsoft Access / VBA Answers - Page 93

Help writing a module
How to edit calculated field in FORM
Calendar Control not on Top...
Windows XP SP2 atomatic delivery April 12
Advantages of Front Ends on Local Machines?
Allow Data Entry if Field is Null, Disable if Field is not Null
java.sql.SQLException: General error
Access- a problem with a copy data
combobox, textbox-synchronization ?
'Number of query values and destination fields are not same' error
SQL
report parameter for unbound textbox
Copying relationships window from one db to the next
Access 2003 table links fail after restarting access
Reporting " count " question
reports/ can we alternate no shading and then shading for multiple records such as a phone directory to help distinguish
When should you upgrade access 97/vba applications?
How to Minimize Access app?
Is it possible to get support from Microsoft for this problem?
Text to Long integer - digits after decimal lost
Usernames, Passwords, and User Levels
audit trail
.requery with sub form
Report's text box control split by page break
Access database as 'exe' file
Find Record Help
Reports from query
How to retrieve MDB file stored query information?
stored procedure recordsource - new record causes problems
Help getting data out of Outlook 2000
Tip on error handling and DAO reference cleanup
SendObject using a particular Email Client
Counting the max number of rows, sorted by group
Database creation query
Copying Data
subreport wont even display?
comparing & then joining 2 tables in ms-access
OpenRecordset
expand only one record with in a datasheet
Technology News
ODBC call failed
Access won't open file
New control cannot be enabled when added to tab
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another
change data link sources in batch
Concurrent connections versus concurrent users
Access 2000 unstable?
Exporting to Word.
Update table from a report
Find Record using three Criteria
Need Solutions.mdb
first day of the week
Trying to understand recordsets and for/next loops.
Access 97 mdb file to a web server. Is it possible to link tables?
Macro? Automatic Date entry upon de-selecting a check box [false]
Designing variable Form Help Needed
Table properties
Automatic Population of fields
Map reference
Editing field in filtered SQL query - RunTime Error 3464
Too Few Parameters? I don't get it ... looks ok to me.
customer management software 4 access?
Looking for same data in two tables
Transfer info to Access
Access 2000 bug?
Where is the cursor !
Exporting (Sharing) Data to Excel
Help with subform, please
Windows Font Size
Selecting "ALL" items from a Combo Box
VBA: Class Modules Questions
Checking for missing cheques
PostgreSQL and MS Access
call a report from another mdb
Populating a text box with text string of table contants
ASP - Increase number field
Base report on form listbox?
Change the recordset of an Access report on Open
Carry data over to new record
How to build database to support user-specified attributes?
expression, text fields, and drop down menus
Date difference calculation in a report
Securing a new database with an existing workgroup file
Database slow down due to query?
Using photo name field to link photo to form
OUTLOOK 2000 - CALENDAR
date field - how to auto enter todays date and not refresh it afterwards
Forms
Table append
Searching multiple tables in Access using Visual Basic
Easy way to find tables/querys in relationships view?
Collumn select?
Simpler way to count text box with Data / Loop on controls?
User customized reports
HELP PLEASE!! one mdb - same machine - different domains
Using OrderBy to dynamically change sort order in reports
Multiple Tables in Update Query..... ADP
Batch Print TIF Images - Build Dynamic Shell Statements
Access Forgets Global Variable!!
VB6 and Access. Cross tabs on the fly.
How to use one line in an address
Add Duplicate Record with blank combo box
Opening reports in ADP
adding to toolbar
Open report problem
Combobox Event Procedure Help
Combo boxes using the result of one in the next
Simple interface for making automatic phone calls from access database
AccessAppStarter
SourceObject relinking not working
can you read a file modification date
How to put logo in form?
Signing Own Database?
Table contains date/time field, I want to query it displaying time-diff between successive records entered. How?
Table relations
Using Access 2003 with SQL Server...?
Is there any way to run a loop within a query on access 2000?
MDW corruption
Move focus to a floating Access toolbar
Trying to combine a field value and a string
Exclusive Open Mode Not Working
Microsoft Access Question????????
PETITION: Help save VBA
Japanese characters corrupt database
using the results from a count query
Wie wil mij helpen met een database maken?
Subscript out of range error while not using array.
HTML forms and Access 2003
Passing a parameter value with spaces to a SQL server procedure.
Batch Print Multi-Page Tiff files - HELP!
Finding data using multiple fields in grouped reports
Importing to Access 97
Access and SQL Server - Query based on Query issue
how to convert codes to names for printing of Access reports?
Formatting a text box based on the contents of another
Query question
Using for...each...next to delete certain fields
Create MDE CRASH
Need to have a save dialog for any data changes
Syntax Error when trying to modify crosstab query
isLoaded not happening in split database
voorbeelden torturials
Printing alternate text on report with no data
Inverse query - greatly puzzling!
Opening a form with a default value
simulate network server locally
Help with validation rule
Report as a Renewal letter to individual email address'
Perform calculations based on week nunber
Pivot Chart
VBA Question
Grant Read
export to DBF without decimals?
VBScript used on html to capture values for a Access database
display parameters on report?
Combo Box Question
case sensetivity
Between dates query
Issues with updated Memp by SQL code. Keepo getting Error msg "Could not update; Currently Locked by session on this machine"
Filtering records in a listbox
Create MS/ACCESS database app for non-ms/access users
Between dates query
Clear data on subform
Issues with updated Memp by SQL code. Keepo getting Error msg "Could not update; Currently Locked by session on this machine"
Filtering records in a listbox
ID problem
Create MS/ACCESS database app for non-ms/access users
Clear data on subform
ID problem
sub classes in access
Importing excel sheets
Custom ShortCutMenus in DataSheet View
SQL select statement with multiple variables
Concatenation
Print Current Record
Single query of multiple external databases?
Directing Reports from Access to a spreadsheet
Access vs ??????
Variable in a sub report
Format Function Problems
Right side of Access chart doesn't print
Doing a Find on a Range of Dates in a Date field?
How to do this.....?
Import forms from Visual Basic into Access
Access Question
2nd post Database design different attributes
Windows Regisry Editor Version 5.0
Acess 2003 crashing
Reasons to convert from Access 2000 to XP or 2003?
Data entry on form based on a many-to-one-to-many relationship query
Build Date
Determine the size of the Windows screen MINUS the task bar?
MS Access 97 Graphs Print as Black Box
Multi-User Access MDE File Growing and Growing.......
Access/Windows NT
event procedure
Specifying values in fields in a table!
Autonumber repeats exisitng values
finding info in a master table
Running Sum with a 0 value in query
applying filter from form on report
Splitting one field into several
Modify VBA Reference Based on Office Version
Help with calculated fields
Autofill based on another field
VBA Editor not starting correctly
Maximize and Popup Forms
Tax Year Function
Please help 'recordset not updateable' error
VBA Syntax Question
Error problem
Help Please
create new textbox at runtime
Create new textbook at runtime
Java: Using an access database
UPDATE
Overlapping months
Determine version of MS Outlook from Access
Evaluating a Network
Repair/Compact Changes Security settings?
2 access 97 databases how to
SQL Performance Tuning
Why subform is read-only?
How to encrypt a Table
Access Tables
How do I creat a Subform to enter parts into a service record form?
Access formula in a query to do retirement projections
Access formula in a query to do retirement projections
What should I pass into this Function?
Excel Spreadsheet in Access
Combo/Field Problem
ACT to Access
Input Form Question
How to Show AutoNumber Value in Form
New Record Button does not work?
VB Using A2000 MDB
Compare 2 tables
Upsizing currency fields
How to open a secured access DB
Access 2000 - Default Font for form/report design
Moving from Approach to Microsoft Access?
access 2k populate outlook 2k form
How to execute a query after changing sql command
Automation Error in Access XP
Subform Help!!
Using access as a historical tracker
Access 97 report function to zoom to a specific size?
Client connection to SQL Server on shared hosting
Continuous form issue
Control Reference Question
Calculating Access 97 size and handling of text fields
Refreshing linked tables - repeat for EVERY table
Subform is creating extra data
Acrobat Reader Path function modification
Mail Merge - Save Image
Updateable Query To List Products Ordered
Function That Cycles Alphabet
Help!
fingerprint identification
Sum if Yes
Access 2000 VB6 Adding Records Locking Error
Combobox selection to query
How to use a custom error message instead of Error#
Getting access to a 2.0 database
Filling a continuous form
Passing the Me Keyword to a Public Function
test
format or template function?
Name of Control in expression
Identifying all records in a list box?
Default Old Value into new form
TransferText and German characters ä, ö, ü
Dsum Calculations
Wrong sorting by query
'cant open any more databases' error?
Backup alternatives for a 3 user database
Security Warnings on opening DB
Use multiple ListBoxes to filter records?
closing a previewed report without closing the database
IN [ODBC with multiple tables
GridLock
DLookup in VBA
Collections, Mail Merge and Word FormFields
little filter problem in access 97
How to change the active .MDW by code ?
Command Wizard Problem
Redemption
Page Numbering in Access Report
Recursive Relationship in 97
First letter needs to be a capital
server.scripttimeout for ASP
SQL (CONDITIONALS)
Filtering An Open Recordset?
binary data and the OLE Object field
Closing acces
Table field that contains a list.
SendKeys problem
DLookup Criteria In A Subform
Set control source =[cbxName].column(2)
Read only prob
Time Input Error Trap
OLE Bound Control
sp_setapprole with SQL Server
Filtering a subform
a2k getting multi-user right from the off
SQL / JOIN problem in Access Report !
Hosting change.
how to avoid shift+enter shortcut functionality on .ade projects
database-design-inventory-different-attributes
Message if no result
Database Update
Permission to modify Querydef
Subscription site with Access db
Lock From Problem
Lock Form Problem
Creating random letter combinations.
Acces 2003 query siize probelm HELP !
Determining Whether a Check Box is Checked
Using Control Property On Action
How many days? - Confusion
Code to Automate Indexing -- If there is such a thing!
FollowHyperlink
Can you call an Access Query from ADO?
Questions on pass-thru queries
Do I need the "Public" in the following... Public Function IsEMailAddress(ByVal sEmail As String, Optional ByRef sReason As String) As Boolean
Hyperlink
Access2002, subforms
Help
Bound Control OLE
OLE Bound Control
filtered rowsource for combo
Word Automation MailMerge and Header
Translate from C to VBA?
Combo Box Options Problem
MS Jet database engine stopped the process ... Error
Formatting multiple text boxes?
Mailing labels
Append String to Table
Exporting data
MS Access - Help Needed
Last added channels at Etamp.net [2005-03-04]
Fancy calendars for Access?
How do you duplicate records with a primary key?
Sending a pdf file to default printer from vba
Compare and count dates in access
Compound Key Question
Data Correlation
Access 97 - report
Printing problem
Visual Basic Pro Ver4 and Access 97 Database
don't want info to show
Class in library, no intellisense ?
Inserting Field Values Using VBA
Access Slowwww
User form to link table
MS Access remote access from ADO
Can't get PDF to open from hyperlink field in database form
If DoCmd Beep is not working for me (I don't hear a beep) - where would I begin to debug that problem?
Query with Grouped Running Totals
Help with DaysDiff/HourDiff (not really datediff())
Query with Grouped Running Totals
Import Class
How to play a midi without the WAIT parm???
How to remove the single quotes (apostrophes) around a hyperlink address.
No Claims Bonus
A2003 Sendobject for Netscape and Other Mail Clients
Active Form as Query Criteria
Input Form Question
How to constrain a screen-dump to include only the current form...
Programatically Save URL
Using Combobx In Continuous Form
Cumulative (running totals)
Converting Numerical Value to Lookup value
database problem
problem with hyperlink and mapping / Probleme bei Hyperlink mit dem Pfad (aboluter und relativer)
Month problem
How to preselect values for List Box
How to get the value for the screen resolution?
How do I get Access to recognise when a result is exactly divisible by a number.
Error "can't create SYSTEM.MDW" ???
Quick Access success story & Quick question
Scrambling text to create a unique identifier
Requery, Return to record
How to track the last URL and write it into a table automatically?
table only not form and data access page, drop down list to drop down list
Populating combo in Access 2000
is it possible to use multiple text or list boxes to filter through a single list?
How to read values from a combo box using VBA
Method or data member not found
Importing Groups from one database to another?
Excel Format Help
Limiting Selections In DropDown List
Error linking Excel table through VBA
Change printer destination
error 3137, Missing semicolon (;) at end of SQL statement
Email Multiple Reports on one Email
Add Record with checkbox
Multiple Selections in a report
Reports that show only some lines from a query
Need help with LABEL Creation ASAP!! (Thanks in advance)
Strange Tip: ExistTableDef()
VBA array basics - dynamic or static?
CREATE PROC error in MS-Access/Delphi
Email from Access - handle cancel error
Change Report Layout Programitically
An automated update program
Yo Ho Ho
query
Update Query
Locking a Field after a box is ticked
Book Recommendations For Building Access Reports
Linking data to query and table
ACT!200 0 data transfer
Problem with mouse wheel
ftp-ado
Searching data
Pass parameters from VB 6 form to the MS Access Report
Keeping a form maximised?
Email Scheme and Massive ID Theft
URL and table fields
DB Bloat: Suspect Something To Do With I/O?
Problem with Access form
VB.Net
locking record
Retrieve Stored proc name
Is there an "In" expression?
Trigger an action by highlighting a row in a subform
First & Last Pages of Group - JAmes H. Brooks' Code
Assessment database need help with linked tables
Number of fields in a query
print out a listing of the queries - Name, Description. Mod Dt
Successive Queries with Value Lists
Protecting my work..
Exporting charts
security on tables
Reference problem
problems canceling a check box update
Using DMAX field in Access Project (XP) connected to SQL 2000
automating hyperlinks
Access Report and Cutepdf
Accessing Oracle Tables from MS Access
Subreports
inetTransferLib produces error depending on connection
OLE Bound Control
Form minimizes
Set Counter to Zero
Transactions concept in ACCESS
The instruction at ... referenced memory at ... The memory cannot be "read"
Finding system folders
Installable ISAM error when linking excel table into Access
Access Web Forms Wizard
Foxpro Query Locks Up
Disappearing Database?
access97, snapshot creation fails with visible image on report
lookup query?
Skip field on report if null
dramatic decrease in speed on forms
Logic help
Call Excel Add-In Function?
delete table- help me out plz
DSN-Less To Crystal Reports
Need to run my query code from a form
Select Option
Access Analysis Tools?
Set Forms Recordsource
"Out of memory" error
Access Import from Excel
access ----> outlook
Timer problems playing with API SetWindowLong and SetLayeredWindowAttributes
Form Calculation
Fuction Key Routine
Text file import/export
"Subscript Out of Range" When Setting Array Elements
subform problem
Book recommendations, please
DB Backend programming?
Fingerprint identification.
Listenfeld über benutzerdefinierte Fkt füllen
copy prevention and time limiting
email through outlook prob
Cannot update. Database or object is read-only.
tableupdate() in MS Access?
Can an update query set values selected from another table?
Find File Or Folder" type dialogue
Tree View
Really simple Command Button question
Look-up values
Jet 3.5 vs 4.0
Outlook Automation Problem
MS Access Project
Query to consolidate 2 tables?
how to fill in blanks after an xcel import
textbox and query
how to close a form after a period of inactivity?
Access Certification?
Update query
SQL Update Permission Problem
All Accounts with Their Latest Request
Editing or Changing record content
record selector box
Automation - xlapp.Quit does not kill Excel
Multi-select List box with textPK
Data Security - Basic Question
How can I find out if a report has been printed after pre-viewing
Printer Devices
combo box advice
many to many relationship
Desperately Seeking Help Filtering a Dynamic Crosstab Query Report
Problem With Drop Down Lists On Continuous Subform
Enumerating ADO Recordset Properties
Foreign key problem
Help with update query please!
Split field in two using comma (for name)
Conditional Formatting
Query question - Access 2003
ComboBoxes on Subform don't display value until one is clicked.
Access to VB.NET Conversion
quiz database
CDOex and Access
keypress event
Access Report - Print Index Cards
Set DefaultValue of Textbox with VBA - why doesn't it stick?
How to find duplicates in a field?
Database Administrators
Using DSN-Less connection to Link Tables
Most Recent Record
openarg problem when null
search between two dates
Error updating subforms
Public Review Comment Tracking Application
Postcode stripping
Access 2000: Duplicate Values in Index Problem
Has anyone ever used the 4Tops Excel Import Assistant Add-In from Code?
Add a worksheet using VBA
Combinging three fields/columns for "factorial" result?
Common Dialog in Access 2000
Hiding Combo Box
Track use of codelibrary?
Access 2000 vs. Access 2003
Stop users linking tables
Change number in linked tables
INNER JOIN question
textbox and queries
Continous Form- How to retain sort order and cursor position after edit
Showing record numbers in query
stLinkCriteria
Porting a split database.....
Set Unicode Compression in code
FoxPro, Access, and ODBC linking question
Backend Path