View Full Version : answers
- Displaying an amount based on a Constant Exchange Rate
- String That Includes Quotes
- keypress for vbkeyspace
- Problem Creating A File Then Trying To Zip It
- linked tables
- duplicates
- Default values on a form
- Odd Error Message Follow-up - Attn. Alan Webb, with thanks
- Need calulations to work with # of fields in a Report
- Access incorrectly counts months between years
- combining subreports based on conditions
- DSN-less ODBC connection doesn't remember PW??
- Between Date criteria problem
- Access 2000 - Table Not Found
- !!FAQ! for Date: 20040227 - New Users Look Here! [Last Updated February 05, 2004]
- parameter query data format problem
- make one field in a query with two diffrent formats
- subform row data requery
- Security--User Account PIDs
- Set Combo default by User
- Type Mismatch
- Count Bad Passwords
- Capturing user-id in Access2000
- Separating data by date
- Dropdown list passing hidden values ?
- Change sender account VBA to objMailItem
- VBE window switches between (Running) and (Code) when saving a form module
- How to deal with problematic programmer on project
- view with parameters as recordsource
- programatically linking tables
- How do I manipulate MSGraph-objects?
- test
- unload event not working
- remove naigation arrows
- MDEs and Run-Time Executables
- comparing two tables
- problem with Unicode, HTML, and MS Access
- required + validation rule
- Strange Error Message Follow-up
- Calendar Report
- How do you generate a list of foms, reports and modules available in a database
- Building a Where Clause Using PC/Zip as Criteria Item
- Can not repair
- Filtering recordsource in VBA
- File/Get Data won't attach to a SQL table.
- Group footer on each page using subreports
- Query can't see the last field in an attached table!
- Control Source on a Text Box
- Problem updating record from subform if it contains only prefilled values
- !!FAQ! for Date: 20040226 - New Users Look Here! [Last Updated February 05, 2004]
- DatePicker Control Problem
- How to check related foreign keys
- Supressing #Error in Access reports ?
- Null Values as Option in List Box
- go to the next blank record in the table
- How to vlookup in Access
- REQ: Question on customizing Microsoft Access Toolbars
- Export Excel; change a range
- FoxPro Programmer - CASE conversion
- making sure that a selection has been made in a combobox
- File dialog
- A2K help- Why does compact/repair corrupt front end on one server but not another?
- Why doen not this code work on filtering a form?!
- Help for write VBA code using "Command" function and "GoToRecord" action
- List box and dissapearing data
- Group Headers and Pager Headers
- Customizing individual items in a list box - is it possible?
- Yahoo API vs Google API with SOAP in Access - anyone know this stuff?
- In a form's event: Execute SQL 450 times OR excute 1 SQL?
- Allow spaces at the end of fields
- SQL query help: Need to get TOP in group where 1st is X times > than 2nd..
- Crosstab Query Criteria
- Create New Records in Table
- #Error Issue
- sub query on reports??
- How to bypass msgbox for PK violations on TransferText import?
- Help with date function
- Word won't hold ODBC data source
- User and Group Permissions - Object list Sort Order
- SQL in VBA + iterating through recordset
- Combo Box at Report Open Time
- access 97 forms and tables
- Automation, disabling keystrokes/mouse
- How to specify this in the query criteria?
- 9 digit postal codes on mailing labels
- !!FAQ! for Date: 20040225 - New Users Look Here! [Last Updated February 05, 2004]
- Compacting
- simple stock control
- Read only database problem
- Query runs quickly as Select, slowly as Append?
- Import text to a variable
- Disposing of Old data
- Assistance with Query to Consolidate Records
- Request suggestions for streamlining distribution process
- SQL Help
- Handling Hex Values
- inputbox to textbox on bound form
- ACCESS accessibility from a C++ process launched from an ACCESS form
- trouble with access / sage
- Copy result of query to new table
- Problems Opening Access 2003 mde Files In Access 2002
- Add fill characters to ConvertCurrencyToEnglish code
- Multi Select List Box options to text boxes
- Copy all tables from one database to another
- Images in export to HTML, help!
- Dynamic Pricing Application
- Split a list in two
- Table Relationshp Question
- Select qry works - delete qry fails
- linking front end to back end
- Flexible Reports
- create new table - no duplicates
- referencing forms / modules without opening them
- User Level
- Thanks to three people who responded to a post...
- A strange error message...
- delete a table in an external database
- How can I go to specified entry from a Windows shell command ?
- Updatable Queries using Access 2003
- Word form can link to Access db, as a data entry form?
- Keeping elements of a report together.
- Query criteria based on 2 different form controls
- Keep together in reports
- Q: Chart in form on demand only
- Borrar una linea en un TXT
- Select only item in dropdown box
- Opening a form with 'openargs'
- !!FAQ! for Date: 20040224 - New Users Look Here! [Last Updated February 05, 2004]
- creating check boxes at run time?
- Query to delete duplicate records in staging table
- Attaching SQL Tables - Unique Key
- Reading my Access database before tomorrow
- Compacting a database
- Parameters in a SELECT DISTINCT doesnt work
- FYI - Sql for splitting a delimited concatenated string into separate strings/rows.
- Connect to Access database that resides on web server via Visual Basic?!
- Rum time error - Command rejected
- Need Insight to Delete Query Method
- Access Object common properties.
- Can Grow/Can Shrink
- Dynamic number of fields in an Access 2000 Report
- Creating a new report in exisiting Access database
- Need Assistance to Resolve Query Syntax Error
- Database locks
- dubliacted record or clon record
- Report field limitations
- TreeView controls and the like
- LEFT JOIN with a subquery (?)
- Access 2K export to Excel - too much data
- Grouping by Dates in a Report
- Schema/User Name Oracle/Access linked tables
- Navigating Records
- Are there any forms open?
- Solution for cmd.CreateParameter and Access memo field types
- Converting from Access97 to Access 2003
- An intranet interface for Access
- Access Memo type and ADO createparameter
- repost: Access 2003 runtime
- delete query frustration
- Bug with TreeView control
- Find Duplicates Query
- Checking for an application in Code - URGENT
- How to export colors from MSFlexgrid to excel ??
- Help converting flat table to relational.......
- Reports - Work on one PC, not on another
- Probably a simple question....
- How many ActiveX controls can I have? Stack overflow problems...
- Access Menus
- Main/subform. Subform works but main form doesn't.
- !!FAQ! for Date: 20040223 - New Users Look Here! [Last Updated February 05, 2004]
- Question on duplicates
- Distibute an application to many users -- Replication? MDE?
- Ask Password
- Passing values between forms
- "Implying" entries
- looking for db design book
- What does an NZ funcion do?
- Listbox gotfocus error that is driving me mad
- photo and images
- Split a field based on a character
- Access 2003 .NET Code Generator
- Dr Watson Access violation error following conversion to Access 97 from A2k
- Terminal Server and Printer
- Edit Textbox using KeyPress vba code in Access
- Help Needed With Bizarre Database Behaviour In Access 2003
- reports with images(the error in format or size?)
- refreshing records
- delete all records ?
- How to Avoid or Trap a Syntax Query Error
- Access to VB
- Access to VB
- Error Message : "Object Required"
- how can i get access to use search engines and return simple results?
- Microsoft Access Calculated Fields
- field types
- Import Specification changes
- Donde encargar o solicitar rutinas de Visual Basic
- odd page up/down problem
- Update Query Overwrite?
- Sorry, Q&A 5.0 need Urgent
- !!FAQ! for Date: 20040222 - New Users Look Here! [Last Updated February 05, 2004]
- access 97: select into/insert into sql question
- subreport problems
- Navigate through combobox
- help with form data synchronising required
- Form Problem
- Very strange??
- visual Foxpro
- ADO in Access 2K and Grid Controls
- Pausing between forms
- Update Query which counts the occurrence of duplicate records
- saving table to excel
- OrderBy closes and reopens the report
- linking to a password protected database
- Brand new install of Office 97 -> 'Builder' and 'Add-In' errors???
- All you geeky buggers talk about is databases
- Access is denied
- Save a forms position
- Multi-Duplicates OK-Primary Keys
- Calculating Moving Average For Previous 12 Records
- What is best way to get access to Access?
- Synchronized Comboboxes in a continuous form
- Question about the QEB
- Access ?
- Saved Query Works in Access but not when called by ASP
- PROBLEM_WITH_MASK
- !!FAQ! for Date: 20040221 - New Users Look Here! [Last Updated February 05, 2004]
- access97: parsing data question
- A.I. and automatic searching and retrival from online search engines using Access ?
- Security question
- Dumb question - took my stupid pill too early
- FileSearch object in Access 2002
- invoicing question
- File - Get External Data - Import - Text Type - Advanced - Specs PROBLEM
- How do you guys work?
- Getting the right record
- Close database window
- ToggleButton
- barcodes
- date troubles
- Update Query Confirmation
- Problem with Multi-Select List Boxes
- at wit's end about corrupted Access 2k records: followup
- Ms access email through Lotus Notes
- Cannot create MDE
- Acccess and Outlook 2003 User Defined Field
- Creating a Calendar from Reservations Dates
- Return Values from a Crosstab Stored Procedure
- Active forms
- Duda en campo importe en euros
- Process Records In A Table In Groups
- Combine four table fields into one record
- Problema al exportar datos a txt, y formato de numero.
- Date Format ???
- Compare Data In Two Tables
- Access 2002 mde in 2003 runtime environment
- Strip document name
- !!FAQ! for Date: 20040220 - New Users Look Here! [Last Updated February 05, 2004]
- Linear update / make table query..
- PEAR DB 1.6.0 has been released
- User new addition to combo box with related fields that need to be populated.
- queries - simple, joint and multiple
- Acces Class Module from outside Access
- escape char for access
- Export Errors in Macro
- Adding one month to a date -- no as easy as it appers!
- How to clear an ActiveX-Control
- Impact of changing field property in Table
- import picture to Access2003
- How to make procedure non-reentrant?
- Delete spaces of fields in access table
- Winzip self-extract for Access Runtime install problem
- Passwords & Forms - Access 2000
- how to calculate man hours for different project ?
- Generic menu handling code
- Warehouse stock location tracking
- Report from Crosstab Query
- pdb file
- Numbering in Report
- Opening MDE Application using File Associations.
- general db design
- Virtual Memory
- Concatenated column in a report
- List box using tables
- Access Forms
- Error 3061
- Problems Caused By Several Users Using A Single Frontend
- query does not extract records if blank fields are included
- Generate PDF with VB code in Acrobat 6.0
- fenton-linson sf wedding
- updating a field with code
- Access 2.0 Multiuser Application
- !!FAQ! for Date: 20040219 - New Users Look Here! [Last Updated February 05, 2004]
- Unique index works but...
- what is wrong with this?
- Can A2002 Reports have multiple Groups on total database records???
- Double combined Search
- Combo box choices using query
- HEEELLP - No Value given for one or more required parameters - Win2000 & XP French version
- Create Shortycups in MS-Access ADP
- How to filter on a report?
- Certain Functions Have Stopped Working
- Reserved Error (-7711); there is no message for this error
- Reading a record set, code reads date as American not English
- Create .mde from .mdb with code or command line
- Sending an email from Access
- Access and DB2
- Comparing data in ms access
- Querying table using duel date fields
- Query Puzzle Access 2000
- Access 2002 conversion back to Access 1997 error
- looking for a tutorial or detailed infos on how to work with arrays??
- Implementing A Junction Table
- Lost the plot in design
- DAO and database corruption
- Updating an Addin
- Passing Query Results to Form
- Random AutoNumber - Is 0 possible?
- displaying data in multiple columns
- Does any body know where I can get a list of english words?
- Can't display embedded OLE object as icon
- Subform Record Pointer Resetting on Requery
- looking for online zipcode database and program
- Fails to navigate to the proper record WITHOUT a MsgBox
- HELP! HELP! HELP
- Getting data into Access Table from SQL
- Outlook events
- Help with automaticallly adding weekly charge
- Network Computers Suddenly Can't Access Database?
- Just converted to A2002, querries not working - please help
- AUTOMATICALLY UPDATE TABLE FROM FORM
- RTF2Control/divide text into several paragraphs
- Text Box Control Source problems.
- Increment Total on Second Table from Form
- forms - control tip text
- Generalization in Microsoft Access
- Length of Formatted String
- Query Causes Hard Crash
- Set required field to Null
- saving [enter a value] in update query
- Need help with delete query
- DLookup questions
- !!FAQ! for Date: 20040218 - New Users Look Here! [Last Updated February 05, 2004]
- excel
- removing last letter in data for a report
- What the hell is wrong with the Update statement!
- Limit the number of 'Selects' in Multiselect
- help with query revised from post (help with query (month as Text) up to given Month) 14/02/2004
- Problem with calculations!
- unique table property
- Word Table to Access
- Export to Excel
- Text string search query
- list box validation
- I'd like to get rid of new record so that user doesn't notice it.
- field-reference in msAccess Report (SQL server backend)
- Numbers in Listbox
- Update Combos using vba
- Replication with Split database
- Error accessing the OLE registry
- Problem with Query Date Parameter Selection
- Reports - Line Spacing in Detail Section
- XP Developer Packaging Wizard Error
- Access 97 Runtime - application icon doesn't appear
- Parameter Like Statement Criteria Problem
- Opening Access 2002 mde Files In Access 2003
- Upgrading from Access 2K to ...?
- "Query by Search Form" Question...
- report building
- Upgrade from O97 to O2K --OR-- O2K3?
- Error: Enter Parameter Value
- Label Wizard - Loses margins
- Convert null to 0 in crosstab query...
- Dialogic Board / Saving Audio files / Dictation
- Access vs. SQL
- Good relational database design
- combo box after update question
- !!FAQ! for Date: 20040217 - New Users Look Here! [Last Updated February 05, 2004]
- Help!! Calculations
- Problem trying to replace a Form using the Macro CopyObject command.
- Form problem
- OLAP cubes
- Scroll in subform only down, UP NOT possible (with mousewheel)
- Call Logging
- Import Wizard Puzzle....
- Corrupted(?) Menus in Access 2000
- wrong order of images in printing reports
- Object invaliad or no longer set error after onverting from Access 97 to 2000
- Exporting to excel csv and how to set the cell to wrap text
- images in reports doesn't refresh
- Help needed: Wrong strTbl in fRefreshLinks
- Complicated problem
- Reading forms and reports information in .adp
- prohibit double booking in room hire database
- text to column
- How can I get all table names from MS Access
- Printing documents from an Access form?
- Brick Codes
- Calling vb from other application
- #include
- very tricky sql statement
- Delete query problem
- Bound form, SQL server, opening in wrong mode
- thin drivers for ms-access ?
- Why to be careful declaring variable As New ...
- changing field names
- How to query for multiple criteria?
- Attach a recordset to a subForm?
- Slowwww printing on inkjet using DoCmd.Printout
- looking for online zipcode program and database
- Access 2000 VBA help file
- report and print a5 landscape
- Running Button Method from Another Form
- Need To Create A Master Record
- If...Then...Else
- Disc catalog to Access table
- Error from Office 2000 to Office XP
- Access 2k ActiveX treeview control
- How to replace a .mde file when many users are connected to the file
- Security--permissions not working properly
- Dlookup function gives "You canceled the previous operation" errmsg
- Scaning Documents Thru Access
- Script for Access FTP
- Cannot link table from SQL Server 2000
- Updating multiple tables with one form
- Using a Recordset to Send Emails in Outlook
- !!FAQ! for Date: 20040216 - New Users Look Here! [Last Updated February 05, 2004]
- Calculating fields in query
- Cannot link tables from SQL Server 2000
- Code to convert a Number to a spelled out number
- Office Delovoper
- Building a report
- Searching in VB
- List plus "Unknown" in Combo Box
- Access fails when clicking on a subform
- Highest Record?
- Open Access Maximized
- Filters and sorts in datasheet view
- Fremdschlüsselbeziehungen anzeigen lassen?
- Parameterized Query
- Building a report
- Easy one
- Acc2K FE, SQL Svr 2K BE, Slow form display?
- nz function with where clause
- OT - NewsGroup Personality - Gilbert And Sullivan
- Save Contents of Unbound Field
- Getting into secured old databases
- sorting difference query-report
- progressive number
- Nested IIF function
- default keypress
- Question on multiple forms and referencing data
- Error: User-Defined Type Not Defined
- Err.msg: You canceld the previous operation ????
- Reading excel file and writing to access table
- Sample database
- Access 97 to XP Access Conversion Error
- Can we use Office Document scaning utility into Access as ocx ?
- Access <- > SQL Server
- Locking records
- How to make/package a mde/mdb file so it can be run on a PC without MS-ACCESS installed...TIA
- Setting the recordsource of a report
- !!FAQ! for Date: 20040215 - New Users Look Here! [Last Updated February 05, 2004]
- Help needed to store quiz solutions from db to VB
- Adding Data to a N:N relationship
- Reservation system in Access?
- Can we display a report without print preview? General queston
- after update handling
- adp connection
- Rdb to MDB
- Error Accessing File - Network Connection May Have Been Lost
- sorting mixed data types in field
- Another update problem?
- Continuous forms, highlighting specific record
- ODBC and Access Database Online
- !!FAQ! for Date: 20040214 - New Users Look Here! [Last Updated February 05, 2004]
- Requery every subform?
- Screen resolution problem
- ODBC
- how to declare only once
- help with query (Month as text ) up to given month
- Print multiple copies
- 32x32 form icon while taskswitching
- Access 97 to XP error Japanese Characters
- Zip Function
- Sharing Access 2000 Files Between Computers
- Saving a record in a suborm with code
- Forms and Subforms - Many Calculations
- Access 2000 - the right choice?
- Access 2003 linked table manager not displaying tables
- /runtime + compact on close + references = crash?
- Senior Microsoft .NET Programmer/Analyst needed
- at wit's end about corrupted records in Access 2k table!
- Selecting Data to get a value
- Sending date to query problem
- Inserting a record & adjusting form?
- !!FAQ! for Date: 20040213 - New Users Look Here! [Last Updated February 05, 2004]
- 3 page "Detail Section" - is it possible?
- Execute/Insert into method works sometimes??
- Referring to subform
- Displaying information in Access - general question
- OLE IMages in Access DB
- problema di sviluppo
- How do I declare a variable that allows data to be added to it without losing its existing value?
- vexing decimal problems
- How to attach an SQL statement to an unbound control????
- Need Asssitance with On Delete Code
- Can't Open Anymore Databases
- MDE
- "Catch all"
- Dates
- ADO not registered anymore
- Access-Datensatz an vorhandene Excel-Tabelle anfügen VBA Function (Office 97)
- relating queries to tables
- Linking to Act
- Replication ID /CustomerID problem
- How do I create an Icon in a form to Print a report
- Readable lables in a Pie Chart...how can I?
- MouseHook and Tab Controls
- Network Update Data,Information needed
- form fields and problems with recording data into the table from the forms
- Forecast Report
- how to retrieve 'quick launch toolbar' folderpath help!
- Calculating subsequent field values in table
- append property
- Need autonumbering help (novice level)
- Access to MySQL
- Access 2002 Database Design Help
- Display updated Totals
- Query Help
- Error 3020 Update or CancelUpdate without AddNew or Edit (Form Error)
- Beyond my scope =-(
- Can't change admin. password because tools menu missing
- queries doesn't return new records
- !!FAQ! for Date: 20040212 - New Users Look Here! [Last Updated February 05, 2004]
- Anyway to change the "style" of an existing form??
- Count distinct occurences
- Re-use report by using a query to filter
- Jumping to row in Subform
- Are drop-down menu itmes stored in table?
- Sympathy for Starwars :)
- Method to Display Future Popup Messages
- Prevent Deletion of Keywords in a Combo Box Table
- query with criteria on two fileds in one table
- Updating records in related tables...
- mde
- MS ACCESS Reports
- How to create own tab delimited file
- Word files import to access database ...?
- Create Read-only file in MSACCESS