Bytes - Microsoft Access / VBA answers - Page 59

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
Incremental Number
altering field properties in code
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?
Corruption from MCCAFFE 10
Reaching a new record in as sub form
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
Access 97: Use VBA to find selected column in subform (datasheet view)
Optional Parameter for Querydef with Default Built In
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
Emailing report via access without outlook prompting user!
finalizing ideas
Severe DB bloat after importing excel records
querydefs in 2000 vs 2003
Printing form with current record
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...
Records getting lost
How Do I Remove Security
First Time Portrait ...
ActiveX Error
How to split report on Group data.....
internationalization of an application
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
gray-out and lock one subform record among many in datasheet view... HOW?
access report
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
Open form to Pivotchart view
Open form to Pivotchart view
Running in Runtime
Problem with exporting/importing
access replication problem
Compatibility
Combo box for a parameter query
Properties Submenu For Custom Men Won't Come Up
Help with calculation in MS Access
Create a Query on a Hyperlink
date reference from loaded form
Joe Celko Nested Sets
Report
Importing Text File
data has been changed error message
Help with table design
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
Form resize alse requeries?
PLEASE HELP... SQL SERVER Query in Access
Populating Recurrsive TreeView in ADP using ADO
Menus overwritten "bluetooth device not found"
Linking a different table hyperlink to each form record
Backup database access
Active Directory and DFS
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
Having trouble creating a deployment disk for an access program
share an access03 database sitting on server2003
Check for field value from within a report OnFormat?
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 2K Macros Appear from Nowhere?
Access 2000/2003
Replace and Update
Order of events - delete record in subform
Show current users
Any good book for MS Access 2003?
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?
Too long combobox
trouble with the IIF
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
Suppress 'Save changes to layout of query...'?
Upgrading to 2003
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
Seperate Totals Based Upon Criteria
frequent crashing on network
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
Data input and tables
How can I hide the Date when I post a message
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
Form Losing Data
Help - Populating a field in a datafeed based on values in another field
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?
How to transfer info automatically from an excel data base to a word document OR an excel
Complicated Append Query
Conversion Access MDB to ADP & MSDE 2000
VB6 code converted to VBA / Access2003
How to add a filter in Acess in VB
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
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
Compact/Repair
Command Button to Unhide Fields
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?
how to see vba "compiled" code
select count by group?
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 automatic purge records
Access 97 automatic purge records
Access 97 - hyperlink
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
Getting three highest values
on delete cascade problem
How do I use Insert Into with parameters in .net
Remotely set a db password?
Help! Run-time error 3358 cannot open Workgroup Information File
Using part of a field to fill in another field?
Help files
How best to set up relationship between city - county tables?
Formatting Date As YYYY-MM instead of YYYY/MM?
Group by Month
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
never can get this right....going from one inbedded subform to another for a value
automatically entered filter criteria
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
Creating a unique number from a text string
Set Up A Workgroup In The Command Line
Access - Email
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!
Class with custom event as subform wrapper
The specified field could refer to more than one table error with curious but inadequate fix
Help needed for Programming
Deselect a Radio Button at Lotus Note
Help with setting Access Memo field restrictions using DDL
Automatic timed deletion of tables
Changing Tab Index of Form Controls
Popup window is hiding whole screen
date problem
Error message when opening a database
Access Developers Handbook
Security Restrictions for Signed Databases in Office 2003
Find and Replace
Finding the true binary structure and contents of MS-Access files
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
Copy A Table Into The Same Database
Can an Access 2002+ app "link" to local xml files?
Can ADO connect to a remote mdb on a web server?
Can an Access app run on a web server?
Programatically Set Startup Form
locked main form conditionally validate 1 subform based on other subform
Distributing Access run-time
add a field
ODBC and Deadlock
sending email to selected contacts
A question about joins
Earthlink's Abuse Policy (long)
SQL and var
Getting a coherent database brief from the client?
SQL and var
Reading data from an DBF file.
Cancel BeforeUpdate and Return To Old Value
Subform error
Null values in query
learning guide suggestion please
Sorting Delimited Text in a Text Box
Quick Question
Getting first 2 numbers of the current year
Access does not remember chart axis format
A97 - Experimenting with Nz - getting return values that are strings rather than numbers???
Append and make table query,prompting for yes or no from access
Two Forms Linked to the Same Table
MS Access filter linked tables, front and back end. Can someone help?
Colour Blindness & Screen Colours in Computer Applications
Extended graph types
Remove Automatic Email Link
create new fields
Jet problem access 2000
Lookup value in weighting table
Photos in Access
Formatting Issue
A97 query field named "Description" is a problem
Open Forms in Hidden Mode
View a Report on a Form
A97 - what would you do 99 times out of a hundred?
MS-Access 2003 & SQL Server
Access 2000 Disable Close and Minimize Buttons
Table names in combo box
Looking to have one field based on two other fields.
Client/server tip - inconsistent collation order betw. Access & Server
Copy all objects to another db