Microsoft Access / VBA Answers - Page 112

Import text to a variable
Disposing of Old data
Assistance with Query to Consolidate Records
Request suggestions for streamlining distribution process
SQL Help
Handling Hex Values
inputbox to textbox on bound form
ACCESS accessibility from a C++ process launched from an ACCESS form
trouble with access / sage
Copy result of query to new table
Problems Opening Access 2003 mde Files In Access 2002
Add fill characters to ConvertCurrencyToEnglish code
Multi Select List Box options to text boxes
Copy all tables from one database to another
Images in export to HTML, help!
Dynamic Pricing Application
Split a list in two
Table Relationshp Question
Select qry works - delete qry fails
linking front end to back end
Flexible Reports
create new table - no duplicates
referencing forms / modules without opening them
User Level
Thanks to three people who responded to a post...
A strange error message...
delete a table in an external database
How can I go to specified entry from a Windows shell command ?
Word form can link to Access db, as a data entry form?
Updatable Queries using Access 2003
Keeping elements of a report together.
Query criteria based on 2 different form controls
Keep together in reports
Q: Chart in form on demand only
Borrar una linea en un TXT
Select only item in dropdown box
Opening a form with 'openargs'
creating check boxes at run time?
Query to delete duplicate records in staging table
Attaching SQL Tables - Unique Key
Reading my Access database before tomorrow
Compacting a database
Parameters in a SELECT DISTINCT doesnt work
FYI - Sql for splitting a delimited concatenated string into separate strings/rows.
Connect to Access database that resides on web server via Visual Basic?!
Rum time error - Command rejected
Need Insight to Delete Query Method
Access Object common properties.
Can Grow/Can Shrink
Dynamic number of fields in an Access 2000 Report
Creating a new report in exisiting Access database
Need Assistance to Resolve Query Syntax Error
Database locks
dubliacted record or clon record
Report field limitations
TreeView controls and the like
LEFT JOIN with a subquery (?)
Access 2K export to Excel - too much data
Grouping by Dates in a Report
Schema/User Name Oracle/Access linked tables
Are there any forms open?
Navigating Records
Solution for cmd.CreateParameter and Access memo field types
Converting from Access97 to Access 2003
An intranet interface for Access
Access Memo type and ADO createparameter
repost: Access 2003 runtime
delete query frustration
Bug with TreeView control
Find Duplicates Query
Checking for an application in Code - URGENT
How to export colors from MSFlexgrid to excel ??
Help converting flat table to relational.......
Reports - Work on one PC, not on another
Probably a simple question....
How many ActiveX controls can I have? Stack overflow problems...
Access Menus
Main/subform. Subform works but main form doesn't.
Question on duplicates
Distibute an application to many users -- Replication? MDE?
Ask Password
"Implying" entries
Passing values between forms
looking for db design book
What does an NZ funcion do?
Listbox gotfocus error that is driving me mad
photo and images
Split a field based on a character
Access 2003 .NET Code Generator
Dr Watson Access violation error following conversion to Access 97 from A2k
Terminal Server and Printer
Edit Textbox using KeyPress vba code in Access
Help Needed With Bizarre Database Behaviour In Access 2003
reports with images(the error in format or size?)
refreshing records
delete all records ?
How to Avoid or Trap a Syntax Query Error
Access to VB
Access to VB
Error Message : "Object Required"
how can i get access to use search engines and return simple results?
Microsoft Access Calculated Fields
field types
Import Specification changes
Donde encargar o solicitar rutinas de Visual Basic
odd page up/down problem
Update Query Overwrite?
Sorry, Q&A 5.0 need Urgent
access 97: select into/insert into sql question
subreport problems
Navigate through combobox
help with form data synchronising required
Form Problem
Very strange??
visual Foxpro
ADO in Access 2K and Grid Controls
Pausing between forms
Update Query which counts the occurrence of duplicate records
saving table to excel
OrderBy closes and reopens the report
linking to a password protected database
Brand new install of Office 97 -> 'Builder' and 'Add-In' errors???
All you geeky buggers talk about is databases
Access is denied
Save a forms position
Multi-Duplicates OK-Primary Keys
Calculating Moving Average For Previous 12 Records
What is best way to get access to Access?
Synchronized Comboboxes in a continuous form
Question about the QEB
Access ?
Saved Query Works in Access but not when called by ASP
PROBLEM_WITH_MASK
access97: parsing data question
A.I. and automatic searching and retrival from online search engines using Access ?
Security question
Dumb question - took my stupid pill too early
FileSearch object in Access 2002
invoicing question
File - Get External Data - Import - Text Type - Advanced - Specs PROBLEM
How do you guys work?
Getting the right record
Close database window
ToggleButton
barcodes
date troubles
Update Query Confirmation
Problem with Multi-Select List Boxes
at wit's end about corrupted Access 2k records: followup
Ms access email through Lotus Notes
Cannot create MDE
Acccess and Outlook 2003 User Defined Field
Creating a Calendar from Reservations Dates
Return Values from a Crosstab Stored Procedure
Active forms
Duda en campo importe en euros
Process Records In A Table In Groups
Combine four table fields into one record
Problema al exportar datos a txt, y formato de numero.
Date Format ???
Compare Data In Two Tables
Access 2002 mde in 2003 runtime environment
Strip document name
Linear update / make table query..
PEAR DB 1.6.0 has been released
User new addition to combo box with related fields that need to be populated.
queries - simple, joint and multiple
Acces Class Module from outside Access
escape char for access
Export Errors in Macro
Adding one month to a date -- no as easy as it appers!
How to clear an ActiveX-Control
Impact of changing field property in Table
import picture to Access2003
How to make procedure non-reentrant?
Delete spaces of fields in access table
Winzip self-extract for Access Runtime install problem
Passwords & Forms - Access 2000
how to calculate man hours for different project ?
Generic menu handling code
Warehouse stock location tracking
Report from Crosstab Query
pdb file
Numbering in Report
Opening MDE Application using File Associations.
general db design
Virtual Memory
Concatenated column in a report
List box using tables
Access Forms
Error 3061
Problems Caused By Several Users Using A Single Frontend
query does not extract records if blank fields are included
Generate PDF with VB code in Acrobat 6.0
fenton-linson sf wedding
updating a field with code
Access 2.0 Multiuser Application
Unique index works but...
what is wrong with this?
Can A2002 Reports have multiple Groups on total database records???
Double combined Search
Combo box choices using query
HEEELLP - No Value given for one or more required parameters - Win2000 & XP French version
Create Shortycups in MS-Access ADP
How to filter on a report?
Certain Functions Have Stopped Working
Reserved Error (-7711); there is no message for this error
Reading a record set, code reads date as American not English
Create .mde from .mdb with code or command line
Sending an email from Access
Access and DB2
Comparing data in ms access
Querying table using duel date fields
Query Puzzle Access 2000
Access 2002 conversion back to Access 1997 error
looking for a tutorial or detailed infos on how to work with arrays??
Implementing A Junction Table
Lost the plot in design
DAO and database corruption
Updating an Addin
Passing Query Results to Form
Random AutoNumber - Is 0 possible?
displaying data in multiple columns
Does any body know where I can get a list of english words?
Can't display embedded OLE object as icon
Subform Record Pointer Resetting on Requery
looking for online zipcode database and program
Fails to navigate to the proper record WITHOUT a MsgBox
HELP! HELP! HELP
Getting data into Access Table from SQL
Outlook events
Help with automaticallly adding weekly charge
Network Computers Suddenly Can't Access Database?
Just converted to A2002, querries not working - please help
AUTOMATICALLY UPDATE TABLE FROM FORM
RTF2Control/divide text into several paragraphs
Text Box Control Source problems.
Increment Total on Second Table from Form
forms - control tip text
Generalization in Microsoft Access
Length of Formatted String
Query Causes Hard Crash
Set required field to Null
saving [enter a value] in update query
Need help with delete query
DLookup questions
removing last letter in data for a report
excel
What the hell is wrong with the Update statement!
Limit the number of 'Selects' in Multiselect
help with query revised from post (help with query (month as Text) up to given Month) 14/02/2004
Problem with calculations!
unique table property
Word Table to Access
Export to Excel
Text string search query
list box validation
I'd like to get rid of new record so that user doesn't notice it.
field-reference in msAccess Report (SQL server backend)
Update Combos using vba
Numbers in Listbox
Replication with Split database
Error accessing the OLE registry
Problem with Query Date Parameter Selection
Reports - Line Spacing in Detail Section
XP Developer Packaging Wizard Error
Access 97 Runtime - application icon doesn't appear
Parameter Like Statement Criteria Problem
Opening Access 2002 mde Files In Access 2003
Upgrading from Access 2K to ...?
"Query by Search Form" Question...
report building
Upgrade from O97 to O2K --OR-- O2K3?
Error: Enter Parameter Value
Label Wizard - Loses margins
Convert null to 0 in crosstab query...
Access vs. SQL
Dialogic Board / Saving Audio files / Dictation
Good relational database design
combo box after update question
Problem trying to replace a Form using the Macro CopyObject command.
Help!! Calculations
Form problem
OLAP cubes
Scroll in subform only down, UP NOT possible (with mousewheel)
Call Logging
Import Wizard Puzzle....
Corrupted(?) Menus in Access 2000
wrong order of images in printing reports
Object invaliad or no longer set error after onverting from Access 97 to 2000
Exporting to excel csv and how to set the cell to wrap text
images in reports doesn't refresh
Help needed: Wrong strTbl in fRefreshLinks
Complicated problem
Reading forms and reports information in .adp
prohibit double booking in room hire database
text to column
How can I get all table names from MS Access
Printing documents from an Access form?
Brick Codes
Calling vb from other application
#include
very tricky sql statement
Delete query problem
Bound form, SQL server, opening in wrong mode
thin drivers for ms-access ?
Why to be careful declaring variable As New ...
changing field names
How to query for multiple criteria?
Attach a recordset to a subForm?
Slowwww printing on inkjet using DoCmd.Printout
looking for online zipcode program and database
Access 2000 VBA help file
report and print a5 landscape
Running Button Method from Another Form
Need To Create A Master Record
If...Then...Else
Disc catalog to Access table
Error from Office 2000 to Office XP
Access 2k ActiveX treeview control
How to replace a .mde file when many users are connected to the file
Security--permissions not working properly
Dlookup function gives "You canceled the previous operation" errmsg
Scaning Documents Thru Access
Script for Access FTP
Cannot link table from SQL Server 2000
Updating multiple tables with one form
Using a Recordset to Send Emails in Outlook
Calculating fields in query
Cannot link tables from SQL Server 2000
Code to convert a Number to a spelled out number
Office Delovoper
Building a report
Searching in VB
List plus "Unknown" in Combo Box
Access fails when clicking on a subform
Highest Record?
Filters and sorts in datasheet view
Open Access Maximized
Fremdschlüsselbeziehungen anzeigen lassen?
Parameterized Query
Building a report
Easy one
Acc2K FE, SQL Svr 2K BE, Slow form display?
OT - NewsGroup Personality - Gilbert And Sullivan
nz function with where clause
Save Contents of Unbound Field
Getting into secured old databases
sorting difference query-report
progressive number
Nested IIF function
default keypress
Question on multiple forms and referencing data
Error: User-Defined Type Not Defined
Err.msg: You canceld the previous operation ????
Reading excel file and writing to access table
Sample database
Access 97 to XP Access Conversion Error
Can we use Office Document scaning utility into Access as ocx ?
Access <- > SQL Server
Locking records
How to make/package a mde/mdb file so it can be run on a PC without MS-ACCESS installed...TIA
Setting the recordsource of a report
Help needed to store quiz solutions from db to VB
Adding Data to a N:N relationship
Reservation system in Access?
Can we display a report without print preview? General queston
after update handling
adp connection
Rdb to MDB
Error Accessing File - Network Connection May Have Been Lost
sorting mixed data types in field
Another update problem?
Continuous forms, highlighting specific record
ODBC and Access Database Online
Requery every subform?
Screen resolution problem
ODBC
how to declare only once
help with query (Month as text ) up to given month
Print multiple copies
32x32 form icon while taskswitching
Access 97 to XP error Japanese Characters
Zip Function
Sharing Access 2000 Files Between Computers
Saving a record in a suborm with code
Forms and Subforms - Many Calculations
Access 2000 - the right choice?
Access 2003 linked table manager not displaying tables
/runtime + compact on close + references = crash?
Senior Microsoft .NET Programmer/Analyst needed
at wit's end about corrupted records in Access 2k table!
Selecting Data to get a value
Sending date to query problem
Inserting a record & adjusting form?
3 page "Detail Section" - is it possible?
Execute/Insert into method works sometimes??
Referring to subform
Displaying information in Access - general question
OLE IMages in Access DB
problema di sviluppo
How do I declare a variable that allows data to be added to it without losing its existing value?
vexing decimal problems
How to attach an SQL statement to an unbound control????
Need Asssitance with On Delete Code
Can't Open Anymore Databases
MDE
"Catch all"
Dates
ADO not registered anymore
Access-Datensatz an vorhandene Excel-Tabelle anfügen VBA Function (Office 97)
relating queries to tables
Linking to Act
Replication ID /CustomerID problem
How do I create an Icon in a form to Print a report
MouseHook and Tab Controls
Readable lables in a Pie Chart...how can I?
Network Update Data,Information needed
form fields and problems with recording data into the table from the forms
Forecast Report
how to retrieve 'quick launch toolbar' folderpath help!
Calculating subsequent field values in table
append property
Need autonumbering help (novice level)
Access to MySQL
Access 2002 Database Design Help
Display updated Totals
Query Help
Error 3020 Update or CancelUpdate without AddNew or Edit (Form Error)
Beyond my scope =-(
Can't change admin. password because tools menu missing
queries doesn't return new records
Anyway to change the "style" of an existing form??
Count distinct occurences
Re-use report by using a query to filter
Jumping to row in Subform
Are drop-down menu itmes stored in table?
Sympathy for Starwars :)
Method to Display Future Popup Messages
Prevent Deletion of Keywords in a Combo Box Table
query with criteria on two fileds in one table
Updating records in related tables...
mde
MS ACCESS Reports
How to create own tab delimited file
Create Read-only file in MSACCESS
Word files import to access database ...?
how to refresh the "other" data base window
Microsoft Progressbare V.6 how to use it ?
Link To Selected Fields
Running Access 97 on Windows ME
invalid arguement when updating memo field -- size limit?
Access VB6 Integration
Please help
Date Conversion From Text
Determining Field Type and Loops
BackColor On TextBox
acting on null recordset
Help with Function to redisplay a cost price...
Publish to web, Local option only enabled?
? about closing this popup form
value substutition
One last question about using GetObject...
Force Textboxes to new page in Reports --- Help
Forcast Report
Average Payment in Days
Adding a column to an existing table with data
Access 2000 and Calendars
VBA Event Procedures in Form Module Lost Association to the Control on Form
Wanted - report writer to access ms-access databases
Creating a Timesheet
Average Payment in Days
requery problem
Windows 2000 Server Listed as a User in an Access XP Dabase
Access 2002 deployment
LIstBox vs Combo Box for looking things up
Forcing zeroes as beginning of Key Number (ie SSN or Zip) and SSN appearing as 2323E+08
Table Relation Question
Adding Records using DAO and variables derived from queries.
time based message box question
Is there a way to speed up execution of this code?
Concept Question
Code to duplicate records
Help with pictures
Calculate in Text Box speed
user input to query
Writing to a file with VBScript/ASP sometimes gets truncated - why??
Advise please
Outlook Express <-> Access97
Help with dlookup required
Access Forms flow--> Visio
How to distribute app with Jet binaries?
should this ng become moderated?
Median in a Query
Upsizing question
Print quality varies with Access version
Building an expressions where parts are unknown at design time
References
How to access a control through code?
datepart to get mmddyy from date/time formatted mm/dd/yyyy problems
Problems With Access 97 Falling Over
MSDE 2000
download data from access ????
How can access desktop access database from my unitech pt930(s)
Text criteria weirdness
Web Enabled Access 2000 Database
OnNextRecord
HOW DO I ADD a vertical row of values in Access 2000??
More getobject help, please
Security Issues In a Multiuser Environment
query to combine two tables
Mapi Fails on MapiSession.Outbox.Messages.Add
I Am Really Crazy
Acess 97 toolbar help wanted
Bibliographic formatted references
Forms Format
Strange "Mystery Record" Behavior
sql server pass through query
Supress Automatically opening modules
Building ODBC Connect strings that work
How to use SQL queries in a report????
ADO recordfind help
Can't compile anything????
=Format$ field doesn't work after copying database to new computer
Subtract one year accurately?
Groupwise Email from MS Access 2000
Calling a function, basic question
How to know if instance is already running
Access 97 less available records
How to put a menu bar DIRECTLY on a form.
How to print tab in the middle of string in a report?
Backwards Conversion
Storing Only One Value?
Future of MS Access......
401K Account Fees
Link Code Modules instead of Import Access 2000
Check for a Date then do something....
Payroll Hx Table and Reports
"The field is too small to accept ..." error for a bound control on a form
Update Query - Finding and Updating Maximum Order Number
Sympathy for Starwars :(
please help me -microsoft access help reqired
function(s) to split an e-mail address into user and host
getobject
access 97: duplicates in query
Editable mde ...
Form letter question
Form Controls Colors
Import table
Interland MS-SQL Hosting - somewhat OT