Microsoft Access / VBA Answers - Page 94

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
need office xp 2002
Sorting Where Sort Field Is Null
Appending data...
Show Total In Subreport On Main Report
Properly cased patronymic last names
Format to say "Required"
report totals
file dialog - select a file
Open Form with a filter value from another form
Module Compare Add-In?
Can't manage to get text to be Vertical
Row Total
Populate List or Combo Box with file names in a folder
can't update/change anything in db application
Last Record
VBA question
On Open Event Procedure
Numeric overflow in [tinyint] field
Using hours in a date range parameter
Expressing hours in a query parameter
On Open Event Procedure
Telling programatically whether an Office product is installed
Tab command in access procedure
This script causes NP Pool to exhaust itself - can't see why - very simple
MS Access 2000 + Table + Report
Query Results formatting.
Testing if an entered value exists
How to manage Access security
Help with access code to close a window
ADO query question - which is faster?
SendObject Warning in Outlook 2003
Get stored procedure output value back in VBA
Trouble with Access 2000 and finding a table's source
Problem retrieving printer information for this object
Project time estimation
Month by month analysys
Append Query Random Failure
Direction on a project early on
Using Mag stripe reader to access records
Sending selected items from listbox to report
Format function in SQL
Help Converting from Treeview 5 to Treeview 6
Output report to rtf format
How to open multiple data bases from one GUI
autonumber->number of key
Fw: Compare textbox value to record in table
Date Difference for different records with same GroupId
Validation rule for number
Need help with Justification in Access
Link Table Manager path problems
Access Scalability - records vs. filesize
Combine two tabels to one. (Regular time and Overtime)
MS Access 2003 Runtime Environment
asp.net datalist display single row
Query results in needless/extra zeros
Huge Database Advice
Huge Database Advice
Query timeout problems
Can not open reports in MS Acess 2003
VBA/ MS Access. Code formating/alignment
Using a variable to store an jpg
Automation - Excel & Access
Creating and using Stored Procedures and Views in Jet
Make table from code?
Setting the size of column widths of a combo box through Code and Searching Combo Box
Doing the unthinkable with my tables
Subreport title
Thanks!
Help with error in trying to email from Access...
Access97 crashes on Windows 2000 or Win XP
Compare textbox value to record in table
EDIT COMMAND
Pls help
Saving Access File
Assistance with Digits To Text Function
A Form Letter with Access
Aligning controls in page header and detail line
A2003 Slow in Shuting Down BE ldb
Password that changes according to month
Combo box entries
Unbound Textbox not printing in Report
Get file attributes with code
using lebans rtf2
Access Paper
Access Docu?
How to copy existing table structure to create empty temp table?
ref:disabled toolbars etc
New; going from flat to relational
Visual Studio Tools for Office ?
Determining whether a Database is corrupt
Dim X as long ==> What is the value of X???
Not able to add record
running a query to find missing names between 2 tables
Sending selected items from listbox to report
ListBox question
Pls help
How to make composite unique index?
CHanging the Extension from mdb to whatever
Coding a switchboard so new forms don't pop open in new windows.
Cascaded update/delete box unavaible.
Access Report / Sub report with parameters
Blank pages in a report
Text box in access report not displaying currency format
Securing A Folder On A Server
Unique OrderId number Help
MS Access on a LAN
Can you stuff data into a word doc w/o word?
Prevent Dups in the code
Doubleclick in listbox
Selecting a row in Subform
UPdate Outlook Calender
Call for help to Scouting members
Linked Files
How can error messages be displayed when using Command Buttons - Access 97 ?
A-2003 - FK combo-box losing formatting when selected in main table
Windows Colour Scheme
How to pass variable value...
Refresh a lookup box?
Setting RecordSource
Import Automation and...
Fuel tracking in vehicle database
Automate run all table names in Combo box
Need to parse Name field so I have to fields, FirstName, LastName
Custom Field in Query Slows it Down Dramatically
Access Developer's Edition Questions
Speeding Up Access and Jet on a Network
code to automate full import - reliable?
Lost References in one copy?
Link two tables?
Connect to Internet from Access?
"You do not have access to the folder ... " message using Access97 on WinXP / WinXP SP2
Access Performance Curiosity Question
Datasheet Form Not Growing to Show Data
Modify a remote macro or startup procedure
calculating a percent of total in a query
How to Energize a Dreadfully Slow Query
Enter a Description using scripts in MS-ACCESS
Design of ticket sales database
Visual Source Safe and MS Access
MS Access 2003 - Error Handlers (Add-ins)
How do I make this report?
Simple Query
Union query
Sorting in forms
How to use form to print report
Programmatically remove a form from Access 2000
format : %
How to get user id of windows into access via vba?
Find record using Combo box
before update - validating potential new data
Create autonumber
Problem with recordset name using string
Encrypting some fields
Pivotchart question
Excel Automation Problem
Charts
Update Query (Access vs. SQL Server)
Access Date Format Input
how can I bypass my query parameter
Disable custom menu in ms access 2000 / xp
ACCESS COPY AND PASTE
Toggling Checkboxes
First sign in a field needs to be a CAPITAL letter
adding numerical values for ID purposes
update table from form
Application.ImportXML Fatal Error; Causes? Way Around?
HTML Template File Name Question
Linked Look-up Menus
filter with form--test for null date
Combo box to query to report
Button Images?
Button Images?
restaurant directory database
Listbox...more
Displaying DWG In A Form
Calculated Control using 3 criteria including dates
List Box DoubleClick
tab control page jumping
Formating currency in a report with mils
Formating currency in a report with mils
Breaking Locks
hyperlink in a report
Access -> Excel
dlookup problem
Hierarchical Data in Jet
ASP Login Failure - Database Password
Enable controls on a tabcontrol
exporting database table create statements
Combo box fills text box
Maschera per interrogare query
Limit decimal places with Excel automation
calculation
Username of XP login
Subform and Macro question.
Sample Switchboard/Design/Code
Shell Woes
Opening Excel spreadsheets: How to get past security warning?
Help with Check Box code
Passthrough queries and RecordsAffected
tab control jumps when you try to cycle subforms?
What's the easiest way to convert an access form to to a web based Front end ?
query to split fields into multiple rows?
If Statement
Append Problems
CurDir
Dates in Visual Basic Access 2003
Transferring data
URGENT PLEASE HELP ASAP. Date/ Time multiplied by a cost for a certain field? PLEASE.
Multi-select list box
Google says piss off!
excel automation, cross tab query, parameterized queries
Child Values in One Field?
Issue tracker MDB
Simple html forms out of a database record?
sql server and access
make all values identical
App Path
help whit DBF linking
HAVE YOU HEARD THE GOOD NEWS!
Web page locks
Priting all files in a Directory
Rename an external file
controltip text not working :-(
Access 2003 -- DAP question -- is it possible to display a form with a subform?
Occurences of a field in database
Opening database with text editor
Connection to MYSQL
Count values across fields?
using database password..
2003: Functional Analog of AutoExec at Quit time?
Is it possible to
Bilingual amount formatting
When to requery Form after running Update query?
EVERY Chord, Scale and Mode for GUITAR.. Literally!!
Please take a look at this great program
String Link Criteria for List Box
Problems with Converting Text to Currency
negative
VB6 dll passing dates
Novice Question
How do i view the SQL statements behind an existing report
How do i view the SQL statements behind an existing report
Can This be Done? PDF Background
Reports with lots of fields not otherwise in database
MS Access dynamically change a table in a query for a report
Where could I purchase a copy of Building Applications with Microsoft Access 97?
Seeking site describing "Class Modules" in Access 97
Database capability question
Add a cloumn with a row source
I wanna create a new database
embedd report as a subform or such...
Leban's RTF2 Span Report Over Multiple Pages
*IMPORTANT* Message for Google Group, Usenet and AOL users!
App won't close
Idiot Question: Why do I get a propety Error with the following code?
ACCESS ADO-Update Function does not work correctly
calling Excel xla from Access
Automating update of date restriction in query
Find Record mataching 3 criteria Fields
*IMPORTANT* Message for Google Group, Usenet and AOL users!
Open pivot table view by default
*IMPORTANT* Message for Google Group users!
PrtDevMode I think
Access 2003 macro security
Problems sorting forms in Access 2003
choice of DB
Changing the source of a report and query
issues with reporting foreign keys
Can I reference Form properties from a control's property sheet?
Count Distinct Response
Like Statement
Access recordset alternative?
Select query on text field
Macro to Run multiple queries
DSum([Field) in Subform where its current-records are stored with all subform records
Problems Saving A Report
vb6 dll
Access.CurrentDb.Name and Win XP
Zoom and fit report to wimdow
Copying MDBs Via Code
Excel like autofilter query
DSum basic help
Tracking/sequence numbers
Code for Duplicate Records Warning
DoCmd.RunSQL INSERT INTO
the SUM function and rounding?
Print content of sub form only
Store the Value?
Selective Table Delete question
Large Query with more than 255 fields
Count of non duplicated recs
COMPACTING AND REPAIRING DATABASE
Recordset retrieval Error
Importing Text
docmd.setwarnings false isn't working...
FillDown in Access
Problems with Access 2003 - Keyboard Type Ahead Buffer
primary key problem...
Yes/NO Query Question
Error 2501 The OpenReport action was cancelled... HELP!
Specific excel file to open on a button.
Creating hyperlinks in exported report
Determining first and last records displayed in a form
how to have a date calculation
How can I change font size in Datasheet view of a sub-form??
How to create autonumber
Acc 97 and Windows XP
converting multiple field data into a scholarship amount
Keeping old office CD's for licensing
Report quirk
Eliminate Blank Rows
Access Run-Time and Name/Initials
Report / Query : Multiple Dates
Popping Access form from CallerID
Codes and masking
question about regression in Access
how to get SQL2k user ID passed to Access
I monografia Administração I
transfer db from one computer to another
Access 97 Subform v. Subreport
Screen Scrape?
error accessing file
Update Table from form or query
Parameter Query Prompts
Displaying first record of subform in parent form.
New record button greyed out
Barcode Scanning
Creating a pass through query
Update query Inner Join question
Update Recordset From Code Problem
delete form