Microsoft Access / VBA Answers - Page 74

How to display 3364751212 as (336) 475-1212 in a report?
Qqueries in VBA
Removing Dropdown Arrow From Locked Field
Display subform problem
Filter form by records that have subforms
Is this a bug? (2)
Suppress Row of Empty Fields in SubForm
Multi User Custom Counters (Numerous)
Text Driver Question
Passwords!!!
Error Linking to a MySql database from within MS Access
appointment dates problem
DateDiff in query
Copy records from one database to another
Foreign Key Design...
Combo Box
Error message with multiple filters code
Count zeros
Mouse Wheel and Combo Boxes
Is this a bug?
Remove PopUp messages
Probs running DoCmd.RunCommand acCmdCopy in A97
ActiveX controls Browse for Folder Dialog
Open/Close form problem
Generate Number on MS. Access
Version Control
Problem with record addition in subform
date sort in form
Move record from one table to another
Enable/Disable Control Buttons
Deleting records in one table having a matching related record in another table?
Report - Sorting grouped items by count value
Problem - HUNDREDS of pages blank detail section
How to construct an ODBC link to data?
Median function in Access calling Excel worksheetfunction, or change to any excel function on a query recordset
Counting!
convert mdb to mde => application error
Query 1:N
Move object on report during print process
Outlook automation help requested
Access Database to website
Balance Brought Forward
MS Access Outlook
Deselect check box from VBA
Duplicate Entry Check - for Allan Browne
Help Sharing a database
Stop Access saving 'broken' queries
If statement help
How to go back after Me.Requery ?
Using tabs for multi page forms
Limiting Memo Field Size
Referencing problem
ASP and Access, problem with LIKE statement
Another stupid error 2501 question in REPORTS
Query
Linking Fields together in Access
report title based on form filter
Copy fields from one continuous form to another with a button
Time grand total in MS-Access
Drop-down reporting?
Combo Box as Criteria for Select Query
number zero in text field
Mail Merge from Access to Word
Code to Copy all objects in one db to another?
MSComctlLib.ListView doesn't work ???
Data Transform from columns to rows
Creating an AttachEvent to send msgbox
Distribution Lists in the Public Folder - Microsoft Outlook
New Access User Having Trouble With A Few Things
Like/ Wildcard on Form
Using wildcards in query input
Listbox - Requery
duplicate index problem
date is automatically changed
Setting the ControlSource of a form from a variable in VB
trying to use the wheelhook A2k version and have a problem
extracting the constraints
Printing a Pivot Table
Combo box to fill two fields from one selection
Drop down list in Form in Access
I need Recursive query structre that can .....
Copy first line of a memo field to a text field
Second Database Is Slow To Open
Order by an aggregate function
Is it really so Difficult
Convert MySQL Database to Access
Updating query running from form
Create Chart in Report
Combo Box in Form (2 Tables used)
Default Value for a field
Copy at least 1 record or more from one table to another table within the same .mdb
Update field only if field is not null
address fields
Combo Box SetFocus not working...
help in access.
GetRows
Query Works By Itself, But Not in a Control
refresh or requery form display on field change
ADO teething problems
Export tables from Backend
Open Form B depending on the pk of Form A
find and delete records in unrelated table
Object dependencies on macro?
Specifying number of enteries in a subform
Writing conflict when record is unchanged
Problem in Ms-Access Report
Delete records on the basis of another tables contents
In Clause - to query text file
In Clause - to query text file
Locking Records in Forms
Prevent The Cruelty
Use VBA to set or select a specific row in a bound combo box
Access Project "Unviewable"
If else decision making
How can I import 2 csv files into 1 table
If else decision making
Multi-User Database Design
access 2003 and sql server 2005
Set Database Index in Access 2003
Saving records to multiple tables.
Creating forn controls with code
Creating forn controls with code
Hyperlink help! (Hyperlink pro needed!)
Query
Why Type Mismatch
Showing details for one specific record / Drag and drop files to get a link to them
constructing a database from downloaded newspaper articles
BMP image to uncompressed PDF stream code fix
SQL for comapre(exact match) returns more rows than the required rows
Tough Select Query
Problem opening form with selection
Address Scrollbar?
Compact BE while idle... so confused!
How to find differences between datasets in a table
Problem selecting max date
Set an array to empty
Reports with unbound fields #Name? error
Problem getting Memo to a file
Comment to the Microsoft Access world
How to detect if current directory is on a CD
Function SpellCheck_Field()
Problems with Pie Charts on Access Reports
Chr function
current event not firing
Populating an option group by recognising 3 digits
Form Recordsets, Requery and FilterOn=False
VBA Access - Moving parts of a program to DLLs? Error 91.. "Object variable or With block variable not set"
Get text of User Defined Functions?
testing a VBA game/ Hall of Fame feature
A resaonable approach to managing data?
Signing a form in access using a tablet PC
How to open a report with a determine field (primary key)
Electronic Forms software that integrates well with Access
Milliseconds
How to convert lowercase to uppercase in Access table
Hotkey to run query
access charts
Adding a record question
creating tabledef connection to login to ODBC dbase
WINSOCK CONTROL FOR TELNET SESSION IN AN ACCESS FORM
Clear Database and Reset the AutoNumber
Creating telnet form in Access
How do I overwrite table data with a CSV file data?
Multi-user database table export
Button size
Print A Word File with an Access Report
Basic Report Question
Client wants to resell database
conditionally parse a numeric field
Access 2002 Debug stopped working
Why the size become smaller after the fix of corruption?
creating a new field with IIF
MSComm and datas receive
Application.FollowHyperlink - Trap Error
Hyperlinking to a document from form?
Add number of working or business days
Multi-User Database Design
WinSock Novice Needs Answers
Adding the current date to the end of exported queries
Access or Excel if You're Doing Lots of Charts?
Openrecordset with criteria problem
Suggestions for software for mass emailing
ADO Update
Sub-forms of Sub-forms
Access 2003 connection to ERwin 4.1.4
Open a new Form with empty data (new record)
Update table via pop up forms
Hotkey for duplicating previous record's value
IsNull anomaly
Cannot tab to new record
ODBC Timeout - Where to start looking
HARD-CORE GURUS ONLY - Early Vs Late Binding question
Multi-user app on citrix
Converting Seconds Minutes and Hours
Splitting user input into multiple fields
TreeView: How to select an item via VBA?
Access-Microsoft Word Merge, avoiding blank spaces
Input Mask Problem
Einblenden und ausblenden von feldern
Problem with Startup
Authenticate the windows password through Active Directory?
Automated import Excel --> Access
SQL and Parentheses
Access 2002 export problem from memo.
Closing a Form
Align scrollbar in Access 97
Access Form --> Hyperlink to Excel --> Return to Original Access Form ?
How to copy form: Access 2003 to Access 97
comparing a record in one table against a record in another using VBA
Presenting queries results
Transferspreadsheet not importing some data
Subreport displaying unwanted value
Using text box to filter
MS Access Textbox to textbox
How to clean a form before input data
Function to Prevent Open MDB via Access File Menu (Access 2000 AND Access 2002
to show a recordset as table
parameterised view sql express 2005
Access value from Listbox to Listbox
Performanceproblems with action Pass-Through-Query
show the drive map and mdb
MCDBA
use ODBC to import filemaker file
MS Access password problem
Combo box with calculated RowSource
Jagged Lines on Pie Charts on Reports
Printing labels from Access
Access 2003 Memo Field Cut-off in Report
Network Efficiency
How to Combine Data from multiple tables or sources?
Please Help with database upate. New to database
Calculated field based on values of different tables
What is wrong with this VBA code?
Help with VBA
Help - AutoExec not running my Function
Extract Text in MS Access 2000
import LDIF file to Access using VB
Form Design Question
How to sort records on a form
zoom in reports
Problems with a query
"country" dependency when importing into acces from csv file
SQL Server, expressions can call code in modules??
Matching a value from one form to another
Application.CurrentProject.Connection
Search Access Code/Modules/Macros in multiple MDB files
Export a txt logfile from access to excel?
Updated Front-End - Rollout procedure
Can I use the data in one field as a variable in the other?
Reminders
vertical property of a label
Choosing more than one selection in a list box
Copy related sub records ............
repair database password... Help
Subversion and splitting apart MDB files for better version control in VBA for Access?
Memo linked textbox showing first 255 characters only.
tables and queries have an owner of "engine"
Security - FE BE - Replication
Problem with report
How to remove a line from a tab separated file before importing
How to corrupt a MS Access database file in a 'normal' way?
New DB for me
New DB for me
"Invalid Operation" in Report
Printing based on data from combo box
Query with several dynamic fields
How To Give The Client Peace Of Mind
Update field value in MSysObjects
Exporting to excel
Data Definition Query Question -- Add New Autonumber Field
PRINTING REPORTS FROM QUERY IN EXCEL
Problem With IIf Statement
Public Function Compile Error
How to sort table with VBA
Quotes, Tilde, Caret Symbol appears only when clicked twice !
Interaction b/w tables and forms
Background color for Tab Control
Can't delete child record in access
Access XP and Windows XP 64-bit
event/contacts/attendees
can I reduce the number of queries?
Moving a PDF file from one folder to another
Subform Acting Weird (again...)
Access Project (adp) - Filter form and sub totals
EOF and BOF Error
Filtering Records
DAO Connectionless Recordset?
Query With Not or <>
Distributing a split database: catch-22 on data MDB file location
dumbest 2003 question of all time
Is it wise to upgrade?
AUdit trail
Save an Array to a Table
License
MS Access continuous forms annd MS SQL server database
Save the Lebanese Civilians
Generating Word documents from access
Lookup Fields
Complex query with different conditions...
Combo Box not displaying all rows
Query for an Auction
typing a VIN number into a combo box VS selecting a value from list
Extract Numbers from Memo field
Setting visible in a report? Or?
sp correction
Viewing more than 10 records in a dropdown box on a DAP
display specific field content using combo box
any body.to create a listbox with three item.by clicking first item form 1open,clicki
Passing fieldname to a subroutine
Clearing multi-select list
Equivalent RunCommand for Records > Refresh?
how can i divide large records ?
Can setfocus on a field error 2108
Appending Access records to end of an Excel file
Concatenate records into single query
Embeding PDF documents
TreeView Control: How to force tb scrolled left?
Access 2007 - Charts
Invalid Field Data Type
Incremental search w/ textbox and listbox
BG color for Tab Control
OpenForm only opens record with data if form has been opened before
Required: Simple Detect Vertical Scrollbar code
Calculate certain number of records
Tab Control
Picking the Primary Key
Multi-select list as report data source
INF: Cascade-to-Null relations are supported in JET 4
How to Running a windows command from Access VBA?
How Do I Create a MDE from a simple database
Can someone help me with a sophisticated DLookUp?
Invalid Field Data type
Trying To Reference SubForm: "2467 Object closed or does not exist"?
Soting a Query export
Access Forms 2 Web - DMSoft Technologies
Tab Control
Transfer Text problem in Access VBA
deletecontrol issues
openReport over ODBC to Oracle
activex issue - document image viewer - access 2003
form sum calculation error
Where to put code for form control properties
ODBC Call -- Failed
Hope someone can help me with this...trying to keep invalid or dupes on records
ODBC Call -- Failed
"on error resume next" does not work!
Test Uniqueness and add to table
cross reference query
"Microsoft Jet database engine cannot open the file..."
Who's my parent form?
Accidental Replication
Function is not available in query expression - HELP
Delete query?
Delete Field Content - Using Query or code
Delete Field Content - Using Query or code
How to evaluate data from the same table?
report printing
Subform's record source
Archiving data
Import text file to table
MS Access data validation combo list text length restriction
The OpenForm action was cancelled. 2501
If Statement with multiple controls
Chart with SQL source
Auto selected / highlighted when focussed
If Hidden BackEnd BE not found then supress error revealing its location?
MS Access 2003 Find/Replace "Search field as formatted" checked as default
Image Field Help.
converting a 97 database to 2003
Runtime Version of Access 2003
Sample Databases
Dates in three diff tables, creating correct report
Can some one tell me where idiots should start?
Whjere is a file created?
Distinct Rows ??
Query builder vs. vba for timestamp criteria
ComboBox Data in a text Box
Form based on query
Open Report Action Canceled Error Message
Dialling out from Access
CInt function for text fields
Exporting to CSV
One or many
Auto Select Combobox item
Pulling data from another table, making link dynamic or static
Object invalid or no longer set
Access Reports, images, and faxing???
When to make separate databases?
multiple query
Restricting details area
1st, 2nd , 3rd, etc
Micro-pump is cool idea for future computer chips
Null expression???
filter or query based on user input
MS Access query returns many rows in preview but 0 on run (execute)
using query results to search by
ODBC Max Length of Pass Through Query with Access 2k2?
How do I figure out if a query already exists?
Forms With M:M relationship
Concatenate Records into One Record
FOr some reason my hyperlink is not working.
Dates in where clause
Alter Table statment: adding foreign key WITHOUT referential integrity
Query Question
For database on the Internet, if not Access, what?
Max Function
Query: Adding record when source table is Null
tricky form
Does anyone care about DFS?
Print Report on Exit
sorting and grouping
Form/subform problem. Tables not receiving all data
Lookup field vs junction table
Starting up in code view
Primary Keys
combo box
Updating rights disappeared
Not-operator not working?
populating a sub form with data
auto update field
What's the best way to allow web updates to a MDB?
accessing mdb files via java
SELECT entire row containing MAX([Start])
Obtaining handle to control object on a form
Creating a date
Wizard not happening
Search a folder with VB for sub-folder names
How can i delete a record?
Open a PDF File from a form button
Sort by date
Referencing RTF2/ActiveX object content to Microsoft Word
How do I save code result to a table
Export Formatted Access Report into Excel
Can app written in 2003 be converted to 2000?
converting from A2003 to A2000
Subform changes focus back to first record
combobox set to a specific value based upon the text box
Over 80 hours.
How do I get min max from 100 cuts in one record?
Click Yes program code for ms access
Monday --> Sunday
Partial "Replace" of a record
Data display question
problem with startup properties
Create Table?
Doesn't anyone care about scatter charts??
Dates
1st, 2nd, 3rd, etc
Using a form to search records
Display values from one table in another
Subroutines in a Form
need a reference in my module..
Changing a memo CR to "\n";
Change Font in VBA
Checkbox Issue
Running a SELECT query from code
Subform limit while using pages
CASE Statements using SQL in MS Access
update one form based on another
Access slowdown...
Table Relationship Problem
Cascading listboxes
Query-problem: Compare ArticleYearPrices of 2 years
Loading 2 versions of runtime
Problem with character ' in openreport link criteria
Controlling Keys in REPORTS
Partially clear form inputs
Scatter charts
onclick event
Handling User Intervention whilst MoveFolder Object execution
wildcard searches
Combobox Item data selection
Sample ADO application wanted.
Importing specific worksheet ranges
SQL design vs VB design
sending a parameter from an access database to a DTS package in sqlserver
A2003 Developers Edition
Leban's calendar
Save queries to create pivot table templates
Complex Conditonal SQL Statement - how?
Report Issues
Application.CurrentObjectName returns no value?
Not Null and ApplyFilter
Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End
Networking Access
Close ODBC connection via code?
Merging 2 Access databases
SQL (or query question)
Creating fields
OnClick event works w/ command button but not image box?
Make Table Query in 2000?
What's the best concept?
New User Needs Help with Dates
Ms Access front end MS SQL backend
Microsoft Office Developer
CMDialog - File open - Multiple file selection order.
CMDialog - File open - default view
hide or move mouse cursor
Speeding up my code
Shortcut Menu becomes Disabled after an Edit in a New Record?
Storing MS Office documents, .txt files, and .PDFs within a JET back end?
database formation--relationship and forms
Access 97 to 2003 General Question
Hidden menu bar toolbar database window?? :(
Searching subform.. :-P
Many to Many record links within 1 table
Help creating a query
Delete Text File
Multiple Parent/Child record-2-record links within same table
calculating a median within a query
Create a field for every hour between Time In and Time Out
Case statements using SQL in VB Editor in Access
I don't understand this at all...
Code VS query gives different average
could not update;currently locked > MDB is split and replicated.
Retaining Default Records After Editing
Help!! - report to show gpas between dates
Öffne Datenbank
Öffne Datenbank
limit records in left table but all records in right table
Excel to Access
Deleting a table in another MDB
2 Weeks Ago (for date field)
Runtime XP e Access 2000
Field level permisions
programmatically lock controls?
Date field problem
Report sub form filter
How to prevent copying
I don't understand this at all...
Access 2003 user level security
Populating field based on previous field criteria
Stephen Lebans Calendar
Creating a new database for items and quotes
Creating a Item / Quote / Sale Database
Vertical lines not printing or exporting...
Subtracting Time
Union Query
Notinlist Onthefly
Another Way to export OLE to JPEG....
Entering data from one table into a field on a form
sort report by year (weird format)
Audit Changes to List Box Items
javascript in a query's text string
<<help>> with sql statements run from a macro
Creating a query in code
Access 2002 Auto numbering key
Access 2003 MDW issue
Importing a collection of Excel workbooks in Access
Listbox with time