- Send Object
- Using VBA for manipulation of files
- Concatenating Memo Fields
- Current Security Group
- TransferDatabase
- Re: Access 97 and Memory
- Changing the seed of Autonumber ?
- query parameter problem
- Authenticating Against Active Directory?
- Create a list of tables
- MaxRecButton Error when exporting Macros
- Re: Making subfrm fields visible (can't make it work)
- On Click Refresh
- Microsoft Outlook 9.0 Object Library
- protecting code
- Palette Source
- how to add a query in onclick event to a command button
- Combining data
- Arrays, multi-dimensional
- Cumulated Standard Normal Distribution in Access
- Integration with Word
- Storing values back into the tables
- Report Error
- from access 97 to access XP
- Data access and Domain Functions
- Check Box, Select All, De-select All.
- Saving the back-end with a new name
- Creating automatically different export paths
- Re: Automated email
- All fields
- Error 2001 Canceled operation
- Passing Parameters to a Query
- Get size of file
- Last Modified Date
- "Method 'Connection' of object '_Current Project' failed. -214702
- Using the pipe character in a T-SQL statement
- DAO SQL INSERT INTO - Syntax?
- Access 2003 - Security level - "how to" sites?
- Adding Sound
- Paramer queries
- Updating Links in External Database
- Re: Manipulating Microsoft Office Spreadsheet 10.0
- Home-grown Functions: Use In Queries?
- How to get a default value from a user?
- Function to convert dates to quarters
- Hide Database Window All the Time (VBA and Set Up Config groups)
- MSYSobjects
- Running access from VB
- Format Text Box
- accessing adress book from Access ?
- export from Outlook to secured Access database using ADO
- Match Query
- Linking Tables to a different backend
- Using a query field to change the propery of graph symbol
- Accessing multiple Access databases
- Form Query for path & filename
- Calculated Field?
- The field X cannot contain a null value because the ..........
- Null Field Values
- Import ODBC table using VBA code?
- How Can i create a function that returns the case of a word
- Field dynamically updates next field
- QueryDef slow down query
- Change Destination Table in QBE from VBA
- How to Create an Audit Trail of Record Changes in a Form
- Looping until EOF
- Forcing a ReQuery
- Pareto Analysis From A Chart
- Repost: Combobox with time values
- Fixed positioning
- Disjoint reporting
- What information does the API GetVersion() return
- Creating a Totals Datagrid
- simple insert statement not working...HELP!
- importing qry as tbl
- hiding subreport in vba
- Quartile function
- Changing field names across MDB
- Form close not correctly triggering duplicate key errors
- Setting text of a control box in VB
- Read Text File via VB
- How do I Stop a Continuous Loop?
- output patient name, date and time of appointment
- Edit existing excel file
- Dynamic Array
- Updating from an external Access table
- Error: you can't carry out this action..
- Imports and Looping
- Brainteaser
- Application.FileSearch vs. Dir
- Re: Faster way?!
- Re: Faster way?!
- QueryDef to change Criteria of a Saved Query
- IF Statement
- Accessing calling Form value
- Modifying Code and Compile Error
- Deleting table in another database
- Show Progress bar to Append Records to a table
- Query execution and saving problem
- Query with Command object ADO
- Copy Subform1 items to Subform2
- Creating formulas
- Variable in another module
- Re-linking tables from code
- create Access Reports using VB6 code
- For Nikos or Anyone: Who's In a File
- Populate Access table
- Exporting Table As Database
- Populating a table
- file browser in Access
- Connection to MDA file
- Subscript Error -Dynamic Array
- Re: runtime error 2191
- Re: runtime error 2191
- Inbox - GetSharedDefaultFolder
- updating a recordset - repost
- Date/time combobox
- Tracing connections to a linked back end mdb
- Referencing Public Constants Access 2000
- Copy/Paste from Access to Excel without Headings
- DLookup with 2 filter criteria
- compile errors?
- compile errors?
- compile errors?
- Getting the value of a dynamically modified Jet registry values
- Access 97 running on Win98 vs WinXP
- guarapari - enseada azul - apartamento
- Switching EXCEL worksheets from ACCESS VBA
- blue pills...
- Deleting linked tables
- Open form On not in list
- validating a field before update
- Selecting a backend to work with
- CommitTrans
- Re: "Method Connection of Object" Error#-2147024769
- Field cannot be updated
- String count
- RE: Open form On not in list
- Filesearch Limitations
- Transferspreadhseet
- Hidden Attribute
- Print report to PDF automatically
- Filesearch Limitations
- VBA module
- Active Directory
- FollowHyperlink Method
- emptying array contents
- Append query (VBA)
- Forcing Naming conventions
- RE: requery on form not working
- Updating a recordset
- Export to text routine
- Find out who is connected to the back-end database.
- PDF and Email
- migration to Access 2003
- search engine - embedded file
- ADO - Strange Behaviour
- Runs on one machine and not another: Error 3075
- Manual trigger query/subform
- Re: What's Wrong with my Code!
- Using Records in a table as Criteria to loop
- Importing CSV files usinf code
- liyunfeng 03
- Can't hide hidden form
- Disabling the database window w/o using access security
- Re: Spell Checking The Table?
- Requery difficulty when record added on popup form
- Problem with OutputTo
- Automate distributing a front end database
- Need Help New records update
- Import Error - Numberic Field Overflow
- Docmd.SetWarnings False but automatically answer No
- Disable Outlook Security Notification
- Enumerating Table Fields in ADO?
- using global variable in query design as a criteria
- Altering Right-click Context menus in Access XP
- Problem closing Excel
- Multi IF Statement
- Opening Access 2002 database from Word
- TransferSpreadsheet when exporting truncates data?
- Dynamic Arrays
- Re: Running Excel from Access
- Activex licenses for MSCOMCTRL
- Using Excel "Cells" function in Access Module
- Rounding double data types
- Requery Method
- Linking problem
- Add New Field to Existing ACCESS table
- Saving current record
- code to dynamically change the Database Name of Linked tables
- Forcing names of Queries
- Macro editing?
- Re: HELP anyone
- Apostrophe in field causes error
- Re: HELP anyone
- Re: Switching to Form view from design view using VBA
- Automation from Flat Text File to Access Database
- Put in a value into a table from VBA
- Automate transferring fields to an Excel template.
- Re: Question on using the Transfer spreadsheet function
- Populate login name and date/time stamp
- Start Word Macro from access
- Error 3197
- Using the Excel Trend function in Access
- Re: DCount and Parametrers
- Remote Add Record To A Open Table
- Evaluating a variable
- How Do I Assign a Workbook to an Object Variable?
- RE: MDE file security
- Re: Automation from Access 2000 to 2002
- Hard Coding Network Printer in a Module
- Verify field name
- Transaction Processing
- Re: MDE file security
- Re: MDE file security
- Using VBA to Integrate Excel/Acess 2003?
- reference a Word bookmark within a text box from Access
- VBA
- RE: Creating MDA file
- RE: Creating MDA file
- Re: Creating MDA file
- MS Access - Create a GUID for Import into SQL
- RE: Creating MDA file
- Re: Code to delete and then add a primary key
- Open Database Window
- Opening a read only file
- Problem with Replace command
- Re: Move A Recordset To Excel
- Re: Creating MDA file
- .NoMatch Compile Error
- VBA - Open Connection Error
- Help needed on an Algorithm
- Regression analysis code/ad in for Access
- Email multiple receipients
- Re: Uppercase suffix "DBF" in exported *.dbf file
- Delete and Create Relationship from Code
- copy and rename image files based on query result
- Ctrl in Access code
- Non updatable query & duped IDs
- Missing VBA screen tips
- On click events
- ADO: Err Number Listing
- The field 'tblLoanRelation.lngBorrowerNumberCnt' cannot
- Re: ERROR: DoCmd.TransferDatabase method
- Re: DCount and Parametrers
- Re: ADO vs DAO
- ADO vs DAO
- Excel Page Settings
- Re: Alternate to 'sendobject'
- Re: Programmatic table Append
- Open MDB using ADO
- Refresh Table Links
- hide all db objects
- ADO Sort Property
- DATE FUNCTIONS
- Programatically copy database
- VAT Rounding
- Re: Converting a form to an Add-in
- Formatting on a Form
- Compact & Repair on the fly...
- displaying checkboxes
- displaying a checkbox on a report
- Need some VB coding Help with routing to multiple Dbases
- How to determine if table contains no records?
- Re: Reserved Error (-1104)?!
- Re: Export as a *.dbf file
- WHERE items.ITEMCODE IN my list box
- Data Type mismatch in criteria expression
- Access hangs while processing
- Field Caption in Table
- Setting a default: Microsoft ActiveX Data Objects 2.8 Library
- Re: Compact & Repair on the fly...
- Re: Creating fields in an existing table...
- Refreshing icon path?
- Re: Simple Boolean for Open recordset
- User access
- Printing OLE Object (Word Documet)
- Le plan de maintenance ne supprime plus les anciens fichiers
- lookup loop for text inside text field ...
- Check if Excel Application is already open
- Wrap code over 2 lines
- microsoft access 2000 forms
- Re: Next Issue?!
- Invoice (Report)+ Numbers+problem
- close outlook from code
- Taoism, Normism & Declaration of Heaven on Earth2747
- [OCX] Detect If SelectedItem on ListView
- How to create index on existing field
- How to programmatically create relationship
- "Variable not defined" when specifying field type
- Replace Function in VB
- onClick error in mde when using runtime
- Re: Modifing Default Value of a Table using VBA
- Error after 380 CreateObject("MAPI.Session")
- calendar control+before update+HELP
- Bug in Access 2003 ? Error after 380 CreateObject("MAPI.Session")
- Mutiple items selected in a list box
- add ImageAvailable = True
- Re: Expression in Default Value
- Re: Next Issue?!
- Deactivate Escape Key
- Access 2000
- Relinking program Icon
- Access code printing
- fIsLoaded function
- Polling and alerting
- Access 2000 - Realtime Development - Should i stick with Access97
- Refertential Integrity
- How to trap Microsoft Access Exit event
- trouble opening access db.
- Access not recognizing Database type
- Expression in Default Value
- How to call a Module.
- Linked Table Attributes (Extra help needed)
- Opening DAO Recordsets
- Tables and look ups
- Re: Append query using RunSQL
- Re: BETWEEN search on text fields question
- Linking tables programatically
- Runtime Err 13 - Type Mismatch
- Undefined function in expression
- Transfer data
- Select into dbase
- Form: control to export
- ADO events under Access 97
- What does Nz mean in VB code
- recordset.nomatch
- converting report to RTF file
- Identifying duplicate records logged within past 30 days
- Linked Table Attributes
- connection string
- Updating field properties with VBA code
- Re: winzip 9 command line addon from VBA
- Re: Title Case
- Setting up an Auto export from an Exchange Calendar
- using New ADODB.Recordset to Find
- if function
- Reference bas files
- queries automated tasks
- difference between declare with 'new' and 'set' keyword?
- Syntax for variable control name
- "can't open any more tables"
- Het zal toch niet zijn wie ik denk dat het is?
- instr function
- counterpart
- Group By SQL statement
- Database in unexpected state
- Looping
- Exporting to multiple PDF's from 1 Access report
- New Undernet Server
- Check to see if files exists and delete it.
- Access Close Code
- mid function
- Code doesn't work but marcro does
- Need Statement Help?
- [Recordset]
- Access 97 Loop Procedure
- A97 to A2K2 coding difference
- List of File Names in a folder
- Help in VBA modules
- Opendatabase with variable
- Access 97 vs Access 2002
- Live Communications Server, Windows Messenger & MS Access 2003
- MapiSendMail without intervention
- Msgbox does not show qty from sum in query
- Auto Executing module
- Modules in access
- How do I know which was the last time a table was updated
- Missing 'current' event in reports?
- Checking to see if Directory exists and making it.
- Application ExitCode
- Arjen Jongeling, een oude bekende
- ACWZTool
- Code for counting commas in a text field?
- Re: Code for counting commas in a text field?
- [Modules] Updating forms'fields from module ?
- Two companies on the same database
- A97 vs AXO (2002)
- Quotes within quotes (repost)
- Enter a calculation for an empty column in a table
- Defining: Join props in Design Query view vs Relationships
- OLE objects
- Access specific Round Down function
- File Save As Dialog Filtering (Office 2003)
- Print directly to LPT Ports
- Method 'Range' of object'_Worksheet' failed problem
- locked recordset in a single user environment
- Method for string
- missing operator
- Runtime Error: 2342. "A RunSQL action requires an argument consist
- Re: Use ADO in Access 2000?
- overflow error
- Escape char or Quoting char
- Re: Stop loss of focus
- chip tuning
- export to Text
- Use ADO in Access 2000?
- Excel object
- Designing Databases
- SQL and Like "*"
- Budget air ticket.
- Error 3159 - Not a valid bookmark
- Code to rename tables
- Commenting Code - recordsets
- Procedure Name
- Creating a record in another database
- Not enough memory error
- Condition for buttons in MS Access
- Last Payment(s) received SQL?
- MsgBox Function
- Mail merge to MS Word
- Excel object: variable range instead of hard code
- Creating new folders using VBA
- How can I determine my Current Record?
- E-Newsletter from access
- Handling quotes in data entries
- URGENT: FILE NAMES
- Comparing Date Ranges
- How can I commit a data change without requerying the form?
- output the result to EXCEL
- Table field named "no"
- Question about other users' code
- Trying to loop through Field Names
- Splitting a colour into R G B values
- Calculated Queries & VBA functions
- Import Fields from Word Table in access record
- Replace() not working
- Setting Table Property "Description" in Code
- How to join these queries...
- How to access another table
- Copying property from one field to another
- Log delete event
- Ivalid operation 3219 using CreateProperty method
- RecordSelect Field Name
- Text in a Hyperlink Field
- Option Explicit
- Change OLE class
- Accessing UserName via VBA
- Processing XML Recordsets
- Error Codes
- chip tuning
- Event to execute once access is closed
- How can I change admin password with DAO?
- What event is for "Next Record"?
- Programmatically changing the text of a label on a report
- StartupShowDBWindow property
- Days in the month
- Populating a List box with files names
- Tool to DIFF between two versions of an Access Application
- Startement to force use of Word 97
- Calculating the WeekDay Names each month
- how to set database password with DAO
- MailItem senderName address
- Mailitem senderName address
- Mailitem senderName email address
- Active Directory Data
- Creating Index in Exported Table
- can I add the content of a memo field to an array?
- Delete Spaces
- Modify Table Input Mask
- External Name Not Defined msg during debugging a module
- Format DecimalPlaces in VB
- Scope of Db and Rst objects: General questions
- chip tuning
- SendObject error
- DAO
- Data Loss in Access 2000
- A lot of "documents" named as ~sq_
- Developing on access xp, using on access 2000
- updating two files, More details of my question
- Acess 2002 SP3, or 2003?
- chip tuning
- Linking tables programmatically
- Run Excel Macro from Access Runtime Error
- Find missing record in backups
- chip tuning
- chip tuning
- Repost - forgot the "New Question" thing...
- 2 criterias on find record
- Programmatically rename tables & fields
- enable button in tabular form
- enable/disable buttons in tabular form
- Enable/Disable button on Tabular Form
- SendObject Error
- SendObject error
- Print Relationships wizard
- AutoEmailing Reports
- Linking List box selection to a query
- Getting value from a table in VB
- Getting value from a table in VB
- Getting value from a table in VB
- Need to updates two tables
- why put #?!
- Tools/Options/Edit-Find
- On Error Resume Next will not fire
- table field descriptions
- Help with VBA code
- deleteting a table in SQL server
- Copy Excel Sheet From Access
- Using the acOLEActivate action
- Working days as a string
- VBA corruption
- DayConstants HELP!
- Re: convertion
- Cannot edit module inside a form in Access 97
- Referential integrity on two fields
- Help with Automation to Word
- Syntax Error
- Re: Record Navigation
- DecimalPlaces Property
- help! with code.
- Change Table Permissions
- relationships
- Fill ListBox with Array contents
- Aagh! Why doesn't this code work?
- Need help w/ Error function
- Transferring information between disparate connections using ADO.
- Saving recordsets and exporting to Excel
- Copy a database while open
- Change Table Field Format via Code
- Unable to trap error 2501 properly
- Recordset variable with SQL
- CreateFieldMethod
- unqiue records
- CDOSys Sample Code?
- Email confirmation msgbox
- How to Append Clone Rec?
- Access/Outlook automation
- How to insert "Manual Line Break" in querry results.
- How to insert "Manual Line Break" in querry results.
- Modify Forms in Separate MDB
- Closing QueryDef doesn't close databases
- Export Binary Data type using DoCmd.OutputTo
- RE: beginner function question
- Re: beginner function question
- emailing an individual record
- 2 String values equal each other - Case Sensitive
- FileSearch Ac97 on XP
- invalid procedure call or argument (error 5)
- Variable with rst!
- Copy calculated value to a field
- add 4 working days
- Switchboard Manager fault
- Updating form in all front-end
- Sorting Data of Access and displaying on VB GUI
- VBA Programming - HELP
- creating a table for a recordset
- Recordset field names
- Module not found -- WHEN CLICKING ON BUTTON
- Error
- Allen Brown has a very useful web site for Access Users
- ADO error: "closed or invalid connection object"
- Error messages not displayed - how do I fix?
- creating calculations
- Automate repositioning subform within parent frame
- Difference Between Modules and Macros
- dim db as database
- Importing from Oracle extract....
- Function Keys
- Re: Alternative For "Exit For"
- What is a Module
- Concatenating Column Headings
- GetRegistryString
- Getting Data from Serial Port
- Add-ins
- Determine if OLE server is done
- String function to retun >255 char len result.
- Epoch Time
- Re: Alternative For "Exit For"
- Public variables not holding value between modules
- Re: Alternative For "Exit For"
- What Data Type: String of infinite len
- Re: Microsoft Jet Engine error.
- Re: Hopefully a simple question
- Re: Updating another Access db from current db (97)
- RE: Updating another Access db from current db (97)
- VBA debug breakpoints
- Re: Programming help with Form, please!
- Slideshow in Access
- Loading comma-delimited string into array
- Copying Value to Clipboard
- E-Mail Attachments
- Re: obtaining file size
- Using Automation to Send a Microsoft Outlook Message
- SendObject, but not in "attachment" form
- Me. vs Me!
- How to check which optional arguments are present?
- Temporary data storage
- Corrupt VBA code?
- [Winsock] DownLoad Form MailServer
- Runtime error using FileDialog
- regular expression
- VBA Creating Table in Second MDB returning curious error
- Re: which is better
- Re: If then else statement help
- Dialogue Box and associated code...
- Re: If then else statement help
- Qualification Database
- Re: Qualification Database
- Re: Firing up word
- Linked/Embedded Objects
- Re: On error resume next code break
- email and Access 97 and outlook express
- Split database for more than one set of tables?
- Removing duplicate values from an array
- Disable All Shortcut Keys - In Access 97
- Re: How to do a search in code?
- Re: change query layout based on a table value
- Run At Startup - Problem
- Re: which is better
- Re: Looping through a Recordset
- Applying filters from VB
- Event Procedures in Data Access Pages
- List Control
- Avoid duplicate entries
- RE: Avoid duplicate entries
- SimpleVBA
- Re: Avoid duplicate entries
- Global Changes to MS Access Database
- Re: How to do a search in code?
- Passing Variables
- Large Files
- Re: How to do a search in code?
- Operation must use an updatable query
- How to email a hyperlink
- Re: string manipulation function
- Query Object
- Insert Word object
- Statements to customers?
- Sending Multiple Emails
- Calender Control
- URGENT - Need InStrRev / StrReverse Functions for Access 97
- openning access.application skiping autoexec macro
- XML and Access 2000
- How to hide/show a query
- re post: DoCmd.OutputTo into multiple worksheets in excel
- passing a variable to OpenReport WhereClause
- Re: textbox's controlsource and SQL statement
- Moving to the next iteration in a loop permaturely
- Where did it go? ? ?
- Re: which is better
- Main Access window title manipulation
- Launch Word, store text in Access
- Custom Navigation Buttons
- RE: Looping through a Recordset
- OverFlow error #6 using strings in Win98???
- Help! How to evaluate a math string expression into a number
- abnormal Program termination - Runtime Error
- Batch update
- SQL Server and Jet in same project
- Ref a form outside access
- HELP!!!! Report with more pages on the same paper page
- Problem converting VB Code from Access 2.0 to Access 2003
- Passing a reference to a form
- Create MDE programatically
- Declaring a variable as a Variant
- Storing NT username in database
- Example Code To verify user name and password from table.
- Change caption of a label on a form
- DoCmd.sendobject error
- Retrieve the next entry
- Code for running query and results
- Problem with a data access page and my backend
- DLookup
- Null is null
- Is it possible?
- Adding user type variable to dictionary
- Jet Database Engine
- OpenRecordset failed to open query : run time error 3061
- Scheduler on an Access 2000 Form...
- World wide air ticket 50% discount!
- Query question
- Coding for subform link
- Export to excel
- GoTo Record
- 90 day customer reminders
- Unresolvable compile error
- using a variable as a string expression
- Re: Has anyone created a Minimum Basline Standards document for MS Access database applications?
- OpenDatabase
- retrieving the value of a user-defined table field property
- File write error if file already exists
- Access with Thin Clients
- Ranges in TransferSpreadsheet
- Send files to a Newly created folder
- double quote as its own string
- Create a folder with Date
- How to Lock table using ADO (Access2000-2002)
- CurrentDb( ) Method
- How to Force Field Size
- Re: SendObject "To" parameter
- Queries using a particular table
- Invalid Qualifier
- Copy cells from Excel
- sql server/adp sync local copy
- File "save as" or "open" Dialog Box
- Changing sting case
- claim your Live Internet training session today.
- how to run a passthru query by coding?
- Start and end times
- SQL Statement - Form/SubForm
- Creeating Access MDE with ADE installed fails
- Incrementing a month value
- Run an Excel macro from Access
- Database File Size
- create pivot table code not working in Access 2002
- Re: Select then append
- Open MS Project and run a Macro in Project
- Query based on another Query in VBA
- Re: textbox's controlsource and SQL statement
- Inserting database fields into email forms
- Trap/Answer Excel Messages from Access?
- RunTime Error
- Set ByPassProperty
- IIF Limitation
- List all the printers on a combo box
- Security Warning
- Saving reports to folders
- Global Properties and Forms
- Passwording on Links to SQL Database
- search
- refresh or requery for a subform
- VB equivalent
- Re: Permission on control
- Disable macros?
- Retrieving an Access form from Word
- Chr() function
- Clearing Text In A Subform
- Run Query to create a Table in second MDB
- Re: renaming a query in VBA code
- TransferDatabase aclink on a password protected database
- Access can't display help
- Re: Select second field from combo box lookup
- List Reports and Associated Recordsource
- Removing Duplicate Records
- Re: Passwording on Links to SQL Database
- Sending E-mails through MAPI to Exchange
- Delete Recordset
- The "LEFT" statement?
- Run-time Error '40036'
- Conversion Problem
- FollowHyperLink
- Rename Excel Spreadsheet
- VBA to create new query
- Collating Order 1024 vs 1033
- What is this code for?
- Adding selected data (using code atached to cmd button from a form) to a table
- RE: Import multiple "csv" files into access tables
- Calculated field with criteria
- Help!! withdrawing materials from a stock.