View Full Version : answers
- Is it possible to "remember" log in credentials? (Many MDB's sharing one MDW)
- Query takes ages to run...
- Table data issues
- docmd.openform not working
- deleting duplicate records with only one field different
- Select Query
- E-mailing a form using Lotus Notes
- Application-defined or object-defined error in Access 2000
- Access 2003 Conversion Errors
- Adding Time
- Setting an object to existing form generates 'can't find form' error
- Recording locations of an object.
- invoices from 2002 & not from 2004
- !!FAQ! for Date: 20040615 - New Users Look Here! [Last Updated February 05, 2004]
- Arjen Jongeling, een oude bekende
- Check Box Problem with Make Table Query
- Colored Background in Command Buttons. Is it Possible?
- Nur ausgewähle Spalten/Felder aus Formular drucken?
- Table Value Setting..conditiontal
- docmd.runsql
- What is the future direction of Access?
- Minimizing forms in a dll
- Change Screen Resolution using VB
- There was an error executing the command
- List Box on Form
- Question about Field names
- backup/recovery: compression command line multispan utility
- Open an exclusively opened mdb, any way?
- Converting Back to Access 97
- Having trouble importing an XML file
- HelpFile F1
- Lookup textbox within form ( Parameter Value error )
- Count by date/id across tables??
- Excel functionnality in Acces
- FileMaker 5.5
- Tony Toews Performance FAQ
- can this be done
- you must specify the name the macro's macro group was last saved under
- Access && JET
- using location in report parameters
- Query-Dates and duplication
- Rounding Up problems
- !!FAQ! for Date: 20040614 - New Users Look Here! [Last Updated February 05, 2004]
- Network error, Access 2003
- Need help with extracting table data into database from web
- Subquery
- Afterupdate & execute problem
- database over internet?
- Help with reports
- Trciky DB tables question
- Constant variable: How? Where? Help!
- A problem occured while Microsoft Access was Communicating with the OLE or Activex Control
- Input mask
- updating people's FE by sending them the recently modified objects
- expression built sting / Parsing text field
- sub-report loses its sort
- Selecting sub-reports by date criteria
- Access lookup's
- Better error messages for Input Masks
- A "Gradient" for Form Sections
- Updating Queries, Forms, Macros, Modules
- Table design question
- Autonumber in query
- !!FAQ! for Date: 20040613 - New Users Look Here! [Last Updated February 05, 2004]
- inputbox and dlookup issues
- hacking to the core of access
- Database Copyright
- Loading from web
- ComboBox RowSourceType containing UDF => call back oddities
- Multiple instances of the same database...
- Assistance with Posting Inventory Average Weighted Cost
- concatenating two fields - problem with leading zeros
- databases that grow like cabbage
- SQL Statement Help
- Call Function On Main Form to Sub Form
- empty screen opening Access 2000 database
- Call Subform Function From Main Form
- help!cannot lock the subform
- Multiple instances of the same database...
- Access 2000 forms
- !!FAQ! for Date: 20040612 - New Users Look Here! [Last Updated February 05, 2004]
- Joins !!
- Query Question
- Autonumbering
- totals
- Delete Query - Criterion in unrelated table
- Example of a University database
- Access 2000 ----> Access 97
- Service accesing a remote access database
- auto update
- auto update
- ADO Cursor performance
- How to create MDB file according to the version of the Access installed
- Opinions on Software called ViewPoint
- What's wrong with this simple code?
- Problem deleteing linked tables
- !!FAQ! for Date: 20040611 - New Users Look Here! [Last Updated February 05, 2004]
- JET/DAO tables bound to forms in Access 2000 ADP: Anybody doing it?
- copying controls from a form to a tab control
- Bizarre problem referencing form by name
- Which choice did he make?
- How to make Command Buttons 'pretty'???
- COM Add-ins
- Unbound listbox in continuous subform
- Date Problem
- Exporting Colours from Access to Excel
- Just how good are you really?
- sum number of rows in different queries?
- Connecting Access Db on Solaris
- Access & Security
- Copy one column to another???
- Can I use wildcards in TransferText import?
- Access Data to Outlook
- Sending One Field To The Printer
- displaying the data of three tables in one form
- Query set within a specific amount of days
- VBA.Trim() and long varchar columns
- !!FAQ! for Date: 20040610 - New Users Look Here! [Last Updated February 05, 2004]
- Cost Center Time Reporting Application
- Event procedure using iif for line breaks.
- Form controls
- Question about Primary Key
- Re. Embed or save ms word into OLE field
- where I made mistake on compact the current database?
- Please Help
- Data Sheet Row Colors?
- Compare 2 tables and only show the changes in result sheet
- Active Directory - Access XP
- Open source alternative for MsAccess?
- Query to list near neighbours
- how to flatten sql query?
- Deleting Workgroups
- How to get directory for CurrentDB
- What's the 'best' was to print a complex calculated field on a report?
- Limitations in exporting to Excel?
- Moving stored procedures
- Access 2k database keeps changing security permissions
- How to set Enabled property - wont allow if control has focus
- Strange annoying problem - long chunk of code
- Strange annoying problem - long chunk of code
- Form freezes.
- Add record to Subform when not on Mainform
- ACCESS 2000 Question
- Me Statment Help
- Waiting for MVP Happy Dust?
- Length(field_name) in Access?
- A way to use crosstab query fielld names as column headings?
- embed or save ms word file into ole field table
- Data Access in multiple history tables across multiple mdb's
- break points in Load_Form event in Access 2000
- Missing Records
- !!FAQ! for Date: 20040609 - New Users Look Here! [Last Updated February 05, 2004]
- MDE Creation on Win98 & WinXP
- access 97: ftp code problems
- Locked data base? Please help
- change load order of form/subform
- MSDE Error on attempting to create new Access 2000 project
- Mini Labels
- Access Project - Primary Key / Foreign Key question
- Pages In Access
- cancel as integer and the like: why and how
- Continous Form constantly moving when loading
- Your small effort make big change
- Unbound Data Entry Problems
- Enabling Tab Stop Makes Form Control Disappear
- Close Button Problem
- Database Form Question
- variables in use
- should i index linked fields
- spellcheck on exit?
- Report Header in Mailing Labels...
- how do you programmatically create a relationship WITHOUT creating an index?
- Upsizing to SQL 2000
- Quirky Record
- could not update; currently locked by another session on this machine
- Want updates in .mdb file to update other .mdb file too
- Using lookups or rates problems
- conditional formating
- Access97 on 1 GB+ System
- Strange Characters in Memo Boxes
- I want to change the spezification for transferText Delim
- Constant ODBC Call Fails
- Convert embedded Word docs to linked
- Need to send an email in code
- Calling a text box in Code Editor
- Could not find installable ISAM
- Computer Books, Inc MS Access Books - up to 80% off
- First Field in Multi-field PK of Linked Tables not displaying in Unmatched Query Wiz
- !!FAQ! for Date: 20040608 - New Users Look Here! [Last Updated February 05, 2004]
- Problem Setting A Field To Null
- Uosing different rates for employees in various stages
- Looking up values
- Can't read MS Access databse
- View only selected fields
- Report from a single record
- Replacing Characters in the Field
- Compare tables
- I need to trick a requirement of an exclusive access in Access 2000
- Subform
- Stopping before EOF
- Preventing running automacro from VBA
- A2K - prevent "/" being input
- Importing Excel to Access
- List Box
- How to send a picture with outlook via access
- DoCmd.OpenReport RPT_TEST, A_PREVIEW, QueryAsFilter fails in A97
- Help! cannot delete records in the table "PRODUCTS"
- Can Access do this..?
- Cancel Change In Option Group
- auto update
- A2K - note field in report not fully expanding
- Error when trying to download using ftp module
- default values
- Adding a new field to an existing form
- left join driving me crazy
- Access + Postgres SQL
- Code Help PLease
- SQL server classes in St. Louis Area
- book on stored procedures for SQL Server 2000
- Unable to open / design saved form in Access 2000
- Adding a table column using VBA/ADO
- Database Held Hostage!
- Back End/Front End Puzzle
- How do I cause a "record find" to open before a form?
- !!FAQ! for Date: 20040607 - New Users Look Here! [Last Updated February 05, 2004]
- Form_BeforeUpdate procedure
- O.T. First time ever for me to have an eCommerce site...
- use a word file as my form for my database
- Access 2000 adds brackets [] to queries
- Running At? (OT) - DAPs and ASP
- Subform
- Error 2001 You canceled the previous operation
- Creat an MDE file?
- HELP, HELP, HELP........plz: Finding and displaying records
- Cancel Change In Option Group
- Unable to return data for some views in Oracle Applications using Access and ODBC
- alternatives to #if ... #else ..... #end if statement
- Mid function perhaps??
- how can I speed up this function with a dcount in it?
- Make Table Query - unique records from other two tables
- More Queries...
- Remove identical records from the same table
- Data Across The Network
- Network Down
- what is wrong with the goto command?
- what is the difference between attributes and properties in things like fields?
- I have a global var named WhichFormOpenedMe. Its value is "frmMainMenu". What syntax do I use with the variable to perform this: [Forms]![frmMainMenu].SetFocus
- when to use indexes
- When is it a look up table and when is it an real entity?
- Loop doesn't find all occurences of search, need help with recordset
- Deleting Records
- Help with Totals in Report
- Automatic update of linked ODBC tables
- !!FAQ! for Date: 20040606 - New Users Look Here! [Last Updated February 05, 2004]
- Developer Extensions Question
- Help - Log Transaction
- 2 databases & synchronization....
- Multiple Users
- Using wild card in Iif statement
- Linux
- Two Databases
- Any way to check current On Error status
- Disable Outputting message popup
- Error 3220 - Function Is Not Available In Expression In Table Level Validation Expression
- Expression builder and Loaded Forms folder
- !!FAQ! for Date: 20040605 - New Users Look Here! [Last Updated February 05, 2004]
- Listbox with checkbox displayed
- Copy/Paste Extra
- Mini Inkjet Labels
- Access2003/OL20003 BCM
- How to make a search engine in a form
- RunSQL vs Execute rehashed
- Access won't close after using DLL
- increasing and changing the tick box
- testing for Key Violation
- determining a report's page orientation with VBA
- Wierd Access behavior while deleting a record
- Aligning Form/Report Controls in Access 2003
- Emails With access 97 BUT NOT OUTLOOK
- Using Listbox contents as query parameter
- GetString method
- Conditional formatting with subforms
- 99% CPU Usage...but for real this time...
- E-Mailing A word attachment using Access
- Access Developer's Edition
- Query and pulling out certain parts of a field
- Open Reports & Fit
- !!FAQ! for Date: 20040604 - New Users Look Here! [Last Updated February 05, 2004]
- Delete button is not working
- parallel reports after random selection
- Problem in a report?
- AC97 - Replication - File Sharing Lock Count Exceeded
- Access + MySQL = ODBC-call failed... sometime
- Combining multiple records into one
- Report printing
- Access and SQL server
- Easy q: Moving data in 1 field to data in another field (all records at once)
- No Current Record message
- how do you get a file off of a web server?
- Split information in fields
- split information in fields
- modifying lay-out of word-document with automation
- Dire need of Help!
- Recordset in subform based on field in parent form
- happy Sonday (spider)
- MS graph changing min and max axis values
- Access 2000: Is this corruption or not?
- Excel to Access - code issue HELP!!
- Form records to Report
- Access 97 - is this possible?
- how to put text under a key
- Over-riding autonum
- Ms Access Reports Letters and Envelopes
- Automatically join MDW
- Check Status of SetWarnings
- TransferText truncates Double datatype to 2 decimal places
- !!FAQ! for Date: 20040603 - New Users Look Here! [Last Updated February 05, 2004]
- DateTime Access bug?
- Query slow for one user, not others
- Selected Property MS ACCESS 2000
- How to avoid clip board message when duplicating record
- Calendars
- Error: 429 ActiveX component can't create object with Outlook 2003 automation
- Query Quandry
- Open Form from Previous Navigated Form
- This is odd!
- Requerying a list box - but not seeing the updates applied on requery!
- How to test if cursor is in text box?
- using form control values in queries
- Add 1 to Serial Number
- Subselect from 2 tables from 2 different databases
- Procedure exits prematurely
- Is Access Dead?
- Unbound Textbox Character limit
- Docmd.SendObject, Lotus Notes and Exchange
- How do I parse XML files?
- Help! Another report criteria stumper. "The field is too small to accept the amount of data..."
- Help! Table locking issue in report with no sub report etc.
- Help! I have a table locking issue in report with no sub reports
- OLE File Associations
- !!FAQ! for Date: 20040602 - New Users Look Here! [Last Updated February 05, 2004]
- almost the same name
- DCOUNT and DateRange Parameter
- syntax help for the gotorecord Method
- syntax help for the gotorecord Method
- Time BETWEEN function
- Behavior Problems with MySQL
- emailing from access
- Report to List All Objects Modifieds After Spec Date/time
- DoEvents?
- Sending Mail
- 100% CPU Usage + "This action will reset...."
- Data Access Page - an introduction
- Use server log on name
- Where do companies like Yahoo get their mapping information from?
- Exporting to a text file
- Front end comparison
- Format problem on entry
- My Access applications are getting messy.
- String Intersection
- Booting people out of a front end
- Disconnected ADO recordsets lose their data
- Mics: String matching, Zip code - alternative city names
- Records *not* in a set
- Control visiblilty of a text box on a Tab Control
- Multiple Users
- Help! Packed app can not run on other computers
- Migrate Raima embedded database (7) to Access
- Need a combination - top 3, and group by...
- How do I detect that there has been no activity on a form
- string with quotes
- Report Problem
- access-vb problems...
- Data Access Pages From Forms
- !!FAQ! for Date: 20040601 - New Users Look Here! [Last Updated February 05, 2004]
- Send Object with No Col Headings
- delete a record in a subform?
- Listboxes and long items
- hi
- Always on Top MakeTopMost
- Conversion from Access 97 to Access 2000
- Changing a text box to a combobox on an open form.
- Query and Table Problem
- system call
- MSFlexGrid and data from spreadsheet
- creating an HTML library of objects
- datediff function
- Tab Forms with Multiple Rows
- Off - Topic... need help recovering inadvertently deleted mdb file off Windows XP machine
- datediff question
- Compatibility issues
- Query current record
- Help with sharing a database! Error 2501
- Change security message
- !!FAQ! for Date: 20040531 - New Users Look Here! [Last Updated February 05, 2004]
- Converting backend to SQL
- Need script to populate Northwind.mdb
- Function name stored in a variable
- SQL Problem
- timing response times in milliseconds
- date/time problem
- open a subform
- What are my choices?
- Still have Type Mismatch Problem
- How to do this?
- Race Time Part II
- Count problem
- !!FAQ! for Date: 20040530 - New Users Look Here! [Last Updated February 05, 2004]
- Time difference
- criteria in query part of field text only
- combobox in subforms
- How to use Enter key as command button?
- converting string to number without rounding decimals
- SendObject as snapshot problem
- Retrieve officepath while runnening access
- combobox
- Access Forms
- importing dos-hebrew files into access
- how to make the top row of combo box = 1st entry
- database field on form never sending "on change" event
- Default library files for a project
- CALCS
- Move files based on file names in table
- Access Runtime and Security
- Access 2003
- !!FAQ! for Date: 20040529 - New Users Look Here! [Last Updated February 05, 2004]
- Can this be done?
- Self Destruct Code
- Student Coursework - Grading System
- OLE Linked, Unlinked, Image at Runtime
- Remove Access scroll bars
- Best way to import a spreadsheet with "junk" in numeric fields?
- Help
- happy Sonday (spider)
- How many recordset can be opened simultaneously for a MS-Access 2000 Database
- Temp table explosion
- Is there an ftp client out there for access 2002?
- Mainform/Subform Refresh/Requery Quirk
- comand buttons not sorting after filtering form
- Is there a way to "freeze" a column in a multi-column Listbox?
- Problem with Type mismatch
- newby help needed
- Programmatic Built-in Commands
- Insert into error with java and MS Access
- Combo Box To Search Subform
- Events Assistance
- Why does compact and repair only compact the front end?
- Query Calculation Based on Values in Another Table
- Cannot add Attachments
- !!FAQ! for Date: 20040528 - New Users Look Here! [Last Updated February 05, 2004]
- MS Access Security/Workgroup problem
- Reset Autonumber
- problem with opening my access database
- Getting column names of a table in C# using OleDB
- Email Log, starting point
- Subtract certian number of weeks from a date field?
- User Permission
- Binding Combo or Listbox to txt or dat file
- help! who knows why "error while registering C:\WINDOWS\SYSTEM\MSADO21.TLB"
- 429 – ActiveX can't create object
- Joins problem
- ldb file is visible after databases are close
- max fields
- looping problem
- Open Access Options without displaying database window
- Help needed transfering query -> CSV
- Outer Join Dilema
- if anyone knows..how do you move info from a listbox? It just seems to select it and do nothing.
- Link to data on CD
- Printing a Form
- What is OEM?
- AccessXP developer upgrade
- counting assemblies per year
- FoxPro drivers and Linking to access question
- A Better Combo Box??
- Shell function in VBA
- Access 2003 - Required Fields, Case Select, Return focus
- Controltip text in continuous form
- DB table design Q
- Using CDO Mail with 2K or 2k3
- 429 – ActiveX can't create object
- !!FAQ! for Date: 20040527 - New Users Look Here! [Last Updated February 05, 2004]
- cannot open access database from a hyperlink using Internet Explorer
- Need to crawl website
- Programatically Delete A Subroutine
- using access 2K on a network
- Export to Word or Excel
- Redundancy
- Area Codes, this should work, right?
- Excel data to a one - to - many relationship
- Ms Access
- Access front end, sql 7 backend, dsn on novell server
- Calling Forms
- Diary of a class module
- Uregent... problem in SQL query
- Urget.. problem in SQL Query
- Right outer join help
- Please can someone help me get a list of absent employees ??
- Data Cleaning
- Disable macros?
- MS ACCESS - JOIN Query
- query filter using many fields
- date in reports
- Highlighting Text In Textbox
- Help wanted, distributing Access 2000
- moved from the wrong location
- TransferText
- TransferText Maintains Old Format
- Shell (sharing window focus on Access and non-Access application like telnet)
- ACCESS2k: requery second combo box to show a new value list
- Possible to use a crosstab query in a report (A97)?
- Import Excel SS into Access
- Password Verification Form...
- Why no access for MAC when there is Excel et al ?
- !!FAQ! for Date: 20040526 - New Users Look Here! [Last Updated February 05, 2004]
- Populating Access fields with information from an Excel spreadsheet
- Capturing alot of check off data
- Access and Citrix
- Return All Records
- Updating table from data in two other tables via a query
- Access: when subform's query has no data. Creates an error message in main form
- Access 2003 / Windows xp Pro amd images
- Help! Access automatically saves any changed data on tables
- Backend Database Performance
- the strangest problem
- Information on Acess and ODBC
- Table design
- Vesrion Control without Developer Edition?
- TOP Records in SQL Statement
- Code for Start Filter Process
- Probably a really stupid question regarding indexing
- Computed Query Field
- Cry For Help! - Filling In Forms Automatically From Tables
- Access 97 bound form edits the previous record, not the one displayed.
- Listbox prob: Selecting the selected row
- Problem with Transfer Test
- MSDN 7 Contain Access Developer
- Two tables and a query
- full outer join on two tables
- Switchboard-Splitting DB Problem
- Union Query returns hieroplyphics?????HELP!
- Filtering Forms
- How do I stop a form's open event in if there's an error?
- Running Access over Citrix
- Puzzling #Name?
- Running macro as a Scheduled Task
- !!FAQ! for Date: 20040525 - New Users Look Here! [Last Updated February 05, 2004]
- division by zero
- Password with TransferDatabase
- Strange Access behavior with DAO3.6 / DAO3.51