Microsoft Access / VBA Answers - Page 108

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
Help in Linking Fields
Getting rid of #DELETE on form with application.echo
how to "disconnect" database connection in Word mail merge?
Q: Help with recursive tables needed
Command to test for success of FollowHyperlink
Help! Complicated Relationship (Part 2)
Using Graphs on PC with Access 97 and Access 2000
Card Reader Information
How to ensure SendObject open Outlook and Not Outlook Express?
A2K db crashes after A2K3/ADE installed
Run-time error 80004005 - HELP!
Create Access 97 MDE from Access 2003
"References" missing from the "tools" menu...
Replace Standard Error Messages
Capturing File Name As Opposed To The Full File Path
No data for subform after Proc executes
What's wrong with my email code?
DYMO Labelwriter
Filtering Queries that use a fucntion to return a value (Null Values in a Date Datatype)
Command or Action 'Setwarnings' isn't available right now?
Error with VB/Access StringFromGUID
controlling a subform from main form?
Setting focus on reports ?
Sub-Report to hide un-checked lines...
Force new Column in Report??
Is Access 2003 slower than 97???
RunTime Error 2455 in Access 2000
access 97: option group and runtime error message 13
Running Access 2003
Save As button greyed out in main menu(disabled)
Creating a Sequential Record Number Field in a Query
Only first digit returned to VC++
ActiveX Calendar Control
Recommendations for a Web Integration Package for Access
Require MS Access Version 2
ADP to SQL Server over DSL connection?
combobox trouble
help in two forms
Faking inheritance in VBA to remove code duplication
entering the same data in several fields
Auto size forms to screen res.
Form, subform, sub-sub form?
Number of characters in a record 2000?
Importing data from excel via command button on a form.
Previous Date
slow to open forms
How do I save a pivot table?
Autonumber Problem
safety warnings upon starting up
Many to Many Relationships- How far is too far?
How to ensure outlook is use during automation from Access? Not OE?
adding a field to an recordset
Querydef problem in mdb>adp conversion (A2K)
Help! Complicated Relationships
I lost my DSN...
My input form just went blank
Repeat Post: Need to lock a group of combo boxes
Requery a form on recordchange?
Send attachment
Tables from Excel database
Outlook Distribution List
query prompts
Error when trying to update SQL Server from MS Access
VB code for copy
Filtering out words?
Conditional formatting in A2003
Data disappears from database
Error not showing up
Member of Workgroup, but ID and Password Prompt to do not Appear
New line in VBA
Print Selected records from DropDownBox
Combo Box/SubForm Index
Trouble with Check Boxes in records...
Bugs in Clearing Form
How to check for installed compnents?
Programmer needed for small Project
Pass null-value to function (How to..)
Access: Protect data in tables from copy and export...
Upgrade to Office 2003 now drops connection to ISP when switching users?
external image files on a report
Please Help: Production list DB
Need help with opening excel worksheets and text files
Placing a black line through deceased items
combo boxes flakey
ACCESS: Make a Search Form
how to deploy mde
Reference Book
Slow down after design changes
Display table data in form text box
How to reference individual cells in Excel via VBA
ACC2000: Import with TransferText
Errors in establishing SQL Server connection - please help
Runtime 2293 using SendObject
Switching between multiple dsn-less connections
memo fields - asking for trouble?
Silmultaneous instances of MS Access 2K
hiding fields in forms
Required Property
Setting Subreport SourceObject Property
Number of items in combobox
back-end being opened in exclusive mode... how?
Normalizing with an Autonumber as a PK
Help with VB Code to open a popup window on the "After Update" event
Help with Configuring ODBC Data Sources to run SQL Pease!
Access Report when exported to MS word Problems
regular expression question to remove blank spaces
access 97 importing specific excel worksheets
replace command
Problems with simple login form
Query Help
testing
Record Specific Email Activation
Security/Permissions questions ACC 2000
append query or other to perform a task?
DLookup() problems Please Help!
DSN Nightmare
Automation error on reading a recordset
How to use data from other field in a found record
bdp ms access connection string ?
Excel opens readonly (sadly enough :)
Why doesn't Like work??
Asking for assistance
Default Design values
Sending email from Access
SQL Date Problem
Print all records after choose by combobox
Preventing File Deletion
splitting a memo field into 2
the name of the Form....
Date() in a form module
Access:exporting memo field to RTF
Move to Last record on a subform
filter in copying data from other database
A few routine programs
ADP: How to handle work tables?
Access: Option group converts to integer
Active Records in a multi-user setting
Can I populate a listbox in asp with values from simple 1 column ms access lookup lists
Switchboard/Startup/Tool Bar problem
Strange problem when quitting program after library reference updates?
Access2K connecting to SQL Server 2K
Vbe6ext.olb File Please
Null List box
MD5 crypt in MS Access
Help needed.
Emailing Data...
Please help me. Multiple problems/challenges
Finding Images in FileName\Image
Room Booking Database
Open Word from Access
Unique ID's with Code 1- whatever
Strange Access effect on CPU
Form error: "Update or CancelUpdate..." etc.
Slow performance progromatically linking tables in Access
Maxing out a filter string?
Access 2003: "Activation"???
SQL Window Font: How To Change?
Access having 2 VBA connections to current db
parameter boxes
Multiple Values in Single Field
Invoice Sub report printing multiple 'copies' Problem
Subform - was working; edited design; not working
Access Performance Problems
Form Timers
Snapshot Reports Still Font Dependent?
To create tables with VBA - To name the new table from a mask'txt box
how to import from another mdb
Code Editor Font
Put Access 2000 on a Windows 2000 Server OS
Getting the first letter of a field
Force another Access App to quit
Combobox - option ALL
Subform screen problem
Setting Future Dates, like a scheduler for a to do list
Correlated sub query crashing report/not allowed sorting
** Room Booking Database **
Button to Advance Count in Field
Union Nulls. Why is 4/14/2004 less than 4/2/2004?
sum() in report footer destroys detail order
VBA Function?
Query Generation - repeating previous value
Access 2000, Citrix, WIndows 2000, PROBLE COM WITH OLE SERVER
Dual language interface
Can someone suggest text books for Visual Basic.Net
Can I add records form a table and related records another table to a third table?
referencing charachter sets
Listbox Popup Menu
Converting Number to Text
Network access - table locks up
Prompted Twice For Filter Criteria
Text Import Wizard Interface Problem
Execute SQL Script
Currency field corrupt display in query..
no period "." in field names? what to do?
Why not to recommend leaving off <>0 in conditionals
Locked out from MS Access database
Determining whether object exists
Repeat post: Windows Installer and Access 97
CMD window will not close after Batch file executes
Specifying version of access in 97 runtime
Accessing hierarchies
Linked tables troubleshooting
Query for winners
multiple viewers in an access database
adding fields to forms in access
Hide calculated fields in continuous forms A2K
Error import or attach external DATA (sort error)
excel automation question
Turn a String Into An Array of Characters
Load Subforms Dynamically?
Help...Filter Subform Wirth Main Form Button
Minimize access window problem
Locate Current Addresses
Question on click event!
Excel Formattings