Microsoft Access / VBA Answers - Page 94

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
strange problem
code to append from excel
Recordset info
multiple entries in a form/subform and how to move through navigator
Linking objects
Silly labels question
using an on-the-fly query in a read-only database
Problems with Command Button Wizard
Overcoming the locked unclosable form in A2K2
Graph problems - axis scaling & PDF output
Crystal Report Report Viewer URL and Access
Office Developer Edition and TreeView
Creating an initial drop down list that will return just that person's information / Calculating Items
Security when spliiting access database between fron end nad backend
Import Text Via VBA
Parameterised Queries in Access with ADO
Idea for a fake treeview
Custom Filter Form
error 7965 not a valid recordset property
Setting Value in an Open Form
Populate multiple query columns with multiple listbox selections
Update Query Issues, Revisited!
Form/SubForm access problem
How to create a new entry automatically in a related table ?
crazy inner join
Using subform/popup form to populate a field on a form.
2000 runtime
Access 2000 runtime
Access 2000 runtime
My Apps Automated?
Use Checkboxes on Continous Forms to Append Records
Can Not Open Any More Databases
How to update tables
Mail Merge from Access Limits & Workarounds
Duplicate Records - Same Table - Multiple Criteria Fields - Please Help!
Query for minutes
Union Query?
insert/edit/delete two tables linked at the same time
multi-user access 2000 database
Refreshing a Subform
Memory problem
Security and Workgrpup
Removing Synchronization / Replication fields
how to wait for completion of print-to-pdf, filecopy, kill?
Latest Record in a Set
Vanishing Relationships
Check Box Problem
SQL Query Question
Refershing a subreport
Generate a "data dictionary" on an Access table
Problem with text box and automatic space removal
copy a value
Total Hour Duration Query
Calc time date difference in a report
Show Column Number On Report?
Diaplying HTML
Access 2000 runtime
How to run a query using VBA and use the result in a condition statement
Error - Field cannot be updated
COVAR function
Multiple instances of frontend - problems?
Form/Subform Searching
How to clear the debug window?
Why Does This Code Work SOOOO Slow?
How to run a query on a truncated date
Not In List
Auto-Updating BE database
Setting up report to Print 'Continuously' -- Tractor Feed
Question about audit trail code
How do I get an Access Table Lock through VBA
Best way to store calc result that can be "NA"?
Save Prompt issue between sub-forms
cant access database tables
Hide pop-up whilst query results are displayed
Macros or DDE
What would be the function to check if an item is in a table
Access -> ODBC -> SQL Server connection hangs
Subform Question
Data Entry Question
Source Control Recommendation Wanted
Total on report blows sorting
Run-time error 3155 ODBC insert on linked table '???' failed
Time in access
Command button won't initialise as invisible!
ApplyFilter in mde
Update Query Issues
Weekly/Monthly Transaction Query
drop down list is blank in subform
How do I connect Access database to Excel?
drop down list is blank in subform
Help
How do I connect Access database to Excel?
daily packing number - again
Why does Access update instantly
Help
daily packing number - again
Why does Access update instantly
DROP TABLE syntax - use with Select?
DROP TABLE syntax - use with Select?
HTML Documents
Unlinking Tables
OT - Why Restored Down
HTML Documents
Unlinking Tables
Using Access 2003 package wizard to package a database for a Access 2000 client
"MSAccess.exe has encountered an error and needs to close"
DateSerial Query
Nearest value with Dmin
OT - Why Restored Down
Eliminate label flicker in On_Timer event?
Using Access 2003 package wizard to package a database for a Access 2000 client
Trouble with AND
"MSAccess.exe has encountered an error and needs to close"
DateSerial Query
Nearest value with Dmin
Export table to TXT file using 2 methods
Eliminate label flicker in On_Timer event?
Trouble with AND
Export table to TXT file using 2 methods
Nesting Transactions with SQLServer 2000 and Access97
Empty Rows on Report
Parse one field's data into multiple fields
experienced in ORACLE but beginner in ACCESS - URGENT
display of long text
Custom Filter Form using Combos
Add record and updating
Form: Auto fill by previous row?
Why doesn't this work?
Read part of the data in text field
running sum (multiple years)
NoData cancel affects 2nd report
Insert Into SQL Statment
dirty vs change vs beforeupdate
shell command not working
OLE Object on a Form
Environ() doesn't work in ACCESS PAGES (view mode)
Access database containing OLE files that are searchable
Empty Listbox crashing Access 2002 SP1
Access database with OLE objects that are searchable
import oracle tables to ms access
Date Comparison in Access 2002 using VBA
Visual Studio Tools
Datasheet View
Input mask property and Mac, Mc and hyphenated names
How to control form events on subforms?
using a text box to filter through a list
Creating a unique id based on a file number and a count of matching records
Query Help Needed
Not Equal
Error when user submits form with ; in value
Link To Outlook Express
MS Access DB auto update by VB (data download from web)
Run-time is "read only" on a PC
Mail merges in Word from Access
Date picker from MS-Access 2000 to MS-Access 2003
Writing Code for a better FIND command
Auto Number Increase
Help!
Access reporting problem
Grid Control Problem when migrating from Access 2000 to 2003
HT execute Access query and HT execute Access function from C#
Email from Access
Where should I buy Microsoft Office Developer Edition XP
How to get unique identifier for Tabledef?
Creditwrench
Bug: locked by another user?
write to text file
Access Encryption Detection
Need help with user permissions
MS Access 2000 Report Problem
MS Access DLLs, OCXs, References
Graph incorrect (Ac 97) when more versions MSOffice?
Adding to a recordset
Running Sum in Subform
Counter for Bit / Flag
AND query in survey table
How can I construct a query to track changes in account balances over time?
Difficult SQL Query - Help required
Tip - wedging middle-tier logic into continuous forms
How to avoid update?
e-mail
Access runtime-action queries must be confirmed?
Using a Macro to Set the Value of a Combo Box
Use of Goto Exit_Proc
alternative to WScript.Shell
Am I Screwed with Autonumber?????
Runtime Error 3167 Record Deleted
Capture windows event from Access
Replication Design Question/Inquiry
Run Command Button on open
Filter subform w/in subform
Print report based on current record
1/4 to 4/4
MS SQL linked tables vs. Pass Through Queries
Extracting a value from a matrix
Problem saving memo field using timer
Return Name of All Forms in Database
Calculate wih a Combo Box
Dividing the number of records from query into a set number
Extracting people from a list
Scrambled Excel Automation
Querying Help - displaying one result for records with same value
Cool File Encryption Software Released.
Title with "The" in the beginning
Create a Link in Access to a Text File
Blank Fields
Tabbed Subform
Assoicating Records
Rst.Update does not update
Need to show the difference between rows in a report
Terminal server problem
Daily Packing Number
Like in Open Form Command
Simple query, difficulty with date
How Many Times Do Queries Run?
SQL or code does not run in .mde
Runtime Error w/Exponentiation?
help creating a query to: "count all rows that meet a condition"
Report problem - Long
I have a user/pc specific problem in access.
Form Recordset VS RecordsetClone
Disabled Shift bypass key but want certain users to have table /query access
How to use Append Query on 00-00-000 formatted field
Using NT rights
Record Number
Sending a report by email and only showing a particular record on that report
Future of MS ACCESS ...
HELP! I cant understand my DLookup problem!
Web Front End (for Access/Jet/MS-SQL) Creation
a2k - simple way of detecting data changes in app
Can action query be restricted to specific table?
Intermediate Table linking two tables
ADO connect on form
Check if a form is open and if it is close it?
Section keep-together within subreport?
convert calculated field to ms sql server 2000
Getting currency to appear in mail merge from fields made in query
MS Access Question for Access Gurus
running number in a query result
Running database on differing OS machines
distributing access database files
? Affecter une priorité à un contrôle d'access
fastest way to call a function
?? TRANSFERDATABASE COMMAND
dsum issue
Print report/subreports based on each date in range
What to delete new record started on Continuous Form
Reformatting data into logical records
20 million records: Too many for an MS Access app?
DateDiff Error
Rolling Rates of Return: Data Structure?
setstartupproperties doesn't work for xp mdb
AccessCode must wait until excel closes. HOW?
Need help formatting page footer please
Applyfilter or form bound to query??
Subform H*LL
listing data in columns dependent on letter of alphabet
listing data in columns dependent on letter of alphabet
MS Excel IF Statement w/pictures??
calculating time II
Calculated field in subform
Show database window from VBA
Array element appears to lose value (Access 2002, XP SP2)
MS Access Report
Which Courses students have not taken query
VBA control of field value match with excel value in cell
On Format headache
genealogy database
Microsoft VBScript runtime error '800a01a8'
VBCode Help for Beginner
Can I display all the records of a DAO.Recordset in continuous forms textboxes?
Putting Columns on a report
Bank reconciliation
How do I do a print preview using Access Automation in VB? Print works fine.
Deploying Access 2003 runtime
Expression Builder
Important Access Client/Server tip
Database size - problem
Will Access 2002 Save As Access 97 ??
Option Group Button Help
Help with Form position after report preview
multilevel hierarchy query
Access Data Projects Uniqueidentifier problem
Best way to make Access 2.0 code wait 10 seconds before processing the next line???
Moving from one form to another and then back
Report Total Line: Summing just two rows?
Emailing from a form
vba sql query passing to report
Open file (from url)
VBA code help Export Excel data to Access table
Error 3048 Cant Open any more databases
Error 3048: Can't Open any more databases
Another Dlookup problem
Database distant access
Combo box query report
Making Access work faster
database tables and relationships
Version issues
Add data from a form into a table!
How to save a record
Q on weird subform skip behaviour
How to ensure that on a continous form of 12 row only 1 tick box is checked??
How to ensure that on a continous form of 12 row only 1 tick box is checked??
Compact the database problem
Changing Window States of Reports/Forms
Difficult Graph Needed
Integrating Crystal Reports into Access97 form
Exam type questions
Help With Query
Record limitation when using Data Access Pages
Finding the last record -10
Record limitation when using Data Access Pages
RowSource Issue
Access: How to disable importing tables from my database to other
Missing Pair Fields WHAT?
Open a corrupt Access 97 db
How to convert Date to Week #
Help with Relationships - Query and Table relationship
How to use a popup form to filter data on a main form?
Calling C#.net .dll from VBA
displaying a command button in the detail part of a form.
Special Labels
Help with Database Object
Database Report field
Database Report field
Ascending number in query
a2k - how to code a simple version check over the net
Parameter in query to dropdown list
Inserting a new Record in sub-table and ensuring valid relationship values
Help with calculated control on form
capturing the printing properties of a report of form when sent to a printer
Downloading of data from access
Command Buttons
Reports
Microsoft Access and Cash Drawer
TreeView documentation
Sub Form - Linked Child Field - Linked Master Field
Multiple users changing the same record
Design question
How to round a number by 50s or 100s.
Why do I always get -1 when I do Recordset.RecordCount
Key Stroke
Access Developers edition?
Asp and access database--Long
I Have a Query
Change Text
How to avoide the "Alert Messages" when using Queries
ms access
Excel error at web server
Excel process doesn't shut down
Assign value to Excel.Range
DSum Help
Public (Global) variables
Late Binding??
query design help for book index
Base DS form on QueryDef?
Output access to Word merge
Where can I find the syntex of "formatnumber"
Tab Caption Goes Away
Exporting a Report As a Word Document
Simple function sometimes works ... sometimes doesn't ?
Code "Auto-Letters" ?
What event occurs just before a record is written to table?
Exporting text files without .txt extension
date issue in .adp file
OFF TOPIC Frustrated Rant
Adding new users requires exclusive access to mdw!!
Complicated Question
Previous Business Day
the Find Command Button
Apply Filter in subform