View Full Version : access answers
- SQL Question
- how to set a form that is a subform
- Foreign Key Won't Enter In Subform
- High Order Zeros Edit Issue
- Need help with aggregate function query
- Commerical App ....but no relationships??? Normal??
- Image not longer shows up in database record-windows reinstall
- If you have connected to FoxPro tables via ODBC, please read/help
- Foreign Key - Replication Code or Integer Long?
- Toolbars and Security
- Would like to somehow link specific eMails in my message store to MS Access database
- SQL quandry
- Setting Hot Keys in MS Access 2000
- Problem with OutputTo
- JD Edwards to MS Access
- Add records programmatically?
- when to use ENUM and when to use Public Const
- JD Edwards to MS ACCESS
- chinese characters in fields
- Definition of Database Map?
- Acrobat Distiller 6.0, VBA and MS Word
- Read-only Forms in a SQL .adp file
- Maximized form Distorts on recordset update
- input mask on date field
- Thanks to Pieter and to Paul
- Entering data through a web page
- Pieter Linden - Thank You
- ODBC and MDAC. ????
- Make a forced new page be an odd number
- Transfering Data: from end of year/season to beginning of next
- SQL User Defined Function
- Synch then find conflicts
- How to make unique hyperlink URL for each form record?
- Report Manipulation
- Copying new records
- how to query values from different fields using different criteria?
- Access Help viewing webpage
- Load Flat File
- Code changes from XP to NT
- Check for Flat File
- Hyperlink problem
- run time error 2202
- ai ai ai
- Cant Get a Date Field to return correct date?
- How to disable MS Access 2000 screen design from the user
- Using Multiple Forms and a single query
- Office 2003 - Digitally Signed Databases problem - URGENT!!
- SQL or VBA?
- How to Trigger Macros in a Access DB from Another Access DB
- database sharing
- Problem with Incremental Search box
- Retrieving images from Access table PLEASE HELP
- MDE AutoNumber problem
- How to email errorlog table.
- Relationship question
- A2K3 Turn off Help Combo Box?
- carrying date into new records
- A few Access questions
- word forms, access, and indefinite numbers of entries
- sorting short dates, without using years
- Feldnamen aus String's zusammensetzen für Abfrage
- Tab control pages
- Issues with Search Form = IIF Statements
- form not copying field to subform
- New user question on forms
- Between Peredicate
- Split Database Issues
- Updating DATES
- Count in a Text Box Control Source Property
- Query counting records for pre-defined ranges
- Aggregate Query problem
- Creating ODBC data source fails
- Table relationships
- When is a boolean not a boolean?
- Collection object help - driving me crazy
- Query Criteria Help
- Revisiting mdb/adp files as libraries
- Retrieving information from tables
- Turn mouse scroll off.
- Possible to link digital photo to OLE type field in bound frame in a form?
- Access project database - failed to create database on MSDE
- database sharing help
- Expanding a Series
- Rotate Text
- How to remove "Type a question for help" box on menubar
- Access 2002 Issues
- Need help on Grouping by Week or DatePart function in ACCESS?
- complicated query... help needed
- Query across three history tables
- Tab from list box to subform control, Access 2000
- Opening Another Database from WITHIN a Database
- Conditional Format Based on a Different Cell
- Storing directory names in a table
- Charts: Change in Y
- Script not working
- VBscript not working
- listbox question
- PDF Creation
- Connect to Copied SQL Database
- order of query
- Pass Calendar Value into subform?
- Programatically printing Access reports from pdf995 using VBA
- Turn mouse scroll off.
- Export Access Data to Oracle
- Looking for Peter Miller - PKSolutions...
- copying and changing fields to another table can you change description at this time?
- Help - Table Field Properties
- I make Database in Ms Access at order
- Bazy w MS Access na zlecenie
- Alpha characters
- Append Data From Report
- ALTER Table in ODBC
- Automated Directory/Folder Creation
- Search invalid forms and reports after design changes in tables
- Print Word doc to lower tray - Access 2003
- NZ Function Not Support via ODBC
- Access 2002 Error 3625 in converted database
- custom message box
- trapping the untrappable ?
- Query writing help
- date+order
- Error in module from XP to NT
- Using a combo box to look up values and to enter new values
- MS Graph Completely Useless in A97?
- Email a report in MS Access
- exclusively open, locking the database
- Merging and deleting duplicate records
- Draw Lines and Boxes Better explained
- Drawing lines and boxes
- Using a Japanese Access '97 database under Windows XP
- Step by step how to open a popup calendar on the main form?
- #Name Error for Calculated Field on a Form
- Date/time problem
- Numbering help
- Endless output using OUTPUTTO MsWord
- ListBox doesn't change focus with form navigation
- Problem with Import External Data
- Query grouping problem
- Link Tables problem....Way too slow to operate.
- Error 2024
- In-Operator and global variable
- Database Access
- Error handler add-in
- Re-write of Allen Browne's "OnHand" function -- opinions?
- Colour values form a bitmap
- access select query
- Help Using Text Box to fill a Listbox
- Validating imported data
- button to import .xls to access
- Access 2002 discontinued?
- filling combo box based on previous combo
- Begginers' problems
- Rank function
- execute SP from ms access
- Accessing webservice from access
- Pulling data w/ date parameters only when a past field value is null
- Override Access update with stored procedure
- Calculate the median
- Adding a Duplicate Record
- Can't get around temp table in front-end
- Hiding Toolbars with code
- Using mdb databases
- Importing new entries only from .csv file
- Export Data to Excel
- Looking for suggestions for "How to Develop"
- Resizing code
- Help+invoice+numbering
- Inputing date to separate tables while retaining links
- Retrieving data from an AS/400 stored procedure
- Audit Users/Login databases/tracking
- Auto writing Excel spreadsheets from Access (97 & 2K) fails to releaseExcel
- MSAccess 2003 - Digital Signature
- MSAccess 2003 - Package Wizard
- Printing to a specific printer
- Linked tables in ms access asking for login/password
- Gauge or timeline control for continuous forms
- debugging classes
- good syntax with if statements
- Mental block - text box binding and queries
- Changes to data from a query
- Point-Of-Sales
- Exporting result of a query to a db3 format?
- Selecting only one page out of a several-page report for printing - how to route in Access?
- What operation have I cancelled?
- Excel Linking
- InputParameters
- Need ActiveX control for JPEGs in Access 97
- Unbound Combo Box Record Selector Question
- HELP! Web update of memo field crashes Access, errors repeatable. HELP!
- ado recordset field becoming NULL
- MSSQL Views a tine problem they may help with.
- SQL DELETE and Me.Requery in Access
- any ideas for boolean yes/no field in table
- day of week
- Getting 2 counts() of 2 foreign keys
- Sorting or Grouping problem
- Any Add-on for this?
- Tools for access similar to Red Gate SQL Compare, SQL DataCompare and SQL Packager
- Need help with reports
- Random Record
- Need to overwrite a table that is already being used. Is this possible?
- Error after 380 CreateObject("MAPI.Session")
- Bug in Access 2003 ? Error after 380 CreateObject("MAPI.Session")
- Standardfiltern von Datensätzen komfortabel gestalten
- sharing data on acc2k
- Counting distinct Surnames on report
- How do I do this?
- DoCmd.TransferDatabase
- can this be done with one query?
- Year-to-Date Totals
- RUN Crystal Reports in MS ACCESS
- MS Access ERROR ! plz help !
- How enable Aligment and Sizing toolbar
- display messages
- calendars in reports
- Manipulating Date
- Problem.. Report?
- thoughts on table setup
- Criteria
- Concatenate multiple rows into one string
- Use result from Inputbox in query
- Security Challenge
- Help with a query
- How do I do this?
- The truth about SQLFetchScroll() and the cursor library? (ODBC / MS Access 4)
- Access crashes when adding linked tables to query grid
- pushing data from unbound text boxes
- Help with code
- Units Conversion in Data Entry Field on a Form
- HELP: Access record ID's corrupted by WWW insert and updates, memo field may be culprit
- Limit number of users
- VB Editor Error - desparate!
- Report From Table - Unique Records in Several Tables
- New Be Need help with date.
- Editable Views (Queries)
- Import Text - Problem With Limits
- problem of drawing round and others
- In-house server to WAN and T1 environment
- Snapshot Format not a SaveAs/Export choice in Access 97
- new to access, but not to visual basic
- Print the current record of a form
- Couldn't find file 'System.mdw'
- Gathering workstation data
- ODBC Driver for .adp
- How to Obtain the Height of a Form?
- Delete all objects from database other than tables
- How to Automatically Resize Form Controls When Resizing a Form
- Date problems yet again - sorry Gurus !
- Autonumber mess, figure out the number
- Stuff a string
- Parameters in QryDef in Acc2000
- Form error
- suddenly "on Error" doesn't work anymore
- how do you know where the call is coming from
- Detect adp connection state before opening
- To Complex of a query
- importing Data from access
- I Cant Return a Next Due Date based on two items of criteria?
- Reports and If()
- VB error: this will reset your project do you want to proceed anyway
- Sending a Form by e-mail
- Putting fields on the first label...
- Code : DoCmd.OpenQuery - and bring result back to form front
- Print report to .pdf
- How to Re-parent a Record
- Opposit of a maketable query
- Print MS Word Merge Document from Access?
- Change focus between Property Sheet and Form Design
- notification of upcoming date; filling in form letters automatically
- Het zal toch niet zijn wie ik denk dat het is?
- Determine Compile Status / Compile Target db using Vba
- Determine Compile Status / Compile Target db using Vba
- Importing data from text files of non-standard layout
- using access as a front end, building a stand alone exe
- PLEASE HELP!- Linking multiple forms to ONE record
- Date format confusion
- event sinking with Word question
- Jet engine install
- access 97.out of memory error..help. tia
- Help! Creating Reports Using Multiple Tables
- Access 97 vs XP
- Good source to learn ADO?
- Form Timer event fails to fire on heavy database access: Access 2003 bug?
- Accessing the New entry portion of an access form
- 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
- 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?
- Change Screen Resolution using VB
- Minimizing forms in a dll
- List Box on Form
- There was an error executing the command
- 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
- 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
- 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
- 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
- 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
- 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
- Open source alternative for MsAccess?
- Active Directory - Access XP
- Query to list near neighbours
- How to get directory for CurrentDB
- how to flatten sql query?
- Deleting Workgroups
- 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.
- ACCESS 2000 Question
- Add record to Subform when not on Mainform
- 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
- Missing Records
- break points in Load_Form event in Access 2000
- 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
- Computer Books, Inc MS Access Books - up to 80% off
- Could not find installable ISAM
- First Field in Multi-field PK of Linked Tables not displaying in Unmatched Query Wiz
- 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
- Unable to open / design saved form in Access 2000
- book on stored procedures for SQL Server 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?
- 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
- 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
- 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