View Full Version : answers
- Access 97 form sizes
- bound ole ctrl only displaying path
- adp and exec stored procedure
- Uncheck Read-Only attribute
- Creating Directories
- Determining Macros Security Level Using Code
- Unicode Compression not working under DAO.
- Importing Access database into Sql Server Express
- Code to check if form is open
- Allowing R/O users access
- A2K - update to field problem
- How to pass a filtered recordset of a form to a chart?
- Spread time accross day
- Variables in Shell Command
- Question about Yes/No selection buttons - can they be reset to "no choice"?
- How to copy the button characteristics
- I Need A Help With Auto Generating String (Access 2003)
- Event Trigger on Save
- ordinal position of fields in ado recordsets
- Changing Integer to Double
- Open word files using combo
- Pivot Chart
- Existence of Field Name in Record Set
- basic DB structure help
- counting records in open form after filter, trapping for empty recordsets
- Assigning sequential numbers
- Can i suppress Acess message ?
- Converting from Access 2000 to Access 2003, execute for a sql insert, update not working
- Water Trending Database
- A97: Setting form's Picture property to another file from within VBA doesn't repaint the form with new bitmap
- digital signature
- Access XP / SQL Server 2005 Express?
- Add a column to table based on formula & criteria
- Copy and Linking Access Front End to SQL Back End
- A97: Simplest way to limit unbound textbox to 200-chars entered MAX
- Error Missing system.tlb
- urgent req with our Direct Client
- change font size for data labels
- Horizontal Report
- Random error Message box
- Does associative array exist in VBA?
- Oracle 10g ODBC
- help with a simple query
- Is it necessary to use PLUSes in an msXML call instead of spaces?
- Does custom form property get reset?
- Selection Problem
- open recordset gives type mismatch
- Opening a PopUp Near the Button that called it
- Making control visible in one record only
- Update query on definite record(row) of table.
- Calendar Control 10.0 Missing Events
- option button help
- Where are A97 command button pictures stored?
- MS Access and Sharepoint: saving the username and password in a linked table
- database in state that prevents it being opened or locked
- Different colored words in a single label control?
- Referencing subform during module code
- Assigning numbers in batches
- update a lbl depending on whether check box is ticked or not
- help with updating checkbox
- Export data
- Write conflict
- Triple state checkboxes CAN be used with themed controls
- MS Access 2003
- Accessing my db remotely
- Using GetOleDbSchemaTable and Visual Basic .NET for MS-Access and SQL Server Express
- How to modify qryOwnerList to not show John Doe record?
- Advice on Courses
- Nedd help finding right course
- Query
- Update multiple tables from one form
- Addinf firelds to tables remotely
- Add rows in access subform
- Access to SQL
- City/County table
- Separating text by carriage return
- Memory Hogging by SQL-Access Database
- database server interfaces examples
- database server interface
- Enumerate objects in ADP
- database server interface
- Failure of OpenDatabase Method
- printing report in vertical using courier new font
- syntax error (missing operator) in query expression
- Flashing Forms on load
- help! how can i notify the user a films is out on rent?
- RWOP queries for back-end secuirty: easy/hard? slow/fast?
- In an object, like combo box, what is difference between "control source" and "Row Source"
- "ORDER BY" negtive decimal values bug hasn't been fixed
- open recordset
- open recordset
- A report with prompts, but without a query...Possible? Clarification Please.
- Error occurring in error handler
- database server interface
- database server interface
- Transactions in Access 2000
- Escape codes for delim characters in listbox value list?
- VB.Net code to upsize Access DB to SQL Express?
- Gantt Chart in MS Access
- After edit form, return to same place on first form...
- Horizontal Report
- openargs and security
- Difference between client server and shared access
- Working with linked tables
- Allowing certain users to administer users via code, and other security questions
- Updating checkboxes with the jitters!
- 1 to many relationship between columns
- Global Search over Multiple Databases
- Find/Replace error
- urgent req with our Direct Client
- Call call
- Contents of Form Fields not Displaying
- Ole Objects
- Keyword Search
- How do I find the remote DB's that link to my tables?
- Change Record Source on switching View to Datasheet
- Need HELP - Form Moving Around
- export report fromm access 2000
- Creating dynamic field queries....
- Advice: Export to excel causes access to hang.
- User queries and security
- Data Access Pages
- Is it possible to examine a system from within a VBA procedure to read and document system settings?
- Me.AddMode
- Selecting only one active record from multiple records
- Spot the Error
- Query - Mid Function & Mail Merge
- Calculating Opening Balance in a Report !
- Pasting table data to web page
- Figuring out the right query
- Cannot Save Imported Access XP Report with Linked Image
- Query Question - Combine records with same policy number
- Query Question - Combine records with same policy number
- Query Question - Combine records with same policy number
- ByVal call
- VBA collections question
- Seeking way to shorten this little code snippet...
- urgent req with our Direct Client
- Date Time picker revisited...
- Code to delete all queries not working right
- Dynamic Fields Report (Access 2000)
- Cant assign a value to this object ... when trying to clear a checkbox
- Dismissal and Google Archives (OT)
- Microsoft Access 97 Runtime
- Database connectivity with MS Access in Microsoft Visual Studio .NET
- A2K - MDE hell
- Relationships Report: how to print additional info about the fields
- How to protect
- Run Time Error
- Difference between Access and Access Project
- Help With Sub-Forms
- A2K - help with array search
- Calling a function
- obtain read permission by VBA
- Append query from Oracle Back-End
- Append query from Oracle Back-End
- MS Access iterators?
- Compact and repair back end?
- Access 2002 vs. 2003
- Office Developer Edition questions.
- Combo Box look up problem
- can't filter report in Access2000
- Report Trouble
- Proposal to change the name of CDMA
- Closing a form automatically if no records
- Button / Macro's does not work on other PC
- Search Function
- Great Job Board
- how to programmatical read the current sql statement if cuurent query ins't saved?
- ' More controls' empty
- Access 12 Blog's Latest Post
- Returning information on form used as a dialog
- How to restrict the number of records added to a table by a subform??
- Run-time error 3231
- clearing form after insert
- Databound list box populated with parameterized query?
- Runtime
- Access 2003 mail merge using DDE
- Global Variables
- Search Form Access
- Transaction Table
- DateSerial ()
- How do I stop the enter key from going to next record?
- What's "required" to get work in Access these days?
- Adding a field to a Form
- Is it possible to get the AD user group to which an Access user belongs??
- Return whole word for filtering
- ODBC not connection to database
- Help !! Form Moves to Unexpected Position
- Converting excel to Access
- You do not have exclusive access
- connection string sql server 2000
- How best to modify value entered into textbox on form during BeforeUpdate event code?
- Excel Output written from Access Form
- Is there a way to randomize or loop through a set of wav sounds--for fun?
- Microsoft Access has encountered a problem...
- PDF Printing
- Page numbering as function of grouping in a report
- Top Values for Each Student
- Sheduled tasks
- Forcing Wait or Delay ?
- Has anyone seen this before?
- Dynamic Query via User-Specified Fields
- Better way to lock VBA Project?
- Invoice Payment Query
- Access 2003: Problem running update queries on linked-in Excel Spreadsheets
- How could bytes be converted into ASCII in a secret code form for students?
- Change Indexed Property in table makes change the query behaviour:why?
- Could you please do this?
- Calculated Summary Field
- Access Blog does a Lazarus
- Comparing Multiple Dates to another table
- Replacement for Access 97
- Select from multiple queries/tables?
- Run time error 3231
- Creating monthly records from effective date records
- easy question on forms/tables
- Run a batch file from Microsoft Access
- Run a batch file from Microsoft Access
- .tab import quiting early
- Access and Outlook Automation
- User "lost" min max close buttons
- lock fields in DB with the content of other fields
- Documentation of Database in Word
- Different results in VB6 ADODB & Access 2003 (11.5614.5606).
- Proposal of Revision of CDMA newsgroup FAQ by Mike Noel
- Query into VBA
- Get the first in the row
- Using ADO to import Excel into Access Read Only - while file is open
- Need help with next step of creating Import Form
- Syntax error in insert
- Urgent req with our Direct Client
- Combine 2 tables into 1 virtual recordset
- DAP - What datapage?
- VB6 code to Lock access table
- QBE function for filling 11 digits
- msoControlEdit bug !!
- data access page
- ADO: importing Excel data while it is already open by another user...
- Lost and Found Database
- Anybody ever create a library catalog in Access?
- Allowing users to view only their own data
- moving to run time Acc 03
- Packaging an excel workbook and assess database to gether
- how do i get access to automatically fill in fields?
- Totals Report
- Error 2501 No-brainer
- Foreign Key not updating
- Tiered database help
- Login Form
- DoCmd
- How do I create a button that prints 2 copies of a form?
- Urgent req with our Direct Client
- How do I fix a corrupt database
- Help in report
- How do I pull only one occurence w/query?
- Is there some way to shut down Access automatically?
- MS Access Form w tabs
- maths on a form
- odd window alignment
- Network Login ID for "Created By"
- Endlosformular
- Primary Key
- Debugging Access 2002 vs 97
- Help! Access 2003 Runtime install problems!
- Links neben Daten einen Text / Grafik anzeigen im bericht
- Visible Command Button
- changing a control property according to record values
- A2K3: Can not see dialog boxes. Form hides them
- Access 2003 Runtime install hangs on Installing fonts
- Total problem in subform
- Macro error "Cannot update. Database or object is read-only."
- Date Serial Issue
- TextStream Object Write to File Fails When Field Text Contains Returns
- Day number to day name
- Forum Announcement
- Using "In"
- query question
- MS Access 2003 - automatically create reports/subreports based on criteria
- programmatically reading .pdf file attributes?
- Urgent req with our Direct Client
- Can't open db tables
- Unable to Edit Records in Linked Table (ISAM, MSA 2000)
- Count day of the week
- updating or replacing multiple values in one field
- Replicating and Synchronizing
- Someone must be able to help me with my ASP problem
- naming conventions
- UNION query not working
- Access Combo (Droplist) Not autocompleting
- Persistence
- Duplicates
- Passing parameters to queries using VBA
- Counting years and months between dates
- Call procedure with parametrs
- Hiding Data
- multi column foreign key and null values
- Help with listbox and append VBA
- Need Help with nasty query
- creating a date value from month, day, and year fields
- Values carried over from one record to the next
- Urgent req with our Direct Client
- Need help with output
- Edit a Query
- Conditional test to combine multiple records
- Creating an MSI file for an Access program
- Complicate report: how to sort out single records?
- String pattern matching with the VBA Replace function?
- select from a table the highest revision number
- Indexs and seek need help
- Lookup field in datasheet view
- Lookup field on datashhe view
- Lookup field on datasheet view
- set the caption of a field using vba
- Extracting date from dat/time field : help required
- A problem occured while Microsoft Access was communicating with the Ole server or ActiveX Control
- Repost - InetTransferLib ftp problem
- Print report multiple times based on value in the report
- drop-down feeding two fields
- Running sum problem
- Cant get into db
- Is There A Way to Pop Up a MessageBox Warning When User Changes Data?
- Cant get into db
- Pass Parameter to query via Report
- Simple join problem (I think!)
- Lock form on a record
- problems with a query or quaries
- mdb -> xls
- Problems creating an Auditing facility
- Lost menu bar in MS Access 2000
- custom button for next "non recurring record"
- Lost table design defaults
- A2K - how do I automate clicking of a checkbox?
- MS Access 2000 - Record data shifting to the right
- Creating a report with 3 tables in it
- how to know the table Exist in the db using dao?
- how to know the table Exist in the db using dao?
- How call procedure?
- Check on fields without a value (value Is Null)
- Hyperlink walkthrough
- Multi user design gaffe
- How to ensure accurate mileage expense calculations??
- Continuous Form !
- Problem with On Error Go to in Event Procedure
- Aligning number values
- Access 2002 Runtime Fails to End
- Choosing the correct event
- Report errors from a form to select names and dates with...
- How to prevent Spell Checker from cycling records?
- Expanding control size in a report
- Why do people do this?
- In some runtime installs of A97 databases want to bury a text file for future reference
- Function returning array of strings
- acOutputTable - cannot save output data
- Splitting string
- Append records into another database
- Padding string
- exporting data with commas separating the data
- Cascading Combo Boxes on Subform within Tab Control - Help!
- Syntax error (missing operator) in query expression
- ER diagram for...
- auto populate sub datasheet
- evaluating calculated controls
- Help with SQL query
- How to get value of Toggle/Check/Combo controls?
- Access 2003 & SQL Server 2005
- report print out is different from preview mode - please help.
- Can one open a xls sheet as a subform?
- query on memo field
- Access Development Freelance
- Enter Key behaviour - Access 2003
- Import XSD file to Access 2003
- Suggestions for creating new SQL Server backend from code
- too many fields.
- What is syntax for displaying a specific tab of a tab control upon an "on open" event of a form?
- Insert into validation rule violation
- Need help again!! Crazy Boss is at it again.
- Nedd help again!! Crazy Boss is at it again.
- How do I set up a report print routine?
- ReCONNECT VB code to Access DB
- ADODB.Connection - from ACCESS to Oracle
- Format dd-mm-yy not working (A2k)
- Me.recordsource in MS Access 2003
- empty table
- refresh not working
- Sum query: Data type mismatch in criteria expression
- sum query: Data type mismatch in criteria expression
- InetTransferLib ftp problem on some computers, not others
- How to output a text file with a page break
- Setting the form dataentry property via vb?
- Method Not Found, Access 97/2000 Conversion
- access to Access
- Query based Report in Access using VBA
- confused with events
- Arithmetic problem refresher help
- Visual Basic Issue
- Report Prints Too Small
- donor database for NGO
- Have on option group but need one of the option buttons when clicked to allow editing to a certain field
- AccessXP and Outlook question
- my DAO-made tables are invisible, not just hidden
- invoicing routine problem
- Strange notation from database
- access 97 - not enough memory to update display...
- MS Access Data Changes Not Committing Before Next Read?
- Print Word doc. from Access
- Access -> SQL Server
- Saving Spreadsheet to Unicode extra quotation marks
- strings
- strings
- Where to find info/samle code to draw graph in Access Form using MS Graph
- Convert Access dates to Oracle format
- import data MySql with Access from Excel file
- Handy routine for building an IN clause from multi-select listbox
- Pushing data from Access to existing Excel workbook using ADO
- open and print files with vba?
- Reading a SQL Server text field using a connection.OpenRecordSet
- Code examples
- Temp database wouldn't open from jump drive
- select cast syntax
- Sending Email Attachment, wrong Outlook Version
- A way to "hide" or not display a field when entire field is null
- Opening access database for exclusive access
- Focus mysteriously shifting from form to form
- Web Form Posts
- freeze of 95 database list of tables, queries, reports
- How to solve MaxLocksPerFile problem without changing registry settings?
- Urgent req with our Direct Client
- Table Names And Field Names
- Command Button And CMD Prompt
- Search for Field Name in Table
- Form sized to design window even though AutoResize = yes (Access 2003)
- attach files
- i'm getting lost/confuse
- Please, help me
- ADO Connection Open fails with error -2147467259 when MS Access database under Source Safe
- Runtime error wanting to be installed
- Graph - Null = Zero Problem
- Using Left Function in table design.
- Regional options: how to change from VB
- display a string as it is
- INI file perhaps?
- HELP Syntax error in sql insert into
- Command button help
- How to get form to display first, then run code on open?
- Rapainting a form
- Access 2003 security
- append table query help
- Creating a New field with input mask using DAO3.6
- Disabled Tools Menu
- How to Automatically Multiply number within the same box???
- Printing a Report problem
- Opening multiple instances of same Report - Update?
- auto number by category?
- Software to compare tables in 2 MDBs and update the design of 1 basedon the other
- Need to "normalize" table
- Using an option button to change an Event Procedure
- prevent summary from being only item on page
- stop form opening
- Switchboard
- Search within a file
- Selecting the Correct Field For A Query
- Toolbar icon via vba
- Using and If Statement in conjunction w/ Multi-Select List Box to Filter a Report
- problems by working with two different odbc connections
- ADO Connection Object
- Problem with Totals / Sum / Count ??
- Combo Box Freezes for about 10 Seconds
- Access 2000
- Access 2000
- Access 2000
- Error msg
- Linked tables manager in Access 2003?!
- Is there a stand alone installer for Access 2003 Runtime?
- Export unicode to text file
- Using OnAction
- Using OnAction
- can one pass more than 1 var to a form via openargs?
- How to get an installer for Access 2003 Runtime?
- Setting the isolation level
- Complex ComboBox Functions for Teachers
- can't be done - pane or very custom toolbar to appear as part of Access window
- variables and control boxes
- How to ensure record completed before creating another
- Increment by 1 if duplicate text value
- Updating field on a form from a sum of values field on a subforms footer.
- Updating a field on a form with a total obtained from another related table
- Dynamic Crosstab + Reports
- many to many setup
- subform won't display as datasheet
- Is there a record timestamp somewhere in Jet - and how read it?
- Count combination of fields in one table occurring in another table
- ????? Error: -2147467259 Method 'Visible' of object 'ComandBar' failed!
- Access2003 VBA code to e-mail being blocked to port 25
- pass-through query: reuse existing connection?
- Deleting table entries from MS Access db from just an entry via web form
- 3 questions regarding access development
- Flashing button in taskbar
- File type Data Source Name sample file needed - PLEASE
- How to take chart and paste it into MS Access Form
- Copy and Email database?
- Assign LinkChildFields property into VBA Access97
- Transfer data from one table to another
- Stacked Column Charts
- Is it possible for a query to accept values from 2 diff locations?
- Error trying to resolve synchronization data errors: The Replication Conflict Viewer (command line interface)
- ms Access 2000
- Assign value to variable from query
- Assign value to variable from query
- Save New Record - Tried all from prior posts
- Dual processor
- How to Pass Value from a Combo Box as Variable in Function
- generate age
- Change default controls in "stock" dialog
- Bill and Microsoft Making an Impact on Cyber Crime
- summing records
- memo records don't copy complete
- Report Size
- Dont show blank pages in print preview in report
- Is there a faster way
- total or sum function?
- Simple Query question
- Really confused about Digital Certification for Access Apps. Advice?
- Really confused about Digital Certification for Access Apps. Advice?
- Selection by non-alphanumeric characters
- normalizing help
- Populate combobox
- Replacing non-alphanumeric characters
- Need help designing an update query
- Understanding Recordsets
- Record selection with combobox and record navigation buttons
- Update query
- Disable Application Restore Button
- Open .pdf without warning
- A simple example of reattaching one table by VBA
- Variable # of columns being output by a Crosstab query
- Downloading large table
- Large text boxes
- Using Japanese vs. US version of Access
- Printing a record from a current form
- Drop List Question
- VBA question - how can i retain the double quotes from a text file after opening it through a recordset?
- Reference a field labels caption?
- Dynamic Crosstab...SOS
- Interesting Problem......... or not so for the advanced, lol
- Combining databases
- Could someone point me in the right direction to use DAO to list all forms, their textboxes and two properties for each textbox?
- Securing both front end and back end
- interesting question - module - chart - form
- calculated text box