View Full Version : answers
- 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
- Counting records returned in a combo-box on a form
- 'create table' not coping with /
- A97: Might I need to set reference to Find and Replace 8.0?
- Installing an OCX or adding an mdb using references other than the BASIC-3
- How to open a protected access file and shorcut keys
- Error Handling : Is it possible to raise the culprit record & field ?
- Postcard
- Opening another Access application from an Access ap;ication
- Excel Link - Can no longer update - Legal issues
- summary by date range
- Date Conversion
- Type Mismatch Error
- O.T. - How to print msconfig STARTUP list?
- Access 97 References
- copy relationships
- A97: problem with Set rst = dbs.OpenRecordset("tblMyTable", dbOpenTable)
- class module & continuous forms
- Need help with Input Mask
- References to ado210.chm keep popping up since yesterday... can't shake it.
- MS Office Access 2003 (simple forms)
- Problems in calculations in MS Access 2003
- A97: Dim dbs As Database yields error "user-defined type not defined"
- Error 2465 with Year Function
- changes in the subform
- Disable the close buttons
- Exporting query results to excel max 255 characters
- Setting Macro Security using VBA
- Access skipping parameter input box
- Append records from a set to another table.
- problems in speed
- text Box Exit event
- Begin writing from the right....
- ms access project 2003
- Form controls have vanished...researched to no avail!
- Access 2003 Listbox scrollbar -- won't appear
- Using IN operator with LIKE operator
- Dates: Just MM-YYYY?
- MsgBox,InputBox formatting
- Allow users without Access 97 ability to view data and search data in tables.
- Alpha-> Numeric conversion????
- Convert Access 2003 Report to Acrobat 7.0
- Normalization Question
- Problem closing form
- Email With attachment woes
- Non-programmer needs help with VB code to locate file on hard drive
- Error 3075
- Reports-Twist to Running Totals - How?
- Datasheet view questions
- Weird Report Problem - Access 2003
- How can I update forms and tables in a shared Access database?
- Median Query
- query works in querybuilder, not in VB
- show only last item per ID
- Printing reports from different trays without locking the db in design mode
- Trigger e-mail when new data entered in table
- Restrict a toggle button to a single click
- Can't convert to MDE after adding refresh links functions
- Update form formatting on FLY?
- rename control in the subform
- percetage calcultion from table
- Synchronising access and sql server
- Check it Out!
- Query to select just one product or all products
- Query
- Nz(variant[, valueifnull]) - Just thought of this 2 minutes ago, wondering if anyone else has ever considered. it...
- Just changed to Access 2003
- Data mapping with a DAO.Recordset?
- Unable to Delete a Record
- Age Calculation in the future
- A97: Set dbs = CurrentDb Set rst = dbs.OpenRecordset(MySQL) 2nd line yields error "Too few parms"
- Query in vba
- Invalid use of NULL
- lil help for incoming bithday
- trap hyperlink error
- cascading combo-boxes and data structure
- Membership & attendance db - table structure?
- Can I link to an mdb in a Web Folder?
- need help in this query
- Find the first date from other table
- Using the Office file selector common dialog exposed by Access
- Difficult Query ?!
- checking data in one table before updating another
- COM s'ware that isn't working for me
- checking data in one table before updating another
- Statistical add-in for Access
- Select Case vs. ElseIf
- A97 - always necessary to encapsulate ampersands in spaces?
- When is NOTHING better than nothing?
- need help
- TypeOf and Date Time Picker control
- Please, help I need expression
- To Larry Linson, please help
- I need expression, please ( MS Access )
- Please, help! MS Access
- cant get recordcount property to work
- RecordSource OnOpen
- Terminal Server Question - Passing Parameters
- DoCmd.RunSQL can execute code in VBA module?
- Master link to more than one child
- I have ODE - A97 flavor and a complete set of the tools that came with it
- Menu Bar
- Protect Back-End Tables in Desktop Db - How?
- Send report to Excel
- Taste beim öffnen eines Formulars abfragen
- Set ExpiredTime on KeyDown
- emulation of MS Access on Linux ?
- A97 dialing numbers via writing directly to the COM port
- Store MS Access Modules in Visual Studio?
- Unsatisfying syntax
- More Specific Access Performance Questions
- Exporting without carriage returns in memos
- Order by dlookup in query
- large recordset - error -2147217887 (80040e21)
- Loop for importing text files
- Form Help---Weekday
- OLAP Cubes
- Problem with ListCount
- Count of the selected items
- DAO 3035 error, update problem under Windows XP x64; "system resource exceeded"
- Simulate slow bandwidth WAN
- Call form's event from a library database: is it possible?
- Normal Distribution Table and Graph
- ADO Copy Table to new MDB Help!
- Version Compatibility?
- dynamically set a textbox control form...apostrophe gets in the way
- Can Access create folders?
- Backwards compatibility
- Prevent Duplicate records based on multiple fields
- Keyboard move after enter
- Permissions
- Permissions
- Runtime problem
- a2k - clash of beforeUpdate event and changing tabs on a subform
- TransferText and Runtime Error 3011 (solved)
- Help! Access 2000 modules disappeared but still there?!?!?!?!
- Exporting a report to Excel, some data is wrong
- Master database
- Disable mouse scroll in subform
- SetFocus to a form
- Checkboxes and Option Groups
- move a file (document) from an unbound object frame to a folder
- X but no move/close in Access form
- Clear a text box after event cancelled.
- Automatically create new record to related table on update
- Programming for all fields in a table
- Customizing form's Control Box
- Form Slow, Then Fast
- What techniques are key to Access performance with separate front-endand back-end Access implementation via a LAN?
- Hyperlink Field in ASP
- Query for List Box - WHERE Clause
- DataBase over WAN: ASP vs. Terminal Server Costs?
- Unwanted hilight of text
- what I am doing wrong in this query
- delete all related records from other tables too
- change value when other textbox's value changes
- Procedure Attributes
- Simulating rollover effects
- mouse scroller not working in Visual Basic window! my fault?
- Determine Windows XP Style or Windows Classic Style
- Connecting Access MDBs to SQL databases
- Working with Sliders and Ratios
- THANK YOU
- Help with combo box
- Launching MS/Word from VBA
- Function to calculate number of days in a month
- form closing
- how to set focus
- on delete add qtyOnHand again in product table
- groupby in query and then pass to expression as recordset..IS THIS POSSIBLE?
- Correct datetime syntax for MSSQL?
- Toolbox is ignoring me
- How to Prevent Table Updates in a Form
- Importing multiple Excel workbooks from Access
- Create a recordset based on another recordset
- MS Access Report to PDF
- Docmd.openreport
- Merging Records
- Sort of a mail merge question
- Linking to record in an outlook message
- apiSHFileOperation preventing Folder deletion
- subform recordsearch don't work
- Using OutputTo command with NoData Report event
- Opening MSWord
- Exporting memo columns to separate files
- Data being lost?
- Running windows functions without using OCX ?
- Eric Rucker hints that Sharepoint is driving Access/Jet features?
- convert rows to columns
- automate from-fiels in outlook
- Importing nested XML structures into Access 2000
- Backup solution created using Access dB
- Using a field from a previos record for a calc
- Using a field from a previos record for a calc
- Bind a Subform to a Query
- Order of Update Query?
- Help with SQL
- TreeView
- crosstab quey fails in case of table.field syntax is used in subquery
- Showing decimals in Access pivot table
- Updating textbox control on form from code won't reflect new value
- Problem getting new record from subform to appear on subreport
- Combo and text box
- Help me in this report
- Jet and MySQL
- Access Date Hell
- HIDING AN IMAGE BASED ON COMBO BOX VALUE
- User Deleted Secured.mdw - now what do I do?
- Get Query Parameters from Report's RecordSource?
- Compact on Close + mda or mde reference = CRASH
- Problems Querying Max Values From 2 Tables
- Time to go from Access 97 to Access 2003
- More Function Joy
- Help with understanding order of For Each Control
- Access 2002 corruption
- I want a msgbox to display BIG and LITTLE instead of YES and NO
- a2k - properties dialog not appearing anymore, for anything!
- Multiple Functions
- I have a 2-field table I want to trim strings off of one of the fields...
- Transfertext with ADO Recordset created in Runtime
- How To Use The Len Function To Count A Space
- MS Access ODBC -- Connect failed!!
- Help - need Cross Tab to Sum AND Count
- ahtCommonFileOpenSave Shortcut extensions lnk url
- Will this SQL work to find records with hard returns in one of the text fields?
- waring message
- Does Access have a mind of its own?
- Surveying out to the field
- Relationship between "Me!" and "The control or subform control is too large for this location"
- Starting a form maximized
- Sort a month
- Access 2002 Packaging Problem
- How to create a multiple column unique constraint
- Change Linked Table links on run time?
- Check for Multiple Instance not working in Access 2003
- Check for Multiple Instance not working in Access 2003
- Composite Primary Key
- Access 2002 - Datei umbenennen
- SQL Update
- "Order by" in my own order
- Text in toolbar text field not committed before clicking toolbar command button
- Duplicate Name Alert
- Deploying Data Access Pages (DAPs) via RDS in 3-tier environment
- I'm confused about encryption
- Fast opening form
- Can I prevent the loss of the values assigned to global variables after an untrapped run-time error?
- Report question
- I don't know how Resume Next is configured to work
- Freeze the MS Access window size
- I don't understand the answer! Doh!
- Call printer by name via code
- can an update query do different values
- MS Access, Oracle 9i, security, and pass-thru update queries
- Wouldnit be nice if the new version of Access.....
- How to stop timeout message box appearing
- Browse your gothic lovers' photos and chat with them online!
- Browse your gothic lovers' photos and chat with them online!
- email selected contacts from access
- extremely long directory paths
- columns header and joins
- The wisdom of a access-MVP please !
- VB Scripts in Access Tables
- Where can I get a VBA code diagramer!
- Not so Much a Question!!
- Testing against a blank field
- Any good Form Resizing code?
- how to format xml/xls web report for specific paper size and orientation?"
- Custom Macros
- Web based Access Applications
- here
- visual basic combo boxes??
- IsNull runTime: Invalid Use of Null
- Can I export the ReportML with a report to xml doc on web site?
- form/subform and calculated control
- Data Access Pages DAPs
- Find - Search - Match: Any Part of Field
- adding mailto automatically after email address inputed
- SQL group by with delimiter
- Trying to create an email with form data.
- Query Help for Inventory Tracking
- value on the base of 2 textboxes
- Syntax
- Exported date format is changed by Excel
- Import New Data File - Archive Now Old Data File
- Hide Access Close buton but show Min/Max
- Hide Access Close buton but show Min/Max
- Set all objects in a form to invisible.
- Creating a query using a variable field name
- HTML and XML
- Turn Error Handler back on.
- General Approach to Updating Via Forms
- Help with Cross tab query
- Access and Office 12 ?
- TS experts - help me out here
- HELP! Having trouble with Workspace
- link tables and remote connections to access
- Can I perform a DCount of records returned by SQL statement (not a saved query)
- Sample DB
- Can someone tell me how data entry to a specific site might be accomplished
- Update query with select statement
- Make Table Un-editable
- Find the differences
- Simple Query
- databases.ms-access ....soft download
- fnd matches
- A97 columnar (and tabular) form wizard are not placing all fields on the new form
- Creating UniquePrimary key in table
- Form opening/switching bug
- A97 runtime error 29013?
- Building Access Tables from SQL server
- Force Data Entry In Combobox First
- About rept footer
- How to display multiply records in query?
- Accidently opening 2 instances of A97 and opening the same database...
- Back End Update
- Access Report Group Header Question
- Problem with IIf statement in the OR clause
- Can not use find and replace right now
- special duplicate query
- VB query from a DAP button
- Concatenating strings
- Combo boxes that delete
- Publish Access Data / Forms - Intranet
- Data disappearing - without apparent cause
- #NAME? displaying in linked tables (Access 2000) after DB2 migration.
- Seeking A97 code snippet to programatically delete table field decriptions
- DAO Rs Update with SQL ODBC linked table
- shortcut to open mdb read-only
- append combobox values
- Restricting A97 form to editing only?
- Ever experienced loss of ability to 'grab' the slide control at the bottom of your A97 database window?
- A97 trying to set shortcutmenu=false for all forms
- Select lowest number from multiple rows in SQL
- Booting users out of Access?
- Standard value for a field?
- compare 2 fields, return w/ nonmatching values
- Access awake after 7 years?
- Help Needed With How To Stop User Resizing Form
- MS Access 2000 Password Recoverer
- Comboboxes and record deletion
- How To: Use a field value from a table to call a function
- Execute function at db startup - how?
- Reading XML file by VBA code and saving the tag-value combination in a table
- transfertext acimportdelim/acexportdelim problem with field names
- Execute a function at database startup ... how?
- Saving Text Editor Color choices
- dynamic param for WHERE ...IN ( @param )
- compare two strings - - - for the guru's
- Preserving wordwrap in MS Word (rtf) exports
- Double Quotes In Data?
- Exporting with text qualifiers - number data
- joining tables
- 2003 not saving VBA coding
- Adding a character to a Combo Box value
- How to fix subreport?
- Going through the field list !
- Check if Microsoft Outlook is installed as default mail cleint
- help - can't create file
- Access Still Sees QueryDef Deleted During a Session?
- Reference a Text Box from another Form displayed on a Tab Control
- displaying the right side of a text field
- Add Fields to a Split Database Table
- DoCmd.TransferText to import text from a large text file
- Record locking on Terminal Services
- Access2K vs 2003
- Increment a table field value by 1 - SQL fails to do so
- IsUserAnAdmin not working
- exporting results of a query to a new table
- How many fields in a table
- removing rows that meet certain aggregate criteria
- Trying to paste sub procedure into A97 global module - code lines show up red
- Please help with this code
- MAPI / A97 question...
- References- How to get rid of them!
- Format Data Access Page
- Clear Button to Ignore Alerts
- Need HELP / Increment ID (number) for each unique text string
- Exporting Access -> Excel
- sending email with multiple records
- Antsoft Best domain software
- ListBox Not Showing Rows?
- Splitting an Access db - the next step
- import doubt?
- merge two tables problem
- Toggle button on the toolbar
- Gantt Chart
- Truncating a Field
- Getting max length
- Date Criteria Problem
- inserting email address into a form
- How to keep a selected item in a list highlighted
- Paste from clipboard to report
- Mail Merge and save individual documents
- How to add 2 text boxes if one one them have no value
- Form in chart view
- Security: some default system.mdw files can get into the app without prompt
- Cannot open anymore databases
- Combo box
- How can I input the same data many times in a form
- Excel stays in RAM after DoCmd.TransferSpreadsheet
- Linked Listboxes
- Regarding saving database objects as text files and importing them...
- MS Access-Show Occurence Count
- Relationship Link
- Simple math
- problem with setbar function
- Suppress line feed in detail section of report
- Database bloat - general discussion...
- Qry Deleted after running macro.
- User-Sequencable List Control?
- Loading Various Image Types into Image Controls
- How many modules is too many?
- Mundane A97 Workgroup Administrator question
- Display a series of records with mixed forms
- Update of field list PivotTable or PivotChart (Data Access Pages)
- Tarpping changes to a field
- Export to Excel and open the worksheet
- Flicker
- How to prevent to enter duplicate record?
- Unbound text box, text>255, MS Access/PostgreSQL
- update from using ms access query
- #error in form footer sum
- Used SQL Upsizing Wizard, Application No Longer Runs
- Or in the Of clause
- Need help with connection string in OpenDatabase
- Jet 4 Replication Service Pack
- combo / form help please
- linking tables to different databases
- Help with schema.ini file
- Need to change LASTNAME, FIRSTNAME MI to FirstName M. LastName
- Again...problems with date settings in IsDate function
- How to establish connection to TCP port 13 on a remote server from within VBA?
- Best practices for canceling out of a report?
- A97: I want a simple text capture on a website (IE, Edit, Select All, CTRL-C)
- Oracle Automated Login via MS Access
- Walk Multi Select List Box A2003
- saving database to winzip file
- Help~
- Refreshing Page
- How can i make a fiels reset on every date change,and auto increasing?
- Scheduling beer trucks into timeslots with sufficient performance
- New record from a join query
- How can i make a fiels reset on every date change,and auto increasing?
- Data Access Page?
- How best to set current system date/time in A97?
- source of CURRENT event for subform?
- sadfdsaf
- adsfsadfsadf
- function to convert word document into HMTL
- How can I call a form's event using a string
- Creating custom Input Masks...
- How to create a access runtime?
- Unduplicated count of a table
- Cash register Access database
- forum
- PT Tables
- csv file line length limit
- Ask before saving record
- Appending from 2 multiselect listboxes
- Using a button to populate another form's auto# field.
- Regarding input masks
- Record Selector Macros
- Form Should open Maximize
- Access Validation Rule Question. Help Greatly Appreciated.
- Access and word mail merge
- txt to mdb
- UI Metaphors for complex criteria selection
- Open form as Data Entry with Customer Info
- Linking Relationship tables problem
- Damaged File/Print... menu option
- How can I input a name into a reprort
- How to have field values transported to fields in another form?
- Access using .Net Datagrid
- Encrypted password field in Access database
- Encrypted password field in Access database
- Help!
- Access Run Time Error 6 Overflow
- IIF acting funny
- ODEUNST.EXE???
- Is it difficult for a hidden form to check for user activity every 15-seconds or so?
- A-97 Alzheimer moment... what were the basic components of securing an app?
- Can not open database file
- Update Query with User-defined function?
- Query base on a changing table
- Sendin emails through Microsoft Access
- Copying a value from subform to main form
- Reading and Writing Folder Properties
- Output To vs. Transfer Text Options
- Bang vs. Dot - final answer
- Question on Error Message
- Access to ASP
- Will Stephan Lebans answer questions about his Calendar 'control'?
- How to copy a value from one form to another by button?
- Open a different Word doc for each record?
- How to join 2 different database files?
- Quick, simple question with Access Database Form
- Use the input to an Access 2003 form as parameters to a SQL Server stored procedure
- running vba code in a loop
- Time Picker Control
- A2K networked DB "already opened exclusively by another user"
- Access12
- Strange Time-Formating Problem
- access and sql server via odbc
- A2K Subreport disappears in Access XP
- OT NNTP in VB
- How to Remove <BR> in Fields
- RAM USAGE
- Strange Email Problem
- What does this query do?
- distinct records
- Looping A Specified Number Of Times
- Subform with Query
- visible flag: datasheet versus form view
- sorting a crosstab query
- Changing to owners permissions using VB
- Subquery Sum by Date Range
- AUTOMATE EMAIL ADDRESS IN ACCESS?
- adding empty rows to the end of a report
- Making a button appear pressed in?
- reference subroutine from another form
- Modify Access MDB Application
- double prompt for value in report
- Over the years, I've used query wizard to list duplicate entries...
- Macro security level
- Macro Data Entry in a multi-row Subform
- linking subform master/child fields problem
- Problem linking Child/Master fields correctly
- Run-time error 2465
- Read Only
- Use other value from table
- Filtering report and subreport from form