View Full Version : answers
- UnitsToElement
- Problem installing Access 97 with Windows XP - "error occurred changing the workgroup database"
- Combo box jumps to values when duplicates
- Send to rpt before moving to a new record
- Subform datasheet selection
- Having Zeros Appear
- Problems with TransferText
- Network load
- Access 2000 - Open external table
- Openings in an online game company for database people
- Distributing Jet database engine
- MOD function
- Formatting Dates
- Mouse Wheel in MS Visual Basic window (in Access) stopped working!!
- Formatting Dates
- Formatting Dates
- Use Windows ImageList for program icons in treeview control?
- Build string variable
- MDE file shareware?
- Att: PC Datasheet - Please readf inside
- Turn off default menu bar
- fastest way to determine if any records exist in table?
- Problem with report trying to Duplex
- Convert .ADP to .NET?
- conditional on a form already being opened
- missing records from coded recordset when compared to qbe
- Table Allocation
- Running script before import
- Network resilience registry key for MS Access?
- Automatic update from Oracle db to access db
- subreport control reference problem
- DAP problem
- Using the Docmd to set another forms detail.visible
- Two multiselect listboxes
- Two multiselect listboxes
- access question / forms
- Text Box Values
- Create Access 2000 MDB from Access 2003
- Looking for help with Runtime Error
- How can I tell if file on linux box is moving across my LAN?
- Missing Query
- Using GroupBy, Min, Max, and Count in the same Query
- Download Code from an Internet Page....
- Conditional formatting problem
- Open WinExplorer from Access VBA ?
- Pictures in Reports
- SQL Backend/Access Frontend
- Access 2003 Edition
- Group Level Count
- SQL in VBA
- Problem with disconnecting
- Modifying subform makes query vanish
- combining duplicate data onto a single record
- 1:M with queries
- OpenReport with acDialog parameter
- Event Caller Question
- Break Default VBA Reference
- Syncronize two copies of a database
- Date() function problem
- Aged Debt grand totals in SQL
- Beginner Question: DAO vs. ADODB
- Variables in standard modules, single record entry wiht foreign keys
- You have a piont...`
- Excluding Previously selected Combo Box record to current Combo Box
- publishing a MS Access Database under one of the open licenses
- Access report totals
- Totally confused about Access 2003 Runtime availability!
- Where IIf and Datediff Statement
- Sharing Access *.mde file
- Subform calculated control
- Automatic Links in PDfs created from Access
- gotorecord help please
- Duplicate Records in a form
- mousewheel events?
- Counting Records
- Update one tab from another
- Newsgroup etiquette...
- AS400 connection AGAIN....
- Calculate totals from nested forms
- Updating a subform using a query
- Multi-User Access Database
- AllowEdits=false and OnKeyDown event
- Creating an Attendance Report
- Show more relevant field
- Scroll wheel on mouse
- How to call a function located in a form module (form open in form view) from an Access Basic global module?
- Timer events that must occur
- Excel automation weirdness
- Track Design Changes
- Help with Syntax on Webpage
- How can I find all instances of "tblCFClientChanges" in an Access 97 database?
- A2003 Help Font Size
- record template
- REPOST: Access 2000 runtime and record-level locking
- Accessing a non-primary key field from one table to another
- Accessing a non-primary key field from one table to another
- Accessing a non-primary key field from one table to another
- Accessing a non-primary key field from one table to another
- Follow up: Using Access+DBMS with >30 users
- Fill from Combo Box Selection - Speed Issue?
- Using Access+DBMS with >30 users
- merging tables/ deleting holes
- Creating relationships using VBA
- Table relationships and join type
- Autonumbers
- Rich Textbox Control That Allows Formatting
- Using Access+DBMS with >30 users
- Combining data from separate databases
- How to combine separate identical databases
- Direct location change
- Help with DConcat - Please
- Average by .25
- SQL Problem - Auction
- Counting group records
- 1 to many concatenation help!
- Date source location
- retrieve only part of text string
- AS400 connection again...
- Internet access behind win xp sp2
- tabbing out of a subform without knowing about the parent
- connect to AS400 using ADO...
- One backend or two?
- access database query HELP!
- Printing a photo from my form - Access 2003
- Select query truncates memo field
- Printing only the last....
- Default
- Problem retrieving printer information for this
- Starting Access program
- Incorrect Date posting Access 2000 SQL statement
- Help with opening form
- Access does not break on errors?!
- Best way to repair corrupted VBA code module?
- Print Log
- Creating a custom right-click "add then paste" item
- Form - won't allow input or new record
- Problems connecting to external data source
- dummy databases?
- Anyone still not upgrading from 97?
- ColumnHeaders
- setting CurrentProject.Connection in VBA
- Combo box behavior on continuous form
- ColumnHeaders
- Shared access to Database
- pass-through queries and parameters
- Cancel external process using event?
- Code is Wrong?
- Not getting value for second combo box "with" statement & Dcount help
- Help with Max Date please ...
- Converting Access 2003 to Access 97
- Can't open database
- Cannot find Macro '.'
- Help with... er... not sure how to describe this
- Sychronized Combo Boxes - Mystery of Missing Values
- Changing Access Charts Using Combo Boxes
- When is "db.close" needed?
- Help with automated sending of report
- Find Records with Max Date
- Problem with ODBC open dialogs under Windows 2003
- Import Specification Help
- sub totals in query
- How to combine Queries
- Parameters Not writing to table
- Textbox Value to Excel from Access
- Automate get external data to import a XML file.
- Opening forms with arguments through a Menu item
- form image background and tab control
- ComboBox Wildcards???
- Help! - How can I make a calculation using a previous record?
- Printing hyperlinked Word doc automatically with an Access report.
- Help constructing a query
- mde/ade security
- closed database
- edit a read only access form
- change lines to columns
- Remove Microsoft Access from task bar?
- Simple relationship question?
- Linking multiple tables alternatives
- autoexec macro for application access not a database
- Active X Textfile Layout Control Misbehaving in Access 2003
- Subform shows no records when Main form is filtered
- Updating field before append query
- Converting from Access2K to Access2K3
- Database structure documentation
- no object in control
- Access 2000 runtime and record-level locking
- Uniqueness of pair
- Form's Large Datasheet Optimization
- Counting Up With A New Twist?
- A2003: Functional equivalent of Excel's "Freeze Pane"?
- Create database in Access 2003 gets Access 2000 formatted DB
- Using "DB2 Friendly" Commands in Access Query - InStr v. POSSTR
- Macro at Starup
- export sql results to CSV file via VBA in access(PLEASE HELP)
- Update checkbox on a Continuous Form
- sql query - case sensitive search
- RNG code request
- Understanding custom events (and the TSI Compactor)
- Continuous subform -LOOP
- Format an Access 2000 Autonumber
- access97 runtime chart
- help starting with access please
- Should Debug.Print be Remmed Out?
- SQL Question
- ADO listbox form navigation issue.
- Updating field when click'ing the record selector in a form
- Linking a CSV file with a DB extension
- autonumber question
- Fantasy League Database
- Update option button value
- One question about report
- Show more relevant fields on report
- Prizes Query
- Access 2003 - Inserting A Quick Time Movie - Data Access Page
- Access 2003 co-habitable with Office XP?
- Print 2 of Each Page in Order
- Report Blank When Cursor is on Blank Line?
- Test for common values
- Global connection string to Access Databse
- Inserting more than one object into an OLE field
- run macro from outlook rules wizard
- Access 97 on Windows 2000 Server
- Calculation-Continous form
- Running an Access app on Citrix via a published application
- Query returning "error#" instead of zero
- repeating a record x times in a query
- How to test a bit in an integer?
- Related Subform causing duplicates?
- Join several tables in one query
- How to edit a non editable field ??
- FormFilter > ReportFilter
- Erratic behavior in combo box typing completion search
- Bit fields with Access97 and SQL2000
- Export to excel & format workbook
- Move file after import
- Context-Sensitive Access Controls
- Setting page heigth
- Alternate Record Printing Between 2 Reports
- Stop Importing of Tables without RWOP
- RTF word count?
- Packaging Wizard Root Directory Orca
- Access 2002 security
- "The OpenForm action was canceled"
- VBA and Reports
- Not recognizing multiple conditional actions within Macro - Help, please
- Access Datasheet - Subdatasheet question
- Autonumber of new record
- Show Menus/Toolbars on Startup
- Database documentation
- ControlSource and saving to table
- Using an OLE DB Provider's Functions in Code
- authorization at the beginning of transaction
- How to get a Gmail account
- HELP with date sorting in reports
- Binding controls to recordset with join
- combo boxes
- Open Excel from Access
- Domino VBA
- Domino VBA
- "Disk or network error"
- Allen Browne AutoFilter
- Form Help
- Access 2K MaxLocksPerFile
- Call the "Mail Recipient (as attachment)..." toolbar function in code
- print query name
- Error trapping ignored on second pass (DAO recordset duplicates error 3022)
- WindowsXP and Access97
- Future date displayed in a table
- Update append queries?
- Need to decompile to resolve references problem to mda
- Passing Data from One Form to Another-Simply
- It is Possible to Open A DBF File in Access
- Sorting Multiple Entries
- Resize OLE object
- Make A2K3 use standard Windows menu appearance?
- report parameter
- Stored procedures
- Access .ADP and Terminal Server / Citrix. Suggestions Needed.
- Startup, Tool Bars, Menu Bars, Shortcuts, DB Window, etc
- Problem activating macro within a form
- Adjust the heights and widths of multiple subforms without additional controls
- Form Unload/Close Randomness
- 2k Master/Child Not working in 2003
- conversion to 2003 and replication
- Importing from Excel, merging fields and Formatting
- RunCode macro
- passing subform argument to function
- importing form source code into access
- Query - possible to choose between 2 fields?
- Subform
- Access version recommendations?
- Storing updates?
- Access 2000 project connections
- Adobe Acrobat Install Kills Access Tooltips
- Nested query of sorts?
- Outer Join, cannot update issue
- calling a calculated field from subform to form
- Access' dStDev vs Excel's StDev?
- Hyperlink to Word Templates
- Access 2000 runtime vs Access 2003 compatability?
- Open Linked Table in Exclusive mode ( DAO)
- Help!! Combo box
- Query/Report Question
- link a webpage to an access database?
- Record Source Property
- This procedure nows fails
- My Form is not shown in Print Preview
- getting named constant values from ini file
- Etiquette Question - Calling reports from multiple locations
- Automate printing of each record in a specific filename
- Run-Time Error 1004
- Jet DB Engine and parameterized UPDATE query
- Data entry continuous subfrom strategy
- combo auto expand
- Installing A97 and A2002
- How I can attach to tables on another machine on my LAN?
- Updating Two Check Boxes on a Form from A Choice in another Combo Box
- Access 2003 won't open databases
- Breaking Out A Where Clause Via Code
- Retrieving the connection string for a linked table in PW protected DB
- Ms. Access database problem
- poor performance of update query
- Counting Up Until Field Value Changes?
- Anybody want an Access Server?
- Help with code
- Queries in Access 2003
- Problem printing Memo field
- OutputTo Macro in Access 2003
- Running Sum in a Subreport
- Caller ID
- Jet database engine and table LOCKS
- FindFirst with a Date Field
- Problem with bit - yes/no
- Form current crash
- Access crashes in the Form_current even
- Auto field entry
- ODBC Call error 3146
- Binding Results from UNION Query to Controls
- strange column names and DataType problems
- Counting Records Retrieved through Queries...
- Report, group by expression with string functions
- Sorting in Access?
- Preventing users from seeing raw data
- What library to use?
- Compare two (same parent) .MDE file
- Compare two (same parent) .MDE file
- Append Vs Make Table - Explain this?
- Yes(No Duplicates)
- Clear Control
- ASP page doesn't SUM amounts correctly
- Quickest Way To Find Out If There Are Any Records On Continuous Form?
- Subform: Can't move to next rec once something is edited?
- How to set maximum number of users
- Array Differences as Parameters
- intro to VB.net assignment
- Check For Duplicate
- Stop a running .EXE in VBA
- Average of multiple records based on similar date
- Required Field
- How to remove the first three characthers from a string
- a button to run a macro
- "This Action Will Reset Your Project"....while editing code?
- Problem returning a recordset from a Sub in vba
- Please help: automating get external data to ACCESS.
- Websphere Datasource
- date rent due problem
- Hide text boxes on a report
- Password-protect a BackEnd.DB/ma access 2000
- Code to export a table via E-Mail
- Recordkeeping
- Random alphanumeric string
- availability database
- Use Windows API within Access to change a file name
- need help with barcode 39, wil reward
- Form-Query-Report
- hospedagem de sites - planos de hospedagem - hospedagem 71155
- Combo Box Question
- Field names / spaces
- Filtering Non Numberic Results
- Differenza fra due date (completo)
- oracle backend connection
- how to create shadowed or etched text
- New to Access
- Form shrinks vertically
- Jet database engine cannot find......
- Link to MySQL datetime as text
- How is this accomplished
- Error trying to append user to groups user collection
- Limit Records Printed with Print Button on Subform.
- Columns vs rows
- Print Output
- OLE Bound Object Again
- MSysdb missing
- Access project locked
- Great News Blog!
- Lost compile in different PCs
- Lost compile in different PCs
- Display timer continuously through a long process
- a2k - where are all the icons?
- On Key Event Call Button
- Error values returned in query...
- Access > email thru outlook failed
- Cannot find the default system.mdw in Access 2003
- Autonumber problem Access 2002
- Database closes itself
- How many fields can I have in a query?
- Übersetzen in eine andere Sprache
- Find Record Button?
- E-Mail a formatted text attachment
- Damaged Database
- Query in Text Box
- Query in Text Box
- Sorting multiple fields in queries
- DoCmd.Rename strangeness
- How Do I Fix Hanging Wizards in Microsoft Access 2000 Sr1 Edition
- Change back to no on close
- Development Dilemma/Advice
- Populate a subform after detail.visible produces an error
- Combo Box Problem !!
- Default Value
- REQ: Formatting rows in a subform
- Simple Basic Access Form Solution Please HELP!
- Access 2K Error on combo boxes
- Invisible Combo Box
- visual basic problem
- SubReport Footer not Printing
- inserting records for multiple times and days
- Get values from .exe programm in "stdout"
- Access requires deleted table
- How, manage documents
- Oracle connection problems; Odbc call failed
- Microsoft ListViewControl, ver 6.0(SP3)
- ado connection with other databases
- Help for novice MS access user
- Office 97 Access Wizards?
- OLE server or ActiveX
- Access SQL Server linked tables, limited # of records
- Resize a snapshot control dynamically
- Running Subtotal of Text Values on a SubForm
- HIDE Access Close Button
- Count of records on Continuous Form
- WeekNumber?
- CopyFromRecordset to Excel Problem
- Hide Access Window
- Inserting addtional criteria before order by
- Access C++ error on Combo Box -- HELP!
- on current in report?
- Calculated fields - I'm missing something important
- ms outlook+sharing contacts
- Adding missing records based on certain criteria
- Up a Gun Tree
- Showing countdown timer on a form
- Median in a query
- Hide Access Window
- Open reports with a hidden MS Access application window
- Use a form like a toolbar
- ODBC problem.
- Using Excel VBA to Update/Modify Access records
- Reports - Displaying a chart based on a parameter type query
- automatic index changes
- Password on BackEnd.Db
- Virtual Primary Key = Slow
- Fix for broken linked table manager
- When should objects be closed and/or variables cleared?
- Report code - image load
- Stuck on Form Design
- access 03 query datashet view problem help
- DAO considered obsolete by MS
- listbox on tab control to update mainform recordset using ADO
- Writing null-padded data.
- On Current Event displays the previous record instead of the record pointed to
- New to Access-Grouping in Form Question
- Creating .exe Database
- Import Text
- Error message 3341 - field must match the join key
- Cannot use a standard module
- Joining Two fields to make one new field
- Applt Filter Woes
- wierd export excel apostrophe problem
- Updating a Form
- Filter a Subform
- Pivot charts in forms
- Details view disappears when converting from Access 2002 to Access 2000
- A2000 sp3 problem compacting large file
- Resync command ?
- Using the Format$ property to define a control
- need help fro sql query
- need help fro sql query
- need help fro sql query
- Count number of occurances in a report
- Access db design
- Simple contatination question for a textbox in a report
- Access db design
- autonumbering?
- HTTP 500 error _ ASP + Javascript
- OpenRecordset.
- Changing back to original System.mdw Workgroup file
- Security Manager Add-In error
- Short GUID
- View Optimization?
- Access 2K/MDAC 2.7 Bookmark not defined
- query results
- combo box selection
- sql query help! COUNT function
- Audit Trail
- Importing .dbf files (Foxpro) to SQL via Access client
- Create report from form?
- tough SQL question
- Force Word doc to use Page Layout view?
- Add fields to BE table - password protected
- Numbering in Access between two numbers
- Editing text fields in Access 2000
- There was a problem retrieving printer information for this object.
- passwords
- Problems with a form
- HELP! Using Multiple Queries
- Programatically set XP regional settings to UK
- spoolsv hogging CPU time
- Help with Excel Complex Formula
- access 97 application only works in 2000?
- Output Report into RTF format error 13
- MSI Setup Files
- Textbox in Unterformular disablen
- Moving a Tab Control during run-time
- Access front end to MySQL
- Data import - foreign key question
- Access treating Memo like a Text field
- VBA: Problem at saving an Excel file
- how pass value from a textbox in form to report?
- Invalid reference for subreport in Parent OnFormat Event
- UTF-8 conversion isn't implemented before 7.1 (#209)
- Command Buttons visible and hidden
- Microsoft Access 2000 maximum database size
- Simple list box
- table information
- Shell command and "BringWindowToTop! trouble. ANY advice welcome!
- Library for function fisAppRunning
- Time Calcalations in Access
- Pass Parameter Value from Form to Query
- Query results in a form
- table/database size
- ADP vs. MDB: Speed
- 1
- What is up with the Shell command here?
- Shelled Command Line Not Visible
- What is Me! and Me. ?
- Interesting
- How to use API code referring to Lib "user32"
- Control Container inside a Tab Control
- Prb: Mass emailing w XP Access+Outlook