View Full Version : access answers
- 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 ?
- Word form can link to Access db, as a data entry form?
- Updatable Queries using Access 2003
- 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'
- 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
- Are there any forms open?
- Navigating Records
- 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.
- Question on duplicates
- Distibute an application to many users -- Replication? MDE?
- Ask Password
- "Implying" entries
- Passing values between forms
- 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
- 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
- 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
- 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
- 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
- removing last letter in data for a report
- excel
- 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)
- Update Combos using vba
- Numbers in Listbox
- 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...
- Access vs. SQL
- Dialogic Board / Saving Audio files / Dictation
- Good relational database design
- combo box after update question
- Problem trying to replace a Form using the Macro CopyObject command.
- Help!! Calculations
- 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
- 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?
- Filters and sorts in datasheet view
- Open Access Maximized
- Fremdschlüsselbeziehungen anzeigen lassen?
- Parameterized Query
- Building a report
- Easy one
- Acc2K FE, SQL Svr 2K BE, Slow form display?
- OT - NewsGroup Personality - Gilbert And Sullivan
- nz function with where clause
- 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
- 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
- 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?
- 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
- MouseHook and Tab Controls
- Readable lables in a Pie Chart...how can I?
- 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
- 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
- Create Read-only file in MSACCESS
- Word files import to access database ...?
- how to refresh the "other" data base window
- Microsoft Progressbare V.6 how to use it ?
- Link To Selected Fields
- Running Access 97 on Windows ME
- invalid arguement when updating memo field -- size limit?
- Access VB6 Integration
- Please help
- Date Conversion From Text
- Determining Field Type and Loops
- BackColor On TextBox
- acting on null recordset
- Help with Function to redisplay a cost price...
- Publish to web, Local option only enabled?
- ? about closing this popup form
- value substutition
- One last question about using GetObject...
- Force Textboxes to new page in Reports --- Help
- Forcast Report
- Average Payment in Days
- Adding a column to an existing table with data
- Access 2000 and Calendars
- VBA Event Procedures in Form Module Lost Association to the Control on Form
- Wanted - report writer to access ms-access databases
- Creating a Timesheet
- Average Payment in Days
- requery problem
- Windows 2000 Server Listed as a User in an Access XP Dabase
- Access 2002 deployment
- LIstBox vs Combo Box for looking things up
- Forcing zeroes as beginning of Key Number (ie SSN or Zip) and SSN appearing as 2323E+08
- Table Relation Question
- Adding Records using DAO and variables derived from queries.
- time based message box question
- Is there a way to speed up execution of this code?
- Concept Question
- Code to duplicate records
- Help with pictures
- Calculate in Text Box speed
- user input to query
- Writing to a file with VBScript/ASP sometimes gets truncated - why??
- Advise please
- Outlook Express <-> Access97
- Help with dlookup required
- Access Forms flow--> Visio
- How to distribute app with Jet binaries?
- should this ng become moderated?
- Median in a Query
- Upsizing question
- Print quality varies with Access version
- Building an expressions where parts are unknown at design time
- References
- How to access a control through code?
- datepart to get mmddyy from date/time formatted mm/dd/yyyy problems
- Problems With Access 97 Falling Over
- MSDE 2000
- download data from access ????
- How can access desktop access database from my unitech pt930(s)
- Text criteria weirdness
- Web Enabled Access 2000 Database
- OnNextRecord
- HOW DO I ADD a vertical row of values in Access 2000??
- More getobject help, please
- Security Issues In a Multiuser Environment
- query to combine two tables
- Mapi Fails on MapiSession.Outbox.Messages.Add
- I Am Really Crazy
- Acess 97 toolbar help wanted
- Bibliographic formatted references
- Forms Format
- Strange "Mystery Record" Behavior
- sql server pass through query
- Supress Automatically opening modules
- Building ODBC Connect strings that work
- How to use SQL queries in a report????
- ADO recordfind help
- Can't compile anything????
- =Format$ field doesn't work after copying database to new computer
- Subtract one year accurately?
- Groupwise Email from MS Access 2000
- Calling a function, basic question
- How to know if instance is already running
- Access 97 less available records
- How to put a menu bar DIRECTLY on a form.
- How to print tab in the middle of string in a report?
- Backwards Conversion
- Storing Only One Value?
- Future of MS Access......
- 401K Account Fees
- Link Code Modules instead of Import Access 2000
- Check for a Date then do something....
- Payroll Hx Table and Reports
- "The field is too small to accept ..." error for a bound control on a form
- Update Query - Finding and Updating Maximum Order Number
- Sympathy for Starwars :(
- please help me -microsoft access help reqired
- function(s) to split an e-mail address into user and host
- getobject
- access 97: duplicates in query
- Editable mde ...
- Form letter question
- Form Controls Colors
- Import table
- Interland MS-SQL Hosting - somewhat OT