View Full Version : access answers
- can I reduce the number of queries?
- 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
- Passing fieldname to a subroutine
- Clearing multi-select list
- 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
- TreeView Control: How to force tb scrolled left?
- Access 2007 - Charts
- 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 to Running a windows command from Access VBA?
- How Do I Create a MDE from a simple database
- 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
- activex issue - document image viewer - access 2003
- form sum calculation error
- Where to put code for form control properties
- ODBC Call -- Failed
- Hope someone can help me with this...trying to keep invalid or dupes on records
- ODBC Call -- Failed
- "on error resume next" does not work!
- Test Uniqueness and add to table
- cross reference query
- "Microsoft Jet database engine cannot open the file..."
- 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
- wildcard searches
- Combobox Item data selection
- 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)
- Audit Changes to List Box Items
- javascript in a query's text string
- <<help>> with sql statements run from a macro
- Creating a query in code
- Access 2002 Auto numbering key
- Access 2003 MDW issue
- Importing a collection of Excel workbooks in Access
- Listbox with time
- 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
- Deleting the Values in A Field for All Records
- complex Query help
- Software looters cause loss of VAST amounts of wealth!
- Computer Industry Workers May Face Cancer Risks
- Build Shortcut Menu missing in Acc2000
- better syntax in A97 statement
- What Does a Valid Date Time Format Look Like?
- Convert Text String to Actual Date/time variable
- findthis.info
- validating form fields problems
- More on "cannot open another database" error
- Microsoft Forms 2.0 TextBox
- VB and an Access 2003
- Create a multiple parameter search form for a query
- fraction number format?
- Sending a Pivot Table by Mail
- Where Clause in OpenForm statement
- Monitoring Record Alterations
- access linked tables causing crashing
- US/UK dates problem
- List of all table names beginning with "ABCDE"
- SYNC Form to listbox
- SQL to find minimum value for each Distinct record
- New job Access 97 help please
- For...Each statement?
- Can anyone help me on a data table problem?
- Parameter Data Type Problem
- Looping through continuous form
- Optional criteria in query
- data in url
- Flag particular dates
- checkbox text to yes/no
- Why?
- Sample Access Databases
- report sorting
- Access closes when activating vba code
- How do you count the similar data in MS Access
- How to shut off ALL Menus ?
- .bak and .mdb file - corruption
- SQL Query.
- Display Current Month in Query
- Mailing List needs CASS certifying or Barcoding
- Import and append spreadsheet with multiple tabs with button
- RecordSet and SQL Insert Query Trouble
- Using a module to refference/control navigation buttons on a subform
- CopyFromRecordset Error
- Query by form
- How to open a QUERY made in MSAccess2002 in VB6?
- Painting the MDI Form with Desktop in VB6
- Exit Button for Switchboard in Access 2003
- Subform not displaying due to missing record
- cutcopymode
- How can I enlarge the size of colume in Access?
- Run-time error 91 Object Variable or With block variable not set
- Returning the range of a particular time
- Runtime Error 3061: Too Few Parameters expected 1
- How can i convert foxpro tables into text files
- Lebans monthCal on subform
- programmatically disable "Show Window Content while Dragging" How ?
- Modifying the Window menu
- Custom Format - QUOTES - blank when 0
- Creating a quote comma delimited .txt file from Access
- Getting a Total from a Single Table in Access
- Bug in subform's Record Source when field added
- Custom Website/Database Design
- How to make a value list's rowsource to reflect records in a coluimn
- Doing a lookup with a small local table and a large ODBC table
- report record source
- Help with report templates
- Need help with an SQL statement
- highest percenatage
- Linked Table Manager
- Slecting Max Date from 1 table
- Can I disable the "X" for the application?
- Normalizing a recipe database?
- Modification of Title Bar in MS Access VBA Application
- Using orderby with multiple fields
- Accessing rows on a subform?
- Open mdb in non-exclusive mode
- Large Text field
- middle tier discussion
- Probably a dumb question
- What is CRUD?
- What is CRUD?
- Mail Merge problems using Word 2003 and Access 2000
- Automatically "fit" query design view table/field grid columns.
- Update currency field
- "Sharing" two tables
- Can only see partial tables without old link
- Unbound form and subform used for new record creation
- Order of subreports on main report
- MS Access reports to XML to .NET
- Combo box question
- Transferspreadsheet - simple question
- Report Help
- suppress Zero in Charts - MS Access
- Question on Mail Merge with Shell Command
- Find record - Simple problem
- Help......replace Access with a .NET front end and SQL Backend solution
- automatic graphics in forms
- two sets of data in one query
- Display of Total work in Seperate display field
- MS access form problem
- Totalling subreports in main report?
- remove first characters of variable
- Better way to update two tables ?
- Field calcuation with an included yy
- Question on Variable in Access
- default printer on toolbar in access 2002
- Problem on using SQL in VB6.0 with MS access Database
- Access Automating
- button on a data access page with more than one function
- Access 2003 and SQL Server 2005 Express
- Can't figure out the right Table Design
- ALTER TABLE syntax?
- Two questions
- Access Front End to MySQL Database for Reporting
- Largest Values & Count in MS Access
- Default to Last Record opn a Form
- Problems with SendObject after Upgrading to Access 2007
- country settings
- Using VBA to Link a Directory of CSV Files
- Need Command Button to Bring up Pivot Table
- Need Command Button to Bring up Pivot Table
- Need Command Button to Pull Up A Pivot Table
- Unable to set .SubDateSheetName=[None]
- Split Time
- iif expression in multiple table query
- Using SQL Server as the backend
- Sum problem in Two Fileds
- Export truncates field of "memo" datatype.
- Check if record is saved
- Time Problems
- access -> excel
- several look for only one look for field!!
- Microsoft Access User level security wizard
- a sql query that doesn't return any record (performing date comparison)
- group by similar columns and append others and add new column
- Comparing Combined Columns
- Help: Search form and fill in record for that field
- Does anyone have any utilities to help with dashboard/switchboard designs?
- Database corrupted error
- Repeat Header Section
- Orderdatabase - Difference in sale from one year to another - SQL?
- OT Windows Vista and requirements
- Left Join with criteria (long msg)
- sql script
- /repair from a .bat file - access 97
- SQL headache
- how to link to a back-end .mdb file on the net
- combining text fields results in number
- Automatically increment a value in a report's textbos or label
- Correct syntax for Function
- Help!
- Migrate from MS Access to SQL - the easy way
- Need help combining some fields
- Add Option to OptionGroup
- Write Conflict: Form / Subform
- Transpose a Report
- Change tab control background color
- Help with Error
- Access Queries
- Read only records when a form is open!
- DBA or NOT
- Informal Poll: Access v. Other Programs
- MS Access using MySQL
- check for null in module??
- Append ADO recordset to table
- Calculating between dates on separate records
- Smooth Refresh of calculated control
- START UP FORM, PAYROLL AND CURRENCY DENOMINATION
- Access Causes Permanent Problem in MSWord
- Security problem
- Date format in update query
- Batch Import text files to Access
- Pennies problem
- Passing data to URL
- Pivot Table to Report
- What is the data type for an auto number value?
- report address formatting
- Slow With Multiple Users
- VBA Code
- Auto add of date to Subject field when sending email
- VBA Code
- Default Value Autoincrement within a Subform
- link microsoft word title to a value in access
- I need a shove in the right direction...
- LEFT JOIN question
- Grouping several reports together?
- copy and paste multiple records
- Reports - Showing Rows when there is no data
- access97, is there an event triggered when you undo the contents of a field
- Associating a color with a field.
- A form to enter report criteria...(couldn't think of a better subject!!)
- Suche innerhalb eie Datenbank
- Looping, extracting and emailing?
- Report IF
- Combining multiple tables into one table