Microsoft Access / VBA Answers - Page 94

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
scurity + form
Need Loop Help - VBA novice
Combo Box Problem
Is it possible to join two queries together
Retrieve Information about Access Version
password enbaling form
Problema con un report
Filtering out unwanted characters from a mag stripe swipe.
jet 4.0 error message
Can't open my database - linked tables
Change me.sourceobject
A very specific problem involving duplicates
Notification
Query question
Type mismatch error, SQL and Recordset
Function used in SQL Select query
Processor Number
How to remove the CR character (â–¡)
Designing Access2003 unbound form in an asp.net-way?
forms: simple and complex question
Suggestions needed.
multi-page, multi-filter access report problem
Database normalization question
Database Replication A97 vs A2003
Access DB Security
Outlook Emails in Access
Date formatting so "01/22/2005" becomes "January, 2005"
Changing, "FindFirst" to using the, "Seek" Method?
print only some reports?!"
Application Search and Replace Tools
Referencing data in a field within another field
forms --> access
Need help with merging spreadsheet together
Import Specs: Still buried in Access 2003?
Combine (Merge) Data from Two Access Tables
Linking to a backend using code?
Adding index marks for Word
Having trouble setting up transactions
How do I set a form to automaticly start at new record and not overwrite first record?
Update sub-form on tab from field
Qty Problem
Searching Using Combo Boxes
Query help : Urgent please
send Outlook email from different name?
Controls over image
Q about creating new form
blat command line does not work in Shell method
From the previous question - Search the records by groups based on identical field value
Help with Acces Runtime 2002
Locked Record when connecting to SQL Database
if then else - help please
Changing and storing the value in a text box without adding row to table
open & close time of database?
Multiple Concurrent 'References' to MS Excel?
Two Tables
Combo Box question
Appending records in another database
recordsets?
Asp.net caching vs Access Caching.
ADO and DAO together in same application?
Create Autonumber & query problem
Indexing a phone book
Custom page size in report
Extended one to many relationship
Book recommendation for access queries?
SQL Server 2005 Express Edition Overview
OLE problem with A2002
List Box Options Not Appearing
Blanl Lines
Displaying both the master and its details as a grid
A'2003; SourceObject = Query.MyQuery (BUG!) (?)
WEB Integration of Access Database/System
Invoking Filter by Form from Code
IM/EXport specifications automatically creating
Crashing Subform
Crashing Form (& Access)
problem with crosstabs + reports
Combo box bound column value
Re-use values of err.number and err.description after a msgbox in the error handler
Combo box question
Database security
How to either programatically reset AutoNumber or simulate autonumber in a temporary table
Calling a class' private method from a form
Create a form to run a Union All Querry for specific citeria.
Upgrade path to MSSQL2000
QUERY 'ONCLOSE' EVENT?
Database Design Questions
Deleting Records Before Packaging Causing Slow Reports
Run Regedit from Access form
Dual "Parent-Child" Combo Boxes
On cancel=true, extra Access-warning?
RTF2 ActiveX plugin from Stephen Lebans
DBase Index Files
Trying to understand primary keys, relationships and such.
What would cause"Compile error in hidden module"
Required Fields in a Form
Parameter Prompt for field, which was deleted from table
Linking tables to SQL Server 2000 causing strange results
CALCULATING TIME
How to check if table exists
data type mismatch in criteria expression
Unable to set focus on a text box
using flash in ms access 97
Initial Value for Combo Box Text field
List Box on Datasheet Form
run beforeupdate from another sub
Getting rid of Access 2000 LDB files
Compact an Access database in VB code
using a remote MySQL Database in MS Access
DDE - Excel XP
Access vs Visual Studio dot.net
Combining data from several fields in a Union Query
Why function does not work?
Dev Ashish function not recognized. Need advice quick.
Comparing input date to current date
Records across LAN
ddl for union queries
Memory usage for reports
Multiple Sort in a Continuous Form - Similiar to AutoFilter
How to bypass 'No current record' error
Detect idle time, shut database down
Upgrade issues from 97 to 2003 - references? DATE LEFT and FORMAT give compile errors
Stop Autosave for Forms with Table Recordsource
Display a numerical query result as a letter
Strange behavior in a continuous forms subform
Passing an argument to a subroutine
subform with unbound forms
Linux backup - mdbtools detect corruption?
can't append or edit data in form & query
One million records a day
Using access data to fill in pdf forms
Can i open remote (http) files for input?
Connection String suddenly Stops working
Deduplication and Data Cleansing Software
Surpress dialogbox?
Check if printer is active
Thanks!
Documentation outsourcing a must to reduce your expenses
outlook data
create autonumber
Form check box & report data
converting data
Need Help opening a form from a form, using Openargs
Hidding dbWindow form user in access app
Set Report Zoom to 90%
Proxy problem with InetTransferLib
Pivot Charts SUCK - need help
Auto Number from a Make table query
Performance of MSDE over VPN
Problem Opening Report From Form
Can DMIN return multiple values
PopulateCombo Box Row Source with list of files
Linked table password storing
Computer bloat question
conditionally enabling a form control
replicate Frontend MDB to Backend Database
Access
ACC97: Linking tables using two fields in each table
Question about Access 2002
Database Issue
Updateable Query
Using On Mouse Over OR Mouse Move to display a description
connection string with database password...
Backup of an Access Database while Running.
Use multiple queries to display information on a form
Access Database on Web Servers
Access and Excel Pivot Table
Anyone have experience using CDOSYS?
Any Idea is welcome
Reports - position of a control
Resize(): Reliable way to determine bottom padding?
Combo Boxes
Tabcontrol - add records
auto generate claim no
create autonumber
While printer.printing
More challenges with Returning orders
I fall down at my knees
Yes, indeed
DLL In Different Locations
before update - validating potential new data?
import+3query+recursion