Microsoft Access / VBA Answers - Page 94

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
Listbox Updating
Code to fix corrupt table
Tables Duplicating Themselves with an underline and then a number
Create IIf Statement for Query
SendObject in Access2K works sporadically
Change Textbox Width
count and group by with OR
Returning Focus to Main Form
Automated Screen Print - Possible?
Union Query Truncates Memo Fields
Amount of time spent on a record
How to make the Linked Tables in Access to Share only ONE connection?
most recent, min/max query
Remove multiple Chr(13) & Chr(10)
Access 2002 runtime error for Windows XP
I cannot figure out this query - I thought it would be simple but...
How to use different data sources for different sections of a report?
Using Excel data in query
Update Query
OLE Applications for JPG Files
Using code to copy forms/macros etc
Saving a set of reports in Word automatically
Recommended Stretagy for Bi-Direction SQL DB Synchronization
Using jpeg files as OLE objects Q2
[ODBC] form linked to odbc tables with "high" number of record
Problems Converting 97 Query into 2003 format
Using JPG Files as OLE Objects
Textbox, web browser control, and Unicode (got cutoff)
splitted database crashes when adding records to linked table
updating access 2000 mdb from asp.net Microsoft.Jet.OLEDB.4.0 ???
Excel protect sheet macro problem
Access and a VPN
Access & a VPN
Access & a VPN
read only access database
Reports In Visual Basic and Access
Access DB Security
Securing a single table - what are the options?
My text field Criteria : "N/A" - How to resolve "/"?
Best way to let users run SQL?
Access unexectedly shutting down
Web browser control, Unicode
Call Function
Subform Contro; Border
Exporting Report To MS Word
Buttons and Listboxes
Access Books
How to convert Date to String
How to convert Date to String
How to convert Date to String
Search and Update - Difficult update query
Hourglass status
caselle di testo e formato ora
me.cb.Type?
Copy file from within Access 2003 project
Two Lookup Combo Boxes on Same Form
Microsoft Office Library Reference
Multiple Field Search
can't send Email from Access
Question didnt seem to bump
Linking table to multiple tables
reports
API Gurus - Alpha transparent popup a la Outlook 2002
Commandbars Controls Collection
Print Form to Report
query based on lookup value
Report performance question
Multi-level GROUP BY Error 3612
Problems loading a listbox rowsource from code
Text box question
Differences - Syntax & Form operations
Combos with Tens of Thousands of Records
Back -end Front-end
Changing Table Names
Next "Available" record ?
Slow Access 2003 in Win XP with network connection
Pad lines on a report
Access/Jet Statistics
Questionnaire in MS Access
Text Box Issues
Updating Records on Form through Linked Tables
Go Back And Forth Between Functions
MS Access and SQL bigInt
Change in appearence of google group page
How to do the Declare for a Delphi DLL
how to change the owner of a table
Security Manager Add-in Error
Settle a disagreement with my boss re SELECT DISTINCT
Creating a Backup Database
Setting focus to textbox after clicking on multipage tab
Comb Boxes within a Sub-form
How to copy groups and users from old secury file .mdw into a new one?
Tuning of group reports
Database back end - SQL Server or Access
Autoexec question
Optimization technique
Using same table for Lookup
Won't sendObject from access 2000
Highest Value For Each Person In the Database
calculation visibility
Where clause in SQL statement problem
Can't open linked DB files
Type conversion problems with Access Import Wizard
Corruption Manifests In Access 2000 But Not In Access 2003
OLE Image Problem in A2002
Return to code section and loop before giving up on an error.
Return to code section and loop before giving up on an error.
Query of two tables
show day (date) quickie
Reconnect to DB back end - password
seperate page/document for each record?
Code problem with rowsource and SQL statement
SETTING DIFFERENT RECORDSOURCES FOR ONE REPORT
Please help me get started (Access on the Web)
Simple question (I hope!!) on .FindFirst
dynamic popup screen for multiple comments fields
Help for Xbase to Access -Allen Browne may be
Report including only days with value > 0