Microsoft Access / VBA Answers - Page 95

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
How to Sum totals contained in queries?
Access 2000 Tab Control OnChange Event does nothing
How would you...(report vs numbered copy)
Have you ever worked with a secure MS-SQL serbver/database?
Total Query from Subtotal Query
Access 2003 - Left Join wierdness
ListBox: Changing appearance of selection rectangle depending on focus?
Populate text box from selection keeping navigation working
How to make ComboBox selection save?
Any advantage to converting DB Format from 2000 to 2003?
"Screen Scrape"
Printer object bug with Access 2003 - confirmed by Microsoft Corporation
Printer object bug with Access 2003 - confirmed by Microsoft Corporation
not show records in a form
auto update currency?
Is it possible to prevent the addition of new records but still be able to edit existing records on a form?
Writing into external table not possible
RecordSet as Record Source
Fill Down in Access ?
Hide Ttle Bar
How to unlock VBA Project?
Populate multi-list box based on selections in a different multi-list box
multiple field primary key in Access 2003?
Save record if any field has been modified on form
Could someone direct me to information on the proper use of WHERE statements
Calculating amount of time spent on a project
Hyperlinks in Access 2003
q. Downloading Photos From the Internet
How can you open a form to a specific record from another form?
Refresh form, Access 2002
Problems linking the value of a ComboBox to a SubForm
I need a function to get the date of the monday in a given (year,weeknumber)
Access 03 and HP Laser - Print Shrinking
Can query with left join be made editable?
Keep together
Efficient temporary tables
Query totals disagree with Filter totals
Unable To set A2k .SubDataSheetName in A2003?
Record Limit in Access 97
Access 2003 macro security
Access vs Excel Presentation
default print settings
How to display zero when value <0 in control?
Populate Form with CrossTab queries and add records to them.
Urgent Help Needed-Copying a FE/BE db
SendKeys Generates Error
Access 2003 Question...
Access Book?
Access 2000 ADO execution failing
Checking matching records
Access 2003 - Left Join won't work ... WHY?
Error 2501
How do I count how many times each distinct entry in a column appears?
Open Excel spreadsheet from Access 2000
Outlook blocks email from access
email a report copy of a form
Cannot create Outlook Object?
Stuck with Run Time Error 2455
Petty Cash Database
Solution for : Access97 SendKeys command disables Numlock....
Access book(s) for a professional developer
searching a query using combo boxes
Setting References
Converting SQL Server Stored Procedures to MS-Access
how to pass a parameter to SP from a form?
Textbox with vertical text ?
open an input window by field selection
Passing a ParamArray from one Function to another Function
Where's my function?
Access 2000 incorrectly deletes ldb file
Speeding Up Reports
Sending Individual Reports based off Data Returned
Random Selection Of Records
Hide ODBC linked table connection information (username and password specifically)
Task list in database
Pop Up or Modal
Linking two tables' data in a subform
Time & Billing Database, Resetting index???????
Edit a group by query
Access Command Line Open Specific Record
Charts Not Showing Data
The ER diagram
procedure parameter question
Is Access a Microsoft development?
Documenting development of and changes to databases
Changing Backround Color in Access
A Whimsical Little MS-SQL Backupper
Finding duplicates
Access 2003 ADE
Changing default settings when using the Wizard
Find Record - Choices appear in Combobox
Can Shrink - Access 2000 vs. Access 2003
Error message OLE object not registered???
Help with MSysObjects problem please..