View Full Version : answers
- Second Database Is Slow To Open
- Order by an aggregate function
- Is it really so Difficult
- Convert MySQL Database to Access
- Updating query running from form
- Create Chart in Report
- Combo Box in Form (2 Tables used)
- Default Value for a field
- Copy at least 1 record or more from one table to another table within the same .mdb
- address fields
- Update field only if field is not null
- Combo Box SetFocus not working...
- help in access.
- GetRows
- Query Works By Itself, But Not in a Control
- refresh or requery form display on field change
- ADO teething problems
- Export tables from Backend
- Open Form B depending on the pk of Form A
- find and delete records in unrelated table
- Object dependencies on macro?
- Specifying number of enteries in a subform
- Writing conflict when record is unchanged
- Problem in Ms-Access Report
- Delete records on the basis of another tables contents
- Locking Records in Forms
- In Clause - to query text file
- In Clause - to query text file
- Prevent The Cruelty
- Use VBA to set or select a specific row in a bound combo box
- Access Project "Unviewable"
- If else decision making
- If else decision making
- How can I import 2 csv files into 1 table
- Multi-User Database Design
- access 2003 and sql server 2005
- Set Database Index in Access 2003
- Saving records to multiple tables.
- Creating forn controls with code
- Creating forn controls with code
- Hyperlink help! (Hyperlink pro needed!)
- Query
- Why Type Mismatch
- Showing details for one specific record / Drag and drop files to get a link to them
- constructing a database from downloaded newspaper articles
- BMP image to uncompressed PDF stream code fix
- SQL for comapre(exact match) returns more rows than the required rows
- Tough Select Query
- Problem opening form with selection
- Address Scrollbar?
- Compact BE while idle... so confused!
- How to find differences between datasets in a table
- Problem selecting max date
- Set an array to empty
- Reports with unbound fields #Name? error
- Problem getting Memo to a file
- Comment to the Microsoft Access world
- How to detect if current directory is on a CD
- Function SpellCheck_Field()
- Problems with Pie Charts on Access Reports
- Chr function
- current event not firing
- Populating an option group by recognising 3 digits
- Form Recordsets, Requery and FilterOn=False
- VBA Access - Moving parts of a program to DLLs? Error 91.. "Object variable or With block variable not set"
- Get text of User Defined Functions?
- testing a VBA game/ Hall of Fame feature
- A resaonable approach to managing data?
- Signing a form in access using a tablet PC
- How to open a report with a determine field (primary key)
- Electronic Forms software that integrates well with Access
- Milliseconds
- How to convert lowercase to uppercase in Access table
- Hotkey to run query
- access charts
- Adding a record question
- creating tabledef connection to login to ODBC dbase
- WINSOCK CONTROL FOR TELNET SESSION IN AN ACCESS FORM
- Clear Database and Reset the AutoNumber
- Creating telnet form in Access
- How do I overwrite table data with a CSV file data?
- Multi-user database table export
- Button size
- Print A Word File with an Access Report
- Basic Report Question
- Client wants to resell database
- conditionally parse a numeric field
- Access 2002 Debug stopped working
- Why the size become smaller after the fix of corruption?
- creating a new field with IIF
- MSComm and datas receive
- Application.FollowHyperlink - Trap Error
- Hyperlinking to a document from form?
- Add number of working or business days
- Multi-User Database Design
- WinSock Novice Needs Answers
- Adding the current date to the end of exported queries
- Access or Excel if You're Doing Lots of Charts?
- Openrecordset with criteria problem
- Suggestions for software for mass emailing
- ADO Update
- Sub-forms of Sub-forms
- Access 2003 connection to ERwin 4.1.4
- Update table via pop up forms
- Open a new Form with empty data (new record)
- Hotkey for duplicating previous record's value
- Cannot tab to new record
- IsNull anomaly
- ODBC Timeout - Where to start looking
- HARD-CORE GURUS ONLY - Early Vs Late Binding question
- Multi-user app on citrix
- Converting Seconds Minutes and Hours
- Splitting user input into multiple fields
- TreeView: How to select an item via VBA?
- Access-Microsoft Word Merge, avoiding blank spaces
- Input Mask Problem
- Einblenden und ausblenden von feldern
- Problem with Startup
- Authenticate the windows password through Active Directory?
- Automated import Excel --> Access
- SQL and Parentheses
- Access 2002 export problem from memo.
- Closing a Form
- Align scrollbar in Access 97
- Access Form --> Hyperlink to Excel --> Return to Original Access Form ?
- How to copy form: Access 2003 to Access 97
- comparing a record in one table against a record in another using VBA
- Presenting queries results
- Transferspreadsheet not importing some data
- Subreport displaying unwanted value
- Using text box to filter
- MS Access Textbox to textbox
- How to clean a form before input data
- Function to Prevent Open MDB via Access File Menu (Access 2000 AND Access 2002
- to show a recordset as table
- parameterised view sql express 2005
- Access value from Listbox to Listbox
- Performanceproblems with action Pass-Through-Query
- show the drive map and mdb
- MCDBA
- use ODBC to import filemaker file
- MS Access password problem
- Combo box with calculated RowSource
- Jagged Lines on Pie Charts on Reports
- Printing labels from Access
- Access 2003 Memo Field Cut-off in Report
- Network Efficiency
- How to Combine Data from multiple tables or sources?
- Please Help with database upate. New to database
- Calculated field based on values of different tables
- What is wrong with this VBA code?
- Help with VBA
- Help - AutoExec not running my Function
- Extract Text in MS Access 2000
- import LDIF file to Access using VB
- Form Design Question
- How to sort records on a form
- zoom in reports
- Problems with a query
- "country" dependency when importing into acces from csv file
- SQL Server, expressions can call code in modules??
- Matching a value from one form to another
- Application.CurrentProject.Connection
- Search Access Code/Modules/Macros in multiple MDB files
- Updated Front-End - Rollout procedure
- Export a txt logfile from access to excel?
- Can I use the data in one field as a variable in the other?
- Reminders
- vertical property of a label
- Choosing more than one selection in a list box
- Copy related sub records ............
- repair database password... Help
- Subversion and splitting apart MDB files for better version control in VBA for Access?
- Memo linked textbox showing first 255 characters only.
- tables and queries have an owner of "engine"
- Security - FE BE - Replication
- Problem with report
- How to remove a line from a tab separated file before importing
- How to corrupt a MS Access database file in a 'normal' way?
- New DB for me
- New DB for me
- "Invalid Operation" in Report
- Printing based on data from combo box
- Query with several dynamic fields
- How To Give The Client Peace Of Mind
- Update field value in MSysObjects
- Exporting to excel
- Data Definition Query Question -- Add New Autonumber Field
- PRINTING REPORTS FROM QUERY IN EXCEL
- Problem With IIf Statement
- Public Function Compile Error
- How to sort table with VBA
- Quotes, Tilde, Caret Symbol appears only when clicked twice !
- Interaction b/w tables and forms
- Background color for Tab Control
- Can't delete child record in access
- Access XP and Windows XP 64-bit
- can I reduce the number of queries?
- event/contacts/attendees
- Moving a PDF file from one folder to another
- Subform Acting Weird (again...)
- Access Project (adp) - Filter form and sub totals
- EOF and BOF Error
- Filtering Records
- DAO Connectionless Recordset?
- Query With Not or <>
- Distributing a split database: catch-22 on data MDB file location
- dumbest 2003 question of all time
- Is it wise to upgrade?
- AUdit trail
- Save an Array to a Table
- License
- MS Access continuous forms annd MS SQL server database
- Save the Lebanese Civilians
- Generating Word documents from access
- Lookup Fields
- Complex query with different conditions...
- Combo Box not displaying all rows
- Query for an Auction
- typing a VIN number into a combo box VS selecting a value from list
- Extract Numbers from Memo field
- Setting visible in a report? Or?
- sp correction
- Viewing more than 10 records in a dropdown box on a DAP
- display specific field content using combo box
- any body.to create a listbox with three item.by clicking first item form 1open,clicki
- Clearing multi-select list
- Passing fieldname to a subroutine
- Equivalent RunCommand for Records > Refresh?
- how can i divide large records ?
- Can setfocus on a field error 2108
- Appending Access records to end of an Excel file
- Concatenate records into single query
- Embeding PDF documents
- Access 2007 - Charts
- TreeView Control: How to force tb scrolled left?
- Invalid Field Data Type
- Incremental search w/ textbox and listbox
- BG color for Tab Control
- OpenForm only opens record with data if form has been opened before
- Required: Simple Detect Vertical Scrollbar code
- Calculate certain number of records
- Tab Control
- Picking the Primary Key
- Multi-select list as report data source
- INF: Cascade-to-Null relations are supported in JET 4
- How Do I Create a MDE from a simple database
- How to Running a windows command from Access VBA?
- Can someone help me with a sophisticated DLookUp?
- Invalid Field Data type
- Trying To Reference SubForm: "2467 Object closed or does not exist"?
- Soting a Query export
- Access Forms 2 Web - DMSoft Technologies
- Tab Control
- Transfer Text problem in Access VBA
- deletecontrol issues
- openReport over ODBC to Oracle
- form sum calculation error
- activex issue - document image viewer - access 2003
- Where to put code for form control properties
- Hope someone can help me with this...trying to keep invalid or dupes on records
- ODBC Call -- Failed
- ODBC Call -- Failed
- please help :) "on error resume next" does not work!
- Test Uniqueness and add to table
- "Microsoft Jet database engine cannot open the file..."
- cross reference query
- Who's my parent form?
- Accidental Replication
- Function is not available in query expression - HELP
- Delete query?
- Delete Field Content - Using Query or code
- Delete Field Content - Using Query or code
- How to evaluate data from the same table?
- report printing
- Subform's record source
- Archiving data
- Import text file to table
- MS Access data validation combo list text length restriction
- The OpenForm action was cancelled. 2501
- If Statement with multiple controls
- Chart with SQL source
- Auto selected / highlighted when focussed
- If Hidden BackEnd BE not found then supress error revealing its location?
- MS Access 2003 Find/Replace "Search field as formatted" checked as default
- Image Field Help.
- converting a 97 database to 2003
- Runtime Version of Access 2003
- Sample Databases
- Dates in three diff tables, creating correct report
- Can some one tell me where idiots should start?
- Whjere is a file created?
- Distinct Rows ??
- Query builder vs. vba for timestamp criteria
- ComboBox Data in a text Box
- Form based on query
- Open Report Action Canceled Error Message
- Dialling out from Access
- CInt function for text fields
- Exporting to CSV
- One or many
- Auto Select Combobox item
- Pulling data from another table, making link dynamic or static
- Object invalid or no longer set
- Access Reports, images, and faxing???
- When to make separate databases?
- multiple query
- Restricting details area
- 1st, 2nd , 3rd, etc
- Micro-pump is cool idea for future computer chips
- Null expression???
- filter or query based on user input
- MS Access query returns many rows in preview but 0 on run (execute)
- using query results to search by
- ODBC Max Length of Pass Through Query with Access 2k2?
- How do I figure out if a query already exists?
- Forms With M:M relationship
- Concatenate Records into One Record
- FOr some reason my hyperlink is not working.
- Dates in where clause
- Alter Table statment: adding foreign key WITHOUT referential integrity
- Query Question
- For database on the Internet, if not Access, what?
- Max Function
- Query: Adding record when source table is Null
- tricky form
- Does anyone care about DFS?
- Print Report on Exit
- sorting and grouping
- Form/subform problem. Tables not receiving all data
- Lookup field vs junction table
- Starting up in code view
- Primary Keys
- combo box
- Updating rights disappeared
- Not-operator not working?
- populating a sub form with data
- auto update field
- What's the best way to allow web updates to a MDB?
- accessing mdb files via java
- SELECT entire row containing MAX([Start])
- Obtaining handle to control object on a form
- Creating a date
- Wizard not happening
- Search a folder with VB for sub-folder names
- How can i delete a record?
- Open a PDF File from a form button
- Sort by date
- Referencing RTF2/ActiveX object content to Microsoft Word
- How do I save code result to a table
- Export Formatted Access Report into Excel
- Can app written in 2003 be converted to 2000?
- converting from A2003 to A2000
- Subform changes focus back to first record
- combobox set to a specific value based upon the text box
- Over 80 hours.
- How do I get min max from 100 cuts in one record?
- Click Yes program code for ms access
- Monday --> Sunday
- Partial "Replace" of a record
- Data display question
- problem with startup properties
- Create Table?
- Doesn't anyone care about scatter charts??
- Dates
- 1st, 2nd, 3rd, etc
- Using a form to search records
- Display values from one table in another
- Subroutines in a Form
- need a reference in my module..
- Changing a memo CR to "\n";
- Change Font in VBA
- Checkbox Issue
- Running a SELECT query from code
- Subform limit while using pages
- CASE Statements using SQL in MS Access
- update one form based on another
- Access slowdown...
- Table Relationship Problem
- Cascading listboxes
- Query-problem: Compare ArticleYearPrices of 2 years
- Loading 2 versions of runtime
- Problem with character ' in openreport link criteria
- Controlling Keys in REPORTS
- Partially clear form inputs
- Scatter charts
- onclick event
- Handling User Intervention whilst MoveFolder Object execution
- Combobox Item data selection
- wildcard searches
- Sample ADO application wanted.
- Importing specific worksheet ranges
- SQL design vs VB design
- sending a parameter from an access database to a DTS package in sqlserver
- A2003 Developers Edition
- Leban's calendar
- Save queries to create pivot table templates
- Complex Conditonal SQL Statement - how?
- Report Issues
- Application.CurrentObjectName returns no value?
- Not Null and ApplyFilter
- Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End
- Networking Access
- Close ODBC connection via code?
- Merging 2 Access databases
- SQL (or query question)
- Creating fields
- OnClick event works w/ command button but not image box?
- Make Table Query in 2000?
- What's the best concept?
- New User Needs Help with Dates
- Ms Access front end MS SQL backend
- Microsoft Office Developer
- CMDialog - File open - Multiple file selection order.
- CMDialog - File open - default view
- hide or move mouse cursor
- Speeding up my code
- Shortcut Menu becomes Disabled after an Edit in a New Record?
- Storing MS Office documents, .txt files, and .PDFs within a JET back end?
- database formation--relationship and forms
- Access 97 to 2003 General Question
- Hidden menu bar toolbar database window?? :(
- Searching subform.. :-P
- Many to Many record links within 1 table
- Help creating a query
- Delete Text File
- Multiple Parent/Child record-2-record links within same table
- calculating a median within a query
- Create a field for every hour between Time In and Time Out
- Case statements using SQL in VB Editor in Access
- I don't understand this at all...
- Code VS query gives different average
- could not update;currently locked > MDB is split and replicated.
- Retaining Default Records After Editing
- Help!! - report to show gpas between dates
- Öffne Datenbank
- Öffne Datenbank
- limit records in left table but all records in right table
- Excel to Access
- Deleting a table in another MDB
- 2 Weeks Ago (for date field)
- Runtime XP e Access 2000
- Field level permisions
- programmatically lock controls?
- Date field problem
- Report sub form filter
- How to prevent copying
- I don't understand this at all...
- Access 2003 user level security
- Populating field based on previous field criteria
- Stephen Lebans Calendar
- Creating a new database for items and quotes
- Creating a Item / Quote / Sale Database
- Vertical lines not printing or exporting...
- Subtracting Time
- Union Query
- Notinlist Onthefly
- Another Way to export OLE to JPEG....
- Entering data from one table into a field on a form
- sort report by year (weird format)
- javascript in a query's text string
- Audit Changes to List Box Items
- <<help>> with sql statements run from a macro
- Access 2002 Auto numbering key
- Creating a query in code
- Access 2003 MDW issue
- Listbox with time
- Importing a collection of Excel workbooks in Access
- Need Help For Comining Two Tables With Same Fields
- dimensioni Corpo di un report
- due valori da una casella combinata
- Legacy data in combo boxes
- Show/Hide ComboBoxe/s base on a tick box answer
- Sorting out the duplicates
- Problem with SQL filter
- Import Date Mask for Excel
- VarPtr() Fun
- How to remove or change title bar
- How to control the Access Title Bar
- splitting memo field at character limit
- Help with command "Find Next"
- Unable to design/preview a report
- Add and/or delete records
- display date numbers on report based on form
- How to close Acess
- Problem with Drop Down Menu and Subform
- Validation Rule Error
- If statement in 'After Update' event makes it miss other code
- Convert rows to columns
- Sub-Report Recordsource
- Need help with criteria for a query - want all records or selection from combo box
- Linked Table Manager
- Printing Problem
- Access 2003 - opening a form to show specific record
- Send an email directly through Exchange
- Excel to .MDB using macro
- The print current record on specific report problem
- Report Control
- Show time in scheduler?
- invalid field names when importing from excell
- Turn a query into a table
- Using a command button to toggle a checkbox
- importing xls with invalid field names
- "Invalid Argument" - 2gb isn't the problem
- "Invalid Argument" - 2gb isn't the problem
- Can I change a Label in a form on the fly?
- Bad Code Needs Help
- Switchboard Buttons quit working
- union query - strange unwanted grouping
- conditional autonumber ID's
- Calling up cost prices
- AutoExec - Action Failed
- Updating between two tables?
- Parameter Query Problem
- Help With Removing Filter Properties From Form
- Requery subform
- sql quest
- Problem in a form based on a query
- Tool to export MS Access forms, queries, tables, and (eventually) code
- Mail Merges in Access/Word 2003
- Problem finding sum of DateDiff Field on report
- Fill colour in field on a report
- Changing Text to Uppercase
- Appointments System
- help me please
- calculating date differences on dynamic variables
- Dates Printing 1906 instead of 2006
- Pass Through DDL SQL to Oracle Express via ODBC - Run-time Error '3003'
- Cannot see tables even though they are there
- Cascading lists problem
- Access "synopsis" function?
- How to Update 2 fields
- M$ CREATE TABLE DATE Issue
- CurrentDb in a DAO.Database
- 2GB size limit on Access2003/XP ?
- creating formula in access
- Copying Data from Access to SQL Server
- creating formula in access
- Experimental PDF Sketchpad A97 software available
- Help on subform.
- Report Formatting
- Two Questions: Seeing if my query is done, and creating a RTF/Word doc
- Complex query calculating sales - question explained
- New Technoligy with Jet engine (terminal service and MDB)
- Error for Linked ODBC tables
- MS Access 2003 Crashes when I Open Form in Design Mode
- Smoothly rename of buttons, combo boxes etc.
- How to approach combo box with by default upper most value focussed
- Conditional record navigation
- Problem with my time clock database