View Full Version : answers
- 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
- Publish to web, Local option only enabled?
- Help with Function to redisplay a cost price...
- ? 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
- !!FAQ! for Date: 20040211 - New Users Look Here! [Last Updated February 05, 2004]
- 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
- !!FAQ! for Date: 20040210 - New Users Look Here! [Last Updated February 05, 2004]
- 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
- Payroll Hx Table and Reports
- Check for a Date then do something....
- "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
- Is there an Access 2002 developer kit?
- !!FAQ! for Date: 20040209 - New Users Look Here! [Last Updated February 05, 2004]
- design question
- Access to SQL Server
- Append Query - Increment Order Number
- Bandwidth Required For ODBC Access
- Start and End dates of gaps in date range
- Need help! Trying to auto fill in a form
- RECORDSET NOT UPDATABLE
- Make Table Query in secured DB
- multiple ifs converted to case statement in vb function
- dates - vacancies and bookings
- ASP connecting to linked table in ACCESS (cannot find the input table or query)
- ASP connecting to linked table in ACCESS (cannot find the input table or query)
- 0 or blank Data Entry field on a form when tabing or clicking to enter
- How to resize form from code?
- Access 97 upgrade question
- OT (a Little) Book Publishing Deals
- Query Date parameters promting order question
- Names of the variables as SUB arguments
- Clearing a binary marked field
- Different text styles in the same text box
- using Find property in a form to locate records in a table
- Tablecreate Query
- Outlook Redemption
- Last 5 items loaded
- conversion -MS Access 2000
- Use project without revealing tables, queries, ...
- Add controls to option group
- Parsing Subdirectories
- Import to table
- Urgent: No database objects visible in .mde
- Create PDF from Runtime/Distributed Application
- Help Displaying Tables in DataSheet Format
- Access 2003 Default File Format
- Can this form be made in ACCESS?
- how can i make unbound box limit to one line
- Re-using Old Autonumber Values
- make source invisible
- link helpfile in a button in the menu
- importing and saving an image
- !!FAQ! for Date: 20040208 - New Users Look Here! [Last Updated February 05, 2004]
- On Not In List
- Connect to Security DataBase (MS Access 2000)
- Getting NZ equivalent in an .adp View
- documenting access apps
- Can't read data from a table after saving record from a form
- mssql server to access script
- Send file as attachment to Outlook Express
- Select distict and order by in a combo box
- requery after date picker
- Combo Box Query On One-To-Many Form.
- Problems with IIF
- Using alias in expression
- Encrypt source
- Date Update!
- Null Values to zero
- If-then statement in query
- Growing database
- Hyperlinks to Powerpoint and Word - how much control does VBA give you?
- Using VBA function for Forms
- Losing it with Report/Sub Report from Union Query
- Outlook calendar in Access
- Access and Cash Register Operations
- Displaying only a startup form
- F11 does not cause the form to break
- Problem with images
- Trace which Key button was pressed?
- Task to convert A97 to A2000
- Table w/ Autonumber AND Cascade update
- Having A Query open a Form
- Engineer Avail
- Finding field names through database
- Duplicate value in field or relationship
- How to fill a two-column list?
- VB, PC to UNIX, mySQL, PHP Freelance Programmer Wanted
- Prerequisit to learn Access
- US and UK dates confused
- !!FAQ! for Date: 20040207 - New Users Look Here! [Last Updated February 05, 2004]
- SOLUTION: run time error 3146 ODBC call failed
- Form with Tab Control
- A date problem?
- Set variable from value in a table
- blinking control in report ?
- Subform refresh??
- Filtering Dilema!
- combo box to find records
- About to install Access 2003 - already have 97 and 2000 installed.
- Combo Box Query: Listing a subset - Revisited
- How to post to a remote form?
- Create cXML-File from Access97
- simple way to link an image to a table entry
- Reasons for upgrading to Access 2003??? Backwards compatibility with 2002?
- Update Query
- relate two access databases
- Timer Component
- HELP! - Missing Access 2000 components
- DateAdd Glitch?
- !!FAQ! for Date: 20040206 - New Users Look Here! [Last Updated February 05, 2004]
- SQL select
- Multiple clients (seperate db) one master (sees all db's)
- ? about displaying total from subform on main form
- openrecordset without using "set variable = "
- Grouping in a report
- How do I refer to a subform (VBA)?
- Microsoft Access can't send this e-mail message
- Save from combox bound info to table
- Delete current record
- Null in subquery returns no records
- Multi - Select List box Question
- How to Prevent ControlTipText Pervasiveness
- Relink just not right....can someone help me please
- Charts in Access
- Access internet linkups
- Oracle Person Needs help with MS Access Queries
- On form open, expression has invalid reference
- Pictures in image control don't refresh
- Missing data when exporting to excel
- formatting a Text box for hyperlink
- Alternate backcolor in report
- MS Access - Crystal Reports
- Security on back-end Access 2002 database.
- Stand Alone Access Applications
- PostgreSQL back-end. Ref. integrity violation in transaction.
- Out of Memory
- Calendar Control on form
- start-up projects
- Image Handling Problems...
- Switchboard - Hide the Database Objects
- Entering a Date/Time parameter?
- The memory could not be "written".
- Adjusting the X-Axis of a Bar Graph
- Form created as datasheet; displays as single form
- ADO: Can I insert a stored procedure in a transaction
- opening recordsets
- ADO: new ID after insert
- Query Help - Returning the Difference between Two Values
- Help out with a difficult query?
- Change default reference from access11 to access 10?
- References
- !!FAQ! for Date: 20040205 - New Users Look Here! [Last Updated February 05, 2004]
- Why does Access get confused with the result set?
- Acrobat 6.0: Print PDF by VB Application.
- Auto populate field based on recordset and coding
- Getting last entry of field for default value in form
- Weird Access 97 MDE behavior
- Msado15.dll
- Query for Report to allow choice between 2 date fields for date range
- How to connect access remotely
- Parsing an XML file
- sql optimisation
- Output To Formats Missing
- Writing from unbound comboboxes to tables
- Subform will only show 6 records
- Before Update Event for Text Box Contents
- Creating duplicate data
- Need help on importing an Excel Sheet into Access 2000
- Subforms - 4
- Hours and numbers
- datetime field overflow (year 1899)
- Showing same ref number in 2 Tables
- Modifying Objects in Access XP
- Combobox help needed...
- Stumped, Desperate: Word 97 with Acc 97 on WinXP...
- Recordsets .. why the error message?
- TransferSpreadsheet fails in simple reproducible example
- Create List of Report Recordsource Items
- Auto fill in without one to many relationship.
- Merge Records From Multiple Sources
- Frontend on Windows PC/backend on a Mac?
- how do I use word doc in access
- Linking from Access 2000 to Access 97
- Time portion displayed when field has the focus
- Charts in access - serious troubles
- Compile error: Can't find catalog - But the reference isn't missing!
- Relationship between tables
- Capturing e-mail messages from Novell Groupwise in Access database
- ERROR Message in report
- multi-select list box
- Moving between forms and other bits
- Repost: Really no one knows about this? (Pivot table)
- Video library database
- Line Method in Access Report
- Linking table SQL help needed
- Help with union of 2 tables
- Custom Navigation Button Woes
- Cascading Combo Boxes to Control a Subform
- Automate faxing in VB VBA from MS Access
- Hints to speed up 1 form
- !!FAQ! for Date: 20040204 - New Users Look Here! [Last Updated November 30, 2003]
- Report Section Height Issues
- Access and LEADTOOLS
- Access2000 can't find Utility.mda file
- Tab stop ??
- Can you format a field as MM:SS in MSAccess? If so How?
- .AddNew does not work if a relationship is declared.
- Usage of db1.mdb file ??
- Code to validate StartDate and EndDate
- Prevent a Specific Value in a Text Field
- Mulitple Main Forms Created by Sub Form Entries
- Access 97: Print report without type CTRL + P
- Split database
- why is visual foxpro 8 much more expensive than access 2003?
- Converting currency
- Date Overlap Challenge
- Display record number of record count in a subform
- Problem with decimal number smaller than 1
- Updating Form Data to Table on Event Procedure
- Using multiple tables as data sources in forms
- Duplicating data to different tables
- Export Access table into another DBMSpreserving Unicode characters?
- Need a familly tree schema
- Requery of combobox doesn't show properly
- Updating Forms
- Sub query problem Access 97
- THANK YOU!
- Scrolling in a Combo Box
- not able to make changes in table
- Phone Input Masks - Area Code
- Efficiency of SQL UPDATE vs Recordset .edit/.update
- Dealing with Name data
- Make Table Query Question
- "Object No Longer Exists" error on one machine, but not another?
- Outlook from Acces (XP)
- Pivot table in data access page on Win 98: fields OK but no detailed data
- Front-end bloat
- Passing field valuse to stored procedure
- To save from a temporary table??
- SQL "in" statement anomaly
- Text Box Control unbound doesnt Sum
- Select names begining w/same ltr in query
- Why is the Switchboard Manager grayed out????
- Question about Joins in Access
- Search form to display results in results form: can't invoke sql
- CAlling a web service from access
- Seasoned Reports suddenly quit working
- Design Check: Creating a Yes or No Drop down box
- Access will not close
- !!FAQ! for Date: 20040203 - New Users Look Here! [Last Updated November 30, 2003]
- Auto email with Access 97 and Outlook
- Sharing a MDB file on a Windows 2000 Server network
- Problem with a date query
- Scan for each matched record
- Help!! Time Calculations.
- Any foreign character mapping charts available?
- Count records on a subform recordsource before/after populating?
- EXPORTING Q&A DATA
- Size of report file
- Print problems
- Combo Box -- Sub Menu
- how to send an e-mail to all record of a table?
- Calculating Dates
- No close (x) buttom for the access
- Different version of Access for frontend and backend.
- Import changes
- Changing Formatting of All Controls in Current Record
- Access Help Pls....Can pay some
- Export lossless
- Print acSelection (i.e. single record) from subform
- I'm goofed up in On Error
- Can't Move Between Records on a Form with the Navigation Buttons
- Can Grow in Report Still Not Showing All Data
- Sub Menus in Access
- ListView ColumnClick Event
- Good DB design question
- How to make a datasheet work like a spreadsheet?
- Weird Compile Error
- Sum Unbound Control on Continuous Form Footer?
- RTF output not identical to Snapshot output?
- Slow query
- Report Filter in VBA
- Calculating Elapsed Minutes
- Relations not visible
- Is it really necessary?
- Checkbox like hotmail or any other web-based email
- Access 2000
- Reports
- Handeling months in access
- Is this a bug?
- sorting question
- Computer User Weekly?
- Access 2002 printing in upper corner of paper
- help with images and reports
- How to see a picture in reports and Forms
- !!FAQ! for Date: 20040202 - New Users Look Here! [Last Updated November 30, 2003]
- For Steve Jorgensen
- Problem using query to supply Default Value for textfield
- database objects
- Using Switch() with numbers
- How to import VB source text files into Access?
- Access 2003: Forms!MainForm!Subform!Control problem
- Collecting information from Access Applications for Word
- Calendar-type reports in access
- Tweaking the Control Text Tip
- FirstName/AltFirstName in code
- Lost tool bar on form
- <<NEED INFO>> Access XP Documenter question???
- How to delete empty "Microsoft Access Class Object"
- Assigning a Variable OpenArgs
- Popup
- Action after closing a table
- Virtual Keyboard
- Hiding the database window
- Lost tool bar on form
- Lost tool bar on form
- Use New for multiple rept. instances conflicts w/ ControlSource on open
- Lost my tool bar on form design
- Rapid Chart displays like a movie.
- ComboBox Selecting Specific Records Filter
- Detecting When A Subform Has No Records
- compact an mdb
- testing an Access application
- Access97 hangup when reading corrupt file on DVD
- validate fields
- Date/Time Calculations in MS Access 2002 using a MySQL backend
- !!FAQ! for Date: 20040201 - New Users Look Here! [Last Updated November 30, 2003]
- using multiple click boxes to store entries
- errore 3343
- [Error]: External Database Driver 11265
- Subtotal From Subform To Mainform
- Newbee TransferText question
- Access Simulated Functionality Limited
- Conditional Concatenation in Reports
- Base for Parameters Array - OT
- reading external data that hase 2 formats
- Object Variable question
- HiTech United Weekly Newsletter
- VBA functional equivalent of "IN" or "AMONG"?
- How to use Function to pass query parameter?
- Query based Report with One-to-Many Table Relationship
- expression problems
- !!FAQ! for Date: 20040131 - New Users Look Here! [Last Updated November 30, 2003]
- Help wanted: what source code to use with form field rules
- Setting a new COLOR_APPWORKSPACE in Access 2003
- VALUE SAVED BY COMBO BOX
- have to use Access XP with wireless network
- Access IRC Help Channel?
- ListCount bug with column heads
- How to Derive Dual use of Combo Box
- Web enabled databases
- Assistance with Open Recordset Or
- Access 97 upgrade to Access 2002
- multiple stLinkCriteria?
- Import/Normalize strategy - More issues - New thread
- Plargiarism Database
- Mailmerge no longer works with Word 2003
- Integrating MS Access with SAP
- Saving An On-Screen Report To A Snapshot File
- Mulitpile Pics in a report
- Forms question
- Form Tab stops
- access97 parsing out enter and tab spaces in fields.
- Access 97 license error
- Inserting text into MS Access with ASP.NET
- Creating PDF's and Bookmarks
- Database encyrption?
- !!FAQ! for Date: 20040130 - New Users Look Here! [Last Updated November 30, 2003]
- major problems with Package Deployment Wizard.
- Moving Fields/Data from one Table to another
- Launching an add-in from code in a multi user enviroment
- Default Value in Drop Down Combo Box
- Office 2003 Backwards Compatibility Issues
- STDEV()
- Form/Subform problems (OpenArgs)
- Calculating age
- Access97 running on Windows XP: unable to create table / query
- Converter Workgroup p/ Ac2000
- XML Import Error
- Multiple change text
- Preparing data for exporting
- Date() function in Access
- Time diff between records
- Automatically Creating and Sending a Outlook Appointment
- Access Shutting Down On An Error When a Query Is Run
- imgPicture/StringLink
- Easy sequential record numbers in Access queries
- Access in a workgroup?
- Calculated field question????
- Report Creation Problems
- Using a subroutine to populate a field in Access - how to tie to field?
- Select Max to Get Value for Field
- Subform/Main Form Calculation Problem
- me.refresh issue (reprise)
- How to print section headers when no details.
- A2K2: Image control cannot read .GIF file
- Date Calculations
- Binding text boxes to fields in a query
- zoom a report 250%
- Goto Helpfile
- Color coding in 1x1 BMP in OLE field
- helpfile(help&manual)
- Riunning A Macro from VBA
- !!FAQ! for Date: 20040129 - New Users Look Here! [Last Updated November 30, 2003]
- Refreshing Main Form Field
- SQL - SELECT DISTINCT
- How to create non-unique index with DDL?
- Compile error: Method or Data Member Not Found
- Access User Utility
- Form / Subform Problems loading Data
- Report running sum-Help with DSum
- Q823718 Security Update for MDAC: TransferDatabase command changed?
- QUERY BASED ON TEXT BOX
- Using a command button to edit a memo field
- How to Migrate Access Users/Groups/Permissions to SQL Server
- binding fields
- Change line height at print time
- subform data from 2 other forms
- Performance issue: combo vs pop-up form
- Access 2002: #Error Sum
- Quit, Close and AccessXP
- Import/Normalize approach - column-DML, or loop
- Viewing Reports
- MS Access odbc issues
- conditional delete
- Linking Files to a Database
- How do you handle multiple elements in a collection.
- How do you handle this combo box problem? Do you have a method?
- Use a field from Main form in subform
- Access to excel
- Refreshing a form
- Mail Merge
- How to save changes to form property in VBA?
- trying to run DoMenuItem - Database - Window - Hide in autoexec macro w/o success...
- Query Expression Show Only <0
- Read only linked tables
- Using switch instead of case to specify order
- How to show Record counts on Forms!?
- Access and Oracle part II
- Adjust main report timing to solve null subreport
- how more than 255 characters per field?
- Lookup field in table
- tools for printer programming in Access 2000!
- 97->2K conversion causes large size increase
- can format memo fields (line breaks, etc.) in Access reports?
- !!FAQ! for Date: 20040128 - New Users Look Here! [Last Updated November 30, 2003]
- webpage development: Datasource update: Any help would be appreciated
- File copy problem
- protect database source
- Is it just me ?
- Auto Reminder
- Read Only Tables
- SQL statements (INSERT...INTO)
- Access and Oracle
- Lookup in a different database?
- Collegamento tabelle oracle