View Full Version : answers
- Exporting date data
- How does access store table data internally..?
- Form Timer
- comparing records
- How to multiselect a combo box
- summary reports/queries
- !!FAQ! for Date: 20040727 - New Users Look Here! [Last Updated February 05, 2004]
- Open Form From Table
- Another question about populating cells
- reading/using rowsource properties in VB6
- Can a pass-through query to create a table?
- problem with large databases
- Reserve Error(0)
- Referring to controls on closed forms
- Documentation of database
- Problem while opeing the Access DB
- HELP!Unable to run macros in ms access database FROM VB
- Windows Installer loads when i use my Main form
- Why can't Access create an ADP project in MDSE?
- Value required (sometimes)
- ADO Recordsets and Forms
- A humbly simple question...
- WeekOfMonth Function
- Help with Query to Return Different Records
- Simple (?) code in Access 2000
- Rename Windows Files Using Access
- TreeView: Now to maintain selection rectangle when it loses focus?
- A challenging query / report
- query criteria with wildcard
- New joined table added to query
- Custom "No Records Found" Message
- Graphic printing from report
- Writing form calculated values to fields in a table
- Seeking table matching time zone specifications with 5-digit ZIP codes for continental US and territories
- Problem with forms on Switchboard
- A2k bug
- No Records Found
- Which event to use to run calculations based off data.
- A97 Runtime on MetaFrame XP
- !!FAQ! for Date: 20040726 - New Users Look Here! [Last Updated February 05, 2004]
- Going to a specfic record when knowing the ID column
- inserimento su db su server tempi troppo lunghi
- Can you pause execution of code in AfterUpdate event?
- Multiple joins and an aggregate function
- Need some help with First Criteria statement or DISTINCT
- vba sql date issue
- Compare a list of values in ASCII file to a column in Access table
- Synchronization - help me please I'm lost
- Opening Schema
- SysCmd as late binding?
- Group By DateValue fails in Access 2K
- Loss of Data Converting Text to Number
- What is the Best Way to Copy a Recordset?
- Multiple Table Form Error
- Lowest cost migration of VBA -Access '97 accounting source code? To what?
- 2 forms
- Subreport in .adp does not work.
- in DLookup I get Error 2001 - says I cancelled previous operation. Huh?
- Multiselect listbox and SQL
- foutmelding
- COMBO BOX, FILTER TEXT BOX AND NEW RECORD
- !!FAQ! for Date: 20040725 - New Users Look Here! [Last Updated February 05, 2004]
- LONG POST: Class Module Property Let Statement "Hangs"
- Difficult SQL Query
- Combining numbers
- start a PDF - file from access (2000)
- lookup questions
- R+D+B+M+S minus D+B+M+S equals R, right? Or, am I wacko?
- How to sort records in a subform control?
- Flexibility in scrolling through continuous forms (no scroll bars)?
- Access Session logon problem
- Count Value Across Multiple Fields
- Access 2k/ XP code 429 problem
- making new field that combines three other fields?
- !!FAQ! for Date: 20040724 - New Users Look Here! [Last Updated February 05, 2004]
- Access 2000 and wav files
- Trying to create a database in a MS Access DB via JDBC drivers
- Use of INSERT INTO
- Access 2K/XP Report with subreport print error
- How to prevent delete ?
- Arnold Schwarzenegger Commits Suicide
- Open Form Problem
- Nested if - in an query
- Best method to selectively lock/disable controls on a form.
- SQL DDL to rename table and rename field
- TSI Soon problem with A2K2
- Regional Settings Currency Format
- Form Focus for search
- Database Query Help Needed Please
- Take the last letter off contents of form combo box
- multiple subforms problem
- Populating a second field based on what was entered in the first field
- Index Search using Seek
- Dynamic Query bombing w/ multiple users
- How To Position A TreeView?
- Radio Button or Check Box and Event Procedures
- From Outlook to Access
- !!FAQ! for Date: 20040723 - New Users Look Here! [Last Updated February 05, 2004]
- Finding "older" duplicates
- Using Access for crunching Phone bills
- Import Text Wizard Problem
- CDO--Failure transmitting PDF as attachment via email from VB, VBA
- Reserved error
- Acc97: Problem with Find Dialog and Sub Form
- Font CharSet - MSAccess Tables
- Requery Sub after update of another sub both on an unbound form
- Error "data type mismatch in criteria expression"
- Error "data type mismatch in criteria expression"
- Strip all non alpha characters from a string
- Order of elements after Split()
- 1 + 1 sometimes = 7.8
- form before update event
- Mutli-user Update using Recordset.AddNew and mutliselection ListBoxes - 3 questions
- MOD SR1 Installation Error
- datasheet mode
- Starting A New Project
- Week Numbers
- noob needs help with join/union/sub-select
- Unbound form throwing error on close.
- Setting a default date with multiple criteria
- Selecting from a master table based on info in a detail table
- Noobish Question
- Linking to Excel
- Parsing text from memo field
- Current Date Appears as 06/24/1894
- OpenReport and Subreport problems
- Is this query possible? Please Help!
- !!FAQ! for Date: 20040722 - New Users Look Here! [Last Updated February 05, 2004]
- Reserved Error (-1517): There is no message for this error.
- delete query
- Frequency Distribution
- Table Design
- For combo specialists
- Graph against "Operator Characters"
- How to set Row Source in Combo Box in VBA based on a variable?
- Bin type lookup in access similar to vlookup?
- Update an MDA file when converting to Acc2K
- select a number from a form, add 1 and write it in a Field on the form
- Access 2003: Message when I open database
- incorporating a search into a form
- Multiselect Listbox & SQL Server --
- CDMA Personnel Changes
- Populate 2nd list box from 1st list box choice
- Test for file to KILL
- query problem - recordset not opening / runtime error 3709
- DoCmd.RunSQL() not reading variable from combo box
- Combo drop down list anomality
- Formating Outlook Email Body from Access
- Multiple designers
- Multiple designers
- Mysterious disappearance of buttons in form view
- Changing query to access different tables
- Can this be done in a query? Probably easy for some of you.
- Adding New Field To Access Table
- filtering a form
- !!FAQ! for Date: 20040721 - New Users Look Here! [Last Updated February 05, 2004]
- converting access 97 to access 2000 and dao.recordset
- Can you check for Windows File-type Association
- TreeView Behavior: "The object invoked has disconnected from it's clients"?
- VBA doesn't recognize @ sign
- MS Access 2002 to generate flow diagram
- Requery / recalc / ..... How to update combination field content in form after row source table is altered?
- Linking between two tables
- Access 2000 to 2003
- exporting data to excel
- Obtain OS username
- Updating the current record with a popup form
- Access 2003 - Expressions in Textboxes
- REQ HELP: Problem eliminating duplicates
- lock records in paradox
- Prevention of form corruption
- Example of creating simple PDF on-the-fly from Access 97
- Updating table values through a form from another table.
- SendObject and Filename Change
- Reg: How to store text of length more than 255 characters in column?
- VB, Access and text file manipulation
- Primary key of SQL Server linked View in an Access Database
- Conditional command Button?
- Macro opens popup form but displays all records or no records
- !!FAQ! for Date: 20040720 - New Users Look Here! [Last Updated February 05, 2004]
- Nulls
- Phantom Relationships
- File Already in Use
- a2k - offering a Cancel option
- Indirect String Reference To Subform
- Return records where count is > 1 (?)
- How to Verify SQL Update Succeeded
- complicated expression
- SourceSafe
- Gif animate nei bottoni
- Trouble with line spacing and Can Shrink/Can Grow
- problem with dates
- Automatically entering table values through a form into another table
- problem with exporting a table and compacting/repairing a DB
- Security
- Access importing from oracle
- Memo text in report
- Problème access import successif
- Date & Time Picker Control
- populating a table from two listboxes
- Checklist Data
- Checklist data
- this recordset is not updatable
- Automatic VPN Connection
- Issue with visual basic syntax in HTML code
- Need help with Inserting/embedding functionality
- Terminal Server: Enough included w/MSDN?
- how do i automatically update a column list box after user enters two codes?
- Retrain Key Fields from prevrious record in new record
- Can I enter parameter values for a query into a form?
- Custom Autonum values
- Form programs allowing output to look like the orignial form.
- Update SNAFU with Access 97
- Sort Table; Then Assign Sequential Numbers
- !!FAQ! for Date: 20040719 - New Users Look Here! [Last Updated February 05, 2004]
- Include todays date as part of file name
- Multiple graphs on a report
- Averages / Formulas
- Relink table problem
- update/replace field data
- How to Count Dates with a Criteria
- SNPP Messages
- near duplicates
- Limited characters in a text box
- One form - 2 tables?
- Two Subforms on One Main Form Question
- Complicated Recordsource problem
- Probably a very easy-to-answer question...
- calling a macro/function in another database
- SQL statement to return n records after a time
- how to make a form stay on top
- Cannot update simple MSSQL join view in A2000, but ok in A2003
- Calculated Field in Access Query
- Anyone have a Meal Planner example? I wish to report a week's menu.
- Need help using datagrid
- Refresh on mainform/subform
- MS Access on Terminal Server.
- Maximum length of an If Then line in VBA
- !!FAQ! for Date: 20040718 - New Users Look Here! [Last Updated February 05, 2004]
- Is it possible to specify a specific printer in the vba code?
- Is it possible to specify a specific printer in the vba code?
- Dialer in AccessFAQ.exe?
- Continue to lock record in main form while editing subform records
- two nested select statements
- Faxing Reports on the Fly
- String Manipulation
- Systemically OutPut Access Report To PDF
- Wierd error when editing an Access Memo field.
- LARGE report problem
- Scrolling problem with php web page - problem with IE or PHP?
- How come I sometimes get this?? "Run-time error 3211: can't lock table. "
- Synchronizing Table definitionns in one mdb file with those from a second mdb file
- How to compare fields from similar tables
- Works to Access
- !!FAQ! for Date: 20040717 - New Users Look Here! [Last Updated February 05, 2004]
- I need HELP with error "Too few parameters..."
- where can i find a script
- How to convert php script to access
- Design Question
- is the byte on or off
- Programatically Enter Data Into main Form And Subform
- printing odd pages of reports / duplex printing in Access 2002
- Filtering text boxes from two comboxes
- Filtering text boxes from two comboxes
- Reset Field Autonumbering
- printing subforms
- update to second table?
- Division in Access does not match Excel.
- OPTIMIZING A FORM?
- DAO problem in Access 2003 - Can't find .Edit method for recordset
- MSACCESS.exe process does not stop when user exits Access
- Help: Using a Checkbox to Control a Date's Value
- Query based on form parameters
- How to go through a bunch of text boxes in a form.
- !!FAQ! for Date: 20040716 - New Users Look Here! [Last Updated February 05, 2004]
- What's the best way to do this in Access2000?
- Continuous Form locking after sorting
- Make active page name on tabbed form BOLD - A97
- Why can't I use Database object in code?
- Any suggestions
- Disadvantage of Access as front-end
- how to force form to load in datasheet view
- what event is fired when you move to next record in form
- Duplicates
- A validation rule question
- database for internet - compacting
- Need help with validation rule
- 2 quesitons about forms
- report rowsource query
- Mailmerge problems - how to solve?
- Which Code run faster in MS Access SQL or DAO
- How do I time out (auto exit) an MS Access 2000 application if no activities after a certain time?
- Rectangles on a form
- query problem - recordset not opening
- Processing Fees based on Percentage
- XML-Import in Access2002
- !!FAQ! for Date: 20040715 - New Users Look Here! [Last Updated February 05, 2004]
- Can't change data in query after adding table
- wifi hotspot directory available in MS Access format
- What is the best setup program generator for a commercial Access application?
- You'd think they'd have used ...
- Format a report with rows and columns
- Parameter query via value in form - driving me mad
- The visual basic for Applications project in the database is corrupt
- Adding Item to Combo Box
- Time isn't on my side
- Programatically Enter Data Into Another Form
- Copy data from subform1 to subform2
- Run Macros without MS ACCESS loaded
- Auto Data Entry
- split reattach code question
- Beginner Help Again - Queries
- Update combobox from table.
- Help needed with databases + asp problem
- Weird actions after upgrading from 2.0-2000
- Shareware documentation?
- FROM RELATIONAL TO FLAT
- Open Form WIth Calendar Control To Specific Date
- Custom message box on NotInList - don't want to add new value
- Report Layout Help Required
- Subform OnExit Not Enough
- Passing Value from the form to a report query
- Line 1: incorrect syntax near '!'. in a macro with asp
- calculating totals in a query
- ADPs /// idull thoughts
- Questions about Reports.
- Problem with Queries and Cartesian Product Joins
- Highlight the background color of data on conditions
- Limited Characters in a Text Box
- Reference Menu Captions in VB
- Dsum Use In Query
- !!FAQ! for Date: 20040714 - New Users Look Here! [Last Updated February 05, 2004]
- Filling in null fields from previous records
- Forms in Access
- MS Access to vb.net/ASp.net migration
- Entering A Transaction
- Pasting records in Access front end using MySQL backend
- Access2000 database on the internet
- how to improve the speed of reading from access using dao
- 2 tables 1 with duplicates
- 'Allow Additions' Causing Unexpected Results
- Automatically populate foreign key in query?
- Simple Access 2000 Query won't work in XP
- editing entries in a table using textboxes and a listbox
- Need some help fixing my UNION statement
- Upgrading to SQL Server
- Text File Export
- archiving
- Download Access templates
- a2k - implementing simple popup form to main form
- PivotTable and recordset
- How to Link MS Access Report in VB
- query help
- Horizontal Report problem
- Databases for translating English-French and English to Spanish
- select aus einer Tabelle in ein Textfeld
- Seeking freelance programmer for simple project
- XP - 97 lockup
- How do i set up a query?
- Acc 97 .Bookmark Property
- Filling null records with previous value--loop?
- Access 2000 Calculations
- GTRR; If no Related Record, Create New In 2nd Form
- Row-level security and MSSQL
- GTRR; If no Related Record, Create New In 2nd Form
- ACCESS 2000 - bad input
- Make Table query on ODBC table changes NULLs to empty strings in Access 2002
- Remapping the keyboard up/down arrows for tab stops
- Need a Search String Routine
- Wierd Query Question
- Display automatic update field on a form without being able to edit
- ** MS Access support in Unix ? **
- HELP
- Opening Backend DB faster
- Can access tell me if I'm using a table or query?
- Call Database in ADO For Table Linking
- Powerpoint from Access problem...any ideas?
- I need help from VB/VBS experts: exporting Access OLE object (Word document) to a file
- !!FAQ! for Date: 20040713 - New Users Look Here! [Last Updated February 05, 2004]
- Finding near matches
- Assign values based on Count(field_name) in query
- Server.CreateObject works on IIS 5.x / WinXP Fails on IIS 6.x / Win2K3
- The Year() Function and Update Queries
- date format problem
- A2K db is read-only for the others
- Automaticall linkin external Paradox tables - based on the pathnames.
- Using AllowSpecialKeys property
- Sub report
- Null values in a query
- Wie kann ich aus einem Formular aus Daten selektieren und in ein Textfeld schreiben?
- My FE updater - whadya'all fink?
- Subform Form.RecordSource inconsistent?
- Basic question on database size - does an empty row take up space?
- Beginners help for Mail Merge
- Correctly sum a column of currency in a report -- rounding issues???
- Cannot Set Bound TextBox Value
- Need Assistance with Error Handling
- HELP!: "Object doesn't support this property or method"
- Access database for rental properties
- Hyperlinks don't update with new record using VB code: Access 97
- Data loss in Access-97
- Hyperlinks don't update with new record using VB code: Access 97
- Problem Setting Value
- Problems with Setting Value
- Items included in one list but not in the other
- Online Performance - Snapshot Viewer
- need help on simple(?) query
- !!FAQ! for Date: 20040712 - New Users Look Here! [Last Updated February 05, 2004]
- Singling out fields on Continuous Forms
- built-in filter functions failing when form recordsource is set to recordset
- Menu Bar Has Disappeared - Can't Get It Back
- Timestamp - Digital Signatures
- Filtering form by combo box
- Timestamp - Digital Signatures
- Simulate "Circular Queue" structure
- Problem on a report..,?
- Full Email Address Outlook Access
- Access 2K - Read-Only Forms
- Trying to combine Two queries into One Query.. Need Help!
- Function to determine if form is loaded returns strange value
- ADP Test (Multi-Posted)
- Menu callback function in Form's code module
- Count query - how to use the result in VBA?
- 1 x front end & 3 x back ends
- Global Variables and Terminal Services
- Addition von Zeiten
- Licensing and availability of VBIDE
- Accessing MS-Access from Solaris and AIX
- PFS Professional File System 2.0
- Filtered by form - differences between totals.
- How to add long items and scroll bars to combobox?
- Next / Previous Record Buttons
- Changing rowsource when dropdown the combobox
- filter adp report where record source uses aggregate functions?
- Access 2000 - Field Color Changes
- !!FAQ! for Date: 20040711 - New Users Look Here! [Last Updated February 05, 2004]
- Need to return latest record when there are duplicates
- Combobox lookup function gives syntax error
- Page Break in Report (Access 97)
- Subcategory lookup tables
- Please Help With This Access Question
- distinct + sum
- one to one relation
- distict and sum
- Limit result set to top 10
- Are Access 2002 and 2003 compatable
- Access 20003 and 2003 compatability
- populating a combobox
- Excel automation causes runtime error 1004 on second attempt
- NORTHWIND questions
- Is access suitable?
- HELP...Exporting/Extracting an Access OLE object (Word document) to a Word document file
- How Do I Transfer Data From One Table To Another
- Combobox Question
- !!FAQ! for Date: 20040710 - New Users Look Here! [Last Updated February 05, 2004]
- Mouse Wheel Subforms (again!)
- Ambitious report idea......... "Favorites"
- cdo scheduled task runs as user1 but not user2 ?
- select aus einer Tabelle in ein Textfeld
- Update query help
- Searching for connecting access to the web
- Resources for intermediate user?
- Assigning Default Value
- Close Button
- Load event of active form fires when Access closes
- REQ HELP: Upper Case "C" replaced Lower Case "c" in Table
- Query textbox value on a form
- Upgrading to newer version
- DCount question
- using control source on query result
- !!FAQ! for Date: 20040709 - New Users Look Here! [Last Updated February 05, 2004]
- selheight question
- Editing object description properties with VBA
- Opening a word document or PDF file
- what sql string has to be?
- Synchronizing Microsoft Access
- Same date data for 12 months how?
- Two questions about Access 2000
- record update to a record in another table..?
- Secure Database Systems
- Importin a MySQL database into MS Access
- Update query doesn't work
- Error 3197: Deadlock?
- Best way of updating a table, based on the results of a query
- simple email from access
- Calendar Control question
- 1 ZIP code 2 Cities
- Report CAN GROW problem with Memo field
- Search Multiple Tables at once.........?
- (dhl) Exporting Table to Excel
- Update query in access - based on data in different table
- Access 2000: how to create a query based on a form parameter -- Please HELP!!
- Access 2000: How to query the fields in a table
- Access Query help!!
- Revisions
- Talking between forms.
- Default Value set the same as last valus for field
- Track the User logged in the Shared MS Access Database
- Email from Access to Outlook express
- Listbox problem
- User Level Security - Change of password...
- Help - Date Tracking
- Search for text in a text field
- Updating 2 tables in 1 to Many
- can't sort after filtering
- filtering form by combo box not really working
- 'Password to view project properties' in MSAccess 2000
- long strings in vba
- how to pass recordset object to procedures/functions?
- VBA - MailMerge error 2046
- Error 2427 upon opening a form/subform?
- The Expression "On Load" you entered....
- Please Help Acc97 Database has Got the Better of me
- Importing dates like 01JAN2003 from txt file
- parameter querie basics
- Access References Using UNC
- Unknown function Date()
- Winzip (wzzip.exe) via access
- Printing Properties
- Access 97 Report crashes under Windows XP but OK on Win2K
- how to track object modifications
- "one user account fits all" in a secured database?
- How do I group weekly dates, based on a Calender Table?
- Forms using linked tables fail
- !!FAQ! for Date: 20040707 - New Users Look Here! [Last Updated February 05, 2004]
- Difficulty with combo box selection TO keep cursor focus
- vb.net and stored procedures on SQL Server 2000
- How could a three dots become a bolded vertical line in a textbox in MS Access 2000?
- Can't edit the results of a query
- A2K: Report formatting issue grouping on "Fld<>'Value'"
- check for identical input
- database servers rent
- whitespace string as primary key
- Multiple queries in a combo box
- query group calculation
- Simple Query Help
- Insert new data in subform
- Runtime Security
- Query table by the date
- Condittional formatting
- If blah blah blah #AND# If Not blah blah blah produce same results. Why?
- Help needed w/Runtime, XP, and "Can't be started…" error
- a2k - creating salary totals
- SendObject creating 2 attachments WHY?
- a2k - creating salary totals
- Farid writes:
- Output Excel File (dhl)
- Hyperlink captured in e-mail
- scrolling through report
- date query