View Full Version : answers
- Collegamento tabelle oracle
- default entries in ms-access
- Compiling to A2000 in A2003... problems
- #Error Sum Reply
- Setup for ms-access program
- Digital signatures for macros
- DblClickNotInList Finally Fixed
- text fields to memo field
- When are SQL Server and Windows Server required?
- What's wrong with this Tony Toews guy?
- DblClickNotInList
- Table values mysteriously changed in 2 columns only
- DefQuery: How to use key word "AS" to create string for sql property
- How to store/use info from barcode scan?
- how do i change a field to greater then 255 characters
- DblClickNotInList
- General Back End Stability question
- Alguien tiene algun tutorial, en espaņol, que sirva para accedera una bd de access con pHP???
- Using Combo Box To Lookup Record
- F4 & F11
- integer in code
- Refer to multiple columns in Multi Select
- Great Difficulties Accessing my Database from an FTP site
- adding multiple categories to a table with products...
- ODBC--call failed.
- No answer for your problem ?
- Linking to Contact File in Exchange 2000 Public Store
- !!FAQ! for Date: 20040127 - New Users Look Here! [Last Updated November 30, 2003]
- Switchboard from hell - Access 2000
- Tack Changes II
- MS Access 2002 - Forms - Fields - Updatable by Admin ONLY????
- Access 2002: #Error Sum
- need a little help with creating database
- Office 97 Developer Edition Tools
- Automatic move to next Access tab page
- Database size optimization?
- query pass through no updatable
- Using Macromedia Flash as a front end for Access
- new record & scrolling
- Combobox bound to not required field tries looking up null value
- Export report with pictures?
- possibly a strange request for help
- How to get properties of option button?
- Migrate DB to web
- Help (F1) não funciona
- creation and update times
- Filemaker vs Access for Large Records
- ODBC connection strings won't update
- Validate Data
- Delete Query Question
- Req: Help with Imported data containing multiple entries in a single data field.
- Automatic move to next Access tab page
- Basic Outlook Automation Question
- Req: Help with Imported data - multiple entries in a single data field.
- Use Subform calculated Field in Main Form
- SQL in Access 97
- Using a SQL Statement To Generate A Report
- How do I make a "conditional Format" on a record in a subform
- editing custom menus and short-cut menus
- Function not woking first time
- Excel Automation
- Report from multiple queries
- Reading Contacts from Outlook
- Track changes
- Multiple table
- Multiform questionnaire overwrites first record
- !!FAQ! for Date: 20040126 - New Users Look Here! [Last Updated November 30, 2003]
- comp.databases.ms-access
- Select all from subform
- Which event(s) can I use to catch a change of a field on subform?
- databases
- Excel Automation
- SQL Delete query won't work from query window but does from code...
- Searchable product images + prices database?
- SQL Delete doesn't work in query window but does in code...
- Loop Through Recordset and Kill
- access 2003 adding items to a listbox without focus
- msa
- exit program and log off as xp user
- Problem with comma delimted file
- mdb+asp not working on server
- openform action was cancelled - why?!?
- Import a dbf (dbaseIV) file
- Adding a password protected field for a scanned signature
- Renaming a database after compact
- NotInList DblClick ERROR
- Error 2450 When Form Is Definitely Open
- Unable to install MSDE
- Access 2000 Forms with Linked Tables to Microsoft SQL Server
- Access 2003 Manuals and Help Files
- How to unlink a protected table?
- Creating a variable to change the name of an export file
- How to refresh an image control
- Table(s) layout
- Force Zeros into inmatched fields in Append Process
- !!FAQ! for Date: 20040125 - New Users Look Here! [Last Updated November 30, 2003]
- Lookup
- Display records in subform to report
- News Readers
- Changing name of export file
- How do you create a new table with different field names
- Update a Table
- Show Record Number in Header
- hyperlink to open an email browser.
- Different columns than selected in datasheet view are pinted
- How do I rename a file's extension
- References Are Not Permanent
- 2 more easy-moderate difficult questions
- Accomodating Different Screen Resolutions For Different Users
- Access 2000 "Between" query question
- Sending Email messages from Access.
- Table relationships lost when ran splitting wizard. WHY?
- Update query not working and error msg is strange
- Onclick get date???
- !!FAQ! for Date: 20040124 - New Users Look Here! [Last Updated November 30, 2003]
- Relational Theory Question
- Suppressing Status Bar Text
- Prevent DoCmd Cancel Message From Appearing
- crosstab query problem
- Table with no PK- need to know order data was entered
- References
- Distinct count syntax?
- access upsizing
- Save DailogBox
- Problem with rs.Update I think?
- User-selection of records, a unique problem. How to approach?
- Error in Runtime 97 after upgrade to Win XP
- Updating Query After Data Entry for Listbox
- Data entry format
- Referring to last date in table01 to run a query on table02
- Error: This recordset is not updateable
- Linked table ISAM problem
- stupid access db, can't do good stuff
- Need help w/mail merge code
- MS Access
- Command text was not set for the command object error And DoCmd.OpenQuery
- When to use integer, when to use string?
- Database Instructions via Word
- Save Dialog Window
- Question about form/inconsistent updates
- !!FAQ! for Date: 20040123 - New Users Look Here! [Last Updated November 30, 2003]
- PJL
- Field is based on an expression that can't be edited
- A4 page changes to Letter size
- Easy button question
- query make table problem?
- strange error messages when trying to create reports in Access
- Count number of records
- Delete query problem...
- Converting Report to HTML
- Resultant tables not allowed to have more than one autonumber field!
- delete records using querydef with parameter deletes ALL records
- Sendkeys or another method
- Different columns than selected are pinted in datasheet view
- Repeat last entry
- A2002: Finding ListIndex of code-generated combo box selection
- ODBC and ADO
- Excel chart in Access report
- isnull not working
- Navigation buttons problem on one screen
- Access Query Prompting for Value
- WorkAlerts Application Information Monitoring
- Basic Query Question
- Lock a Sub-Form from a Form control
- The search key was not found in any record
- simple yet beyond me
- Wildcards in a lookup table?
- how to graphical visualize simple PERT chart (network planning)
- disappearing controls on form
- Forcing the Count(*) function to update.
- #deleted appears in memo field?
- Help with Sendkeys
- Semplice, semplice... ma come si fa?
- Adding bunch of data in table usnig VBA
- Waiting for another app to close
- Generic coding
- Importing data from an Excel spreadsheet into an MS Access database
- [access] images load
- [access] caricamento immagini
- Default locations for Office 2002 using Group Policies
- Creating Report with two one-to-many relationships
- Clearing checks in column of Check Boxes
- ACCESS 2000 x'd out on installation CD
- Filter and Visible Properties
- Msys Tables -- How do I get rid of them???
- Keeping a non-alphabetical sort order
- Carry over data fields from one form to another...
- output report in html
- Mutliple Event Sink problem
- Passing values between Databases
- Forcing "Blank" to the beginning of a query
- Numbering Records Based On Another Field In A Report
- Access 2000 upgrade to Access 2003
- "Unspecified Error" After a Few Thousand INSERTs
- Update Query
- Table relationships
- How to walk Access object model - Control properties
- !!FAQ! for Date: 20040121 - New Users Look Here! [Last Updated November 30, 2003]
- Inserts via query on 1-to-1 relationship
- Error Number No Records Found
- Need help "weeding out" junk records
- Pivot Chart Legend
- Unwanted trailing spaces added to text column
- Auto fill help
- Update Current Row based on Previous Row
- too many fields in crosstab query
- Searching for a string from a form
- Access 2000 MSI Wizard from SageKey
- PC Crashes
- sending data from popup to main form
- VBA Novice looking for help
- docmd.runsql update problem
- Does access have an application path?
- Repair database
- Missing Help topics in Help
- Numbering Records On a Report
- Printing Specs?
- COnversion question
- AllowBypassKey Function with DDL Set to True
- Problems with Structuring a Combo Box Row Source
- Heavy Data-Import to Access
- Conditional formatting in Report
- How to pass back recordset from inprocess COM object cleanly?
- Display recordcount of a sub form in a main form
- Breakpoint on a button Click does not 'break' when button clicked
- This may be a dumb question, but can't you monitor the progress of VBA as it affects a form?
- access 2002 insert into statement
- How to reference ComboBox Column(1) in query?
- Code style musing - eliminating double negatives.
- Locking and Transferdatabase
- ADODB Connections
- Eliminating warning messages
- Avoiding startup Ugliness
- Stored Procudures renamed with ";1" suffix
- A runtime application (with mdb-file)
- SetWarnings False does not work
- Longing to be like Oracle ...
- Displaying multiple records on a form..
- Stuck on using nextrecord, movelayout, printsection.
- GUID identity
- Tree control
- Sending emails in using Access to Outlook 2002
- link to password protected mdb
- Printing Labels
- Adding blank datasheet to a form
- access97: step into problem
- A2002:
- Two Table Loop - Assigning Names to Records
- The old subform trick.....
- social security numbers again
- Keeping Track of Changes
- Date/Time Field query
- VB problem with LinkChildField/LinkMasterField
- Opening Forms Maximized
- VBA code to fix key violation message
- Approximating Multi-Select Functionality w/TreeView?
- Am trying to grey out a field in a form depending on if there's adate in it or not...
- !!FAQ! for Date: 20040120 - New Users Look Here! [Last Updated November 30, 2003]
- Automate Getting External Data from text file
- minutes after midnight in graph
- conditional formatting
- Restrict user access to tables in MDE file
- Mouse Scroll In Procedure View
- basic report/subreport ?
- changing recordsource of a form
- Can't view AutoCad 2004 drawing in Access 2000 Reports
- Passing query "Between" date values into Report heading
- Exporting Data and Bookmarks
- Multiple Access databases headache?
- Specify "Landscape/Portrait from VBA
- AXP: Err 2467 and Recordsource change - BUG???
- >,<,= or BETWEEN
- Using a single form to enter data into several Tables
- Form with subforms
- Filtering a form works in 2.0 not in XP
- Can't grow calculated field in report
- frontend / backend access question
- Find info based on an item selected in a cboBox
- INSERT Cyrillic to Access DB via ASP ?
- Returns The Previous Record's Value In Another Field In A Query
- Admissions database - advice needed on calculating semester
- Calling a Form Function limited to 1 argument?
- How to setup/change the permission ?
- <Non-Basic Code> in Call Stack
- Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\wwwroot\fpdb\asplogin.mdb;
- Validate fields on bound form when save record - A 2000
- Help: 'trim()' Function not recognized
- Networkdays
- How do I trim a number from 13 digits to 12 using a query?
- General SQL Error -2147221164
- VBA to add a colum to a table and then modify the data type
- Help: I need help set an unbound text box
- Update a form field
- Add up minutes 23:30 -04:05 next day??
- Double Jeopoardy
- Help with Access and VBScript please
- !!FAQ! for Date: 20040119 - New Users Look Here! [Last Updated November 30, 2003]
- Using checkboxes on subforms
- Want to keep deleted records in a separate table. How?
- Preventing mulitple imports of a text file
- System update message Board
- Access <-> MSDE - mangled stored procedure names
- Forms and cancelling updates
- clicking a HTML page form vb/access
- adding a field to a table
- Is Visible Help
- Bug warning: DAO 3.6 FindFirst with Like operator
- URGENT : Access 2000 - Database corrupted just after Launch
- SQL ODBC Error when idle
- How to force drop table?
- Can one not show checkboxes in treeview (for certain nodes)
- Inserting Spaces Between Fields in Expression Builder
- how to put an animated gif working?
- SetWarnings False is not doing the job. Other VBA command?
- Am I doing this correctly?
- ADODB.Recordset from Forms!SomeForm!ListBox.Recordset?!?!
- There is supposed to be only one table . . .
- Help! Access 2003/XP
- Refresh Links Jet3.5 / Access 97
- social security number
- Creating Switchboard that Opens Automatically When Database is Clicked
- Urgent - non-editable fields in form
- !!FAQ! for Date: 20040118 - New Users Look Here! [Last Updated November 30, 2003]
- Access 2003 vs. 2002
- SQL statement too long in VBA - how can I fix it?
- Recording Macros?
- Programatically populate continuous form
- Can a popup form be used to enter SQL?
- Off Topic Opinions or Answer
- Access 97 pop up alarm
- How to refer to a subform ?
- How to create a quote not an order
- Just a test
- ACCESS 2000 x'd out on installation CD
- SQL does not work in VBA, but does with tweaking in QBE
- Using the Lebans ToolTip Class with Check Boxes and Option Buttons
- Multi-pages per sheet report
- Using Lebans ToolTip Classes with Container Controls (Option Frames, Tab Controls)
- Import report
- Making the same data in one table, with same name, appear automatically in another table and form for record integrity and adding extra information
- How to toggle record sources of 2 subforms that must be visible on a main form
- Jump To End Of Loop
- Change color of text box when printing report
- Hiding Access Main Form/tables/queries/forms/etc - Access 97
- Calling sub and/or function
- !!FAQ! for Date: 20040117 - New Users Look Here! [Last Updated November 30, 2003]
- Searching for Duplicates
- Need Simple Help on procedure
- Runtime doesn't work with Window XP
- Save Files On Floppy to Harddisk
- Floppy Drive
- Validation Rule
- Why Two Windows Dialog Boxes for OuputTo?
- Printing Subform
- slow database query
- Updating data using VBA and SQL
- How to have query show differences between 2 tables?
- Schema for accounting system
- Absolute Beginner - Relationships/Forms - Multiple Fields
- Printing To Network Printers
- Data Defintion Query - Creating New AutoNumber Field
- More than one record per record on a form...
- ACC2K2: Dynamic report filters failing on IN operator
- access degree online
- Problems with mixed environment (Access 2000 and Access XP)
- turning text into hyperlink in Outlook (from Access)
- Dirty Subform
- How to add autoincrement field to a table with duplicated records?
- Mouse Scroll
- Dynamic reports PTII
- Query to Build List of Existing Fields in a Table
- Please help me with access
- Testing Query with NO Result in it
- Please help! Email generated by Access -- wierd problem!
- strange combo box behavior
- Ole Drag-Drop between TreeView and another control?
- This is a test posting
- Search Dailog Window opening another Dialog Window instead of a Report
- !!FAQ! for Date: 20040116 - New Users Look Here! [Last Updated November 30, 2003]
- 'UPPER CASE' to 'Normal Writing'
- Error when adding data in Access Database
- Database Corrupted and compacting delete a Table with an error 1206
- Database Replication and Linked Tables
- print number of copies based on text box value
- Pages in subreport
- Shared Database
- How to change control properties programmatically?
- Object to Recordset
- Deleting records in main form and subform
- "Can Shrink" isnt shrinking on report
- MS Access and Shareware
- accessing an Access-query from an applet
- vba code not working Dragon naturally speaking
- FLAGGING SYSTEM
- Query-Access 97 Pulling a Specific Year(s) of Data
- Listbox not updating
- sending emails via Groupwise ver6??
- Access 2002 db opened with access 2003
- Help on Capacity Control Program needed
- Access '97 Bug?
- Popup Form Report Filter
- How to open mdb in background?
- Coding Access For Emails
- Combo Box Order
- acExportDelim With Leading Zeros
- API Calls in lieu of Common Dialogs Control
- Determining Total # of Records and Absolute Position of Current Record on linked Subform
- Reports
- Useful refactoring/function for DAO object clean-up
- AllowBypassKey Change Property Function Assistance
- How to Exit Sub on Error?
- How to sense when a label is full?
- Need Help with conditional print on a report!
- Multiuser Madness (advanced)
- Password requested after Exiting Access
- opening ms word
- Any way to examine/manipulate relationships layout from code?
- transorf a record and open report
- MS Access 2002 and Outlook COntacts
- A2002: Calculated control in subreport not printing
- Version Compatability
- Display Parameter
- Access Project Refresh connection to SQL Server 2000
- Sunrise & sunset code
- !!FAQ! for Date: 20040115 - New Users Look Here! [Last Updated November 30, 2003]
- reply not shown in Outlook
- Parsing and combining values
- EditMode Property Help
- Do I need to use Nothing after each rst.close?
- Help on Capacity Control Program needed
- Controling Report Printing Positions
- How do you.......
- Office 97 Developers Edition - Golden Oldie
- Request - What's the easiest way to make a search field on a form?
- setting a date value to sql server
- Querry on multiple forms
- Help SQL Server / Access locking problem
- Help with Date Data Type ( i dont want to hold the year)
- Table Structure
- problem with sending email from VBA using CDO for Windows 2000
- Help with report filter
- How to get Form properties from Workspace?
- Calendar Active X controls
- Opening .mdb made with access 2002 with access 2003
- Grouping In A Form
- Permanent Reference using VBE
- Can you alphabetize combo box contents?
- Installshield package for access - shortcut
- vba for seeing if a field in a table is indexed
- Converting Text to Date after file import
- Easiest/most idiot-proof UI for database?
- How many records will Access store?
- Access XP periodically crashing on requery - timing issue
- Access 2000 and VB6 gives me 3426 error
- Printing a record from report?
- Code to Changing a property in the table design view
- Help with corrupt table
- DoCmd.SendObject in Access2000 MDE
- Outlook contacts and Ms Acces
- How to make Class properties available to entire mdb?
- A97 / tdf.attributes
- Frequent repair messages
- Looking for 3rd party Access Admin tool
- ODBC Connection
- Access Pack and Deploy Wizard for MDE
- Elapsed Time in workdays (M-F, 8-5)?
- !!FAQ! for Date: 20040114 - New Users Look Here! [Last Updated November 30, 2003]
- ms-access runtine
- Images
- Docmd.OpenReport - slow opening a report.
- Exclude Records in Query, DateDiff/DateAdd/DateSerial/ ? HELP
- SQL problem
- Page Layout
- Help needed with a Dates Access Query
- Why can't this unbound control be changed?
- Access set up for Network
- Stop Delete confirmation Box from displaying
- VB app connecting to Access 2000 db runs slower for each additional user
- ascii sort
- Do datasheets support multiple selections?
- sub report's "report header" on show on first page
- Changing from Common Dialogs Control to API Calls
- How to create and reference a Workspace?
- can I reference a subform as an object?
- Report and zoom, help.
- export variable from a form to a report using VBA
- How to specify mdb as datasource?
- Can't Edit Records Using a Form
- Sub Report controls for printing
- Code to Changing a property in the table design view
- TransferDatabase with key in place
- Can the Access2k wizards be run from code in the Runtime enviroment?
- Access 2k to xp
- Removing Macro Security Warning..arrrggghhh
- DateDiff/DateAdd/Date Serial Question for Query ? Access 97
- 2000 mde with xp
- HELP I need Conditional Fields on report
- Output data in a specific format
- Can a control be SUMMED?
- Dynamic reports
- Linking an Mdb to SQL Server
- Print Reports
- Listing Courses
- Using 'create table .....' to create a table
- This Recordset is not Updateable Problem
- Table Design- one or many?
- DateDiff, DateSerial, DateAdd, HELP
- What's the best way to export a query dynaset in Access 2.0?
- Export Query to CSV File
- Populate Listbox With FileNames
- O.T. - Why would renaming a database file in a CMD window under XP take 85 seconds?
- Access2K: Extract a string
- !!FAQ! for Date: 20040113 - New Users Look Here! [Last Updated November 30, 2003]
- Data Entry Form Outputs to Multiple Tables
- Maintaining and updating an Access database on a remote location
- access query not returning all records
- add a colmn to an existing table using ADO
- Which are better queries in code or stored queries?
- How do I make an MS Word background with VBA ?
- Hyperlink doesn't work i.c.w. Browse button (API)
- Consistantly open database
- Register MSFLXGRD.OCX => error 8002801c
- Counting in Query
- Get names and types of modules/forms VB sub, functions and variables
- Make a MS Word background with VBA
- Autonumber Duplicates Problem
- Access 2000 or XP ?
- Linked table via ODBC
- AllowBypassKey Function Option Failed
- RTF2 Control -> MS Word
- Unable to open form !!
- Page Setup unstable
- What is Best Method to Limit Number of Records
- SubForm on Tab Control Issue
- snapshot on a web page (access xp)
- Setting User Defined Paper Sizes
- Snapshot Viewer PrintSnapshot method
- How to Account for 2 Options
- How to reset AutoNumber sequence?
- Using one form to select the current record in another..
- Help with controlling Installations in Access XP Package Wizard.
- Looking for a loan management database
- rake-them-all-into-a-string query: is that possible?
- Path to a "personal knowledge database"
- Updating form resolution question
- Changing data source for Access 97
- CancelEvent problem
- Please help: set recordsource of report
- If Dir - File lookup
- passwords in Access