Microsoft Access / VBA Answers - Page 108

Reconnecting Front to Back end in Developer
Please Help... Making Comparison Between 2 Years
security query
Access 2002 crashing
Defining a filter by table values
NotInList events
How do you keep users from changing reports and forms
Function to Append DATE to output tablename for Make Table Query
Printing a Word doc from Access
Solution: How to printout a richtextbox on an MS Access 2K form.
Error writing to SQL database from Access
Solution: "You do not have the license required to use this ActiveX control"
Referring to subform via variable?
Error 3386: Relationships Must Be on Same Number of Fields
Protecting code
Input Mask Issue
record a macro in Access 2000
Constantly corrupting Access 2002 database
How in the SQL do I get these two statements into one?
ADO and Union Query Results
A text box question: tricky
"Read-Only" Connection: Any Such Thing?
Help with Forms: How to have form lookup City and State after Zip is supplied
Autonumber is Not Unique
Copying a picture from excel to Access
ASP access database
StrConv and expected error
inserting/retrieving data with relational databases
How to prevent users from modifying data in combo box
Securing Microsoft Access Application
Saving calculated values
remote change to a table and a form
RWOP queries, security and .NET front ends
subqueries in text control boxes
Set visible objects when opening Report
Grab User informaiton for Datbase updates
A2K - reports not opening correctly on one pc
Help! Report Not Printing
launching IE with shell
Temp Table in Stored Procedure with Access Report
Update Query
Locking Records
pulling data with query
Where to learn VB
Creating (not selecting) a range of dates
Hide Duplicates
Access Shell/Instance wont quit
Space in file name
Copy Previou Record
Roster prediction
Commands for the OWC Spreadsheet?
Query works in grid but not in code
Buying Office 97 Developer Edition - pros and cons
Forms and Reports
Add one more to the highest number
a better way to update?
query by field heading
where am I going wrong
How to create custom data migration query?
Combo Box #3, and underlying table
Need Help with Mailmerge to Word 2003
Pension Payroll in MS Access
Links
Cloning a recordset but adding user input
Microsoft Office XP Developer does not have latest msjet40
Help wanted Code won't work
Too few parameters
recordcount in ADO
Code to set property in form not working
Refreshing Data
Wild Card in ADO
Thou shalt not use Autonumber if the field is meant to have meaning for thy users.
Auto Lookup & Populate
Web Support in Access 97 Vs Access 2000
Suddenly Locked!!
ODBC, SQL and Access: File DSN ignores authentication settings
Viewing Total in Report
access 97: multi user and do lookup functions
SMTP retrieve emails through Access
Subquery in a form...
Using dates for months
Gererating an error message when field not entered on form
Combo box problem.
"No more space on temporary disk..." ?
subdatasheet and "You can't carry out this action at this time"
ADP: QueryDef equivalent?
Event
Create recordset based on directory read
Combo Box Problem/Question #2
Access 2002 Db crashing due to one form element
Automatic ODBC Connection
need help with mail merge code
How to get a Digital Certificate
String and number conversion and comparison
How to remove Access acount?
Access: Specific modification between two tables
Validation Rules - Microsoft Access 2000
Application.Run with custom add-ins
VBA code for adding, deleting and searching for a record.
sending enter key to webbrowser control
Access for Company Identification Cards
VBA-help
Error 3218 or Error 3246 problem
how do i take data from a report and insert it into a form
'operation was canceled' error. Please help.
Macros
autocomplete fields in my table
Adding a field to a form
sql querry : Union, Exists, IN
How to select only customers that ordered 2 specific products?
Enter button question
Using Filter by Form on Tab Controls
Archiving the current database and creating a new empty database
SendKeys to Java app
Dynamically created controls
Dropdown box on on name rather than number?
invalid use of null in mail merge function
How do I timelock a database? Help please
ADO/DAO
SQL Query?
Subreport showing all but one row - still trying for an answer
Sending Email and the lovely SendKeys command.
Shortcut menu bar question
Option groups and reports
<<HELP>> Companies that provide software support
Stock control
Num Lock
Type mismatch
How to allow user to select records and modify field
ADO Execute or command execute?
Validation Rule
GoToControl Action Error 2108
MS Access Web Page with pictures?
Help with VBA
I was *forced* to use RunSQL
OpenForm
Week
XML Nested List from Cascading Relations 2
Main table and 32 Sub tables
use data from form on query?(noob)
week format
trying to copy a table to another with a second table as reference
Embedded Spreadsheet in an Access form. How to save data.
again: datatypes Access 2003
Frequency Distribution question
Need the Date Expression to Determine Past 12 months of Data When Month and Year Entered
Determine Combo Box Choices
Reverting To Old Value if Validation Fails
Access 2000 file format on Access2002
DoCmd.Maximize prevents form from persisting
? User level security glitch
Access MDE distribution question
Sharing Access
XML Nested List from Cascading Relations
Access 2002 Toolbar dynamic caption update
Preventing duplicate contact entries
Remote access to a ms-access db
Security question, read only db with subsequent logons
Backing Up Ones SQL-Server Data as Jet
Group By First problem
MouseWheel off without DLL?
Where do I put my code?
Query Parameter drop down box???
Access hangs
Help changing Field Values: Text to Number
Queries on a switchboard?
Outlook 2000 into Access 2000 Can't see HTML message Bodies
Unique index and null values
access/outlook automation incoming emails
Referential Integrity that isn't
how to parse a string
Tool for Isolating Unused Reports, Queries, etc
Sending email from Access
User specific list box
<<help>> Open same form with multiple queries
Table Description
Is it possible to programmatically close a MsgBox?
Data type STRING?
Print selected records from combo
Application Title
Opening A Secure Database
Splitting Access 2000
Controlling a Find Query
Storing a persistent value
default set to 'max+1'
How do I print a report with data JUST taken from a form?
Access 97 Cpu useage
Access 97 Cpu useage
Access 97 Cpu useage
Opening MS Word File from Access Form
Workgroup Security Failing across a LAN - any ideas out there?
Lookups - What's Best...In a Table or on a Form?
need help with importing a Table from another access database in code
need multi selection list box help
How to print non-ole-images
help! scheduling employees projects
Calculating week numbers from dates in other fields
Question: Parameter value query?
DLookup in a datasheet form
sorting arbitrarily
Who could solve this bug (in my balanced line)
Using Proc to return RecordSet to Subform
How to hide excel close button programatically
dragging existing controls onto a new 'tab control'
Help
Open/Save-Dialog
Spacing issue with MS Access report
Access Runtime Error - Tahomabd.ttf
Using a VB function to update records
Need to buy access 2002 , 2000
HELP! Query Ambiguous Outer Joins
OLE and photographs
Compact on close not happening
Writing to exchange contactitem fails
"Access Cookbook, Second Edition" Released by O'Reilly
Table update
Unique ID system -- multiple data sources
OT ish. UK Ltd Company Status. Anybody done it?
Join & Minus Tables in Access
Creating unlimited records
User-defined type not defined
Allow Zero Length field
record count
Relationships - determining a contact person based on 3 fields in table.
Programming to "Print" using CUTE PDF!
Multiple link criteria and new records
What is the latest version of access
Programming to "print" a report using CUTE FTP
Scanning data into Access 2000
Strawman: Is MS Access a "database"?
SQL's equivalent of CASE WHEN ... END CASE
File conversion
Sum trouble
Display value from previous record.
debug.print not working?
League Table design
Use MS Access databse under chinese windows
Exporting/Importing a single record from one DB to Another
Launching Microsoft Access via javascript - Will not stay open
Error Trapping In Access 2000
Date in Query
stripping quote characters?
Need to Average Grand Total of 14 fields
Value from ActiveX Calender
Queries and Like
Combo change to Text Field on a Form
Docmd.OpenReport CRASHES Access '97
Can you update a field in a Select query automatically?
automating oracle ODBC driver connect login
Memo fields truncated when using SELECT DISTINCT
Help with man/months
VB to Access
Printed Serial Numbers
Truncated memo fields when using SELECT DISTINCT
nt 4 profile problem ???
what do you think of this vendor?
Format text within embedded fields
scroll down automatically in subform
Scroll wheel mystery
create PDF and mail in one action
after installing office 2003
What is this Jet Engine error while creating partial replica?????
Between dates (dd-mm) query MS Access
Creating Pivot tables
Better multitasking when running queries?
Access Development 2000 versus 2002/3
concatenate values in a continuous form
SUBFORM goto a Selected Record
mde slower then mdb
Populate a form
Access database works for some users
Form - Subform
Access query Help..
Calculated Field Not Requerying
No Of User Connected..
reserved error occured
Reconnecting Front and Backends
Print from date selection
Docmd.Runcommand accmdsaverecord vs Me.Dirty = False
Form question - how to distinguish existing records
Multiple Filtering on a subform
Sorting RecordsetClone?
Incrementing time from an input time?
Showing datasheet
How can I get DatabaseFileName to refer to the current mdb file?
Maximizing forms
Table design question
Combo Box was ok, but replaced it with Incremental Search that doesn't quite work
Problem with segmenting an ACT database (records will not export)
access form display question?
Just Venting and a Question
Excel Pivot Table from MSAccess 2002 - 2003
Append query from two tables with different fieldnames -- easy linking?
String function in query not working
HELP.... How to avoid updating selling prices?
Update or CancelUpdate without AddNew or Edit Error
Problem inserting record into Access database
REQ HELP: Date Format Mysteriously Changed Globally to Four Digit Year
MS Access Project Explorer showing New Icon and Crashing with Errors
Need help with A2K report/subreport, please
Pick a record at random
Multi-List boxes and navigation
Update Query or VBA?
Read-Only
Determining if an Access Project is open
Access to Oracle Datatypes?
Locations of .dll files
Append query, "invalid password"
Visual Studio (Developers Edition) for 2000 Wanted
Cannot find answer to what seems simple error problem for insertinginto table
Problem with OldValue
Prevent tabbing across multiple records
User Input in an Access Report?
Complex "IIf" Statement erro
Reports - Mystery Data Origin
Accessing your Outlook InBox via Access
how to speed up access?
Problem With Embedded jpg Image
how to check if result query is 0 records
copy the value of a field in one record to rest of record, automtically
Open a popup form with same record source as the subform it is actioned by
connecting to password protected backend.mdb in VBA
size of a field is too long error
How to bullet-proof mde?
Use the input from a query
webbrowser control
How to change the contents of a combo box based on another
Wildcard help
Access 97 linked to SQL 2000 large fields problems
Need help desperately, Problem Generating Errors for currentdb.execute
Either open in exclusive mode or do not open at all:
n-rows or one
Carrying over a name to a subform
Print Access Record from Word Doc.
Forcing Zero in Social Security Number Field and Putting Cursor at Left for Data Entry
Help with hyperlink
3 tables into one Queries?
Prevent characters
Update Query
form - populate several fields before display, and on repetitive use
ReConnecting Front and Backend
Error Deleting record
MS Access Connection Window in ADP
how to deal with quotes and this sql statement
Query parameter with a combo box
Option Button Problem
dynamic sql via code
Finances on an Access Database
Upgraded to Office 2K - SP3, now Access wants Password!
Using Combo box and text box to Query table
Check Print Queue
display last update in a form box/field ?
date sort in Access 97
Password protected backend problem
MSDE
Combo Box Question
DDE functions having no result and no errors
Data in Reports - Where is it coming from?
Too few parameters. Expected 1.
Old Programmer
Old Programmer
File Locking Problem
A97 Import from CSV via ASP page
Code returns unexpected Null for Listbox Column
how to declare more than one variable
(Access97) Does not list Excel as an EXPORT Option
joining two action buttons
Need Calendar Function
SQL - join hassle?
Help Please!!
Visibility of controls in a Sub-Report
DDE & Access 2003
Addressing Multiple Proc Parameters
Access Front End Stored Procedure Advice
Relationship finder for reports
Change query from textbox on form
Try #2 - Inheritance work-around in VBA
Instructions on how to Create a Word document that Links To Access DB
Assistance with Posting Multiple Payment Activity
tapiRequestMakeCall - How to customize behavior?
Access 2 and XLS 97
Please help with hyperlinking rows in summary worksheet
Creating a query with current day but a standard time
Query Question
MS Access Date/Time Data type mismatch
Problem with INSERT INTO statement (Access and VB .NET)
Problem witth Combo Box To View from Linked Server Database
Finding out of sequence numbers
OnAction executing twice
Access 97 Printing
Calculating against Nulls in Access Query
MVP Open Registration
Empty/Blank form appearing!?
Help needed printing groups of linked documents
API Dialog for SelPrint
Form Input handling of Many-to-Many Relationship in Access
Please get my customer receipt working!
Access 2003 Questions
unique data in a table.
Visible property on a mask (MS Access)
How do I get the full month name and not just the number?
Datasheet Subform - Change the width of a column
MDB file
Oops Help switching field type in a table- Was Help Switching Table Types, Please
Help Switching Table Types, Please
Want my subform info to autopopulate...
Populating fields.
Names of OLE objects
How to report on fields from another table?
VBA for beginners
Can access go to a website and read the contents of each page?
Beginner's help using count/Dcount function
Access 2003 Returns Different Recordset than 97
Locating Source Locations For Linked Tables In Access?
Editing records from recordsetclone
Handling groups of records
Print combobox search
Retirving Data for Multiple Select List Box
How to get Macro contents with VBA
Are Access Forms Polymorphic?
Goto Last Record and Open Form at same time ?
Cannot find the file ... [or one of its components]
getting autonumber from last INSERT?
CheckBox in qry with GroupBy
ControlTipText on subform?
use existing connection or create new
<<HELP>> Problem with recalling a record and displaying it on the form!
command buttons
Performin Computations on Date Range Input
How to invoke system command from VBA?
VBA beginner: how to run VBA code independently of Access
Access2k with SQL Server2k backend: yes/no fields and date input masks, how?
Report capturing data from 'red flagged' field
JET
Comparing certain fields within a duplicate records query
Complexity in Posting Payments Using an Update Query
Proper event for option button?
<< HELP>> Enter Parameter Value in query
Syntax help with requery command
Depleting inventory in access
Calling form's methods using a string
Sort Order - random?
How to persist UID/PWD when setting PassThrough query .Connect?
Tool Tips disappear
Warning. Min/Max use on fields with criteria
Carriage return in memo fields and queries
getting multiple fields onto a single line
Narrowing a report using pre-defined criteria - how?
My Code has Problems: Opening specific records in a form based on closed form ?
Display suggested completion for text box input. How?
2 small program questions
How I can check file existence including subfolders
Barcode Integration
Generate records based on a given number range
Set Default Max Records in VBA
Access 2000 Delete multiple objects
HostName Function with Access2K front end
Problem with Access runtime and the swedish language
Copying between subforms, help please.
execute a query with parameter in a vba code
Access recognising screen Res
Sub or function not defined
Query criteria problem
ODBC for Access back end in WAN environment
Access VBA: References
What to do with an empty query in a report?
Can this be used to automate Mapi
opening specific records in forms ?
Sum/Count on Aggregate Query
WHERE TO START?
Error 2486, Access Data Project
"Cant open any more databases" error
transparent XP icon
acces 97: export multiple queries into one workbook
MS access - Unique table for several cash & bank accounts
Lookup/Update Query
Lebans' calendar
Syntax Error (missing operator) in query expression
Format Function
Error -2147221231 A2002 developer
Weed out words...
Forms & Subforms and email
Connection to SQL Server
Stuck on images
Windows Login Name
Access SQL query incompatability (nolock)
security with one user name
IIf in QBE
Passing arrays to functions
Multiple Users Running Same Query
PW logout
Converting SQL Server 2000 query to MS Access 2000 query
"Save as HTML" feature in Access 95 or 97??
Tech: How to return a value to an external call?
1 button reports faxing
Changing print orientation in a subform
Multi Select in Option Groups
Increase the field size >255
Need to upgrade - 2002 or 2003?
URGENT!! Problem sending data to field
MySQL
Disable Shift at StartUp! Can't be so difficult, can it? Access 2002.
Finding Windows Install Key
Max fields
How to sort this
Filter by Form
Microsoft Access Record-Locking Information Icon
fHandleFile() Function in Terminal Server
Integrating Microsoft Phone Dialer ver. 5.2 with Access 2003
stopping warning messages
How do I send Instant Messages through VBA?
Requerying subforms in tab controls
problems with OpenForm - XP
Either open in exclusive mode or do not open at all:
Parsing out Firstname from Given Names
Parameter query returning information in form view
Help! Why won't this just print ONE record by TransID?
Using Like Nz() in Access losing records when used more then once in query
efficiency of query
Customising Buttons
Loops for Parent/Child relationships
execution error '3021'
Exporting Reports to RTF format causes unexpected truncation
SQL Statement - Expected : End of Statement
Omitting Records in Union Query?
Maximum Length of Query String is 512 Characters?
Automating Outlook or Outlook Express.
Column Property of a Combo Box
Access Query Date Range
Fire-up MS Access Database from VB and Leave it Running When VB App is Closed?
what is required for Access upgrade?
Group Level on DAP bug? limitation?
Help using REPLACE in a query
Importing into Access XP
Access: How to disable data copying from datasheet form
Access 97 changes Paper Size in Page Setup in Reports
Using standard Publish It with Word facility
error in recordsource after converting to sql server 2000
Error: "Function is not available in expressions in query expression"
SQL Question
can you do this in access? strings mentioned
Why does HyperlinkPart return inconsistent values?
forms
3 part adp project
Finacial years
Is there a function for the following calculations
Problems accessing a MySQL database via an Access linked table
filtering using 2 combo boxes
Compacting a backend Acess 2002
Union qry format