View Full Version : answers
- Loop through Field names in code???
- Sum and Insert Query Question
- Help with (il)logic in option group/combo box/query
- Send To changes format in Access2000??
- Control + Tab between subforms on tab control pages ACC 2002
- extending memo field length
- problems with OpenTextFile
- Executable to close a 3rd party DOS window by name
- Any count distinct alternative ?
- Now() returning time different from system clock???
- how to change the form size in Design view
- Networking issues?
- Last selection with multi-select
- Package and Deployment Wizard
- Is it possible to programatically save a certain image from a certain web page?
- Parsing barcode data
- Append new records to table syntax
- SP2 - Access 97 issue
- Formatting within Access report text controls - OR - sorting and grouping in Word
- Northwind Database
- Error deleting record from subform
- Flickering form and subform upon insertion of new page
- Check to see whether a table exists
- Access Queries to a single value...
- MS Access 97 and DOS program to be displayed in a split window.
- how to export without the ID field
- sorting question
- PDFWriter and VB
- Arrow down - up causing move between records
- How to start a running sum from other calculation
- How to create a Calculated Field
- How to query database with multiple queries
- Datareport-How to query from MS Access
- Vertical scroll position of a rich textbox control
- Alt Key in Autokeys macro
- Page totals off by one record ? Please help :)
- 2002 Developers addition
- Filter=True & =Sum(Field1 + Field2 ...)
- avoid zeros in report
- Help with a lesson plan database please
- Adding new pages to a form
- Report from linked tables.
- Working with recordsets
- recordset
- Running procedure when I press Ctl K
- Retaining comment on form
- (rs.BOF and rs.EOF = true) but Record Count = 1
- Wy do these 2 SQL statements corrupt both form and crash my Appl.?
- Looking for ways to automate part-number classifying
- What is causing these 2 forms with SQL statements to corrupt when imported
- Indirect Lookup Field
- Access Data from a txtBox on a form using SQL
- Shrink Field
- Create Excel Doc with Access VBA
- How can we control the security pop-ups when Automating OPutlook from Access?
- Create circle on form
- Text File Export Issue
- Is it possible to disable security prompts for sendobject Faxing
- Searching Subforms...
- Columns and subreports
- Error 429 - ActiveX Component can't create object
- How to check check which control is active
- Tables and Relationships
- Access 2.0 -- Need Install Disks
- Can't Requery Subform
- Inserting client name and address in document
- Determining Future Date
- .pdf files and email
- Sending E-mail With Outlook
- Bound Combo Box on Subform displaying records with active status in list.
- faulting module
- How to Enter "" in a text box or field
- access to excel automation..problem: seem to have a hidden instance of excel
- DCount and Dates
- Landscape switching to portrait
- How to set Datasheet RowHeight with VBA?
- select all record starting at a null field where ever in the table
- aggregate functions
- how to fined a weekdayname of last day in the month
- Multiple Front Ends on SERVER??
- SQL count across two tables in a one to many relationship
- Access 2003 - Rename or Copy File Problems
- Specifying a printer in code - Access 2000
- Linked Table to Exchange (Contacts)
- Strange problems in A2002 SP3
- Forms Problem
- ComboBox - ChangeEvent - update Field
- Access 2003 corruption: is this one salvageable?
- Getting a Subform to Run Code Each Time It's Invoked?
- cannot test time values for equality...why?
- How do you refer to a control on subform inside a tab control?
- Query Should run but Data Type Mismatch error
- Quick SQL wording Question
- Access97 -> SQL Server - ODE tools
- Create a query to list which tables an item is located in
- RENUMBERING KEYS
- Error message numbering in Access
- bitmap
- MONTH TO DATE AND YEAR TO DATE REPORTING
- Help with query and list box values
- Sorry, ...
- ODBC Link to SQL Server fails every day
- DYNAMIC new page forcing
- new features
- Select Multiple Options
- Split List
- How to write link so remote user can open document?
- Not update record using Navigator in MS Access
- SQL question on summary
- Superior SQL Builder version 1.5 released
- Implementing Security
- Creating MDE File Unsuccessful
- Some features not installed A2K, will any CD work to add same?
- opening a form to display records
- Disable Hot Keys?
- Problem querying SQL Server View as mail merge source
- Subform Getting Parent's Current Record & VB Events....
- Where Clause Problem in SQL statement
- Form combo box question
- Form combo box question
- How to get text from ms-access module in remote db?
- Importing Excel with Quotes in Name?
- quicker query method?
- Time when database was compacted
- Creating table relationships with code
- Strange behaviour of an Microsoft Rich Textbox Control (6.0 SP4) on a subform Access 2000
- Database Limits and Error ' Error evaluating CHECK constraint. ' in the validation rule.
- Hour glass not becoming visible
- Combo box as lookup
- Function Returning Empty String
- DB DESIGN FIELD
- Having difficulty creating reports with query parameters set from form controls
- Sub-Form Object ID's
- References to Cardinality in index tables - what is meant by this?
- Access 97 and Recordsetclone
- Attaching to MySQL tables from MS Access - apostrophes { Chr$(39) } in memo fields are somhow expanded to a 4-character string ("'")
- Datasheet view
- DCount involving 2 fields
- Error #2202 Viewing Reports
- Orderby set by code causes stupid access 2000 behaviour
- Access 2003 and runtime?
- Duplicating Rows in Data Table View
- week number
- retrieving a value from a list box
- How do I combine records and fields
- default settings for search and replace dialogbox
- Rounding a number
- dsum in a query
- Limit of users in Ms-Access?
- Print OLE Object/Image Picture
- Adding times
- extracting specific words to different fields automatically
- Please Review Tables and Help With Query
- database structure problem - advice please?
- Close report by code help needed
- Mirroring Database
- Mail merge problem
- Access97 with SQL Server back end
- 5-Star Collector Error
- website doesn't clode using FindWindow()
- Access with Activex dll
- Mandatory on one side of one to many?
- Filter Combo Box List
- Reading comma seperated lists
- help with query
- not liking LIKE so much any more
- Looking For More Efficient Data Entry
- Query as data source for mail merge
- Asp Pages?
- initializing variables
- Automation
- Basic query help needed...
- Automatic inserts (given count variables from another table)
- Using a common DB with different versions of Access
- Filtering combo boxes in a form
- displaying recordset results from VBA
- Preventing reading of a lookup table Acc2000
- Make group header span columns
- Access to Indexing Service...can it be done?
- Please tell me the best way of doing this....
- Check boxes Access 2002 FE SQL Server 2000 BE update problem
- disconnect different frontends from backend
- IE Control and <return>
- Help: Date Fields
- Help me understand this sql code
- Importing from secured frontend
- VBA code won't step
- Simulate Network
- How to color tab of tab control when content of tab meets generic criteria
- Production tracking database
- Focus On Tab Control
- Corrupt DB
- Sort by a second field in a SELECT TOP query
- Upsize Database to Sql Server
- A2K Listbox Rowsource question
- Create file on web site using CGI from Access 97 VBA
- Help with wherecondition and wildcards in VBA..........
- Query Grid no longer shoes relationships
- Updating an Access based program, how do I do it???
- Copy date (date/time) to memo field
- Is Acrobat Distiller running?
- Access 97 on XP
- Report all records with date of same month
- MS Access with Pocket PC, followup questions
- ODBC connection failed
- Aligning overlapping controls
- Data Entry Form problem. Please help!!
- BeforeUpdate
- Tools\Macro\Security Window
- iexplorer will not close using vba
- Unlock MSAccess Database
- The Case of the Disappearing Relationships
- How do I connect two combo boxes in a form?
- 'group by' plus a specific action on form
- accessing data quicker
- Select primary key with import spec?
- Update data from a subform
- Crosstab Summary for Month & Year
- Book on database problem solving.
- Windows to Mac
- Microsoft Graph Chart in Access 2003
- customized locking
- access 2003: annoying customize a shortcut menu issue
- Access and SQL data
- get parameter detail onto a chart.
- List for Event order?
- access front end - changing dsn's that point to sql
- Open Word from an icon on the Access toolbar?
- How to retrieve column names in a table
- Non updateable view access 2000
- Terminate iexplore programmatically
- Syntax for multiple filters???
- Access to store images from the web which lets you paste them into Word
- send commands to barcode label printer with docmd.printout ??
- Adding a field to an existing table using a query
- Listbox additem Fehler
- linking to an oracal database??
- Subform going completely blank
- Help with Query
- Disabling Import/Linking
- Tricky VB/VBA side effects, and how to avoid them
- deploiement of MS Access 97 application
- export forms?
- WRITE #1 to a text file - MEMO fields
- not quite right
- Timed Messages
- Linked Table Password
- Custom Input Mask
- Is it possible to disable security prompts for sendobject Faxing
- Zeros not updating
- Access FORMS on Pocket PC?
- TextBox on Unbound Form Does not show complete data
- Need help with pass-thru and local queries
- ACC2000 - error 3197 occurs when supplying db password
- SQL Union question
- Table Linking Access 2000 FE / Access 2000 BE
- How to handle Primary Key violations in a bound form without causing and ODBC error.
- Refreshing a list box
- Using Windows Log-in in Access
- Setting button properties
- Command Button Code Req
- passing dynamic sql to criteria field
- EDI and Access ?
- Detect when toolbar button is clicked
- VB code to print on MS Office Document Image Writer
- problem calling date function from query
- Data Values not correct on linked table
- Highlighting most popular answer on report
- Open form to new record (autonumber is generated) from another form
- currency
- Converting Access 2000 to SQL Server (docmd.GoToRecord problem)
- List box output string
- Synchronise tables
- Getting windows user name
- Connecting to two databases with ASP /access
- DB Passwords and Windows Scheduler
- Tables and cascading updates question
- 2003 Package Wizard Problems
- "find" form: enter text, click button, show results?
- Assignments
- Getting the Sub or Function not defined error
- How to track monthly enrollment
- Access 97 to Access 2003
- Data entry subform in .adp
- Retrieve Highlighted Records in VB?
- Get Subform Selections from VB?
- Database query, part of records
- Problems with Registry Functions under A2002
- Jet 4 errors
- PREVENT run-time from overwriting the existing file associations
- I Cannot Copy Records
- How to eliminate nt integrated security option
- Enter default User Name & Initials for all users
- problem with autonumber-field in Access
- saving a record before a Close action -- "Me.Dirty = False" OR "RunCommand acCmdSaveRecord"
- User-defined type not defined
- Punkt 1231049 - Powalice
- a2k - validating excel file before importing
- Combo Box Row Source
- Access Linked Tables and IIS/ASP
- Hoiw to store text to the Windows Clipboard using vba
- mousewheelhook Stephen Lebans
- Blank Query Parameter Problems
- Using SQL to source email address list
- runsql vs Execute
- Ad
- Database Design
- Going mobile with PDA: Palm OS or PocketPc platform ?
- Queries with field names defined by a control in a form
- are Transactions necessary with Forms?
- Connect to filebased accessdatabase on other computer?
- Looking for an Access Programmer
- getting rid of a dodgy query
- Calendar of Events
- better VBA editor? Does anyone know of a better VBA editor for Access?
- Credit card authentication from Access
- Telephone
- How do I remove references to non-existent menubars in an Access 2.0 report?
- queries and sql
- SQL Problem
- how to know which is the current user logged on access project
- Query on a calculated date field
- loc files
- ByRef question
- How Can I fax directly from Access 2003 to MS Fax
- ByRef question
- Access 2003 with a 2000 database
- How to trigger a tab key press programmatically?
- bind a standalone recordset to a form
- Lookup List with Code Hiding?
- Error 3251 Operation is not supported for this type of object
- Changing form properties with a button
- Refer to a control by its index
- Control array on form
- going beyond blanket upper case conversion
- Access with SQL Server
- Declaring variables
- Comparing quarterly sales data to previous quarter and previous year.
- ZOrder or SetChildIndex in Access
- multiple records open with forms
- Check for Backup file before deleting
- MAX with JOINS
- VIEW Relationships Using VBA
- Reporting Problem !
- Listbox max lenght valuelist
- Batch updates based on form data entries
- How to mimic a doubleclick in VBA
- How to suppress pop up box.
- Prepare a number
- combo box select when opening report
- Object owner can't change security
- Controlling "Next record" button
- randomising for a quiz
- MS Access on PocketPC?
- Using Rich TextBox on Forms
- Acces 2003 Package Wizard with Developer Extensions
- How to get Bold letters in MsgBox
- Opening an external Access form to add record (not-in-list event)
- Calculated Field Problem Access 2000 DB and Access 2003
- Linked SQL Tables
- Acc2003 - acDialog form freezing
- Filter By Form
- To Access MVPs regarding Access 2003 Help
- DCount and DLookup with Date
- Code question in form?
- MS Access 97 Find Duplicates Query w/o the Wizard
- Filter Combo Box Using A Checkbox
- AutoLookUp wont save field
- Postcode Database
- PRoblems importing excel spreadsheet
- linked table after microsoft access 2003
- Datensatzleiste enablen
- Setting a value in a subform
- Access 2000 - Error 3426 "This action was cancelled by an associated object" - info
- startup for to be invisible
- MDE doesn't work on target machine -- Access 2000
- Manipulating TableDefs
- Sorting out the logic
- Intranet/Network
- How to terminate process with VBA?
- AC2003 Runtime
- Copy & Pasting AC2003
- "Molasses" for Windows LAN?
- Changing field names or setting field names while importing a range of cells from Excel to Access
- Stand alone database
- Access Application on a web page
- Prevent
- Access Parameter Query to Word Merge
- Final solution on copy a recordset?
- Modify DAO.Tabledef
- Images quality in Reports
- Security Problem
- Hyperlink Stop New MS IE instances
- Run AutoReport with Parms from VBA
- Yes/No Field Using Make-Table Query
- Need advice on Word Automation from Access
- milti column page layout report
- Problem cycling records
- resize only a record in a continuous form
- Advice on VBA Comment Style
- running sum
- ODBC error - linking to oracle
- Why is this so slow
- Securing a Backend
- Test for Nothing
- PDF Automation
- Export fixed-width file
- Open an ODBC connection in a jet workspace and which workspace is better
- Can I call a SQL Server 2000 User-Defined Function from Access 2003?
- Write conflict (Record locking)
- Queries for MSSQL Server
- access 2003: ftp question
- appending local table to remote table using pass-through query
- Calculation on a form and a report
- running total in query
- Problem using Access linked table in Visual Studio.Net
- Replication and memo field
- Need Proof... Need Help Access issues
- access auto email message body
- What's the next step...connect to db in web folder
- VPN - FYI
- Help with Queries
- query help with conditional summing
- Problem to print the value of a parameter on a report?
- What is the largest "auto number" that can exist in an Access database? How to reset autonumber to start at 1?
- Combo Box problem
- How to reuse a subform?
- Confirm Successfull Update of Database
- Lookup problems
- Copying MS Access object (Forms etc) using VB from 1 db to another
- docmd.RunSQL Update records in table how can I get rid of the "You are about to update" message
- Code to get phone numbers in canonical format?
- sql query
- Display only 1 item out of duplicates query
- Display only 1 item out of duplicates query
- Why 50 character fieldsize default for text field type?
- Script to Filter and Email Reports
- Mouse Wheel
- !!FAQ! for Date: 20040823 - New Users Look Here! [Last Updated February 05, 2004]
- Hiding a Group Footing while a report is running
- Linking Tables Problem
- List box Help
- trying to pass a field name as a string to a function
- access 97 to access 2003: query builder question
- Open MSAccess 2003 with MSAccess 2000
- Custom date format
- Can this be done in Access???
- Access 2002 and Sync
- Reports too wide
- Please help friends
- tricky access question using sql
- Expanding data - 1-5 to 1, 2, 3, 4, 5
- Multiples campos en uno
- Call me Mr Picky but ...
- Abnormal Programm Termination
- Copy a recordset will now copy - almost!
- Statistical Control Charts
- Calendar
- looping through records and updating specific records
- HELP! Working through the "Trusted Site" security "feature"
- Search Form and Access
- !!FAQ! for Date: 20040822 - New Users Look Here! [Last Updated February 05, 2004]
- Keyboard set focus in tabbed subform?
- COPY A RECORDSET WILL NO LONGER COPY!
- Duplicate Records Warning
- New Records to Several Forms
- Autonumber Replica
- Advice for Avoiding Critical Posts
- Advice for reacting to critical posts
- Acc97: Splitting tables
- Different users, different access using encrypted data
- looping through specific records and updating
- !!FAQ! for Date: 20040821 - New Users Look Here! [Last Updated February 05, 2004]
- Custom Menus being overwritten
- Dim me as stubborn!
- Query Drop box, etc Help will pay for your time!!
- Sending email from Access
- obtaining and then grouping by week no's
- Runtime Access 2002 (I need help)running on Win2K Win98
- Advice on database design requested
- Problema num relatorio ???
- Operation must be an updateable query
- access 97: queries
- Math SUM() - - Database amounts lack positive / negative
- New Records
- !!FAQ! for Date: 20040820 - New Users Look Here! [Last Updated February 05, 2004]
- Images on forms
- Drag and Drop from Windows Explorer to copy files from 1 directory to another
- Screen Refresh
- How to highlight textbox with the max value
- Build a reference to a control on the fly
- Referencing the Caption of a Custom Popup in VB
- Recent problem wtih dates in report - Please help
- SQL-Export: Access --> Access - How to make a SQL-File for Backup?
- e-mailing mail merged word documents
- One last command before DB closes
- A2003 - "Code May be Harmful" message
- Comparing Tables
- Identifier row in query
- The best (correct?) way
- carriage return in an expression
- Looking for the right CRITERIA!
- Runtime Error Win 98 Microsoft 2000 Pro
- Dates and enrolment
- Odd behavior of A2K app in Access 2003
- Insert Email Address
- IVR software for A2K VBA?
- SMTP Engine for VBA?
- Month/Year Date Format
- Update All Records in Subform
- Naming of subreport text boxes
- Stored Procedure Temp Table Madness
- How do I open a Report to a specific page?
- User Interface Conceptual Questionn - on right track?
- Calculated Controls- Recognizing change in value
- Dynamically Creating a form
- Creating PDF
- Disabling the <shift> + <enter>
- Form Print with changed copies
- Windows API ShellExecute in Access 2003/Windows XP
- Code a button
- !!FAQ! for Date: 20040819 - New Users Look Here! [Last Updated February 05, 2004]
- Process needs refining,
- finding duplicates with two fields....
- Pop Music Chart Database Template Needed
- Report generates incorrect results after first time
- Slidng windows in Ms Access
- How secure is my application???
- Query, drop box HEELLP!
- retrieve word OLE object from a table in access
- Performance drops after first lock
- Data Access Pages only work from local drive
- E-Mail Single Record in Access
- Set focus in a recordset?
- Finding if a value exists in a table
- DoCmd.OpenQuery Windows 98
- Null
- SQL To JetSQL Converter?
- SQL To JetSQL Converter?
- Table vs. Query
- Appending an s for plural
- Sum columns in Access table
- Architecture billable-hour tracking
- Newbe - Data Entry - Home/End/Arrow Keys
- !!FAQ! for Date: 20040818 - New Users Look Here! [Last Updated February 05, 2004]
- Trying to get file attributes from within Access
- No License on Access 97 - Now Out of Memory
- Data type mismatch....
- ? How to display result set in random order?
- ? How to display result set in random order?