Microsoft Access / VBA Answers - Page 82

Problems with 1) Office links sending Access report to Word and 2)send to mail recipient
Strange Access/SQL Error
making a footer visible=false in a report
XP SP2 Screen Updating Problems
synchronizing excel and access
dCOUNT DATE
Working with continuous form....
how to create automatic backup
How to open browser from link in Access
CanShrinkLines hung up by debugger
ADO-SQL LIKE
Honey, I shrunk my sig!
Easier, more straightforward way for VBA to determine if live connection to web exists?
A qiuestion for the community
Shrinking object
database examples?
linked form instead of subform - 1 to many relationship
Browse button in database
SELECT TOP question?
Choose latest data for report
How to include field names as first row of selct query?
Choose latest data for report
Reset Increment number on new month
Create New Parent and Child Records from Old
understanding North Wind Stock control
Reporting
in front end application and back end tables
Get value from a table to a form
Getting around file lock with Symlink or other means via JDBC?
Calculating Specific Lines On a Report
Database form lockout
Can I use VBA to send text to Microsoft Sam (Win XP) from Access 97 to 'speak' the code in modules?
Sorting and Grouping - page break error
Best way to tell if X is between two values? A97
Security
Grpah report is very slow
DbSee Changes
Combo box dropdown problem
Freeze Record after entry
how to pass a variable in insert
date string
If...then...else?
SQL - Left Join not working as intended
ORDER BY ..... in Union Query
sending fax
Changed fields/values on a form
At what point is a Report added to the Reports collection?
PV function in Access
Page setup
Option group Question
Subform new record specific field
Deleting Duplicates
altering field properties in code
Incremental Number
Unicode and VBA
duplicate 20 records
Looping through records
Serializing a class with a Collection
comments on stephan lebans' A97SnapshotToPDFver746.mdb?
Does Access have to be installed on the server?
Am confused as to what Date = Date + 1 means?
Reaching a new record in as sub form
Corruption from MCCAFFE 10
Need Help Urgently with Strange Problem
Query question
Problem with Trim command
Hiding a table contents using security
How to quick-check SQL connection
What is wrong with my connection.
Common Code in Access - Excel - Power Point Programs
Common Code in Access - Excel - Power Point Programs
Add a Class property dynamically at run-time
Limit 'many'Records in 1:many Form/Subform
using access to update a sharepoint (SPS 2003) list
Carriage return in label?
Enumerating Textboxes
Memo fields and performance/db corruption issues; best practices
Access friendly stored procedures transportable?
Getting Access to auto creat letters for a mailing list
Can I make a form goto a specific record using SQL?
Denormalize Data?
select multiple values from a combo box
Data collisions
Delete Query help (A2003)
Can VBA be used in A97 to make setting to other windows programs?
Date formats when exporting to excel via VB
too many fields in a table... over 255
Problem with FROM Clause in Query
Looking for Easter Egg Pong style game Code
MS Access 97 DB Corrupts after Compact
DB design using expiry date in products
OLE information from OLE field
incorrect OREDR BY results when reading from access DB using fields in different charset
Inventory Control.. This is more COMPLEX than I thought!
Recordset Type in ADP
Advice on upgrading 97 runtime app to 2003
Help with If Then statement
Optional Parameter for Querydef with Default Built In
Access 97: Use VBA to find selected column in subform (datasheet view)
open source solution for extracting data from MS Access on Linux?
RunSQL Delete is locking up/taking forever
performing an unusual record search
Last recorded record based product
Option Group Options Not Checking
Custom Row Functions: Access vs. SQL Server
finalizing ideas
Emailing report via access without outlook prompting user!
Severe DB bloat after importing excel records
Printing form with current record
querydefs in 2000 vs 2003
relationship problems
Wrong Weeknumber
Pie-chart printing quality in Access Report
Design Flaw?
Pivot charts in Access
A97 vs.A2003
Print Report with 2 subreports while maintaining different image backgrounds
How to sum columns with code?
Passing information from a form to SQL
OLE information from OLE field
Update syntax
saving records
Print a record from a form
Using combo box values to select query fields
Remote ADO connection to SQL Server (MSDE)
order by property in a table
How do you do calculations in Access?
Best Way to Get At Data in Another mdb
Problems with Code on machines with latest corp image
VBA Question: Is There an Easy Way to Trim All Fields in a Table?
Student Record System in Access
Microsoft Access Secrets?
Form to Subform Linking
Report Driving Me Crazy!!
Query problem
tables and relationships
tables and relationships
tables and relationships
How to refer to the control on the second subform
Simple Password Form
creating a help file
ActiveX Component can't create object
Help! Client's request beyond my Access capability
Problem with Sub-Form and SQL-Server Back End
Query on Formula
OT. Funny story about passwords. I wonder how many people do this
Error 2465 - Can't find field 'forms' ???
Building SQL query when table is two words...
VBA to Add or Remove a Field From a Table?
upgrade A97 or stay put
Automatically Generate Number On Form
Remote ADP connection to MSDE
populating an access database...
How Do I Remove Security
Records getting lost
First Time Portrait ...
ActiveX Error
internationalization of an application
How to split report on Group data.....
in subform different query
in subform different query
NoData event happening when there _is_ data.
make .mde with A2k2 runtime
Importing table to replace existing table
PivotChart with dual scale
Upsize to SQL Server
access report
gray-out and lock one subform record among many in datasheet view... HOW?
Need code to update tables on server database
Need Access Clipboard help ...
Need Help With Query
Relationships reappearing in query design
Delete relationship
Help for Acc. 2003 dev. extentions needed
Private versus public variables and error handling
stupid report question
creating Multiple subforms
Help with ADO Connection needed please
Table Structure help
Table normalizing help/suggestion
Date search problem
Running in Runtime
Open form to Pivotchart view
Open form to Pivotchart view
Problem with exporting/importing
access replication problem
Compatibility
Combo box for a parameter query
Properties Submenu For Custom Men Won't Come Up
Create a Query on a Hyperlink
Help with calculation in MS Access
date reference from loaded form
Joe Celko Nested Sets
Report
Importing Text File
Help with table design
data has been changed error message
Multiple formats in query
Fill out a PDF Form from Access
Help with building an access database.
Why won't Access Run this Query?
Resize Form Controls and Subform Controls at the same time
DB Structure help
PLEASE HELP... SQL SERVER Query in Access
Form resize alse requeries?
Populating Recurrsive TreeView in ADP using ADO
Menus overwritten "bluetooth device not found"
Linking a different table hyperlink to each form record
Active Directory and DFS
Backup database access
relatively new to database
adding a column to a linked table
WinXP-A97: Can't start mailsession
Access Security?
Disconnected mapped network drive
Slightly more complex SELECT query syntax in A97
Error looping through controls on form in Access 2003
Reset Auto Number Fields
Is this valid syntax (A97 VBA)?
Trying to show data in report columns by year
Strange symptom - Auto switching to Chinese keyboard input
I need advice on some Stephen Lebans' code
Change Text Box Display in Reports
Displaying the Input mask when entering a control
Preventing Users From Viewing A Record That Is Being Edited By Another User
Prevent Access from closing
share an access03 database sitting on server2003
Check for field value from within a report OnFormat?
Having trouble creating a deployment disk for an access program
Import Text Wizard Doesn't Work in Access 2003
Showing photos in forms or reports
Better way to test for field being left empty
Saving Pivotchart as an image
Qutting Access when a dialog box is open
Using =Sum([x]*[y]) in a Report control (ADP)
Help Query, two table, look for figure between start and end Version: Any Version
How to maybe save tenths of a second
Printing a UTF-8 encoded XML file
Using MSDE automated with code.
Counting recordsets
Crosstab report Null and Zeros
Resetting the Recordset while within the Form - how?
#Error in query
Checking for group membership?
Sorting Numbers within A String
Ongoing problem with Unknown Function Replace
Align numbers right in list
Easier / different way to do this
Error loading DLL?
O.T. - trying to sync w/ nist time server...
Problem with passing a string to a function
Options - Confirm Actions
Too few parameters expected 2 error occurs after migrating "MS Access 2000" to "MS SQL Server"
Microsoft Access Applicatiion Doesn't Close in my XP machine
The Access 12 Blog/RSS
Access Sorting problem - please help! (also in comp.databases)
count checkbox values
Problem concatenating memo fields in MS access database
Specifications for a development PC
Compile/ADE Weirdness
double data entry with msgbox function?
Mailmerge from MDE not working
Little Help With Update & Subquery?
filter by form/subform
BXOR
Multi-Select Listbox: Loop through, ignoring duplicate items
auto populate field
License question: .MDB files in .NET applications
OpenForm based on combo box in a continuous subform.
DAO (Instantiate as Object or use the Data Control)
Many global vars in an A97 app - good or bad? Why?
Datasheet views
combo box - requery question
Access 2000/2003
Access 2K Macros Appear from Nowhere?
Replace and Update
Order of events - delete record in subform
Any good book for MS Access 2003?
Show current users
time increment query
Date Variable in DSum function
Dirty Event for Form is not "firing".
ado connection with excel pivotcach-problem compact db
Using NetWorkdays Worksheet Function
Insert records to a related table when an option is selected from list
Problem pulling value of OpenArgs into report InputParameters
Launch switchboard from desktop icon
MCACCESS AND WINFAX
Value displayed incorrectly in Recordset
MS Access ODBC -- Connect failed!!
Running DTS package from Access
Using SQL to update control properties...possible?
Combobox value not saved - why
DatePicker
refencing page tab
Locked out of old mdb...help
Incorrect data on opened form based on SQL View
Problem with quotation marks in code
Combo Box
Access stucks in Before Update
Getting Information to Subform
The future of various DB connection technologies and related technoloies
Security Warnings
A97 error #2109 ?
access 2003 using sql view to write reports
access 2003 using sql view to write reports
Closing ADO Recordset created by Execute
Busines Related Links?
trouble with the IIF
Too long combobox
Creating Queries in DAO vs ADOX
import excel with macro and truncate 1000s off of time
Access to automatically send email with excel attachment through outlook
A97 - Can I trap 'n handle error #3315 inside my own error handler?
Automation Weirdness with Outlook
Help with add/subtract
Export to Excel multiple existing sheets
need help in date code..find all product that expired in the month
Restricting selections on form based on live updating query
Link tables by code
migrating old access database over to a new one
User selectable color spec in data fields on printed reports
How to reference the MS Graph control place inside an unbound object frame
Upgrading to 2003
Suppress 'Save changes to layout of query...'?
Field captions in Queries
Verify Format
Problem with filling in Bookmarks in Word
date query
No valid bookmark - no bookmarks present
Join with intermediate table
:?: Need advice on how to create searchable database :?:
MSAccess Freezes, double-click on statusbar helps
Changing query for MS Graph
What happens in procedure 1 the very instant sub procedure 2 is called?
Old ms Acess App
Bitmap prints differently on different computers (repost)
Regression Testing tools
frequent crashing on network
Seperate Totals Based Upon Criteria
SQL SUM Questions
Listing users of a database
Error 3027: cannot update: database or object is read only
Binary data stored in SQL Server: can't read from ASP.NET, *can* read from Access?
Need code to import files
Simple Query Help Needed
Fields do not shrink on the report.
Error trying to change permissions
OT? Recruiter Hell
Help:creating a new invoice?
Unlinked subreport (as TOC) won't display
Import file from a website into a table
How can I hide the Date when I post a message
Data input and tables
Possible to run code in one form from another form?
Combo Box "Not In List" VBA code to Add item to table
Tab Control Sub-report with Different Sized Pages
Dlookup - Determining what table to lookup based on value in certain field
Generate report for different departments in a list
Yet another Query Linking Question
Dividing currency in half?
Help with SQL please..........
Moving a picture from one form to another
Remove orderline from subform when returning order
Detect When Entering New Record
Like problem in SQL
Multiselect ListBox - Active/Inactive Items
Request for Steve Jorgensen
Access Freezes
Inventory History Report w/ Balances
Announcing Data Swap for MS Access
Export to Excel Template gives Error - HELP!
Documenter in adp?
Autoupdate Time Zone in Access
Global Const (MY_VERSION$) 's value will not display in textbox
Connect using file DSN in code using a DAO function
show certain record first in subfrom
Help - Populating a field in a datafeed based on values in another field
Form Losing Data
A97 - easiest way to have a look at a value entered into a textbox during the BeforeUpdate event?
New Computer Groups
Why does tracing (debug) yield different results?
How to transfer info automatically from an excel data?
automatic export with layout in excel....
Finding the maximum value across several fields in a query
Table with 230 Fields....what's a better alternative?
2nd Try: Access Data in Subform
Viewing Data Access Pages (DAP) - Internet Explorer Protecting Your Security
Runtime DB?
Strange new runtime error. Please advise!
MS Access Create form / report with multiple pages using different background images
A97 bound controls not showing default values in form view on new record?
VBA332.DLL and AccessXP And Getting Current Folder
Moving a picture from one form to another
Formal Complaint
Access 2000 view Outlook 2000 Inbox error
Access to Auto Export in HTML format at specific time intervals
Handbase + MS Access
Installing Visual Basic 6 "downgraded" Jet 4.0 to Jet 3.5. How to fix?
Complicated Append Query
How to transfer info automatically from an excel data base to a word document OR an excel
Conversion Access MDB to ADP & MSDE 2000
VB6 code converted to VBA / Access2003
Append 2nd, 4th, 6th line of a text file to the 1st, 3rd, 5th line as a table
How to add a filter in Acess in VB
How to add a filter in Acess in VB
Sort table, not with SQL!
Help- How do I insert objects in a table in bulk?
Registry patch question
How to show the System Name
Trouble with navigation
Problem with HOST_NAME Function with Linked View
Hierarchical Database Systems
Programmatically unchecking Show Hidden Objects at DB-launch
How to update a graph in a subform
Totals query for the last date
Date input mask.
Use of Parameter Query in Code
Creating Object (Outlook.Application)
Run Time Error Question
Deploying access database
Command Button to Unhide Fields
Compact/Repair
Strange report error message - control must have focus
Reference If Statement Result
DoCmd.OpenForm Problem
Put Item from One List Box BACK into Source List Box and Using Field data
Print Code for non-Working Form
Query witt parameter used as Table in SELECT * FROM. Howto?
select count by group?
how to see vba "compiled" code
If Statement Unbound Text Box
multi selection
Linked excel spreadsheet - multiple cells
Lix count (readabillity) / Flesch-Kincaid
Calendar
open report in a succession
record source
Trapping Click With Calculated Check Box
Callback function in ADE file
Interpret Error And Provide Cure
MS Access + HanDBase Synchronising
Create DSN and Link SQL Table in Access - Solution
Trying to filter data as I summarize in Query
query question
Using Access 2003 to Send Outlook Emails
Copying down a column in Microsoft Access
"Sorry, Access has to close now for some reason or another..." msgs in A97
Activate Event question
Automated Time Card System Recommendations
filter field for report - access97
PC Donation Database
search by form question
@ to go down a line in message box prompt
Form Optimization
Access 97 - hyperlink
Access 97 automatic purge records
Access 97 automatic purge records
Looping variables - Integer vs Long
Performance by working with linked tables
Seeking latest 5-digit zip database floating around out there?
Encryption method desired...
How to re-provide password to encrypted linked tables?
Parsing an email address from a string? (A97)
Questions about tables upsized db from access to sql
on delete cascade problem
Getting three highest values
How do I use Insert Into with parameters in .net
Using part of a field to fill in another field?
Help! Run-time error 3358 cannot open Workgroup Information File
Remotely set a db password?
How best to set up relationship between city - county tables?
Help files
Group by Month
Formatting Date As YYYY-MM instead of YYYY/MM?
Using FileStream and XmlSerializer: Gives me the error:The instruction at "0x635e0719" referenced memory at "0x00000000". The momory could not be "read
Date Format
Error 3167 record deleted
automatically entered filter criteria
never can get this right....going from one inbedded subform to another for a value
Data Validtion using a table of SQL statements
Access VB help
Programtically create mdw file
Producing an age profile for members of a club
using access 97 mde file
Locked record message
Using Google Maps In MS Access
License Required to use this ActiveX Control ?
Setting Report Properties at Run Time
Help with Expression Builder
DoCmd.PrintOut .... Doesn't
Turn off View Hidden and System Objects in code
Getting rid of spaces in fields
Access on Citrix: will global vars come back to haunt me
automate import of encrypted Paradox tables?
Access 97 - Working with Chart Wizard
Problem with Totals on Sub Forms and Main Forms
Need to increment a non-standard number
Project problem..........
Creating PDFs from Access 2003 on Windows XP
Creating PDFs from Access 2003 on Windows XP
Why is sorting in the database view bad? (Form Properties > Datasheet View)
activating Date and Time Picker
Breaking up a report or looping through?
Date Format Issue
Duplicate Value error with Single Table across multiple tabs
NZ Example from MLH
Installing Access on XP Home
Action Queries In Series
How to have capital characters not changed into lower case?
Running LIKE SQL in VB CODE
Formula required
Listing fields in a table
rs.FindFirst question
Toolbar button to open Windows printer selection window
Access - Email
Set Up A Workgroup In The Command Line
Creating a unique number from a text string
Can I get the highlighted row from a dropdown?
Problem with MID function
CALL FOR SHORT ARTICLES - Proposal Deadline: 15 Nov 2005 (Extended)
DBEngine.CreateWorkspace Error 3002 Could Not Start Session
Link SQL table through VB Code
First Function - One Problem!
The specified field could refer to more than one table error with curious but inadequate fix
Class with custom event as subform wrapper
Deselect a Radio Button at Lotus Note
Help needed for Programming
Help with setting Access Memo field restrictions using DDL
Automatic timed deletion of tables
Popup window is hiding whole screen
Changing Tab Index of Form Controls
Error message when opening a database
date problem
Access Developers Handbook
Find and Replace
Finding the true binary structure and contents of MS-Access files
Security Restrictions for Signed Databases in Office 2003
Creating EMAIL from VBA (behind a form)
problem with relative paths for references
VB.NET conversion
"The command or action 'xxxxxx' is not available now" Error
Preferences for loading unbound data?
Conditional Formatting
"Jet engine" error in A2000
Date Calculation - same field, different record
simultaneously access
ADP database name?
Access 97 -- how to get to VBA code?
Access 97 .mdws with Access XP databases