View Full Version : answers
- Taking info from one form entry to another.
- Taking info from one form entry to another.
- Dealing With Quotes In SQL Statement
- How to highlight all fields in record when entering one field?
- An Easy Question
- what the...?
- form design with tabs, subforms, and multiple entries for one record
- MS-Access doesnt close
- Memo fields in Access 2003
- YTD figures on a report
- access unbound column of bound combo box
- Multi User system Update
- Query By Form Like Statement
- Report shows wrong Sum() format
- Accessing Oracle Sequences via ODBC
- Is this possible?
- How to trap error when referential integrity is violated?
- Compact MDB
- Using a form (with a combo box) to enter report criteria
- Form not updating query and table
- OOPS! How to restore a module after removing it?
- Bug when copying a form or report to another one?!
- Same font, same size, same printer but different length. Please explain
- Tooltips Switched Off
- database
- Need to supress a open form command if the fieldto getting focus is [field1]
- Website Internal Messaging System
- Access administration/support business plan
- Downloading a Report from Access into Word
- Put your pc to work-paid autosurf
- How to use wildcard character in query?
- Happy new year
- Date Criteria Problem
- Thanks for the help on multiple instances!
- How To Prevent a User from running 2+ copies of the Same Access Application
- Some more problems with exporting Access Table in Oracle
- SQL - Total results
- Looking for rowsource property using DAO in ASP.
- No one has solved this: Runtime error 2118
- Replace with wildcards
- problem exporting access table in oracle database
- problem exporting from Access to Oracle
- A2K - how do i make this SQL retrieve distinct values?
- Need SQL code for fields when using MAX function
- Can't get past table strategy (that IS step one right?)
- Tab order on multirow tab control
- Help with populated data on a new form from the previous.
- Table Field date problem
- Filter Report to Only Print Current Record from Form
- Lookup Lists
- Lookup Lists
- Splitting a text field conatining a carriage return.
- Faster alternative to Microsoft Graph 5.0 Chart ??
- Anyone having trouble with the Access VBA help system?
- Job Titles
- update auto incrementing check# to records on table
- looking for code to copy a file from a ftp location.
- A2K or later: Format a time field as 24 hour time format?
- How to change an existing field size with DAO or ADO?
- Connecting access aplications with PIN/CHIP payment divises
- UPDATE query syntax question
- field contanins column name for query
- field contanins column name for query
- find duplicates wizard Fao Darryl Kerkeslager
- I fear
- In Access 2003, how to: output a value, followed by a percent sign (%), from a SQL query on a Report
- Finding complimentary data sets in MS Access Using Queries
- Why can I not add a field to form??!!
- Query - fields showing up that aren't selected
- 80004005 too many columns selected
- Query - fields showing up that aren't selected
- Query
- Query - fields showing up that aren't selected
- Vary gap widths in report charts (ACC2000)
- Which way to have transactions?
- OpenArgs from a combo box?
- #Error in Form Footer Total
- A2K3 on Windows Terminal Server
- Enter Parameter Value dialog appears on only one PC
- list all dates within a range except for those in table
- Rotating Objects in Access 2000 Project
- Printing Multi-part Reports
- Digital Signature is lost if SQL Server tables are relinked
- Strange Access2003 problems
- Change how a Lookup Value is stored
- Wait for PDF printing to stop before next code
- Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
- ASP and access
- Access: using as the backend
- Unpredictable db size increase during INSERTs - Memos?
- Error '3426' When Updating Database
- DoCmd.TransferDatabase saveloginid flag working?
- Access Report, Conditional Text
- ListView Control: Some way to estimate size needed?
- How to convert mde to mdb
- Setting a default equal to the last value entered
- find duplicates wizard
- createdatabase method not accepting dbVersion40
- * Records not visible except to computer Administrator
- Export records to text file?
- a2k - how to split up field contents
- Can ListBox be pre-loaded for better scrolling?
- ADP: subform auto-requeries in endless loop
- LastXDay function
- Forms with Calculated Fields not populating
- Stop importing
- Remove Help Window
- ListBox value when nothing selected
- Find a Date in Time for Valentine's Day
- RE Query forms
- Using Wildcard with IIF() Statement
- Strategy for form instantiation: is it a good idea?
- Access and MYSQL continous form problem
- Access koppelen aan pin/chip automaat
- "Group by" annually
- Query forms
- access 2003 add-in manager
- Picklist w/Snaking Columns? (Access 2k)
- Remote database
- Report/query prob
- More trouble getting Dates
- Opening Subreports with dates
- Opening subreports with dates
- Lookup Wizard
- Combining records
- Problem setting .OnClick event
- Need Query by Month when date written as **/**/2004
- remove letters and numbers from text box
- Creating Account numbers and such
- Table access via recordsets
- ms access connect to quickbooks?
- Easily go from one data set to another?
- Spawning Access from Access
- Getting the name of the database, is there a varialbe?
- How to add minutes to Date?
- form/subfrom problem
- Access/Outlook interface
- Recursive Function with Select Case fails to exit
- Database Connectivity
- Database to a table
- Images in Access Runtime problem
- access97 vs access2000 advance filter
- Getting rid of hard coded path
- Packaging third party activex
- Web-Based DB Application
- Create a duplicate record
- Access 2003 Runtime
- Package Wizard Problem
- Using a string to call a function
- Please Help Me
- Homo Holliday Gift
- SubQuery parameter for report
- Auto Numbering - Help!
- Save As Type Dialog
- DB design question - survey system
- Access.Lockfile.9 - why???
- AutoCommit
- Printing all subform data records
- 2 questions concerning multiple tables
- "Global" Qualifier question
- Best way to find a record in a table with a large number of entries?
- Form values via SQL Server Pass-through?
- Generate Reports to Multiple People Automatically - SendObject
- Need help on continous forms please
- Disabling Function keys
- ! Data not visible when not logged as Admin
- Architectures for multi-user access database
- Yet another list box problem
- Help with and Regular vs Overtime Query
- Updating fields inside headers/foooters
- need help with field refreshing
- Can multiple users input information into one table possibly simultaneously ?
- Access 97 : How to suppress duplicate information in a complex(?) report?
- Query and Report Questions
- Two problems in Access
- SendKeys not consistent with MS Word
- Wrapping problems
- 1 more question
- List box to list the opposite of a query
- Making a word document with VBA in Access or Word? Examples from other users
- Find duplicate records in multiple tables
- Transpose Tables like proc transpose in SAS
- Transpose table like Proc Transpose in SAS
- Server for replication over the Internet
- SQL duplication & project maintainability
- Moving/Rolling Average in Ms Access Query
- Continuous Form and Images
- Left, Right Mid?
- Tab Order
- Create Form Section
- Security
- Access 2002 Form
- Can DDE Functionality Be Reloaded Into OS?
- 2003 Package Wizard Problem - aim.ocx
- Different MDAC ? different SQL server behaviour
- api for having a warning sound?
- Backup backend.mdb into separate folders?
- Automatically select all records from a list box
- subform printing
- A2002: Count only records closest to criterion in query
- MDE file -- advantages and disadvantages
- A2002: Count only records closest to criterion in query
- Show window
- How to set Security level in MS Access
- Undo subform from main form
- ADO Transaction Question
- allowing null values in rst
- A new question with lookups
- Implementing financial calculations?
- How do you calculate someones age?
- find text question - looking in specific field vs all fields in table
- testing emails
- Need help with report
- Inserting data from one subform into another subform
- Creating a Macro that will send a report via e-mail using different queries each time.
- Linked table automatic login to SQL Server
- Concurrence issues
- Creating a Macro that will send a report via e-mail using different queries each time.
- concurrency issues
- Macro that e-mails one report using a different query for each rep/e-mail
- Filtering Forms
- Security
- Revision Counts for Access Project
- Hyperlink field
- Multiple Field Queries
- parameter prompt when form opens
- Disable Write Conflict Dialog
- how to get current record
- How to open MS Access DB exclusively
- How to open MS Access DB exclusively
- Form Datasheet Formatting
- Silent install - run-time
- Office 2003 - Certificates for Code Signing
- Database Backup
- UNION ALL causing #Error when used with DSUM
- -> POP-UP FORM with PROGRESSBAR while LOOPING recordset
- Open Office BETA Debuts With "Access-like" Application
- "Dim db as Database" generates an error
- Can I use bookmarks to mark records for deleting?
- need to trap hyperlink error message
- Mail Merge Complication
- Access 2000 vs Works db
- Importing Hidden files
- Auto Numbering
- Auto Numbering
- Input Parameters in an adp form
- Apple and Access on Windows Peer to Peer
- Invert Unequal Dataset
- How to enter a value in a field to be calculated and stored
- How to enter a value in a field to be calculated and stored
- How to enter a value in a field to be calculated and stored
- Help to caculate Employees Hour:minutes towards overtime
- Tab Pages
- Using a Message Box with a Combo Box
- Query a one to many table
- displaying records for a certain amount of time that has elapsed
- Norton Ghost
- need to trap hyperlink error message
- Access 97 - Error Message
- Problems with embedded images associated with Microsoft Photo Editor 3
- req: file
- Acess/VB Coding
- Map Ext. View Elt. to Conc. View Elt
- Access 97 office links when running XP Pro
- Hyperlink base
- need to check if field is empty
- use DBITM???
- Access 2003: Request help on pivot table query
- Format number as 0.0k
- How to restore cursor position after acSaveRecord?
- INSERT INTO PROBLEM
- SQL INSERT INTO PROBLEM
- Excel Automation from Access - releasing instance
- trap hyperlink error message
- Query troubles
- DlookUp
- Caculating Currency to Time (hours:minutes) format:
- Unrecognised database format
- delete column values (but not the column)
- Solution To ERROR 3051 (Client Cant Connect Due To Open Exclusive)
- Church Database
- Labels 11 Vertical Issue
- Import Pics from folder...
- SQL MAX() on two tables
- Copy and Paste header into MSWord template
- Function As Rowsource In Listbox???
- Making change to tab-defined linked file from access
- Amherst report card database
- Table setup
- Refresh Form data across a network
- populate combo with field-caption-names of a table
- How to get a Form pointer to the parent MS Access window?
- NOT FIRST OR LAST
- How to track the history of a selected number of fields in a record? Access2003
- How do I...return non BoundColumn value from MultiSelect-Extended listbox using VBA?
- cd 4 "visual basic lang. developers handbook"
- Access DB "on it's way" to corruption
- Syntax For Collection
- if/then query
- Where is my default shortcut menu?
- AfterUpdate Event Runs Repeatedly (3 times)
- Change DB Autocorrect from VBA
- too many fields defined
- Bild in Access-Bericht frei platzieren
- Form Events MS Access 2000
- Import table as query
- QUERY
- MS Word doc to Access with images put into a file server...
- Treeview Control
- Controlling Form Size
- Database Security
- Help please! Linking, showing, but not embedding images
- Get Max Value AND Date it Occurred
- Stop Access from reformatting and breaking my SQL statements
- Formatting Fonts
- Listbox problem
- Using OR in Switch functions
- There is no limit to human folly
- Automation Problem
- Access continuous form, different indentation for each record
- Access 2003 Form with Calculation
- scrolling listbox is slow
- Read PK from MS Access Metadata
- Reports
- messing around with the item ordering of a Collection - the Controls one, specifically
- Prevent showing duplicate records in a query
- Highlight first record in listbox on opening form?
- mail label printing in acess 2000 +
- Crosstabulate orderdetails
- Mysterious adArray - Does anyone know how to use?
- Access 97 - Input Mask
- Jet database growing and a few questions
- Automate Table Creation
- Solution: Concatenate rows from same column
- ADO Command Object with Array Parameter
- How To: Using Desired Gross Profit Percentage to calculate Selling Price
- Syncronized Combo box (Cash Flow DB)
- JOINing detail tables into the main table
- Data Entry Form Problem
- Data Access Page (DAP) viewable from Pocket PC needs IE 5.5 or higher
- Is it possible to filter ontop of the current filter?
- subreport blank
- Reports: continued page footer
- Simple Database
- Extra Access Instance with Automated Mail Merge
- Referring to a subreport (Error 2455)
- Select value for textbox by using another form
- Combining two tables
- Let your customer find fast and easy all text he searches !
- Opening Crystal Report for a password protected Access database
- Delete old database
- grouping in reports
- Launch ADP from Server
- Automate the import of a csv file
- Sorting A Collection
- What's your evaluation of Visual Studo for Office?
- Access 97 Subforms
- Relative Paths for Graphics
- how to import query from drive, path, filename
- Crosstab query to fill values in Table
- Performance Timer
- Warning when opening and Access 2000 file in Access 2003
- Option Button on MS Access Form
- Code not running correctly from form
- Fastest way to browse recordset?
- Code not running correctly from form
- copying data between forms on DoCmd.OpenForm
- Access developers: Job Title question
- MS Access for a dummy
- Fields Not Displaying Properly
- table not linked
- Running AVIs with sound in Access 2003
- ODBC Connection
- Computing the past monday - Friday when Sunday occurs
- Last day of the month
- Recovering table
- E-mailing from Access
- Code not completely running
- DoCmd.OpenReport Crashing Access 2000
- Error on defining DAO objects in the access VBA
- Mousewheel problem
- running alphabet
- Automatically get data in field when picking something in other field
- Auotmatically getting info from another field
- Code not completely running
- word mail mergers from access
- Repost- Calculating the difference in two values
- List box decimal places
- Multiple tabcontrols
- Clipboard
- Polymorphism and inheritance patterns in VB
- Using Dlookup
- How can I manage propertygrid
- Display Items In A Collection In A Listbox
- month over month decline query
- Visual Studio 2003 & .NET Applications
- Visual Studi.NET 2003
- Show Month over Month Declining Sales
- OleDrag/Drop events?
- Highlight field in continuous form - based on value in field
- Mousewheel problem
- Sending email to Lotus Notes from access????
- Field compare report
- Switchboard not in Forms objects
- findRecord method
- Fom deactivating NUM LOCK
- How best to update client table records with a dozen or so changed records from another table?
- VBA Array to Lotus Notes email Looping Problem
- Combining Fields
- Find TableName of related table
- "the wizard is unable to create your report"
- Number of tab controls
- Printing labes
- increment revision value
- Form Layout problem
- Date stamp on tables
- How to keep track of data changes (best way..)
- merging multiple fields from various tables in one word document
- Comparison between two Access tables
- form design one to one relation
- Disabling buttons on parent form when child form is opened
- Class or Function that lists options
- Creating Tables from a grouped recordset
- Sequel Server
- rounding error issues on invoices
- Fill Reports
- Data from multiple tables for report - how to do it?
- passing multiple arrays as parameters.
- Report: Text box won't print or repeat in page header.
- NDS authenication via LDAP
- Properties Update
- #Error
- Create/Edit Batch Files from Access
- Using Novell (via LDAP?) to authenicate
- Nested Quiriers ??
- Sub Report Not Showing
- Third Party Crystal Report Viewers??
- Editing field in form
- drop index question
- Access based software for managing client services for basic humanneeds agency
- Calculating the difference between two values
- Using a value in Tb1 to determine num of appends in Tbl2
- Using a value in Tb1 to determine num of appends in Tbl2 (txt vers)
- Date stamp on tables
- how to display one to one relation data on a form.
- invoice printing
- How can I prevent to add double data
- Jump to record in listbox
- On Error Resume Next - Not working
- Cumulative Monthly Returns
- Page header does not display when using Columns
- some clarification
- Access97 runtime on Terminal Server
- Obtain IP address via VBA ?
- On Error Resume Next - not working
- Open forms using Openargs
- AutoNumber Regeneration
- some clarification
- Access97 runtime on Terminal Server
- Obtain IP address via VBA ?
- "Word could not re-establish DDE connection to Microsoft Access to
- Can I use multiple criteria with a DLookup?
- increment Revision field value
- Copy from a variable Directory to a Fixed Location
- On Error Resume Next - not working
- HTML Help file problem
- New Access User - Stuck on a simple problem...I think
- Open forms using Openargs
- merge multiple tables in one word-document: how to do it ?
- Return field values from a query using a Recordset in VBA
- Help! subform vertical scrollbar problem
- AutoNumber Regeneration
- Back up split database
- "Word could not re-establish DDE connection to Microsoft Access to
- increment Revision field value
- Can I use multiple criteria with a DLookup?
- What does ByVal mean?
- VBA/Access: How do I "abandon" a record when using linked forms?
- How to control the scrollbar of the subform
- Copy from a variable Directory to a Fixed Location
- HTML Help file problem
- New Access User - Stuck on a simple problem...I think
- Query help
- "Enter parameter value" input box when running SQL statement
- Linking Custom Form User-defined fields from Oulook to Access
- merge multiple tables in one word-document: how to do it ?
- Can't Get Database To Open
- Return field values from a query using a Recordset in VBA
- query to self table
- Help! subform vertical scrollbar problem
- Back up split database
- What does ByVal mean?
- VBA/Access: How do I "abandon" a record when using linked forms?
- How to control the scrollbar of the subform
- Query help
- "Enter parameter value" input box when running SQL statement
- Linking Custom Form User-defined fields from Oulook to Access
- Can't Get Database To Open
- Concatenate rows from same column
- query to self table
- Concatenate rows from same column
- VB routine to parse SQL string and get the field names
- VB routine to parse SQL string and get the field names
- Database Help -- hotel front desk emergency
- Dynamically add columns to a form using CrossTab queries
- Database Help -- hotel front desk emergency
- Playing around with Access references
- Playing around with Access references
- Dynamically add columns to a form using CrossTab queries
- Allow Menus Via Code?
- Allow Menus Via Code?
- List of Trusted Publishers
- List of Trusted Publishers
- NT Authentication and MS Access
- NT Authentication and MS Access
- Fill textboxes in report with vba
- I'm having a GoToControl problem. Error says can't move focus to ButtonG???
- Printing Subreport Borders
- FTP using Inet Transfer.mdb
- Create table from Global Address List group..
- Run Compact & Repair/Import Externally
- Subreport Borders
- Subreport Borders
- Access Calculation of differences
- Highlighting current checkbox
- Go to record in listbox
- How to delete from cloned recordset?
- Numeric Field Auto-Fill-in
- Import of RTF to Access Database
- Tip for code improvement and development time savings - set-oriented programming
- Write conflict ?
- Possibility to divide a tall subform to two short subforms?
- How to make a running sum in Query ?
- How to make a running sum in Query ?
- Problem with cdo.dll/cdosys.dll
- "the search key was not found in any record"
- Query with multiple outputs
- PDF Files
- selTop and filters
- Converting Unicode Strings in Access/Basic
- MS Access Variance Graphs
- .bak file created by Wrkgadm.exe
- Exporting images to PDF
- Easiest Way to Enable Groups of Controls?
- REMOVING '/' IN A FIELD RECORD USING ACCESS CODE
- 400+metrics: Span multiple wide tables or use one narrow table?
- Continous Form
- outlook 2003 distrubtion list with 1000s of contacts
- Importing a DBF file
- Data-Entry option error