View Full Version : answers
- concatenate true value in iff() function
- Export All MS Access Queries into External Text Files
- Count Records Query
- Entering a negative number into a textbox
- mailto in Access form
- Formating Columns
- Programatically create a file folder
- Help with SQL statement, please
- How to set defaults in Find and Replace dialog box
- access to word merge report questions
- Converting an Access app from Jet database to MySql
- Seeking simplest, most straightforward process for creating & populating a database
- this sql command make me sick
- Access beginner User..Need help setting upa database
- Ms Access Template
- The column prefix 'MS1' does not match with a table or alias name used in the query. (#107)
- Exit Event
- Form Detail Section formatting
- "Cloning" a control and its event code
- Need to make shift-enter behave like control-enter
- Can you link a form from another database
- Windows Backup
- How to avoid 'Permission denied' error with Scripting Runtime?
- Zip
- Queries
- O.T. - but stemming from an Access Application objective
- Data Being Updated by Another User
- importing charts
- VB Help wont work, double arrow
- Tab Control
- Dark gray, blank screen when app opens via vb script.
- How to find Unique records?
- PDF to RTF in Access VBA
- Acrobat Javascript in Access/VBA
- ODBC Error 0x80004005 with multiple connections
- Using Null in query criteria
- Queries crashing A2003
- Problem with Linked OLE fields
- Schedule Query to run that uses ODBC link
- DLookup based on combo box on parent form
- OpenForm - Where Condition
- SQL Syntax Error???
- SQL Syntax Error???
- Solved Error 2100 "The control or subform control is too large for this location"
- 2 columns with one Autonumber?
- 2450 error. A97 fails to find saved form?
- Field populated from derived equation. Help?
- Problem with date based query
- Concat two fields but force first field fixed length in SQL query
- Search field in search record dialog not same as focussed field
- merging tables in query
- CODE FOR QUERY?
- Access 2007 Custom Menu Bars
- AccessForms2Web
- Automating email from Access
- Create a query in code or not
- How to protect database (requiring Shift+Enter)
- Disable Item.Send Outlook Warning from Access?
- Can a user accidentally create a delete query using the wizard?
- access automation error
- Replacing text...
- access automation error
- access automation error
- Users Log in issue
- ADO error - please explain/help!
- Access and Outlook
- exclusive access error and adobe add-in
- Adding decimals to duplicate values
- Operation Must Use An Updateable Query!? - NOT Permissions - CrossTab!!??
- Access 2003 keeps crashing
- conversion : access 97 to access 2k or xp
- Hide Query Output
- Make linked table have a relative path
- Code to add and verify existing data
- Compact the access-DB
- query
- Web Service: Which Way In?
- Interesting query problem
- Subreport or DLookup?
- Making a copy of the current database using code
- access currency and decimals
- Licensing / Packaging Excel components with an Access application?
- Access SQL
- Refreshing Referenced Module
- Can not use Date()
- Calling stored procedure with parameters and returning resultsets.
- How can I write C# code that can pick up the custom events that occur in it's Access server?
- My ritual question for each new version of Access since 2000
- MessageBox alternative
- Help needed with First/Last Name combinations
- Can Crystal Reports be integrated in an Access97 runtime environment?
- Relational Design - Organisations and Contacts Addresses - Help Please
- "Clear" Type In Access 2007
- Create a form to enter report criteria?
- Help with Data Access Pages
- A new Tech Forum Looking for Mods
- select records only in certain months
- Phone call recording software (cmd button: autodialer)
- How to navigate records based on another field
- How to have ID's re-numbered
- "Go to next record"-button command starts new record
- Cant Update Recordset
- Double Selection combo boxes
- Copy Contents of Recordset to a table
- Append or Update?
- Text field with horizontal scrollbar
- Eval error 2431
- Pivot table event handler
- Downloaded API
- Counting the number of times a number turns up
- Table security
- option button in toolbar
- Making sure all changes are caught
- Cannot add reference system.management.dll in MS Access
- Splash form problem
- invisible toolbar
- Splash screen
- Splash screen
- unbound subform not working correctly
- Can I use a RecordSetClone in SQL
- Detecting saved data
- Access 2002-2003 creation query string
- Record Last Updated
- Using the alphabet
- making sql statement
- Restore Database Window
- Programmatic Relinking
- http:// in string for images
- grouping memo fields
- dynamic query of files in a directory
- How do I restore menus?
- Command Line parms for self-extracting files?
- Date Range for Query Filter
- Access front end - SQL back end question
- Adding/Combining BMP images in a Report?
- MATCHING ONE TO ONE-IN-MANY IN RECORDSET
- How Do I Replace the Primary Code Module for a Form?
- How do I add a field?
- Access SQL
- Help with Normalization
- Ac 2007 Connections; preliminary look
- Problem with Like operator in VBA
- MS Jet Engine error: "Cannot open any more tables" -1311
- Filtering records in a query based on field values in adjacent records
- Looking for Expression using date conditions.
- Adding Primary Key = Better Performance ?
- Help on Emailing to a Group
- HOWTO import *long* text fields from a csv file ?
- Combo or List
- "Could not find installable ISAM"
- Could not update; currently locked by another session on this machine.
- Web based in-house phone directory
- XL 2003 Graphs: Retrieving Point Name
- Subtract recordset
- Output stored procdure in datasheet-view without using a form
- Windows 2003
- outer join - second post
- UNC Usage
- Help with rs.TableName
- Opening and closing of Queries in VBA
- Start database ved AT.exe
- VBA -Recordset
- Where is ODBC Connection Information Stored?
- 4 steps or better in one step?
- Cursor in default field on form
- Filling every record in a table with the same data.
- Strings Using Concatenated Fields
- Report to word doc
- Renaming
- Add Tasks to Administrator's Outlook on Initial Use
- Catastrophic Failure, Out of Stack Space
- MS Access, locking linked txt-files..
- Deleting Duplicate Values in a MS Access Query
- Office 9 library
- last id of auto-increment field
- Combo Boxes - ID # entering into Table And not Text
- changing auto numbers
- conditional query in access db
- Periodic prompt to Convert database
- Set Window State
- Problem Opening Database Created in A2004 in A97
- Norcal user group?
- start function in access
- Approach to access migration
- A97: If you assign a variant its value using a FN and the FN returns Null, what is the resulting value of the variant?
- Access 03 query question
- Office 2007 public beta available
- Running an update query through ODBC connection doesn't work
- Get the names of Outlook Task subfolders
- Dot or a bang?
- MS Access and caluclating weekdays
- toolbar on the fly
- Problem getting duplicated unbound textboxes to print
- CrossTab Query with Parameter
- DDE Mail Merge issue
- Please offer an opinion on Normalization Question
- Search Multiple Queries with One Entry
- Opening Multiple Copies of one Access Database
- Worked ok until put on CD
- Tool required to Convert
- Need Help Please
- Monitor object activity
- Stuck in AfterUpdate with Form/Subform
- Form Load using SQL HELP PLEASE
- Dbase3 Conversion
- Problem
- Access help
- sequence for access db
- 3D Block Model - Referencing adjacent blocks (records)?
- Taking control of a record
- How will Access Survive
- ADO.NET is an evolution of the ADO data access model
- date filter not working
- Combo box and option group for filtering records for table input
- Find gaps in a sequence and insert rows
- Groups of Database Objects
- Compact & Repair Questions Access2000.
- "Attaching" documents to records
- Unexpected problem with synchronisation
- Programmatically positioning query output on the screen
- Date Query problem
- How to calc the greatest column value for each record?
- Filter By Form problem
- Problems updating/adding records in Access 97
- Accessing a DB from Corporate Intranet
- Import delimited file won't import space value
- Import delimited file won't import space value
- Unable to access folder from A2003
- List query
- Dcount and SQL expression
- outer join
- SQL Select - How do I do this?
- Dcount
- Word Count in a Form
- How do I use a PictureBox ctl as in VB ?
- Update query question
- Finding duplicates
- Display font choices each in own font
- Help with adding a calculated field to a table?
- Help determining Record Source for report
- Need a script or bat file to uninstall Access97
- Access databases in Chinese
- Displaying Recordset
- Update Query
- 2 Queries Export to Excel in the same spreadsheet
- List Box lookup
- error accessing file. network connection may have been lost
- Close All Instances of Microsoft Outlook with VBA
- Newbie needs help
- Combo box to select colors
- Exporting into Excel
- Is setting to Nothing really necessary if procedure is about to end?
- do i NEED to use .movefirst immediately upon opening a recordset?
- Strange problems with /decompile
- centralized database
- Site for Access experts
- strange Combo Behavior
- make database
- Chicago Access Users Group meets May 25: Quickbooks integration, Total Access Analyzer from FMS
- DoCmd.OutputTo -- From SQL String?
- Need help accessing different forms
- Trying to add dotted line after a text box
- Crystal Reports vs. Access
- Dump file to access table
- Am trying to understand #If ... #Then
- If I forget about and leave a breakpoint set in A97?
- Error message
- freelance programmer / developer
- Adding Time over 24 hours
- Help with a Form and Multiple Queries
- Help wanted sales tax
- Viewing images in forms and reports...
- How can I make a form re-read (refresh) it's datasource
- Exporting Query Results To Word Form
- strange function problem
- Update 3 rows at a time
- Make query2 contain same rows as query1?
- How to set ADP file revision number
- Better syntax?
- Date entry in a text box
- Albert Kallal's printch2k.mdb
- auto-updating a table based on a linked table
- transfering data
- Access 2003 backend db path display
- Adding text boxes
- PivotChart Decimal Place on Fixed Number Format on Averaged Field
- Finding an index in an Access DB
- Finding index tables on an Access DB
- DoCmd.OpenReport "rpt1", acViewNormal - Choose Printer Dialog
- quer files don't work with back-end database
- Recursive BOM
- Getting a Constant Number of Records from a Query
- Shell command won't work using file server path
- Access.Image with MS.Imagelist
- Visual Studio & Access Developer Extensions Help?
- Grouping with detail
- Null Propagation Issue
- How to show...
- Building a list from a list box selection
- Performing DLookUp in a query field?
- Paste to ComboBox: NotInList
- Drill Down On Report
- Changin fields' names
- Slow synchronizatin proccess with Access 97
- How to get recordcount or number of records when using linked tables
- Need Help with an Access Calculation in a Report
- Need Help with an Access Calculation in a Report
- Need to Pull Data from a ListBox to a Control
- Can't compact Access 200 db
- Ms Access 2003
- Opening MS Access forms from within PDF
- Access VBA WMI inventory
- Is there a way to prevent BeforeUpdate from firing??
- Rules for multiline SQL statements
- Query Subforms breaks link to back-end database on new imports
- You don't have a license required to use this ActiveX control
- combining multiple crosstab queries into a query or temp table
- NotInList adding new entry as a new record each time
- Easiest Way to Find a Table
- Automation Issues
- Seeing all records on a form when re-opening
- Calculate Width of text
- Calculate Width of text.
- version support for dbase/paradox access 2007
- Preventing duplicate records in query/database design?
- MS Access Date Expiration lockdown function
- Continous Form Records Ranking
- Intellectual property: The foundation of A L L human prosperity.
- Continuous Forms--Combo Box with Variable Row Source
- HELP With Where Clause
- Performance of Links? To Import or to Link?
- Double one to many....PLEASE READ
- Making a duplicate record
- Persistent Connections - always a good thing?
- How to create an Excel Spread sheet from Access
- Multiuser access and storing user objects
- iterating over a form's records
- Building a form to copy and rename files
- Select Query Help
- New Kexi 2006.1 for MS Windows released
- Deleting Data in Access
- Security Wizard but Not Secure
- Using checkboxes to select rows in a form
- showing data
- call a query by macro with parameters
- Access Report Page Header problem
- Problem with left join statement
- Using Access to pull data from FileMaker Pro
- Searching for words out of older in Access
- Can't Make a Simple Change to a Record in a Single Table
- MS Access linked tables MYSQL
- Control Sound Recorder from VBA
- importing .dbf or opening with ado
- Error trapping in Access 2003
- Emailing Reports in the body and adding attachments
- TransferSpreadsheet Method and SQL
- Report
- Duane Hookom's Outlook Style Report for MS Access
- ODBC connection fails only for a single table
- How to check if running in full version or runtime
- MS Access 2003 OfficeLinks - Disable Excel
- Repost: Conditional formatting not shown when opening datasheet subform
- CSV date Field IMPORT Problem
- Tab Control Back Style Windows Themed Controls
- Strange Permissions problem (I think)
- Can't Create Linked Server SP in ADP
- Choose Function
- NewData and OpenArgs to pass values from form to form...problems
- Automate Word Mail Merge - Conversion Issue
- How to refer to a form control programmatically
- require help with form setfocus back to last row??
- Inputmask using date - Edit the date after input a cause error
- File->Export from a report shows "registry error" in installed app only
- Mysterious errors with Event Procedure on one form
- Constants in queries
- how to get rid of warnings from required fields?
- Have SQL syntax for create table/data, how run it in Access2003 ?
- GOTO Indexed Record in Code
- building multiuser database
- Calculating Late Date in Access
- Help with Availability Query in Access
- Solver function from within access/vba
- runtime error 438 after importing project
- prevent importation of tables
- Design question: Permissions to view
- Combo Box Help
- Bitmap images no longer visible
- Disabling part of a form on startup and setting the focus
- Saving text fields from Word templates into Access DB?
- Form that enters data into multiple tables
- Resizing image control with jpg image
- field for mailto links in access
- How to add a drop-down to a toolbar? (Rich Text)
- Toolbars not working
- Check for Duplicate Data
- French Characters
- Specify Pages to Print
- importing csv
- Reading Material
- Create a column populated with numbers sequentially that look like 1, 1, 2, 2, 3, 3 ?
- Query question
- Compact and repair Back End From Front End at Runtime
- Rename tables from external program
- Help needed again
- Sending E-mails to adresses in a table
- select query + insert query + MS ACCESS
- consolidating tables
- Cannot close Access
- forcing a page break in a report using code?
- Need to add multiple blank records in one table based on a parameterized query
- Nested "With" Clauses?
- Duplicate records
- Use Access to POST and read from website?
- Wrestling Match - Need Access 2002 SP3 POST hotfix ?
- Crazy email button
- Combine Tables
- Getting data from a field to use in VBA code
- help needed
- Pulling Multiple Columns from a Combo Box
- Created on Access 2003, but.......................
- Update Query Help
- Importing Hyperlinks from Excel to Access
- Help with querydef and parameter query
- Multiple combo boxes - got 2 out of 3 working...
- Debug window: How to change keys that open it
- Change Guru Lebans listbox selections to query
- bitwise operations
- Update form when list selection changes
- DB developing
- BlackOut????
- Any way to flip a Vertical Alignment label?
- Adding additional lines / empty records on a report
- Making text boxes on a report grow and shrink all together
- Excalmation point in Date/Time input mask
- Something strange about Form_Current
- Need WorkAround: The expression you entered refers to an object that is closed or doesn't exist.
- Automating MS Outlook Agenda
- Comparing dates of birth to find twins
- Date format frustration in forms
- Source safe problem...
- Access check box and option button to filter
- MS Access Database Network Path
- update fields in table using vba
- Composite Primary Keys
- I'm not sure if Jet 4.0 is correctly installed
- Message Box Not Appearing and Field Updates Automatically
- using boolean as criteria in SQL
- ACCESS Help with System DSN
- Can I link to reports in another database?
- daily activity
- Locking Form and Subform
- combo box shows relevant reports in subform
- Add to a memo field
- VBA Calendar Controls
- DAO recordset append single record locks entire table (linked table)
- Dropdown Property
- I got a databse here that was done a little different
- Problem with DISTINCT query ?
- Importing Excel to Access Date/Time Format erroring
- Query a subform
- Query a subform
- Chinese chars output from query??
- Tracking Daily Attendance in MS Access
- why does it not work occasionally?
- MS Access Application
- Comparing Tables Containing null Values
- Evaluate UNBOUND textbox using custom function.
- Using Steve Lebans' Rich Text ReportUtilitiesVer76 - Error
- Error code 2585
- SSN Format query
- SAP R/3 and MS Access
- create dump files
- Use someone elses DB and Queries
- SP2 slipstream of Access 2003 runtime
- A97: When to set var to Nothing?
- passing values in query
- Print same Reciept 3 times on a Page
- My DB is 2GB and won't come down!
- Recordset Help
- Reports and parameter queries
- Import Shift Some Column Data
- jpg file to image control
- Help with subreport referencing
- Data entry, storage and processing - MS Access okay?
- Data entry and processing - MS Access okay?
- Detecting SQL Server error messages in Access
- Saving an Access Report In PDF Format with a different Name
- Data entry and processing - MS Access okay?
- Find All Instances of a Subpattern Using RegExp?
- Problem using window API Access 2003
- Using two columns as a primary key
- Unbound form questions
- Unbound form questions
- Here's one for ya.
- Validation VBA w/MS Access
- Access to word Mail merge problem: Requested object is not available
- Macro Substitution
- a bit stuck
- Record Source (Multiple Tables) No Relationships
- MS-Access Combo Box To List
- Create a macro to send object by email
- setting null image.Picture property
- how to use decompile on secured db
- O.T. - Seeking Registrar w/ no imposed domain xfer fee (if you're opposed to O.T. posts - don't read this)
- Requering One Record When Change is made using code in form
- numbering by unique
- How to return multiple strings from a user defined function
- Opening Word Document and passing information to next new line
- counting number of rows which contain the same Part No.
- Move buttons by user ?
- Avery No of days late query
- unable to loop thru records
- HELP!! going to go mad soon!! query help
- freelance programmer / developer
- Order records in ComboBox
- How to display a subform with a command button
- Is there a way to open a *FILTERED* recordset on an excel file ?
- Adding data to a recordset
- Access 2003 Beginner - Requery from Combo Box Help
- Simple conditions for comboboxes but without query
- Leave a message when exiting system in Access
- Application.FollowHyperlink Pass a value to web page
- Useful MS Access focussed Search Engine Swicki
- Need help with sending HTTP strings from Access VBA
- Date/Time Calculation
- HELP! unwanted fields
- Showing web page in database form
- Completely OT Rant about MS
- Updating a check box based on a complicated relationship.
- Export --> JPEG OLEtoDisk
- TransferSpreadsheet Method
- Opening form with Value in Combo Box from another form
- Error 2465 "Access cannot find the field..."
- Access deleting updated records from update table
- Creating an email with attachments from an Access Form using VB
- Missing Operator In Query Expression
- Missing Operator In Query Expression
- HI-report generation tools
- export DDL for tables from Access 2000
- report creation problem
- DISTINCT or DISTINCTROW does not work
- Update references from code
- Acc2K3: Changing value on form from another form doesn't fire change event?
- Ranking records in a query
- Detect column in list box mouse click
- Help with DLookup/ I'm stumped!
- Please someone explain to me why
- Calling Procedure From Command Line?
- need to sort part numbers that have various prefixes
- Checkbox and Continuous form again